Проблема при попытке авторизации.

[Alex_Jemison]

Проблема при попытке авторизации.

Код:

Спойлер

[18:08:24] [WARNING] mysql_connect: no password specified
[18:08:57] [ERROR] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[18:08:57] [ERROR] cache_get_value_name: invalid row index '0' (number of rows: '0')
[18:08:57] [ERROR] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[18:08:57] [ERROR] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[18:08:57] [ERROR] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[18:08:57] [ERROR] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[18:08:57] [ERROR] cache_get_value_name: invalid row index '0' (number of rows: '0')
[18:08:57] [ERROR] cache_get_value_name: invalid row index '0' (number of rows: '0')

case 6:
		{
			if(response)
			{
				if(!strlen(inputtext))
				{
					SendClientMessage(playerid, COLOR_GOLD, ">> {FFFFFF}Для авторизации введите пароль");
					ShowLogin(playerid);
					return 1;
				}
				if(strcmp(PlayerInfo[playerid][pPassword], inputtext, true, 30) == 0)
				{
    				static const fmt_query[] = "SELECT * FROM `accounts` WHERE `Name` = '%s' AND `Password` = '%s' ";
					new query[sizeof(fmt_query) +(-2+MAX_PLAYER_NAME)+(-2+30)];
					format(query, sizeof(query), fmt_query, PlayerInfo[playerid][pName],PlayerInfo[playerid][pPassword]);
					mysql_tquery(mysql, query, "PlayerLogin", "i", playerid);
				}
				else
				{
    				new string[70];
    				WrongPassword[playerid]--;
    				if(WrongPassword[playerid] > 0) 
    				{
    					format(string, sizeof(string), ">> {FFFFFF}Вы ввели неправильный пароль. У вас осталось %d попыток !", GetPVarInt(playerid, "WrongPassword"));
    					SendClientMessage(playerid, COLOR_GOLD, string);
    				}
    				if(WrongPassword[playerid] == 0)
    				{
    					SendClientMessage(playerid, COLOR_RED, ">> {FFFFFF}Вы использовали все попытки для входа");
    				}
    				ShowLogin(playerid);
				}
			}
			else   
			{
				SendClientMessage(playerid, COLOR_RED, ">> Для выхода из игры используйте /quit");
				return Kick(playerid);
			}
		}
	}

forward PlayerLogin(playerid);
public PlayerLogin(playerid)
{
    cache_get_value_name_int(0, "ID", PlayerInfo[playerid][pID]);
    cache_get_value_name(0, "Email", PlayerInfo[playerid][pEmail], 64);
    cache_get_value_name_int(0, "Skin", PlayerInfo[playerid][pSkin]);
    cache_get_value_name_int(0, "Sex", PlayerInfo[playerid][pSex]);
    cache_get_value_name_int(0, "Race", PlayerInfo[playerid][pRace]);
    cache_get_value_name_int(0, "Referal", PlayerInfo[playerid][pReferal]);
    cache_get_value_name(0, "RegIP", PlayerInfo[playerid][pRegIP], 12);
    cache_get_value_name(0, "RegData", PlayerInfo[playerid][pRegData], 15);
    TogglePlayerSpectating(playerid, 0);
    SetPVarInt(playerid, "Logged", 1);
    SpawnPlayer(playerid);
    return 1;
}