Question about MySQL systems. - 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: Question about MySQL systems. (/showthread.php?tid=417787)

---

Question about MySQL systems. - PaulDinam - 22.02.2013

I made many systems that loads from MySQL:
Bank System
Label System
Door System
Admin Teleport Sytem
Info System
Objects System

My question is: Is it better with MySQL loading or better inside the gamemode?
Because i'm going to make alot systems like, Dynamic ATM, Gas Station, Dealerships, houses, business, food stalls.

---

Re: Question about MySQL systems. - Neil. - 22.02.2013

It's generally more fast and efficient. Not to mention the ability to display something into php or html (Although y_ini could also do this)

---

Re: Question about MySQL systems. - xDaidal0S - 22.02.2013

MySQL is always better:faster,safer,more convinient.

---

Re: Question about MySQL systems. - PaulDinam - 22.02.2013

Another question, what's a good way to make like dynamic vehicle systems.
MySQL.. or inside gamemode just to add the vehicles?

And how can I get the vehicleid through MySQL?

---

Re: Question about MySQL systems. - Neil. - 22.02.2013

On my Vehicle system, I use MySQL. On public vehicles (Since it's public, any player may use it), I use AddStaticVehicle.

Each time a vehicle is bought, save its components, assign a unique id if you want to.

---

Re: Question about MySQL systems. - PaulDinam - 22.02.2013

I got it, I can make defines like a vehicle ID,
for example:
#define LSPD_FACTION_VEHICLE 1
VehicleInfo[vehicleid][vUniqueID] = LSPD_FACTION_VEHICLE;

Then it's just simple thanks for the idea.

---