Changeset 1509473

Timestamp:

10/06/2016 05:41:24 PM (8 years ago)

Author:

Stefan M.

Message:

4.0.0

• [Feature] New filter wctformoutput added for table filtering
• [Premium Feature] Possible to add standard (including PHP values) to custom forms

Location:

custom-tables/trunk

Files:

• custom-tables-search.php (modified) (1 diff)
• custom-tables-widget.php (modified) (1 diff)
• custom-tables.php (modified) (3 diffs)
• pages/save_forms.php (modified) (2 diffs)
• pages/setup_form.php (modified) (3 diffs)
• pages/show_form.php (modified) (5 diffs)
• readme.txt (modified) (3 diffs)
• updates/2016100601.php (added)

custom-tables/trunk/custom-tables-search.php

@@ -4 +4 @@
    Plugin URI: http://blog.murawski.ch/2011/08/custom-tables-wordpress-plugin/
    Description: [PREMIUM FEATURE] Extend the normal WordPress Search with the search in the Custom Tables
-   Version: 3.9.9
+   Version: 4.0.0
    Author: Web Updates KMU
    Author URI: http://wuk.ch/

custom-tables/trunk/custom-tables-widget.php

@@ -4 +4 @@
    Plugin URI: http://blog.murawski.ch/2011/08/custom-tables-wordpress-plugin/
    Description: [PREMIUM FEATURE] Delivers a Widget for Link Categories to a Custom Table
-   Version: 3.9.9
+   Version: 4.0.0
    Author: Web Updates KMU
    Author URI: http://wuk.ch/

custom-tables/trunk/custom-tables.php

@@ -4 +4 @@
    Plugin URI: http://blog.murawski.ch/2011/08/custom-tables-wordpress-plugin/
    Description: Create Tables and show on a page/article. Usable for all kind of diffrent databases.
-   Version: 3.9.9
+   Version: 4.0.0
    Author: Web Updates KMU
    Author URI: http://wuk.ch/
@@ -27 +27 @@
 */
 
-define('WCT_VERSION', '3.9.6');  
-define('WCT_DBVERSION', '2013102001');    
+define('WCT_VERSION', '4.0.0');  
+define('WCT_DBVERSION', '2016100601');    
 
 if (!function_exists('mres')) { function mres($t) { $t = esc_sql($t); return $t; } }
@@ -112 +112 @@
                 if ($this->settings['dbversion'] == "2012122308") { $this->dbupdate('2013030501',1); }
                 if ($this->settings['dbversion'] == "2013030501") { $this->dbupdate('2013102001',1); }
+                if ($this->settings['dbversion'] == "2013102001") { $this->dbupdate('2016100601',1); }
 
                 add_action('in_plugin_update_message-custom-tables/custom-tables.php', array(&$this, 'plugin_updates'));

custom-tables/trunk/pages/save_forms.php

@@ -15 +15 @@
             $feld .= rtrim(substr($var,(5 + strlen($_POST['wct_stable'])),1024)).",";
         }
+
     }
     if ($feld != '') { $feld = substr($feld,0,strlen($feld)-1); }
@@ -27 +28 @@
             $feld .= "<td>{".rtrim(substr($var,5,1024))."}</td>";
         }
+        elseif (substr($var,0,5) == "valu_") {
+            $feld2 .= trim($wert).",";
+        }
     }
-    $wpdb->get_row("UPDATE `".$wpdb->prefix."wct_form` SET `t_setup`='".mres($feld)."' WHERE `id`='".mres($formid)."' LIMIT 1;");
+        if ($feld2 != '') { $feld2 = substr($feld2,0,strlen($feld2)-1); }
+    $wpdb->get_row("UPDATE `".$wpdb->prefix."wct_form` SET `t_setup`='".mres($feld)."', `t_val`='".mres($feld2)."' WHERE `id`='".mres($formid)."' LIMIT 1;");
 }
 

custom-tables/trunk/pages/setup_form.php

@@ -101 +101 @@
 
         case 'tsetup':
-            echo "<h3>" . __('Table Setup','wct'). "</h3><input type=\"hidden\" name=\"ts\" value=\"1\"><table><tr><td><b>".__('Field','wct')."</b></td><td><b>".__('Show','wct')."&nbsp;</b></td><td><b>".__('Rights','wct')."</b></td></tr>";
-            $myrow = $wpdb->get_row("SELECT `r_fields`,`t_setup`,`r_table` FROM `".$wpdb->prefix."wct_form` WHERE `id`='".mres($formid)."' LIMIT 1;");          
+            echo "<h3>" . __('Table Setup','wct'). "</h3><input type=\"hidden\" name=\"ts\" value=\"1\"><table><tr><td><b>".__('Field','wct')."</b></td><td><b>".__('Show','wct')."&nbsp;</b></td><td><b>".__('Rights','wct')."</b></td><td><b>".__('Standard Value (PHP possible)','wct')."</b></td></tr>";
+            $myrow = $wpdb->get_row("SELECT `r_fields`,`t_setup`,`t_val`,`r_table` FROM `".$wpdb->prefix."wct_form` WHERE `id`='".mres($formid)."' LIMIT 1;");          
 
             $table = $wpdb->get_row("SHOW CREATE TABLE `".$wpdb->prefix."wct".$myrow->r_table."`;");
@@ -116 +116 @@
             $felder2 =  explode(",",$myrow->r_fields);
 
+            if (strstr($myrow->t_val,",")) { $valu = explode(",",$myrow->t_val); } else { $valu= array(); } 
+            $t = '0';
             foreach ($treffer as $f => $feld) {
                 $feld = str_replace("`","",$feld);
@@ -122 +124 @@
                 echo "></td><td><font color=\"";
                 if (in_array($feld,$felder2)) { echo "#00BF60\">yes"; } else { echo "#FF0000\">no"; }
-                echo "</font></td></tr>";
+                echo "</font></td><td><input type=\"text\" name=\"valu_".$feld."\" value=\"".str_replace("\"","&quot;",stripslashes($valu[$t]))."\"></td></tr>";
+                $t++;
             }
 

custom-tables/trunk/pages/show_form.php

@@ -3 +3 @@
 // [wctform id="1" limit="50"] als ausgabe zu Form 1
 
-$form = $wpdb->get_row("SELECT `e_setup`,`t_setup`,`rights`,`r_table`,`r_fields`,`r_filter`,`htmlview`,`smail`,`toapprove` FROM `".$wpdb->prefix."wct_form` WHERE `id`='".$id."' LIMIT 1;");
+$form = $wpdb->get_row("SELECT `e_setup`,`t_setup`,`t_val`,`rights`,`r_table`,`r_fields`,`r_filter`,`htmlview`,`smail`,`toapprove` FROM `".$wpdb->prefix."wct_form` WHERE `id`='".$id."' LIMIT 1;");
+$felder2 =  explode(",",$form->r_fields);
+
+if (strstr($form->t_val,",")) { $valu = explode(",",$form->t_val); } else { $valu= array(); } 
+for ($i=0;$felder2[$i]!='';$i++) {
+    // uses variables as std values
+    $val = str_replace(array("'","\"",";","[","]"),"",stripslashes($valu[$i]));
+    if (strstr($val,"\$_GET")) { $valu[$felder2[$i]] =  htmlentities($_GET[str_replace("\$_GET","",$val)]); }
+    elseif (strstr($val,"\$_POST")) { $valu[$felder2[$i]] = htmlentities($_POST[str_replace("\$_POST","",$val)]); }
+    elseif (strstr($val,"\$_REQUEST")) { $valu[$felder2[$i]] = htmlentities($_REQUEST[str_replace("\$_REQUEST","",$val)]); }
+    elseif (strstr($val,"\$")) { $val = str_replace("\$","",$val); $valu[$felder2[$i]] = htmlentities($$val); }
+    else { $valu[$felder2[$i]] = $val; }
+}
+
+
 if ($form->rights[3] == '1' AND $_GET['wctdfid'] != '') {
     if ($form->r_filter != '') { $filter = "AND ".sqldatefilter(stripslashes($form->r_filter)); } else { $filter = ''; }
@@ -142 +156 @@
             }
 
-            if ($feld2[$wert] == "smallint(6)") { $inhalt = str_replace("{".$wert."}","<input class=\"wct-formint6\" type=\"text\" name=\"".($addon != '' ? "wctn_" : "wctf_").$wert."\" value=\"\" maxsize=\"6\"".$addon."/>",$inhalt); }
+            if ($feld2[$wert] == "smallint(6)") { $inhalt = str_replace("{".$wert."}","<input class=\"wct-formint6\" type=\"text\" name=\"".($addon != '' ? "wctn_" : "wctf_").$wert."\" value=\"".$valu[$wert]."\" maxsize=\"6\"".$addon."/>",$inhalt); }
             elseif ($feld2[$wert] == "int(10)") { 
                 if (strpos($rights,",".$wert.",") === false) {
-                    $inhalt = str_replace("{".$wert."}","<input class=\"wct-formdate\" type=\"text\" name=\"wctn_".$wert."\" value=\"".date("Y-m-d",time())."\" maxsize=\"10\"".$addon.">",$inhalt);
+                    $inhalt = str_replace("{".$wert."}","<input class=\"wct-formdate\" type=\"text\" name=\"wctn_".$wert."\" value=\"".($valu[$wert] != '' ? $valu[$wert] : date("Y-m-d",time()))."\" maxsize=\"10\"".$addon.">",$inhalt);
                 }
                 else {
-                    $inhalt = str_replace("{".$wert."}","<input class=\"wct-formdate\" type=\"text\" name=\"wctf_".$wert."\" value=\"".date("Y-m-d",time())."\" maxsize=\"10\"".$addon.">",$inhalt);
-                }
-            }
-            elseif ($feld2[$wert] == "int(11)") { $inhalt = str_replace("{".$wert."}","<input class=\"wct-formint11\" type=\"text\" name=\"".($addon != '' ? "wctn_" : "wctf_").$wert."\" value=\"\" maxsize=\"11\"".$addon."/>",$inhalt); }
-            elseif ($feld2[$wert] == "varchar(32)") { $inhalt = str_replace("{".$wert."}","<input class=\"wct-formchar32\" type=\"text\" name=\"".($addon != '' ? "wctn_" : "wctf_").$wert."\" value=\"\" maxsize=\"32\"".$addon."/>",$inhalt); }
-            elseif ($feld2[$wert] == "varchar(64)") { $inhalt = str_replace("{".$wert."}","<input class=\"wct-formchar64\" type=\"text\" name=\"".($addon != '' ? "wctn_" : "wctf_").$wert."\" value=\"\" maxsize=\"64\"".$addon."/>",$inhalt); }
-            elseif ($feld2[$wert] == "varchar(128)") { $inhalt = str_replace("{".$wert."}","<input class=\"wct-formchar128\" type=\"text\" name=\"".($addon != '' ? "wctn_" : "wctf_").$wert."\" value=\"\" maxsize=\"128\"".$addon."/>",$inhalt); }
-            elseif ($feld2[$wert] == "varchar(160)" OR $feld2[$wert] == "varchar(254)") { $inhalt = str_replace("{".$wert."}","<input class=\"wct-formpic\" id=\"wctp_".$wert."\" type=\"file\" size=\"50\" name=\"wctp_".$wert."\" value=\"\" />",$inhalt); }
+                    $inhalt = str_replace("{".$wert."}","<input class=\"wct-formdate\" type=\"text\" name=\"wctf_".$wert."\" value=\"".($valu[$wert] != '' ? $valu[$wert] : date("Y-m-d",time()))."\" maxsize=\"10\"".$addon.">",$inhalt);
+                }
+            }
+            elseif ($feld2[$wert] == "int(11)") { $inhalt = str_replace("{".$wert."}","<input class=\"wct-formint11\" type=\"text\" name=\"".($addon != '' ? "wctn_" : "wctf_").$wert."\" value=\"".$valu[$wert]."\" maxsize=\"11\"".$addon."/>",$inhalt); }
+            elseif ($feld2[$wert] == "varchar(32)") { $inhalt = str_replace("{".$wert."}","<input class=\"wct-formchar32\" type=\"text\" name=\"".($addon != '' ? "wctn_" : "wctf_").$wert."\" value=\"".$valu[$wert]."\" maxsize=\"32\"".$addon."/>".$wert,$inhalt); }
+            elseif ($feld2[$wert] == "varchar(64)") { $inhalt = str_replace("{".$wert."}","<input class=\"wct-formchar64\" type=\"text\" name=\"".($addon != '' ? "wctn_" : "wctf_").$wert."\" value=\"".$valu[$wert]."\" maxsize=\"64\"".$addon."/>",$inhalt); }
+            elseif ($feld2[$wert] == "varchar(128)") { $inhalt = str_replace("{".$wert."}","<input class=\"wct-formchar128\" type=\"text\" name=\"".($addon != '' ? "wctn_" : "wctf_").$wert."\" value=\"".$valu[$wert]."\" maxsize=\"128\"".$addon."/>",$inhalt); }
+            elseif ($feld2[$wert] == "varchar(160)" OR $feld2[$wert] == "varchar(254)") { $inhalt = str_replace("{".$wert."}","<input class=\"wct-formpic\" id=\"wctp_".$wert."\" type=\"file\" size=\"50\" name=\"wctp_".$wert."\" value=\"".$valu[$wert]."\" />",$inhalt); }
             elseif (substr($feld2[$wert],0,4) == "enum") {
                 if ($addon == "") {
@@ -161 +175 @@
                     $defs = explode("xxxoooxxx",str_replace("'","",substr($feld2[$wert],6,(strlen(rtrim($feld2[$wert]))-8))));
                     foreach ($defs as $posibility) {
-                        $tmp .= "<option value=\"".$posibility."\">".$posibility."</option>";
+                        
+                        $tmp .= "<option value=\"".$posibility."\"".($valu[$wert] == $posibility ? ' selected' : '').">".$posibility."</option>";
                     }
                     $tmp .= "</select>";
                 }
                 else {
-                    $tmp = "<input size=\"10\" type=\"text\" name=\"wctn_".$wert."\" value=\"".stripslashes($row->$wert)."\" maxsize=\"32\"".$addon."/>";
+                    $tmp = "<input size=\"10\" type=\"text\" name=\"wctn_".$wert."\" value=\"".($valu[$wert] != '' ? $valu[$wert] : stripslashes($row->$wert))."\" maxsize=\"32\"".$addon."/>";
                 }
                 $inhalt = str_replace("{".$wert."}",$tmp,$inhalt);
@@ -176 +191 @@
                 foreach ($defs as $posibility) {
                     $ji++;
-                    $tmp .= "<div class=\"set_checkbox\"><input type=\"checkbox\" name=\"".($addon != '' ? "wctn_" : "wctf_").$wert."[]\" value=\"".$posibility."\">".substr($posibility,0,17)."</div>";
+                    $tmp .= "<div class=\"set_checkbox\"><input type=\"checkbox\" name=\"".($addon != '' ? "wctn_" : "wctf_").$wert."[]\" value=\"".$posibility."\"".($valu[$wert] == $posibility ? ' checked' : '').">".substr($posibility,0,17)."</div>";
                 }
                 $inhalt = str_replace("{".$wert."}",$tmp,$inhalt);
             }
-            elseif ($feld2[$wert] == "float(8.2)") { $inhalt = str_replace("{".$wert."}","<input size=\"12\" type=\"text\" name=\"".($addon != '' ? "wctn_" : "wctf_").$wert."\" value=\"\" maxsize=\"11\"".$addon."/>",$inhalt); }
+            elseif ($feld2[$wert] == "float(8.2)") { $inhalt = str_replace("{".$wert."}","<input size=\"12\" type=\"text\" name=\"".($addon != '' ? "wctn_" : "wctf_").$wert."\" value=\"".$valu[$wert]."\" maxsize=\"11\"".$addon."/>",$inhalt); }
             elseif ($feld2[$wert] == "text") {
                 if ($addon != '') { $addon = " style=\"background-color: #CCC;\" readonly=\"readonly\""; } else { $mytextfelder .= "wctf_".$wert.","; }
-                $inhalt = str_replace("{".$wert."}","<textarea class=\"wct-formtext\" id=\"wctf_".$wert."\" name=\"".($addon != '' ? "wctn_" : "wctf_").$wert."\" style=\"height: 155px;width: 100%;\"".$addon.">".stripslashes($row->$wert)."</textarea>",$inhalt);
+                $inhalt = str_replace("{".$wert."}","<textarea class=\"wct-formtext\" id=\"wctf_".$wert."\" name=\"".($addon != '' ? "wctn_" : "wctf_").$wert."\" style=\"height: 155px;width: 100%;\"".$addon.">".($valu[$wert] != '' ? $valu[$wert] : stripslashes($row->$wert))."</textarea>",$inhalt);
             }
         }
@@ -430 +445 @@
     
     $out .= "<input type=\"submit\" name=\"submit\" value=\"". __('Save all Changes', 'wct') ."\"></form>\n\n<!-- Custom Tables Plugin 05a1a29bdcae7b12229e651a9fd48b11 -->\n\n";
-    $out = do_shortcode(stripslashes($out));
+    $out = apply_filters('wctformoutput',do_shortcode(stripslashes($out)));
 }
 

custom-tables/trunk/readme.txt

@@ -1 @@
-wurde korrigiert=== custom tables ===
+=== custom tables ===
 Contributors: Stefan M.
 Donate link: http://blog.murawski.ch/2011/08/custom-tables-wordpress-plugin/
 Tags: custom tables, tables, databases, custom databases
 Requires at least: 3.8
-Tested up to: 3.8.1
+Tested up to: 4.6.1
 Stable tag: trunk
 
@@ -111 +111 @@
 == Changelog ==
 
+= 4.0.0 =
+* [Feature] New filter `wctformoutput` added for table filtering
+* [Premium Feature] Possible to add standard (including PHP values) to custom forms
+
 = 3.9.9 =
 * [Feature] Basic WPML Support added in tables, more details please see FAQ
@@ -139 +143 @@
 
 = 3.9.1 =
-* [Feature] New filger `wctoutput` added for table filtering
+* [Feature] New filter `wctoutput` added for table filtering
 * [Feature] Sortation in backendeditor is working on next pages