Changeset 21237 for extensions/whois_online/config.php

Timestamp:

Mar 6, 2013, 12:38:35 PM (11 years ago)

Author:

plg

Message:

compatibility with Piwigo 2.5: replace mysql_* functions by pwg_db_* equivalent

disable whois online feature for search engine robots to avoid useless CPU usage

File:

• extensions/whois_online/config.php (modified) (6 diffs)

extensions/whois_online/config.php

@@ -146 +146 @@
 // The whois_online table summary
 if (isset($_GET['tab']) and $_GET['tab']=='monitor') {
-  $whois_status = mysql_fetch_assoc(pwg_query('SHOW TABLE STATUS LIKE "' . WHOIS_ONLINE_TABLE .'%" ;'));
+  $whois_status = pwg_db_fetch_assoc(pwg_query('SHOW TABLE STATUS LIKE "' . WHOIS_ONLINE_TABLE .'%" ;'));
   $whois_status['table'] = WHOIS_ONLINE_TABLE;
   $whois_status['size'] = ($whois_status['Data_length'] + $whois_status['Index_length']) . ' bytes';
@@ -169 +169 @@
         if (!empty($result))
         {
-                while ($row = mysql_fetch_assoc($result))
+                while ($row = pwg_db_fetch_assoc($result))
                 {
                         $tpl[$row['session_id']] = $row['username'];
@@ -187 +187 @@
         if (!empty($result))
         {
-                while ($row = mysql_fetch_assoc($result))
+                while ($row = pwg_db_fetch_assoc($result))
                 {
                         $tpl[$row['session_id']] = $row['username'];
@@ -218 +218 @@
           'a:1:{s:6:"fields";a:5:{s:10:"date-after";s:10:"2009-09-09";s:11:"date-before";s:10:"2009-09-09";s:5:"types";a:4:{i:0;s:4:"none";i:1;s:7:"picture";i:2;s:4:"high";i:3;s:5:"other";}s:4:"user";s:2:"-1";s:17:"display_thumbnail";s:26:"display_thumbnail_hoverbox";}}'
           .'\');');
-          $conf_whois['Search id'] = mysql_insert_id();
+          $conf_whois['Search id'] = pwg_db_insert_id();
                 $conf['Whois Online'] = serialize($conf_whois);
                 pwg_query('REPLACE INTO ' . CONFIG_TABLE . " (param,value,comment)
@@ -224 +224 @@
         }
         // Get and Set to current date the stupid History search.
-        list($serialized_rules) = mysql_fetch_row(pwg_query('SELECT rules FROM '.SEARCH_TABLE.'
+        list($serialized_rules) = pwg_db_fetch_row(pwg_query('SELECT rules FROM '.SEARCH_TABLE.'
           WHERE id = '.$conf_whois['Search id'].';'));
         $page['search'] = unserialize($serialized_rules);
@@ -234 +234 @@
         // Most members ever online was
         if (!isset($conf_whois['Users']['count']) or $conf_whois['Users']['count'] == 0) {
-                $count = mysql_fetch_assoc(pwg_query('SELECT MAX(`'. $conf['user_fields']['id'] .'`) AS `ctr` FROM ' . USERS_TABLE));
+                $count = pwg_db_fetch_assoc(pwg_query('SELECT MAX(`'. $conf['user_fields']['id'] .'`) AS `ctr` FROM ' . USERS_TABLE));
                 $conf_whois['Users']['count'] = $count['ctr'];
         }