{$data['message']}", "
{$popup_div}
{$this->ipsclass->DB->error}
"; } else { $this->ipsclass->main_msg .= "Query: ".htmlspecialchars($sql)."
Executed Successfully
"; } $this->ipsclass->DB->error = ""; $this->ipsclass->DB->failed = 0; } } } //----------------------------------------- // Get current table definitions //----------------------------------------- if( !file_exists( ROOT_PATH."/install/sql/{$this->ipsclass->vars['sql_driver']}_tables.php" ) ) { $this->ipsclass->admin->error( "You must upload /install/sql/{$this->ipsclass->vars['sql_driver']}_tables.php from the IPB installation package for your current version to run this tool" ); } //require ROOT_PATH."sources/action_admin/sql_{$this->ipsclass->vars['sql_driver']}.php"; require_once( KERNEL_PATH . 'db_lib/' . strtolower($this->ipsclass->vars['sql_driver']) . '_tools.php' ); require_once( ROOT_PATH . 'install/sql/' . strtolower($this->ipsclass->vars['sql_driver']) . '_tables.php' ); $db_tools = new db_tools( $this->ipsclass ); $output = array(); if ( !$output = $db_tools->db_table_diag( $TABLE ) ) { $this->ipsclass->admin->error( "There was an error and we could not process your " . strtolower($this->ipsclass->vars['sql_driver']) . "_tables.php file." ); } if( $output['error_count'] > 0 ) { $this->ipsclass->adskin->td_header[] = array( "{none}" , "50%" ); $this->ipsclass->adskin->td_header[] = array( "{none}" , "50%" ); $this->ipsclass->html .= $this->html->dbchecker_javascript(); $this->ipsclass->html .= $this->ipsclass->adskin->start_table( "WARNING: ERRORS FOUND" ); $this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( array( "There were errors found with your database. Please review them below, or click here to correct these errors.", 2 ) ) ); $this->ipsclass->html .= $this->ipsclass->adskin->end_table(); } else { $this->ipsclass->adskin->td_header[] = array( "{none}" , "50%" ); $this->ipsclass->adskin->td_header[] = array( "{none}" , "50%" ); $this->ipsclass->html .= $this->ipsclass->adskin->start_table( "No Errors Found" ); $this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( array( "There were no errors found with your database.", 2 ) ) ); $this->ipsclass->html .= $this->ipsclass->adskin->end_table(); } $this->ipsclass->adskin->td_header[] = array( "Table" , "30%" ); $this->ipsclass->adskin->td_header[] = array( "Status" , "20%" ); $this->ipsclass->adskin->td_header[] = array( "Fix" , "50%" ); $this->ipsclass->html .= $this->ipsclass->adskin->start_table( "Database Table Results" ); $good_img = "
";
$bad_img = "
";
$i = 0;
foreach( $output['results'] as $data )
{
if( $data['status'] == 'error' )
{
$popup_div = "";
$this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( "{$data['table']}",
"{$good_img}",
"{$popup_div}
" , $php_body ); # PREVENT WRAP: Very long string cookies $php_body = str_replace( "%3B", "
" , $php_body ); # PREVENT WRAP: Serialized array string cookies $php_body = str_replace( ";i:", ";
i:" , $php_body ); # PREVENT WRAP: LS_COLORS env $php_body = str_replace( ":*.", "
:*." , $php_body ); # PREVENT WRAP: PATH env $php_body = str_replace( "bin:/", "bin
:/" , $php_body ); # PREVENT WRAP: Cookie %2C split $php_body = str_replace( "%2C", "%2C
" , $php_body ); #PREVENT WRAP: Cookie , split $php_body = preg_replace( "#,(\d+),#", ",
\\1," , $php_body ); $php_style = "\n"; $this->ipsclass->html = $php_style . $php_body; $this->ipsclass->admin->output(); } $this->ipsclass->DB->sql_get_version(); $sql_version = strtoupper(SQL_DRIVER)." ".$this->ipsclass->DB->true_version; $php_version = phpversion()." (".@php_sapi_name().") ( PHP INFO )"; $server_software = php_uname(); $load_limit = "--"; $server_load_found = 0; //----------------------------------------- // Check cache first... //----------------------------------------- if( $this->ipsclass->cache['systemvars']['loadlimit'] ) { $loadinfo = explode( "-", $this->ipsclass->cache['systemvars']['loadlimit'] ); if ( intval($loadinfo[1]) > (time() - 10) ) { //----------------------------------------- // Cache is less than 10 secs old, use it //----------------------------------------- $server_load_found = 1; $load_limit = $loadinfo[0]; } } //----------------------------------------- // No cache or it's old, check real time //----------------------------------------- if( !$server_load_found ) { # @ supressor fixes warning in >4.3.2 with open_basedir restrictions if ( @file_exists('/proc/loadavg') ) { if ( $fh = @fopen( '/proc/loadavg', 'r' ) ) { $data = @fread( $fh, 6 ); @fclose( $fh ); $load_avg = explode( " ", $data ); $load_limit = trim($load_avg[0]); } } else if( strstr( strtolower(PHP_OS), 'win' ) ) { /*--------------------------------------------------------------- | typeperf is an exe program that is included with Win NT, | XP Pro, and 2K3 Server. It can be installed on 2K from the | 2K Resource kit. It will return the real time processor | Percentage, but will take 1 second processing time to do so. | This is why we shall cache it, and check only every 2 mins. | | Can also be obtained from COM, but it's extremely slow... ---------------------------------------------------------------*/ $serverstats = @shell_exec("typeperf \"Processor(_Total)\% Processor Time\" -sc 1"); if( $serverstats ) { $server_reply = explode( "\n", str_replace( "\r", "", $serverstats ) ); $serverstats = array_slice( $server_reply, 2, 1 ); $statline = explode( ",", str_replace( '"', '', $serverstats[0] ) ); $load_limit = round( $statline[1], 4 ); } } else { if ( $serverstats = @exec("uptime") ) { preg_match( "/(?:averages)?\: ([0-9\.]+),[\s]+([0-9\.]+),[\s]+([0-9\.]+)/", $serverstats, $load ); $load_limit = $load[1]; } } if( $load_limit ) { $this->ipsclass->cache['systemvars']['loadlimit'] = $load_limit."-".time(); $this->ipsclass->update_cache( array( 'name' => 'systemvars', 'array' => 1, 'deletefirst' => 0 ) ); } } $total_memory = $avail_memory = "--"; if( strstr( strtolower(PHP_OS), 'win' ) ) { $mem = @shell_exec('systeminfo'); if( $mem ) { $server_reply = explode( "\n", str_replace( "\r", "", $mem ) ); if( count($server_reply) ) { foreach( $server_reply as $info ) { if( strstr( $info, "Total Physical Memory" ) ) { $total_memory = trim( str_replace( ":", "", strrchr( $info, ":" ) ) ); } if( strstr( $info, "Available Physical Memory" ) ) { $avail_memory = trim( str_replace( ":", "", strrchr( $info, ":" ) ) ); } } } } } else { $mem = @shell_exec("free -m"); $server_reply = explode( "\n", str_replace( "\r", "", $mem ) ); $mem = array_slice( $server_reply, 1, 1 ); $mem = preg_split( "#\s+#", $mem[0] ); $total_memory = $mem[1].' MB'; $avail_memory = $mem[3].' MB'; } $disabled_functions = @ini_get('disable_functions') ? str_replace( ",", ", ", @ini_get('disable_functions') ) : "no information"; //----------------------------------------- // Upgrade history? //----------------------------------------- $upgrade_history = array(); $latest_version = array( 'upgrade_version_id' => NULL ); $this->ipsclass->DB->simple_construct( array( 'select' => '*', 'from' => 'upgrade_history', 'order' => 'upgrade_version_id DESC', 'limit' => array(0, 5) ) ); $this->ipsclass->DB->simple_exec(); while( $r = $this->ipsclass->DB->fetch_row() ) { if ( $r['upgrade_version_id'] > $latest_version['upgrade_version_id'] ) { $latest_version = $r; } $upgrade_history[] = $r; } //----------------------------------------- // Got real version number? //----------------------------------------- $this->ipsclass->version = 'v'.$latest_version['upgrade_version_human']; $this->ipsclass->vn_full = ( isset($latest_version['upgrade_notes']) AND $latest_version['upgrade_notes'] ) ? $latest_version['upgrade_notes'] : $this->ipsclass->vn_full; //----------------------------------------- // Version History //----------------------------------------- foreach( $upgrade_history as $r ) { $r['_date'] = $this->ipsclass->get_date( $r['upgrade_date'], 'SHORT' ); $thiscontent .= $this->html->acp_version_history_row( $r ); } $this->ipsclass->adskin->td_header[] = array( "{none}" , "40%" ); $this->ipsclass->adskin->td_header[] = array( "{none}" , "60%" ); $this->ipsclass->html .= $this->ipsclass->adskin->start_table( "System Overview" ); $this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( "IPB Version", $this->ipsclass->version . " (ID:" . $this->ipsclass->vn_full . ")" ) ); $this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( strtoupper(SQL_DRIVER)." Version", $sql_version ) ); $this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( "PHP Version", $php_version ) ); $this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( "Disabled PHP Functions", $disabled_functions ) ); $this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( "Safe Mode", SAFE_MODE_ON == 1 ? "ON" : "OFF" ) ); $this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( "Server Software", $server_software ) ); $this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( "Current Server Load", $load_limit ) ); $this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( "Total Server Memory", $total_memory ) ); $this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( "Available Physical Memory", $avail_memory ) ); $this->ipsclass->html .= $this->ipsclass->adskin->end_table(); $this->ipsclass->html .= $this->ipsclass->adskin->start_table( "System Processes" ); if( strstr( strtolower(PHP_OS), 'win' ) ) { $tasks = @shell_exec( "tasklist" ); $tasks = str_replace( " ", " ", $tasks ); } else { $tasks = @shell_exec( "top -b -n 1" ); $tasks = str_replace( " ", " ", $tasks ); } if( !$tasks ) { $tasks = "Unable to obtain process information"; } else { $tasks = "
".$tasks.""; } $this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( $tasks ) ); $this->ipsclass->html .= $this->ipsclass->adskin->end_table(); $this->ipsclass->html .= $this->html->acp_version_history_wrapper( $thiscontent ); //----------------------------------------- // File Version Checker //----------------------------------------- /* $this->ipsclass->html .= $this->ipsclass->adskin->start_form( array( 1 => array( 'code' , 'fileversions' ), 2 => array( 'act' , 'diag' ), 4 => array( 'section', $this->ipsclass->section_code ), ) ); $this->ipsclass->html .= $this->ipsclass->adskin->start_table( "File Version Checker" ); $this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( "This tool will check your file versions to verify they match. Running different versions of core files can result in unexpected behavior." ) ); $this->ipsclass->html .= $this->ipsclass->adskin->end_form('Run Tool'); $this->ipsclass->html .= $this->ipsclass->adskin->end_table(); //----------------------------------------- // Whitespace Checker //----------------------------------------- $this->ipsclass->html .= $this->ipsclass->adskin->start_form( array( 1 => array( 'code' , 'whitespace' ), 2 => array( 'act' , 'diag' ), 4 => array( 'section', $this->ipsclass->section_code ), ) ); $this->ipsclass->html .= $this->ipsclass->adskin->start_table( "Whitespace Checker" ); $this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( "If your php files have whitespace at the beginning or end of the file, it can cause certain issues with IPB. This tool will check for any files that have this problem." ) ); $this->ipsclass->html .= $this->ipsclass->adskin->end_form('Run Tool'); $this->ipsclass->html .= $this->ipsclass->adskin->end_table(); //----------------------------------------- // File Permissions Checker //----------------------------------------- $this->ipsclass->html .= $this->ipsclass->adskin->start_form( array( 1 => array( 'code' , 'filepermissions' ), 2 => array( 'act' , 'diag' ), 4 => array( 'section', $this->ipsclass->section_code ), ) ); $this->ipsclass->html .= $this->ipsclass->adskin->start_table( "File Permissions Checker" ); $this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( "This tool will check your file and folder permissions to verify those that need to be writeable are. If permissions are not set properly your skins, languages and other board elements may not be saved correctly." ) ); $this->ipsclass->html .= $this->ipsclass->adskin->end_form('Run Tool'); $this->ipsclass->html .= $this->ipsclass->adskin->end_table(); //----------------------------------------- // DB Table/Column Checker //----------------------------------------- $this->ipsclass->html .= $this->ipsclass->adskin->start_form( array( 1 => array( 'code' , 'dbchecker' ), 2 => array( 'act' , 'diag' ), 4 => array( 'section', $this->ipsclass->section_code ), ) ); $this->ipsclass->html .= $this->ipsclass->adskin->start_table( "Database Table/Column Checker" ); $this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( "This tool will check your database tables to verify they are up to date and accurate." ) ); $this->ipsclass->html .= $this->ipsclass->adskin->end_form('Run Tool'); $this->ipsclass->html .= $this->ipsclass->adskin->end_table(); //----------------------------------------- // DB Index Checker //----------------------------------------- $this->ipsclass->html .= $this->ipsclass->adskin->start_form( array( 1 => array( 'code' , 'dbindex' ), 2 => array( 'act' , 'diag' ), 4 => array( 'section', $this->ipsclass->section_code ), ) ); $this->ipsclass->html .= $this->ipsclass->adskin->start_table( "Database Index Checker" ); $this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( "This tool will check your database indexes to ensure they are correct. If databases indexes are not set properly, your database may not run as fast or as efficient as it should." ) ); $this->ipsclass->html .= $this->ipsclass->adskin->end_form('Run Tool'); $this->ipsclass->html .= $this->ipsclass->adskin->end_table(); */ //----------------------------------------- $this->ipsclass->admin->output(); } } ?>