[UnknownGamer]

Hi People,

I was looking around on the search, for the best SQL, for a Roleplay GM, that's currently using:

/* Script Includes */
#include <a_samp>
#include <OPVD>
#include <foreach>
#include <fuckcleo>
#include <audio>
#include <streamer>
#include <YSI/y_ini>
#include <sscanf2>
#include <zcmd>

Which one do you think is best? I can't find a tutorial that explains, how SQL saves data to the tables, fields, etc. And how it loads, also including the plugin.

Could someone forward me in the right direction please? (I know BlueG is a choice, but can't seem to find his plugin anywhere on search, that explains what's what, and how it loads/saves, etc).

Thanks in advance.

+REP to anyone how can forward me a link, that explains how SA-MP loads/connects/saves data, etc.

Edit: also another note; Does MYSQL work with Y_COMMANDS? I'm thinking of switching ZCMD, with Y_CMDS.

Edit: Looking around, is it possible, that SSCANF2 can load data from a MYSQL Table? using; if(!sscanf - then just using the params such as s< etc?

[Konstantinos]

BlueG's MySQL Plugin (Thread): https://sampforum.blast.hk/showthread.php?tid=56564

MySQL R33 version: https://code.******.com/p/sa-mp-mysq...downloads/list

Tutorial (threaded queries): https://sampforum.blast.hk/showthread.php?tid=337810

Tutorial (ORM): https://sampforum.blast.hk/showthread.php?tid=461766

Gamemode (basic register/login): https://sampforum.blast.hk/showthread.php?tid=390428

[UnknownGamer]

Quote:

Originally Posted by Konstantinos BlueG's MySQL Plugin (Thread): https://sampforum.blast.hk/showthread.php?tid=56564 MySQL R33 version: https://code.******.com/p/sa-mp-mysq...downloads/list Tutorial (threaded queries): https://sampforum.blast.hk/showthread.php?tid=337810 Tutorial (ORM): https://sampforum.blast.hk/showthread.php?tid=461766 Gamemode (basic register/login): https://sampforum.blast.hk/showthread.php?tid=390428

Cheers buddy! - Is mySQL, easier than SQLITE? or other way round?

[Konstantinos]

Quote:

Originally Posted by UnknownGamer Edit: also another note; Does MYSQL work with Y_COMMANDS? I'm thinking of switching ZCMD, with Y_CMDS. Edit: Looking around, is it possible, that SSCANF2 can load data from a MYSQL Table? using; if(!sscanf - then just using the params such as s< etc?

- Yes, it does.

- You could use sscanf before (R6) but threaded queries do not need it.

Quote:

Originally Posted by UnknownGamer Cheers buddy! - Is mySQL, easier than SQLITE? or other way round?

In my opinion, both are same on the level of difficulty (even though; none of them are difficult). However, I recommend MySQL (much faster).

[UnknownGamer]

Quote:

Originally Posted by Konstantinos - Yes, it does. - You could use sscanf before (R6) but threaded queries do not need it. In my opinion, both are same on the level of difficulty (even though; none of them are difficult). However, I recommend MySQL (much faster).

Looking through them links, they don't explain how MYSQL loads/saves.

I know about the dBConnection, stuff. Is there any tut's that really explain and give example querys? that load and save data?

[Konstantinos]

AndreT's tutorial about Using BlueG's MySQL plugin R7 and newer (with cache) explains the functions are used for threaded queries.

You need to make a callback when you use SELECT clause; however, it's not necessary when you use, UPDATE, INSERT INTO, DELETE clauses.