Changeset 151781

Timestamp:

09/03/2009 12:45:28 PM (17 years ago)

Author:

pishmishy

Message:

Added ability to hide fields

File:

• wordpress-petition-plugin/trunk/fcpetition.php (modified) (10 diffs)

wordpress-petition-plugin/trunk/fcpetition.php

@@ -102 +102 @@
                         `type`  VARCHAR(10),
                         `opt`       TEXT,
+                        `hide`  TINYINT(1),
                         `ts`    TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                         UNIQUE KEY name (petition,name)
@@ -232 +233 @@
         $wpdb->get_results("ALTER TABLE $fields_table ADD `ts` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;");
     }
+    // Upgrade the petitions table if the hide field isn't present
+    if($wpdb->get_var("SHOW COLUMNS FROM $fields_table LIKE 'hide'") != "hide") {
+        $wpdb->get_results("ALTER TABLE $fields_table ADD `hide` TINYINT(1);");
+    }
     // Upgrade the signatures table if the keep_private column isn't present
     if($wpdb->get_var("SHOW COLUMNS FROM $signature_table LIKE 'keep_private'") != "keep_private") {
@@ -463 +468 @@
             }
             if ($row->fields<>""){
-                $fields = fcpetition_prettyvalues(unserialize(base64_decode($row->fields)));
+                $fields = fcpetition_prettyvalues(unserialize(base64_decode($row->fields)),$petition);
             }
             // Are comments enabled and a comment exists?
@@ -917 +922 @@
  * Adds a custom field to the database
  */
-function fcpetition_addfield($po,$fieldname,$fieldtype,$options){
+function fcpetition_addfield($po,$fieldname,$fieldtype,$options,$hidefield){
     global $wpdb;
     global $fields_table;
-    $sql = "INSERT into $fields_table (`petition`,`name`,`type`,`opt`) values ($po,'$fieldname','$fieldtype','$options')";
+    $sql = "INSERT into $fields_table (`petition`,`name`,`type`,`opt`,`hide`) values ($po,'$fieldname','$fieldtype','$options','$hidefield')";
     $wpdb->get_results($sql);
 }
@@ -947 +952 @@
         ?>
         <table>
-            <tr><thead><th>Name</th><th>Type</th><th>Options</th><th></th></thead></tr>
+            <tr><thead><th>Name</th><th>Type</th><th>Options</th><th>Printed</th><th></th></thead></tr>
         <?php
         foreach($res as $row){
@@ -970 +975 @@
                 </td>
                 <td>
+                    <?php if($row->hide == 0) { ?>
+                        No
+                    <?php } else { ?>
+                        Yes
+                     <?php } ?>
+                </td>                                                                                                                           
+                <td>
                     <form  method="post" action="<?php echo str_replace( '%7E', '~', $_SERVER['REQUEST_URI']); ?>"/>
                         <input type="hidden" name="fieldname" value="<?php echo $row->name; ?>"/>
@@ -1009 +1021 @@
     if(count($res)>0) {
         foreach($res as $row){
+            if($row->hide == 1) { $lmsg = __(" (won't be published)","fcpetition");} else { $lmsg = "";}
             if($row->type == "text") {
-                $output .= "$row->name:<br/><input type='$row->type' name='$row->name'/><br/>\n";
+                $output .= "$row->name$lmsg:<br/><input type='$row->type' name='$row->name'/><br/>\n";
             } elseif($row->type == "select") {
-                $output .= "$row->name:<br/><select name='$row->name'>";
+                $output .= "$row->name$lmsg:<br/><select name='$row->name'>";
                 foreach(split(",",$row->opt) as $d){
                     $output .= "<option value='$d'>$d</option>\n";
@@ -1062 +1075 @@
                 Name:<input type="text" name="fieldname"/>
                 Options:<input type="text" name="options"/>
+                Publish field <input type="checkbox" name="hide" checked/>
                 <input type="submit" name="Submit" value="<?php _e("Add","fcpetition")?>"/>
             </form>
@@ -1077 +1091 @@
 }
 
-function fcpetition_prettyvalues($package) {
+function fcpetition_prettyvalues($package,$petition) {
+    global $wpdb;
+    global $fields_table;
     if(!$package) return;
+    
+    foreach($wpdb->get_results("SELECT name,hide FROM $fields_table WHERE petition = '$petition' ORDER BY ts") as $row) {
+        $hide[$row->name] = $row->hide;
+    }
+
+    foreach ($package as $fieldname => $fieldvalue){
+            if($hide[$fieldname] == 1) {
+                unset($package[$fieldname]);
+            }
+    }
+
     $custom_fields = "";
     $custom_fields = htmlchars(implode(", ",$package));
@@ -1158 +1185 @@
         $fieldtype = $wpdb->escape($_POST['fieldtype']);
         $fieldname = $wpdb->escape($_POST['fieldname']);
+        $fieldhide = $wpdb->escape($_POST['hide'])=='on'?1:0;
         $fieldoptions = $wpdb->escape($_POST['options']);
-        fcpetition_addfield($po,$fieldname,$fieldtype,$fieldoptions);
+        fcpetition_addfield($po,$fieldname,$fieldtype,$fieldoptions,$fieldhide);
     }
     if ( $_POST['deletefield']) {