Quote:
Originally Posted by Bugsy
You would do:
Code:
SELECT * FROM `global_stats` WHERE `timestamp` < '%d';
OR
SELECT Field1, Field2, Field3 FROM `global_stats` WHERE `timestamp` < '%d';
In your query handler (IgnoreHandle) you would then read the results and write to log file.
|
im not sure im i geting it right..
PHP Code:
SQL_ThreadQuery(g_SqlTuple, "displayFunction", "SELECT * FROM `global_stats` WHERE `timestamp` < '%d';");
PHP Code:
public displayFunction(failState, Handle:Query, Error[], errorId, Data[], dataSize, Float:queueTime)
{
// Only reach here if there is no connection or invalid query
if (failState || errorId || Error[0])
log_amx("SQL_ThreadQuery Failed! FailState = %d | Error = %s | errorId = %d", failState, Error, errorId);
else
{
if (SQL_NumRows(Query))
{
// Stress results
while (SQL_MoreResults(Query))
{
new Name[512];
SQL_ReadResult(Query, 0, Name, charsmax(Name));
log_to_file("addons/amxmodx/logs/deleted.log","%s",Name)
SQL_NextRow(Query);
}
// Rewind from zero
SQL_Rewind(Query);
// Stress again
while (SQL_MoreResults(Query))
{
new Name[512];
SQL_ReadResult(Query, 0, Name, charsmax(Name));
SQL_NextRow(Query);
// Print
server_print(Name);
log_to_file("addons/amxmodx/logs/deleted.log","%s",Name)
}
}
// Get field's name
new fieldName[512];
SQL_FieldNumToName(Query, 0, fieldName, charsmax(fieldName));
server_print(fieldName);
log_to_file("addons/amxmodx/logs/deleted.log","%s",fieldName)
}
}
result>
PHP Code:
L 01/28/2017 - 18:36:04: steamid-name