SA-MP Forums Archive
mysql_log errors - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql_log errors (/showthread.php?tid=563064)


mysql_log errors - tarzanus - 13.02.2015

Hey..
I made a stunt server but, i have some errors in mysq_log.
register:
Код:
[21:13:09] [WARNING] cache_insert_id - no active cache
login:
Код:
[21:14:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[21:14:15] [ERROR] cache_get_field_content_int - invalid datatype
[21:14:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[21:14:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[21:14:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[21:14:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[21:14:15] [ERROR] cache_get_field_content_int - invalid datatype
[21:14:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[21:14:15] [ERROR] cache_get_field_content_int - invalid datatype
[21:14:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[21:14:15] [ERROR] cache_get_field_content_int - invalid datatype
[21:14:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[21:14:15] [ERROR] cache_get_field_content_int - invalid datatype
[21:14:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[21:14:15] [ERROR] cache_get_field_content_int - invalid datatype
[21:14:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[21:14:15] [ERROR] cache_get_field_content_int - invalid datatype
[21:14:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[21:14:15] [ERROR] cache_get_field_content_int - invalid datatype
[21:14:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[21:14:15] [ERROR] cache_get_field_content_int - invalid datatype
I'll think is from there:
Код:
forward SavePlayerData(playerid);
public SavePlayerData(playerid)
{
	szQuery[0] = EOS, PaccInfo[playerid][LGIN] = 0;
	mysql_format(Handle, szQuery, 256, "UPDATE `users` SET `Money` = '%d', `Level` = '%d', `VIP` = '%d', `Kills` = '%d', `Deaths` = '%d', `Hours` = '%d', `Mins` = '%d', `Secs` = '%d' WHERE `ID` = '%e'", PaccInfo[playerid][Money], PaccInfo[playerid][Level], PaccInfo[playerid][Vip], PaccInfo[playerid][Kills], PaccInfo[playerid][Deaths], PaccInfo[playerid][Hours], PaccInfo[playerid][Mins], PaccInfo[playerid][Secs], PaccInfo[playerid][ID]);
	mysql_tquery(Handle, szQuery);
	return 1;
}
Код:
forward LoadPlayerData(playerid);
public LoadPlayerData(playerid)
{
    szQuery[0] = EOS;
	/*if(!cache_get_row_count(Handle))
	{
		format(szQuery, 128, "{00FF00}Salut {FF0000}%s{00FF00}\nAcest nume este inregistrat.\n{FFFF00}Te rugam sa introduci parola.", GetName(playerid));
		ShowPlayerDialog(playerid, L_DIALOG, DIALOG_STYLE_PASSWORD, "Logare", szQuery, "Logare", "Exit");
		return 1;
	}*/
	PaccInfo[playerid][ID] = cache_get_field_content_int(0, "ID");
	cache_get_field_content(0, "IP", PaccInfo[playerid][IP]);
	cache_get_field_content(0, "Name", PaccInfo[playerid][Name]);
	cache_get_field_content(0, "Password", PaccInfo[playerid][Password]);
	PaccInfo[playerid][Money] = cache_get_field_content_int(0, "Money");
	PaccInfo[playerid][Level] = cache_get_field_content_int(0, "Level");
	PaccInfo[playerid][Vip] = cache_get_field_content_int(0, "VIP");
	PaccInfo[playerid][Kills] = cache_get_field_content_int(0, "Kills");
	PaccInfo[playerid][Deaths] = cache_get_field_content_int(0, "Deaths");
	PaccInfo[playerid][Hours] = cache_get_field_content_int(0, "Hours");
	PaccInfo[playerid][Mins] = cache_get_field_content_int(0, "Mins");
	PaccInfo[playerid][Secs] = cache_get_field_content_int(0, "Secs");
	PaccInfo[playerid][LGIN] = 1;
	format(szQuery, 128, "Bine ai revenit %s. Ai fost logat cu succes.", GetName(playerid));
	SendClientMessage(playerid, LIGHTGREEN, szQuery);
	return 1;
}
Sorry for my bad English.