Changeset 3202005

Timestamp:

12/03/2024 11:59:41 PM (15 months ago)

Author:

codecompiled

Message:

Updated database information displayed.

File:

• wp-settings/trunk/wp-settings.php (modified) (2 diffs)

wp-settings/trunk/wp-settings.php

@@ -4 +4 @@
 Plugin URI: https://wordpress.org/plugins/wp-settings/
 Description:Displays the important information about WordPress installation such as important wordpress settings,database settings,theme details and php information.You can generate DB Backup Script for restoring the database and for keeping database backups.
-Version: 2.2
+Version: 2.3
 Author: CodeCompiled
 Author URI: http://www.codecompiled.com
@@ -91 +91 @@
 
 function wpsettings_getMySqlDetails() {
-         global $wpdb;
-         $results = $wpdb->get_results('select version() as mysqlversion');
-         $sqlInfoVer;
-          foreach( $results as $result ) {
-            $sqlInfoVer= $result->mysqlversion;
-    }
-       $ws_mysqldetails=array();
-       $ws_mysqldetails["VERSION"]= $sqlInfoVer;//DB_NAME;
-       $ws_mysqldetails["DATABASE NAME"]=DB_NAME;
-       $ws_mysqldetails["DATABASE USER NAME"]=DB_USER;
-       $ws_mysqldetails["DATABASE HOST"]=DB_HOST;
-       $ws_mysqldetails["DATABASE SIZE(MB)"] = $wpdb->get_var("SELECT sum( data_length + index_length ) / 1024 / 1024 'dbsize' FROM information_schema.TABLES WHERE table_schema ='".DB_NAME."'");
-       $ws_mysqldetails["NO. OF TABLES"]= $wpdb->get_var("SELECT count(*) FROM INFORMATION_SCHEMA.TABLES WHERE table_schema='".DB_NAME."'");
-       return $ws_mysqldetails;
-    }
+    global $wpdb;
+    
+    // Query for MySQL version
+    $results = $wpdb->get_results('SELECT VERSION() as mysqlversion');
+    $sqlInfoVer = '';
+    foreach ($results as $result) {
+        $sqlInfoVer = $result->mysqlversion;
+    }
+
+    // Table schema name (DB_NAME) for information_schema queries
+    $tableSchema = DB_NAME;
+
+    // Fetching MySQL details
+    $ws_mysqldetails = array();
+    $ws_mysqldetails["VERSION"] = $sqlInfoVer;
+    $ws_mysqldetails["DATABASE NAME"] = DB_NAME;
+    $ws_mysqldetails["DATABASE USER NAME"] = DB_USER;
+    $ws_mysqldetails["DATABASE HOST"] = DB_HOST;
+    $ws_mysqldetails["DATABASE SIZE (MB)"] = $wpdb->get_var(
+        $wpdb->prepare(
+            "SELECT SUM(data_length + index_length) / 1024 / 1024 AS dbsize 
+             FROM information_schema.TABLES 
+             WHERE table_schema = %s",
+            $tableSchema
+        )
+    );
+    $ws_mysqldetails["NO. OF TABLES"] = $wpdb->get_var(
+        $wpdb->prepare(
+            "SELECT COUNT(*) 
+             FROM information_schema.TABLES 
+             WHERE table_schema = %s",
+            $tableSchema
+        )
+    );
+
+    // Fetching table names
+    $tableNames = $wpdb->get_col(
+        $wpdb->prepare(
+            "SELECT table_name 
+             FROM information_schema.TABLES 
+             WHERE table_schema = %s",
+            $tableSchema
+        )
+    );
+
+    // Convert array to comma-separated values
+    $ws_mysqldetails["TABLE NAMES"] = is_array($tableNames) ? implode(', ', $tableNames) : '';
+
+    return $ws_mysqldetails;
+}
 function wpsettings_bloginfo_array() {
     $fields = array('name', 'description', 'wpurl', 'url', 'admin_email', 'version','categories','pages','pingback_url', 'language');