reckless
Новичок
Приветствую всех, возник такой вопрос. Перевел систему аккаунтов на MySQL и такая проблема, при регистрации создается персонаж в БД, но при перезаходе не сохраняются данные о нем (Level, Admin, Helper, VIP и.т.д.) в чем может быть проблема?
PHP:
public OnPlayerUpdateSG(playerid)
{
if(IsPlayerConnected(playerid))
{
if(gPlayerLogged[playerid] == 1)
{
if(mysql_ping() == -1) mysql_reconnect();
new sql[3012];
GetPlayerHealth(playerid, PlayerInfo[playerid][pHealth]);
PlayerInfo[playerid][pInt] = GetPlayerInterior(playerid);
PlayerInfo[playerid][pCash] = GetPlayerMoney(playerid);
format(sql, sizeof(sql), "UPDATE `Accounts` SET Level = %d,\
`Admin`=%d,\
`Helper`=%d,\
`DonateRank`=%d,\
`ConnectTime`=%d,\
`Registered`=%d,\
`Sex`=%d,\
`Age`=%d,\
`Origin`=%d,\
`Muted`=%d,\
`Respect`=%d,\
`Money`=%d,\
`Crimes`=%d,\
`Kills`=%d,\
`Deaths`=%d,\
`Arrested`=%d,\
`WantedDeaths`=%d,\
`Phonebook`=%d",
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pHelper],
PlayerInfo[playerid][pDonateRank],
PlayerInfo[playerid][pConnectTime],
PlayerInfo[playerid][pReg],
PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pAge],
PlayerInfo[playerid][pOrigin],
PlayerInfo[playerid][pMuted],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pCash],
PlayerInfo[playerid][pCrimes],
PlayerInfo[playerid][pKills],
PlayerInfo[playerid][pDeaths],
PlayerInfo[playerid][pArrested],
PlayerInfo[playerid][pWantedDeaths],
PlayerInfo[playerid][pPhoneBook]);
format(sql, sizeof(sql), "%s`Job`=%d,\
`Paycheck`=%d,\
`HeadValue`=%d,\
`Jailed`=%d,\
`JailTime`=%d,\
`Materials`=%d,\
`Drugs`=%d,\
`Leader`=%d,\
`Member`=%d,\
`Rank`=%d,\
`Char`=%d,\
`ContractTime`=%d,\
`DetSkill`=%d,\
`SexSkill`=%d,\
`LawSkill`=%d,\
`CarSkill`=\"%s\",\
`DrugsSkill`=\"%s\",\
`pSHealth`=%d,\
`pHealth`=%d,\
`Int`=%d,\
`Local`=%d",
sql,
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pPayCheck],
PlayerInfo[playerid][pHeadValue],
PlayerInfo[playerid][pJailed],
PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pMats],
PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pRank],
PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pContractTime],
PlayerInfo[playerid][pDetSkill],
PlayerInfo[playerid][pSexSkill],
PlayerInfo[playerid][pLawSkill],
PlayerInfo[playerid][pMechSkill],
PlayerInfo[playerid][pJackSkill],
PlayerInfo[playerid][pCarSkill],
PlayerInfo[playerid][pDrugsSkill],
PlayerInfo[playerid][pSHealth],
PlayerInfo[playerid][pHealth],
PlayerInfo[playerid][pInt],
PlayerInfo[playerid][pLocal]);
format(sql, sizeof(sql), "%s`PhoneNr`=%d,\
`House`=%d,\
`Bizz`=%d,\
`Pos_x`=%.3f,\
`Pos_y`=%.3f,\
`Pos_z`=%.3f,\
`CarLicA`=%d,\
`CarLicB`=%d,\
`CarLicC`=%d,\
`FlyLic`=%d,\
`BoatLic`=%d,\
`FishLic`=%d,\
`GunLic`=%d,\
`PayDay`=%d,\
`PayDayHad`=%d,\
`CDPlayer`=%d,\
`Wins`=%d,\
`Loses`=%d,\
`Tutorial`=%d,\
`Warnings`=%d,\
`Adjustable`=%d",
sql,
PlayerInfo[playerid][pPnumber],
PlayerInfo[playerid][pPhousekey],
PlayerInfo[playerid][pPbiskey],
PlayerInfo[playerid][pPos_x],
PlayerInfo[playerid][pPos_y],
PlayerInfo[playerid][pPos_z],
PlayerInfo[playerid][pCarLicA],
PlayerInfo[playerid][pCarLicB],
PlayerInfo[playerid][pCarLicC],
PlayerInfo[playerid][pBoatLic],
PlayerInfo[playerid][pFlyLic],
PlayerInfo[playerid][pGunLic],
PlayerInfo[playerid][pPayDay],
PlayerInfo[playerid][pPayDayHad],
PlayerInfo[playerid][pCDPlayer],
PlayerInfo[playerid][pWins],
PlayerInfo[playerid][pLoses],
PlayerInfo[playerid][pTut],
PlayerInfo[playerid][pWarns],
PlayerInfo[playerid][pAdjustable]);
format(sql, sizeof(sql), "%s`Fuel`=%d,\
`Married`=%d,\
`MarriedTo`='%s',\
`Passport`=%d,\
`PassNr`=%d,\
`Radio`=%d,\
`Vigovor`=%d,\
`MuteTime`=%d,\
`Medics`=%d,\
`Bank`=%d,\
`Card`=%d,\
`Ban`=%d,\
`Zakonop`=%d,\
`Style`=%d",
sql,
PlayerInfo[playerid][pFuel],
PlayerInfo[playerid][pMarried],
PlayerInfo[playerid][pMarriedTo],
PlayerInfo[playerid][pPass],
PlayerInfo[playerid][pPassnum],
PlayerInfo[playerid][pRadio],
PlayerInfo[playerid][pVig],
PlayerInfo[playerid][pMuteTime],
PlayerInfo[playerid][pMed],
PlayerInfo[playerid][pBank],
PlayerInfo[playerid][pCard],
PlayerInfo[playerid][pLocked],
PlayerInfo[playerid][pZakonp],
PlayerInfo[playerid][pStyle]);
format(sql, sizeof(sql), "%s`SLOT1`=%d,\
`AMMO1`=%d,\
`SLOT2`=%d,\
`AMMO2`=%d,\
`SLOT3`=%d,\
`AMMO3`=%d,\
`SLOT4`=%d,\
`AMMO4`=%d,\
`SLOT5`=%d,\
`AMMO5`=%d,\
`SLOT6`=%d,\
`AMMO6`=%d,\
`SLOT7`=%d,\
`AMMO7`=%d,\
`SLOT8`=%d,\
`AMMO8`=%d,\
`SLOT9`=%d,\
`AMMO9`=%d,\
`SLOT10`=%d,\
`AMMO10`=%d,",
sql,
PlayerInfo[playerid][pGuns][0], PlayerInfo[playerid][pAmmo][0],
PlayerInfo[playerid][pGuns][1], PlayerInfo[playerid][pAmmo][1],
PlayerInfo[playerid][pGuns][2], PlayerInfo[playerid][pAmmo][2],
PlayerInfo[playerid][pGuns][3], PlayerInfo[playerid][pAmmo][3],
PlayerInfo[playerid][pGuns][4], PlayerInfo[playerid][pAmmo][4],
PlayerInfo[playerid][pGuns][5], PlayerInfo[playerid][pAmmo][5],
PlayerInfo[playerid][pGuns][6], PlayerInfo[playerid][pAmmo][6],
PlayerInfo[playerid][pGuns][7], PlayerInfo[playerid][pAmmo][7],
PlayerInfo[playerid][pGuns][8], PlayerInfo[playerid][pAmmo][8],
PlayerInfo[playerid][pGuns][9], PlayerInfo[playerid][pAmmo][9]);
format(sql, sizeof(sql), "%s `SLOT11`=%d,\
`AMMO11`=%d,\
`SLOT12`=%d,\
`AMMO12`=%d,\
`SLOT13`=%d,\
`AMMO13`=%d,\
`MedicBill`=%d,\
`HospitalTime`=%d",
sql,
PlayerInfo[playerid][pGuns][10], PlayerInfo[playerid][pAmmo][10],
PlayerInfo[playerid][pGuns][11], PlayerInfo[playerid][pAmmo][11],
PlayerInfo[playerid][pGuns][12], PlayerInfo[playerid][pAmmo][12],
PlayerInfo[playerid][pMedicBill],
HospitalTime[playerid]);
mysql_query(sql);
}
}
return 1;
}
public OnPlayerLogin(playerid, password[])
{
new query[128], pass[32], name[24], result[3000], string2[64], tmp2[256];
mysql_real_escape_string(password, pass), mysql_real_escape_string(PlayerName2(playerid), name);
format(query, sizeof(query), "SELECT * FROM `Accounts` WHERE `Name` = '%s' LIMIT 1", PlayerName2(playerid));
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() == 1)
{
mysql_fetch_row_format(result, "|");
sscanf(result, "p<|>iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiffiiiifffiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii",
PlayerInfo[playerid][pUID],
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pHelper],
PlayerInfo[playerid][pDonateRank],
PlayerInfo[playerid][pConnectTime],
PlayerInfo[playerid][pReg],
PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pAge],
PlayerInfo[playerid][pOrigin],
PlayerInfo[playerid][pMuted],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pCash],
PlayerInfo[playerid][pCrimes],
PlayerInfo[playerid][pKills],
PlayerInfo[playerid][pDeaths],
PlayerInfo[playerid][pArrested],
PlayerInfo[playerid][pWantedDeaths],
PlayerInfo[playerid][pPhoneBook],
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pJailed],
PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pMats],
PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pRank],
PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pContractTime],
PlayerInfo[playerid][pDetSkill],
PlayerInfo[playerid][pSexSkill],
PlayerInfo[playerid][pLawSkill],
PlayerInfo[playerid][pMechSkill],
PlayerInfo[playerid][pJackSkill],
PlayerInfo[playerid][pCarSkill],
PlayerInfo[playerid][pDrugsSkill],
PlayerInfo[playerid][pSHealth],
PlayerInfo[playerid][pHealth],
PlayerInfo[playerid][pInt],
PlayerInfo[playerid][pLocal],
PlayerInfo[playerid][pPhousekey],
PlayerInfo[playerid][pPbiskey],
PlayerInfo[playerid][pPos_x],
PlayerInfo[playerid][pPos_y],
PlayerInfo[playerid][pPos_z],
PlayerInfo[playerid][pCarLicA],
PlayerInfo[playerid][pCarLicB],
PlayerInfo[playerid][pCarLicC],
PlayerInfo[playerid][pFlyLic],
PlayerInfo[playerid][pBoatLic],
PlayerInfo[playerid][pFishLic],
PlayerInfo[playerid][pGunLic],
PlayerInfo[playerid][pPayDay],
PlayerInfo[playerid][pPayDayHad],
PlayerInfo[playerid][pCDPlayer],
PlayerInfo[playerid][pWins],
PlayerInfo[playerid][pLoses],
PlayerInfo[playerid][pTut],
PlayerInfo[playerid][pWarns],
PlayerInfo[playerid][pFuel],
PlayerInfo[playerid][pMarried],
PlayerInfo[playerid][pPass],
PlayerInfo[playerid][pPassnum],
PlayerInfo[playerid][pRadio],
PlayerInfo[playerid][pVig],
PlayerInfo[playerid][pMuteTime],
PlayerInfo[playerid][pMed],
PlayerInfo[playerid][pBank],
PlayerInfo[playerid][pCard],
PlayerInfo[playerid][pLocked],
PlayerInfo[playerid][pZakonp],
PlayerInfo[playerid][pStyle],
PlayerInfo[playerid][pGuns][0],
PlayerInfo[playerid][pAmmo][0],
PlayerInfo[playerid][pGuns][1],
PlayerInfo[playerid][pAmmo][1],
PlayerInfo[playerid][pGuns][2],
PlayerInfo[playerid][pAmmo][2],
PlayerInfo[playerid][pGuns][3],
PlayerInfo[playerid][pAmmo][3],
PlayerInfo[playerid][pGuns][4],
PlayerInfo[playerid][pAmmo][4],
PlayerInfo[playerid][pGuns][5],
PlayerInfo[playerid][pAmmo][5],
PlayerInfo[playerid][pGuns][6],
PlayerInfo[playerid][pAmmo][6],
PlayerInfo[playerid][pGuns][7],
PlayerInfo[playerid][pAmmo][7],
PlayerInfo[playerid][pGuns][8],
PlayerInfo[playerid][pAmmo][8],
PlayerInfo[playerid][pGuns][9],
PlayerInfo[playerid][pAmmo][9],
PlayerInfo[playerid][pGuns][10],
PlayerInfo[playerid][pAmmo][10],
PlayerInfo[playerid][pGuns][11],
PlayerInfo[playerid][pAmmo][11],
PlayerInfo[playerid][pGuns][12],
PlayerInfo[playerid][pAmmo][12],
PlayerInfo[playerid][pMedicBill],
HospitalTime[playerid]);
format(string2, sizeof(string2), "%s, ìû ðàäû âèäåòü òåáÿ íà ñåðâåðå.",PlayerName2(playerid));
SendClientMessage(playerid, COLOR_LIGHTBLUE,string2);
gPlayerLogged[playerid] = 1;
SpawnPlayer(playerid);
format(tmp2, sizeof(tmp2), "~w~ƒO—PO ŒO„A‡O‹A¦’ ~n~~y~ %s", PlayerName2(playerid));
DateProp(playerid);
GameTextForPlayer(playerid, tmp2, 5000, 1);
if(PlayerInfo[playerid][pReg] == 0)
{
PlayerInfo[playerid][pLevel] = 15;
PlayerInfo[playerid][pPos_x] = 2225.0273;
PlayerInfo[playerid][pPos_y] = -1149.4296;
PlayerInfo[playerid][pPos_z] = 1025.7969;
SetCameraBehindPlayer(playerid);
PlayerInfo[playerid][pInt] = 15;
SetPlayerVirtualWorld(playerid, 15);
PlayerInfo[playerid][pLocal] = 255;
PlayerInfo[playerid][pSHealth] = 50;
new randphone = 100000 + random(899999);//minimum 1000 max 9999 //giving one at the start
PlayerInfo[playerid][pPnumber] = randphone;
PlayerInfo[playerid][pPhousekey] = 800;
PlayerInfo[playerid][pPbiskey] = 255;
PlayerInfo[playerid][pReg] = 1;
PlayerInfo[playerid][pTut] = 0;
}
mysql_free_result();
}
return 1;
}