$problem ): ?>
 
 

phpMyAdmin Database Manager > WordPress Database > SQL Tab. In case you\'re not familiar with hosting service tools, please contact to your hosting service support team and forward them this message with the SQL command.', 'wpforo' ), '[' . __( 'Solve database problems', 'wpforo' ) . ']' ) ?>

SET AUTOCOMMIT = 0;
';
                                    $SQL = wpforo_database_fixer( $problems );
                                    if( wpfval( $SQL, 'fields' ) ) {
                                        foreach( $SQL['fields'] as $query ) echo $query . '
';
                                    }
                                    if( wpfval( $SQL, 'keys' ) ) {
                                        foreach( $SQL['keys'] as $query ) echo $query . '
';
                                    }
                                    if( wpfval( $SQL, 'tables' ) ) {
                                        foreach( $SQL['tables'] as $query ) echo $query . '

';
                                    }
                                    if( wpfval( $SQL, 'data' ) ) {
                                        foreach( $SQL['data'] as $query ) echo $query . '

';
                                    }
                                    echo ';SET AUTOCOMMIT = 1;';
                                }
                                ?>

 

board->get_current( 'boardid' ); printf( '', wp_nonce_url( admin_url( sprintf( 'admin.php?page=%1$s&wpfaction=%2$s&boardid=%3$s', 'wpforo-boards', 'board_repair', $boardid ) ), 'wpforo-board-repair-' . $boardid ), __( 'Repair', 'wpforo' ) ); ?>
tables as $table ) { wpforo_table_info( $table ); } ?>
db->get_var( "SHOW TABLES LIKE '" . esc_sql( $table ) . "'" ); if( $_table_exists ) { $result = WPF()->db->get_results( "SHOW FULL COLUMNS FROM " . esc_sql( $table ), ARRAY_A ); $count = WPF()->db->get_var( "SELECT COUNT(*) FROM " . esc_sql( $table ) ); $status = WPF()->db->get_row( "CHECK TABLE " . esc_sql( $table ), ARRAY_A ); echo ''; echo ''; echo ''; echo '
'; echo ''; echo ''; foreach( $result as $info ) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo '
' . $table . '  |  Rows: ' . $count . '  |  Status: ' . $status['Msg_text'] . '
' . $info['Field'] . '' . $info['Type'] . '' . $info['Collation'] . '' . ( $info['Null'] == 'NO' ? '-' : 'NULL' ) . '' . $info['Key'] . '' . $info['Default'] . '
'; echo '		'; $result = WPF()->db->get_results( "SHOW INDEXES FROM " . esc_sql( $table ), ARRAY_A ); echo ''; echo ''; $indexes = []; foreach( $result as $info ) { $indexes[ $info['Key_name'] ]['Key_name'] = $info['Key_name']; $indexes[ $info['Key_name'] ]['Column_name'][] = $info['Column_name']; $indexes[ $info['Key_name'] ]['Non_unique'] = $info['Non_unique']; $indexes[ $info['Key_name'] ]['Index_type'] = $info['Index_type']; } foreach( $indexes as $info ) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo '
Indexes
' . $info['Key_name'] . '' . implode( ', ', $info['Column_name'] ) . '' . ( $info['Non_unique'] ? '0' : 'Un' ) . '' . $info['Index_type'] . '
'; echo '
'; } else { echo '

Table ' . $table . ' doesn\'t exist

'; } }