[ Index ] |
PHP Cross Reference of phpwcms V1.4.7 _r403 (01.11.10) |
[Summary view] [Print] [Text view]
1 <?php 2 /************************************************************************************* 3 Copyright notice 4 5 (c) 2002-2010 Oliver Georgi (oliver@phpwcms.de) // All rights reserved. 6 7 This script is part of PHPWCMS. The PHPWCMS web content management system is 8 free software; you can redistribute it and/or modify it under the terms of 9 the GNU General Public License as published by the Free Software Foundation; 10 either version 2 of the License, or (at your option) any later version. 11 12 The GNU General Public License can be found at http://www.gnu.org/copyleft/gpl.html 13 A copy is found in the textfile GPL.txt and important notices to the license 14 from the author is found in LICENSE.txt distributed with these scripts. 15 16 This script is distributed in the hope that it will be useful, but WITHOUT ANY 17 WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A 18 PARTICULAR PURPOSE. See the GNU General Public License for more details. 19 20 This copyright notice MUST APPEAR in all copies of the script! 21 *************************************************************************************/ 22 23 // ---------------------------------------------------------------- 24 // obligate check for phpwcms constants 25 if (!defined('PHPWCMS_ROOT')) { 26 die("You Cannot Access This Script Directly, Have a Nice Day."); 27 } 28 // ---------------------------------------------------------------- 29 30 31 // try 32 33 if(isset($_GET['edit'])) { 34 $plugin['id'] = intval($_GET['edit']); 35 } else { 36 $plugin['id'] = 0; 37 } 38 39 40 // process post form 41 if(isset($_POST['adcampaign_title'])) { 42 43 $plugin['data'] = array( 44 45 'adcampaign_id' => intval($_POST['adcampaign_id']), 46 'adcampaign_title' => clean_slweg($_POST['adcampaign_title']), 47 'adcampaign_created' => date('Y-m-d H:i:s'), 48 'adcampaign_changed' => date('Y-m-d H:i:s'), 49 'adcampaign_comment' => clean_slweg($_POST['adcampaign_comment']), 50 'adcampaign_data' => array( 51 52 'width' => intval($_POST['adcampaign_width']), 53 'height' => intval($_POST['adcampaign_height']), 54 'unique' => empty($_POST['adcampaign_unique']) ? 0 : 1, 55 'url' => clean_slweg($_POST['adcampaign_url']), 56 'target' => clean_slweg($_POST['adcampaign_target']), 57 'image' => isset($_POST['adcampaign_image']) ? clean_slweg($_POST['adcampaign_image']) : '', 58 'flash' => isset($_POST['adcampaign_flash']) ? clean_slweg($_POST['adcampaign_flash']) : '', 59 'html' => slweg($_POST['adcampaign_html']), 60 'alt_text' => clean_slweg($_POST['adcampaign_alt_text']), 61 'title_text' => clean_slweg($_POST['adcampaign_title_text']), 62 'css' => isset($_POST['adcampaign_css']) ? clean_slweg($_POST['adcampaign_css']) : '', 63 'bgcolor' => clean_slweg($_POST['adcampaign_bgcolor']), 64 'bordercolor' => clean_slweg($_POST['adcampaign_bordercolor']), 65 'flashversion' => clean_slweg($_POST['adcampaign_flashversion']) 66 67 ), 68 'adcampaign_status' => empty($_POST['adcampaign_status']) ? 0 : 1, 69 'adcampaign_date_start' => clean_slweg($_POST['adcampaign_date_start']), 70 'adcampaign_date_end' => clean_slweg($_POST['adcampaign_date_end']), 71 'adcampaign_time_start' => clean_slweg($_POST['adcampaign_time_start']), 72 'adcampaign_time_end' => clean_slweg($_POST['adcampaign_time_end']), 73 'adcampaign_type' => empty($_POST['adcampaign_type']) ? 0 : intval($_POST['adcampaign_type']), 74 'adcampaign_place' => intval($_POST['adcampaign_place']), 75 'adcampaign_maxview' => intval($_POST['adcampaign_max_views']), 76 'adcampaign_maxclick' => intval($_POST['adcampaign_max_click']), 77 'adcampaign_maxviewuser'=> intval($_POST['adcampaign_max_viewuser']), 78 79 'adcampaign_duplicate' => empty($_POST['adcampaign_duplicate']) ? 0 : 1 80 ); 81 82 if(empty($plugin['data']['adcampaign_data']['flashversion'])) { 83 $plugin['data']['adcampaign_data']['flashversion'] = '7'; 84 } 85 86 if($plugin['data']['adcampaign_type'] > 4) $plugin['data']['adcampaign_type'] = 0; 87 88 // clean up date/time 89 include_once($phpwcms['modules'][$module]['path'].'inc/processing.datetime.inc.php'); 90 91 if(empty($plugin['data']['adcampaign_title'])) { 92 93 $plugin['error']['adcampaign_title'] = 1; 94 95 } 96 97 // handle media upload 98 if($plugin['data']['adcampaign_id'] && !empty($_FILES['adcampaign_upload_image']['name'])) { 99 100 // image upload 101 $plugin['data']['upload'] = saveUploadedFile('adcampaign_upload_image', PHPWCMS_CONTENT.'ads/'.$plugin['data']['adcampaign_id'].'/', '', '1,2,3', '1,4'); 102 if($plugin['data']['upload']['status']) { 103 $plugin['data']['adcampaign_data']['image'] = $plugin['data']['upload']['rename']; 104 unset($_POST['save']); 105 } else { 106 $plugin['error']['image'] = $plugin['data']['upload']['error']; 107 } 108 109 } 110 if($plugin['data']['adcampaign_id'] && !empty($_FILES['adcampaign_upload_flash']['name'])) { 111 112 // flash upload 113 $plugin['data']['upload'] = saveUploadedFile('adcampaign_upload_flash', PHPWCMS_CONTENT.'ads/'.$plugin['data']['adcampaign_id'].'/', 'swf', '', '1,4'); 114 if($plugin['data']['upload']['status']) { 115 $plugin['data']['adcampaign_data']['flash'] = $plugin['data']['upload']['rename']; 116 unset($_POST['save']); 117 } else { 118 $plugin['error']['flash'] = $plugin['data']['upload']['error']; 119 } 120 121 } 122 if($plugin['data']['adcampaign_id'] && !empty($_FILES['adcampaign_upload_css']['name'])) { 123 124 // css upload 125 $plugin['data']['upload'] = saveUploadedFile('adcampaign_upload_css', PHPWCMS_CONTENT.'ads/'.$plugin['data']['adcampaign_id'].'/', 'css', '', '1,4'); 126 if($plugin['data']['upload']['status']) { 127 $plugin['data']['adcampaign_data']['css'] = $plugin['data']['upload']['rename']; 128 unset($_POST['save']); 129 } else { 130 $plugin['error']['css'] = $plugin['data']['upload']['error']; 131 } 132 133 } 134 135 if(!isset($plugin['error'])) { 136 137 if($plugin['data']['adcampaign_duplicate']) { 138 $plugin['data']['adcampaign_id'] = 0; 139 } 140 141 if($plugin['data']['adcampaign_id']) { 142 143 // UPDATE 144 $sql = 'UPDATE '.DB_PREPEND.'phpwcms_ads_campaign SET '; 145 146 $sql .= "adcampaign_changed='". aporeplace($plugin['data']['adcampaign_changed'])."', "; 147 $sql .= "adcampaign_status=". $plugin['data']['adcampaign_status'].", "; 148 $sql .= "adcampaign_title='". aporeplace($plugin['data']['adcampaign_title'])."', "; 149 $sql .= "adcampaign_comment='". aporeplace($plugin['data']['adcampaign_comment'])."', "; 150 $sql .= "adcampaign_datestart='". aporeplace($plugin['data']['adcampaign_datestart'])."', "; 151 $sql .= "adcampaign_dateend='". aporeplace($plugin['data']['adcampaign_dateend'])."', "; 152 $sql .= "adcampaign_maxview=". $plugin['data']['adcampaign_maxview'].", "; 153 $sql .= "adcampaign_maxclick=". $plugin['data']['adcampaign_maxclick'].", "; 154 $sql .= "adcampaign_maxviewuser=". $plugin['data']['adcampaign_maxviewuser'].", "; 155 $sql .= "adcampaign_type=". $plugin['data']['adcampaign_type'].", "; 156 $sql .= "adcampaign_place=". $plugin['data']['adcampaign_place'].", "; 157 $sql .= "adcampaign_data='". aporeplace(serialize($plugin['data']['adcampaign_data']))."' "; 158 159 $sql .= "WHERE adcampaign_id=".$plugin['data']['adcampaign_id']; 160 161 if(@_dbQuery($sql, 'UPDATE')) { 162 163 if(isset($_POST['save'])) { 164 165 headerRedirect(decode_entities(MODULE_HREF).'&listcampaign=1'); 166 167 } 168 169 } else { 170 171 $plugin['error']['update'] = mysql_error(); 172 173 } 174 175 176 } else { 177 178 // INSERT 179 $sql = 'INSERT INTO '.DB_PREPEND.'phpwcms_ads_campaign ('; 180 181 $sql .= " adcampaign_created, adcampaign_changed, adcampaign_status, adcampaign_title, "; 182 $sql .= " adcampaign_comment, adcampaign_datestart, adcampaign_dateend, "; 183 $sql .= " adcampaign_maxview, adcampaign_maxclick, adcampaign_maxviewuser, "; 184 $sql .= " adcampaign_type, adcampaign_place, adcampaign_data"; 185 186 $sql .= ') VALUES ('; 187 188 $sql .= " '". aporeplace($plugin['data']['adcampaign_created'])."', "; 189 $sql .= " '". aporeplace($plugin['data']['adcampaign_changed'])."', "; 190 $sql .= $plugin['data']['adcampaign_status'].", "; 191 $sql .= " '". aporeplace($plugin['data']['adcampaign_title'])."', "; 192 $sql .= " '". aporeplace($plugin['data']['adcampaign_comment'])."', "; 193 $sql .= " '". aporeplace($plugin['data']['adcampaign_datestart'])."', "; 194 $sql .= " '". aporeplace($plugin['data']['adcampaign_dateend'])."', "; 195 $sql .= $plugin['data']['adcampaign_maxview'].", "; 196 $sql .= $plugin['data']['adcampaign_maxclick'].", "; 197 $sql .= $plugin['data']['adcampaign_maxviewuser'].", "; 198 $sql .= $plugin['data']['adcampaign_type'].", "; 199 $sql .= $plugin['data']['adcampaign_place'].", "; 200 $sql .= " '". aporeplace(serialize($plugin['data']['adcampaign_data']))."'"; 201 202 $sql .= ')'; 203 204 if($plugin_new_id = @_dbQuery($sql, 'INSERT')) { 205 206 if(isset($_POST['save'])) { 207 208 headerRedirect(decode_entities(MODULE_HREF).'&listcampaign=1'); 209 210 } elseif(!empty($plugin_new_id['INSERT_ID'])) { 211 212 headerRedirect(decode_entities(MODULE_HREF).'&campaign=1&edit='.$plugin_new_id['INSERT_ID']); 213 214 } 215 216 } else { 217 218 $plugin['error']['update'] = mysql_error(); 219 220 } 221 222 223 } 224 } 225 226 } 227 228 // try to read entry from database 229 if($plugin['id'] && !isset($plugin['error'])) { 230 231 $sql = 'SELECT *,'; 232 $sql .= "DATE_FORMAT(adcampaign_datestart, '%d".$BLM['date_delimiter']."%m".$BLM['date_delimiter']."%Y') AS adcampaign_date_start, "; 233 $sql .= "DATE_FORMAT(adcampaign_dateend, '%d".$BLM['date_delimiter']."%m".$BLM['date_delimiter']."%Y') AS adcampaign_date_end, "; 234 $sql .= "DATE_FORMAT(adcampaign_datestart, '%H:%i') AS adcampaign_time_start, "; 235 $sql .= "DATE_FORMAT(adcampaign_dateend, '%H:%i') AS adcampaign_time_end "; 236 $sql .= 'FROM '.DB_PREPEND.'phpwcms_ads_campaign WHERE adcampaign_id='.$plugin['id']; 237 $plugin['data'] = _dbQuery($sql); 238 $plugin['data'] = $plugin['data'][0]; 239 $plugin['data']['adcampaign_data'] = @unserialize($plugin['data']['adcampaign_data']); 240 if(!is_array($plugin['data']['adcampaign_data'])) { 241 $plugin['data']['adcampaign_data'] = array( 242 243 'unique' => 0, 244 'width' => '', 245 'height' => '', 246 'url' => '', 247 'target' => '_blank', 248 'image' => '', 249 'flash' => '', 250 'html' => '', 251 'alt_text' => '', 252 'title_text' => '', 253 'css' => '', 254 'bgcolor' => '', 255 'bordercolor' => '', 256 'flashversion' => '7' 257 258 ); 259 } 260 261 } 262 263 // default values 264 if(empty($plugin['data'])) { 265 266 $plugin['data'] = array( 267 268 'adcampaign_id' => 0, 269 'adcampaign_title' => '', 270 'adcampaign_created' => '', 271 'adcampaign_changed' => date('Y-m-d H:i:s'), 272 'adcampaign_comment' => '', 273 'adcampaign_data' => array( 274 275 'unique' => 0, 276 'width' => '', 277 'height' => '', 278 'url' => '', 279 'target' => '_blank', 280 'image' => '', 281 'flash' => '', 282 'html' => '', 283 'alt_text' => '', 284 'title_text' => '', 285 'css' => '', 286 'bgcolor' => '', 287 'bordercolor' => '', 288 'flashversion' => '7' 289 290 ), 291 'adcampaign_status' => 0, 292 'adcampaign_date_start' => '', 293 'adcampaign_date_end' => '', 294 'adcampaign_time_start' => '00:00', 295 'adcampaign_time_end' => '23:59', 296 'adcampaign_place' => 0, 297 'adcampaign_type' => 0, 298 'adcampaign_maxview' => 0, 299 'adcampaign_maxclick' => 0, 300 'adcampaign_maxviewuser'=> 0 301 302 ); 303 304 } 305 306 307 ?>
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
Generated: Tue Nov 16 22:51:00 2010 | Cross-referenced by PHPXref 0.7 |