WordPress.org
Get WordPress

Plugin Directory

Changeset 1685146


Ignore:
Timestamp:
06/25/2017 05:23:34 PM (8 years ago)
Author:
Stefan M.
Message:

4.2.0

  • [Bugfix] PHP 7.1, 7.0, 5.6 and 5.4 Compatibility archived
Location:
custom-tables/trunk
Files:
4 edited

Legend:

Unmodified
Added
Removed

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

    r1553910 r1685146  
    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.1.1
     6   Version: 4.2.0
    77   Author: Web Updates KMU
    88   Author URI: http://wuk.ch/
    … …  
    2727*/
    2828
    29 define('WCT_VERSION', '4.1.1'); 
     29define('WCT_VERSION', '4.2.0'); 
    3030define('WCT_DBVERSION', '2016101601');   
    3131
    … …  
    6363        var $saltdone;
    6464        var $wctnr;
    65 
     65       
     66        function wuk_custom_tables() {
     67            self::__construct();
     68        }
    6669        function __construct() {
    6770            global $wpdb;

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

    r1553910 r1685146  
    227227        for($i=1;$i<=$x;$i++) {
    228228            if ($feld[$i] != 'id') {
    229                 echo "<input type=\"hidden\" name=\"wctff[]\" value=\"".$feld[$i]."\" /><tr><td style=\"width:150px;\"><strong>".$feld[$i]."</strong>&nbsp;</td><td>";
    230                 if ($feld2[$i] == "smallint(6)") { echo "<input size=\"7\" type=\"text\" name=\"wctf[]\" value=\"".stripslashes($qry->$feld[$i])."\" maxsize=\"6\"/>"; }
    231                 elseif ($feld2[$i] == "int(11)") { echo "<input size=\"12\" type=\"text\" name=\"wctf[]\" value=\"".stripslashes($qry->$feld[$i])."\" maxsize=\"11\"/>"; }
     229                $wass = $feld[$i];
     230                echo "<input type=\"hidden\" name=\"wctff[]\" value=\"".$feld[$i]."\" /><tr><td style=\"width:150px;\"><strong>".$wass."</strong>&nbsp;</td><td>";
     231                if ($feld2[$i] == "smallint(6)") { echo "<input size=\"7\" type=\"text\" name=\"wctf[]\" value=\"".stripslashes($qry->$wass)."\" maxsize=\"6\"/>"; }
     232                elseif ($feld2[$i] == "int(11)") { echo "<input size=\"12\" type=\"text\" name=\"wctf[]\" value=\"".stripslashes($qry->$wass)."\" maxsize=\"11\"/>"; }
    232233                elseif ($feld2[$i] == "int(10)") {
    233234                    echo "<input style=\"background-image: url('".plugins_url('custom-tables/jquery/cal.png')."');background-repeat: no-repeat;background-position: right center;\" size=\"14\" type=\"text\" id=\"datefield".$feld[$i]."\" name=\"wctf[]\" value=\"".date("Y-m-d",$qry->$feld[$i])."\"/>
    234235                    <script type=\"text/javascript\">jQuery(document).ready(function(){jQuery('#datefield".$feld[$i]."').datepicker({dateFormat : 'yy-mm-dd',firstDay: 1});});</script>";
    235236                }
    236                 elseif ($feld2[$i] == "varchar(32)") { echo "<input size=\"34\" type=\"text\" name=\"wctf[]\" value=\"".htmlspecialchars(stripslashes($qry->$feld[$i]), ENT_QUOTES)."\" maxsize=\"32\"/>"; }
    237                 elseif ($feld2[$i] == "varchar(64)") { echo "<input size=\"65\" type=\"text\" name=\"wctf[]\" value=\"".htmlspecialchars(stripslashes($qry->$feld[$i]), ENT_QUOTES)."\" maxsize=\"64\"/>"; }
    238                 elseif ($feld2[$i] == "varchar(128)") { echo "<input size=\"112\" type=\"text\" name=\"wctf[]\" value=\"".htmlspecialchars(stripslashes($qry->$feld[$i]), ENT_QUOTES)."\" maxsize=\"128\"/>"; }
     237                elseif ($feld2[$i] == "varchar(32)") { echo "<input size=\"34\" type=\"text\" name=\"wctf[]\" value=\"".htmlspecialchars(stripslashes($qry->$wass), ENT_QUOTES)."\" maxsize=\"32\"/>"; }
     238                elseif ($feld2[$i] == "varchar(64)") { echo "<input size=\"65\" type=\"text\" name=\"wctf[]\" value=\"".htmlspecialchars(stripslashes($qry->$wass), ENT_QUOTES)."\" maxsize=\"64\"/>"; }
     239                elseif ($feld2[$i] == "varchar(128)") { echo "<input size=\"112\" type=\"text\" name=\"wctf[]\" value=\"".htmlspecialchars(stripslashes($qry->$wass), ENT_QUOTES)."\" maxsize=\"128\"/>"; }
    239240                elseif ($feld2[$i] == "varchar(160)" OR $feld2[$i] == "varchar(254)") {
    240                     echo "<input id=\"upload_image".$feld[$i]."\" type=\"text\" size=\"90\" name=\"wctf[]\" value=\"".stripslashes($qry->$feld[$i])."\" /><input id=\"upload_image_button".$feld[$i]."\" type=\"button\" value=\"".__('Upload Image','wct')."\" />";
     241                    echo "<input id=\"upload_image".$feld[$i]."\" type=\"text\" size=\"90\" name=\"wctf[]\" value=\"".stripslashes($qry->$wass)."\" /><input id=\"upload_image_button".$feld[$i]."\" type=\"button\" value=\"".__('Upload Image','wct')."\" />";
    241242                    $picturefeld[] = $feld[$i];
    242243                }
    243244                elseif ($feld2[$i] == "text") {
    244245                    echo "<input type=\"hidden\" name=\"wctf[]\" value=\"SpeCial_".$feld[$i]."\"/>";
    245                     the_editor(stripslashes($qry->$feld[$i]), "wctfs_".$feld[$i], $feld[($i-1)], $media_buttons = false);
     246                    the_editor(stripslashes($qry->$wass), "wctfs_".$feld[$i], $feld[($i-1)], $media_buttons = false);
    246247                }
    247248                elseif (substr($feld2[$i],0,4) == "enum") {
    … …  
    250251                    foreach ($defs as $posibility) {
    251252                        echo "<option value=\"".$posibility."\"";
    252                         if ($posibility == stripslashes($qry->$feld[$i])) { echo " selected"; }
     253                        if ($posibility == stripslashes($qry->$wass)) { echo " selected"; }
    253254                        echo ">".$posibility."</option>";
    254255                    }
    … …  
    257258                elseif (substr($feld2[$i],0,3) == "set") {
    258259                    $defs = explode("'.'",substr($feld2[$i],5,(strlen(rtrim($feld2[$i]))-7)));
    259                     $wasjetzt = ",".stripslashes($qry->$feld[$i]).",";
     260                    $wasjetzt = ",".stripslashes($qry->$wass).",";
    260261                    echo "<input type=\"hidden\" name=\"wctf[]\" value=\"SpeCSet_".$feld[$i]."\">";
    261262                    foreach ($defs as $posibility) {
    … …  
    277278                            echo "<select name=\"wctf[]\">option value=\"\"></option>";
    278279                            foreach ($abfrage3 as $rel => $te) {
    279                                 if (stripslashes($qry->$feld[$i]) == $te->id) { $done = 1; }
    280                                 echo "<option value=\"".$te->id."\" ".(stripslashes($qry->$feld[$i]) == $te->id ? " selected" : "").">".$te->$felde.(($te->n2 != $te->$felde AND $te->n2 != '') ? " (".$te->n2.")" : "")."</option>";
     280                                if (stripslashes($qry->$wass) == $te->id) { $done = 1; }
     281                                echo "<option value=\"".$te->id."\" ".(stripslashes($qry->$wass) == $te->id ? " selected" : "").">".$te->$felde.(($te->n2 != $te->$felde AND $te->n2 != '') ? " (".$te->n2.")" : "")."</option>";
    281282                            }
    282                             if ($done != '1') { echo "<option value=\"".$qry->$feld[$i]."\" selected>--no change--</option>"; }
    283                             echo "</select> <a href=\"admin.php?page=wct_table_".$exists2->t_table."&wcttab=content&action=edit&rid=".$qry->$feld[$i]."\" style=\"text-decoration:none;\">[EDIT]</a>";
     283                            if ($done != '1') { echo "<option value=\"".$qry->$wass."\" selected>--no change--</option>"; }
     284                            echo "</select> <a href=\"admin.php?page=wct_table_".$exists2->t_table."&wcttab=content&action=edit&rid=".$qry->$wass."\" style=\"text-decoration:none;\">[EDIT]</a>";
    284285                        }
    285286                        else {
    … …  
    290291                    }
    291292                }
    292                 elseif ($feld2[$i] == "float(8.2)") { echo "<input size=\"12\" type=\"text\" name=\"wctf[]\" value=\"".stripslashes($qry->$feld[$i])."\" maxsize=\"11\"/>"; }
     293                elseif ($feld2[$i] == "float(8.2)") { echo "<input size=\"12\" type=\"text\" name=\"wctf[]\" value=\"".stripslashes($qry->$wass)."\" maxsize=\"11\"/>"; }
    293294                else {
    294295                    $abfrage =  $wpdb->get_row("SELECT `name` FROM `".$wpdb->prefix."wct_fields` WHERE `definition`='".str_replace(" ,",",",$feld2[$i])."' AND `special`='0' LIMIT 1;");
    295296                    if (count($abfrage) == '1') {
    296297                        if (preg_match("/\(([0-9]*)[,]{0,1}.*\)/",$abfrage->name,$treffer)) {
    297                             echo "<input size=\"".($treffer[1]+1)."\" type=\"text\" name=\"wctf[]\" value=\"".stripslashes($qry->$feld[$i])."\" maxsize=\"".$treffer[1]."\"/>";
    298                         }
    299                         echo "<input size=\"112\" type=\"text\" name=\"wctf[]\" value=\"".stripslashes($qry->$feld[$i])."\"/>";
     298                            echo "<input size=\"".($treffer[1]+1)."\" type=\"text\" name=\"wctf[]\" value=\"".stripslashes($qry->$wass)."\" maxsize=\"".$treffer[1]."\"/>";
     299                        }
     300                        echo "<input size=\"112\" type=\"text\" name=\"wctf[]\" value=\"".stripslashes($qry->$wass)."\"/>";
    300301                    }
    301302                    else {
    302                         echo __('undefinied field type','wct')."<input type=\"hidden\" name=\"wctf[]\" value=\"".stripslashes($qry->$feld[$i])."\" />";
     303                        echo __('undefinied field type','wct')."<input type=\"hidden\" name=\"wctf[]\" value=\"".stripslashes($qry->$wass)."\" />";
    303304                    }
    304305                }
    … …  
    636637            foreach ($qry as $row) {
    637638                $gs++;
     639               
    638640                if ($color == "#EEEEEE" ) { $color = "#DDDDDD"; } else { $color = "#EEEEEE"; }
    639641                echo "<tr onMouseOver=\"this.style.backgroundColor='#FFCCCC';\" onMouseOut=\"this.style.backgroundColor='".$color."';\" style=\"background-color:".$color." !important;\">";
    … …  
    654656                            echo "<input onkeyup=\"altered(this,'fff|".$tableid."|".$row->id."|".$feld[$i]."');\" style=\"width:95%;background-color:".$color.";\" type=\"text\" name=\"fde".$tableid."-".$row->id."\" value=\"";
    655657                        }
    656                         if (is_numeric($row->$feld[$i]) AND $row->$feld[$i] >= '700000000' AND $row->$feld[$i] < '3000000000') { echo date("Y-m-d",$row->$feld[$i]); }
    657                         else { echo $row->$feld[$i]; }
     658                        $wass = $feld[$i];
     659                        if (is_numeric($row->$wass) AND $row->$wass >= '700000000' AND $row->$wass < '3000000000') { echo date("Y-m-d",$row->$wass); }
     660                        else { echo $row->$wass; }
    658661                        if ($globaledit == '1' AND $i >= '2') { echo "\" />"; }
    659662                    }

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

    r1023039 r1685146  
    504504        echo "<div class=\"field\"><label><strong>". __('Table Name', 'wct') .":</strong>&nbsp;<input size=\"32\" type=\"text\" name=\"vipName\" value=\"".$tablename->name."\"></label></div>".
    505505             "<br/><strong>".__('Fields', 'wct').":</strong><br/>".
    506              "<input type=\"text\" name=\"id\" value=\"id\" readonly><input type=\"text\" name=\"idtype\" value=\"int(11) UNIQUE\" readonly><br/>".
    507              "<input type=\"text\" name=\"status\" value=\"status\" readonly><input type=\"text\" name=\"idtype\" value=\"enum('active','draft','passive')\" readonly><br/>".$feldoutput.
     506             "<input type=\"text\" name=\"id\" value=\"id\" style=\"width:52%;float:left;\" readonly><input style=\"width:40%;\" type=\"text\" name=\"idtype\" value=\"int(11) UNIQUE\" readonly><br/>".
     507             "<input type=\"text\" name=\"status\" style=\"width:52%;float:left;\" value=\"status\" readonly><input style=\"width:40%;\" type=\"text\" name=\"idtype\" value=\"enum('active','draft','passive')\" readonly><br/>".$feldoutput.
    508508             "<input type=\"button\" id=\"newFieldBtn\" value=\"". __('Add new Field', 'wct') ."\">&nbsp;".
    509509             "<br/><br/><input type=\"checkbox\" name=\"wctheaderline\" value=\"1\" id=\"wctheaderline\"";

  • custom-tables/trunk/readme.txt

    r1553910 r1685146  
    115115
    116116== Changelog ==
     117
     118= 4.2.0 =
     119* [Bugfix] PHP 7.1, 7.0, 5.6 and 5.4 Compatibility archived
    117120
    118121= 4.1.1 =
Note: See TracChangeset for help on using the changeset viewer.