Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted as Plain Text by Hoss ( 13 years ago )
SavePlayer(playerid)
{
if(pInfo[playerid][Logged] == 1)
{
new query[1000];
format(query, 1000, "UPDATE `"#playerdata"` SET `donor`='%d', `admin`='%d', `score`='%d', `money`='%d', `kills`='%d', `deaths`='%d',`Rank`='%d',`Respect`='%d',`DonatorPoints`='%d',`Donated`='%d'",query,pInfo[playerid][dLevel], pInfo[playerid][pAdmin], pInfo[playerid][Score], pInfo[playerid][pMoney], pInfo[playerid][pKills], pInfo[playerid][pDeaths],pInfo[playerid][pRank],pInfo[playerid][pRespect],pInfo[playerid][pDonatorPoints],pInfo[playerid][pDonated]);
printf("Query 1 Printed");
format(query, 1000, "%s, `Turfs`='%d',`WeaponTrucks`='%d'", query, pInfo[playerid][pTurfs],pInfo[playerid][pWeaponTrucks]);
printf("Query 2 Printed");
format(query, 1000, "%s, `Action1`='%d', `Action2`='%d',`Action3`='%d',`Action4`='%d',`Action5`='%d',`Action6`='%d',`Action7`='%d',`Action8`='%d',`Action9`='%d',`Action10`='%d'", query, pInfo[playerid][Action1],pInfo[playerid][Action2],pInfo[playerid][Action3],pInfo[playerid][Action4],pInfo[playerid][Action5],pInfo[playerid][Action6],pInfo[playerid][Action7],pInfo[playerid][Action8],pInfo[playerid][Action9],pInfo[playerid][Action10]);
printf("Query 3 Printed");
format(query, 1000, "%s, `Seconds`='%d',`Minutes`='%d',`Hours`='%d',`Week`='%d',`TotalHours`='%d',`TotalMins`=%d, `helpers`='%d', `online`='0' WHERE `nick`='%s' LIMIT 1", query, pInfo[playerid][Sec],pInfo[playerid][Min],pInfo[playerid][Hour],pInfo[playerid][Week],pInfo[playerid][TotalHours],pInfo[playerid][TotalMins],pInfo[playerid][Helpers], pInfo[playerid][Nick]);
mysql_query(query);
}
}
stock MySQL_Login(playerid)
{
format(Query, SOQ, "SELECT * FROM `playerdata` WHERE `nick` COLLATE latin1_general_cs = '%s' LIMIT 1", pInfo[playerid][Nick]);
mysql_query(Query);
mysql_store_result();
while(mysql_fetch_row(Query))
{
mysql_fetch_int("id", pInfo[playerid][ID]);
mysql_fetch_int("donor", pInfo[playerid][dLevel]);
mysql_fetch_int("admin", pInfo[playerid][pAdmin]);
mysql_fetch_int("score", pInfo[playerid][Score]); SetPlayerScore(playerid, pInfo[playerid][Score]);
mysql_fetch_int("money", pInfo[playerid][pMoney]); GivePlayerMoney(playerid, pInfo[playerid][pMoney]);
mysql_fetch_int("kills", pInfo[playerid][pKills]);
mysql_fetch_int("deaths", pInfo[playerid][pDeaths]);
mysql_fetch_int("Rank", pInfo[playerid][pRank]);
mysql_fetch_int("Respect", pInfo[playerid][pRespect]);
mysql_fetch_int("DonatorPoints", pInfo[playerid][pDonatorPoints]);
mysql_fetch_int("Donated", pInfo[playerid][pDonated]);
mysql_fetch_int("Turfs", pInfo[playerid][pTurfs]);
mysql_fetch_int("WeaponTrucks", pInfo[playerid][pWeaponTrucks]);
mysql_fetch_int("Action1", pInfo[playerid][Action1]);
mysql_fetch_int("Action2", pInfo[playerid][Action2]);
mysql_fetch_int("Action3", pInfo[playerid][Action3]);
mysql_fetch_int("Action4", pInfo[playerid][Action4]);
mysql_fetch_int("Action5", pInfo[playerid][Action5]);
mysql_fetch_int("Action6", pInfo[playerid][Action6]);
mysql_fetch_int("Action7", pInfo[playerid][Action7]);
mysql_fetch_int("Action8", pInfo[playerid][Action8]);
mysql_fetch_int("Action9", pInfo[playerid][Action9]);
mysql_fetch_int("Action10", pInfo[playerid][Action10]);
mysql_fetch_int("Seconds", pInfo[playerid][Sec]);
mysql_fetch_int("Minutes", pInfo[playerid][Min]);
mysql_fetch_int("Hours", pInfo[playerid][Hour]);
mysql_fetch_int("Week", pInfo[playerid][Week]);
mysql_fetch_int("TotalHours", pInfo[playerid][TotalHours]);
mysql_fetch_int("TotalMins", pInfo[playerid][TotalMins]);
mysql_fetch_int("helpers", pInfo[playerid][Helpers]);
}
mysql_free_result();
format(Query, SOQ, "UPDATE `playerdata` SET `ip` = '%s', `laston` = UTC_TIMESTAMP(), `online` = 1 WHERE `id` = '%d' LIMIT 1", pInfo[playerid][IP], pInfo[playerid][ID]);
mysql_query(Query);
SendClientMessage(playerid, -1, "You have been logged in!");
TimeTimer = SetTimerEx("TimeOnServer", 1000, 1, "i", playerid);
pInfo[playerid][Logged] = 1;
//SendMessageToRAdmins(red, "Player has successfully logged in!");
return 1;
}
Revise this Paste