[Levtu]

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

[Mauzen]

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.

[Snipa]

You should read this tutorial by [HiC]TheKiller

https://sampforum.blast.hk/showthread.php?tid=159785

He explains MySQL..

[Levtu]

I use that GameMode by Mlody626
http://solidfiles.com/d/5e150/

[tsubasa11]

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

[Levtu]

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.

[Levtu]

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'",

I found it in .pwn file.

[Levtu]

Refresh.

[Levtu]

Refresh.

[array13]

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