Index: trunk/wb/modules/form/install.php =================================================================== --- trunk/wb/modules/form/install.php (revision 80) +++ trunk/wb/modules/form/install.php (nonexistent) @@ -1,103 +0,0 @@ - - Copyright (C) 2004-2005, Ryan Djurovich - - Website Baker is free software; you can redistribute it and/or modify - it under the terms of the GNU General Public License as published by - the Free Software Foundation; either version 2 of the License, or - (at your option) any later version. - - Website Baker is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU General Public License for more details. - - You should have received a copy of the GNU General Public License - along with Website Baker; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -*/ - -/* -The Website Baker Project would like to thank Rudolph Lartey -for his contributions to this module - adding extra field types -*/ - -if(defined('WB_URL')) { - - // Create tables - $database->query("DROP TABLE IF EXISTS `".TABLE_PREFIX."mod_form_fields`"); - $mod_form = 'CREATE TABLE `'.TABLE_PREFIX.'mod_form_fields` ( `field_id` INT NOT NULL AUTO_INCREMENT,' - . ' `section_id` INT NOT NULL ,' - . ' `page_id` INT NOT NULL ,' - . ' `position` INT NOT NULL ,' - . ' `title` VARCHAR(255) NOT NULL ,' - . ' `type` VARCHAR(255) NOT NULL ,' - . ' `required` INT NOT NULL ,' - . ' `value` TEXT NOT NULL ,' - . ' `extra` TEXT NOT NULL ,' - . ' PRIMARY KEY ( `field_id` ) )' - . ' '; - $database->query($mod_form); - $database->query("DROP TABLE IF EXISTS `".TABLE_PREFIX."mod_form_settings`"); - $mod_form = 'CREATE TABLE `'.TABLE_PREFIX.'mod_form_settings` (' - . ' `section_id` INT NOT NULL,' - . ' `page_id` INT NOT NULL,' - . ' `header` TEXT NOT NULL ,' - . ' `field_loop` TEXT NOT NULL ,' - . ' `footer` TEXT NOT NULL ,' - . ' `email_to` TEXT NOT NULL ,' - . ' `email_from` VARCHAR(255) NOT NULL ,' - . ' `email_subject` VARCHAR(255) NOT NULL ,' - . ' `success_message` TEXT NOT NULL ,' - . ' `stored_submissions` INT NOT NULL,' - . ' `max_submissions` INT NOT NULL,' - . ' PRIMARY KEY ( `section_id` ) )' - . ' '; - $database->query($mod_form); - $database->query("DROP TABLE IF EXISTS `".TABLE_PREFIX."mod_form_submissions`"); - $mod_form = 'CREATE TABLE `'.TABLE_PREFIX.'mod_form_submissions` ( `submission_id` INT NOT NULL AUTO_INCREMENT,' - . ' `section_id` INT NOT NULL,' - . ' `page_id` INT NOT NULL,' - . ' `submitted_when` INT NOT NULL,' - . ' `submitted_by` INT NOT NULL,' - . ' `body` TEXT NOT NULL ,' - . ' PRIMARY KEY ( `submission_id` ) )' - . ' '; - $database->query($mod_form); - - // Insert info into the search table - // Module query info - $field_info = array(); - $field_info['page_id'] = 'page_id'; - $field_info['title'] = 'page_title'; - $field_info['link'] = 'link'; - $field_info['description'] = 'description'; - $field_info['modified_when'] = 'modified_when'; - $field_info['modified_by'] = 'modified_by'; - $field_info = serialize($field_info); - $database->query("INSERT INTO ".TABLE_PREFIX."search (name,value,extra) VALUES ('module', 'form', '$field_info')"); - // Query start - $query_start_code = "SELECT [TP]pages.page_id, [TP]pages.page_title, [TP]pages.link, [TP]pages.description, [TP]pages.modified_when, [TP]pages.modified_by FROM [TP]mod_form_fields, [TP]mod_form_settings, [TP]pages WHERE "; - $database->query("INSERT INTO ".TABLE_PREFIX."search (name,value,extra) VALUES ('query_start', '$query_start_code', 'form')"); - // Query body - $query_body_code = " [TP]pages.page_id = [TP]mod_form_settings.page_id AND [TP]mod_form_settings.header [O] \'[W][STRING][W]\' AND [TP]pages.searching = \'1\' - OR [TP]pages.page_id = [TP]mod_form_settings.page_id AND [TP]mod_form_settings.footer [O] \'[W][STRING][W]\' AND [TP]pages.searching = \'1\' - OR [TP]pages.page_id = [TP]mod_form_fields.page_id AND [TP]mod_form_fields.title [O] \'[W][STRING][W]\' AND [TP]pages.searching = \'1\'"; - $database->query("INSERT INTO ".TABLE_PREFIX."search (name,value,extra) VALUES ('query_body', '$query_body_code', 'form')"); - // Query end - $query_end_code = ''; - $database->query("INSERT INTO ".TABLE_PREFIX."search (name,value,extra) VALUES ('query_end', '$query_end_code', 'form')"); - - // Insert blank row (there needs to be at least on row for the search to work) - $database->query("INSERT INTO ".TABLE_PREFIX."mod_form_fields (page_id,section_id) VALUES ('0','0')"); - $database->query("INSERT INTO ".TABLE_PREFIX."mod_form_settings (page_id,section_id) VALUES ('0','0')"); - -} - -?> \ No newline at end of file Property changes on: trunk/wb/modules/form/install.php ___________________________________________________________________ Deleted: svn:executable ## -1 +0,0 ## -* \ No newline at end of property Deleted: svn:keywords ## -1 +0,0 ## -Id \ No newline at end of property Index: trunk/wb/modules/form/modify_settings.php =================================================================== --- trunk/wb/modules/form/modify_settings.php (revision 80) +++ trunk/wb/modules/form/modify_settings.php (nonexistent) @@ -1,147 +0,0 @@ - - Copyright (C) 2004-2005, Ryan Djurovich - - Website Baker is free software; you can redistribute it and/or modify - it under the terms of the GNU General Public License as published by - the Free Software Foundation; either version 2 of the License, or - (at your option) any later version. - - Website Baker is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU General Public License for more details. - - You should have received a copy of the GNU General Public License - along with Website Baker; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -*/ - -/* -The Website Baker Project would like to thank Rudolph Lartey -for his contributions to this module - adding extra field types -*/ - -require('../../config.php'); - -// Include WB admin wrapper script -require(WB_PATH.'/modules/admin.php'); - -// Get header and footer -$query_content = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_form_settings WHERE section_id = '$section_id'"); -$setting = $query_content->fetchRow(); - -// Set raw html <'s and >'s to be replace by friendly html code -$raw = array('<', '>'); -$friendly = array('<', '>'); - -?> - - - -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
: - -
: - -
: - -
: - -
: - - -
: - -
: - -
: - -
: - -
- - - - - - -
  - - - -
- - -print_footer(); - -?> \ No newline at end of file Property changes on: trunk/wb/modules/form/modify_settings.php ___________________________________________________________________ Deleted: svn:executable ## -1 +0,0 ## -* \ No newline at end of property Deleted: svn:keywords ## -1 +0,0 ## -Id \ No newline at end of property Index: trunk/wb/modules/form/delete_submission.php =================================================================== --- trunk/wb/modules/form/delete_submission.php (revision 80) +++ trunk/wb/modules/form/delete_submission.php (nonexistent) @@ -1,57 +0,0 @@ - - Copyright (C) 2004-2005, Ryan Djurovich - - Website Baker is free software; you can redistribute it and/or modify - it under the terms of the GNU General Public License as published by - the Free Software Foundation; either version 2 of the License, or - (at your option) any later version. - - Website Baker is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU General Public License for more details. - - You should have received a copy of the GNU General Public License - along with Website Baker; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -*/ - -/* -The Website Baker Project would like to thank Rudolph Lartey -for his contributions to this module - adding extra submission types -*/ - -require('../../config.php'); - -// Get id -if(!isset($_GET['submission_id']) OR !is_numeric($_GET['submission_id'])) { - header("Location: ".ADMIN_URL."/pages/index.php"); -} else { - $submission_id = $_GET['submission_id']; -} - -// Include WB admin wrapper script -$update_when_modified = true; // Tells script to update when this page was last updated -require(WB_PATH.'/modules/admin.php'); - -// Delete row -$database->query("DELETE FROM ".TABLE_PREFIX."mod_form_submissions WHERE submission_id = '$submission_id'"); - -// Check if there is a db error, otherwise say successful -if($database->is_error()) { - $admin->print_error($database->get_error(), ADMIN_URL.'/pages/modify.php?page_id='.$page_id); -} else { - $admin->print_success($TEXT['SUCCESS'], ADMIN_URL.'/pages/modify.php?page_id='.$page_id); -} - -// Print admin footer -$admin->print_footer(); - -?> \ No newline at end of file Property changes on: trunk/wb/modules/form/delete_submission.php ___________________________________________________________________ Deleted: svn:keywords ## -1 +0,0 ## -Id \ No newline at end of property Index: trunk/wb/modules/form/save_settings.php =================================================================== --- trunk/wb/modules/form/save_settings.php (revision 80) +++ trunk/wb/modules/form/save_settings.php (nonexistent) @@ -1,79 +0,0 @@ - - Copyright (C) 2004-2005, Ryan Djurovich - - Website Baker is free software; you can redistribute it and/or modify - it under the terms of the GNU General Public License as published by - the Free Software Foundation; either version 2 of the License, or - (at your option) any later version. - - Website Baker is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU General Public License for more details. - - You should have received a copy of the GNU General Public License - along with Website Baker; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -*/ - -/* -The Website Baker Project would like to thank Rudolph Lartey -for his contributions to this module - adding extra field types -*/ - -require('../../config.php'); - -// Include WB admin wrapper script -$update_when_modified = true; // Tells script to update when this page was last updated -require(WB_PATH.'/modules/admin.php'); - -// This code removes any ', ''); -$header = $admin->add_slashes($_POST['header']); -$field_loop = $admin->add_slashes($_POST['field_loop']); -$footer = $admin->add_slashes($_POST['footer']); -$email_to = $admin->add_slashes($_POST['email_to']); -if($_POST['email_from_field'] == '') { - $email_from = $admin->add_slashes($_POST['email_from']); -} else { - $email_from = $admin->add_slashes($_POST['email_from_field']); -} -$email_subject = $admin->add_slashes($_POST['email_subject']); -$success_message = $admin->add_slashes($_POST['success_message']); -if(!is_numeric($_POST['max_submissions'])) { - $max_submissions = 50; -} else { - $max_submissions = $_POST['max_submissions']; -} -if(!is_numeric($_POST['stored_submissions'])) { - $stored_submissions = 100; -} else { - $stored_submissions = $_POST['stored_submissions']; -} -// Make sure max submissions is not smaller than stored submissions -if($max_submissions < $stored_submissions) { - $max_submissions = $stored_submissions; -} - -// Update settings -$database->query("UPDATE ".TABLE_PREFIX."mod_form_settings SET header = '$header', field_loop = '$field_loop', footer = '$footer', email_to = '$email_to', email_from = '$email_from', email_subject = '$email_subject', success_message = '$success_message', max_submissions = '$max_submissions', stored_submissions = '$stored_submissions' WHERE section_id = '$section_id'"); - -// Check if there is a db error, otherwise say successful -if($database->is_error()) { - $admin->print_error($database->get_error(), ADMIN_URL.'/pages/modify.php?page_id='.$page_id); -} else { - $admin->print_success($TEXT['SUCCESS'], ADMIN_URL.'/pages/modify.php?page_id='.$page_id); -} - -// Print admin footer -$admin->print_footer(); - -?> \ No newline at end of file Property changes on: trunk/wb/modules/form/save_settings.php ___________________________________________________________________ Deleted: svn:executable ## -1 +0,0 ## -* \ No newline at end of property Deleted: svn:keywords ## -1 +0,0 ## -Id \ No newline at end of property Index: trunk/wb/modules/form/move_up.php =================================================================== --- trunk/wb/modules/form/move_up.php (revision 80) +++ trunk/wb/modules/form/move_up.php (nonexistent) @@ -1,57 +0,0 @@ - - Copyright (C) 2004-2005, Ryan Djurovich - - Website Baker is free software; you can redistribute it and/or modify - it under the terms of the GNU General Public License as published by - the Free Software Foundation; either version 2 of the License, or - (at your option) any later version. - - Website Baker is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU General Public License for more details. - - You should have received a copy of the GNU General Public License - along with Website Baker; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -*/ - -/* -The Website Baker Project would like to thank Rudolph Lartey -for his contributions to this module - adding extra field types -*/ - -require('../../config.php'); - -// Get id -if(!isset($_GET['field_id']) OR !is_numeric($_GET['field_id'])) { - header("Location: index.php"); -} else { - $field_id = $_GET['field_id']; -} - -// Include WB admin wrapper script -require(WB_PATH.'/modules/admin.php'); - -// Include the ordering class -require(WB_PATH.'/framework/class.order.php'); - -// Create new order object an reorder -$order = new order(TABLE_PREFIX.'mod_form_fields', 'position', 'field_id', 'section_id'); -if($order->move_up($field_id)) { - $admin->print_success($TEXT['SUCCESS'], ADMIN_URL.'/pages/modify.php?page_id='.$page_id); -} else { - $admin->print_error($TEXT['ERROR'], ADMIN_URL.'/pages/modify.php?page_id='.$page_id); -} - -// Print admin footer -$admin->print_footer(); - -?> \ No newline at end of file Property changes on: trunk/wb/modules/form/move_up.php ___________________________________________________________________ Deleted: svn:executable ## -1 +0,0 ## -* \ No newline at end of property Deleted: svn:keywords ## -1 +0,0 ## -Id \ No newline at end of property Index: trunk/wb/modules/form/view.php =================================================================== --- trunk/wb/modules/form/view.php (revision 80) +++ trunk/wb/modules/form/view.php (nonexistent) @@ -1,323 +0,0 @@ - - Copyright (C) 2004-2005, Ryan Djurovich - - Website Baker is free software; you can redistribute it and/or modify - it under the terms of the GNU General Public License as published by - the Free Software Foundation; either version 2 of the License, or - (at your option) any later version. - - Website Baker is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU General Public License for more details. - - You should have received a copy of the GNU General Public License - along with Website Baker; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -*/ - -/* -The Website Baker Project would like to thank Rudolph Lartey -for his contributions to this module - adding extra field types -*/ - -// Must include code to stop this file being access directly -if(defined('WB_PATH') == false) { exit("Cannot access this file directly"); } - -// Function for generating an optionsfor a select field -function make_option(&$n) { - // start option group if it exists - if (substr($n,0,2) == '[=') { - $n = ''; - } elseif ($n == ']') { - $n = ''; - } else { - $n = ''; - } -} - -// Function for generating a checkbox -function make_checkbox(&$n, $idx, $params) { - $field_id = $params[0]; - $seperator = $params[1]; - //$n = ''.''.$n.''.$seperator; - $n = ''.''.$n.''.$seperator; -} - -// Function for generating a radio button -function make_radio(&$n, $idx, $params) { - $field_id = $params[0]; - $group = $params[1]; - $seperator = $params[2]; - $n = ''.''.$n.''.$seperator; -} - -// Work-out if the form has been submitted or not -if($_POST == array()) { - -?> - -query("SELECT header,field_loop,footer FROM ".TABLE_PREFIX."mod_form_settings WHERE section_id = '$section_id'"); -if($query_settings->numRows() > 0) { - $fetch_settings = $query_settings->fetchRow(); - $header = $this->strip_slashes_dummy($fetch_settings['header']); - $field_loop = $this->strip_slashes_dummy($fetch_settings['field_loop']); - $footer = $this->strip_slashes_dummy($fetch_settings['footer']); -} else { - $header = ''; - $field_loop = ''; - $footer = ''; -} - -// Add form starter code -?> -
-query("SELECT * FROM ".TABLE_PREFIX."mod_form_fields WHERE section_id = '$section_id' ORDER BY position ASC"); -if($query_fields->numRows() > 0) { - while($field = $query_fields->fetchRow()) { - // Set field values - $field_id = $field['field_id']; - $value = $this->strip_slashes_dummy($field['value']); - // Print field_loop after replacing vars with values - $vars = array('{TITLE}', '{REQUIRED}'); - $values = array($field['title']); - if($field['required'] == 1) { - $values[] = '*'; - } else { - $values[] = ''; - } - if($field['type'] == 'textfield') { - $vars[] = '{FIELD}'; - $values[] = ''; - } elseif($field['type'] == 'textarea') { - $vars[] = '{FIELD}'; - $values[] = ''; - } elseif($field['type'] == 'select') { - $vars[] = '{FIELD}'; - $options = explode(',', $value); - array_walk($options, 'make_option'); - $field['extra'] = explode(',',$field['extra']); - $values[] = ''; - } elseif($field['type'] == 'heading') { - $vars[] = '{FIELD}'; - $values[] = ''; - $tmp_field_loop = $field_loop; // temporarily modify the field loop template - $field_loop = $field['extra']; - } elseif($field['type'] == 'checkbox') { - $vars[] = '{FIELD}'; - $options = explode(',', $value); - array_walk($options, 'make_checkbox',array($field_id,$field['extra'])); - $values[] = implode($options); - } elseif($field['type'] == 'radio') { - $vars[] = '{FIELD}'; - $options = explode(',', $value); - array_walk($options, 'make_radio',array($field_id,$field['title'],$field['extra'])); - $values[] = implode($options); - } elseif($field['type'] == 'email') { - $vars[] = '{FIELD}'; - $values[] = ''; - } - if($field['type'] != '') { - echo str_replace($vars, $values, $field_loop); - } - if (isset($tmp_field_loop)) $field_loop = $tmp_field_loop; - } -} - -// Print footer -echo $footer; - -// Add form end code -?> -
-query("SELECT email_to,email_from,email_subject,success_message,max_submissions,stored_submissions FROM ".TABLE_PREFIX."mod_form_settings WHERE section_id = '$section_id'"); - if($query_settings->numRows() > 0) { - $fetch_settings = $query_settings->fetchRow(); - $email_to = $this->strip_slashes_dummy($fetch_settings['email_to']); - $email_from = $this->strip_slashes_dummy($fetch_settings['email_from']); - if(substr($email_from, 0, 5) == 'field') { - // Set the email from field to what the user entered in the specified field - $email_from = $this->add_slashes($_POST[$email_from]); - } - $email_subject = $this->strip_slashes_dummy($fetch_settings['email_subject']); - $success_message = $this->strip_slashes_dummy($fetch_settings['success_message']); - $max_submissions = $this->strip_slashes_dummy($fetch_settings['max_submissions']); - $stored_submissions = $this->strip_slashes_dummy($fetch_settings['stored_submissions']); - } else { - exit($TEXT['UNDER_CONSTRUCTION']); - } - $email_body = ''; - - // Create blank "required" array - $required = array(); - - // Loop through fields and add to message body - // Get list of fields - $query_fields = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_form_fields WHERE section_id = '$section_id' ORDER BY position ASC"); - if($query_fields->numRows() > 0) { - while($field = $query_fields->fetchRow()) { - // Add to message body - if($field['type'] != '') { - if(!empty($_POST['field'.$field['field_id']])) { - if($field['type'] == 'heading') { - $email_body .= ' - - '.$_POST['field'.$field['field_id']]; - } elseif (!is_array($_POST['field'.$field['field_id']])) { - $email_body .= ' - - '.$this->strip_slashes_dummy($field['title']).': '.$_POST['field'.$field['field_id']]."\n"; - } else { - $email_body .= ' - - '.$this->strip_slashes_dummy($field['title']).": \n"; - foreach ($_POST['field'.$field['field_id']] as $k=>$v) { - $email_body .= ' - - '.$v; - } - } - } elseif($field['required'] == 1) { - $required[] = $this->strip_slashes_dummy($field['title']); - } - } - } - } - - // Addslashes to email body - proposed by Icheb in topic=1170.0 - // $email_body = $this->add_slashes($email_body); - - // Check if the user forgot to enter values into all the required fields - if($required != array()) { - if(!isset($MESSAGE['MOD_FORM']['REQUIRED_FIELDS'])) { - echo 'You must enter details for the following fields'; - } else { - echo $MESSAGE['MOD_FORM']['REQUIRED_FIELDS']; - } - echo ':
    '; - foreach($required AS $field_title) { - echo '
  • '.$field_title; - } - echo '
'.$TEXT['BACK'].''; - - } else { - - // Check how many times form has been submitted in last hour - $query_submissions = $database->query("SELECT submission_id FROM ".TABLE_PREFIX."mod_form_submissions WHERE submitted_when >= '3600'"); - if($query_submissions->numRows() > $max_submissions) { - // Too many submissions so far this hour - echo $MESSAGE['MOD_FORM']['EXCESS_SUBMISSIONS']; - $success = false; - } else { - // Now send the email - if($email_to != '') { - if($email_from != '') { - if(mail($email_to,$email_subject,str_replace('\n', '', $email_body),"From: ".$email_from)) { $success = true; } - } else { - if(mail($email_to,$email_subject,str_replace('\n', '', $email_body))) { $success = true; } - } - } - // Write submission to database - if(isset($admin) AND $admin->get_user_id() > 0) { - $admin->get_user_id(); - } else { - $submitted_by = 0; - } - $email_body = $this->add_slashes($email_body); - $database->query("INSERT INTO ".TABLE_PREFIX."mod_form_submissions (page_id,section_id,submitted_when,submitted_by,body) VALUES ('".PAGE_ID."','$section_id','".mktime()."','$submitted_by','$email_body')"); - // Make sure submissions table isn't too full - $query_submissions = $database->query("SELECT submission_id FROM ".TABLE_PREFIX."mod_form_submissions ORDER BY submitted_when"); - $num_submissions = $query_submissions->numRows(); - if($num_submissions > $stored_submissions) { - // Remove excess submission - $num_to_remove = $num_submissions-$stored_submissions; - while($submission = $query_submissions->fetchRow()) { - if($num_to_remove > 0) { - $submission_id = $submission['submission_id']; - $database->query("DELETE FROM ".TABLE_PREFIX."mod_form_submissions WHERE submission_id = '$submission_id'"); - $num_to_remove = $num_to_remove-1; - } - } - } - if(!$database->is_error()) { - $success = true; - } - } - - // Now check if the email was sent successfully - if(isset($success) AND $success == true) { - echo $success_message; - } else { - echo $TEXT['ERROR']; - } - - } - -} - -?> \ No newline at end of file Property changes on: trunk/wb/modules/form/view.php ___________________________________________________________________ Deleted: svn:executable ## -1 +0,0 ## -* \ No newline at end of property Deleted: svn:keywords ## -1 +0,0 ## -Id \ No newline at end of property Index: trunk/wb/modules/form/view_submission.php =================================================================== --- trunk/wb/modules/form/view_submission.php (revision 80) +++ trunk/wb/modules/form/view_submission.php (nonexistent) @@ -1,92 +0,0 @@ - - Copyright (C) 2004-2005, Ryan Djurovich - - Website Baker is free software; you can redistribute it and/or modify - it under the terms of the GNU General Public License as published by - the Free Software Foundation; either version 2 of the License, or - (at your option) any later version. - - Website Baker is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU General Public License for more details. - - You should have received a copy of the GNU General Public License - along with Website Baker; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -*/ - -/* -The Website Baker Project would like to thank Rudolph Lartey -for his contributions to this module - adding extra field types -*/ - -require('../../config.php'); - -// Get id -if(!isset($_GET['submission_id']) OR !is_numeric($_GET['submission_id'])) { - header("Location: ".ADMIN_URL."/pages/index.php"); -} else { - $submission_id = $_GET['submission_id']; -} - -// Include WB admin wrapper script -require(WB_PATH.'/modules/admin.php'); - -// Get submission details -$query_content = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_form_submissions WHERE submission_id = '$submission_id'"); -$submission = $query_content->fetchRow(); - -// Get the user details of whoever did this submission -$query_user = "SELECT username,display_name FROM ".TABLE_PREFIX."users WHERE user_id = '".$submission['submitted_by']."'"; -$get_user = $database->query($query_user); -if($get_user->numRows() != 0) { - $user = $get_user->fetchRow(); -} else { - $user['display_name'] = 'Unknown'; - $user['username'] = 'unknown'; -} - -?> - - - - - - - - - - - - - - - - - - - -
:
:
:
-
-
- strip_slashes_dummy(str_replace('\n', '
', $submission['body'])); ?> -
- -
- - - -print_footer(); - -?> \ No newline at end of file Property changes on: trunk/wb/modules/form/view_submission.php ___________________________________________________________________ Deleted: svn:keywords ## -1 +0,0 ## -Id \ No newline at end of property Index: trunk/wb/modules/form/modify.php =================================================================== --- trunk/wb/modules/form/modify.php (revision 80) +++ trunk/wb/modules/form/modify.php (nonexistent) @@ -1,191 +0,0 @@ - - Copyright (C) 2004-2005, Ryan Djurovich - - Website Baker is free software; you can redistribute it and/or modify - it under the terms of the GNU General Public License as published by - the Free Software Foundation; either version 2 of the License, or - (at your option) any later version. - - Website Baker is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU General Public License for more details. - - You should have received a copy of the GNU General Public License - along with Website Baker; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -*/ - -/* -The Website Baker Project would like to thank Rudolph Lartey -for his contributions to this module - adding extra field types -*/ - -// Must include code to stop this file being access directly -if(!defined('WB_PATH')) { exit("Cannot access this file directly"); } - -?> - - - - - -
- - - -
- -
- -

-query("SELECT * FROM `".TABLE_PREFIX."mod_form_fields` WHERE section_id = '$section_id' ORDER BY position ASC"); -if($query_fields->numRows() > 0) { - $num_fields = $query_fields->numRows(); - $row = 'a'; - ?> - - fetchRow()) { - ?> - - - - - - - - - - - -
- - ^ - - - - - - - - - - - - - - - ^ - - - - - - v - - - - - X - -
- - -

- -

- -query("SELECT * FROM `".TABLE_PREFIX."mod_form_submissions` WHERE section_id = '$section_id' ORDER BY submitted_when ASC"); -if($query_submissions->numRows() > 0) { - ?> - - fetchRow()) { - ?> - - - - - - - -
- - <?php echo $TEXT['OPEN']; ?> - - - - X - -
- - -
\ No newline at end of file Property changes on: trunk/wb/modules/form/modify.php ___________________________________________________________________ Deleted: svn:executable ## -1 +0,0 ## -* \ No newline at end of property Deleted: svn:keywords ## -1 +0,0 ## -Id \ No newline at end of property Index: trunk/wb/modules/form/move_down.php =================================================================== --- trunk/wb/modules/form/move_down.php (revision 80) +++ trunk/wb/modules/form/move_down.php (nonexistent) @@ -1,57 +0,0 @@ - - Copyright (C) 2004-2005, Ryan Djurovich - - Website Baker is free software; you can redistribute it and/or modify - it under the terms of the GNU General Public License as published by - the Free Software Foundation; either version 2 of the License, or - (at your option) any later version. - - Website Baker is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU General Public License for more details. - - You should have received a copy of the GNU General Public License - along with Website Baker; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -*/ - -/* -The Website Baker Project would like to thank Rudolph Lartey -for his contributions to this module - adding extra field types -*/ - -require('../../config.php'); - -// Get id -if(!isset($_GET['field_id']) OR !is_numeric($_GET['field_id'])) { - header("Location: index.php"); -} else { - $field_id = $_GET['field_id']; -} - -// Include WB admin wrapper script -require(WB_PATH.'/modules/admin.php'); - -// Include the ordering class -require(WB_PATH.'/framework/class.order.php'); - -// Create new order object an reorder -$order = new order(TABLE_PREFIX.'mod_form_fields', 'position', 'field_id', 'section_id'); -if($order->move_down($field_id)) { - $admin->print_success($TEXT['SUCCESS'], ADMIN_URL.'/pages/modify.php?page_id='.$page_id); -} else { - $admin->print_error($TEXT['ERROR'], ADMIN_URL.'/pages/modify.php?page_id='.$page_id); -} - -// Print admin footer -$admin->print_footer(); - -?> \ No newline at end of file Property changes on: trunk/wb/modules/form/move_down.php ___________________________________________________________________ Deleted: svn:executable ## -1 +0,0 ## -* \ No newline at end of property Deleted: svn:keywords ## -1 +0,0 ## -Id \ No newline at end of property Index: trunk/wb/modules/form/modify_field.php =================================================================== --- trunk/wb/modules/form/modify_field.php (revision 80) +++ trunk/wb/modules/form/modify_field.php (nonexistent) @@ -1,218 +0,0 @@ - - Copyright (C) 2004-2005, Ryan Djurovich - - Website Baker is free software; you can redistribute it and/or modify - it under the terms of the GNU General Public License as published by - the Free Software Foundation; either version 2 of the License, or - (at your option) any later version. - - Website Baker is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU General Public License for more details. - - You should have received a copy of the GNU General Public License - along with Website Baker; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -*/ - -/* -The Website Baker Project would like to thank Rudolph Lartey -for his contributions to this module - adding extra field types -*/ - -require('../../config.php'); - -// Get id -if(!isset($_GET['field_id']) OR !is_numeric($_GET['field_id'])) { - header("Location: ".ADMIN_URL."/pages/index.php"); -} else { - $field_id = $_GET['field_id']; -} - -// Include WB admin wrapper script -require(WB_PATH.'/modules/admin.php'); - -// Get header and footer -$query_content = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_form_fields WHERE field_id = '$field_id'"); -$form = $query_content->fetchRow(); -$type = $form['type']; -if($type == '') { - $type = 'none'; -} - -// Set raw html <'s and >'s to be replaced by friendly html code -$raw = array('<', '>'); -$friendly = array('<', '>'); -?> - -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
: - -
: - -
: - -
: - -
: - -
: - -
: - - - - - - -
: - -
- - - - - - -
: - -
- - -
: - - -
: - /> - - - -   - /> - - - -
: - -
: - /> - - - -   - /> - - - -
- - - - - - - -
  - - - - - -
- -print_footer(); - -?> \ No newline at end of file Property changes on: trunk/wb/modules/form/modify_field.php ___________________________________________________________________ Deleted: svn:executable ## -1 +0,0 ## -* \ No newline at end of property Deleted: svn:keywords ## -1 +0,0 ## -Id \ No newline at end of property Index: trunk/wb/modules/form/add_field.php =================================================================== --- trunk/wb/modules/form/add_field.php (revision 80) +++ trunk/wb/modules/form/add_field.php (nonexistent) @@ -1,58 +0,0 @@ - - Copyright (C) 2004-2005, Ryan Djurovich - - Website Baker is free software; you can redistribute it and/or modify - it under the terms of the GNU General Public License as published by - the Free Software Foundation; either version 2 of the License, or - (at your option) any later version. - - Website Baker is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU General Public License for more details. - - You should have received a copy of the GNU General Public License - along with Website Baker; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -*/ - -/* -The Website Baker Project would like to thank Rudolph Lartey -for his contributions to this module - adding extra field types -*/ - -require('../../config.php'); - -// Include WB admin wrapper script -require(WB_PATH.'/modules/admin.php'); - -// Include the ordering class -require(WB_PATH.'/framework/class.order.php'); -// Get new order -$order = new order(TABLE_PREFIX.'mod_form_fields', 'position', 'field_id', 'section_id'); -$position = $order->get_new($section_id); - -// Insert new row into database -$database->query("INSERT INTO ".TABLE_PREFIX."mod_form_fields (section_id,page_id,position,required) VALUES ('$section_id','$page_id','$position','0')"); - -// Get the id -$field_id = $database->get_one("SELECT LAST_INSERT_ID()"); - -// Say that a new record has been added, then redirect to modify page -if($database->is_error()) { - $admin->print_error($database->get_error(), WB_URL.'/modules/form/modify_field.php?page_id='.$page_id.'§ion_id='.$section_id.'&field_id='.$field_id); -} else { - $admin->print_success($TEXT['SUCCESS'], WB_URL.'/modules/form/modify_field.php?page_id='.$page_id.'§ion_id='.$section_id.'&field_id='.$field_id); -} - -// Print admin footer -$admin->print_footer(); - -?> \ No newline at end of file Property changes on: trunk/wb/modules/form/add_field.php ___________________________________________________________________ Deleted: svn:executable ## -1 +0,0 ## -* \ No newline at end of property Deleted: svn:keywords ## -1 +0,0 ## -Id \ No newline at end of property Index: trunk/wb/modules/form/add.php =================================================================== --- trunk/wb/modules/form/add.php (revision 80) +++ trunk/wb/modules/form/add.php (nonexistent) @@ -1,48 +0,0 @@ - - Copyright (C) 2004-2005, Ryan Djurovich - - Website Baker is free software; you can redistribute it and/or modify - it under the terms of the GNU General Public License as published by - the Free Software Foundation; either version 2 of the License, or - (at your option) any later version. - - Website Baker is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU General Public License for more details. - - You should have received a copy of the GNU General Public License - along with Website Baker; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -*/ - -/* -The Website Baker Project would like to thank Rudolph Lartey -for his contributions to this module - adding extra field types -*/ - -// Insert an extra rows into the database -$header = ''; -$field_loop = ''; -$footer = ' - - -
{TITLE}{REQUIRED}:{FIELD}
  - -
'; -$email_to = $admin->get_email(); -$email_from = ''; -$email_subject = 'Results from form on website...'; -$success_message = 'Thank-you.'; -$max_submissions = 50; -$stored_submissions = 100; -$database->query("INSERT INTO ".TABLE_PREFIX."mod_form_settings (page_id,section_id,header,field_loop,footer,email_to,email_from,email_subject,success_message,max_submissions,stored_submissions) VALUES ('$page_id','$section_id','$header','$field_loop','$footer','$email_to','$email_from','$email_subject','$success_message','$max_submissions','$stored_submissions')"); - -?> \ No newline at end of file Property changes on: trunk/wb/modules/form/add.php ___________________________________________________________________ Deleted: svn:executable ## -1 +0,0 ## -* \ No newline at end of property Deleted: svn:keywords ## -1 +0,0 ## -Id \ No newline at end of property Index: trunk/wb/modules/form/index.php =================================================================== --- trunk/wb/modules/form/index.php (revision 80) +++ trunk/wb/modules/form/index.php (nonexistent) @@ -1,33 +0,0 @@ - - Copyright (C) 2004-2005, Ryan Djurovich - - Website Baker is free software; you can redistribute it and/or modify - it under the terms of the GNU General Public License as published by - the Free Software Foundation; either version 2 of the License, or - (at your option) any later version. - - Website Baker is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU General Public License for more details. - - You should have received a copy of the GNU General Public License - along with Website Baker; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -*/ - -/* -The Website Baker Project would like to thank Rudolph Lartey -for his contributions to this module - adding extra field types -*/ - -header('Location: ../index.php'); - -?> \ No newline at end of file Property changes on: trunk/wb/modules/form/index.php ___________________________________________________________________ Deleted: svn:executable ## -1 +0,0 ## -* \ No newline at end of property Deleted: svn:keywords ## -1 +0,0 ## -Id \ No newline at end of property Index: trunk/wb/modules/form/save_field.php =================================================================== --- trunk/wb/modules/form/save_field.php (revision 80) +++ trunk/wb/modules/form/save_field.php (nonexistent) @@ -1,103 +0,0 @@ - - Copyright (C) 2004-2005, Ryan Djurovich - - Website Baker is free software; you can redistribute it and/or modify - it under the terms of the GNU General Public License as published by - the Free Software Foundation; either version 2 of the License, or - (at your option) any later version. - - Website Baker is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU General Public License for more details. - - You should have received a copy of the GNU General Public License - along with Website Baker; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -*/ - -/* -The Website Baker Project would like to thank Rudolph Lartey -for his contributions to this module - adding extra field types -*/ - -require('../../config.php'); - -// Get id -if(!isset($_POST['field_id']) OR !is_numeric($_POST['field_id'])) { - header("Location: ".ADMIN_URL."/pages/index.php"); -} else { - $field_id = $_POST['field_id']; - $field_id = $field_id; -} - -// Include WB admin wrapper script -$update_when_modified = true; // Tells script to update when this page was last updated -require(WB_PATH.'/modules/admin.php'); - -// Validate all fields -if($admin->get_post('title') == '' OR $admin->get_post('type') == '') { - $admin->print_error($MESSAGE['GENERIC']['FILL_IN_ALL'], WB_URL.'/modules/form/modify_field.php?page_id='.$page_id.'§ion_id='.$section_id.'&field_id='.$field_id); -} else { - $title = $admin->add_slashes($admin->get_post('title')); - $type = $admin->get_post('type'); - $required = $admin->get_post('required'); -} - -// Update row -$database->query("UPDATE ".TABLE_PREFIX."mod_form_fields SET title = '$title', type = '$type', required = '$required' WHERE field_id = '$field_id'"); - -// If field type has multiple options, get all values and implode them -$list_count = $admin->get_post('list_count'); -if(is_numeric($list_count)) { - $values = array(); - for($i = 1; $i <= $list_count; $i++) { - if($admin->get_post('value'.$i) != '') { - $values[] = $admin->get_post('value'.$i); - } - } - $value = implode(',', $values); -} - -// Get extra fields for field-type-specific settings -if($admin->get_post('type') == 'textfield') { - $length = $admin->get_post('length'); - $value = $admin->get_post('value'); - $database->query("UPDATE ".TABLE_PREFIX."mod_form_fields SET value = '$value', extra = '$length' WHERE field_id = '$field_id'"); -} elseif($admin->get_post('type') == 'textarea') { - $value = $admin->get_post('value'); - $database->query("UPDATE ".TABLE_PREFIX."mod_form_fields SET value = '$value', extra = '' WHERE field_id = '$field_id'"); -} elseif($admin->get_post('type') == 'heading') { - $extra = $admin->get_post('template'); - if(trim($extra) == '') $extra = '{TITLE}{FIELD}'; - $extra = $admin->add_slashes($extra); - $database->query("UPDATE ".TABLE_PREFIX."mod_form_fields SET value = '', extra = '$extra' WHERE field_id = '$field_id'"); -} elseif($admin->get_post('type') == 'select') { - $extra = $admin->get_post('size').','.$admin->get_post('multiselect'); - $database->query("UPDATE ".TABLE_PREFIX."mod_form_fields SET value = '$value', extra = '$extra' WHERE field_id = '$field_id'"); -} elseif($admin->get_post('type') == 'checkbox') { - $extra = $admin->get_post('seperator'); - $database->query("UPDATE ".TABLE_PREFIX."mod_form_fields SET value = '$value', extra = '$extra' WHERE field_id = '$field_id'"); -} elseif($admin->get_post('type') == 'radio') { - $extra = $admin->get_post('seperator'); - $database->query("UPDATE ".TABLE_PREFIX."mod_form_fields SET value = '$value', extra = '$extra' WHERE field_id = '$field_id'"); -} - -// Check if there is a db error, otherwise say successful -if($database->is_error()) { - $admin->print_error($database->get_error(), WB_URL.'/modules/form/modify_field.php?page_id='.$page_id.'§ion_id='.$section_id.'&field_id='.$field_id); -} else { - $admin->print_success($TEXT['SUCCESS'], WB_URL.'/modules/form/modify_field.php?page_id='.$page_id.'§ion_id='.$section_id.'&field_id='.$field_id); -} - -// Print admin footer -$admin->print_footer(); - -?> \ No newline at end of file Property changes on: trunk/wb/modules/form/save_field.php ___________________________________________________________________ Deleted: svn:executable ## -1 +0,0 ## -* \ No newline at end of property Deleted: svn:keywords ## -1 +0,0 ## -Id \ No newline at end of property Index: trunk/wb/modules/form/delete.php =================================================================== --- trunk/wb/modules/form/delete.php (revision 80) +++ trunk/wb/modules/form/delete.php (nonexistent) @@ -1,35 +0,0 @@ - - Copyright (C) 2004-2005, Ryan Djurovich - - Website Baker is free software; you can redistribute it and/or modify - it under the terms of the GNU General Public License as published by - the Free Software Foundation; either version 2 of the License, or - (at your option) any later version. - - Website Baker is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU General Public License for more details. - - You should have received a copy of the GNU General Public License - along with Website Baker; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -*/ - -/* -The Website Baker Project would like to thank Rudolph Lartey -for his contributions to this module - adding extra field types -*/ - -// Delete page from mod_wysiwyg -$database->query("DELETE FROM ".TABLE_PREFIX."mod_form_fields WHERE page_id = '$page_id'"); -$database->query("DELETE FROM ".TABLE_PREFIX."mod_form_settings WHERE page_id = '$page_id'"); - -?> \ No newline at end of file Property changes on: trunk/wb/modules/form/delete.php ___________________________________________________________________ Deleted: svn:executable ## -1 +0,0 ## -* \ No newline at end of property Deleted: svn:keywords ## -1 +0,0 ## -Id \ No newline at end of property Index: trunk/wb/modules/form/info.php =================================================================== --- trunk/wb/modules/form/info.php (revision 80) +++ trunk/wb/modules/form/info.php (nonexistent) @@ -1,40 +0,0 @@ - - Copyright (C) 2004-2005, Ryan Djurovich - - Website Baker is free software; you can redistribute it and/or modify - it under the terms of the GNU General Public License as published by - the Free Software Foundation; either version 2 of the License, or - (at your option) any later version. - - Website Baker is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU General Public License for more details. - - You should have received a copy of the GNU General Public License - along with Website Baker; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -*/ - -/* -The Website Baker Project would like to thank Rudolph Lartey -for his contributions to this module - adding extra field types -*/ - -$module_directory = 'form'; -$module_name = 'Form'; -$module_type = 'page'; -$module_version = '2.5'; -$module_designed_for = '2.x'; -$module_author = 'Ryan Djurovich & Rudolph Lartey'; -$module_description = 'This module allows you to create customised online forms, such as a feedback form. '. -'Thank-you to Rudolph Lartey who help enhance this module, providing code for extra field types, etc.'; - -?> \ No newline at end of file Property changes on: trunk/wb/modules/form/info.php ___________________________________________________________________ Deleted: svn:executable ## -1 +0,0 ## -* \ No newline at end of property Deleted: svn:keywords ## -1 +0,0 ## -Id \ No newline at end of property Index: trunk/wb/modules/form/delete_field.php =================================================================== --- trunk/wb/modules/form/delete_field.php (revision 80) +++ trunk/wb/modules/form/delete_field.php (nonexistent) @@ -1,57 +0,0 @@ - - Copyright (C) 2004-2005, Ryan Djurovich - - Website Baker is free software; you can redistribute it and/or modify - it under the terms of the GNU General Public License as published by - the Free Software Foundation; either version 2 of the License, or - (at your option) any later version. - - Website Baker is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU General Public License for more details. - - You should have received a copy of the GNU General Public License - along with Website Baker; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -*/ - -/* -The Website Baker Project would like to thank Rudolph Lartey -for his contributions to this module - adding extra field types -*/ - -require('../../config.php'); - -// Get id -if(!isset($_GET['field_id']) OR !is_numeric($_GET['field_id'])) { - header("Location: ".ADMIN_URL."/pages/index.php"); -} else { - $field_id = $_GET['field_id']; -} - -// Include WB admin wrapper script -$update_when_modified = true; // Tells script to update when this page was last updated -require(WB_PATH.'/modules/admin.php'); - -// Delete row -$database->query("DELETE FROM ".TABLE_PREFIX."mod_form_fields WHERE field_id = '$field_id'"); - -// Check if there is a db error, otherwise say successful -if($database->is_error()) { - $admin->print_error($database->get_error(), ADMIN_URL.'/pages/modify.php?page_id='.$page_id); -} else { - $admin->print_success($TEXT['SUCCESS'], ADMIN_URL.'/pages/modify.php?page_id='.$page_id); -} - -// Print admin footer -$admin->print_footer(); - -?> \ No newline at end of file Property changes on: trunk/wb/modules/form/delete_field.php ___________________________________________________________________ Deleted: svn:executable ## -1 +0,0 ## -* \ No newline at end of property Deleted: svn:keywords ## -1 +0,0 ## -Id \ No newline at end of property Index: addons/modules/form/save_field.php =================================================================== --- addons/modules/form/save_field.php (nonexistent) +++ addons/modules/form/save_field.php (revision 81) @@ -0,0 +1,103 @@ + + Copyright (C) 2004-2005, Ryan Djurovich + + Website Baker is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + Website Baker is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Website Baker; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +*/ + +/* +The Website Baker Project would like to thank Rudolph Lartey +for his contributions to this module - adding extra field types +*/ + +require('../../config.php'); + +// Get id +if(!isset($_POST['field_id']) OR !is_numeric($_POST['field_id'])) { + header("Location: ".ADMIN_URL."/pages/index.php"); +} else { + $field_id = $_POST['field_id']; + $field_id = $field_id; +} + +// Include WB admin wrapper script +$update_when_modified = true; // Tells script to update when this page was last updated +require(WB_PATH.'/modules/admin.php'); + +// Validate all fields +if($admin->get_post('title') == '' OR $admin->get_post('type') == '') { + $admin->print_error($MESSAGE['GENERIC']['FILL_IN_ALL'], WB_URL.'/modules/form/modify_field.php?page_id='.$page_id.'§ion_id='.$section_id.'&field_id='.$field_id); +} else { + $title = $admin->add_slashes($admin->get_post('title')); + $type = $admin->get_post('type'); + $required = $admin->get_post('required'); +} + +// Update row +$database->query("UPDATE ".TABLE_PREFIX."mod_form_fields SET title = '$title', type = '$type', required = '$required' WHERE field_id = '$field_id'"); + +// If field type has multiple options, get all values and implode them +$list_count = $admin->get_post('list_count'); +if(is_numeric($list_count)) { + $values = array(); + for($i = 1; $i <= $list_count; $i++) { + if($admin->get_post('value'.$i) != '') { + $values[] = $admin->get_post('value'.$i); + } + } + $value = implode(',', $values); +} + +// Get extra fields for field-type-specific settings +if($admin->get_post('type') == 'textfield') { + $length = $admin->get_post('length'); + $value = $admin->get_post('value'); + $database->query("UPDATE ".TABLE_PREFIX."mod_form_fields SET value = '$value', extra = '$length' WHERE field_id = '$field_id'"); +} elseif($admin->get_post('type') == 'textarea') { + $value = $admin->get_post('value'); + $database->query("UPDATE ".TABLE_PREFIX."mod_form_fields SET value = '$value', extra = '' WHERE field_id = '$field_id'"); +} elseif($admin->get_post('type') == 'heading') { + $extra = $admin->get_post('template'); + if(trim($extra) == '') $extra = '{TITLE}{FIELD}'; + $extra = $admin->add_slashes($extra); + $database->query("UPDATE ".TABLE_PREFIX."mod_form_fields SET value = '', extra = '$extra' WHERE field_id = '$field_id'"); +} elseif($admin->get_post('type') == 'select') { + $extra = $admin->get_post('size').','.$admin->get_post('multiselect'); + $database->query("UPDATE ".TABLE_PREFIX."mod_form_fields SET value = '$value', extra = '$extra' WHERE field_id = '$field_id'"); +} elseif($admin->get_post('type') == 'checkbox') { + $extra = $admin->get_post('seperator'); + $database->query("UPDATE ".TABLE_PREFIX."mod_form_fields SET value = '$value', extra = '$extra' WHERE field_id = '$field_id'"); +} elseif($admin->get_post('type') == 'radio') { + $extra = $admin->get_post('seperator'); + $database->query("UPDATE ".TABLE_PREFIX."mod_form_fields SET value = '$value', extra = '$extra' WHERE field_id = '$field_id'"); +} + +// Check if there is a db error, otherwise say successful +if($database->is_error()) { + $admin->print_error($database->get_error(), WB_URL.'/modules/form/modify_field.php?page_id='.$page_id.'§ion_id='.$section_id.'&field_id='.$field_id); +} else { + $admin->print_success($TEXT['SUCCESS'], WB_URL.'/modules/form/modify_field.php?page_id='.$page_id.'§ion_id='.$section_id.'&field_id='.$field_id); +} + +// Print admin footer +$admin->print_footer(); + +?> \ No newline at end of file Property changes on: addons/modules/form/save_field.php ___________________________________________________________________ Added: svn:executable ## -0,0 +1 ## +* \ No newline at end of property Added: svn:keywords ## -0,0 +1 ## +Id \ No newline at end of property Index: addons/modules/form/modify_field.php =================================================================== --- addons/modules/form/modify_field.php (nonexistent) +++ addons/modules/form/modify_field.php (revision 81) @@ -0,0 +1,218 @@ + + Copyright (C) 2004-2005, Ryan Djurovich + + Website Baker is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + Website Baker is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Website Baker; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +*/ + +/* +The Website Baker Project would like to thank Rudolph Lartey +for his contributions to this module - adding extra field types +*/ + +require('../../config.php'); + +// Get id +if(!isset($_GET['field_id']) OR !is_numeric($_GET['field_id'])) { + header("Location: ".ADMIN_URL."/pages/index.php"); +} else { + $field_id = $_GET['field_id']; +} + +// Include WB admin wrapper script +require(WB_PATH.'/modules/admin.php'); + +// Get header and footer +$query_content = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_form_fields WHERE field_id = '$field_id'"); +$form = $query_content->fetchRow(); +$type = $form['type']; +if($type == '') { + $type = 'none'; +} + +// Set raw html <'s and >'s to be replaced by friendly html code +$raw = array('<', '>'); +$friendly = array('<', '>'); +?> + +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
: + +
: + +
: + +
: + +
: + +
: + +
: + + + + + + +
: + +
+ + + + + + +
: + +
+ + +
: + + +
: + /> + + + +   + /> + + + +
: + +
: + /> + + + +   + /> + + + +
+ + + + + + + +
  + + + + + +
+ +print_footer(); + +?> \ No newline at end of file Property changes on: addons/modules/form/modify_field.php ___________________________________________________________________ Added: svn:executable ## -0,0 +1 ## +* \ No newline at end of property Added: svn:keywords ## -0,0 +1 ## +Id \ No newline at end of property Index: addons/modules/form/modify_settings.php =================================================================== --- addons/modules/form/modify_settings.php (nonexistent) +++ addons/modules/form/modify_settings.php (revision 81) @@ -0,0 +1,147 @@ + + Copyright (C) 2004-2005, Ryan Djurovich + + Website Baker is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + Website Baker is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Website Baker; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +*/ + +/* +The Website Baker Project would like to thank Rudolph Lartey +for his contributions to this module - adding extra field types +*/ + +require('../../config.php'); + +// Include WB admin wrapper script +require(WB_PATH.'/modules/admin.php'); + +// Get header and footer +$query_content = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_form_settings WHERE section_id = '$section_id'"); +$setting = $query_content->fetchRow(); + +// Set raw html <'s and >'s to be replace by friendly html code +$raw = array('<', '>'); +$friendly = array('<', '>'); + +?> + + + +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
: + +
: + +
: + +
: + +
: + + +
: + +
: + +
: + +
: + +
+ + + + + + +
  + + + +
+ + +print_footer(); + +?> \ No newline at end of file Property changes on: addons/modules/form/modify_settings.php ___________________________________________________________________ Added: svn:executable ## -0,0 +1 ## +* \ No newline at end of property Added: svn:keywords ## -0,0 +1 ## +Id \ No newline at end of property Index: addons/modules/form/view.php =================================================================== --- addons/modules/form/view.php (nonexistent) +++ addons/modules/form/view.php (revision 81) @@ -0,0 +1,323 @@ + + Copyright (C) 2004-2005, Ryan Djurovich + + Website Baker is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + Website Baker is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Website Baker; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +*/ + +/* +The Website Baker Project would like to thank Rudolph Lartey +for his contributions to this module - adding extra field types +*/ + +// Must include code to stop this file being access directly +if(defined('WB_PATH') == false) { exit("Cannot access this file directly"); } + +// Function for generating an optionsfor a select field +function make_option(&$n) { + // start option group if it exists + if (substr($n,0,2) == '[=') { + $n = ''; + } elseif ($n == ']') { + $n = ''; + } else { + $n = ''; + } +} + +// Function for generating a checkbox +function make_checkbox(&$n, $idx, $params) { + $field_id = $params[0]; + $seperator = $params[1]; + //$n = ''.''.$n.''.$seperator; + $n = ''.''.$n.''.$seperator; +} + +// Function for generating a radio button +function make_radio(&$n, $idx, $params) { + $field_id = $params[0]; + $group = $params[1]; + $seperator = $params[2]; + $n = ''.''.$n.''.$seperator; +} + +// Work-out if the form has been submitted or not +if($_POST == array()) { + +?> + +query("SELECT header,field_loop,footer FROM ".TABLE_PREFIX."mod_form_settings WHERE section_id = '$section_id'"); +if($query_settings->numRows() > 0) { + $fetch_settings = $query_settings->fetchRow(); + $header = $this->strip_slashes_dummy($fetch_settings['header']); + $field_loop = $this->strip_slashes_dummy($fetch_settings['field_loop']); + $footer = $this->strip_slashes_dummy($fetch_settings['footer']); +} else { + $header = ''; + $field_loop = ''; + $footer = ''; +} + +// Add form starter code +?> +
+query("SELECT * FROM ".TABLE_PREFIX."mod_form_fields WHERE section_id = '$section_id' ORDER BY position ASC"); +if($query_fields->numRows() > 0) { + while($field = $query_fields->fetchRow()) { + // Set field values + $field_id = $field['field_id']; + $value = $this->strip_slashes_dummy($field['value']); + // Print field_loop after replacing vars with values + $vars = array('{TITLE}', '{REQUIRED}'); + $values = array($field['title']); + if($field['required'] == 1) { + $values[] = '*'; + } else { + $values[] = ''; + } + if($field['type'] == 'textfield') { + $vars[] = '{FIELD}'; + $values[] = ''; + } elseif($field['type'] == 'textarea') { + $vars[] = '{FIELD}'; + $values[] = ''; + } elseif($field['type'] == 'select') { + $vars[] = '{FIELD}'; + $options = explode(',', $value); + array_walk($options, 'make_option'); + $field['extra'] = explode(',',$field['extra']); + $values[] = ''; + } elseif($field['type'] == 'heading') { + $vars[] = '{FIELD}'; + $values[] = ''; + $tmp_field_loop = $field_loop; // temporarily modify the field loop template + $field_loop = $field['extra']; + } elseif($field['type'] == 'checkbox') { + $vars[] = '{FIELD}'; + $options = explode(',', $value); + array_walk($options, 'make_checkbox',array($field_id,$field['extra'])); + $values[] = implode($options); + } elseif($field['type'] == 'radio') { + $vars[] = '{FIELD}'; + $options = explode(',', $value); + array_walk($options, 'make_radio',array($field_id,$field['title'],$field['extra'])); + $values[] = implode($options); + } elseif($field['type'] == 'email') { + $vars[] = '{FIELD}'; + $values[] = ''; + } + if($field['type'] != '') { + echo str_replace($vars, $values, $field_loop); + } + if (isset($tmp_field_loop)) $field_loop = $tmp_field_loop; + } +} + +// Print footer +echo $footer; + +// Add form end code +?> +
+query("SELECT email_to,email_from,email_subject,success_message,max_submissions,stored_submissions FROM ".TABLE_PREFIX."mod_form_settings WHERE section_id = '$section_id'"); + if($query_settings->numRows() > 0) { + $fetch_settings = $query_settings->fetchRow(); + $email_to = $this->strip_slashes_dummy($fetch_settings['email_to']); + $email_from = $this->strip_slashes_dummy($fetch_settings['email_from']); + if(substr($email_from, 0, 5) == 'field') { + // Set the email from field to what the user entered in the specified field + $email_from = $this->add_slashes($_POST[$email_from]); + } + $email_subject = $this->strip_slashes_dummy($fetch_settings['email_subject']); + $success_message = $this->strip_slashes_dummy($fetch_settings['success_message']); + $max_submissions = $this->strip_slashes_dummy($fetch_settings['max_submissions']); + $stored_submissions = $this->strip_slashes_dummy($fetch_settings['stored_submissions']); + } else { + exit($TEXT['UNDER_CONSTRUCTION']); + } + $email_body = ''; + + // Create blank "required" array + $required = array(); + + // Loop through fields and add to message body + // Get list of fields + $query_fields = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_form_fields WHERE section_id = '$section_id' ORDER BY position ASC"); + if($query_fields->numRows() > 0) { + while($field = $query_fields->fetchRow()) { + // Add to message body + if($field['type'] != '') { + if(!empty($_POST['field'.$field['field_id']])) { + if($field['type'] == 'heading') { + $email_body .= ' + + '.$_POST['field'.$field['field_id']]; + } elseif (!is_array($_POST['field'.$field['field_id']])) { + $email_body .= ' + + '.$this->strip_slashes_dummy($field['title']).': '.$_POST['field'.$field['field_id']]."\n"; + } else { + $email_body .= ' + + '.$this->strip_slashes_dummy($field['title']).": \n"; + foreach ($_POST['field'.$field['field_id']] as $k=>$v) { + $email_body .= ' + + '.$v; + } + } + } elseif($field['required'] == 1) { + $required[] = $this->strip_slashes_dummy($field['title']); + } + } + } + } + + // Addslashes to email body - proposed by Icheb in topic=1170.0 + // $email_body = $this->add_slashes($email_body); + + // Check if the user forgot to enter values into all the required fields + if($required != array()) { + if(!isset($MESSAGE['MOD_FORM']['REQUIRED_FIELDS'])) { + echo 'You must enter details for the following fields'; + } else { + echo $MESSAGE['MOD_FORM']['REQUIRED_FIELDS']; + } + echo ':
    '; + foreach($required AS $field_title) { + echo '
  • '.$field_title; + } + echo '
'.$TEXT['BACK'].''; + + } else { + + // Check how many times form has been submitted in last hour + $query_submissions = $database->query("SELECT submission_id FROM ".TABLE_PREFIX."mod_form_submissions WHERE submitted_when >= '3600'"); + if($query_submissions->numRows() > $max_submissions) { + // Too many submissions so far this hour + echo $MESSAGE['MOD_FORM']['EXCESS_SUBMISSIONS']; + $success = false; + } else { + // Now send the email + if($email_to != '') { + if($email_from != '') { + if(mail($email_to,$email_subject,str_replace('\n', '', $email_body),"From: ".$email_from)) { $success = true; } + } else { + if(mail($email_to,$email_subject,str_replace('\n', '', $email_body))) { $success = true; } + } + } + // Write submission to database + if(isset($admin) AND $admin->get_user_id() > 0) { + $admin->get_user_id(); + } else { + $submitted_by = 0; + } + $email_body = $this->add_slashes($email_body); + $database->query("INSERT INTO ".TABLE_PREFIX."mod_form_submissions (page_id,section_id,submitted_when,submitted_by,body) VALUES ('".PAGE_ID."','$section_id','".mktime()."','$submitted_by','$email_body')"); + // Make sure submissions table isn't too full + $query_submissions = $database->query("SELECT submission_id FROM ".TABLE_PREFIX."mod_form_submissions ORDER BY submitted_when"); + $num_submissions = $query_submissions->numRows(); + if($num_submissions > $stored_submissions) { + // Remove excess submission + $num_to_remove = $num_submissions-$stored_submissions; + while($submission = $query_submissions->fetchRow()) { + if($num_to_remove > 0) { + $submission_id = $submission['submission_id']; + $database->query("DELETE FROM ".TABLE_PREFIX."mod_form_submissions WHERE submission_id = '$submission_id'"); + $num_to_remove = $num_to_remove-1; + } + } + } + if(!$database->is_error()) { + $success = true; + } + } + + // Now check if the email was sent successfully + if(isset($success) AND $success == true) { + echo $success_message; + } else { + echo $TEXT['ERROR']; + } + + } + +} + +?> \ No newline at end of file Property changes on: addons/modules/form/view.php ___________________________________________________________________ Added: svn:executable ## -0,0 +1 ## +* \ No newline at end of property Added: svn:keywords ## -0,0 +1 ## +Id \ No newline at end of property Index: addons/modules/form/view_submission.php =================================================================== --- addons/modules/form/view_submission.php (nonexistent) +++ addons/modules/form/view_submission.php (revision 81) @@ -0,0 +1,92 @@ + + Copyright (C) 2004-2005, Ryan Djurovich + + Website Baker is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + Website Baker is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Website Baker; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +*/ + +/* +The Website Baker Project would like to thank Rudolph Lartey +for his contributions to this module - adding extra field types +*/ + +require('../../config.php'); + +// Get id +if(!isset($_GET['submission_id']) OR !is_numeric($_GET['submission_id'])) { + header("Location: ".ADMIN_URL."/pages/index.php"); +} else { + $submission_id = $_GET['submission_id']; +} + +// Include WB admin wrapper script +require(WB_PATH.'/modules/admin.php'); + +// Get submission details +$query_content = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_form_submissions WHERE submission_id = '$submission_id'"); +$submission = $query_content->fetchRow(); + +// Get the user details of whoever did this submission +$query_user = "SELECT username,display_name FROM ".TABLE_PREFIX."users WHERE user_id = '".$submission['submitted_by']."'"; +$get_user = $database->query($query_user); +if($get_user->numRows() != 0) { + $user = $get_user->fetchRow(); +} else { + $user['display_name'] = 'Unknown'; + $user['username'] = 'unknown'; +} + +?> + + + + + + + + + + + + + + + + + + + +
:
:
:
+
+
+ strip_slashes_dummy(str_replace('\n', '
', $submission['body'])); ?> +
+ +
+ + + +print_footer(); + +?> \ No newline at end of file Property changes on: addons/modules/form/view_submission.php ___________________________________________________________________ Added: svn:keywords ## -0,0 +1 ## +Id \ No newline at end of property Index: addons/modules/form/save_settings.php =================================================================== --- addons/modules/form/save_settings.php (nonexistent) +++ addons/modules/form/save_settings.php (revision 81) @@ -0,0 +1,79 @@ + + Copyright (C) 2004-2005, Ryan Djurovich + + Website Baker is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + Website Baker is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Website Baker; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +*/ + +/* +The Website Baker Project would like to thank Rudolph Lartey +for his contributions to this module - adding extra field types +*/ + +require('../../config.php'); + +// Include WB admin wrapper script +$update_when_modified = true; // Tells script to update when this page was last updated +require(WB_PATH.'/modules/admin.php'); + +// This code removes any ', ''); +$header = $admin->add_slashes($_POST['header']); +$field_loop = $admin->add_slashes($_POST['field_loop']); +$footer = $admin->add_slashes($_POST['footer']); +$email_to = $admin->add_slashes($_POST['email_to']); +if($_POST['email_from_field'] == '') { + $email_from = $admin->add_slashes($_POST['email_from']); +} else { + $email_from = $admin->add_slashes($_POST['email_from_field']); +} +$email_subject = $admin->add_slashes($_POST['email_subject']); +$success_message = $admin->add_slashes($_POST['success_message']); +if(!is_numeric($_POST['max_submissions'])) { + $max_submissions = 50; +} else { + $max_submissions = $_POST['max_submissions']; +} +if(!is_numeric($_POST['stored_submissions'])) { + $stored_submissions = 100; +} else { + $stored_submissions = $_POST['stored_submissions']; +} +// Make sure max submissions is not smaller than stored submissions +if($max_submissions < $stored_submissions) { + $max_submissions = $stored_submissions; +} + +// Update settings +$database->query("UPDATE ".TABLE_PREFIX."mod_form_settings SET header = '$header', field_loop = '$field_loop', footer = '$footer', email_to = '$email_to', email_from = '$email_from', email_subject = '$email_subject', success_message = '$success_message', max_submissions = '$max_submissions', stored_submissions = '$stored_submissions' WHERE section_id = '$section_id'"); + +// Check if there is a db error, otherwise say successful +if($database->is_error()) { + $admin->print_error($database->get_error(), ADMIN_URL.'/pages/modify.php?page_id='.$page_id); +} else { + $admin->print_success($TEXT['SUCCESS'], ADMIN_URL.'/pages/modify.php?page_id='.$page_id); +} + +// Print admin footer +$admin->print_footer(); + +?> \ No newline at end of file Property changes on: addons/modules/form/save_settings.php ___________________________________________________________________ Added: svn:executable ## -0,0 +1 ## +* \ No newline at end of property Added: svn:keywords ## -0,0 +1 ## +Id \ No newline at end of property Index: addons/modules/form/add_field.php =================================================================== --- addons/modules/form/add_field.php (nonexistent) +++ addons/modules/form/add_field.php (revision 81) @@ -0,0 +1,58 @@ + + Copyright (C) 2004-2005, Ryan Djurovich + + Website Baker is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + Website Baker is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Website Baker; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +*/ + +/* +The Website Baker Project would like to thank Rudolph Lartey +for his contributions to this module - adding extra field types +*/ + +require('../../config.php'); + +// Include WB admin wrapper script +require(WB_PATH.'/modules/admin.php'); + +// Include the ordering class +require(WB_PATH.'/framework/class.order.php'); +// Get new order +$order = new order(TABLE_PREFIX.'mod_form_fields', 'position', 'field_id', 'section_id'); +$position = $order->get_new($section_id); + +// Insert new row into database +$database->query("INSERT INTO ".TABLE_PREFIX."mod_form_fields (section_id,page_id,position,required) VALUES ('$section_id','$page_id','$position','0')"); + +// Get the id +$field_id = $database->get_one("SELECT LAST_INSERT_ID()"); + +// Say that a new record has been added, then redirect to modify page +if($database->is_error()) { + $admin->print_error($database->get_error(), WB_URL.'/modules/form/modify_field.php?page_id='.$page_id.'§ion_id='.$section_id.'&field_id='.$field_id); +} else { + $admin->print_success($TEXT['SUCCESS'], WB_URL.'/modules/form/modify_field.php?page_id='.$page_id.'§ion_id='.$section_id.'&field_id='.$field_id); +} + +// Print admin footer +$admin->print_footer(); + +?> \ No newline at end of file Property changes on: addons/modules/form/add_field.php ___________________________________________________________________ Added: svn:executable ## -0,0 +1 ## +* \ No newline at end of property Added: svn:keywords ## -0,0 +1 ## +Id \ No newline at end of property Index: addons/modules/form/info.php =================================================================== --- addons/modules/form/info.php (nonexistent) +++ addons/modules/form/info.php (revision 81) @@ -0,0 +1,40 @@ + + Copyright (C) 2004-2005, Ryan Djurovich + + Website Baker is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + Website Baker is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Website Baker; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +*/ + +/* +The Website Baker Project would like to thank Rudolph Lartey +for his contributions to this module - adding extra field types +*/ + +$module_directory = 'form'; +$module_name = 'Form'; +$module_type = 'page'; +$module_version = '2.5'; +$module_designed_for = '2.x'; +$module_author = 'Ryan Djurovich & Rudolph Lartey'; +$module_description = 'This module allows you to create customised online forms, such as a feedback form. '. +'Thank-you to Rudolph Lartey who help enhance this module, providing code for extra field types, etc.'; + +?> \ No newline at end of file Property changes on: addons/modules/form/info.php ___________________________________________________________________ Added: svn:executable ## -0,0 +1 ## +* \ No newline at end of property Added: svn:keywords ## -0,0 +1 ## +Id \ No newline at end of property Index: addons/modules/form/move_down.php =================================================================== --- addons/modules/form/move_down.php (nonexistent) +++ addons/modules/form/move_down.php (revision 81) @@ -0,0 +1,57 @@ + + Copyright (C) 2004-2005, Ryan Djurovich + + Website Baker is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + Website Baker is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Website Baker; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +*/ + +/* +The Website Baker Project would like to thank Rudolph Lartey +for his contributions to this module - adding extra field types +*/ + +require('../../config.php'); + +// Get id +if(!isset($_GET['field_id']) OR !is_numeric($_GET['field_id'])) { + header("Location: index.php"); +} else { + $field_id = $_GET['field_id']; +} + +// Include WB admin wrapper script +require(WB_PATH.'/modules/admin.php'); + +// Include the ordering class +require(WB_PATH.'/framework/class.order.php'); + +// Create new order object an reorder +$order = new order(TABLE_PREFIX.'mod_form_fields', 'position', 'field_id', 'section_id'); +if($order->move_down($field_id)) { + $admin->print_success($TEXT['SUCCESS'], ADMIN_URL.'/pages/modify.php?page_id='.$page_id); +} else { + $admin->print_error($TEXT['ERROR'], ADMIN_URL.'/pages/modify.php?page_id='.$page_id); +} + +// Print admin footer +$admin->print_footer(); + +?> \ No newline at end of file Property changes on: addons/modules/form/move_down.php ___________________________________________________________________ Added: svn:executable ## -0,0 +1 ## +* \ No newline at end of property Added: svn:keywords ## -0,0 +1 ## +Id \ No newline at end of property Index: addons/modules/form/delete.php =================================================================== --- addons/modules/form/delete.php (nonexistent) +++ addons/modules/form/delete.php (revision 81) @@ -0,0 +1,35 @@ + + Copyright (C) 2004-2005, Ryan Djurovich + + Website Baker is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + Website Baker is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Website Baker; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +*/ + +/* +The Website Baker Project would like to thank Rudolph Lartey +for his contributions to this module - adding extra field types +*/ + +// Delete page from mod_wysiwyg +$database->query("DELETE FROM ".TABLE_PREFIX."mod_form_fields WHERE page_id = '$page_id'"); +$database->query("DELETE FROM ".TABLE_PREFIX."mod_form_settings WHERE page_id = '$page_id'"); + +?> \ No newline at end of file Property changes on: addons/modules/form/delete.php ___________________________________________________________________ Added: svn:executable ## -0,0 +1 ## +* \ No newline at end of property Added: svn:keywords ## -0,0 +1 ## +Id \ No newline at end of property Index: addons/modules/form/delete_field.php =================================================================== --- addons/modules/form/delete_field.php (nonexistent) +++ addons/modules/form/delete_field.php (revision 81) @@ -0,0 +1,57 @@ + + Copyright (C) 2004-2005, Ryan Djurovich + + Website Baker is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + Website Baker is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Website Baker; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +*/ + +/* +The Website Baker Project would like to thank Rudolph Lartey +for his contributions to this module - adding extra field types +*/ + +require('../../config.php'); + +// Get id +if(!isset($_GET['field_id']) OR !is_numeric($_GET['field_id'])) { + header("Location: ".ADMIN_URL."/pages/index.php"); +} else { + $field_id = $_GET['field_id']; +} + +// Include WB admin wrapper script +$update_when_modified = true; // Tells script to update when this page was last updated +require(WB_PATH.'/modules/admin.php'); + +// Delete row +$database->query("DELETE FROM ".TABLE_PREFIX."mod_form_fields WHERE field_id = '$field_id'"); + +// Check if there is a db error, otherwise say successful +if($database->is_error()) { + $admin->print_error($database->get_error(), ADMIN_URL.'/pages/modify.php?page_id='.$page_id); +} else { + $admin->print_success($TEXT['SUCCESS'], ADMIN_URL.'/pages/modify.php?page_id='.$page_id); +} + +// Print admin footer +$admin->print_footer(); + +?> \ No newline at end of file Property changes on: addons/modules/form/delete_field.php ___________________________________________________________________ Added: svn:executable ## -0,0 +1 ## +* \ No newline at end of property Added: svn:keywords ## -0,0 +1 ## +Id \ No newline at end of property Index: addons/modules/form/install.php =================================================================== --- addons/modules/form/install.php (nonexistent) +++ addons/modules/form/install.php (revision 81) @@ -0,0 +1,103 @@ + + Copyright (C) 2004-2005, Ryan Djurovich + + Website Baker is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + Website Baker is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Website Baker; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +*/ + +/* +The Website Baker Project would like to thank Rudolph Lartey +for his contributions to this module - adding extra field types +*/ + +if(defined('WB_URL')) { + + // Create tables + $database->query("DROP TABLE IF EXISTS `".TABLE_PREFIX."mod_form_fields`"); + $mod_form = 'CREATE TABLE `'.TABLE_PREFIX.'mod_form_fields` ( `field_id` INT NOT NULL AUTO_INCREMENT,' + . ' `section_id` INT NOT NULL ,' + . ' `page_id` INT NOT NULL ,' + . ' `position` INT NOT NULL ,' + . ' `title` VARCHAR(255) NOT NULL ,' + . ' `type` VARCHAR(255) NOT NULL ,' + . ' `required` INT NOT NULL ,' + . ' `value` TEXT NOT NULL ,' + . ' `extra` TEXT NOT NULL ,' + . ' PRIMARY KEY ( `field_id` ) )' + . ' '; + $database->query($mod_form); + $database->query("DROP TABLE IF EXISTS `".TABLE_PREFIX."mod_form_settings`"); + $mod_form = 'CREATE TABLE `'.TABLE_PREFIX.'mod_form_settings` (' + . ' `section_id` INT NOT NULL,' + . ' `page_id` INT NOT NULL,' + . ' `header` TEXT NOT NULL ,' + . ' `field_loop` TEXT NOT NULL ,' + . ' `footer` TEXT NOT NULL ,' + . ' `email_to` TEXT NOT NULL ,' + . ' `email_from` VARCHAR(255) NOT NULL ,' + . ' `email_subject` VARCHAR(255) NOT NULL ,' + . ' `success_message` TEXT NOT NULL ,' + . ' `stored_submissions` INT NOT NULL,' + . ' `max_submissions` INT NOT NULL,' + . ' PRIMARY KEY ( `section_id` ) )' + . ' '; + $database->query($mod_form); + $database->query("DROP TABLE IF EXISTS `".TABLE_PREFIX."mod_form_submissions`"); + $mod_form = 'CREATE TABLE `'.TABLE_PREFIX.'mod_form_submissions` ( `submission_id` INT NOT NULL AUTO_INCREMENT,' + . ' `section_id` INT NOT NULL,' + . ' `page_id` INT NOT NULL,' + . ' `submitted_when` INT NOT NULL,' + . ' `submitted_by` INT NOT NULL,' + . ' `body` TEXT NOT NULL ,' + . ' PRIMARY KEY ( `submission_id` ) )' + . ' '; + $database->query($mod_form); + + // Insert info into the search table + // Module query info + $field_info = array(); + $field_info['page_id'] = 'page_id'; + $field_info['title'] = 'page_title'; + $field_info['link'] = 'link'; + $field_info['description'] = 'description'; + $field_info['modified_when'] = 'modified_when'; + $field_info['modified_by'] = 'modified_by'; + $field_info = serialize($field_info); + $database->query("INSERT INTO ".TABLE_PREFIX."search (name,value,extra) VALUES ('module', 'form', '$field_info')"); + // Query start + $query_start_code = "SELECT [TP]pages.page_id, [TP]pages.page_title, [TP]pages.link, [TP]pages.description, [TP]pages.modified_when, [TP]pages.modified_by FROM [TP]mod_form_fields, [TP]mod_form_settings, [TP]pages WHERE "; + $database->query("INSERT INTO ".TABLE_PREFIX."search (name,value,extra) VALUES ('query_start', '$query_start_code', 'form')"); + // Query body + $query_body_code = " [TP]pages.page_id = [TP]mod_form_settings.page_id AND [TP]mod_form_settings.header [O] \'[W][STRING][W]\' AND [TP]pages.searching = \'1\' + OR [TP]pages.page_id = [TP]mod_form_settings.page_id AND [TP]mod_form_settings.footer [O] \'[W][STRING][W]\' AND [TP]pages.searching = \'1\' + OR [TP]pages.page_id = [TP]mod_form_fields.page_id AND [TP]mod_form_fields.title [O] \'[W][STRING][W]\' AND [TP]pages.searching = \'1\'"; + $database->query("INSERT INTO ".TABLE_PREFIX."search (name,value,extra) VALUES ('query_body', '$query_body_code', 'form')"); + // Query end + $query_end_code = ''; + $database->query("INSERT INTO ".TABLE_PREFIX."search (name,value,extra) VALUES ('query_end', '$query_end_code', 'form')"); + + // Insert blank row (there needs to be at least on row for the search to work) + $database->query("INSERT INTO ".TABLE_PREFIX."mod_form_fields (page_id,section_id) VALUES ('0','0')"); + $database->query("INSERT INTO ".TABLE_PREFIX."mod_form_settings (page_id,section_id) VALUES ('0','0')"); + +} + +?> \ No newline at end of file Property changes on: addons/modules/form/install.php ___________________________________________________________________ Added: svn:executable ## -0,0 +1 ## +* \ No newline at end of property Added: svn:keywords ## -0,0 +1 ## +Id \ No newline at end of property Index: addons/modules/form/index.php =================================================================== --- addons/modules/form/index.php (nonexistent) +++ addons/modules/form/index.php (revision 81) @@ -0,0 +1,33 @@ + + Copyright (C) 2004-2005, Ryan Djurovich + + Website Baker is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + Website Baker is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Website Baker; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +*/ + +/* +The Website Baker Project would like to thank Rudolph Lartey +for his contributions to this module - adding extra field types +*/ + +header('Location: ../index.php'); + +?> \ No newline at end of file Property changes on: addons/modules/form/index.php ___________________________________________________________________ Added: svn:executable ## -0,0 +1 ## +* \ No newline at end of property Added: svn:keywords ## -0,0 +1 ## +Id \ No newline at end of property Index: addons/modules/form/move_up.php =================================================================== --- addons/modules/form/move_up.php (nonexistent) +++ addons/modules/form/move_up.php (revision 81) @@ -0,0 +1,57 @@ + + Copyright (C) 2004-2005, Ryan Djurovich + + Website Baker is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + Website Baker is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Website Baker; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +*/ + +/* +The Website Baker Project would like to thank Rudolph Lartey +for his contributions to this module - adding extra field types +*/ + +require('../../config.php'); + +// Get id +if(!isset($_GET['field_id']) OR !is_numeric($_GET['field_id'])) { + header("Location: index.php"); +} else { + $field_id = $_GET['field_id']; +} + +// Include WB admin wrapper script +require(WB_PATH.'/modules/admin.php'); + +// Include the ordering class +require(WB_PATH.'/framework/class.order.php'); + +// Create new order object an reorder +$order = new order(TABLE_PREFIX.'mod_form_fields', 'position', 'field_id', 'section_id'); +if($order->move_up($field_id)) { + $admin->print_success($TEXT['SUCCESS'], ADMIN_URL.'/pages/modify.php?page_id='.$page_id); +} else { + $admin->print_error($TEXT['ERROR'], ADMIN_URL.'/pages/modify.php?page_id='.$page_id); +} + +// Print admin footer +$admin->print_footer(); + +?> \ No newline at end of file Property changes on: addons/modules/form/move_up.php ___________________________________________________________________ Added: svn:executable ## -0,0 +1 ## +* \ No newline at end of property Added: svn:keywords ## -0,0 +1 ## +Id \ No newline at end of property Index: addons/modules/form/delete_submission.php =================================================================== --- addons/modules/form/delete_submission.php (nonexistent) +++ addons/modules/form/delete_submission.php (revision 81) @@ -0,0 +1,57 @@ + + Copyright (C) 2004-2005, Ryan Djurovich + + Website Baker is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + Website Baker is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Website Baker; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +*/ + +/* +The Website Baker Project would like to thank Rudolph Lartey +for his contributions to this module - adding extra submission types +*/ + +require('../../config.php'); + +// Get id +if(!isset($_GET['submission_id']) OR !is_numeric($_GET['submission_id'])) { + header("Location: ".ADMIN_URL."/pages/index.php"); +} else { + $submission_id = $_GET['submission_id']; +} + +// Include WB admin wrapper script +$update_when_modified = true; // Tells script to update when this page was last updated +require(WB_PATH.'/modules/admin.php'); + +// Delete row +$database->query("DELETE FROM ".TABLE_PREFIX."mod_form_submissions WHERE submission_id = '$submission_id'"); + +// Check if there is a db error, otherwise say successful +if($database->is_error()) { + $admin->print_error($database->get_error(), ADMIN_URL.'/pages/modify.php?page_id='.$page_id); +} else { + $admin->print_success($TEXT['SUCCESS'], ADMIN_URL.'/pages/modify.php?page_id='.$page_id); +} + +// Print admin footer +$admin->print_footer(); + +?> \ No newline at end of file Property changes on: addons/modules/form/delete_submission.php ___________________________________________________________________ Added: svn:keywords ## -0,0 +1 ## +Id \ No newline at end of property Index: addons/modules/form/modify.php =================================================================== --- addons/modules/form/modify.php (nonexistent) +++ addons/modules/form/modify.php (revision 81) @@ -0,0 +1,191 @@ + + Copyright (C) 2004-2005, Ryan Djurovich + + Website Baker is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + Website Baker is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Website Baker; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +*/ + +/* +The Website Baker Project would like to thank Rudolph Lartey +for his contributions to this module - adding extra field types +*/ + +// Must include code to stop this file being access directly +if(!defined('WB_PATH')) { exit("Cannot access this file directly"); } + +?> + + + + + +
+ + + +
+ +
+ +

+query("SELECT * FROM `".TABLE_PREFIX."mod_form_fields` WHERE section_id = '$section_id' ORDER BY position ASC"); +if($query_fields->numRows() > 0) { + $num_fields = $query_fields->numRows(); + $row = 'a'; + ?> + + fetchRow()) { + ?> + + + + + + + + + + + +
+ + ^ + + + + + + + + + + + + + + + ^ + + + + + + v + + + + + X + +
+ + +

+ +

+ +query("SELECT * FROM `".TABLE_PREFIX."mod_form_submissions` WHERE section_id = '$section_id' ORDER BY submitted_when ASC"); +if($query_submissions->numRows() > 0) { + ?> + + fetchRow()) { + ?> + + + + + + + +
+ + <?php echo $TEXT['OPEN']; ?> + + + + X + +
+ + +
\ No newline at end of file Property changes on: addons/modules/form/modify.php ___________________________________________________________________ Added: svn:executable ## -0,0 +1 ## +* \ No newline at end of property Added: svn:keywords ## -0,0 +1 ## +Id \ No newline at end of property Index: addons/modules/form/add.php =================================================================== --- addons/modules/form/add.php (nonexistent) +++ addons/modules/form/add.php (revision 81) @@ -0,0 +1,48 @@ + + Copyright (C) 2004-2005, Ryan Djurovich + + Website Baker is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; either version 2 of the License, or + (at your option) any later version. + + Website Baker is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with Website Baker; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +*/ + +/* +The Website Baker Project would like to thank Rudolph Lartey +for his contributions to this module - adding extra field types +*/ + +// Insert an extra rows into the database +$header = ''; +$field_loop = ''; +$footer = ' + + +
{TITLE}{REQUIRED}:{FIELD}
  + +
'; +$email_to = $admin->get_email(); +$email_from = ''; +$email_subject = 'Results from form on website...'; +$success_message = 'Thank-you.'; +$max_submissions = 50; +$stored_submissions = 100; +$database->query("INSERT INTO ".TABLE_PREFIX."mod_form_settings (page_id,section_id,header,field_loop,footer,email_to,email_from,email_subject,success_message,max_submissions,stored_submissions) VALUES ('$page_id','$section_id','$header','$field_loop','$footer','$email_to','$email_from','$email_subject','$success_message','$max_submissions','$stored_submissions')"); + +?> \ No newline at end of file Property changes on: addons/modules/form/add.php ___________________________________________________________________ Added: svn:executable ## -0,0 +1 ## +* \ No newline at end of property Added: svn:keywords ## -0,0 +1 ## +Id \ No newline at end of property