[WhiteAngels]

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

[DTV]

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

[WhiteAngels]

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?

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

[WhiteAngels]

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

[Konstantinos]

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