Доступ к архиву

Переход в группу "Пользователь"

300.00 ₽
Одноразовый платёж
Быстрый переход в группу "Пользователи", без надобности написания постов и ожидания.

Покупка дает возможность:
Быть полноправным участником форума
Нормальное копирование кода
Создавать темы
Скачивать файлы
Доступ к архиву Pawno-Info

Запрос в MySQL R5

Статус
В этой теме нельзя размещать новые ответы.

Felar.Exe

Компетентный
Помогите, что такое происходит? Запрос работает только на бизнес, Дом. На остальное ему насрать.

Код: 
public Save_Player(playerid) { // Сохранение аккаунта.
    if(IsPlayerConnected(playerid)) { // Проверка, если аккаунт авторизован.
		new str[9000],sctring[9000];
		format(str,sizeof(str),"UPDATE `accounts` SET `Level` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pLVL],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `House` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pHouse],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Bizz` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pBiznes],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `AdminLevel` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pAdminLVL],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Ochko` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pOchko],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `pNomerMobile` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pNomerMobile],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Fuelcar` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pFuelcar],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Text` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pText],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Housecash` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pHouseCash],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `pSaveCuff` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pSaveCuff],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `HP` = '%f' WHERE `Name` = '%s'",PINFO[playerid][pHP],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `EM_Proverka` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pEM_Proverka],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Proverkaip` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pIP_Proverka],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `pPhoneBook` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pPhoneBook],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Bolnica` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pBolnica],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `pDirectory` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDirectory],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Car` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pCar][0],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Donateschet` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDonatSchet],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `pLastDonate` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pLastDonate],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Donatemoney` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDonateMoney],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `DonateRank` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pVIP],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Registered` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pReg],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Sex` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pSex],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `pArrested` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pArrested],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Muted` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pMuted],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Crimes` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pCrimes],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Respect` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pExp],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Money` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pCash],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Kills` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pKills],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Deaths` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDeaths],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `pJobZp` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pJobZp],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Jailed` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pJailed],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `JailTime` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pJailTime],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Drugs` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDrugs],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Leader` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pLeader],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Member` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pMember],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Rank` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pRank],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Job` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pJob],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `VodPrava` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pVodPrava],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `BizLic` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pBizLic],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `pFlyLic` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pFlyLic],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `pBoatLic` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pBoatLic],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `pGunLic` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pGunLic],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Desert` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pGunSkill][1],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `Smg` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pGunSkill][2],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `AK47` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pGunSkill][3],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `M4` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pGunSkill][4],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `pSDPistol` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pGunSkill][0],GN(playerid)); strcat(sctring,str);
		format(str,sizeof(str),"UPDATE `accounts` SET `pShotGun` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pGunSkill][5],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Char` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pSkin][0],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Char2` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pSkin][1],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Model` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pModel],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `PhoneNr` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pPnumber],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Tutorial` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pTut],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Warnings` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pWarns],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `unWarns` = '%d' WHERE `Name` = '%s'",PINFO[playerid][punWarns],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `unWarnstime` = '%d' WHERE `Name` = '%s'",PINFO[playerid][punWarnstime],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Married` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pMarried],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `MuteTime` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pMuteTime],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Mobile` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pMobileBill],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Bank` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pBank],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `BoxSkill` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pStyleSkill][0],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `KongfuSkill` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pStyleSkill][1],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `KickboxSkill` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pStyleSkill][2],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Zakonop` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pZakonp],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `NarcoZavisimost` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pNZavism],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Mats` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pMats],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Proz` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pCarProcents],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Kolesa` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDetaLesCar][0],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `HOOD` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDetaLesCar][1],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Spoiler` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDetaLesCar][2],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Bamper1` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDetaLesCar][3],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Bamper2` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDetaLesCar][4],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `ROOF` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDetaLesCar][5],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `SIDESKIRT` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDetaLesCar][8],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Nitro` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDetaLesCar][6],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Gidravlika` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDetaLesCar][7],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `LAMPS` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDetaLesCar][9],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `EXHAUST` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDetaLesCar][10],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `VENT_RIGHT` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDetaLesCar][11],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `VENT_LEFT` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDetaLesCar][12],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `COLOR1` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDetaLesCar][13],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `COLOR2` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pDetaLesCar][14],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `pAvtomas` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pAvtomas],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `pMestoJail` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pMestoJail],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Zvezdi` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pZvezdi],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Keys` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pKeys],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `GameTime` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pGameTime],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `pRobbing` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pRobbing],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Hijack` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pHijack],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `DpExp` = '%d' WHERE `Name` = '%s'",PINFO[playerid][DpExp],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `DpLvl` = '%d' WHERE `Name` = '%s'",PINFO[playerid][DpLvl],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `pWantedDeaths` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pWantedDeaths],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `pGolos` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pGolos],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `pFstyle` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pFstyle],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `pPolka` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pSkin][2],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `pTaxiSkill` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pTaxiSkill],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `pTaxiExp` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pTaxiExp],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Sitost` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pSitost],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `panels` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pV_Sost][0],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `doors` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pV_Sost][1],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `lights` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pV_Sost][2],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `tires` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pV_Sost][3],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `Komnata` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pKomnata],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `InFrac` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pTimeInFrac],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `pbUgon` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pbUgon],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `pSpawnCH` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pSpawnCH],GN(playerid)); strcat(sctring,str);
        format(str,sizeof(str),"UPDATE `accounts` SET `pVigovor` = '%d' WHERE `Name` = '%s'",PINFO[playerid][pVigovor],GN(playerid)); strcat(sctring,str);
        mysql_query(str); // Отправляем запрос
	}
    return true;
}
Помогите, буду блогадарен
 
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу