MySQL Question [+REP] - 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 Question [+REP] (/showthread.php?tid=318997)

---

MySQL Question [+REP] - SpankMe2 - 17.02.2012

Hey,

I was looking through some Tutorials and the ones I've looked at loads the infromation when needed, Is it okay to just load everything so its all in the enums etc. Then upload te new ones when they leave. So eeverthing for the players is only loaded and unloaded once?.

---

Re: MySQL Question [+REP] - KingHual - 17.02.2012

Yes, that's the best solution - Load data to player variables on connect, edit them on the run (while the player is ingame) and save the data from the variables to MySQL when a player disconnects.

---

Re: MySQL Question [+REP] - SpankMe2 - 17.02.2012

How would I select EVERYTHING then as in about 70 values per player? THanks

---

Re: MySQL Question [+REP] - KingHual - 17.02.2012

"Select * WHERE `Name` = 'PlayerName'"

---