SA-MP Forums Archive
MySQL - 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: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL (/showthread.php?tid=110183)


MySQL - Mick901 - 25.11.2009

Hey I'm working on a little roleplay styled Godfather thing (don't hate on me bro). I was wondering a few things about MySQL.

1. What is it?
2. Where can I get it?
3. A helpful tutorial (if possible) otherwise whats an easy way to learn this MySQL?

Thanks in advance

Re: MySQL - Joe Staff - 25.11.2009

I learned MySQL through checking the available functions and how they're used in common gamemode scripts on the site supplied in the MySQL plugin thread in the plugins board, and through googling the main functions of MySQL.

MySQL is a form of saving information, but instead of saving lines in a text file (like fwrite does) it saves information in tables

like this
Код:
    Column 1 - Column 2 - Column 3 
Row 1|  Name  |  Level  |  Admin  |
Row 2|  Name  |  Level  |  Admin  |
Row 3|  Name  |  Level  |  Admin  |
So instead of doing a check if a player's file exists, you check the table of the player's name already exists, then you just get the rest of the information by checking the other columns of that row.

Example: Player "Jimmy" has logged into the server. Comparing Jimmy's name with those in all of column 1(names), Jimmy's name was found on row 3, checking the levels column to get Jimmy's level, Jimmy is level 5!

That sorta thing... yeah...

Re: MySQL - mprofitt - 25.11.2009

Quote:
Originally Posted by Mick901
Hey I'm working on a little roleplay styled Godfather thing (don't hate on me bro). I was wondering a few things about MySQL.

1. What is it?
2. Where can I get it?
3. A helpful tutorial (if possible) otherwise whats an easy way to learn this MySQL?

Thanks in advance
You can get it here ... http://www.apachefriends.org/en/xampp.html.

Re: MySQL - Mick901 - 25.11.2009

I'm usually a fast learner through the ways like you said. Thanks for the help I'll be sure to maybe PM you if I've got any further questions.

Quote:
Originally Posted by Joe Staff
I learned MySQL through checking the available functions and how they're used in common gamemode scripts on the site supplied in the MySQL plugin thread in the plugins board, and through googling the main functions of MySQL.

MySQL is a form of saving information, but instead of saving lines in a text file (like fwrite does) it saves information in tables

like this
Код:
    Column 1 - Column 2 - Column 3 
Row 1|  Name  |  Level  |  Admin  |
Row 2|  Name  |  Level  |  Admin  |
Row 3|  Name  |  Level  |  Admin  |
So instead of doing a check if a player's file exists, you check the table of the player's name already exists, then you just get the rest of the information by checking the other columns of that row.

Example: Player "Jimmy" has logged into the server. Comparing Jimmy's name with those in all of column 1(names), Jimmy's name was found on row 3, checking the levels column to get Jimmy's level, Jimmy is level 5!

That sorta thing... yeah...