Сергей|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;
}