[Tutorial] Making a MySQL system - 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)
+---- Forum: Tutorials (https://sampforum.blast.hk/forumdisplay.php?fid=70)
+---- Thread: [Tutorial] Making a MySQL system (/showthread.php?tid=159785)

---

Re: Making a MySQL system - Type-R - 29.10.2011

Hey guys could anyone help me with the login problem? Register works, and it puts in a password in the MySQL database, but when i try to login it says the password is wrong. :/ Anyone?

---

Re: Making a MySQL system - [HiC]TheKiller - 29.10.2011

Try it again and if your problem persists, PM me.

---

Re: Making a MySQL system - juraska - 22.11.2011

Awesome tutorial, however before in tutorial you use sscanf to data loading . Why now don't use ?
And which one better sscanf or default plugin function?

---

Re: Making a MySQL system - [HiC]TheKiller - 23.11.2011

The plugin sscanf version is far better. I didn't use sscanf in this because there was hardly any variables used. If you have heaps of variables, then it's probably best to use sscanf. I didn't use it because this was simply meant to be a MySQL tutorial without adding everything else on. I was trying to show people how to do it the MySQL way.

---

Re: Making a MySQL system - spedico - 12.01.2012

If you get "incorrect password" error every time, increase the string length in the MySQL database. The hashed password is longer than the actual password.

Just pointing that out, I had that problem.

---

Re: Making a MySQL system - [HiC]TheKiller - 12.01.2012

I've increased the password length in the table by one character because the MAX_LENGTH of SHA1 is 40, I didn't count in the null character at the end.

---

Re: Making a MySQL system - ReneG - 12.06.2012

When formatting a query to update a row, why do you only have to put apostrophes( ' ) around string specifiers(%s), and not integers(%d)?

---

Re: Making a MySQL system - spedico - 12.06.2012

Because it is a string. It doesn't matter if you have a variable for it or not, strings still need the apostrophes.

e.g.
mysql_query("UPDATE Players SET Score=1337 WHERE Username='n00b' ");

---

Re: Making a MySQL system - Fnatic. - 27.06.2012

Awesome!

Good Job Bro!

---

Re: Making a MySQL system - Ryz - 03.10.2014

Server crashed! when player login

---

Re: Making a MySQL system - Rudy_ - 03.10.2014

Wow nice O_O

---

Re: Making a MySQL system - RGOimpact - 25.11.2014

Oracle please!

---

AW: Making a MySQL system - Mellnik - 25.11.2014

Outdated. This thread should be locked.

---

Re: Making a MySQL system - MD5 - 15.12.2014

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /cnrsf/public_html/ucp1/login.php on line 44

Not sure what's going on?

---

Re: Making a MySQL system - cuc123 - 08.03.2015

Download rezult?

---

[IGNORE - SourceySam - 27.03.2015

[DELETED]

---

Re: Making a MySQL system - SourceySam - 28.03.2015

Honestly one of the best tutorials I have read. I am constantly using this thread to help me when I get stuck with a issue with an MySQL database.

---

Re: Making a MySQL system - naveen - 13.04.2015

can any one teach me in easier way?

---

Re: Making a MySQL system - fuckingcruse - 31.05.2015

Its the easiest way.. and awesome tutorial.. .

---

Re: Making a MySQL system - Battlezone - 04.06.2015

I don't like the MySQL part very much (codes could be optimized), however I loved the PHP part, + for you

---