[Oshery]

Can anyone please help me with my server? i'm using mysql connection but when any user connect to server i see mysql.log, [21:27:57] [WARNING] cache_get_row_count - no active cache
[21:27:57] [WARNING] cache_get_row_count - no active cache
[21:28:08] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Score")
[21:28:08] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Cash")
[21:28:08] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Level")
[21:28:08] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Coins")
[21:28:08] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Kills")
[21:28:08] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Deaths")
[21:28:08] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Vip")
[21:28:08] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Kicks")
[21:28:08] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Bans")
[21:28:08] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Jails")
[21:28:08] [WARNING] CMySQLResult::GetRowDataByName - field not found ("license")
[21:28:08] [WARNING] CMySQLResult::GetRowData - invalid row ('1') or field index ('0')

And the user isnt begin saved after deisconnecting, can anyone please help me solving it out?
skype? or any other social network?

[BiosMarcel]

We need code, otherwise we can't help. You shouldn't come here and expect external help (skype and such).

[saffierr]

Show us your OnPlayerDisconnect for the saving part.
For your errors, show us the appropriate related code.

[Oshery]

i have to create Accounts table but i dont know how to do it, ive just created colums or however it is names.
i dont know what i should show you, the mainly reason why i need external help..

[saffierr]

I just told you, what to show... "OnPlayerDisconnect" and the code of the errors.

[Oshery]

Here the OnPlayerDisconnect code,

Код:

public OnPlayerDisconnect(playerid, reason)
{

PlayersOnline--;
//StealingA69Prot[playerid] = 0;  //prototype
//++++++++++++++++++++SQL+++++++++++++++++
if(Logged[playerid] == 1 && buggy[playerid] == 0)
{
        //If the player disconnects before registering,
        //we want to make sure it doesn't try update
        //so we check if the player is logged in.
        PlayerInfo[playerid][Level] = TempAdmin[playerid];
        new score = GetPlayerScore(playerid); //Gets players score
        new money = GetPlayerMoney(playerid); //Gets players money
        new query[200], pname[24]; //Creates the variables
        GetPlayerName(playerid, pname, 24); //Gets the players name.
       	new h, m, s; TotalGameTime(playerid, h, m, s);
        format(query, sizeof(query), "UPDATE Accounts SET Score=%d, Cash=%d WHERE Name='%s'", score, money, pname);
        mysql_query(connection, query);
        format(query, sizeof(query), "UPDATE Accounts SET Level=%d, Coins=%d, Kills=%d, Deaths=%d, Vip=%d, Kicks=%d, Bans=%d, Jails=%d, license=%d WHERE Name='%s'", PlayerInfo[playerid][Level], PlayerInfo[playerid][Helper], PlayerInfo[playerid][Kills], PlayerInfo[playerid][Deaths], PlayerInfo[playerid][dRank], h, m, s, License[playerid], pname);
        mysql_query(connection, query);
        //No need to store a result for a update string
}

And here is the code of the create table Accounts which is giving me the mysql errors above^,

Код:

 mysql_query(connection, "CREATE TABLE IF NOT EXISTS Accounts(Name VARCHAR(24), password VARCHAR(40), IP VARCHAR(16), Cash INT(20), Score INT(30), Level INT(10), Kills INT(20), Deaths INT(20), viplevel INT(10))");

I don't know how to set it so please tell me if you know about it..

[Oshery]

bump//

[AmigaBlizzard]

That code isn't related to your problem.

Your problem lies in OnPlayerConnect, where you LOAD the data, not saving in OnPlayerDisconnect.

Show us OnPlayerConnect, or whatever you use (callback or function after logging in) to load your data when a player connects to your server.