MySQL R41 help! - Printable Version

MySQL R41 help! - 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 R41 help! (/showthread.php?tid=619689)

MySQL R41 help! - WhiteAngels - 21.10.2016

could someone tell me how MySQL R41 works, because the old version had old functions and there's no thread about MySQL R41. I'm new in MySQL so that's why when i learn MySQL from tutorial (sub forum) which is using an old version (R33+, R39) i'm still confused, and of course when i try the latest version (R41) i got a lot of errors, so
i hope someone could help me

anyway sorry
my english is so bad

gonna give +rep

Re: MySQL R41 help! - DTV - 21.10.2016

Click here for the wiki of the latest MySQL version.
Click here for updating your script to the latest version of MySQL.

Re: MySQL R41 help! - WhiteAngels - 26.10.2016

Quote:

Originally Posted by DTV

Click here for the wiki of the latest MySQL version.
Click here for updating your script to the latest version of MySQL.

still confused by wiki because there is only one line for each functions
could you give me an example?

Re: MySQL R41 help! - Konstantinos - 26.10.2016

Honestly, even that one line is enough in most cases to get an idea for what is used and how. The very basic concept is to understand how to use threaded queries (specifying a callback and call the cache functions there) and of course just play around with it (write a register/login system) to practice.

Here's an example script for R40+: https://raw.githubusercontent.com/pB...stem-cache.pwn
Feel free to ask if you don't understand something.

Re: MySQL R41 help! - WhiteAngels - 26.10.2016

Quote:

Originally Posted by Konstantinos

Honestly, even that one line is enough in most cases to get an idea for what is used and how. The very basic concept is to understand how to use threaded queries (specifying a callback and call the cache functions there) and of course just play around with it (write a register/login system) to practice.

Here's an example script for R40+: https://raw.githubusercontent.com/pB...stem-cache.pwn
Feel free to ask if you don't understand something.

Thank you so much

and now. How to add like "Admin Level, Gender,etc.. to the sql"
and could you explain how "Integer Types" works in MySQL? Thank you

Re: MySQL R41 help! - Konstantinos - 27.10.2016

If you use tools such phpMyAdmin: http://i.imgur.com/X0yk5eZ.png
You can still execute queries if you prefer:

pawn Код:

ALTER TABLE players ADD COLUMN `admin` tinyint(1) unsigned NOT NULL DEFAULT '0';

for admin levels that do not exceed 255.

Here's the integer lengths: http://dev.mysql.com/doc/refman/5.7/...ger-types.html