21.02.2015, 01:48
Код:
forward MysqlLoadPlayer(playerid);
public MysqlLoadPlayer(playerid)
{
new rows, fields;
cache_get_data(rows, fields);
if(rows)
{
new temp[128];
cache_get_row(0, 0, temp);
PlayerInfo[playerid][UID] = strval(temp);
cache_get_row(0, 1, temp);
format(PlayerInfo[playerid][RegisterDate], 30, "%s", temp);
cache_get_row(0, 2, temp);
PlayerInfo[playerid][Level] = strval(temp);
cache_get_row(0, 3, temp);
PlayerInfo[playerid][Helper] = strval(temp);
cache_get_row(0, 4, temp);
PlayerInfo[playerid][dRank] = strval(temp);
cache_get_row(0, 5, temp);
format(PlayerInfo[playerid][Nick], 21, "%s", temp);
cache_get_row(0, 6, temp);
format(PlayerInfo[playerid][Password], 128, "%s", temp);
cache_get_row(0, 7, temp);
PlayerInfo[playerid][Kills] = strval(temp);
cache_get_row(0, 8, temp);
PlayerInfo[playerid][Deaths] = strval(temp);
cache_get_row(0, 9, temp);
PlayerInfo[playerid][Score] = strval(temp);
cache_get_row(0, 10, temp);
PlayerInfo[playerid][Money] = strval(temp);
cache_get_row(0, 11, temp);
PlayerInfo[playerid][Headshots] = strval(temp);
GivePlayerCash(playerid, PlayerInfo[playerid][Money]);
SetPlayerScore(playerid, PlayerInfo[playerid][Score]);
format(query, sizeof(query), "SELECT * FROM `Prestiges` WHERE `Nick` = '%s'", escpname(playerid));
mysql_function_query(connectionhandle, query, true, "MysqlLoadPrestige", "i", playerid);
PlayerInfo[playerid][LoggedIn] = true;
OnPlayerRequestClass(playerid, 0);
return 1;
}
Код:
SavePlayer(playerid)
{
new score, money, kills, deaths, helper, donor, hs, string2[128];
score = GetPlayerScore(playerid);
money = GetPlayerCash(playerid);
helper = PlayerInfo[playerid][Helper];
donor = PlayerInfo[playerid][dRank];
kills = PlayerInfo[playerid][Kills];
deaths = PlayerInfo[playerid][Deaths];
hs = PlayerInfo[playerid][Headshots];
new Year, Month, Day;
getdate(Year, Month, Day);
format(string2, sizeof(string2), "%02d/%02d/%d", Day, Month, Year);
format(query, sizeof(query), "UPDATE `Accounts` SET `Helper`='%d', `Donor`='%d', `Score`='%d', `Money`='%d', `Kills`='%d', `Deaths`='%d', `Headshots`='%d', `laston`='%s' WHERE `Nick`='%s'",helper, donor, score, money, kills, deaths, hs, string2, GetName(playerid));
mysql_function_query(connectionhandle, query, false, "", "");
if(templevel[playerid] < 1)
{
format(query, sizeof(query), "UPDATE `Accounts` SET `Admin`='%i' WHERE `Nick`='%s'", PlayerInfo[playerid][Level], GetName(playerid));
mysql_function_query(connectionhandle, query, false, "", "");
}
format(query, sizeof(query), "UPDATE `playeronlinetime` SET `ohours`='%d', `ominutes`='%d', `oseconds`='%d' WHERE `name`='%s'",PlayerInfo[playerid][hours],PlayerInfo[playerid][mins],PlayerInfo[playerid][secs],escpname(playerid));
mysql_function_query(connectionhandle, query, false, "", "");
format(query, sizeof(query), "UPDATE `Tag` SET `Allowed`='%d' WHERE `Nick`='%s'", PlayerInfo[playerid][Tag], GetName(playerid));
mysql_function_query(connectionhandle, query, false, "", "");
}