Приветствую всех
суть проблемы
при загрузке банлиста, в лог mysql выводится ошибка:
При этом столбец BANDATE - имеетсяPHP код:
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
[23:46:29] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BANDATE")
Загрузка банлиста:
PHP код:
forward mysql_OnPlayerBanlistGet(playerid);
public mysql_OnPlayerBanlistGet(playerid)
{
new rows,fields;
cache_get_data(rows, fields);
if(!rows) return Message(playerid, COLOR_GREEN, "Список забаненых игроков пуст");
new banned[MAX_PLAYER_NAME],unban[11],i;
new string[128];
while(i < rows)
{
cache_get_field_content(i, "BANNED", banned, dbHandle, 24);
cache_get_field_content(i, "BANDATE", unban, dbHable);
if(gettime() >= strval(unban))
{
f(string, "DELETE FROM "T_GETBANS" WHERE `BANNED`='%e'", banned);
mysql_function_query(dbHandle, string, false, "", "");
}
i++;
}
mysql_function_query(dbHandle, "SELECT `BANNED` FROM "T_GETBANS"", true, "mysql_OnPlayerBanlistShow", "i", playerid);
return 1;
}