1.76c
the database (sqlite) doesnt get pruned, it gets locked when trying to get pruned
** Map 'ship_fight' ended
L 12/02/2007 - 20:59:01: [MYSQLX] Error in querying database, location: 6
L 12/02/2007 - 20:59:01: [MYSQLX] Message: database is locked (5)
L 12/02/2007 - 20:59:01: [MYSQLX] Query statement: DELETE FROM wc3_player_race WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( (julianday(`time`) + 11) < julianday('now') ) );
L 12/02/2007 - 20:59:20: ** Map '2_rooms_m' started
L 12/02/2007 - 20:59:20: ** Plugin version: '3.0 RC7.9 Custom'
L 12/02/2007 - 20:59:43: [MYSQLX] Error in querying database, location: 6
L 12/02/2007 - 20:59:43: [MYSQLX] Message: database is locked (5)
L 12/02/2007 - 20:59:43: [MYSQLX] Query statement: SELECT `race_id`, `race_xp` FROM `wc3_player_race` WHERE ( `player_id` = '24782' );
L 12/02/2007 - 20:59:50: ** Map '2_rooms_m' ended
L 12/02/2007 - 20:59:50: [MYSQLX] Error in querying database, location: 6
L 12/02/2007 - 20:59:50: [MYSQLX] Message: database is locked (5)
L 12/02/2007 - 20:59:50: [MYSQLX] Query statement: DELETE FROM wc3_player_race WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( (julianday(`time`) + 31) < julianday('now') ) );
L 12/02/2007 - 20:59:57: ** Map 'de_dust' started
and also, its not suppose to be [MYSQLX]
Code: Select all
SQLITE_Prune()
{
new const szPruneQuery[SQLITE_TOTAL_PRUNE_QUERY][] =
{
"DELETE FROM wc3_player_race WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( (julianday(`time`) + %d) < julianday('now') ) );",
"DELETE FROM wc3_player_skill WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( (julianday(`time`) + %d) < julianday('now') ) );"
};
new szQuery[256];
// Need to run all 3 queries
for ( new i = 0; i < MYSQL_TOTAL_PRUNE_QUERY; i++ )
{
formatex( szQuery, 255, szPruneQuery[i], get_pcvar_num( CVAR_wc3_days_before_delete ) );
new Handle:query = SQL_PrepareQuery( g_DBConn, szQuery );
if ( !SQL_Execute( query ) )
{
MYSQLX_Error( query, szQuery, 6 );
?????????NOT SQLITE_Error(...????
return;
}
}
}
