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=243697)


MySQL server info saving? - Unknown123 - 24.03.2011

Is it possible to save server infos in MySQL? like...

TotalKicks: X
TotalConnects: X

pawn Код:
Serverkicks ++;
ServerConnects ++;
and how to read from them?
pawn Код:
new string[35];
format(string,sizeof(string),"There has been %d kiced players on this server",ServerKicks);
SendClientMessage(playerid,0xFFFFFAA,string);
if possible... HOW? soz caps

Re: MySQL server info saving? - THE_KNOWN - 24.03.2011

make a var that store the players kicks and stuff. when he gets kicked just do

kick[playerid]=kick[playerid]+1;

and then save it to mysql. so your just loading the value when ever he loggs in and then increasing it when he gets kicked and the save

Re: MySQL server info saving? - Unknown123 - 24.03.2011

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;
}


Re: MySQL server info saving? - THE_KNOWN - 24.03.2011

first query fix:
format(queue, sizeof(queue), "INSERT INTO `ServerInfo` (TotalKicks, TotalConnects, TotalDisconnects) VALUES (0, 0, 0)");

second:

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

Re: MySQL server info saving? - THE_KNOWN - 24.03.2011

Код:
new tkicks;
new tcons;
new tdiscons;

public OnPlayerConnect(playerid)
{
	tcons++;
	new q[128];
	format(q,128,"UPDATE `setverinfo` SET totalkicks=%d, totalconnects=%d, totaldiscons=%d",tkicks,tcons,tdiscons);
	mysql_query(q);
	return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
	tdiscons++;
	if(reason == 2) tkicks++;
	new q[128];
	format(q,128,"UPDATE `setverinfo` SET totalkicks=%d, totalconnects=%d, totaldiscons=%d",tkicks,tcons,tdiscons);
	mysql_query(q);
	return 1;
}

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;
}
proper way todo it

Re: MySQL server info saving? - Unknown123 - 24.03.2011

Quote:
Originally Posted by THE_KNOWN
Посмотреть сообщение
Код:
new tkicks;
new tcons;
new tdiscons;

public OnPlayerConnect(playerid)
{
	tcons++;
	new q[128];
	format(q,128,"UPDATE `setverinfo` SET totalkicks=%d, totalconnects=%d, totaldiscons=%d",tkicks,tcons,tdiscons);
	mysql_query(q);
	return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
	tdiscons++;
	if(reason == 2) tkicks++;
	new q[128];
	format(q,128,"UPDATE `setverinfo` SET totalkicks=%d, totalconnects=%d, totaldiscons=%d",tkicks,tcons,tdiscons);
	mysql_query(q);
	return 1;
}

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;
}
proper way todo it
Hmm it dont work :S

and if i get it to work... how to read from it?

Edit: i got it to work.. but how to read from the Database?
pawn Код:
new string[35];
format(string,sizeof(string),"Total connects of this server is %s",TotalConnects);
SendClientMessage(playerid,0xFFFFFAA,string);

//??/??/