| 1 | 560 | Ruebenwurz | <?php
 | 
      
        | 2 |  |  | 
 | 
      
        | 3 |  |  | // $Id$
 | 
      
        | 4 |  |  | 
 | 
      
        | 5 |  |  | /*
 | 
      
        | 6 |  |  | 
 | 
      
        | 7 |  |  |  Website Baker Project <http://www.websitebaker.org/>
 | 
      
        | 8 |  |  |  Copyright (C) 2004-2008, Ryan Djurovich
 | 
      
        | 9 |  |  | 
 | 
      
        | 10 |  |  |  Website Baker is free software; you can redistribute it and/or modify
 | 
      
        | 11 |  |  |  it under the terms of the GNU General Public License as published by
 | 
      
        | 12 |  |  |  the Free Software Foundation; either version 2 of the License, or
 | 
      
        | 13 |  |  |  (at your option) any later version.
 | 
      
        | 14 |  |  | 
 | 
      
        | 15 |  |  |  Website Baker is distributed in the hope that it will be useful,
 | 
      
        | 16 |  |  |  but WITHOUT ANY WARRANTY; without even the implied warranty of
 | 
      
        | 17 |  |  |  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 | 
      
        | 18 |  |  |  GNU General Public License for more details.
 | 
      
        | 19 |  |  | 
 | 
      
        | 20 |  |  |  You should have received a copy of the GNU General Public License
 | 
      
        | 21 |  |  |  along with Website Baker; if not, write to the Free Software
 | 
      
        | 22 |  |  |  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 | 
      
        | 23 |  |  | 
 | 
      
        | 24 |  |  | */
 | 
      
        | 25 |  |  | 
 | 
      
        | 26 |  |  | /*
 | 
      
        | 27 |  |  | The Website Baker Project would like to thank Rudolph Lartey <www.carbonect.com>
 | 
      
        | 28 |  |  | for his contributions to this module - adding extra field types
 | 
      
        | 29 |  |  | */
 | 
      
        | 30 |  |  | 
 | 
      
        | 31 |  |  | // Must include code to stop this file being access directly
 | 
      
        | 32 |  |  | if(defined('WB_PATH') == false) { exit("Cannot access this file directly"); }
 | 
      
        | 33 |  |  | 
 | 
      
        | 34 |  |  | // check if frontend.css file needs to be included into the <body></body> of view.php
 | 
      
        | 35 | 570 | doc | if((!function_exists('register_frontend_modfiles') || !defined('MOD_FRONTEND_CSS_REGISTERED')) &&
 | 
      
        | 36 |  |  | 	file_exists(WB_PATH .'/modules/form/frontend.css')) {
 | 
      
        | 37 |  |  | 	echo '<style type="text/css">';
 | 
      
        | 38 |  |  | 	include(WB_PATH .'/modules/form/frontend.css');
 | 
      
        | 39 |  |  | 	echo "\n</style>\n";
 | 
      
        | 40 | 560 | Ruebenwurz | }
 | 
      
        | 41 |  |  | 
 | 
      
        | 42 | 596 | thorn | require_once(WB_PATH.'/include/captcha/captcha.php');
 | 
      
        | 43 |  |  | 
 | 
      
        | 44 | 789 | doc | // obtain the settings of the output filter module
 | 
      
        | 45 |  |  | if(file_exists(WB_PATH.'/modules/output_filter/filter-routines.php')) {
 | 
      
        | 46 |  |  | 	include_once(WB_PATH.'/modules/output_filter/filter-routines.php');
 | 
      
        | 47 |  |  | 	$filter_settings = get_output_filter_settings();
 | 
      
        | 48 |  |  | } else {
 | 
      
        | 49 |  |  | 	// no output filter used, define default settings
 | 
      
        | 50 |  |  | 	$filter_settings['email_filter'] = 0;
 | 
      
        | 51 |  |  | }
 | 
      
        | 52 |  |  | 
 | 
      
        | 53 | 560 | Ruebenwurz | // Function for generating an optionsfor a select field
 | 
      
        | 54 | 570 | doc | if (!function_exists('make_option')) {
 | 
      
        | 55 | 618 | thorn | function make_option(&$n, $k, $values) {
 | 
      
        | 56 | 560 | Ruebenwurz | 	// start option group if it exists
 | 
      
        | 57 |  |  | 	if (substr($n,0,2) == '[=') {
 | 
      
        | 58 |  |  | 	 	$n = '<optgroup label="'.substr($n,2,strlen($n)).'">';
 | 
      
        | 59 |  |  | 	} elseif ($n == ']') {
 | 
      
        | 60 |  |  | 		$n = '</optgroup>';
 | 
      
        | 61 |  |  | 	} else {
 | 
      
        | 62 | 760 | Ruebenwurz | 		if(in_array($n, $values)) {
 | 
      
        | 63 | 618 | thorn | 			$n = '<option selected="selected" value="'.$n.'">'.$n.'</option>';
 | 
      
        | 64 | 760 | Ruebenwurz | 		} else {
 | 
      
        | 65 | 618 | thorn | 			$n = '<option value="'.$n.'">'.$n.'</option>';
 | 
      
        | 66 | 760 | Ruebenwurz | 		}
 | 
      
        | 67 | 560 | Ruebenwurz | 	}
 | 
      
        | 68 |  |  | }
 | 
      
        | 69 |  |  | }
 | 
      
        | 70 |  |  | // Function for generating a checkbox
 | 
      
        | 71 | 570 | doc | if (!function_exists('make_checkbox')) {
 | 
      
        | 72 | 560 | Ruebenwurz | function make_checkbox(&$n, $idx, $params) {
 | 
      
        | 73 | 618 | thorn | 	$field_id = $params[0][0];
 | 
      
        | 74 |  |  | 	$seperator = $params[0][1];
 | 
      
        | 75 | 760 | Ruebenwurz | 	$label_id = 'wb_'.str_replace(" ", "_", $n);
 | 
      
        | 76 |  |  | 	if(in_array($n, $params[1])) {
 | 
      
        | 77 |  |  | 		$n = '<input class="field_checkbox" type="checkbox" id="'.$label_id.'" name="field'.$field_id.'['.$idx.']" value="'.$n.'" checked="checked" />'.'<label for="'.$label_id.'" class="checkbox_label">'.$n.'</lable>'.$seperator;
 | 
      
        | 78 |  |  | 	} else {
 | 
      
        | 79 |  |  | 		$n = '<input class="field_checkbox" type="checkbox" id="'.$label_id.'" name="field'.$field_id.'['.$idx.']" value="'.$n.'" />'.'<label for="'.$label_id.'" class="checkbox_label">'.$n.'</label>'.$seperator;
 | 
      
        | 80 |  |  | 	}
 | 
      
        | 81 | 560 | Ruebenwurz | }
 | 
      
        | 82 |  |  | }
 | 
      
        | 83 |  |  | // Function for generating a radio button
 | 
      
        | 84 | 570 | doc | if (!function_exists('make_radio')) {
 | 
      
        | 85 | 560 | Ruebenwurz | function make_radio(&$n, $idx, $params) {
 | 
      
        | 86 |  |  | 	$field_id = $params[0];
 | 
      
        | 87 |  |  | 	$group = $params[1];
 | 
      
        | 88 |  |  | 	$seperator = $params[2];
 | 
      
        | 89 | 760 | Ruebenwurz | 	$label_id = 'wb_'.str_replace(" ", "_", $n);
 | 
      
        | 90 |  |  | 	if($n == $params[3]) {
 | 
      
        | 91 |  |  | 		$n = '<input class="field_radio" type="radio" id="'.$label_id.'" name="field'.$field_id.'" value="'.$n.'" checked="checked" />'.'<label for="'.$label_id.'" class="radio_label">'.$n.'</label>'.$seperator;
 | 
      
        | 92 |  |  | 	} else {
 | 
      
        | 93 |  |  | 		$n = '<input class="field_radio" type="radio" id="'.$label_id.'" name="field'.$field_id.'" value="'.$n.'" />'.'<label for="'.$label_id.'" class="radio_label">'.$n.'</label>'.$seperator;
 | 
      
        | 94 |  |  | 	}
 | 
      
        | 95 | 560 | Ruebenwurz | }
 | 
      
        | 96 |  |  | }
 | 
      
        | 97 |  |  | // Generate temp submission id
 | 
      
        | 98 |  |  | function new_submission_id() {
 | 
      
        | 99 |  |  | 	$submission_id = '';
 | 
      
        | 100 |  |  | 	$salt = "abchefghjkmnpqrstuvwxyz0123456789";
 | 
      
        | 101 |  |  | 	srand((double)microtime()*1000000);
 | 
      
        | 102 |  |  | 	$i = 0;
 | 
      
        | 103 |  |  | 	while ($i <= 7) {
 | 
      
        | 104 |  |  | 		$num = rand() % 33;
 | 
      
        | 105 |  |  | 		$tmp = substr($salt, $num, 1);
 | 
      
        | 106 |  |  | 		$submission_id = $submission_id . $tmp;
 | 
      
        | 107 |  |  | 		$i++;
 | 
      
        | 108 |  |  | 	}
 | 
      
        | 109 |  |  | 	return $submission_id;
 | 
      
        | 110 |  |  | }
 | 
      
        | 111 |  |  | 
 | 
      
        | 112 |  |  | // Work-out if the form has been submitted or not
 | 
      
        | 113 |  |  | if($_POST == array()) {
 | 
      
        | 114 |  |  | 
 | 
      
        | 115 |  |  | // Set new submission ID in session
 | 
      
        | 116 |  |  | $_SESSION['form_submission_id'] = new_submission_id();
 | 
      
        | 117 |  |  | 
 | 
      
        | 118 |  |  | // Get settings
 | 
      
        | 119 |  |  | $query_settings = $database->query("SELECT header,field_loop,footer,use_captcha FROM ".TABLE_PREFIX."mod_form_settings WHERE section_id = '$section_id'");
 | 
      
        | 120 |  |  | if($query_settings->numRows() > 0) {
 | 
      
        | 121 |  |  | 	$fetch_settings = $query_settings->fetchRow();
 | 
      
        | 122 |  |  | 	$header = str_replace('{WB_URL}',WB_URL,$fetch_settings['header']);
 | 
      
        | 123 |  |  | 	$field_loop = $fetch_settings['field_loop'];
 | 
      
        | 124 |  |  | 	$footer = str_replace('{WB_URL}',WB_URL,$fetch_settings['footer']);
 | 
      
        | 125 |  |  | 	$use_captcha = $fetch_settings['use_captcha'];
 | 
      
        | 126 |  |  | } else {
 | 
      
        | 127 |  |  | 	$header = '';
 | 
      
        | 128 |  |  | 	$field_loop = '';
 | 
      
        | 129 |  |  | 	$footer = '';
 | 
      
        | 130 |  |  | }
 | 
      
        | 131 |  |  | 
 | 
      
        | 132 |  |  | ?>
 | 
      
        | 133 | 760 | Ruebenwurz | <form name="form" action="<?php echo htmlspecialchars(strip_tags($_SERVER['PHP_SELF'])); ?>" method="post">
 | 
      
        | 134 | 560 | Ruebenwurz | <input type="hidden" name="submission_id" value="<?php echo $_SESSION['form_submission_id']; ?>" />
 | 
      
        | 135 |  |  | <?php
 | 
      
        | 136 | 596 | thorn | if(ENABLED_ASP) { // first add some honeypot-fields
 | 
      
        | 137 |  |  | ?>
 | 
      
        | 138 |  |  | <input type="hidden" name="submitted_when" value="<?php $t=time(); echo $t; $_SESSION['submitted_when']=$t; ?>" />
 | 
      
        | 139 | 739 | thorn | <p class="nixhier">
 | 
      
        | 140 | 596 | thorn | email address:
 | 
      
        | 141 | 762 | thorn | <label for="email">Leave this field email-address blank:</label>
 | 
      
        | 142 | 596 | thorn | <input id="email" name="email" size="56" value="" /><br />
 | 
      
        | 143 |  |  | Homepage:
 | 
      
        | 144 | 762 | thorn | <label for="homepage">Leave this field homepage blank:</label>
 | 
      
        | 145 | 596 | thorn | <input id="homepage" name="homepage" size="55" value="" /><br />
 | 
      
        | 146 |  |  | URL:
 | 
      
        | 147 | 762 | thorn | <label for="url">Leave this field url blank:</label>
 | 
      
        | 148 | 596 | thorn | <input id="url" name="url" size="61" value="" /><br />
 | 
      
        | 149 |  |  | Comment:
 | 
      
        | 150 | 762 | thorn | <label for="comment">Leave this field comment blank:</label>
 | 
      
        | 151 | 760 | Ruebenwurz | <textarea id="comment" name="comment" cols="50" rows="10"></textarea><br />
 | 
      
        | 152 | 596 | thorn | </p>
 | 
      
        | 153 | 760 | Ruebenwurz | 
 | 
      
        | 154 | 596 | thorn | <?php }
 | 
      
        | 155 |  |  | 
 | 
      
        | 156 | 760 | Ruebenwurz | // Print header
 | 
      
        | 157 |  |  | echo $header;
 | 
      
        | 158 |  |  | 
 | 
      
        | 159 | 560 | Ruebenwurz | // Get list of fields
 | 
      
        | 160 |  |  | $query_fields = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_form_fields WHERE section_id = '$section_id' ORDER BY position ASC");
 | 
      
        | 161 | 760 | Ruebenwurz | 
 | 
      
        | 162 | 560 | Ruebenwurz | if($query_fields->numRows() > 0) {
 | 
      
        | 163 |  |  | 	while($field = $query_fields->fetchRow()) {
 | 
      
        | 164 |  |  | 		// Set field values
 | 
      
        | 165 |  |  | 		$field_id = $field['field_id'];
 | 
      
        | 166 |  |  | 		$value = $field['value'];
 | 
      
        | 167 |  |  | 		// Print field_loop after replacing vars with values
 | 
      
        | 168 |  |  | 		$vars = array('{TITLE}', '{REQUIRED}');
 | 
      
        | 169 | 760 | Ruebenwurz | 		if (($field['type'] == "radio") || ($field['type'] == "checkbox")) {
 | 
      
        | 170 |  |  | 			$field_title = $field['title'];
 | 
      
        | 171 | 560 | Ruebenwurz | 		} else {
 | 
      
        | 172 | 760 | Ruebenwurz | 			$field_title = '<label for="field'.$field_id.'">'.$field['title'].'</label>';
 | 
      
        | 173 |  |  | 		}
 | 
      
        | 174 |  |  | 		$values = array($field_title);
 | 
      
        | 175 |  |  | 		if ($field['required'] == 1) {
 | 
      
        | 176 |  |  | 			$values[] = '<span class="required">*</span>';
 | 
      
        | 177 |  |  | 		} else {
 | 
      
        | 178 | 560 | Ruebenwurz | 			$values[] = '';
 | 
      
        | 179 |  |  | 		}
 | 
      
        | 180 |  |  | 		if($field['type'] == 'textfield') {
 | 
      
        | 181 |  |  | 			$vars[] = '{FIELD}';
 | 
      
        | 182 | 618 | thorn | 			$values[] = '<input type="text" name="field'.$field_id.'" id="field'.$field_id.'" maxlength="'.$field['extra'].'" value="'.(isset($_SESSION['field'.$field_id])?$_SESSION['field'.$field_id]:$value).'" class="textfield" />';
 | 
      
        | 183 | 560 | Ruebenwurz | 		} elseif($field['type'] == 'textarea') {
 | 
      
        | 184 |  |  | 			$vars[] = '{FIELD}';
 | 
      
        | 185 | 760 | Ruebenwurz | 			$values[] = '<textarea name="field'.$field_id.'" id="field'.$field_id.'" class="textarea" cols="25" rows="5">'.(isset($_SESSION['field'.$field_id])?$_SESSION['field'.$field_id]:$value).'</textarea>';
 | 
      
        | 186 | 560 | Ruebenwurz | 		} elseif($field['type'] == 'select') {
 | 
      
        | 187 |  |  | 			$vars[] = '{FIELD}';
 | 
      
        | 188 |  |  | 			$options = explode(',', $value);
 | 
      
        | 189 | 618 | thorn | 			array_walk($options, 'make_option', (isset($_SESSION['field'.$field_id])?$_SESSION['field'.$field_id]:array()));
 | 
      
        | 190 | 760 | Ruebenwurz | 			$field['extra'] = explode(',',$field['extra']);
 | 
      
        | 191 |  |  | 			$values[] = '<select name="field'.$field_id.'[]" id="field'.$field_id.'" size="'.$field['extra'][0].'" '.$field['extra'][1].'="'.$field['extra'][1].'" class="select">'.implode($options).'</select>';
 | 
      
        | 192 | 560 | Ruebenwurz | 		} elseif($field['type'] == 'heading') {
 | 
      
        | 193 |  |  | 			$vars[] = '{FIELD}';
 | 
      
        | 194 |  |  | 			$values[] = '<input type="hidden" name="field'.$field_id.'" id="field'.$field_id.'" value="===['.$field['title'].']===" />';
 | 
      
        | 195 |  |  | 			$tmp_field_loop = $field_loop;		// temporarily modify the field loop template
 | 
      
        | 196 |  |  | 			$field_loop = $field['extra'];
 | 
      
        | 197 |  |  | 		} elseif($field['type'] == 'checkbox') {
 | 
      
        | 198 |  |  | 			$vars[] = '{FIELD}';
 | 
      
        | 199 |  |  | 			$options = explode(',', $value);
 | 
      
        | 200 | 618 | thorn | 			array_walk($options, 'make_checkbox', array(array($field_id,$field['extra']),(isset($_SESSION['field'.$field_id])?$_SESSION['field'.$field_id]:array())));
 | 
      
        | 201 | 560 | Ruebenwurz | 			$options[count($options)-1]=substr($options[count($options)-1],0,strlen($options[count($options)-1])-strlen($field['extra']));
 | 
      
        | 202 |  |  | 			$values[] = implode($options);
 | 
      
        | 203 |  |  | 		} elseif($field['type'] == 'radio') {
 | 
      
        | 204 |  |  | 			$vars[] = '{FIELD}';
 | 
      
        | 205 |  |  | 			$options = explode(',', $value);
 | 
      
        | 206 | 618 | thorn | 			array_walk($options, 'make_radio', array($field_id,$field['title'],$field['extra'], (isset($_SESSION['field'.$field_id])?$_SESSION['field'.$field_id]:'')));
 | 
      
        | 207 | 560 | Ruebenwurz | 			$options[count($options)-1]=substr($options[count($options)-1],0,strlen($options[count($options)-1])-strlen($field['extra']));
 | 
      
        | 208 |  |  | 			$values[] = implode($options);
 | 
      
        | 209 |  |  | 		} elseif($field['type'] == 'email') {
 | 
      
        | 210 |  |  | 			$vars[] = '{FIELD}';
 | 
      
        | 211 | 760 | Ruebenwurz | 			$values[] = '<input type="text" name="field'.$field_id.'" id="field'.$field_id.'" value="'.(isset($_SESSION['field'.$field_id])?$_SESSION['field'.$field_id]:'').'" maxlength="'.$field['extra'].'" class="email" />';
 | 
      
        | 212 | 560 | Ruebenwurz | 		}
 | 
      
        | 213 | 618 | thorn | 		if(isset($_SESSION['field'.$field_id])) unset($_SESSION['field'.$field_id]);
 | 
      
        | 214 | 560 | Ruebenwurz | 		if($field['type'] != '') {
 | 
      
        | 215 |  |  | 			echo str_replace($vars, $values, $field_loop);
 | 
      
        | 216 |  |  | 		}
 | 
      
        | 217 |  |  | 		if (isset($tmp_field_loop)) $field_loop = $tmp_field_loop;
 | 
      
        | 218 |  |  | 	}
 | 
      
        | 219 |  |  | }
 | 
      
        | 220 |  |  | 
 | 
      
        | 221 |  |  | // Captcha
 | 
      
        | 222 | 596 | thorn | if($use_captcha) { ?>
 | 
      
        | 223 |  |  | 	<tr>
 | 
      
        | 224 |  |  | 	<td class="field_title"><?php echo $TEXT['VERIFICATION']; ?>:</td>
 | 
      
        | 225 |  |  | 	<td><?php call_captcha(); ?></td>
 | 
      
        | 226 |  |  | 	</tr>
 | 
      
        | 227 | 560 | Ruebenwurz | 	<?php
 | 
      
        | 228 |  |  | }
 | 
      
        | 229 |  |  | 
 | 
      
        | 230 |  |  | // Print footer
 | 
      
        | 231 |  |  | echo $footer;
 | 
      
        | 232 |  |  | 
 | 
      
        | 233 | 789 | doc | /**
 | 
      
        | 234 |  |  | 	NOTE: comment out the line ob_end_flush() if you indicate problems (e.g. when using ob_start in the index.php of your template)
 | 
      
        | 235 |  |  | 	With ob_end_flush(): output filter will be disabled for this page (and all sections embedded on this page)
 | 
      
        | 236 |  |  | 	Without ob_end_flush(): emails are rewritten (e.g. name@domain.com --> name(at)domain(dot)com) if output filter is enabled
 | 
      
        | 237 |  |  | 	All replacements made by the Output-Filter module will be reverted before the email is send out
 | 
      
        | 238 |  |  | */
 | 
      
        | 239 |  |  | if($filter_settings['email_filter'] && !($filter_settings['at_replacement']=='@' && $filter_settings['dot_replacement']=='.')) {
 | 
      
        | 240 |  |  | 	ob_end_flush();
 | 
      
        | 241 |  |  | }
 | 
      
        | 242 |  |  | 
 | 
      
        | 243 | 560 | Ruebenwurz | // Add form end code
 | 
      
        | 244 |  |  | ?>
 | 
      
        | 245 |  |  | </form>
 | 
      
        | 246 |  |  | <?php
 | 
      
        | 247 |  |  | 
 | 
      
        | 248 |  |  | } else {
 | 
      
        | 249 |  |  | 
 | 
      
        | 250 |  |  | 	// Check that submission ID matches
 | 
      
        | 251 |  |  | 	if(isset($_SESSION['form_submission_id']) AND isset($_POST['submission_id']) AND $_SESSION['form_submission_id'] == $_POST['submission_id']) {
 | 
      
        | 252 |  |  | 
 | 
      
        | 253 |  |  | 		// Set new submission ID in session
 | 
      
        | 254 |  |  | 		$_SESSION['form_submission_id'] = new_submission_id();
 | 
      
        | 255 |  |  | 
 | 
      
        | 256 | 596 | thorn | 		if(ENABLED_ASP && ( // form faked? Check the honeypot-fields.
 | 
      
        | 257 |  |  | 			(!isset($_POST['submitted_when']) OR !isset($_SESSION['submitted_when'])) OR
 | 
      
        | 258 |  |  | 			($_POST['submitted_when'] != $_SESSION['submitted_when']) OR
 | 
      
        | 259 |  |  | 			(!isset($_POST['email']) OR $_POST['email']) OR
 | 
      
        | 260 |  |  | 			(!isset($_POST['homepage']) OR $_POST['homepage']) OR
 | 
      
        | 261 |  |  | 			(!isset($_POST['comment']) OR $_POST['comment']) OR
 | 
      
        | 262 |  |  | 			(!isset($_POST['url']) OR $_POST['url'])
 | 
      
        | 263 |  |  | 		)) {
 | 
      
        | 264 |  |  | 			exit(header("Location: ".WB_URL.PAGES_DIRECTORY.""));
 | 
      
        | 265 |  |  | 		}
 | 
      
        | 266 |  |  | 
 | 
      
        | 267 | 560 | Ruebenwurz | 		// Submit form data
 | 
      
        | 268 |  |  | 		// First start message settings
 | 
      
        | 269 |  |  | 		$query_settings = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_form_settings WHERE section_id = '$section_id'");
 | 
      
        | 270 |  |  | 		if($query_settings->numRows() > 0) {
 | 
      
        | 271 |  |  | 			$fetch_settings = $query_settings->fetchRow();
 | 
      
        | 272 |  |  | 			$email_to = $fetch_settings['email_to'];
 | 
      
        | 273 |  |  | 			$email_from = $fetch_settings['email_from'];
 | 
      
        | 274 |  |  | 			if(substr($email_from, 0, 5) == 'field') {
 | 
      
        | 275 |  |  | 				// Set the email from field to what the user entered in the specified field
 | 
      
        | 276 | 656 | thorn | 				$email_from = htmlspecialchars($wb->add_slashes($_POST[$email_from]));
 | 
      
        | 277 | 560 | Ruebenwurz | 			}
 | 
      
        | 278 | 638 | thorn | 			$email_fromname = $fetch_settings['email_fromname'];
 | 
      
        | 279 | 560 | Ruebenwurz | 			$email_subject = $fetch_settings['email_subject'];
 | 
      
        | 280 |  |  | 			$success_page = $fetch_settings['success_page'];
 | 
      
        | 281 |  |  | 			$success_email_to = $fetch_settings['success_email_to'];
 | 
      
        | 282 |  |  | 			if(substr($success_email_to, 0, 5) == 'field') {
 | 
      
        | 283 |  |  | 				// Set the success_email to field to what the user entered in the specified field
 | 
      
        | 284 | 656 | thorn | 				$success_email_to = htmlspecialchars($wb->add_slashes($_POST[$success_email_to]));
 | 
      
        | 285 | 560 | Ruebenwurz | 			}
 | 
      
        | 286 |  |  | 			$success_email_from = $fetch_settings['success_email_from'];
 | 
      
        | 287 | 638 | thorn | 			$success_email_fromname = $fetch_settings['success_email_fromname'];
 | 
      
        | 288 | 560 | Ruebenwurz | 			$success_email_text = $fetch_settings['success_email_text'];
 | 
      
        | 289 |  |  | 			$success_email_subject = $fetch_settings['success_email_subject'];
 | 
      
        | 290 |  |  | 			$max_submissions = $fetch_settings['max_submissions'];
 | 
      
        | 291 |  |  | 			$stored_submissions = $fetch_settings['stored_submissions'];
 | 
      
        | 292 |  |  | 			$use_captcha = $fetch_settings['use_captcha'];
 | 
      
        | 293 |  |  | 		} else {
 | 
      
        | 294 |  |  | 			exit($TEXT['UNDER_CONSTRUCTION']);
 | 
      
        | 295 |  |  | 		}
 | 
      
        | 296 |  |  | 		$email_body = '';
 | 
      
        | 297 |  |  | 
 | 
      
        | 298 |  |  | 		// Create blank "required" array
 | 
      
        | 299 |  |  | 		$required = array();
 | 
      
        | 300 |  |  | 
 | 
      
        | 301 | 618 | thorn | 		// Captcha
 | 
      
        | 302 |  |  | 		if($use_captcha) {
 | 
      
        | 303 |  |  | 			if(isset($_POST['captcha']) AND $_POST['captcha'] != ''){
 | 
      
        | 304 |  |  | 				// Check for a mismatch
 | 
      
        | 305 |  |  | 				if(!isset($_POST['captcha']) OR !isset($_SESSION['captcha']) OR $_POST['captcha'] != $_SESSION['captcha']) {
 | 
      
        | 306 |  |  | 					$captcha_error = $MESSAGE['MOD_FORM']['INCORRECT_CAPTCHA'];
 | 
      
        | 307 |  |  | 				}
 | 
      
        | 308 |  |  | 			} else {
 | 
      
        | 309 |  |  | 				$captcha_error = $MESSAGE['MOD_FORM']['INCORRECT_CAPTCHA'];
 | 
      
        | 310 |  |  | 			}
 | 
      
        | 311 |  |  | 		}
 | 
      
        | 312 |  |  | 		if(isset($_SESSION['captcha'])) { unset($_SESSION['captcha']); }
 | 
      
        | 313 |  |  | 
 | 
      
        | 314 | 560 | Ruebenwurz | 		// Loop through fields and add to message body
 | 
      
        | 315 |  |  | 		// Get list of fields
 | 
      
        | 316 |  |  | 		$query_fields = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_form_fields WHERE section_id = '$section_id' ORDER BY position ASC");
 | 
      
        | 317 |  |  | 		if($query_fields->numRows() > 0) {
 | 
      
        | 318 |  |  | 			while($field = $query_fields->fetchRow()) {
 | 
      
        | 319 |  |  | 				// Add to message body
 | 
      
        | 320 |  |  | 				if($field['type'] != '') {
 | 
      
        | 321 |  |  | 					if(!empty($_POST['field'.$field['field_id']])) {
 | 
      
        | 322 | 760 | Ruebenwurz | 						if (is_array($_POST['field'.$field['field_id']])) {
 | 
      
        | 323 |  |  | 							$_SESSION['field'.$field['field_id']] = $_POST['field'.$field['field_id']];
 | 
      
        | 324 |  |  | 						} else {
 | 
      
        | 325 |  |  | 							$_SESSION['field'.$field['field_id']] = htmlspecialchars($_POST['field'.$field['field_id']]);
 | 
      
        | 326 |  |  | 						}
 | 
      
        | 327 | 789 | doc | 						// if the output filter is active, we need to revert (dot) to . and (at) to @ (using current filter settings)
 | 
      
        | 328 |  |  | 						// otherwise the entered mail will not be accepted and the recipient would see (dot), (at) etc.
 | 
      
        | 329 |  |  | 						if ($filter_settings['email_filter']) {
 | 
      
        | 330 |  |  | 							$field_value = $_POST['field'.$field['field_id']];
 | 
      
        | 331 |  |  | 							$field_value = str_replace($filter_settings['at_replacement'], '@', $field_value);
 | 
      
        | 332 |  |  | 							$field_value = str_replace($filter_settings['dot_replacement'], '.', $field_value);
 | 
      
        | 333 |  |  | 							$_POST['field'.$field['field_id']] = $field_value;
 | 
      
        | 334 |  |  | 						}
 | 
      
        | 335 | 560 | Ruebenwurz | 						if($field['type'] == 'email' AND $admin->validate_email($_POST['field'.$field['field_id']]) == false) {
 | 
      
        | 336 |  |  | 							$email_error = $MESSAGE['USERS']['INVALID_EMAIL'];
 | 
      
        | 337 |  |  | 						}
 | 
      
        | 338 |  |  | 						if($field['type'] == 'heading') {
 | 
      
        | 339 |  |  | 							$email_body .= $_POST['field'.$field['field_id']]."\n\n";
 | 
      
        | 340 |  |  | 						} elseif (!is_array($_POST['field'.$field['field_id']])) {
 | 
      
        | 341 |  |  | 							$email_body .= $field['title'].': '.$_POST['field'.$field['field_id']]."\n\n";
 | 
      
        | 342 |  |  | 						} else {
 | 
      
        | 343 |  |  | 							$email_body .= $field['title'].": \n";
 | 
      
        | 344 |  |  | 							foreach ($_POST['field'.$field['field_id']] as $k=>$v) {
 | 
      
        | 345 |  |  | 								$email_body .= $v."\n";
 | 
      
        | 346 |  |  | 							}
 | 
      
        | 347 |  |  | 							$email_body .= "\n";
 | 
      
        | 348 |  |  | 						}
 | 
      
        | 349 |  |  | 					} elseif($field['required'] == 1) {
 | 
      
        | 350 |  |  | 						$required[] = $field['title'];
 | 
      
        | 351 |  |  | 					}
 | 
      
        | 352 |  |  | 				}
 | 
      
        | 353 |  |  | 			}
 | 
      
        | 354 |  |  | 		}
 | 
      
        | 355 | 760 | Ruebenwurz | 
 | 
      
        | 356 | 560 | Ruebenwurz | 		// Check if the user forgot to enter values into all the required fields
 | 
      
        | 357 |  |  | 		if($required != array()) {
 | 
      
        | 358 |  |  | 			if(!isset($MESSAGE['MOD_FORM']['REQUIRED_FIELDS'])) {
 | 
      
        | 359 |  |  | 				echo 'You must enter details for the following fields';
 | 
      
        | 360 |  |  | 			} else {
 | 
      
        | 361 |  |  | 				echo $MESSAGE['MOD_FORM']['REQUIRED_FIELDS'];
 | 
      
        | 362 |  |  | 			}
 | 
      
        | 363 |  |  | 			echo ':<br /><ul>';
 | 
      
        | 364 |  |  | 			foreach($required AS $field_title) {
 | 
      
        | 365 |  |  | 				echo '<li>'.$field_title;
 | 
      
        | 366 |  |  | 			}
 | 
      
        | 367 | 760 | Ruebenwurz | 			if(isset($email_error)) {
 | 
      
        | 368 |  |  | 				echo '<li>'.$email_error.'</li>';
 | 
      
        | 369 |  |  | 			}
 | 
      
        | 370 |  |  | 			if(isset($captcha_error)) {
 | 
      
        | 371 |  |  | 				echo '<li>'.$captcha_error.'</li>';
 | 
      
        | 372 |  |  | 			}
 | 
      
        | 373 |  |  | 			echo '</ul><a href="'.htmlspecialchars(strip_tags($_SERVER['PHP_SELF'])).'">'.$TEXT['BACK'].'</a>';
 | 
      
        | 374 | 560 | Ruebenwurz | 		} else {
 | 
      
        | 375 |  |  | 			if(isset($email_error)) {
 | 
      
        | 376 |  |  | 				echo '<br /><ul>';
 | 
      
        | 377 |  |  | 				echo '<li>'.$email_error.'</li>';
 | 
      
        | 378 | 760 | Ruebenwurz | 				echo '</ul><a href="'.htmlspecialchars(strip_tags($_SERVER['PHP_SELF'])).'">'.$TEXT['BACK'].'</a>';
 | 
      
        | 379 | 560 | Ruebenwurz | 			} elseif(isset($captcha_error)) {
 | 
      
        | 380 |  |  | 				echo '<br /><ul>';
 | 
      
        | 381 |  |  | 				echo '<li>'.$captcha_error.'</li>';
 | 
      
        | 382 | 760 | Ruebenwurz | 				echo '</ul><a href="'.htmlspecialchars(strip_tags($_SERVER['PHP_SELF'])).'">'.$TEXT['BACK'].'</a>';
 | 
      
        | 383 | 560 | Ruebenwurz | 			} else {
 | 
      
        | 384 |  |  | 				// Check how many times form has been submitted in last hour
 | 
      
        | 385 |  |  | 				$last_hour = time()-3600;
 | 
      
        | 386 |  |  | 				$query_submissions = $database->query("SELECT submission_id FROM ".TABLE_PREFIX."mod_form_submissions WHERE submitted_when >= '$last_hour'");
 | 
      
        | 387 |  |  | 				if($query_submissions->numRows() > $max_submissions) {
 | 
      
        | 388 |  |  | 					// Too many submissions so far this hour
 | 
      
        | 389 |  |  | 					echo $MESSAGE['MOD_FORM']['EXCESS_SUBMISSIONS'];
 | 
      
        | 390 |  |  | 					$success = false;
 | 
      
        | 391 |  |  | 				} else {
 | 
      
        | 392 |  |  | 					// Now send the email
 | 
      
        | 393 |  |  | 					if($email_to != '') {
 | 
      
        | 394 |  |  | 						if($email_from != '') {
 | 
      
        | 395 | 638 | thorn | 							if($wb->mail($email_from,$email_to,$email_subject,$email_body,$email_fromname)) {
 | 
      
        | 396 | 560 | Ruebenwurz | 								$success = true;
 | 
      
        | 397 |  |  | 							}
 | 
      
        | 398 |  |  | 						} else {
 | 
      
        | 399 | 638 | thorn | 							if($wb->mail('',$email_to,$email_subject,$email_body,$email_fromname)) {
 | 
      
        | 400 | 560 | Ruebenwurz | 								$success = true;
 | 
      
        | 401 |  |  | 							}
 | 
      
        | 402 |  |  | 						}
 | 
      
        | 403 |  |  | 					}
 | 
      
        | 404 |  |  | 					if($success_email_to != '') {
 | 
      
        | 405 |  |  | 						if($success_email_from != '') {
 | 
      
        | 406 | 638 | thorn | 							if($wb->mail($success_email_from,$success_email_to,$success_email_subject,$success_email_text,$success_email_fromname)) {
 | 
      
        | 407 | 560 | Ruebenwurz | 								$success = true;
 | 
      
        | 408 |  |  | 							}
 | 
      
        | 409 |  |  | 						} else {
 | 
      
        | 410 | 638 | thorn | 							if($wb->mail('',$success_email_to,$success_email_subject,$success_email_text,$success_email_fromname)) {
 | 
      
        | 411 | 560 | Ruebenwurz | 								$success = true;
 | 
      
        | 412 |  |  | 							}
 | 
      
        | 413 |  |  | 						}
 | 
      
        | 414 |  |  | 					}
 | 
      
        | 415 |  |  | 
 | 
      
        | 416 |  |  | 					// Write submission to database
 | 
      
        | 417 | 596 | thorn | 					if(isset($admin) AND $admin->is_authenticated() AND $admin->get_user_id() > 0) {
 | 
      
        | 418 |  |  | 						$submitted_by = $admin->get_user_id();
 | 
      
        | 419 | 560 | Ruebenwurz | 					} else {
 | 
      
        | 420 |  |  | 						$submitted_by = 0;
 | 
      
        | 421 |  |  | 					}
 | 
      
        | 422 |  |  | 					$email_body = $wb->add_slashes($email_body);
 | 
      
        | 423 |  |  | 					$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')");
 | 
      
        | 424 |  |  | 					// Make sure submissions table isn't too full
 | 
      
        | 425 |  |  | 					$query_submissions = $database->query("SELECT submission_id FROM ".TABLE_PREFIX."mod_form_submissions ORDER BY submitted_when");
 | 
      
        | 426 |  |  | 					$num_submissions = $query_submissions->numRows();
 | 
      
        | 427 |  |  | 					if($num_submissions > $stored_submissions) {
 | 
      
        | 428 |  |  | 						// Remove excess submission
 | 
      
        | 429 |  |  | 						$num_to_remove = $num_submissions-$stored_submissions;
 | 
      
        | 430 |  |  | 						while($submission = $query_submissions->fetchRow()) {
 | 
      
        | 431 |  |  | 							if($num_to_remove > 0) {
 | 
      
        | 432 |  |  | 								$submission_id = $submission['submission_id'];
 | 
      
        | 433 |  |  | 								$database->query("DELETE FROM ".TABLE_PREFIX."mod_form_submissions WHERE submission_id = '$submission_id'");
 | 
      
        | 434 |  |  | 								$num_to_remove = $num_to_remove-1;
 | 
      
        | 435 |  |  | 							}
 | 
      
        | 436 |  |  | 						}
 | 
      
        | 437 |  |  | 					}
 | 
      
        | 438 |  |  | 					if(!$database->is_error()) {
 | 
      
        | 439 |  |  | 						$success = true;
 | 
      
        | 440 |  |  | 					}
 | 
      
        | 441 |  |  | 				}
 | 
      
        | 442 |  |  | 			}
 | 
      
        | 443 |  |  | 		}
 | 
      
        | 444 |  |  | 	}
 | 
      
        | 445 |  |  | 
 | 
      
        | 446 |  |  | 	// Now check if the email was sent successfully
 | 
      
        | 447 |  |  | 	if(isset($success) AND $success == true) {
 | 
      
        | 448 | 760 | Ruebenwurz | 	   if ($success_page=='none') {
 | 
      
        | 449 | 560 | Ruebenwurz | 			echo str_replace("\n","<br />",$success_email_text);
 | 
      
        | 450 |  |  |   		} else {
 | 
      
        | 451 |  |  | 			$query_menu = $database->query("SELECT link,target FROM ".TABLE_PREFIX."pages WHERE `page_id` = '$success_page'");
 | 
      
        | 452 |  |  | 			if($query_menu->numRows() > 0) {
 | 
      
        | 453 | 760 | Ruebenwurz |   	        	$fetch_settings = $query_menu->fetchRow();
 | 
      
        | 454 |  |  | 			   $link = WB_URL.PAGES_DIRECTORY.$fetch_settings['link'].PAGE_EXTENSION;
 | 
      
        | 455 |  |  | 			   echo "<script type='text/javascript'>location.href='".$link."';</script>";
 | 
      
        | 456 | 560 | Ruebenwurz | 			}
 | 
      
        | 457 |  |  | 		}
 | 
      
        | 458 | 760 | Ruebenwurz | 		// clearing session on success
 | 
      
        | 459 |  |  | 		$query_fields = $database->query("SELECT field_id FROM ".TABLE_PREFIX."mod_form_fields WHERE section_id = '$section_id' AND required = 1");
 | 
      
        | 460 |  |  | 		while($field = $query_fields->fetchRow()) {
 | 
      
        | 461 |  |  | 			$field_id = $field[0];
 | 
      
        | 462 |  |  | 			if(isset($_SESSION['field'.$field_id])) unset($_SESSION['field'.$field_id]);
 | 
      
        | 463 |  |  | 		}
 | 
      
        | 464 | 560 | Ruebenwurz | 	} else {
 | 
      
        | 465 | 760 | Ruebenwurz | 		if(isset($success) AND $success == false) {
 | 
      
        | 466 |  |  | 			echo $TEXT['ERROR'];
 | 
      
        | 467 |  |  | 		}
 | 
      
        | 468 |  |  | 	}
 | 
      
        | 469 | 560 | Ruebenwurz | }
 | 
      
        | 470 |  |  | 
 | 
      
        | 471 | 760 | Ruebenwurz | ?>
 |