hi all
i have this code to cleanup old entries in my database
PHP Code:
public CleanDataBase()
{
new curTime = get_systime();
curTime -= ((30 * 24) * 3600);
new szTemp[512]
new ErrorCode,Handle:SqlConnection = SQL_Connect(g_SqlTuple,ErrorCode,g_Error,charsmax(g_Error))
if(g_SqlTuple == Empty_Handle)
set_fail_state(g_Error)
formatex(szTemp,charsmax(szTemp),"DELETE FROM `global_stats` WHERE `timestamp` < '%d';", curTime);
SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTemp)
SQL_FreeHandle(SqlConnection)
}
how can i see whole info aboute this entry? (steamid-name) for example
this is my table
PHP Code:
Queries = SQL_PrepareQuery(SqlConnection,"CREATE TABLE IF NOT EXISTS global_stats (`steamid-name` varchar(32), xp TEXT(11), level INT(11), `timestamp` INT(10) NOT NULL DEFAULT 0, name varchar(32))")
point of this is i want to log deleted entries