PHP код:
stock SavePlayer(playerid)
{
static query[5000];
query = "UPDATE `accounts` SET ";
format(query, sizeof(query), "%sLvL=%d,", query, Player[playerid][pLevel]);
format(query, sizeof(query), "%sAdmin=%d,", query, Player[playerid][pAdmin]);
format(query, sizeof(query), "%sHelper=%d,", query, Player[playerid][pHelper]);
format(query, sizeof(query), "%spGuardCL=%d,", query, Player[playerid][pGuardCL]);
format(query, sizeof(query), "%sVip=%d,", query, Player[playerid][pVip]);
format(query, sizeof(query), "%sVipTime=%d,", query, Player[playerid][pVipTime]);
format(query, sizeof(query), "%sConnectTime=%d,", query, Player[playerid][pConnectTime]);
format(query, sizeof(query), "%sSex=%d,", query, Player[playerid][pSex]);
format(query, sizeof(query), "%sExp=%d,", query, Player[playerid][pExp]);
format(query, sizeof(query), "%sMoney=%d,", query, Player[playerid][pMoney]);
format(query, sizeof(query), "%sBankMoney=%d,", query, Player[playerid][pBankMoney]);
format(query, sizeof(query), "%sJailed=%d,", query, Player[playerid][pJailed]);
format(query, sizeof(query), "%sJailTime=%d,", query, Player[playerid][pJailTime]);
format(query, sizeof(query), "%sLeader=%d,", query, Player[playerid][pLeader]);
format(query, sizeof(query), "%sMember=%d,", query, Player[playerid][pMember]);
format(query, sizeof(query), "%sRank=%d,", query, Player[playerid][pRank]);
format(query, sizeof(query), "%sSkin=%d,", query, Player[playerid][pSkin]);
format(query, sizeof(query), "%sMutedTime=%d,", query, Player[playerid][pMutedTime]);
format(query, sizeof(query), "%sFMutedTime=%d,", query, Player[playerid][pFMutedTime]);
format(query, sizeof(query), "%sHealth=%f,", query, Player[playerid][pHealth]);
format(query, sizeof(query), "%sTut=%d,", query, Player[playerid][pTut]);
format(query, sizeof(query), "%sWarns=%d,", query, Player[playerid][pWarns]);
format(query, sizeof(query), "%sFWarns=%d,", query, Player[playerid][pFWarns]);
format(query, sizeof(query), "%sBlocks=%d,", query, Player[playerid][pBlocks]);
format(query, sizeof(query), "%sDonateMoney=%d,", query, Player[playerid][pDonateMoney]);
format(query, sizeof(query), "%sALLDonateMoney=%d,", query, Player[playerid][pALLDonateMoney]);
format(query, sizeof(query), "%sStylef=%d,", query, Player[playerid][pStylef]);
format(query, sizeof(query), "%sPiss=%d,", query, Player[playerid][pPiss]);
format(query, sizeof(query), "%sHunger=%d,", query, Player[playerid][pHunger]);
format(query, sizeof(query), "%sPit=%d,", query, Player[playerid][pPit]);
format(query, sizeof(query), "%sSleep=%d,", query, Player[playerid][pSleep]);
format(query, sizeof(query), "%sRadiation=%d,", query, Player[playerid][pRadiation]);
format(query, sizeof(query), "%sVirus=%d,", query, Player[playerid][pVirus]);
format(query, sizeof(query), "%sLastOnline=%d,", query, Player[playerid][pLastOnline]);
format(query, sizeof(query), "%sRegOnline=%d,", query, Player[playerid][pRegOnline]);
format(query, sizeof(query), "%sVampire=%d,", query, Player[playerid][pVampire]);
format(query, sizeof(query), "%sGunSkill_1=%d,", query, Player[playerid][pGunSkill][0]);
format(query, sizeof(query), "%sGunSkill_2=%d,", query, Player[playerid][pGunSkill][1]);
format(query, sizeof(query), "%sGunSkill_3=%d,", query, Player[playerid][pGunSkill][2]);
format(query, sizeof(query), "%sGunSkill_4=%d,", query, Player[playerid][pGunSkill][3]);
format(query, sizeof(query), "%sGunSkill_5=%d,", query, Player[playerid][pGunSkill][4]);
format(query, sizeof(query), "%sGunSkill_6=%d,", query, Player[playerid][pGunSkill][5]);
format(query, sizeof(query), "%sSpawn=%d,", query, Player[playerid][pSpawn]);
format(query, sizeof(query), "%sPosX=%f,", query, Player[playerid][pPosX]);
format(query, sizeof(query), "%sPosY=%f,", query, Player[playerid][pPosY]);
format(query, sizeof(query), "%sPosZ=%f,", query, Player[playerid][pPosZ]);
format(query, sizeof(query), "%sPosA=%f,", query, Player[playerid][pPosA]);
format(query, sizeof(query), "%sSpawnExit=%d,", query, Player[playerid][pSpawnExit]);
format(query, sizeof(query), "%sSlots=%d,", query, Player[playerid][pSlots]);
format(query, sizeof(query), "%sPack=%d,", query, Player[playerid][pPack]);
format(query, sizeof(query), "%sPupgrade=%d,", query, Player[playerid][gPupgrade]);
format(query, sizeof(query), "%sMask=%d,", query, Player[playerid][pMask]);
format(query, sizeof(query), "%sDiverSkill=%d,", query, Player[playerid][pDiverSkill]);
format(query, sizeof(query), "%sGuardCode=%d,", query, Player[playerid][pGuardCode]);
format(query, sizeof(query), "%sFlatKey=%d,", query, Player[playerid][pFlatKey]);
format(query, sizeof(query), "%s_Int_=%d,", query, Player[playerid][pInt]);
format(query, sizeof(query), "%sLocal=%d,", query, Player[playerid][pLocal]);
format(query, sizeof(query), "%sPhousekey=%d,", query, Player[playerid][pPhousekey]);
format(query, sizeof(query), "%sWeapon1=%d,", query, Player[playerid][Weapon1]);
format(query, sizeof(query), "%sWeapon1a=%d,", query, Player[playerid][Weapon1a]);
format(query, sizeof(query), "%sWeapon2=%d,", query, Player[playerid][Weapon2]);
format(query, sizeof(query), "%sWeapon2a=%d,", query, Player[playerid][Weapon2a]);
format(query, sizeof(query), "%sWeapon3=%d,", query, Player[playerid][Weapon3]);
format(query, sizeof(query), "%sWeapon3a=%d,", query, Player[playerid][Weapon3a]);
format(query, sizeof(query), "%sWeapon4=%d,", query, Player[playerid][Weapon4]);
format(query, sizeof(query), "%sWeapon4a=%d,", query, Player[playerid][Weapon4a]);
format(query, sizeof(query), "%sWeapon5=%d,", query, Player[playerid][Weapon5]);
format(query, sizeof(query), "%sWeapon5a=%d,", query, Player[playerid][Weapon5a]);
format(query, sizeof(query), "%sWeapon6=%d,", query, Player[playerid][Weapon6]);
format(query, sizeof(query), "%sWeapon6a=%d,", query, Player[playerid][Weapon6a]);
format(query, sizeof(query), "%sWeapon7=%d,", query, Player[playerid][Weapon7]);
format(query, sizeof(query), "%sWeapon7a=%d,", query, Player[playerid][Weapon7a]);
format(query, sizeof(query), "%sWeapon8=%d,", query, Player[playerid][Weapon8]);
format(query, sizeof(query), "%sWeapon8a=%d,", query, Player[playerid][Weapon8a]);
format(query, sizeof(query), "%sWeapon9=%d,", query, Player[playerid][Weapon9]);
format(query, sizeof(query), "%sWeapon9a=%d,", query, Player[playerid][Weapon9a]);
format(query, sizeof(query), "%sWeapon10=%d,", query, Player[playerid][Weapon10]);
format(query, sizeof(query), "%sWeapon10a=%d,", query, Player[playerid][Weapon10a]);
format(query, sizeof(query), "%sWeapon11=%d,", query, Player[playerid][Weapon11]);
format(query, sizeof(query), "%sWeapon11a=%d,", query, Player[playerid][Weapon11a]);
format(query, sizeof(query), "%sWeapon12=%d,", query, Player[playerid][Weapon12]);
format(query, sizeof(query), "%sWeapon12a=%d,", query, Player[playerid][Weapon12a]);
format(query, sizeof(query), "%sBarterSkil=%d,", query, Player[playerid][pBarterSkill]);
format(query, sizeof(query), "%sSurvSkill=%d,", query, Player[playerid][pSurvSkill]);
format(query, sizeof(query), "%sWeapSkill=%d,", query, Player[playerid][pWeapSkill]);
format(query, sizeof(query), "%sMedSkill=%d,", query, Player[playerid][pMedSkill]);
format(query, sizeof(query), "%sRepSkill=%d,", query, Player[playerid][pRepSkill]);
format(query, sizeof(query), "%sGuardClothes=%d", query, Player[playerid][pGuardClothes]);
format(query, sizeof(query), "%s WHERE Name='%s'", query, Player[playerid][pName]);
mysql_tquery(connectionHandle,query, "","");
query = "UPDATE `accounts` SET ";
for(new i; i < INVNUMBERS/2-1; i++)
format(query, sizeof(query), "%sPlayerInv_%d=%d,", query, i+1, Player[playerid][pPlayerInv][i]);
format(query, sizeof(query), "%sPlayerInv_%d=%d", query, INVNUMBERS/2, Player[playerid][pPlayerInv][INVNUMBERS/2-1]);
format(query, sizeof(query), "%s WHERE Name='%s'", query, Player[playerid][pName]);
mysql_tquery(connectionHandle,query, "","");
query = "UPDATE `accounts` SET ";
for(new i=INVNUMBERS/2; i < INVNUMBERS-1; i++)
format(query, sizeof(query), "%sPlayerInv_%d=%d,", query, i+1, Player[playerid][pPlayerInv][i]);
format(query, sizeof(query), "%sPlayerInv_%d=%d", query, INVNUMBERS, Player[playerid][pPlayerInv][INVNUMBERS-1]);
format(query, sizeof(query), "%s WHERE Name='%s'", query, Player[playerid][pName]);
mysql_tquery(connectionHandle,query, "","");
query = "UPDATE `accounts` SET ";
for(new i; i < IDKVEST; i++)
{
format(query, sizeof(query), "%sSaveKvest_%d=%d,", query, i+1, Player[playerid][pSaveKvest][i]);
}
for(new i; i < 20; i++)
{
format(query, sizeof(query), "%sPlayerInv_%d=%d,", query, i+1, Player[playerid][pPlayerGMP][i]);
}
format(query, sizeof(query), "%sOtkatgun=%d,", query, Player[playerid][pOtkatgun]);
format(query, sizeof(query), "%sHeadValue=%d,", query, Player[playerid][pHeadValue]);
format(query, sizeof(query), "%sFishki=%d,", query, Player[playerid][pFishki]);
format(query, sizeof(query), "%sTimequest=%d,", query, Player[playerid][pTimequest]);
format(query, sizeof(query), "%sInfoquest=%d,", query, Player[playerid][pInfoquest]);
format(query, sizeof(query), "%sNaruch=%d,", query, Player[playerid][pNaruch]);
format(query, sizeof(query), "%sPame='%s',", query, Player[playerid][pPame]);
format(query, sizeof(query), "%sGul=%d", query, Player[playerid][pGul]);
format(query, sizeof(query), "%s WHERE Name='%s'", query, Player[playerid][pName]);
mysql_tquery(connectionHandle,query, "","");
return 1;
}