WordPress.org
Get WordPress

Plugin Directory

Changeset 1907781


Ignore:
Timestamp:
07/11/2018 04:42:22 PM (7 years ago)
Author:
Stefan M.
Message:

4.3.3

  • [Bugfix] PHP 7.x Fix for CSV Downloader
Location:
custom-tables/trunk
Files:
3 edited

Legend:

Unmodified
Added
Removed

  • custom-tables/trunk/custom-tables.php

    r1879921 r1907781  
    44   Plugin URI: http://blog.murawski.ch/2011/08/custom-tables-wordpress-plugin/
    55   Description: Create Tables and show on a page/article. Usable for all kind of diffrent databases.
    6    Version: 4.3.2
     6   Version: 4.3.3
    77   Author: Web Updates KMU
    88   Author URI: http://wuk.ch/
    … …  
    2727*/
    2828
    29 define('WCT_VERSION', '4.3.2'); 
     29define('WCT_VERSION', '4.3.3'); 
    3030define('WCT_DBVERSION', '2016101601');   
    3131

  • custom-tables/trunk/dl.php

    r785760 r1907781  
    4545function wctdebug() {
    4646    global $WCTDEBUG;
    47     if ($WCTDEBUG) { return mysql_error(); }
     47    if ($WCTDEBUG) { return mysqli_error(); }
    4848    else { return ''; }
    4949}
    … …  
    9696}
    9797
     98function mysqli_result($res, $row, $field=0) {
     99    $res->data_seek($row);
     100    $datarow = $res->fetch_array();
     101    return $datarow[$field];
     102}
     103
    98104if (is_numeric($_GET['i']) AND isset($_GET['l']) AND ($_GET['t'] == 'excel' OR $_GET['t'] == 'csv' OR $_GET['t'] == 'xml')) {
    99105    if ($WCTDEBUG) echo "In der Verarbeitung<br/>";
    100106    $num = (integer)$_GET['i'];
    101     $db = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die(wctdebug());
    102     mysql_select_db(DB_NAME,$db) or die(wctdebug());
    103 
    104     $secretchk = mysql_query("SELECT `id` FROM `".$wpdb->prefix."wct_list` WHERE `id`='".mysql_real_escape_string($num)."' AND `secret`='".mysql_real_escape_string($_GET['l'])."' LIMIT 1;", $db) or die(wctdebug());
    105     if (@mysql_num_rows($secretchk) == '1') {
    106         $table = mysql_query("SHOW CREATE TABLE `".$wpdb->prefix."wct".mysql_real_escape_string($num)."`;", $db) or die(wctdebug());
    107         if (@mysql_num_rows($table) == '1') {
     107    $db = new mysqli(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME) or die(wctdebug());
     108    $secretchk = $db->query("SELECT `id` FROM `".$wpdb->prefix."wct_list` WHERE `id`='".$db->real_escape_string($num)."' AND `secret`='".$db->real_escape_string($_GET['l'])."' LIMIT 1;") or die(wctdebug());
     109
     110   
     111    if (@mysqli_num_rows($secretchk) == '1') {
     112        $table = $db->query("SHOW CREATE TABLE `".$wpdb->prefix."wct".$db->real_escape_string($num)."`;") or die(wctdebug());
     113        if (@mysqli_num_rows($table) == '1') {
    108114            if ($_GET['t'] == 'csv') {
    109115                if (!$WCTDEBUG) {
    … …  
    119125                }
    120126                else { echo "Header xml gesetzt<br/>"; }
    121                 echo "<?xml version='1.0' standalone='yes'?>\r\n<table>\r\n\t<name>wct".mysql_real_escape_string($num)."</name>\r\n\t<header><![CDATA[";
     127                echo "<?xml version='1.0' standalone='yes'?>\r\n<table>\r\n\t<name>wct".$db->real_escape_string($num)."</name>\r\n\t<header><![CDATA[";
    122128
    123129            }
    … …  
    130136                else { echo "Header Excel gesetzt<br/>"; }
    131137            }
    132             $felder = explode("\n",mysql_result($table,0,"Create Table"));
     138            $felder = explode("\n",mysqli_result($table,0,"Create Table"));
    133139            for ($i=3;$felder[$i] != '';$i++) {
    134140                if ($_GET['t'] == 'csv') {
    … …  
    159165            if (isset($_GET['r'])) {
    160166                $addon = "WHERE `status`='active'";
    161                 if ($ids != '') { $addon .= " AND `id` IN(".mysql_real_escape_string($ids).")"; }
    162             }
    163             $abf = mysql_query("SHOW CREATE TABLE `".$wpdb->prefix."wct".mysql_real_escape_string($num)."`;", $db) or die(wctdebug());
    164             $create = mysql_result($abf,0,"Create Table");
     167                if ($ids != '') { $addon .= " AND `id` IN(".$db->real_escape_string($ids).")"; }
     168            }
     169            $abf = $db->query("SHOW CREATE TABLE `".$wpdb->prefix."wct".$db->real_escape_string($num)."`;") or die(wctdebug());
     170            $create = mysqli_result($abf,0,"Create Table");
    165171            $fields = explode("`",str_replace("` "," ",$create));
    166172            array_shift($fields); array_shift($fields);
    … …  
    171177            }
    172178           
    173             $abfrage = mysql_query("SELECT * FROM `".$wpdb->prefix."wct".mysql_real_escape_string($num)."` ".($addon != '' ? $addon : "").";", $db) or die(wctdebug());
    174             if (mysql_num_rows($abfrage) >= '1') {
     179            $abfrage = $db->query("SELECT * FROM `".$wpdb->prefix."wct".$db->real_escape_string($num)."` ".($addon != '' ? $addon : "").";") or die(wctdebug());
     180            if (mysqli_num_rows($abfrage) >= '1') {
    175181                if ($_GET['t'] == 'xml') { echo "\t<content>\r\n"; }
    176                 while ($row = mysql_fetch_array($abfrage))
     182                while ($row = $abfrage->fetch_array(MYSQLI_ASSOC))
    177183                {
    178184                    if ($_GET['t'] == 'excel') { echo "<tr>"; }
    … …  
    206212}
    207213elseif (isset($_GET['s'])) {
    208     $db = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die(wctdebug());
    209     mysql_select_db(DB_NAME,$db) or die(wctdebug());
    210 
    211     $qrya = mysql_query("SELECT `id` FROM `".$wpdb->prefix."wct_list` WHERE `secret`='".mysql_real_escape_string($_GET['s'])."' AND `id`='0' LIMIT 1;", $db) or die(wctdebug());
    212     if (@mysql_num_rows($qrya) >= '1') {
     214    $db = mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME) or die(wctdebug());
     215
     216    $qrya = $db->query("SELECT `id` FROM `".$wpdb->prefix."wct_list` WHERE `secret`='".$db->real_escape_string($_GET['s'])."' AND `id`='0' LIMIT 1;") or die(wctdebug());
     217    if (@mysqli_num_rows($qrya) >= '1') {
    213218
    214219        if (!$WCTDEBUG) {
    … …  
    220225            echo "Header ausgegeben<br/>";
    221226        }
    222         $qry = mysql_query("SELECT `blog_id`,`option_value` FROM `".$wpdb->prefix."options` WHERE `option_name`='wuk_custom_tables' LIMIT 1;",$db) or die(wctdebug());
     227        $qry = $db->query("SELECT `blog_id`,`option_value` FROM `".$wpdb->prefix."options` WHERE `option_name`='wuk_custom_tables' LIMIT 1;",$db) or die(wctdebug());
    223228        if (!$WCTDEBUG) {
    224229            echo "// Custom Tables Settings\r\n";
    225             echo "\$wpdb->get_row(\"DELETE FROM `\".\$wpdb->prefix.\"options` WHERE `blog_id`='".mysql_result($qry,0,"blog_id")."' AND `option_name`='wuk_custom_tables' LIMIT 1;\");\r\n";
    226             echo "\$wpdb->get_row(\"REPLACE INTO `\".\$wpdb->prefix.\"options` SET `blog_id`='".mysql_result($qry,0,"blog_id")."', `option_name`='wuk_custom_tables', `option_value`='".mysql_real_escape_string(mysql_result($qry,0,"option_value"))."', `autoload`='yes';\");\r\n\r\n";
     230            echo "\$wpdb->get_row(\"DELETE FROM `\".\$wpdb->prefix.\"options` WHERE `blog_id`='".mysqli_result($qry,0,"blog_id")."' AND `option_name`='wuk_custom_tables' LIMIT 1;\");\r\n";
     231            echo "\$wpdb->get_row(\"REPLACE INTO `\".\$wpdb->prefix.\"options` SET `blog_id`='".mysqli_result($qry,0,"blog_id")."', `option_name`='wuk_custom_tables', `option_value`='".$db->real_escape_string(mysqli_result($qry,0,"option_value"))."', `autoload`='yes';\");\r\n\r\n";
    227232            echo "\$wpdb->get_row(\"DELETE FROM `\".\$wpdb->prefix.\"wct_list`;\");\r\n\r\n";
    228233        }
    229234        else { echo "Settings ausgegeben<br/>"; }
    230235
    231         $qry = mysql_query("SELECT * FROM `".$table_prefix."wct_list` ORDER BY `id` ASC;",$db) or die(wctdebug());
    232         if (@mysql_num_rows($qry) >= '1') {
    233             while ($row = mysql_fetch_assoc($qry)) {
     236        $qry = $db->query("SELECT * FROM `".$table_prefix."wct_list` ORDER BY `id` ASC;",$db) or die(wctdebug());
     237        if (@mysqli_num_rows($qry) >= '1') {
     238            while ($row = $qry->fetch_array(MYSQLI_ASSOC)) {
    234239                if (!$WCTDEBUG) {
    235240                    echo "// Table '".$row[name]."':\r\n";
    236241                    if ($row[id] != '0') { $secret = $row[secret]; } else { $secret = '-- none --'; }
    237                     echo "\$wpdb->get_row(\"INSERT INTO `\".\$wpdb->prefix.\"wct_list` SET `id`='".$row[id]."', `name`='".mysql_real_escape_string($row[name])."', `secret`='".$secret."', `t_setup`='".mysql_real_escape_string($row[t_setup])."', `e_setup`='".mysql_real_escape_string($row[e_setup])."', `o_setup`='".mysql_real_escape_string($row[o_setup])."', `sheme`='".$row[sheme]."', `overlay`='".mysql_real_escape_string($row[overlay])."', `headerline`='".mysql_real_escape_string($row[headerline])."', `header`='".mysql_real_escape_string($row[header])."', `headersort`='".mysql_real_escape_string($row[headersort])."', `vortext`='".mysql_real_escape_string($row[vortext])."', `nachtext`='".mysql_real_escape_string($row[nachtext])."', `sort`='".$row[sort]."', `sortB`='".$row[sortB]."', `searchaddon`='".$row[searchaddon]."';\");\r\n";
     242                    echo "\$wpdb->get_row(\"INSERT INTO `\".\$wpdb->prefix.\"wct_list` SET `id`='".$row[id]."', `name`='".$db->real_escape_string($row[name])."', `secret`='".$secret."', `t_setup`='".$db->real_escape_string($row[t_setup])."', `e_setup`='".$db->real_escape_string($row[e_setup])."', `o_setup`='".$db->real_escape_string($row[o_setup])."', `sheme`='".$row[sheme]."', `overlay`='".$db->real_escape_string($row[overlay])."', `headerline`='".$db->real_escape_string($row[headerline])."', `header`='".$db->real_escape_string($row[header])."', `headersort`='".$db->real_escape_string($row[headersort])."', `vortext`='".$db->real_escape_string($row[vortext])."', `nachtext`='".$db->real_escape_string($row[nachtext])."', `sort`='".$row[sort]."', `sortB`='".$row[sortB]."', `searchaddon`='".$row[searchaddon]."';\");\r\n";
    238243                } else { echo "Tabelle: Erstellt"; }
    239244
    240245                if ($row[id] != '0') {
    241                     $tablet = mysql_query("SHOW CREATE TABLE `".$table_prefix."wct".$row[id]."`;");
     246                    $tablet = $db->query("SHOW CREATE TABLE `".$table_prefix."wct".$row[id]."`;");
    242247
    243248                    if (!$WCTDEBUG) {
    244249                        echo "\$wpdb->get_row(\"DROP TABLE `\".\$wpdb->prefix.\"wct".$row[id]."`;\");\r\n";
    245                         echo "\$wpdb->get_row(\"".str_replace($table_prefix,"\".\$wpdb->prefix.\"",rbr(mysql_result($tablet,0,'Create Table'),'')).";\");\r\n";
     250                        echo "\$wpdb->get_row(\"".str_replace($table_prefix,"\".\$wpdb->prefix.\"",rbr(mysqli_result($tablet,0,'Create Table'),'')).";\");\r\n";
    246251                    } else { echo ", Drop &amp; Create, Inhalt:<br/>"; }
    247252
    248                     $abfrage = mysql_query("SELECT * FROM `".$table_prefix."wct".$row[id]."`;",$db) or die(wctdebug());
    249                     if (@mysql_num_rows($abfrage) >= '1') {
     253                    $abfrage = $db->query("SELECT * FROM `".$table_prefix."wct".$row[id]."`;",$db) or die(wctdebug());
     254                    if (@mysqli_num_rows($abfrage) >= '1') {
    250255                        while ($row2 = mysql_fetch_assoc($abfrage)) {
    251256                            $x='0';
    … …  
    254259                                if (!$WCTDEBUG AND $x >= '1') { echo ","; }
    255260                                $x++;
    256                                 if (!$WCTDEBUG) echo " `".$var."`='".mysql_real_escape_string($wert)."'";
     261                                if (!$WCTDEBUG) echo " `".$var."`='".$db->real_escape_string($wert)."'";
    257262                            }
    258263                            if (!$WCTDEBUG) { echo ";\");\r\n"; } else { echo ". "; }
    … …  
    268273        }
    269274
    270         $qry = mysql_query("SELECT * FROM `".$table_prefix."wct_setup` ORDER BY `id` ASC;",$db) or die(wctdebug());
    271         if (@mysql_num_rows($qry) >= '1') {
    272             while ($row = mysql_fetch_assoc($qry)) {
     275        $qry = $db->query("SELECT * FROM `".$table_prefix."wct_setup` ORDER BY `id` ASC;",$db) or die(wctdebug());
     276        if (@mysqli_num_rows($qry) >= '1') {
     277            while ($row = $qry->fetch_array(MYSQLI_ASSOC)) {
    273278                if (!$WCTDEBUG) {
    274279                    echo "// Table '".$row[table_id]."' Alternate Design '".$row[name]."':\r\n";
    275                     echo "\$wpdb->get_row(\"INSERT INTO `\".\$wpdb->prefix.\"wct_setup` SET `id`='".$row[id]."', `name`='".mysql_real_escape_string($row[name])."', `table_id`='".mysql_real_escape_string($row[table_id])."', `t_setup`='".mysql_real_escape_string($row[t_setup])."', `e_setup`='".mysql_real_escape_string($row[e_setup])."', `o_setup`='".mysql_real_escape_string($row[o_setup])."', `sheme`='".$row[sheme]."', `overlay`='".mysql_real_escape_string($row[overlay])."', `headerline`='".mysql_real_escape_string($row[headerline])."', `header`='".mysql_real_escape_string($row[header])."', `headersort`='".mysql_real_escape_string($row[headersort])."', `vortext`='".mysql_real_escape_string($row[vortext])."', `nachtext`='".mysql_real_escape_string($row[nachtext])."', `sort`='".$row[sort]."', `sortB`='".$row[sortB]."', `searchaddon`='".$row[searchaddon]."';\");\r\n";
     280                    echo "\$wpdb->get_row(\"INSERT INTO `\".\$wpdb->prefix.\"wct_setup` SET `id`='".$row[id]."', `name`='".$db->real_escape_string($row[name])."', `table_id`='".$db->real_escape_string($row[table_id])."', `t_setup`='".$db->real_escape_string($row[t_setup])."', `e_setup`='".$db->real_escape_string($row[e_setup])."', `o_setup`='".$db->real_escape_string($row[o_setup])."', `sheme`='".$row[sheme]."', `overlay`='".$db->real_escape_string($row[overlay])."', `headerline`='".$db->real_escape_string($row[headerline])."', `header`='".$db->real_escape_string($row[header])."', `headersort`='".$db->real_escape_string($row[headersort])."', `vortext`='".$db->real_escape_string($row[vortext])."', `nachtext`='".$db->real_escape_string($row[nachtext])."', `sort`='".$row[sort]."', `sortB`='".$row[sortB]."', `searchaddon`='".$row[searchaddon]."';\");\r\n";
    276281                } else { echo "Alternative Designs: Erstellt"; }
    277282
    … …  
    283288        else { echo "<br/>Bestehende Forms l&ouml;schen<br/>"; }
    284289
    285         $qry = mysql_query("SELECT * FROM `".$table_prefix."wct_form` ORDER BY `id` ASC;",$db) or die(wctdebug());
    286         if (@mysql_num_rows($qry) >= '1') {
    287             while ($row = mysql_fetch_assoc($qry)) {
     290        $qry = $db->query("SELECT * FROM `".$table_prefix."wct_form` ORDER BY `id` ASC;",$db) or die(wctdebug());
     291        if (@mysqli_num_rows($qry) >= '1') {
     292            while ($row = $qry->fetch_array(MYSQLI_ASSOC)) {
    288293                if (!$WCTDEBUG) {
    289294                    echo "// Form '".$row[name]."':\r\n";
    290                     echo "\$wpdb->get_row(\"INSERT INTO `\".\$wpdb->prefix.\"wct_form` SET `id`='".$row[id]."', `name`='".mysql_real_escape_string($row[name])."', `t_setup`='".mysql_real_escape_string($row[t_setup])."', `e_setup`='".mysql_real_escape_string($row[e_setup])."', `r_fields`='".mysql_real_escape_string($row[r_fields])."', `r_table`='".$row[r_table]."', `r_filter`='".mysql_real_escape_string($row[r_filter])."', `rights`='".mysql_real_escape_string($row[rights])."'\");\r\n";
     295                    echo "\$wpdb->get_row(\"INSERT INTO `\".\$wpdb->prefix.\"wct_form` SET `id`='".$row[id]."', `name`='".$db->real_escape_string($row[name])."', `t_setup`='".$db->real_escape_string($row[t_setup])."', `e_setup`='".$db->real_escape_string($row[e_setup])."', `r_fields`='".$db->real_escape_string($row[r_fields])."', `r_table`='".$row[r_table]."', `r_filter`='".$db->real_escape_string($row[r_filter])."', `rights`='".$db->real_escape_string($row[rights])."'\");\r\n";
    291296                    echo "\r\n";
    292297                }
    … …  
    300305        else { echo "<br/>Bestehende Cronjobs l&ouml;schen<br/>"; }
    301306
    302         $qry = mysql_query("SELECT * FROM `".$table_prefix."wct_cron` ORDER BY `id` ASC;",$db) or die(wctdebug());
    303         if (@mysql_num_rows($qry) >= '1') {
    304             while ($row = mysql_fetch_assoc($qry)) {
     307        $qry = $db->query("SELECT * FROM `".$table_prefix."wct_cron` ORDER BY `id` ASC;",$db) or die(wctdebug());
     308        if (@mysqli_num_rows($qry) >= '1') {
     309            while ($row = $qry->fetch_array(MYSQLI_ASSOC)) {
    305310                if (!$WCTDEBUG) {
    306311                    echo "// Cron '".$row[id]."':\r\n";
    307                     echo "\$wpdb->get_row(\"INSERT INTO `\".\$wpdb->prefix.\"wct_cron` SET `id`='".$row[id]."', `schedule`='".mysql_real_escape_string($row[schedule])."', `command`='".mysql_real_escape_string($row[command])."', `nextrun`='".mysql_real_escape_string($row[nextrun])."', `error`='".mysql_real_escape_string($row[error])."', `active`='".$row[active]."'\");\r\n";
     312                    echo "\$wpdb->get_row(\"INSERT INTO `\".\$wpdb->prefix.\"wct_cron` SET `id`='".$row[id]."', `schedule`='".$db->real_escape_string($row[schedule])."', `command`='".$db->real_escape_string($row[command])."', `nextrun`='".$db->real_escape_string($row[nextrun])."', `error`='".$db->real_escape_string($row[error])."', `active`='".$row[active]."'\");\r\n";
    308313                    echo "\r\n";
    309314                }

  • custom-tables/trunk/readme.txt

    r1879921 r1907781  
    115115
    116116== Changelog ==
     117
     118= 4.3.3 =
     119* [Bugfix] PHP 7.x Fix for CSV Downloader
    117120
    118121= 4.3.2 =
Note: See TracChangeset for help on using the changeset viewer.