cthuj
Новичок
Здравствуйте, при регистрации аккаунт не сохраняется в БД, сохраняется только Логин и Пароль. Помогите решить пожалуйста.
Первый пункт регистрации:
Пред-последний пункт регистрации:
ПОследний пункт регитсрации
Паблик "OnPlayerRegister":
И вот OnPlayerLoginToServer:
Напоминаю, Имя и Пароль сохраняет.
P.S До недавнего времени все работало... Может проблемма в БД?
Первый пункт регистрации:
PHP:
case 2:
{
new name[MAX_PLAYER_NAME];
GetPlayerName(playerid, name, sizeof(name));
GetPlayerName(playerid, playername, sizeof(playername));
if(response)
{
if(!strlen(inputtext))
{
format(string,256, "{ffffff}Добро пожаловать на сервер: {6495ED}Ralf RolePlay.\n{ffffff}Для игры на нашем сервере нужно пройти регистрацию\n\n{ffffff}Логин: {6495ED}%s\n{ffffff}Введите пароль:", name);
ShowPlayerDialogEx(playerid,2,DIALOG_STYLE_INPUT, "{FFFFFF}Регистрация",string, "Готово", "Отмена");
return true;
}
if(!strlen(inputtext) || strlen(inputtext) < 6 || strlen(inputtext) > 15)
{
return ShowPlayerDialogEx(playerid,2,DIALOG_STYLE_MSGBOX, "Ошибка!", "{FF6347}Длина пароля должна быть от 6 до 15 символов", "Повтор", "");
}
for(new i = strlen(inputtext); i != 0; --i)
switch(inputtext[i])
{
case 'А'..'Я', 'а'..'я', ' ':
return ShowPlayerDialogEx(playerid,2,DIALOG_STYLE_MSGBOX, "Ошибка!", "{00FF21}Введенный вами пароль содержит русские буквы.\n Смените раскладку клавиатуры!", "Повтор", "");
}
new str[228];
format(str, sizeof(str), "INSERT INTO `accounts` (`Name`, `pKey`) VALUES ('%s', '%s')", Name(playerid),inputtext);
mysql_query(str);
PlayerPlaySound(playerid, 1097, 0.0, 0.0, 0.0);
new rulesdialog[1300];
format(rulesdialog,sizeof(rulesdialog), "%s%s%s%s%s%s%s%s%s%s%s%s%s%s%s%s%s",
RulesMSG[0],RulesMSG[1],RulesMSG[2],RulesMSG[3],RulesMSG[4],RulesMSG[5],RulesMSG[6],RulesMSG[7],RulesMSG[8],RulesMSG[9],RulesMSG[10],RulesMSG[11],RulesMSG[12],RulesMSG[13],RulesMSG[14],RulesMSG[15],RulesMSG[16]);
ShowPlayerDialogEx(playerid,12,DIALOG_STYLE_MSGBOX, "[1/4] Правила сервера", rulesdialog, "Согласен", "Выйти");
strmid(PlayerInfo[playerid][pKey], inputtext, 0, strlen(inputtext), strlen(inputtext)+5);
return true;
}
else
{
SendClientMessage(playerid, COLOR_LIGHTRED, "Для выхода из игры используйте /q(uit)");
Kick(playerid);
}
}
PHP:
case 1945:
{
if(response)
{
if(strlen(inputtext) > 5 && strfind(inputtext, "@", true) != -1 && strfind(inputtext, ".", true) != -1)
{
ShowPlayerDialogEx(playerid,2625,DIALOG_STYLE_INPUT, "[4/4] По приглашению от:", "Введите ник игрока, пригласившиго вас на сервер", "Далее", "Пропуск");
PlayerInfo[playerid][pEmail] = strval(inputtext);
strmid (PlayerInfo[playerid][pEmail], inputtext, 0, strlen(inputtext),strlen(inputtext)+5);
}
else
{
ShowPlayerDialogEx(playerid,2625,DIALOG_STYLE_INPUT, "[4/4] По приглашению от:", "Введите ник игрока, пригласившиго вас на сервер", "Далее", "Пропуск");
}
}
else
{
ShowPlayerDialogEx(playerid,2625,DIALOG_STYLE_INPUT, "[4/4] По приглашению от:", "Введите ник игрока, пригласившиго вас на сервер", "Далее", "Пропуск");
}
return true;
}
PHP:
case 2625:
{
if(response)
{
PlayerInfo[playerid][pDrug] = strval(inputtext);
strmid (PlayerInfo[playerid][pDrug], inputtext, 0, strlen(inputtext), strlen(inputtext)+5);
OnPlayerRegister(playerid,PlayerInfo[playerid][pKey]);
return true;
}
else OnPlayerRegister(playerid,PlayerInfo[playerid][pKey]);
}
PHP:
[B]public [/B][B]OnPlayerRegister(playerid, password[])
[/B]{
new string[128];
new query[2700];
if(IsPlayerConnected(playerid))
{
query = "UPDATE `accounts` SET ";
acc_int_strcat(query, sizeof(query), "pLevel",5);
acc_int_strcat(query, sizeof(query), "pPhousekey",999);
acc_int_strcat(query, sizeof(query), "pPbiskey",255);
acc_int_strcat(query, sizeof(query), "pAdmin",0);
acc_int_strcat(query, sizeof(query), "pHelper",0);
acc_int_strcat(query, sizeof(query), "pForma",0);
acc_int_strcat(query, sizeof(query), "pJobHeal",0);
acc_int_strcat(query, sizeof(query), "pJobHealLeader",0);
acc_float_strcat(query, sizeof(query), "pFuelcar",300);
acc_int_strcat(query, sizeof(query), "pText",0);
acc_int_strcat(query, sizeof(query), "pPodarok1",0);
acc_int_strcat(query, sizeof(query), "pPodarok2",0);
acc_int_strcat(query, sizeof(query), "pHP",100);
acc_int_strcat(query, sizeof(query), "pSatiety",100);
acc_int_strcat(query, sizeof(query), "pCheckip",0);
acc_int_strcat(query, sizeof(query), "pPhoneBook",0);
acc_int_strcat(query, sizeof(query), "pDirectory",0);
acc_int_strcat(query, sizeof(query), "pAlcoholPerk",0);
acc_int_strcat(query, sizeof(query), "pCar",462);
acc_int_strcat(query, sizeof(query), "pDonatechet",0);
acc_int_strcat(query, sizeof(query), "pDonatemoney",300);
acc_int_strcat(query, sizeof(query), "pDonateRank",0);
acc_int_strcat(query, sizeof(query), "pReg", 0);
acc_int_strcat(query, sizeof(query), "pSex", PlayerInfo[playerid][pSex]);
acc_int_strcat(query, sizeof(query), "pArrested",0);
acc_int_strcat(query, sizeof(query), "pMuted",0);
acc_int_strcat(query, sizeof(query), "pCrimes",0);
acc_int_strcat(query, sizeof(query), "pExp",0);
acc_int_strcat(query, sizeof(query), "pCash",3000000);
acc_int_strcat(query, sizeof(query), "pKills",0);
acc_int_strcat(query, sizeof(query), "pDeaths",0);
acc_int_strcat(query, sizeof(query), "pPayCheck",0);
acc_int_strcat(query, sizeof(query), "pJailed",0);
acc_int_strcat(query, sizeof(query), "pCheat",0);
acc_int_strcat(query, sizeof(query), "pJailTime",0);
acc_int_strcat(query, sizeof(query), "pMats",0);
acc_int_strcat(query, sizeof(query), "pDrugs",0);
acc_int_strcat(query, sizeof(query), "pLeader",0);
acc_int_strcat(query, sizeof(query), "pMember",0);
acc_int_strcat(query, sizeof(query), "pRank",0);
acc_int_strcat(query, sizeof(query), "pJob",0);
acc_int_strcat(query, sizeof(query), "pCarLic",1);
acc_int_strcat(query, sizeof(query), "pBizLic",0);
acc_int_strcat(query, sizeof(query), "pFlyLic",0);
acc_int_strcat(query, sizeof(query), "pBoatLic",0);
acc_int_strcat(query, sizeof(query), "pFishLic",0);
acc_int_strcat(query, sizeof(query), "pGunLic",0);
acc_int_strcat(query, sizeof(query), "pSlot1",0);
acc_int_strcat(query, sizeof(query), "pSlot2",0);
acc_int_strcat(query, sizeof(query), "pSlot3",0);
acc_int_strcat(query, sizeof(query), "pSlot4", PlayerInfo[playerid][pSlot4]);
acc_int_strcat(query, sizeof(query), "pSlot5", PlayerInfo[playerid][pSlot5]);
acc_int_strcat(query, sizeof(query), "pSlot6", PlayerInfo[playerid][pSlot6]);
acc_int_strcat(query, sizeof(query), "pSlot7", PlayerInfo[playerid][pSlot7]);
acc_int_strcat(query, sizeof(query), "pSlot8", PlayerInfo[playerid][pSlot8]);
acc_int_strcat(query, sizeof(query), "pSlot9", PlayerInfo[playerid][pSlot9]);
acc_int_strcat(query, sizeof(query), "pSlot10", PlayerInfo[playerid][pSlot10]);
acc_int_strcat(query, sizeof(query), "pSlot11", PlayerInfo[playerid][pSlot11]);
acc_int_strcat(query, sizeof(query), "pSlotammo1", PlayerInfo[playerid][pSlotammo1]);
acc_int_strcat(query, sizeof(query), "pSlotammo2", PlayerInfo[playerid][pSlotammo2]);
acc_int_strcat(query, sizeof(query), "pSlotammo3", PlayerInfo[playerid][pSlotammo3]);
acc_int_strcat(query, sizeof(query), "pSlotammo4", PlayerInfo[playerid][pSlotammo4]);
acc_int_strcat(query, sizeof(query), "pSlotammo5", PlayerInfo[playerid][pSlotammo5]);
acc_int_strcat(query, sizeof(query), "pSlotammo6", PlayerInfo[playerid][pSlotammo6]);
acc_int_strcat(query, sizeof(query), "pSlotammo7", PlayerInfo[playerid][pSlotammo7]);
acc_int_strcat(query, sizeof(query), "pSlotammo8", PlayerInfo[playerid][pSlotammo8]);
acc_int_strcat(query, sizeof(query), "pSlotammo9", PlayerInfo[playerid][pSlotammo9]);
acc_int_strcat(query, sizeof(query), "pSlotammo10", PlayerInfo[playerid][pSlotammo10]);
acc_int_strcat(query, sizeof(query), "pSlotammo11", PlayerInfo[playerid][pSlotammo11]);
acc_int_strcat(query, sizeof(query), "pGunSkill1", 0);
acc_int_strcat(query, sizeof(query), "pGunSkill2", 0);
acc_int_strcat(query, sizeof(query), "pGunSkill3", 0);
acc_int_strcat(query, sizeof(query), "pGunSkill4", 0);
acc_int_strcat(query, sizeof(query), "pGunSkill5", 0);
acc_int_strcat(query, sizeof(query), "pGunSkill6", 0);
acc_int_strcat(query, sizeof(query), "ptaxiexp",0);
acc_int_strcat(query, sizeof(query), "ptaxilvl",0);
acc_int_strcat(query, sizeof(query), "pDLevel",0);
acc_int_strcat(query, sizeof(query), "pDExp",0);
acc_int_strcat(query, sizeof(query), "pDMgruz",0);
acc_int_strcat(query, sizeof(query), "pDgruz",0);
acc_int_strcat(query, sizeof(query), "pKazpay",0);
acc_int_strcat(query, sizeof(query), "pChar",0);
acc_int_strcat(query, sizeof(query), "pChar1",0);
acc_int_strcat(query, sizeof(query), "pChar2",0);
acc_int_strcat(query, sizeof(query), "pViborChar",0);
acc_float_strcat(query, sizeof(query), "pSHealth",100);
acc_float_strcat(query, sizeof(query), "pHealth",100);
acc_int_strcat(query, sizeof(query), "pInt",0);
acc_int_strcat(query, sizeof(query), "pLocal",255);
acc_int_strcat(query, sizeof(query), "pModel",0);
acc_int_strcat(query, sizeof(query), "pPnumber",Random(100000,999999));
acc_int_strcat(query, sizeof(query), "pPayDay",0);
acc_int_strcat(query, sizeof(query), "pPayDayHad",0);
acc_int_strcat(query, sizeof(query), "pTut",0);
acc_int_strcat(query, sizeof(query), "pWarns",0);
acc_int_strcat(query, sizeof(query), "punWarns",0);
acc_int_strcat(query, sizeof(query), "punWarnstime",0);
acc_int_strcat(query, sizeof(query), "pFuel",0);
acc_int_strcat(query, sizeof(query), "pMarried",0);
acc_str_strcat(query, sizeof(query), "pMarriedTo","-");
acc_str_strcat(query, sizeof(query), "pDrug",PlayerInfo[playerid][pDrug]);
acc_int_strcat(query, sizeof(query), "pMushrooms",0);
acc_int_strcat(query, sizeof(query), "pFishes",0);
acc_int_strcat(query, sizeof(query), "pMuteTime",0);
acc_int_strcat(query, sizeof(query), "pMobile",0);
acc_int_strcat(query, sizeof(query), "pBank",0);
acc_int_strcat(query, sizeof(query), "pLocked",0);
acc_int_strcat(query, sizeof(query), "pBanDay",0);
acc_int_strcat(query, sizeof(query), "pBanMounth",0);
acc_int_strcat(query, sizeof(query), "pKrisha",0);
acc_int_strcat(query, sizeof(query), "pUseKrisha",0);
acc_int_strcat(query, sizeof(query), "pDolg",0);
acc_int_strcat(query, sizeof(query), "pBoxSkill",0);
acc_int_strcat(query, sizeof(query), "pKongfuSkill",0);
acc_int_strcat(query, sizeof(query), "pKickboxSkill",0);
acc_str_strcat(query, sizeof(query), "pDostup","ertiengfj");
acc_int_strcat(query, sizeof(query), "pZakonp",0);
acc_int_strcat(query, sizeof(query), "pAddiction",0);
acc_int_strcat(query, sizeof(query), "pMats",0);
acc_int_strcat(query, sizeof(query), "pNarcoLomka",0);
acc_int_strcat(query, sizeof(query), "pProcents",100);
acc_int_strcat(query, sizeof(query), "pWheels",0);
acc_int_strcat(query, sizeof(query), "pPaintJob",0);
acc_int_strcat(query, sizeof(query), "pSpoiler",0);
acc_int_strcat(query, sizeof(query), "pBumper1",0);
acc_int_strcat(query, sizeof(query), "pBumper2",0);
acc_int_strcat(query, sizeof(query), "pColor1",0);
acc_int_strcat(query, sizeof(query), "pColor2",0);
acc_int_strcat(query, sizeof(query), "pNitro",0);
acc_int_strcat(query, sizeof(query), "pHydrawlic",0);
acc_int_strcat(query, sizeof(query), "pAvtomas",255);
acc_int_strcat(query, sizeof(query), "pMestoJail",0);
acc_int_strcat(query, sizeof(query), "pSong",0);
acc_int_strcat(query, sizeof(query), "pHousecash",0);
acc_int_strcat(query, sizeof(query), "pKvartiraKey",0);
acc_int_strcat(query, sizeof(query), "pWantedLevel",0);
acc_int_strcat(query, sizeof(query), "pChas",0);
acc_int_strcat(query, sizeof(query), "pMin",0);
acc_int_strcat(query, sizeof(query), "pSkilla",0);
acc_str_strcat(query, sizeof(query), "pEmail", PlayerInfo[playerid][pEmail]);
new playersip[64];
GetPlayerIp(playerid,playersip,sizeof(playersip));
new year, month, day;
getdate(year, month, day);
new strstre[50];
new sendername[MAX_PLAYER_NAME];
GetPlayerName(playerid,sendername,sizeof(sendername));
format(strstre,sizeof(strstre), "%d/%d/%d",day,month,year);
acc_str_strcat(query, sizeof(query), "pOnline", strstre);
acc_str_strcat(query, sizeof(query), "pvIp", playersip);
acc_str_strcat(query, sizeof(query), "pDataReg", strstre);
acc_str_strcat(query, sizeof(query), "pIpReg", playersip);
format(strstre,sizeof(strstre), "%d:%d",PlayerInfo[playerid][pChas],PlayerInfo[playerid][pMin]);
acc_str_strcat(query, sizeof(query), "pOnlineLid", strstre);
strdel(query, strlen(query)-1, strlen(query));
format(string,sizeof(string)," WHERE `Name` = '%s'",sendername);
strcat(query, string);
mysql_query(query);
OnPlayerLoginToServer(playerid);
}
return true;
}
PHP:
static stock [B]OnPlayerLoginToServer(playerid)
[/B]{
new tmp2[256];
new string[300];
new playername2[MAX_PLAYER_NAME];
format(string, sizeof(string), "SELECT * FROM `accounts` WHERE name = '%s'",Name(playerid));
mysql_query(string);
mysql_store_result();
if(mysql_fetch_row_format(string))
{
BaseGetInt("pID", PlayerIDs[playerid]); BaseGetInt("pLevel", PlayerInfo[playerid][pLevel]); BaseGetInt("pPhousekey", PlayerInfo[playerid][pPhousekey]);
BaseGetInt("pPbiskey", PlayerInfo[playerid][pPbiskey]); BaseGetInt("pAdmin", PlayerInfo[playerid][pAdmin]); BaseGetInt("pHelper", PlayerInfo[playerid][pHelper]);
BaseGetInt("pForma", PlayerInfo[playerid][pForma]); BaseGetInt("pJobHeal", PlayerInfo[playerid][pJobHeal]); BaseGetInt("pJobHealLeader", PlayerInfo[playerid][pJobHealLeader]);
BaseGetFloat("pFuelcar", PlayerInfo[playerid][pFuelcar]); BaseGetInt("pText", PlayerInfo[playerid][pText]); BaseGetInt("pPodarok1", PlayerInfo[playerid][pPodarok][0]);
BaseGetInt("pPodarok2", PlayerInfo[playerid][pPodarok][1]); BaseGetInt("pHP", PlayerInfo[playerid][pHP]); BaseGetInt("pSatiety", PlayerInfo[playerid][pSatiety]);
BaseGet("pKeyip", PlayerInfo[playerid][pKeyip]); BaseGet("pEmail", PlayerInfo[playerid][pEmail]); BaseGetInt("pCheckip", PlayerInfo[playerid][pCheckip]);
BaseGetInt("pReg", PlayerInfo[playerid][pReg]); BaseGetInt("pTut", PlayerInfo[playerid][pTut]); BaseGetInt("pGod", PlayerInfo[playerid][pGod]);
BaseGetInt("pMes", PlayerInfo[playerid][pMes]); BaseGet("pDataReg", PlayerInfo[playerid][pDataReg]); BaseGetInt("pVhoddata", PlayerInfo[playerid][pVhoddata]);
BaseGetInt("pVhodMes", PlayerInfo[playerid][pVhodMes]); BaseGetInt("pVhodchas", PlayerInfo[playerid][pVhodchas]); BaseGetInt("pVhodminute", PlayerInfo[playerid][pVhodminute]);
BaseGetInt("pPhoneBook", PlayerInfo[playerid][pPhoneBook]); BaseGetInt("pDirectory", PlayerInfo[playerid][pDirectory]); BaseGetInt("pAlcoholPerk", PlayerInfo[playerid][pAlcoholPerk]);
BaseGet("pIp", PlayerInfo[playerid][pIp]); BaseGet("pvIp", PlayerInfo[playerid][pvIp]); BaseGet("pIpReg", PlayerInfo[playerid][pIpReg]);
BaseGetInt("pCar", PlayerInfo[playerid][pCar]); BaseGetInt("pDonatechet", PlayerInfo[playerid][pDonatechet]); BaseGetInt("pDonatemoney", PlayerInfo[playerid][pDonatemoney]);
BaseGetInt("pDonateRank", PlayerInfo[playerid][pDonateRank]); BaseGetInt("pSex", PlayerInfo[playerid][pSex]); BaseGetInt("pArrested", PlayerInfo[playerid][pArrested]);
BaseGetInt("pMuted", PlayerInfo[playerid][pMuted]); BaseGetInt("pCrimes", PlayerInfo[playerid][pCrimes]); BaseGetInt("pExp", PlayerInfo[playerid][pExp]);
BaseGetInt("pCash", PlayerInfo[playerid][pCash]); BaseGetInt("pKills", PlayerInfo[playerid][pKills]); BaseGetInt("pDeaths", PlayerInfo[playerid][pDeaths]);
BaseGetInt("pPayCheck", PlayerInfo[playerid][pPayCheck]); BaseGetInt("pJailed", PlayerInfo[playerid][pJailed]); BaseGetInt("pCheat", PlayerInfo[playerid][pCheat]);
BaseGetInt("pJailTime", PlayerInfo[playerid][pJailTime]); BaseGetInt("pMats", PlayerInfo[playerid][pMats]); BaseGetInt("pDrugs", PlayerInfo[playerid][pDrugs]);
BaseGetInt("pLeader", PlayerInfo[playerid][pLeader]); BaseGetInt("pMember", PlayerInfo[playerid][pMember]); BaseGetInt("pRank", PlayerInfo[playerid][pRank]);
BaseGetInt("pJob", PlayerInfo[playerid][pJob]); BaseGetInt("pCarLic", PlayerInfo[playerid][pCarLic]); BaseGetInt("pBizLic", PlayerInfo[playerid][pBizLic]);
BaseGetInt("pFlyLic", PlayerInfo[playerid][pFlyLic]); BaseGetInt("pBoatLic", PlayerInfo[playerid][pBoatLic]); BaseGetInt("pFishLic", PlayerInfo[playerid][pFishLic]);
BaseGetInt("pGunLic", PlayerInfo[playerid][pGunLic]); BaseGetInt("pSlot1", PlayerInfo[playerid][pSlot1]); BaseGetInt("pSlot2", PlayerInfo[playerid][pSlot2]);
BaseGetInt("pSlot3", PlayerInfo[playerid][pSlot3]); BaseGetInt("pSlot4", PlayerInfo[playerid][pSlot4]); BaseGetInt("pSlot5", PlayerInfo[playerid][pSlot5]);
BaseGetInt("pSlot6", PlayerInfo[playerid][pSlot6]); BaseGetInt("pSlot7", PlayerInfo[playerid][pSlot7]); BaseGetInt("pSlot8", PlayerInfo[playerid][pSlot8]);
BaseGetInt("pSlot9", PlayerInfo[playerid][pSlot9]); BaseGetInt("pSlot10", PlayerInfo[playerid][pSlot10]); BaseGetInt("pSlot11", PlayerInfo[playerid][pSlot11]);
BaseGetInt("pSlotammo1", PlayerInfo[playerid][pSlotammo1]); BaseGetInt("pSlotammo2", PlayerInfo[playerid][pSlotammo2]); BaseGetInt("pSlotammo3", PlayerInfo[playerid][pSlotammo3]);
BaseGetInt("pSlotammo4", PlayerInfo[playerid][pSlotammo4]); BaseGetInt("pSlotammo5", PlayerInfo[playerid][pSlotammo5]); BaseGetInt("pSlotammo6", PlayerInfo[playerid][pSlotammo6]);
BaseGetInt("pSlotammo7", PlayerInfo[playerid][pSlotammo7]); BaseGetInt("pSlotammo8", PlayerInfo[playerid][pSlotammo8]); BaseGetInt("pSlotammo9", PlayerInfo[playerid][pSlotammo9]);
BaseGetInt("pSlotammo10", PlayerInfo[playerid][pSlotammo10]); BaseGetInt("pSlotammo11", PlayerInfo[playerid][pSlotammo11]); BaseGetInt("pGunSkill1", PlayerInfo[playerid][pGunSkill][0]);
BaseGetInt("pGunSkill2", PlayerInfo[playerid][pGunSkill][1]); BaseGetInt("pGunSkill3", PlayerInfo[playerid][pGunSkill][2]); BaseGetInt("pGunSkill4", PlayerInfo[playerid][pGunSkill][3]);
BaseGetInt("pGunSkill5", PlayerInfo[playerid][pGunSkill][4]); BaseGetInt("pGunSkill6", PlayerInfo[playerid][pGunSkill][5]); BaseGetInt("ptaxiexp", PlayerInfo[playerid][ptaxiexp]);
BaseGetInt("ptaxilvl", PlayerInfo[playerid][ptaxilvl]); BaseGetInt("pDLevel", PlayerInfo[playerid][pDLevel]); BaseGetInt("pDExp", PlayerInfo[playerid][pDExp]);
BaseGetInt("pDMgruz", PlayerInfo[playerid][pDMgruz]); BaseGetInt("pDgruz", PlayerInfo[playerid][pDgruz]); BaseGetInt("pKazpay", PlayerInfo[playerid][pKazpay]);
BaseGetInt("pChar", PlayerInfo[playerid][pChar][0]); BaseGetInt("pChar1", PlayerInfo[playerid][pChar][1]); BaseGetInt("pChar2", PlayerInfo[playerid][pChar][2]);
BaseGetInt("pViborChar", PlayerInfo[playerid][pViborChar]); BaseGetFloat("pSHealth", PlayerInfo[playerid][pSHealth]); BaseGetFloat("pHealth", PlayerInfo[playerid][pHealth]);
BaseGetInt("pInt", PlayerInfo[playerid][pInt]); BaseGetInt("pLocal", PlayerInfo[playerid][pLocal]); BaseGetInt("pModel", PlayerInfo[playerid][pModel]);
BaseGetInt("pPnumber", PlayerInfo[playerid][pPnumber]); BaseGetInt("pPayDay", PlayerInfo[playerid][pPayDay]); BaseGetInt("pPayDayHad", PlayerInfo[playerid][pPayDayHad]);
BaseGetInt("pWarns", PlayerInfo[playerid][pWarns]); BaseGetInt("punWarns", PlayerInfo[playerid][punWarns]); BaseGetInt("punWarnstime", PlayerInfo[playerid][punWarnstime]);
BaseGetInt("pFuel", PlayerInfo[playerid][pFuel]); BaseGetInt("pMarried", PlayerInfo[playerid][pMarried]); BaseGet("pDrug", PlayerInfo[playerid][pDrug]);
BaseGet("pMarriedTo", PlayerInfo[playerid][pMarriedTo]); BaseGetInt("pMushrooms", PlayerInfo[playerid][pMushrooms]); BaseGetInt("pMuteTime", PlayerInfo[playerid][pMuteTime]);
BaseGetInt("pMobile", PlayerInfo[playerid][pMobile]); BaseGetInt("pBank", PlayerInfo[playerid][pBank]); BaseGetInt("pLocked", PlayerInfo[playerid][pLocked]);
BaseGetInt("pBanDay", PlayerInfo[playerid][pBanDay]); BaseGetInt("pBanMounth", PlayerInfo[playerid][pBanMounth]); BaseGetInt("pDolg", PlayerInfo[playerid][pDolg]);
BaseGetInt("pKrisha", PlayerInfo[playerid][pKrisha]); BaseGetInt("pUseKrisha", PlayerInfo[playerid][pUseKrisha]); BaseGetInt("pBoxSkill", PlayerInfo[playerid][pBoxSkill]);
BaseGetInt("pKongfuSkill", PlayerInfo[playerid][pKongfuSkill]); BaseGetInt("pKickboxSkill", PlayerInfo[playerid][pKickboxSkill]); BaseGet("pDostup", PlayerInfo[playerid][pDostup]);
BaseGetInt("pFishes", PlayerInfo[playerid][pFishes]); BaseGetInt("pZakonp", PlayerInfo[playerid][pZakonp]); BaseGetInt("pAddiction", PlayerInfo[playerid][pAddiction]);
BaseGetInt("pNarcoLomka", PlayerInfo[playerid][pNarcoLomka]); BaseGetInt("pProcents", PlayerInfo[playerid][pProcents]); BaseGetInt("pWheels", PlayerInfo[playerid][pWheels]);
BaseGetInt("pPaintJob", PlayerInfo[playerid][pPaintJob]); BaseGetInt("pSpoiler", PlayerInfo[playerid][pSpoiler]); BaseGetInt("pBumper1", PlayerInfo[playerid][pBumper1]);
BaseGetInt("pBumper2", PlayerInfo[playerid][pBumper2]); BaseGetInt("pColor1", PlayerInfo[playerid][pColor][0]); BaseGetInt("pColor2", PlayerInfo[playerid][pColor][1]);
BaseGetInt("pNitro", PlayerInfo[playerid][pNitro]); BaseGetInt("pHydrawlic", PlayerInfo[playerid][pHydrawlic]); BaseGetInt("pAvtomas", PlayerInfo[playerid][pAvtomas]);
BaseGetInt("pMestoJail", PlayerInfo[playerid][pMestoJail]); BaseGetInt("pSong", PlayerInfo[playerid][pSong]); BaseGetInt("pHousecash", PlayerInfo[playerid][pHousecash]);
BaseGetInt("pKvartiraKey", PlayerInfo[playerid][pKvartirakey]); BaseGetInt("pWantedLevel", PlayerInfo[playerid][pWantedLevel]); BaseGetInt("pChas", PlayerInfo[playerid][pChas]);
BaseGetInt("pMin", PlayerInfo[playerid][pMin]); BaseGetInt("pSkilla", PlayerInfo[playerid][pSkilla]); mysql_free_result();
PlayerInfo[playerid][pLogin] = 1;
format(string, sizeof(string), "UPDATE accounts SET pLogin = '%d' WHERE name = '%s'",PlayerInfo[playerid][pLogin],Name(playerid));
mysql_query(string);
}
if(PlayerInfo[playerid][pLocked] == 1)
{
if(PlayerInfo[playerid][pBanDay] == 0) ShowPlayerDialogEx(playerid,69,DIALOG_STYLE_MSGBOX, "{B20000}Внимание","{FF6347}Этот аккаунт заблокирован\nДата разбана: Никогда\n\nВведите '/q', чтобы выйти", "Закрыть", ""), Kick(playerid);
else
{
new year, month,day;
getdate(year, month, day);
if(PlayerInfo[playerid][pBanDay] <= day && PlayerInfo[playerid][pBanMounth] <= month)
{
PlayerInfo[playerid][pBanDay] = 0;
PlayerInfo[playerid][pLocked] = 0;
SendClientMessage(playerid,COLOR_GREEN,"Ваш аккаунт был разбанен. Перезайдите в игру");
Kick(playerid);
}
else
{
format(tmp2,sizeof(tmp2), "{FF6347}Этот аккаунт заблокирован\nДата разбана: %d/%d/%d\n\nВведите '/q', чтобы выйти",PlayerInfo[playerid][pBanDay],PlayerInfo[playerid][pBanMounth],year);
ShowPlayerDialogEx(playerid,69,DIALOG_STYLE_MSGBOX, "{B20000}Внимание",tmp2, "Закрыть", "");
Kick(playerid);
}
}
}
new playersip[40];
GetPlayerIp(playerid,playersip,sizeof(playersip));
if(PlayerInfo[playerid][pCheckip] == 1)
{
if(strcmp(playersip, PlayerInfo[playerid][pIp]) != 0)
{
PlayerInfo[playerid][pLogin] = 0;
format(string, sizeof(string), "UPDATE accounts SET pLogin = '%d' WHERE name = '%s'",PlayerInfo[playerid][pLogin],Name(playerid));
mysql_query(string);
SetPlayerInterior(playerid, 0);
SetPlayerFacingAngle(playerid, 179.5547);
SetPlayerCameraPos(playerid,1911.426269, -1774.763916, 132.995452);
SetPlayerCameraLookAt(playerid,1908.732177, -1770.573364, 132.570449);
TogglePlayerControllable(playerid, 0);
ShowPlayerDialogEx(playerid,16,DIALOG_STYLE_INPUT, "Введите ключ безопасности", " ==== Ваш IP адрес сменился ====\n=== Введите Ваш ключ безопасности ===", "Готово", "Отмена");
PlayerInfo[playerid][pLogin] = 0;
return true;
}
}
if(PlayerInfo[playerid][pCheckip] == 1)
{
PlayerInfo[playerid][pLogin] = 1;
format(string, sizeof(string), "UPDATE accounts SET pLogin = '%d' WHERE name = '%s'",PlayerInfo[playerid][pLogin],Name(playerid));
mysql_query(string);
}
if(PlayerInfo[playerid][pCheckip] == 0)
{
GetPlayerIp(playerid,playersip,sizeof(playersip));
PlayerInfo[playerid][pLogin] = 1;
format(string, sizeof(string), "UPDATE accounts SET pLogin = '%d',pIp = '%s' WHERE name = '%s'",PlayerInfo[playerid][pLogin],playersip,Name(playerid));
mysql_query(string);
}
if(PlayerInfo[playerid][pCash] <= 0) PlayerInfo[playerid][pCash] = 0;
if(PlayerInfo[playerid][pProcents] <= 0) PlayerInfo[playerid][pProcents] = 0;
if(PlayerInfo[playerid][pChar][PlayerInfo[playerid][pViborChar]] == 0) PlayerInfo[playerid][pChar][PlayerInfo[playerid][pViborChar]] = 230;
if(PlayerInfo[playerid][pAdmin] <= 0) PlayerInfo[playerid][pDostup] = 521957921;
if(PlayerInfo[playerid][pDonateRank] > 0) SendClientMessage(playerid, 0xFEBC41AA, "Здравствуйте V.I.P игрок!"), format(tmp2, sizeof(tmp2), "~w~Welcome ~n~~b~ %s", playername2);
else format(tmp2, sizeof(tmp2), "~w~Welcome ~n~~b~ %s", playername2);
GameTextForPlayer(playerid, tmp2, 5000, 1);
if (PlayerInfo[playerid][pText] == 4) SendClientMessage(playerid, COLOR_WHITE, "С Вас была снята лидерка организации"), PlayerInfo[playerid][pText] = 0;
if (PlayerInfo[playerid][pText] == 5) SendClientMessage(playerid, COLOR_WHITE, "Ваша автомастерская была продана государству. Половина стоимости зачислена на ваш счет"), PlayerInfo[playerid][pText] = 0;
if (PlayerInfo[playerid][pText] == 3) PlayerInfo[playerid][pText] = 0, SendClientMessage(playerid, COLOR_WHITE, "Вы получили 100 000 вирт на банковский счет, за приглашённого друга");
if (PlayerInfo[playerid][pCheckip] == 0) SendClientMessage(playerid, COLOR_LIGHTRED, "У вас низкая степень защиты! Рекомендуем вам повысить уровень защиты аккаунта"), SendClientMessage(playerid, COLOR_LIGHTRED, "Изменение защиты аккаунта: /mm - [9] Безопасность");
if (PlayerInfo[playerid][pText] == 1) SendClientMessage(playerid, COLOR_LIGHTRED, "Вы были выселены за неуплату квартплаты"), SendClientMessage(playerid, COLOR_LIGHTRED, "Деньги за дом вы можете получить в банке \"/GetHouseMoney\"");
if (PlayerInfo[playerid][pText] == 2) SendClientMessage(playerid, COLOR_YELLOW, "Ваш бизнес был продан государству за простой государству. Половина стоимости зачислена на ваш банковский счет"), PlayerInfo[playerid][pText] = 0;
if(PlayerInfo[playerid][pPhousekey] != 999)
{
new house = PlayerInfo[playerid][pPhousekey];
createdcar = caridhouse[playerid];
caridhouse[playerid] = CreateVehicle(PlayerInfo[playerid][pCar], HouseInfo[house][hCarx], HouseInfo[house][hCary], HouseInfo[house][hCarz], HouseInfo[house][hCarc] , PlayerInfo[playerid][pColor][0] ,PlayerInfo[playerid][pColor][1], 86400);
createdcar ++;
LockCar(caridhouse[playerid]);
Fuell[caridhouse[playerid]] = PlayerInfo[playerid][pFuelcar];
CompVeh(playerid,caridhouse[playerid]);
}
/*******************************/
Lvl[playerid] = CreateProgressBar(500.00, 9.00, 106.50, 5.19, 866844671, 100.0);
SetProgressBarValue(Lvl[playerid],PlayerInfo[playerid][pExp]);
SetProgressBarMaxValue(Lvl[playerid],4*(PlayerInfo[playerid][pLevel]+1));
ShowProgressBarForPlayer(playerid, Lvl[playerid]);
format(string, sizeof(string), "%d",4*(PlayerInfo[playerid][pLevel]+1)-PlayerInfo[playerid][pExp]);
PlayerTextDrawSetString(playerid,TLvl[playerid],string);
PlayerTextDrawShow(playerid,TLvl[playerid]);
/******************************/
PEfir[playerid] = 255;
Pefir[playerid] = 999;
if(!strlen(PlayerInfo[playerid][pEmail]))
{
format(string,sizeof(string),"Авторизация прошла успешно. Игровой аккаунт: %s. Ваш номер аккаунта: %d, Email: Нет",Name(playerid),PlayerIDs[playerid]);
SendClientMessage(playerid,COLOR_REDD,string);
SendClientMessage(playerid,COLOR_RED,"Указать E-Mail вы можете в /mm => [9] Безопасность => [5] Указать E-mail");
}
else
{
format(string,sizeof(string),"Авторизация прошла успешно. Игровой аккаунт: %s. Ваш номер аккаунта: %d, Email: %s",Name(playerid),PlayerIDs[playerid],PlayerInfo[playerid][pEmail]);
SendClientMessage(playerid,COLOR_WHITE,string);
}
SpawnPlayer(playerid);
InitLockDoors(playerid);
GangZoneShowForPlayer(playerid, Army, COLOR_YELLOW2);
SetPlayerHealthAC(playerid, PlayerInfo[playerid][pHP]);
ResetPlayerMoney(playerid);
OnPlayerUpdateAc(playerid);
if(PlayerInfo[playerid][pAdmin] >= 1) SendClientMessage(playerid,COLOR_BLUE,"Вы вошли как администратор. Для авторизации, введите \"/alogin\""), SendClientMessage(playerid,COLOR_WHITE,"Пока вы не авторизованы, вы не можете пользоваться привелегиями.");
return true;
}P.S До недавнего времени все работало... Может проблемма в БД?