SQL Tutorials? - 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: SQL Tutorials? (/showthread.php?tid=466968)

---

SQL Tutorials? - UnknownGamer - 30.09.2013

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?

---

Re: SQL Tutorials? - Konstantinos - 30.09.2013

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

---

Re: SQL Tutorials? - UnknownGamer - 30.09.2013

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

---

Re: SQL Tutorials? - Konstantinos - 30.09.2013

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

---

Re: SQL Tutorials? - UnknownGamer - 30.09.2013

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?

---

Re: SQL Tutorials? - Konstantinos - 30.09.2013

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.

---