Warcraft 3 MODs

Posted: **Sun Dec 02, 2007 9:16 pm**

RC8
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;
		}
	}
}

Posted: **Mon Dec 03, 2007 12:20 am**

To fix the "Database is locked" error, upgrade to 1.8

Posted: **Mon Dec 03, 2007 5:11 pm**

wouldn't the menus die?

can i just update the sqlite module?

Posted: **Mon Dec 03, 2007 5:14 pm**

That I am not sure about. Though, you can also try what is in the SVN. That has the menus fixed for 1.8 and a few other things.

Posted: **Mon Dec 03, 2007 5:43 pm**

Yea SVN has a lot of fixes... and it's "stable"... I'd release it as RC9 but i don't want to zip up the files b/c i'm lazy

Posted: **Tue Dec 04, 2007 4:13 am**

Geesu wrote:Yea SVN has a lot of fixes... and it's "stable"... I'd release it as RC9 but i don't want to zip up the files b/c i'm lazy

I was about to ask if it was going to be officially released... I think you should!

Warcraft 3 MODs

sqlite prune

sqlite prune