SA-MP Forums Archive
MySQL server info saving - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL server info saving (/showthread.php?tid=243723)


MySQL server info saving - Unknown123 - 24.03.2011

This code work perfect, but when i restart my GameMode (Close console then open) then the Info from Data base reseted..

so how can i fix this?


pawn Код:
new KickCounts;
new ConnectCounts;
new DisconnectCounts;

public OnPlayerConnect(playerid)
{
    UpdatePlayerConnects();
    return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    if(reason == 2)
    {
        UpdatePlayerKicks();
    }
    else
    {
        UpdatePlayerDisconnects();
        return 1;
    }
    return 1;
}

public OnPlayerCommandText(playerid, cmdtext[])
{
    dcmd(create, 6, cmdtext);
    return 0;
}

dcmd_create(playerid, params[])
{
    #pragma unused params
    #pragma unused playerid
    new queue[128];

    format(queue, sizeof(queue), "INSERT INTO `ServerInfo` (TotalKicks, TotalConnects, TotalDisconnects) VALUES (0, 0, 0)");
    mysql_query(queue);
    return 1;
}


stock UpdatePlayerKicks()
{
    KickCounts++;
    ServerInfoUpdate();
}

stock UpdatePlayerConnects()
{
    ConnectCounts++;
    ServerInfoUpdate();
}

stock UpdatePlayerDisconnects()
{
    DisconnectCounts++;
    ServerInfoUpdate();
    return 1;
}

stock ServerInfoUpdate()
{
    new Query[128];
    format(Query, sizeof(Query), "UPDATE `ServerInfo` SET TotalKicks= %d, TotalPlayerBans= %d, TotalAntiCheatBans= %d, TotalConnects= %d, TotalDisconnects= %d, LasVenturasFuelStation= %d", KickCounts, ConnectCounts, DisconnectCounts);
    mysql_query(Query);
    return 1;
}


Re: MySQL server info saving - Sascha - 24.03.2011

use
"SELECT * FROM `ServerInfo`" (query) on OnGameModeInit..
then save the data in the variables you are using... (if you don't have it already)

Re: MySQL server info saving - Unknown123 - 24.03.2011

I guess you didnt mean like this? xD it failed :S

pawn Код:
public OnGameModeInit()
{
    LoadServerInfo();
    return 1;
}

stock LoadServerInfo()
{
    new queue[16];
    format(queue, sizeof(queue), "SELECT * FROM `ServerInfo` WHERE TotalKicks= '%d', TotalConnects= '%d', TotalDisconnects= '%d'", KickCounts, ConnectCounts, DisconnectCounts);
    mysql_query(queue);
    return 1;
}