Авторизация MYSQL R39-2

[lava172]

При авторизации текстдравы отображаются некорректно, иногда вылетает самп. При регистрации все нормально.


В диалоге авторизации:

new sqlname[24];
	mysql_real_escape_string(pStats[playerid][pName], sqlname); // Защита от SQL Inject, шифрует кодировку.
	if(!strcmp(pStats[playerid][pPassword], inputtext))
    {
    new query_string[52+MAX_PLAYER_NAME];
    f(query_string, "SELECT * FROM `accounts` WHERE `Name` = '%s'",sqlname);
    mysql_function_query(mysql_connect_ID, query_string, true, "UploadPlayerAccount","i", playerid);
    }

Сам коллбэк авторизации.

publics UploadPlayerAccount(playerid)
{
	new string[128];
	pStats[playerid][plogged] = true;
	SCM(playerid,-1,"Вы успешно авторизовались.");
	SCM(playerid,-1,"Введите команду /skin для выбора скина");
	SCM(playerid,-1,"Введите команду /gun для выбора набора оружия при спавне");
    pStats[playerid][pMoney] = cache_get_field_content_int(0, "Money", mysql_connect_ID);
	pStats[playerid][pKills] = cache_get_field_content_int(0, "Kills", mysql_connect_ID);
	pStats[playerid][pDeaths] = cache_get_field_content_int(0, "Deaths", mysql_connect_ID);
	pStats[playerid][pSkin] = cache_get_field_content_int(0, "Skin", mysql_connect_ID);
	pStats[playerid][pAdmin] = cache_get_field_content_int(0, "Admin", mysql_connect_ID);
	pStats[playerid][pWarns] = cache_get_field_content_int(0, "Warns", mysql_connect_ID);
	pStats[playerid][pMute] = cache_get_field_content_int(0, "Mute", mysql_connect_ID);
	pStats[playerid][pMutes] = cache_get_field_content_int(0, "Mutes", mysql_connect_ID);
	pStats[playerid][pJail] = cache_get_field_content_int(0, "Jail", mysql_connect_ID);
	pStats[playerid][pJails] = cache_get_field_content_int(0, "Jails", mysql_connect_ID);
	pStats[playerid][pDonateMoney] = cache_get_field_content_int(0, "DonateMoney", mysql_connect_ID);
	pStats[playerid][Gorod] = cache_get_field_content_int(0, "Gorod", mysql_connect_ID);
	pStats[playerid][pSex] = cache_get_field_content_int(0, "Sex", mysql_connect_ID);
	pStats[playerid][pGun1] = cache_get_field_content_int(0, "Gun1", mysql_connect_ID);
	pStats[playerid][pGun2] = cache_get_field_content_int(0, "Gun2", mysql_connect_ID);
	pStats[playerid][pGun3] = cache_get_field_content_int(0, "Gun3", mysql_connect_ID);
	pStats[playerid][pGun4] = cache_get_field_content_int(0, "Gun4", mysql_connect_ID);
	pStats[playerid][pLevel] = cache_get_field_content_int(0, "Level", mysql_connect_ID);
	pStats[playerid][pBank] = cache_get_field_content_int(0, "Bank", mysql_connect_ID);
	pStats[playerid][pFreeze] = cache_get_field_content_int(0, "Freeze", mysql_connect_ID);
	pStats[playerid][pFreezes] = cache_get_field_content_int(0, "Freezes", mysql_connect_ID);
	pStats[playerid][pKiss] = cache_get_field_content_int(0, "Kiss", mysql_connect_ID);
	pStats[playerid][phour] = cache_get_field_content_int(0, "Hour", mysql_connect_ID);
	pStats[playerid][pminute] = cache_get_field_content_int(0, "Minute", mysql_connect_ID);
	pStats[playerid][pyear] = cache_get_field_content_int(0, "Year", mysql_connect_ID);
	pStats[playerid][pmonth] = cache_get_field_content_int(0, "Month", mysql_connect_ID);
	pStats[playerid][pday] = cache_get_field_content_int(0, "Day", mysql_connect_ID);
	PGang[playerid] = cache_get_field_content_int(0, "Gang", mysql_connect_ID);
	GangLvl[playerid] = cache_get_field_content_int(0, "GangLvl", mysql_connect_ID);
    pStats[playerid][pEndhour] = cache_get_field_content_int(0, "EndHour", mysql_connect_ID);
	pStats[playerid][pEndminute] = cache_get_field_content_int(0, "EndMinute", mysql_connect_ID);
	pStats[playerid][pEndyear] = cache_get_field_content_int(0, "EndYear", mysql_connect_ID);
	pStats[playerid][pEndmonth] = cache_get_field_content_int(0, "EndMonth", mysql_connect_ID);
	pStats[playerid][pEndday] = cache_get_field_content_int(0, "EndDay", mysql_connect_ID);
    pStats[playerid][House] = cache_get_field_content_int(0, "House", mysql_connect_ID);
    pStats[playerid][Dacha] = cache_get_field_content_int(0, "Dacha", mysql_connect_ID);
    pStats[playerid][Biznes] = cache_get_field_content_int(0, "Biznes", mysql_connect_ID);
 	pStats[playerid][Mycar] = cache_get_field_content_int(0, "Mycar", mysql_connect_ID);
	pStats[playerid][Mybike] = cache_get_field_content_int(0, "Mybike", mysql_connect_ID);
	pStats[playerid][Mytank] = cache_get_field_content_int(0, "Mytank", mysql_connect_ID); 
	pStats[playerid][Myjeep] = cache_get_field_content_int(0, "Myjeep", mysql_connect_ID); 
	pStats[playerid][Myyaht] = cache_get_field_content_int(0, "Myyaht", mysql_connect_ID); 
	pStats[playerid][Myfred] = cache_get_field_content_int(0, "Myfred", mysql_connect_ID);
	pStats[playerid][Myvele] = cache_get_field_content_int(0, "Myvele", mysql_connect_ID);
	pStats[playerid][pDriftScore] = cache_get_field_content_int(0, "DriftScore", mysql_connect_ID);
	pStats[playerid][pDriftMoney] = cache_get_field_content_int(0, "DriftMoney", mysql_connect_ID); 
	pStats[playerid][pWedding]  = cache_get_field_content_int(0, "Wedding", mysql_connect_ID); 
    cache_get_field_content(0, "NickName_Wedding", pStats[playerid][pNickNameWedding], mysql_connect_ID, MAX_PLAYER_NAME); 
    if(pStats[playerid][pAdmin] >= 1)
	{
	f(string, "[A] Вы вошли как администратор {1E90FF}%d-го {FF4500}уровня.",pStats[playerid][pAdmin]);
	SCM(playerid,0x9597EAAA,string);
	SCM(playerid,0x9597EAAA,"[A] Используйте {1E90FF}/ahelp {FF4500}для помощи по командам администратора");
	}
	if(pStats[playerid][pMutes] >= 1)
	{
	f(string, "У Вас стоит затычка. До снятия {1E90FF}%d {FF4500}мин | {1E90FF}%d {FF4500}сек.",pStats[playerid][pMute],pStats[playerid][pMutes]);
	SCM(playerid,0x9597EAAA,string);
	}
	if(pStats[playerid][pJails] >= 1)
	{
	f(string, "Вы находитесь в тюрьме. До освобождения {1E90FF}%d {FF4500}мин | {1E90FF}%d {FF4500}сек.",pStats[playerid][pJail],pStats[playerid][pJails]);
	SCM(playerid,0x9597EAAA,string);
    ResetPlayerWeapons(playerid);
	GameTextForPlayer(playerid, "~r~Busted", 3000, 3);
	SetPlayerInterior(playerid, 3);
	SetPlayerPos(playerid, 198.5319,162.3093,1003.0300);
	}
	if(pStats[playerid][pFreezes] >= 1)
	{
	TogglePlayerControllable(playerid, false);
	f(string, "Вы заморожены. До снятия {1E90FF}%d {FF4500}мин | {1E90FF}%d {FF4500}сек.",pStats[playerid][pFreeze],pStats[playerid][pFreezes]);
	SCM(playerid,0x9597EAAA,string);
	}
	if(pStats[playerid][Biznes] != 1000) Plateg[playerid] = SetTimerEx("GiveBiznesMoney", 5*60*1000, 1, "i", playerid);
	return SpawnPlayer(playerid);
}