Сергей|DEMON91052
Компетентный
Всем привет дорогие друзья, прошу помочь мне с переводом мода с MySql R6 на R7. Я и в обычном скриптинге дум дум а тут такое 
, Я не знаю как вы мне сможете помочь, я понимаю что это не правильно но я прошу вас сделать всё за меня. Мод на R6 но Ru-Hoster не принимает этот плагин приходиться переводить либо на R5 либо на R7 я выбрал R7 (т.к. новее)
Вот что надо перевести:
, Я не знаю как вы мне сможете помочь, я понимаю что это не правильно но я прошу вас сделать всё за меня. Мод на R6 но Ru-Hoster не принимает этот плагин приходиться переводить либо на R5 либо на R7 я выбрал R7 (т.к. новее)Вот что надо перевести:
PHP:
GetPlayerName(playerid, plname, sizeof(plname));
format(query, sizeof query, "SELECT * FROM `users` WHERE `PlayerName`='%s' LIMIT 1;", plname);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows()>0) { gPlayerAccount[playerid] = 1; }
else { gPlayerAccount[playerid] = 0; }
mysql_free_result();
PHP:
case 327:
{
if(response==1)
{
if(!strlen(inputtext)) return SPD(playerid,327,DIALOG_STYLE_PASSWORD,"Смена пароля","Введите ваш действующий пароль:", "Принять", "Отмена");
new pass[50];
GetPlayerName(playerid,playername,sizeof(playername));
format(query, sizeof query, "SELECT Key FROM `users` WHERE `ID`='%d';", SqlID[playerid]);
mysql_query(query);
mysql_store_result();
mysql_retrieve_row();
mysql_get_field("Key",pass);
mysql_free_result();
for(new i = strlen(inputtext); i != 0; --i)
switch(inputtext[i]){case 'А'..'Я', 'а'..'я', ' ': return SPD(playerid,10007,DIALOG_STYLE_MSGBOX,"{00FF00}Ошибка!","Введенный вами пароль содержит русские буквы.\n Смените раскладку клавиатуры!","Повтор","");}
if(!strcmp(inputtext,pass,true)){ SPD(playerid,328,DIALOG_STYLE_PASSWORD,"Смена пароля","Введите ваш новый пароль:", "Принять", "Отмена");}
else return true;
return true;
}
}
PHP:
GetPlayerName(playerid, playername2, sizeof(playername2));
format(query, sizeof query, "SELECT * FROM `users` WHERE `PlayerName`='%s' LIMIT 1;", playername2);
mysql_query(query);
mysql_store_result();
mysql_retrieve_row();
if(mysql_num_rows() > 0)
{
format(query, sizeof query, "SELECT * FROM `users` WHERE `MarriedTo` LIMIT 1;");
new cash = PlayerInfo[targetid][pCash];
new warrests = PlayerInfo[targetid][pWantedDeaths];
new drugs = PlayerInfo[targetid][pDrugs];
new mats = PlayerInfo[targetid][pMats];
new wanted = WantedLevel[playerid];
new level = PlayerInfo[targetid][pLevel];
new pnumber = PlayerInfo[targetid][pPnumber];
new warns = PlayerInfo[targetid][pWarns];
new zakon = PlayerInfo[targetid][pZakonp];
new exp = PlayerInfo[targetid][pExp];
new nxtlevel = PlayerInfo[targetid][pLevel]+1;
new expamount = nxtlevel*levelexp;
new honem = PlayerInfo[targetid][pMobile];
new narko = PlayerInfo[targetid][pNarcoZavisimost];
new bcase = PlayerInfo[targetid][pBank];
new arrests = PlayerInfo[targetid][pArrested];
new kills = PlayerInfo[targetid][pKills];
new stringi[20];
/*GetPlayerName(targetid, name, sizeof(name));
format(string,sizeof(string),"accounts/%s.ini",name);
new File = ini_openFile(string);
ini_getString(File,"pDataReg",stringi);
ini_closeFile(File);*/
format(query, sizeof query, "SELECT * FROM `users` WHERE `pDataReg` LIMIT 1;");
new playerip[15];
GetPlayerIp(targetid, playerip, sizeof(playerip));
GetPlayerName(targetid, name, sizeof(name));
new Float:px,Float:py,Float:pz;
GetPlayerPos(targetid, px, py, pz);
new str[166],sctring[1450];
format(str,sizeof(str),"{00FF04}__________________________________________________\n\n");
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Имя: \t\t\t\t\t{9ACD32}%s \n\n",name);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Уровень: \t\t\t\t{ffffff}%d \n",level);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Респекты: \t\t\t\t{ffffff}%d / %d \n",exp,expamount);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Пол: \t\t\t\t\t{ffffff}%s \n",atext);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Статус в штате: \t\t\t{ffffff}%s \n",drank);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Статус {FFFF00}VIP{ffffff}: \t\t\t\t%s \n",arank);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Проживает с: \t\t\t\t{ffffff}%s \n",stringi);
strcat(sctring,str);
format(str,sizeof(str),"{00FF04}__________________________________________________\n\n");
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Законопослушность: \t\t\t{ffffff}%d \n",zakon);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Арестов: \t\t\t\t{ffffff}%d \n\n",arrests);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Варн(ов): \t\t\t\t{ffffff}%d/{FF6347}3 \n",warns);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Уровень Преступлений: \t\t{ffffff}%d/{FF6347}6 \n",wanted);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Убийств: \t\t\t\t{ffffff}%d \n",kills);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Смертей в розыске: \t\t\t{ffffff}%d \n",warrests);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Наркозависимость: \t\t\t{ffffff}%d \n",narko);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Наркотики при себе: \t\t\t{ffffff}%d \n",drugs);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Материалы при себе: \t\t{ffffff}%d \n",mats);
strcat(sctring,str);
format(str,sizeof(str),"{00FF04}__________________________________________________\n\n");
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Работа: \t\t\t\t{ffffff}%s \n",jtext);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Организация: \t\t\t\t{ffffff}%s \n",ttext);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Ранг: \t\t\t\t\t{ffffff}%s \n\n",rangz); ///
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Денег: \t\t\t\t{ffffff}%d{FFFF00}$ \n",cash);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}В банке: \t\t\t\t{ffffff}%d{FFFF00}$ \n",bcase);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Телефон: \t\t\t\t{ffffff}%d \n",pnumber);
strcat(sctring,str);
format(str,sizeof(str),"{ffffff}Баланс на телефоне: \t\t{ffffff}%d{FFFF00}$ \n",honem);
strcat(sctring,str);
format(str,sizeof(str),"{00FF04}__________________________________________________\n");
strcat(sctring,str);
new lol[256];
format(lol,sizeof(lol),"{33AA33}Статистика игрового аккаунта:{ffffff} %s ",name);
SPD(playerid,10004,DIALOG_STYLE_MSGBOX,lol,sctring,"Ок","");
}
PHP:
for(new h = 0; h < AllHouse; h++)
{
if(HouseInfo[h][hKlass] == 0 && HouseInfo[h][hOwned] == 1){HouseInfo[h][hTakings] -=50;}
if(HouseInfo[h][hKlass] == 1 && HouseInfo[h][hOwned] == 1){HouseInfo[h][hTakings] -=100;}
if(HouseInfo[h][hKlass] == 2 && HouseInfo[h][hOwned] == 1){HouseInfo[h][hTakings] -=150;}
if(HouseInfo[h][hKlass] == 3 && HouseInfo[h][hOwned] == 1){HouseInfo[h][hTakings] -=100;}
if(HouseInfo[h][hKlass] == 4 && HouseInfo[h][hOwned] == 1){HouseInfo[h][hTakings] -=50;}
if(HouseInfo[h][hTakings] <= 0 && HouseInfo[h][hOwned] == 1)
{
new housecash = HouseInfo[h][hValue]/2;
format(query, sizeof query, "UPDATE `users` SET `Housecash`='%d' WHERE `PlayerName`='%s' LIMIT 1;", housecash, HouseInfo[h][hOwner]);
mysql_query(query);
HouseInfo[h][hHel] = 0;
HouseInfo[h][hLock] = 1;
HouseInfo[h][hOwned] = 0;
HouseInfo[h][hNarko] = 0;
HouseInfo[h][hMoney] = 0;
strmid(HouseInfo[h][hOwner], "The State", 0, strlen("The State"), 10);
}
}
PHP:
format(query, sizeof query, "SELECT DLevel FROM `users` WHERE `PlayerName`='%s' LIMIT 1;", playername3);
mysql_query(query);
mysql_store_result();
new num = mysql_num_rows();
mysql_free_result();
if(!num)
{
query = "INSERT INTO `users` (`PlayerName`,`Key`,`DLevel`,`DExp`,`pSitosti`,`pFerma`,`pFermazarobotok`,`pFermajob`\
,`Level`,`House`,`Bizz`,`AdminLevel`,`Fuelcar`,`Text`,`HP`,`Proverkaip`,`pPhoneBook`,`pDirectory`,`pAlcoholPerk`,`Car`,`Donateschet`,`Donatemoney`\
,`DonateRank`,`Registered`,`Sex`,`pArrested`,`Muted`,`Crimes`,`Respect`,`TaxiExp`,`TaxiLvl`,`Money`,`Kills`\
,`Deaths`,`Paycheck`,`Jailed`,`Cheat`,`JailTime`,`Materials`,`Drugs`,`Leader`,`Member`,`Rank`,`Job`,`Fish`";
format(query, sizeof query, "%s,`VodPrava`,`BizLic`,`FlyLic`,`BoatLic`,`FishLic`,`GunLic`,`Slot1`,`Slot2`,`Slot3`,`Slot4`,`Slot5`,`Slot6`,`Slot7`\
,`Slot8`,`Slot9`,`Slot10`,`Slot11`,`Slotammo2`,`Slotammo3`,`Slotammo4`,`Slotammo5`,`Slotammo6`,`Slotammo7`\
,`Slotammo8`,`Slotammo9`,`Slotammo10`,`Gun0`,`Gun1`,`Gun2`,`Gun3`,`Gun4`,`Gun5`,`Gun6`,`Gun7`,`Gun8`,`Gun9`\
,`Gun10`,`Gun11`,`Ammo0`,`Ammo1`,`Ammo2`,`Ammo3`,`Ammo4`,`Ammo5`,`Ammo6`,`Ammo7`,`Ammo8`,`Ammo9`,`Ammo10`,`Ammo11`", query);
format(query, sizeof query, "%s,`SDPistol`,`DesertEagle`,`ShotGun`,`MP5`,`AK47`,`M4`,`Char`,`pSHealth`,`pHealth`,`Int`,`Local`,`Model`,`PhoneNr`\
,`PayDay`,`PayDayHad`,`Tutorial`,`Warnings`,`unWarns`,`unWarnstime`,`Fuel`,`Married`,`pDrugmoney`,`pGrib`,`MuteTime`\
,`Mobile`,`Bank`,`Ban`,`Krisha`,`UseKrisha`,`Dolg`,`BoxSkill`,`KongfuSkill`,`KickboxSkill`,`Proezd`,`Rp`", query);
format(query, sizeof query, "%s,`pDostup`,`Zakonop`,`Mats`,`NarcoLomka`,`Proz`,`SDPlayer`,`VozdKrisha`,`VozdKapot`,`Wheels`,`PaintJob`\
,`Spoiler`,`ForwBamp`,`BackBamp`,`Color1`,`Nitro`,`Hydraulica`,`pAvtomas`,`pMestoJail`,`Voennik`,`Zvonok`\
,`Zvyozdi`,`Housecash`,`Ogran`,`Shlem`,`Max`) VALUES ('%s','%s','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%.4f','%d','%d','%d','%d','%d'",
query, playername3, password,
PlayerInfo[playerid][pDLevel], PlayerInfo[playerid][pDExp], PlayerInfo[playerid][pSitosti], PlayerInfo[playerid][pFerma], PlayerInfo[playerid][pFermazarobotok], PlayerInfo[playerid][pFermajob], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pPhousekey], PlayerInfo[playerid][pPbiskey], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pFuelcar], PlayerInfo[playerid][pText], PlayerInfo[playerid][pHPs], PlayerInfo[playerid][pProverkaip],
PlayerInfo[playerid][pPhoneBook], PlayerInfo[playerid][pDirectory]);
format(query, sizeof query, "%s ,'%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d'",
query, PlayerInfo[playerid][pAlcoholPerk], PlayerInfo[playerid][pCar], PlayerInfo[playerid][pDonatechet], PlayerInfo[playerid][pDonatemoney], PlayerInfo[playerid][pDonateRank], PlayerInfo[playerid][pReg], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pArrested], PlayerInfo[playerid][pMuted], PlayerInfo[playerid][pCrimes], PlayerInfo[playerid][pExp], PlayerInfo[playerid][ptaxiexp],
PlayerInfo[playerid][ptaxilvl], PlayerInfo[playerid][pCash]);
format(query, sizeof query, "%s ,'%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d'",
query,
PlayerInfo[playerid][pKills],
PlayerInfo[playerid][pDeaths],
PlayerInfo[playerid][pPayCheck],
PlayerInfo[playerid][pJailed],
PlayerInfo[playerid][pCheat],
PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pMats],
PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pRank],
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pFish],
PlayerInfo[playerid][pVodPrava]);
format(query, sizeof query, "%s ,'%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d'",
query,
PlayerInfo[playerid][pBizLic],
PlayerInfo[playerid][pFlyLic],
PlayerInfo[playerid][pBoatLic],
PlayerInfo[playerid][pFishLic],
PlayerInfo[playerid][pGunLic],
PlayerInfo[playerid][pSlot1],
PlayerInfo[playerid][pSlot2],
PlayerInfo[playerid][pSlot3],
PlayerInfo[playerid][pSlot4],
PlayerInfo[playerid][pSlot5],
PlayerInfo[playerid][pSlot6],
PlayerInfo[playerid][pSlot7],
PlayerInfo[playerid][pSlot8],
PlayerInfo[playerid][pSlot9]);
format(query, sizeof query, "%s ,'%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d'",
query,
PlayerInfo[playerid][pSlot10],
PlayerInfo[playerid][pSlot11],
PlayerInfo[playerid][pSlotammo2],
PlayerInfo[playerid][pSlotammo3],
PlayerInfo[playerid][pSlotammo4],
PlayerInfo[playerid][pSlotammo5],
PlayerInfo[playerid][pSlotammo6],
PlayerInfo[playerid][pSlotammo7],
PlayerInfo[playerid][pSlotammo8],
PlayerInfo[playerid][pSlotammo9],
PlayerInfo[playerid][pSlotammo10],
PlayerInfo[playerid][pGun0],
PlayerInfo[playerid][pGun1],
PlayerInfo[playerid][pGun2]);
format(query, sizeof query, "%s ,'%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d'",
query,
PlayerInfo[playerid][pGun3],
PlayerInfo[playerid][pGun4],
PlayerInfo[playerid][pGun5],
PlayerInfo[playerid][pGun6],
PlayerInfo[playerid][pGun7],
PlayerInfo[playerid][pGun8],
PlayerInfo[playerid][pGun9],
PlayerInfo[playerid][pGun10],
PlayerInfo[playerid][pGun11],
PlayerInfo[playerid][pAmmo0],
PlayerInfo[playerid][pAmmo1],
PlayerInfo[playerid][pAmmo2],
PlayerInfo[playerid][pAmmo3],
PlayerInfo[playerid][pAmmo4]);
format(query, sizeof query, "%s ,'%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d'",
query,
PlayerInfo[playerid][pAmmo5],
PlayerInfo[playerid][pAmmo6],
PlayerInfo[playerid][pAmmo7],
PlayerInfo[playerid][pAmmo8],
PlayerInfo[playerid][pAmmo9],
PlayerInfo[playerid][pAmmo10],
PlayerInfo[playerid][pAmmo11],
0,
0,
0,
0,
0,
0,
PlayerInfo[playerid][pChar]);
format(query, sizeof query, "%s ,'%.4f','%.4f','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d'",
query,
PlayerInfo[playerid][pSHealth],
PlayerInfo[playerid][pHealth],
PlayerInfo[playerid][pInt],
PlayerInfo[playerid][pLocal],
PlayerInfo[playerid][pModel],
PlayerInfo[playerid][pPnumber],
PlayerInfo[playerid][pPayDay],
PlayerInfo[playerid][pPayDayHad],
PlayerInfo[playerid][pTut],
PlayerInfo[playerid][pWarns],
PlayerInfo[playerid][punWarns],
PlayerInfo[playerid][punWarnstime],
PlayerInfo[playerid][pFuel],
PlayerInfo[playerid][pMarried]);
format(query, sizeof query, "%s ,'%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d'",
query,
PlayerInfo[playerid][pDrugmoney],
PlayerInfo[playerid][pGrib],
PlayerInfo[playerid][pMuteTime],
PlayerInfo[playerid][pMobile],
PlayerInfo[playerid][pBank],
PlayerInfo[playerid][pLocked],
PlayerInfo[playerid][pKrisha],
PlayerInfo[playerid][pUseKrisha],
PlayerInfo[playerid][pDolg],
PlayerInfo[playerid][pBoxSkill],
PlayerInfo[playerid][pKongfuSkill],
PlayerInfo[playerid][pKickboxSkill],
PlayerInfo[playerid][pProezd],
PlayerInfo[playerid][pRp]);
format(query, sizeof query, "%s ,'%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d'",
query,
PlayerInfo[playerid][pDostup],
PlayerInfo[playerid][pZakonp],
PlayerInfo[playerid][pMats],
PlayerInfo[playerid][pNarcoLomka],
PlayerInfo[playerid][pProz],
PlayerInfo[playerid][pSDPlayer],
PlayerInfo[playerid][pVozduho1],
PlayerInfo[playerid][pVozduho2],
PlayerInfo[playerid][pKolesocar],
PlayerInfo[playerid][pPokraska],
PlayerInfo[playerid][pSpoiler],
PlayerInfo[playerid][pBamper1],
PlayerInfo[playerid][pBamper2],
PlayerInfo[playerid][pCvet]);
format(query, sizeof query, "%s ,'%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d');",
query,
PlayerInfo[playerid][pNitro],
PlayerInfo[playerid][pGidra],
PlayerInfo[playerid][pAvtomas],
PlayerInfo[playerid][pMestoJail],
PlayerInfo[playerid][pVoennik],
PlayerInfo[playerid][pZvonok],
PlayerInfo[playerid][pZvezdi],
PlayerInfo[playerid][pHousecash],
PlayerInfo[playerid][pOgran],
PlayerInfo[playerid][pShlem],
PlayerInfo[playerid][pMax]);
mysql_query(query);
PlayerInfo[playerid][pProz] = 100;
new year, month,day;
getdate(year, month, day);
new currentip[32];
GetPlayerIp(playerid, currentip, 32);
format(query, sizeof query, "UPDATE `users` SET `Registered`='1', `pDateReg`='%d/%d/%d', `pIpReg`='%s' WHERE `PlayerName`='%s' LIMIT 1;",day,month,year,currentip,playername3);
mysql_query(query);
}
else
{
SendClientMessage(playerid, 0xFF0000FF, "Аккаунт с таким именем уже зарегистрирован!");
Kick(playerid);
return 1;
}
PHP:
format(strstre,sizeof(strstre),"%d/%d/%d",day,month,year);
PlayerInfo[playerid][pCash] = GetSRVMoney(playerid);
format(query, sizeof query, "UPDATE `users` SET `DLevel`='%d'\
,`DExp`='%d'\
,`pSitosti`='%d'\
,`pFerma`='%d'\
,`pFermazarobotok`='%d'\
,`pFermajob`='%d'\
,`Level`='%d'\
,`House`='%d'\
,`Bizz`='%d'\
,`AdminLevel`='%d'\
,`Fuelcar`='%.4f'\
,`Text`='%d'\
,`HP`='%d'\
,`Proverkaip`='%d'\
,`pPhoneBook`='%d'\
,`pDirectory`='%d'\
,`pAlcoholPerk`='%d'\
,`Car`='%d'\
,`Donateschet`='%d'\
,`Donatemoney`='%d'\
,`DonateRank`='%d'\
,`Registered`='%d'\
,`Sex`='%d'\
,`pArrested`='%d'\
,`Muted`='%d'",
PlayerInfo[playerid][pDLevel],
PlayerInfo[playerid][pDExp],
PlayerInfo[playerid][pSitosti],
PlayerInfo[playerid][pFerma],
PlayerInfo[playerid][pFermazarobotok],
PlayerInfo[playerid][pFermajob],
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pPhousekey],
PlayerInfo[playerid][pPbiskey],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pFuelcar],
PlayerInfo[playerid][pText],
PlayerInfo[playerid][pHPs],
PlayerInfo[playerid][pProverkaip],
PlayerInfo[playerid][pPhoneBook],
PlayerInfo[playerid][pDirectory],
PlayerInfo[playerid][pAlcoholPerk],
PlayerInfo[playerid][pCar],
PlayerInfo[playerid][pDonatechet],
PlayerInfo[playerid][pDonatemoney],
PlayerInfo[playerid][pDonateRank],
PlayerInfo[playerid][pReg],
PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pArrested],
PlayerInfo[playerid][pMuted]);
format(query, sizeof query, "%s \
,`Crimes`=%d\
,`Respect`=%d\
,`TaxiExp`=%d\
,`TaxiLvl`=%d\
,`Money`=%d\
,`Kills`=%d\
,`Deaths`=%d\
,`Paycheck`=%d\
,`Jailed`=%d\
,`Cheat`=%d\
,`JailTime`=%d\
,`Materials`=%d\
,`Drugs`=%d\
,`Leader`=%d\
,`Member`=%d\
,`Rank`=%d\
,`Job`=%d\
,`Fish`=%d\
,`VodPrava`=%d\
,`BizLic`=%d\
,`FlyLic`=%d\
,`BoatLic`=%d\
,`FishLic`=%d\
,`GunLic`=%d\
,`Slot1`=%d\
,`Slot2`=%d\
,`Slot3`=%d\
,`Slot4`=%d\
,`Slot5`=%d\
,`Slot6`=%d\
,`Slot7`=%d\
,`Slot8`=%d",
query,
PlayerInfo[playerid][pCrimes],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][ptaxiexp],
PlayerInfo[playerid][ptaxilvl],
PlayerInfo[playerid][pCash],
PlayerInfo[playerid][pKills],
PlayerInfo[playerid][pDeaths],
PlayerInfo[playerid][pPayCheck],
PlayerInfo[playerid][pJailed],
PlayerInfo[playerid][pCheat],
PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pMats],
PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pRank],
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pFish],
PlayerInfo[playerid][pVodPrava],
PlayerInfo[playerid][pBizLic],
PlayerInfo[playerid][pFlyLic],
PlayerInfo[playerid][pBoatLic],
PlayerInfo[playerid][pFishLic],
PlayerInfo[playerid][pGunLic],
PlayerInfo[playerid][pSlot1],
PlayerInfo[playerid][pSlot2],
PlayerInfo[playerid][pSlot3],
PlayerInfo[playerid][pSlot4],
PlayerInfo[playerid][pSlot5],
PlayerInfo[playerid][pSlot6],
PlayerInfo[playerid][pSlot7],
PlayerInfo[playerid][pSlot8]);
format(query, sizeof query, "%s\
,`Slot9`='%d'\
,`Slot10`='%d'\
,`Slot11`='%d'\
,`Slotammo2`='%d'\
,`Slotammo3`='%d'\
,`Slotammo4`='%d'\
,`Slotammo5`='%d'\
,`Slotammo6`='%d'\
,`Slotammo7`='%d'\
,`Slotammo8`='%d'\
,`Slotammo9`='%d'\
,`Slotammo10`='%d'\
,`Gun0`='%d'\
,`Gun1`='%d'\
,`Gun2`='%d'\
,`Gun3`='%d'\
,`Gun4`='%d'\
,`Gun5`='%d'\
,`Gun6`='%d'\
,`Gun7`='%d'\
,`Gun8`='%d'\
,`Gun9`='%d'\
,`Gun10`='%d'\
,`Gun11`='%d'\
,`Ammo0`='%d'\
,`Ammo1`='%d'\
,`Ammo2`='%d'\
,`Ammo3`='%d'\
,`Ammo4`='%d'\
,`Ammo5`='%d'",
query,
PlayerInfo[playerid][pSlot9],
PlayerInfo[playerid][pSlot10],
PlayerInfo[playerid][pSlot11],
PlayerInfo[playerid][pSlotammo2],
PlayerInfo[playerid][pSlotammo3],
PlayerInfo[playerid][pSlotammo4],
PlayerInfo[playerid][pSlotammo5],
PlayerInfo[playerid][pSlotammo6],
PlayerInfo[playerid][pSlotammo7],
PlayerInfo[playerid][pSlotammo8],
PlayerInfo[playerid][pSlotammo9],
PlayerInfo[playerid][pSlotammo10],
/*Gun0*/ PlayerInfo[playerid][pGun0],
/*Gun1*/ PlayerInfo[playerid][pGun1],
/*Gun2*/ PlayerInfo[playerid][pGun2],
/*Gun3*/ PlayerInfo[playerid][pGun3],
/*Gun4*/ PlayerInfo[playerid][pGun4],
/*Gun5*/ PlayerInfo[playerid][pGun5],
/*Gun6*/ PlayerInfo[playerid][pGun6],
/*Gun7*/ PlayerInfo[playerid][pGun7],
/*Gun8*/ PlayerInfo[playerid][pGun8],
/*Gun9*/ PlayerInfo[playerid][pGun9],
/*Gun10*/ PlayerInfo[playerid][pGun10],
/*Gun11*/ PlayerInfo[playerid][pGun11],
/*Ammo0*/ PlayerInfo[playerid][pAmmo0],
/*Ammo1*/ PlayerInfo[playerid][pAmmo1],
/*Ammo2*/ PlayerInfo[playerid][pAmmo2],
/*Ammo3*/ PlayerInfo[playerid][pAmmo3],
/*Ammo4*/ PlayerInfo[playerid][pAmmo4],
/*Ammo5*/ PlayerInfo[playerid][pAmmo5]);
format(query, sizeof query, "%s,`Ammo6`='%d'\
,`Ammo7`='%d'\
,`Ammo8`='%d'\
,`Ammo9`='%d'\
,`Ammo10`='%d'\
,`Ammo11`='%d'\
,`SDPistol`='%d'\
,`DesertEagle`='%d'\
,`ShotGun`='%d'\
,`MP5`='%d'\
,`AK47`='%d'\
,`M4`='%d'\
,`Char`='%d'\
,`pSHealth`='%.4f'\
,`pHealth`='%.4f'\
,`Int`='%d'\
,`Local`='%d'\
,`Model`='%d'\
,`PhoneNr`='%d'\
,`PayDay`='%d'\
,`PayDayHad`='%d'\
,`Tutorial`='%d'\
,`Warnings`='%d'\
,`unWarns`='%d'\
,`unWarnstime`='%d'\
,`Fuel`='%d'\
,`Married`='%d'\
,`pDrugmoney`='%d'\
,`pGrib`='%d'",
query,
PlayerInfo[playerid][pAmmo6],
/*Ammo7*/ PlayerInfo[playerid][pAmmo7],
/*Ammo8*/ PlayerInfo[playerid][pAmmo8],
/*Ammo9*/ PlayerInfo[playerid][pAmmo9],
/*Ammo10*/ PlayerInfo[playerid][pAmmo10],
/*Ammo11*/ PlayerInfo[playerid][pAmmo11],
/*SDPistol*/0,
/*DesertEagle*/0,
/*ShotGun*/0,
/*MP5*/0,
/*AK47*/0,
/*M4*/0,
/*Char*/PlayerInfo[playerid][pChar],
/*pSHealth*/PlayerInfo[playerid][pSHealth],
/*pHealth*/PlayerInfo[playerid][pHealth],
/*Int*/PlayerInfo[playerid][pInt],
/*Local*/PlayerInfo[playerid][pLocal],
/*Model*/PlayerInfo[playerid][pModel],
/*PhoneNr*/PlayerInfo[playerid][pPnumber],
/*PayDay*/PlayerInfo[playerid][pPayDay],
/*PayDayHad*/PlayerInfo[playerid][pPayDayHad],
/*Tutorial*/PlayerInfo[playerid][pTut],
/*Warnings*/PlayerInfo[playerid][pWarns],
/*unWarns*/PlayerInfo[playerid][punWarns],
/*unWarnstime*/PlayerInfo[playerid][punWarnstime],
/*Fuel*/PlayerInfo[playerid][pFuel],
/*Married*/PlayerInfo[playerid][pMarried],
/*pDrugmoney*/PlayerInfo[playerid][pDrugmoney],
/*pGrib*/PlayerInfo[playerid][pGrib]);
format(query, sizeof query, "%s, `MuteTime`='%d'\
,`Mobile`='%d'\
,`Bank`='%d'\
,`Ban`='%d'\
,`Krisha`='%d'\
,`UseKrisha`='%d'\
,`Dolg`='%d'\
,`BoxSkill`='%d'\
,`KongfuSkill`='%d'\
,`KickboxSkill`='%d'\
,`Proezd`='%d'\
,`Rp`='%d'\
,`pDostup`='%d'\
,`Zakonop`='%d'\
,`Mats`='%d'\
,`NarcoLomka`='%d'\
,`Proz`='%d'\
,`SDPlayer`='%d'\
,`VozdKrisha`='%d'\
,`VozdKapot`='%d'\
,`Wheels`='%d'\
,`PaintJob`='%d'\
,`Spoiler`='%d'\
,`ForwBamp`='%d'\
,`BackBamp`='%d'\
,`Color1`='%d'",
query,
PlayerInfo[playerid][pMuteTime],
/*Mobile*/PlayerInfo[playerid][pMobile],
/*Bank*/PlayerInfo[playerid][pBank],
/*Ban*/PlayerInfo[playerid][pLocked],
/*Krisha*/PlayerInfo[playerid][pKrisha],
/*UseKrisha*/PlayerInfo[playerid][pUseKrisha],
/*Dolg*/PlayerInfo[playerid][pDolg],
/*BoxSkill*/PlayerInfo[playerid][pBoxSkill],
/*KongfuSkill*/PlayerInfo[playerid][pKongfuSkill],
/*KickboxSkill*/PlayerInfo[playerid][pKickboxSkill],
/*Proezd*/PlayerInfo[playerid][pProezd],
/*Rp*/PlayerInfo[playerid][pRp],
PlayerInfo[playerid][pDostup],
/*Zakonop*/PlayerInfo[playerid][pZakonp],
/*Mats*/PlayerInfo[playerid][pMats],
/*NarcoLomka*/PlayerInfo[playerid][pNarcoLomka],
/*Proz*/PlayerInfo[playerid][pProz],
/*SDPlayer*/PlayerInfo[playerid][pSDPlayer],
/*Воздухосборник крыша*/PlayerInfo[playerid][pVozduho1],
/*Воздухосборник капот*/PlayerInfo[playerid][pVozduho2],
/*Колёса*/PlayerInfo[playerid][pKolesocar],
/*Покраска*/PlayerInfo[playerid][pPokraska],
/*Спойлер*/PlayerInfo[playerid][pSpoiler],
/*Передний бампер*/PlayerInfo[playerid][pBamper1],
/*Задний бампер*/PlayerInfo[playerid][pBamper2],
/*Цвет*/PlayerInfo[playerid][pCvet]);
format(query, sizeof query, "%s,`Nitro`='%d'\
,`Hydraulica`='%d'\
,`pAvtomas`='%d'\
,`pMestoJail`='%d'\
,`Voennik`='%d'\
,`Zvonok`='%d'\
,`Zvyozdi`='%d'\
,`Housecash`='%d'\
,`Ogran`='%d'\
,`Shlem`='%d'\
,`Max`='%d'\
,`pFerma`='%d'\
,`pFermazarobotok`='%d'\
,`pFermajob`='%d'\
WHERE `ID`='%d';",
query,
PlayerInfo[playerid][pNitro],
PlayerInfo[playerid][pGidra],
PlayerInfo[playerid][pAvtomas],
PlayerInfo[playerid][pMestoJail],
PlayerInfo[playerid][pVoennik],
PlayerInfo[playerid][pZvonok],
PlayerInfo[playerid][pZvezdi],
PlayerInfo[playerid][pHousecash],
PlayerInfo[playerid][pOgran],
PlayerInfo[playerid][pShlem],
PlayerInfo[playerid][pMax],
PlayerInfo[playerid][pFerma],
PlayerInfo[playerid][pFermazarobotok],
PlayerInfo[playerid][pFermajob],
SqlID[playerid]);
mysql_query(query);
query="";
new string2[256];
Последнее редактирование: