DataBase MySQL - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: DataBase MySQL (/showthread.php?tid=272555)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: DataBase MySQL (/showthread.php?tid=272555)
DataBase MySQL - Levtu - 28.07.2011
Hi.
Somedays ago I bought server on OS Linux. SAMP 0.3c R3
I have 1 problem. When I set DB settings in .ini file, server rightly connect with Database, but accounts and stats don't save up.
Someone tell me i must create tables in my DB, through PHPMyAdmin.
That's a question: What tables i must create?
Sorry for my English
Re: DataBase MySQL - Mauzen - 28.07.2011
This depends on the gamemode/save script you are using. It should be explained in the topic of that script what you have to do to set it up.
Re: DataBase MySQL - Snipa - 29.07.2011
You should read this tutorial by [HiC]TheKiller
https://sampforum.blast.hk/showthread.php?tid=159785
He explains MySQL..
Re: DataBase MySQL - Levtu - 29.07.2011
I use that GameMode by Mlody626
http://solidfiles.com/d/5e150/
Re: DataBase MySQL - tsubasa11 - 29.07.2011
Man, i don't understand why you don't ask that person, who sold for you the gamemode...
I think he can help you , and more , he need to be liable for the gamemode...
I suggest zou to ask him, beacuse it's hard to look around at all of gamemode for the tables and for all the fields in the table, mostly if you are not an advenced scripter...
It's just a suggetion, if you want you can ignor it
Re: DataBase MySQL - Levtu - 29.07.2011
Author who do that GameMode, don't sold me it.
Other person publish his GameMode in GTAOnline.pl
I don't know him, and I have no contact with him.
It's really important for me, because my server still works on data save File.
Re: DataBase MySQL - Levtu - 29.07.2011
That's tables?
Код:
new tmp[350]; format(tmp, sizeof(tmp), "UPDATE `Players` SET `Pass` = '%s',`Score` = '%d',`Bank` = '%d',`Bounty` = '%d',`Kills` = '%d',`Deaths` = '%d',`Suicides` = '%d',`Used_Score` = '%d',`Skin` = '%d',`Row_Kills` = '%d',`Arena` = '%d',`Drag` = '%d',`Time` = '%d' WHERE `Nick` = '%s'",
Re: DataBase MySQL - Levtu - 30.07.2011
Refresh.
Re: DataBase MySQL - Levtu - 31.07.2011
Refresh.
Re: DataBase MySQL - array13 - 01.08.2011
update your linux OS
centOS : yum install update
Debian: apt-get update
after update installed:
centOS: yum install mysql mysql-server mysql-devel
Debian: sudo aptitude install install mysql-server mysql-client libmysqlclient15-dev