MySQL For the first Time - Printable Version

MySQL For the first Time - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL For the first Time (/showthread.php?tid=351082)

MySQL For the first Time - Joaogl - 14.06.2012

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?

Re: MySQL For the first Time - [MG]Dimi - 14.06.2012

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

Re: MySQL For the first Time - Joaogl - 15.06.2012

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?

Re: MySQL For the first Time - Joaogl - 15.06.2012

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....

Re: MySQL For the first Time - Kirollos - 15.06.2012

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.

Re: MySQL For the first Time - Mandrakke - 15.06.2012

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);