HostName: Brazil Death Match Ultimate Gang War
Address:  191.252.204.45:7777
Players:  2 / 100
Ping:    17
Mode:    UGW 8.3b PT-BR
Language: Portugues

Hi everyone,

Hi, I’m trying to make a UCP system for my SA-MP roleplay server, but I’m really new to this, and I’m stuck. My idea is that players will register on a website outside the game, and the website will save their data (like username and email) into a MySQL database. When they join the game, I want the server to get that data (like their email) and show it in something like a dialog or a
/stats command. I don’t really understand how to make the server read the data from the database and display it in-game. Can someone explain how to do this step by step?

Here’s what I’m trying to achieve:

1. Retrieve Data: How can I fetch the player’s email from the MySQL database when they log in?
   
2. Display Data: How do I show the retrieved email in a dialog or a command (like/stats)?
   
3. Syncing: What’s the best way to ensure that the data in the database matches the player in-game?
   

So I feel very stupid right now but can somebody help me with this problem.

I'm making a loop which loads the mysql database data for my admin system.

Hi all,

I think most of us are in the Discord server already, but thought I would remind everyone on the forums that it exists just in case :)

Our Discord server has:

👥 Almost 35,000 users 
- A good combination of veteran SA-MP players and new players - find old friends who you used to play with, and make new ones!
- Players from all different servers and all different countries - lots of old players from popular servers!
- SA-related channels
- Casual/off-topic chat channels
- VIP channels
- Channels to showcase your creations (both SA and non-SA!)
- open.mp development log channel
- Server advertisements
- Dedicated channels for each spoken language to meet people from your own countries

📰 The most up-to-date information on open.mp
- Announcements
- News and updates
- Releases
- Development log
- Real-time feedback from open.mp partners

🆘 Support channels
- open.mp support
- SA-MP support
- GTA SA support
- Pawn/scripting support
- Other software dev support
- Tech support

Come and hang out! :)

http://discord.com/samp

I have the game purchased on steam and I want you to count the hours played on open mp.

Tengo el juego comprado en steam y quiero que me cuente las horas jugadas en open mp.

Started out with some actors that had the ability to talk back to the player like in this video:
[Video: https://www.youtube.com/watch?v=ZoWpUR5I7V8]

Now, in the latest update, the actors can also use commands such as /me and /do to roleplay, and they can also interact with other actors. It needs more work to be stable, but for now I'm using it to make the login/registration screen more interesting.

[Video: https://www.youtube.com/watch?v=RMHRkCpbA9A]

Right now, it's still a work in progress, I'm not confident enough to let players interact with it because it is still somewhat unstable and can break down and become gibberish (even now it still isn't always perfect), but if I can get this to a more stable state, I could see so many interesting possibilities for interactions with actors/NPCs, especially in a roleplay setting. Imagine going to the store and literally telling the actor what you want, or going to a car dealership and talking to the salesman, or even needing to do an actual interview for a job, and the actor can hire you based on that interview. So many possibilities.

This filterscript loads vehicles from files and streams them. It loads vehicle data from files, then creates vehicles when they are in range of a player and destroys them when no player is in range. It also updates vehicle data when they are spawned.
GitHub Link: https://github.com/Kingvornex/SA-MP-Open...lterScript

So, my main suggestion was that it would be very nice to be able to toggle the HUD (cash, health, weapon, minimap, etc). Underground Multiplayer has done this in the past as an extension to SA-MP as well.

But then I was thinking, while we're at it, why not look into all the changes that Underground MP did? Other changes like being able to give cars any color you want are pretty amazing too. Has there ever been any communication from the Open MP team with the former Underground MP dev team about this?

It would/could break compatibility with SA-MP clients, but this could be a config setting like 0.3.7 compatibility, right?

I've posted some videos and photos of this in the past, but after many years I've picked up on this project again for my upcoming roleplaying server.

Current history so far:
V1: Was written in PAWN, world generation took 30 - 60 minutes and during that time you couldn't join the server.
V2: Was written in .NET using spaghetti code, world generation took roughly 15 minutes and during that time you could play on the server and see it happen in front of you, see Young Fir Forest & Dense Fir Forest video.
V3: Fully refactored the code in .NET and made it organized, clean and now partially supports multi-threading. World generation now takes roughly 100 seconds, does give a bit of a lag spike on the server while it is generating.

Little disclaimer: This is not yet actually for the entire world. Red County and Whetstone are near fully implemented, Flint County and Bone County still have to be done. I also have plans to add way more biomes in the future, and even underwater biomes, all of which will increase the generation time.

[Video: https://www.youtube.com/watch?v=fF0cSdKCPnw]
[Video: https://www.youtube.com/watch?v=0Q5gp7N4M0M]
[Video: https://www.youtube.com/watch?v=KvREbFi6sb0]
[Video: https://www.youtube.com/watch?v=c5YGdkrZHsE]

I also have plans for a V4 in the future. I believe I can get the world generation time down even more, but for now I am satisfied and working on other more important features for the server. The biome generator is not just meant to be a gimmick but have an actual purpose for RPG elements like crafting, gathering, hunting, woodcutting, mining, etc.