Quote:
Originally Posted by CrossUSAAF
pawn Код:
mysql_format(dbHandle, query, sizeof(query), "SELECT FROM_UNIXTIME(`Unban`, '%%Y-%%m-%%d %%l:%%i %%p') FROM `Bans` WHERE `Nick` = '%e'", params);
mysql_query(dbHandle, query, true);
cache_get_data(rows, fields);
if (rows) {
new bannedStamp[20];
cache_get_field_content(0, "Unban", bannedStamp);
printf("%s", bannedStamp):
}
Do you now understand, what I Mean? How can I Get the changed result from that query above? This one gives me a warning: "[WARNING] CMySQLResult::GetRowDataByName - field not found ("Unban")". Is this even possible or not?
Thanks for your reply in advance! |
It's a query issue, not a plugin issue. Scripting discussion would be more appropriate subforum for the question.
Anyways, change "FROM_UNIXTIME(`Unban`, '%%Y-%%m-%%d %%l:%%i %%p')" to "FROM_UNIXTIME(`Unban`, '%%Y-%%m-%%d %%l:%%i %%p') AS `Unban`" and it should work.
