[Joaogl]

Hello,
Im trying to create my own GameMode

I Have everything in the gamemode is actually finished but i want to change the Bans, VIPs and Accounts from the usual files /users/%s.ini to a DataBase with one different table for each thing Bans accounts and vips.

Ive never used mysql in SAMP so how can i do it?

[[MG]Dimi]

I suggest you read this.
Once you read it just edit your system into MySQL. It's nothing hard.

[Joaogl]

There is any way to use MD5 on pawn i mean thats what i whant to do:

My name is joao_gl im registred in the samp server
then i just need to go to the website and type the password and users from the game becouse they are using the same databse for login.


But my passwords on SAMP are ecripted so the website cant read then there is any way to ecript the password to the website and samp can read them?

[Joaogl]

And im taking a little bit doing the MySQL codes becouse its dificult for me and becouse my accounts files have 221 things so im adding one by one to the database....

[Kirollos]

in php:

PHP код:

hash('md5', 'Your text'); // replace your text to the password written in the field || that will return md5 hashed of the text. 


[Mandrakke]

Quote:

Originally Posted by Joaogl There is any way to use MD5 on pawn i mean thats what i whant to do: My name is joao_gl im registred in the samp server then i just need to go to the website and type the password and users from the game becouse they are using the same databse for login. But my passwords on SAMP are ecripted so the website cant read then there is any way to ecript the password to the website and samp can read them?

Код:

format(Query, sizeof(Query), "SELECT * FROM users WHERE Username = '%s' AND Password = MD5('%s')", givenuser, givenpass);