lava172
Умник
Такая проблема. При авторизации пишет что ввел неправильный пароль, хотя ввожу правильный.
Диалог авторизации:
LoginCallback
stock Avt(z,playerid)
Диалог авторизации:
PHP:
case 2://Авторизация
{
if(response)
{
if(!strlen(inputtext))
{
SCM(playerid,0xFF4500FF,"[Регистрация]: Вы ничего не ввели");
return ShowPlayerLoginDialog(playerid);
}
//mysql_format(MYSQL_ARG, string,512, "SELECT Money,Kills,Deaths,Skin,Admin,Warns,Mute,Mutes,Jail,Jails,DonateMoney,Gorod,Sex,Gun1,Gun2,Gun3,Gun4,Level,Bank,Freeze,Freezes,Kiss,Hour,Minute,Year,Month,Day,EndHour,EndMinute,EndYear,EndMonth,EndDay,Gang,GangLvl FROM `"TABLE_ACCOUNTS"` WHERE 'Name' = '%s' AND `Key` = '%s'",pStats[playerid][pName],inputtext);
mysql_real_escape_string(inputtext, sqlpass);
mysql_format(MYSQL_ARG, asd,90,"SELECT * FROM `"TABLE_ACCOUNTS"` WHERE 'Name' = '%s' AND `Key` = '%s'",pStats[playerid][pName],sqlpass);
mysql_function_query(MYSQL_ARG, asd, true, "LoginCallback","ds", playerid, inputtext);
return 1;
}
else SCM(playerid, COLOR_RED, "Вы отказались от авторизации. Для выхода введите /q");
}
PHP:
publics LoginCallback(playerid, password[])
{
GetPlayerName(playerid,pStats[playerid][pName],24);
new string[144];
cache_get_data(rows, fields);
if(!rows)
{
if(pStats[playerid][pWrPass] == 3)
{
f(string,"Игрок %s был кикнут, причина: [3 раза ввел неверный пароль]",pStats[playerid][pName]);
SCMT(COLOR_RED,string);
return GKick(playerid);
}
pStats[playerid][pWrPass]++;
f(string, "[Авторизация]: Вы ввели неправильный пароль. Осталось попыток {1E90FF}%i {FF4500}из {1E90FF}3",pStats[playerid][pWrPass]);
SCM(playerid,0xFF4500FF,string);
return ShowPlayerLoginDialog(playerid);
}
else
{
pStats[playerid][plogged] = true;
SCM(playerid,-1,"Вы успешно авторизовались.");
SCM(playerid,-1,"Введите команду /skin для выбора скина");
SCM(playerid,-1,"Введите команду /gun для выбора набора оружия при спавне");
SpawnPlayer(playerid);
for(new z = 0; z < rows;z++)
{
Avt(z,playerid);//Тут читаем бд и записываем в переменную
}}
return 1;
}
PHP:
stock Avt(z,playerid)
{
pStats[playerid][pMoney] = cache_get_field_content_int(z, "Money", MYSQL_ARG);
pStats[playerid][pKills] = cache_get_field_content_int(z, "Kills", MYSQL_ARG);
pStats[playerid][pDeaths] = cache_get_field_content_int(z, "Deaths", MYSQL_ARG);
pStats[playerid][pSkin] = cache_get_field_content_int(z, "Skin", MYSQL_ARG);
pStats[playerid][pAdmin] = cache_get_field_content_int(z, "Admin", MYSQL_ARG);
pStats[playerid][pWarns] = cache_get_field_content_int(z, "Warns", MYSQL_ARG);
pStats[playerid][pMute] = cache_get_field_content_int(z, "Mute", MYSQL_ARG);
pStats[playerid][pMutes] = cache_get_field_content_int(z, "Mutes", MYSQL_ARG);
pStats[playerid][pJail] = cache_get_field_content_int(z, "Jail", MYSQL_ARG);
pStats[playerid][pJails] = cache_get_field_content_int(z, "Jails", MYSQL_ARG);
pStats[playerid][pDonateMoney] = cache_get_field_content_int(z, "DonateMoney", MYSQL_ARG);
pStats[playerid][Gorod] = cache_get_field_content_int(z, "Gorod", MYSQL_ARG);
pStats[playerid][pSex] = cache_get_field_content_int(z, "Sex", MYSQL_ARG);
pStats[playerid][pGun1] = cache_get_field_content_int(z, "Gun1", MYSQL_ARG);
pStats[playerid][pGun2] = cache_get_field_content_int(z, "Gun2", MYSQL_ARG);
pStats[playerid][pGun3] = cache_get_field_content_int(z, "Gun3", MYSQL_ARG);
pStats[playerid][pGun4] = cache_get_field_content_int(z, "Gun4", MYSQL_ARG);
pStats[playerid][pLevel] = cache_get_field_content_int(z, "Level", MYSQL_ARG);
pStats[playerid][pBank] = cache_get_field_content_int(z, "Bank", MYSQL_ARG);
pStats[playerid][pFreeze] = cache_get_field_content_int(z, "Freeze", MYSQL_ARG);
pStats[playerid][pFreezes] = cache_get_field_content_int(z, "Freezes", MYSQL_ARG);
pStats[playerid][pKiss] = cache_get_field_content_int(z, "Kiss", MYSQL_ARG);
pStats[playerid][phour] = cache_get_field_content_int(z, "Hour", MYSQL_ARG);
pStats[playerid][pminute] = cache_get_field_content_int(z, "Minute", MYSQL_ARG);
pStats[playerid][pyear] = cache_get_field_content_int(z, "Year", MYSQL_ARG);
pStats[playerid][pmonth] = cache_get_field_content_int(z, "Month", MYSQL_ARG);
pStats[playerid][pday] = cache_get_field_content_int(z, "Day", MYSQL_ARG);
pStats[playerid][pEndhour] = cache_get_field_content_int(z, "EndHour", MYSQL_ARG);
pStats[playerid][pEndminute] = cache_get_field_content_int(z, "EndMinute", MYSQL_ARG);
pStats[playerid][pEndyear] = cache_get_field_content_int(z, "EndYear", MYSQL_ARG);
pStats[playerid][pEndmonth] = cache_get_field_content_int(z, "EndMonth", MYSQL_ARG);
pStats[playerid][pEndday] = cache_get_field_content_int(z, "EndDay", MYSQL_ARG);
PGang[playerid] = cache_get_field_content_int(z, "Gang", MYSQL_ARG);
GangLvl[playerid] = cache_get_field_content_int(z, "GangLvl", MYSQL_ARG);
}
