Djon95
Компетентный
На хостинге не создаётся аккаунт в базу данных,если акк есть в базе то загружает обновляет и т.д.Тоесть подключено все правильно.
хостинг:Ru-hoster.com(не реклама)
сохранение:
хостинг:Ru-hoster.com(не реклама)
сохранение:
PHP:
stock SaveAccount(playerid)
{
if(PlayerLogged[playerid] == 0) return 1;
new src[1024], ip[16];
/////////////////////////////////
format(query,sizeof(query),"UPDATE "TABLE_ACCOUNT" SET ");
GetPlayerIp(playerid, ip, 16);
format(src,sizeof(src),"ip='%s',",ip);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"level=%d,",PlayerInfo[playerid][pLevel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"admin=%d,",PlayerInfo[playerid][pAdmin]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sex=%d,",PlayerInfo[playerid][pSex]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"model=%d,",PlayerInfo[playerid][pModel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"loach=%d,",PlayerInfo[playerid][pChar]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cash=%d,",PlayerInfo[playerid][pCash]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"bank=%d,",PlayerInfo[playerid][pBank]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mute=%d,",PlayerInfo[playerid][pMuted]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"warn=%d,",PlayerInfo[playerid][pWarn]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"leader=%d,",PlayerInfo[playerid][pLeader]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"member=%d,",PlayerInfo[playerid][pMember]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"rank=%d,",PlayerInfo[playerid][pRank]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"pick=%d,",PlayerInfo[playerid][pPick]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"exp=%d,",PlayerInfo[playerid][pExp]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"news=%d,",PlayerInfo[playerid][pNews]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"crimes=%d,",PlayerInfo[playerid][pCrimes]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wanted=%d,",PlayerInfo[playerid][pWanted]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedtime=%d,",PlayerInfo[playerid][pWantedTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedwho='%s',",PlayerInfo[playerid][pWantedWho]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedreason='%s',",PlayerInfo[playerid][pWantedReason]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"jail=%d,",PlayerInfo[playerid][pJail]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"job=%d,",PlayerInfo[playerid][pJob]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"jailtime=%d,",PlayerInfo[playerid][pJailTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"checktime=%d,",PlayerInfo[playerid][pCheckTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"drugs=%d,",PlayerInfo[playerid][pDrugs]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mats=%d,",PlayerInfo[playerid][pMats]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"heal='%f',",PlayerInfo[playerid][pHeal]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"married=%d,",PlayerInfo[playerid][pMarried]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"whomarried='%s',",PlayerInfo[playerid][pWhoMarried]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"paycheck='%i',",PlayerInfo[playerid][pPayCheck]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"fishing='%i',",PlayerInfo[playerid][pFish]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"lottery='%i',",PlayerInfo[playerid][pLottery]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"vip='%i',",PlayerInfo[playerid][pVIP]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"time='%i',",PlayerInfo[playerid][pTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"patr=%d,",pPatron[playerid]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pPhones],16,"%i, %i, %i",
PlayerInfo[playerid][pPhone][0],PlayerInfo[playerid][pPhone][1], PlayerInfo[playerid][pPhone][2]);
format(src,sizeof(src),"phone='%s',",PlayerInfo[playerid][pPhones]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pLics],40,"%i, %i, %i, %i, %i",
PlayerInfo[playerid][pLic][0],PlayerInfo[playerid][pLic][1],PlayerInfo[playerid][pLic][2]
,PlayerInfo[playerid][pLic][3],PlayerInfo[playerid][pLic][4]);
format(src,sizeof(src),"lic='%s',",PlayerInfo[playerid][pLics]);
strcat(query,src,sizeof(query));
if(GetPVarInt(playerid, "GunCheat") == 0)
{
for(new i = 0; i < 13; i++)
{
GetPlayerWeaponData(playerid, i, PlayerInfo[playerid][pGun][i], PlayerInfo[playerid][pAmmo][i]);
}
format(PlayerInfo[playerid][pGuns],40,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
PlayerInfo[playerid][pGun][0],PlayerInfo[playerid][pGun][1],PlayerInfo[playerid][pGun][2],
PlayerInfo[playerid][pGun][3],PlayerInfo[playerid][pGun][4],PlayerInfo[playerid][pGun][5],
PlayerInfo[playerid][pGun][6],PlayerInfo[playerid][pGun][7],PlayerInfo[playerid][pGun][8],
PlayerInfo[playerid][pGun][9],PlayerInfo[playerid][pGun][10],PlayerInfo[playerid][pGun][11],PlayerInfo[playerid][pGun][12]);
format(src,sizeof(src),"guns='%s',",PlayerInfo[playerid][pGuns]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pAmmos],160,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
PlayerInfo[playerid][pAmmo][0],PlayerInfo[playerid][pAmmo][1],PlayerInfo[playerid][pAmmo][2],
PlayerInfo[playerid][pAmmo][3],PlayerInfo[playerid][pAmmo][4],PlayerInfo[playerid][pAmmo][5],
PlayerInfo[playerid][pAmmo][6],PlayerInfo[playerid][pAmmo][7],PlayerInfo[playerid][pAmmo][8],
PlayerInfo[playerid][pAmmo][9],PlayerInfo[playerid][pAmmo][10],PlayerInfo[playerid][pAmmo][11],PlayerInfo[playerid][pAmmo][12]);
format(src,sizeof(src),"ammos='%s',",PlayerInfo[playerid][pAmmos]);
}
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pSkills],40,"%d,%d,%d,%d,%d,%d,%d",
PlayerInfo[playerid][pGunSkill][0],PlayerInfo[playerid][pGunSkill][1],PlayerInfo[playerid][pGunSkill][2],
PlayerInfo[playerid][pGunSkill][3],PlayerInfo[playerid][pGunSkill][4],PlayerInfo[playerid][pGunSkill][5],
PlayerInfo[playerid][pGunSkill][6]);
format(src,sizeof(src),"skills='%s'",PlayerInfo[playerid][pSkills]);
strcat(query,src,sizeof(query));
format(src,sizeof(src)," WHERE name='%s'",sendername(playerid));
strcat(query,src,sizeof(query));
return 1;
}[/SPOILER]