Mine

public text v1 · immutable
#220461
·published 2006-10-25 05:35 UTC

sql_query($sql);

if( !( $opt_row = $db-&gt;sql_fetchrow($opt_result) ) )
{
	message_die(GENERAL_ERROR, 'Could not obtain optimize database config', '', __LINE__, __FILE__, $sql);
}

if ( ( $opt_row['cron_enable'] == '1' ) &amp;&amp; ( $opt_row['cron_lock'] == '1' ) )

{
	
	//
	// Lock cron for contemporary accesses
	//
	$sql = "UPDATE " . OPTIMIZE_DB_TABLE . " SET cron_lock = '0' ";

	if( !($result = $db-&gt;sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Could not lock optimize database cron', '', __LINE__, __FILE__, $sql);
	}

	$current_time = time();
	
	//
	// Check cron next 
	//
	if ( $opt_row['cron_next'] &lt;= $current_time ) 
	{
	ignore_user_abort();

	//
	// Get tables list
	//
	$list = mysql_list_tables($dbname); 

	//
	// Optimize tables 
	//
	while ( $tab = $db-&gt;sql_fetchrow($list) ) { 
		
		foreach ($tab as $column_value) {
			$sql = "OPTIMIZE TABLES $column_value"; 
			if ( !$result = $db-&gt;sql_query($sql) )
				{ 
				message_die(GENERAL_ERROR, "Couldn't optimize database", "", __LINE__, __FILE__, $sql);
				} 
		  }
	
	} 

	$sql = "UPDATE " . OPTIMIZE_DB_TABLE . " SET cron_next = " . ( $current_time + $opt_row['cron_every'] ) . ", cron_count = cron_count+1 ";

	if( !($result = $db-&gt;sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Could not update next optimize time', '', __LINE__, __FILE__, $sql);
	}
	}

}

else 

{ 

//
// Unlock cron for contemporary accesses
//
$sql = "UPDATE " . OPTIMIZE_DB_TABLE . " SET cron_lock = '1' "; 
if( !($result = $db-&gt;sql_query($sql)) ) 
{ 
	message_die(GENERAL_ERROR, 'Could not unlock optimize database cron', '', __LINE__, __FILE__, $sql); 
} 

}

?&gt;