MySQL server info saving?
#3

Something like:
ehh

btw im not used to use MySQL and.. Y_ini wont save the info... dini wont either

pawn Код:
#include <a_samp>
#include <mysql>

#define dcmd(%1,%2,%3) if (!strcmp((%3)[1], #%1, true, (%2)) && ((((%3)[(%2) + 1] == '\0') && (dcmd_%1(playerid, ""))) || (((%3)[(%2) + 1] == ' ') && (dcmd_%1(playerid, (%3)[(%2) + 2]))))) return 1

enum ServerStats
{
    TotalKicks,
    TotalConnects,
    TotalDisconnects
}
new ServerData[MAX_PLAYERS][ServerStats];

public OnPlayerConnect(playerid)
{
    ServerData[playerid][TotalConnects] ++;
    UpdateConnects(playerid);
    return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    ServerData[playerid][TotalDisconnects] ++;
    return 1;
}




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

dcmd_create(playerid, params[])
{
    #pragma unused params
    #pragma unused playerid
    new queue[200];
   
    format(queue, sizeof(queue), "INSERT INTO `ServerInfo` (TotalKicks, TotalConnects, TotalDisconnects) VALUES ('0', '0, '0')");
    mysql_query(queue);
    return 1;
}

stock UpdateConnects(playerid)
{
    new queue[200];

    format(queue, sizeof(queue), "UPDATE `ServerInfo` SET TotalConnects= '%d' WHERE TotalConnects= '%d'", ServerData[playerid][TotalConnects]);
    mysql_query(queue);

    mysql_free_result();
    return 1;
}
Reply


Messages In This Thread
MySQL server info saving? - by Unknown123 - 24.03.2011, 10:38
Re: MySQL server info saving? - by THE_KNOWN - 24.03.2011, 10:41
Re: MySQL server info saving? - by Unknown123 - 24.03.2011, 11:21
Re: MySQL server info saving? - by THE_KNOWN - 24.03.2011, 11:31
Re: MySQL server info saving? - by THE_KNOWN - 24.03.2011, 11:44
Re: MySQL server info saving? - by Unknown123 - 24.03.2011, 12:15

Forum Jump:


Users browsing this thread: 1 Guest(s)