[ Index ] |
PHP Cross Reference of phpwcms V1.5.0 _r431 (28.01.12) |
[Summary view] [Print] [Text view]
1 <?php 2 /************************************************************************************* 3 Copyright notice 4 5 (c) 2002-2012 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 // ---------------------------------------------------------------- 25 // obligate check for phpwcms constants 26 if (!defined('PHPWCMS_ROOT')) { 27 die("You Cannot Access This Script Directly, Have a Nice Day."); 28 } 29 // ---------------------------------------------------------------- 30 31 32 if( (isset($_GET["s"]) && intval($_GET["s"]) == 1) || isset($_GET['struct']) ) { //Show single article information 33 34 //Artikel editieren 35 $article = array(); 36 $article["article_id"] = empty($_GET["id"]) ? 0 : intval($_GET["id"]); 37 $article["article_timeout"] = ''; 38 $article['article_nosearch'] = ''; 39 $article['article_nositemap'] = 1; 40 $article['article_morelink'] = 1; 41 $article["article_cntpart"] = array(); 42 43 // check if in POST mode (form submitted) and NOT add new article 44 if((!isset($_POST["article_update"]) || !intval($_POST["article_update"])) && !isset($_GET['struct'])) { 45 $read_done = false; 46 $sql = "SELECT DISTINCT *, date_format(article_tstamp, '%Y-%m-%d %H:%i:%s') AS article_date ". 47 "FROM ".DB_PREPEND."phpwcms_article LEFT JOIN ".DB_PREPEND."phpwcms_articlecat ON ". 48 DB_PREPEND."phpwcms_article.article_cid=".DB_PREPEND."phpwcms_articlecat.acat_id WHERE ". 49 DB_PREPEND."phpwcms_article.article_id='".$article["article_id"]."' LIMIT 1"; 50 if($result = mysql_query($sql, $db) or die("error getting info about article")) { 51 if($row = mysql_fetch_assoc($result)) { 52 $article["article_id"] = $row["article_id"]; 53 $article["article_title"] = $row["article_title"]; 54 $article["article_alias"] = $row["article_alias"]; 55 $article["article_notitle"] = $row["article_notitle"]; 56 $article["article_hidesummary"] = $row["article_hidesummary"]; 57 $article["article_subtitle"] = $row["article_subtitle"]; 58 $article["article_summary"] = $row["article_summary"]; 59 $article["article_public"] = $row["article_public"]; 60 $article["article_aktiv"] = $row["article_aktiv"]; 61 $article["article_date"] = $row["article_date"]; 62 $article["article_begin"] = $row["article_begin"]; 63 $article["article_end"] = $row["article_end"]; 64 $article["article_redirect"] = $row["article_redirect"]; 65 $article["article_username"] = $row["article_username"]; 66 $article["article_uid"] = $row["article_uid"]; 67 if($row["acat_id"]) { 68 $article["article_cat"] = $row["acat_name"].' [ID:'.$row["acat_id"].']'; 69 $article["article_catid"] = $row["acat_id"]; 70 $article["template_id"] = $row['acat_template']; 71 $article["article_cntpart"] = isset($row['acat_cntpart']) ? explode(',', $row['acat_cntpart']) : false; 72 $article['article_cpdefault'] = empty($row['acat_cpdefault']) ? 0 : intval($row['acat_cpdefault']); 73 } else { 74 $article["article_cat"] = $indexpage['acat_name'].' [ID:0]'; //"index (website start)"; 75 $article["article_catid"] = 0; 76 $article["template_id"] = $indexpage['acat_template']; 77 $article["article_cntpart"] = isset($indexpage['acat_cntpart']) ? explode(',', $indexpage['acat_cntpart']) : false; 78 $article['article_cpdefault'] = empty($indexpage['acat_cpdefault']) ? 0 : intval($indexpage['acat_cpdefault']); 79 } 80 $article["article_keyword"] = $row["article_keyword"]; 81 $article["image"] = unserialize($row["article_image"]); 82 $article["article_timeout"] = $row["article_cache"]; 83 $article['article_nosearch'] = $row['article_nosearch']; 84 $article['article_nositemap'] = $row['article_nositemap']; 85 $set_begin = ($article["article_begin"]) ? 1 : 0; 86 $set_end = ($article["article_end"]) ? 1 : 0; 87 88 $article['article_aliasid'] = $row['article_aliasid']; 89 $article['article_headerdata'] = $row['article_headerdata']; 90 $article['article_morelink'] = $row['article_morelink']; 91 $article['article_pagetitle'] = $row['article_pagetitle']; 92 $article['article_paginate'] = $row['article_paginate']; 93 $article['article_sort'] = $row['article_sort']; 94 $article['article_priorize'] = $row['article_priorize']; 95 $article['article_created'] = $row['article_created']; 96 $article['article_norss'] = $row['article_norss']; 97 $article['article_menutitle'] = $row['article_menutitle']; 98 $article['article_description'] = $row['article_description']; 99 100 $article['article_archive_status'] = $row['article_archive_status']; 101 102 $read_done = true; 103 } 104 mysql_free_result($result); 105 } 106 if(!$read_done) { 107 headerRedirect(PHPWCMS_URL."phpwcms.php?do=articles&p=2"); 108 } 109 110 111 // add new article inside structure 112 } elseif( isset($_GET['struct']) ) { 113 114 // define defaults 115 $article["article_id"] = 0; 116 $article["article_catid"] = intval($_GET['struct']); 117 $article["article_title"] = ''; 118 $article["article_alias"] = ''; 119 $article["article_subtitle"] = ''; 120 $article["article_menutitle"] = ''; 121 $article["article_description"] = ''; 122 $article["article_summary"] = ''; 123 $article["article_public"] = 1; 124 $article["article_notitle"] = 0; 125 $article["article_hidesummary"] = 0; 126 $article["article_aktiv"] = 0; 127 $article["article_begin"] = ''; 128 $article["article_end"] = ''; 129 $article["article_keyword"] = ''; 130 $article["article_redirect"] = ''; 131 $article['article_aliasid'] = ''; 132 $article['article_headerdata'] = 0; 133 $article['article_morelink'] = 1; 134 $article["article_pagetitle"] = ''; 135 $article['article_paginate'] = 0; 136 $article['article_sort'] = 0; 137 $article['article_priorize'] = 0; 138 $article['article_norss'] = 1; 139 $article['article_archive_status'] = 1; 140 $article["article_timeout"] = ''; 141 $article['article_nosearch'] = ''; 142 $article['article_nositemap'] = 1; 143 $article["article_uid"] = $_SESSION["wcs_user_id"]; 144 $article["article_username"] = $_SESSION["wcs_user_name"]; 145 146 $article['image'] = array(); 147 $article['image']['tmpllist'] = 'default'; 148 $article['image']['tmplfull'] = 'default'; 149 $article['image']['name'] = ''; 150 $article['image']['id'] = ''; 151 $article['image']['caption'] = ''; 152 $article["image"]["hash"] = ''; 153 $article['image']['list_usesummary'] = 0; 154 $article['image']['list_name'] = ''; 155 $article['image']['list_id'] = 0; 156 $article['image']['list_width'] = ''; 157 $article['image']['list_height'] = ''; 158 $article['image']['list_zoom'] = 0; 159 $article['image']['list_caption'] = ''; 160 $article["image"]["list_hash"] = ''; 161 $article['image']['zoom'] = 0; 162 163 $set_begin = 0; 164 $set_end = 0; 165 166 } else { 167 168 // Take article Post data 169 170 $article_err = array(); 171 172 $article["article_catid"] = intval($_POST["article_cid"]); 173 $article["article_title"] = clean_slweg($_POST["article_title"], 255); 174 175 $article["article_alias"] = proof_alias($article["article_id"], $_POST["article_alias"], 'ARTICLE'); 176 177 $article["article_subtitle"] = clean_slweg($_POST["article_subtitle"], 255); 178 $article["article_menutitle"] = clean_slweg($_POST["article_menutitle"], 255); 179 $article["article_description"] = clean_slweg($_POST["article_description"], 255); 180 $article["article_summary"] = str_replace('<p></p>', '<p> </p>', slweg($_POST["article_summary"]) ); 181 $article["article_public"] = isset($_POST["article_public"]) ? 1 : 0; 182 $article["article_notitle"] = isset($_POST["article_notitle"]) ? 1 : 0; 183 $article["article_hidesummary"] = isset($_POST["article_hidesummary"]) ? 1 : 0; 184 $article["article_aktiv"] = isset($_POST["article_aktiv"]) ? 1 : 0; 185 $article["article_begin"] = clean_slweg($_POST["article_begin"]); 186 $article["article_end"] = clean_slweg($_POST["article_end"]); 187 $article["article_keyword"] = clean_slweg($_POST["article_keyword"]); 188 189 $article["article_keyword"] = implode(', ', convertStringToArray( trim($article["article_keyword"], ',') , ',') ); 190 191 $article["article_redirect"] = clean_slweg($_POST["article_redirect"]); 192 $set_begin = isset($_POST["set_begin"]) ? 1 : 0; 193 $set_end = isset($_POST["set_end"]) ? 1 : 0; 194 $article['article_nosearch'] = isset($_POST['article_nosearch']) ? 1 : ''; 195 $article['article_nositemap'] = isset($_POST['article_nositemap']) ? 1 : 0; 196 197 $article['article_aliasid'] = intval($_POST["article_aliasid"]); 198 $article['article_headerdata'] = isset($_POST["article_headerdata"]) ? 1 : 0; 199 $article['article_morelink'] = isset($_POST["article_morelink"]) ? 1 : 0; 200 $article["article_pagetitle"] = clean_slweg($_POST["article_pagetitle"]); 201 $article['article_paginate'] = isset($_POST["article_paginate"]) ? 1 : 0; 202 $article['article_sort'] = empty($_POST["article_sort"]) ? 0 : intval($_POST["article_sort"]); 203 $article['article_priorize'] = empty($_POST["article_priorize"]) ? 0 : intval($_POST["article_priorize"]); 204 $article['article_norss'] = empty($_POST["article_norss"]) ? 0 : 1; 205 $article['article_archive_status'] = empty($_POST["article_archive"]) ? 0 : 1; 206 207 $article["article_timeout"] = clean_slweg($_POST["article_timeout"]); 208 if(isset($_POST['article_cacheoff']) && intval($_POST['article_cacheoff'])) $article["article_timeout"] = '0'; //check if cache = Off 209 210 if($_SESSION["wcs_user_admin"]) { 211 $article["article_uid"] = isset($_POST["article_uid"]) ? intval($_POST["article_uid"]) : $_SESSION["wcs_user_id"]; 212 } 213 if(empty($article["article_uid"])) { 214 $article["article_uid"] = $_SESSION["wcs_user_id"]; 215 } 216 217 $article["article_username"] = clean_slweg($_POST["article_username"],100); 218 if(!$article["article_username"]) $article["article_username"] = $_SESSION["wcs_user_name"]; 219 220 if(isEmpty($article["article_title"])) { 221 $article_err[] = $BL['be_article_err1']; 222 } 223 if($article["article_begin"]) { //Check date 224 $article["article_begin"] = phpwcms_strtotime($article["article_begin"]); 225 if($article["article_begin"] == false) { 226 $article["article_begin"] = date("Y-m-d H:i:s"); 227 $set_begin = 1; 228 $article_err[] = $BL['be_article_err2']; 229 } else { 230 $article["article_begin"] = date("Y-m-d H:i:s", $article["article_begin"]); 231 $set_begin = 1; 232 } 233 } else { 234 $article["article_begin"] = date("Y-m-d H:i:s"); 235 $set_begin = 0; 236 } 237 if($article["article_end"]) { //Check date 238 $article["article_end"] = phpwcms_strtotime($article["article_end"]); 239 if($article["article_end"] == false) { 240 $article["article_end"] = date("Y-m-d H:i:s", time() + (3600*24*365*10) ); 241 $set_end = 1; 242 $article_err[] = $BL['be_article_err4']; 243 } else { 244 $article["article_end"] = date("Y-m-d H:i:s", $article["article_end"]); 245 $set_end = 1; 246 } 247 } else { 248 $article["article_end"] = date("Y-m-d H:i:s", time() + (3600*24*365*10) ); 249 $set_end = 0; 250 } //Ende Check Date 251 252 $article['image'] = array(); 253 $article['image']['tmpllist'] = slweg($_POST["article_tmpllist"]); 254 $article['image']['tmplfull'] = slweg($_POST["article_tmplfull"]); 255 256 // get summary image info for article detail 257 $article['image']['name'] = clean_slweg($_POST["cimage_name"]); 258 $article['image']['id'] = intval($_POST["cimage_id"]); 259 $article['image']['width'] = (intval($_POST["cimage_width"])) ? intval($_POST["cimage_width"]) : ''; 260 $article['image']['height'] = (intval($_POST["cimage_height"])) ? intval($_POST["cimage_height"]) : ''; 261 $article['image']['caption'] = clean_slweg($_POST["cimage_caption"]); 262 $article['image']['zoom'] = empty($_POST["cimage_zoom"]) ? 0 : 1; 263 $article['image']['lightbox'] = empty($_POST["cimage_lightbox"]) ? 0 : 1; 264 265 if ($article['image']['width'] > $phpwcms["content_width"] || $article['image']['width'] == '') { 266 $article['image']['width'] = $phpwcms["content_width"]; 267 } 268 269 if ($article['image']['id']) { 270 // check for image information and get alle infos from file 271 $img_sql = "SELECT * FROM " . DB_PREPEND . "phpwcms_file WHERE f_id="; 272 $img_sql .= $article['image']['id']." LIMIT 1"; 273 274 if ($img_result = mysql_query($img_sql, $db) or die("error while getting content image info")) { 275 if ($img_row = mysql_fetch_assoc($img_result)) { 276 277 $article['image']['id'] = $img_row['f_id']; 278 $article['image']['name'] = $img_row['f_name']; 279 $article['image']['hash'] = $img_row['f_hash']; 280 $article['image']['ext'] = $img_row['f_ext']; 281 282 } 283 mysql_free_result($img_result); 284 } 285 } 286 287 // get list image for article 288 $article['image']['list_usesummary'] = isset($_POST["cimage_usesummary"]) ? 1 : 0; 289 $article['image']['list_name'] = clean_slweg($_POST["cimage_list_name"]); 290 $article['image']['list_id'] = intval($_POST["cimage_list_id"]); 291 $article['image']['list_width'] = (intval($_POST["cimage_list_width"])) ? intval($_POST["cimage_list_width"]) : ''; 292 $article['image']['list_height'] = (intval($_POST["cimage_list_height"])) ? intval($_POST["cimage_list_height"]) : ''; 293 $article['image']['list_caption'] = clean_slweg($_POST["cimage_list_caption"]); 294 $article['image']['list_zoom'] = empty($_POST["cimage_list_zoom"]) ? 0 : 1; 295 $article['image']['list_lightbox'] = empty($_POST["cimage_list_lightbox"]) ? 0 : 1; 296 297 $article['image']['list_maxwords'] = empty($_POST["article_listmaxwords"]) ? 0 : intval($_POST["article_listmaxwords"]); 298 299 if($article['image']['list_width'] > $phpwcms["content_width"] || $article['image']['list_width'] == '') { 300 $article['image']['list_width'] = $phpwcms["content_width"]; 301 } 302 303 if($article['image']['list_id']) { 304 // check for image information and get alle infos from file 305 $img_sql = "SELECT * FROM " . DB_PREPEND . "phpwcms_file WHERE f_id="; 306 $img_sql .= $article['image']['list_id']." LIMIT 1"; 307 308 if ($img_result = mysql_query($img_sql, $db) or die("error while getting content image info")) { 309 if ($img_row = mysql_fetch_assoc($img_result)) { 310 311 $article['image']['list_id'] = $img_row['f_id']; 312 $article['image']['list_name'] = $img_row['f_name']; 313 $article['image']['list_hash'] = $img_row['f_hash']; 314 $article['image']['list_ext'] = $img_row['f_ext']; 315 316 } 317 mysql_free_result($img_result); 318 } 319 } 320 321 322 if( count($article_err) == 0 ) { 323 324 if($article["article_id"] == 0) { 325 326 // Insert (create) new article 327 328 $data = array( 329 330 'article_created' => time(), 331 "article_cid" => $article["article_catid"], 332 "article_title" => $article["article_title"], 333 "article_alias" => $article["article_alias"], 334 "article_keyword" => $article["article_keyword"], 335 "article_public" => $article["article_public"], 336 "article_aktiv" => $article["article_aktiv"], 337 "article_begin" => $article["article_begin"], 338 "article_end" => $article["article_end"], 339 "article_subtitle" => $article["article_subtitle"], 340 "article_summary" => $article["article_summary"], 341 "article_redirect" => $article["article_redirect"], 342 "article_sort" => $article["article_sort"], 343 "article_username" => $article["article_username"], 344 "article_notitle" => $article["article_notitle"], 345 "article_hidesummary" => $article["article_hidesummary"], 346 "article_image" => serialize($article['image']), 347 "article_cache" => $article["article_timeout"], 348 "article_nosearch" => $article['article_nosearch'], 349 "article_nositemap" => $article['article_nositemap'], 350 "article_aliasid" => $article['article_aliasid'], 351 "article_headerdata" => $article['article_headerdata'], 352 "article_morelink" => $article['article_morelink'], 353 "article_pagetitle" => $article['article_pagetitle'], 354 "article_paginate" => $article['article_paginate'], 355 "article_priorize" => $article['article_priorize'], 356 "article_norss" => $article['article_norss'], 357 "article_uid" => $article["article_uid"], 358 "article_archive_status"=> $article["article_archive_status"], 359 "article_menutitle" => $article["article_menutitle"], 360 'article_description' => $article["article_description"], 361 'article_serialized' => '' 362 363 ); 364 365 $result = _dbInsert('phpwcms_article', $data); 366 367 if(isset($result['INSERT_ID'])) { 368 369 $article["article_id"] = $result['INSERT_ID']; 370 371 } else { 372 373 $result = false; 374 375 } 376 377 378 } else { 379 380 // Update article summary data 381 382 $sql = "UPDATE ".DB_PREPEND."phpwcms_article SET ". 383 "article_cid=".$article["article_catid"].",". 384 "article_title='".aporeplace($article["article_title"])."', ". 385 "article_alias='".aporeplace($article["article_alias"])."', ". 386 "article_keyword='".aporeplace($article["article_keyword"])."', ". 387 "article_public=".$article["article_public"].", ". 388 "article_aktiv=".$article["article_aktiv"].", ". 389 "article_begin='".aporeplace($article["article_begin"])."', ". 390 "article_end='".aporeplace($article["article_end"])."', ". 391 "article_subtitle='".aporeplace($article["article_subtitle"])."', ". 392 "article_summary='".aporeplace($article["article_summary"])."', ". 393 "article_redirect='".aporeplace($article["article_redirect"])."', ". 394 "article_sort='".aporeplace($article["article_sort"])."', ". 395 "article_username='".aporeplace($article["article_username"])."', ". 396 "article_notitle=".$article["article_notitle"].", ". 397 "article_hidesummary=".$article["article_hidesummary"].", ". 398 "article_image='".aporeplace(serialize($article['image']))."', ". 399 "article_cache='".aporeplace($article["article_timeout"])."', ". 400 "article_nosearch='".aporeplace($article['article_nosearch'])."', ". 401 "article_nositemap=".$article['article_nositemap'].", ". 402 "article_aliasid=".$article['article_aliasid'].", ". 403 "article_headerdata=".$article['article_headerdata'].", ". 404 "article_morelink=".$article['article_morelink'].", ". 405 "article_pagetitle='".aporeplace($article['article_pagetitle'])."', ". 406 "article_paginate=".$article['article_paginate'].", ". 407 "article_priorize=".$article['article_priorize'].", ". 408 "article_norss=".$article['article_norss'].", ". 409 "article_archive_status=".$article['article_archive_status'].", ". 410 "article_menutitle='".aporeplace($article["article_menutitle"])."',". 411 "article_description='".aporeplace($article["article_description"])."' "; 412 if($_SESSION["wcs_user_admin"]) { 413 $sql .= ", article_uid=".$article["article_uid"]." "; 414 } 415 416 $sql .= "WHERE article_id=".$article["article_id"]; 417 418 $result = _dbQuery($sql, 'UPDATE'); 419 420 } 421 422 if($result) { 423 424 update_cache(); // set cache timeout = 0 425 426 427 _dbSaveCategories($article["article_keyword"], 'article', $article["article_id"], ','); 428 429 $update = isset($_POST['updatesubmit']) ? '&aktion=1' : ''; 430 headerRedirect(PHPWCMS_URL.'phpwcms.php?do=articles&p=2&s=1'.$update.'&id='.$article["article_id"]); 431 } 432 433 } else { 434 435 set_status_message( $BL['be_admin_usr_err'] . ': ' . implode(', ', $article_err) , 'warning'); 436 437 } 438 439 } 440 441 442 // list mode 443 if( (!isset($_GET["aktion"]) || !intval($_GET["aktion"])) && !isset($_GET['struct'])) { 444 445 include_once PHPWCMS_ROOT."/include/inc_tmpl/articlecontent.list.tmpl.php"; 446 $phpwcms['be_parse_lang_process'] = true; 447 448 // edit article summary 449 } elseif( (isset($_GET["aktion"]) && intval($_GET["aktion"]) == 1) || isset($_GET['struct']) ) { 450 451 // initialize Mootools for autocomplete 452 initMootoolsAutocompleter(); 453 454 include_once PHPWCMS_ROOT."/include/inc_tmpl/article.editsummary.tmpl.php"; 455 456 } elseif(intval($_GET["aktion"]) == 2) { //Neuen Artikelcontent erstellen 457 458 if(isset($content["error"])) unset($content["error"]); //fehler zurücksetzen 459 $content["media_control"] = 1; //Vordefinierte Werte 460 461 if(isset($_GET["acid"]) && intval($_GET["acid"])) { 462 $content["id"] = intval($_GET["acid"]); 463 $content["aid"] = intval($_GET["id"]); 464 465 $sql = "SELECT * FROM ".DB_PREPEND."phpwcms_articlecontent WHERE acontent_id=".$content["id"]." AND ". 466 "acontent_aid=".$content["aid"]." LIMIT 1"; 467 if($result = mysql_query($sql, $db) or die("error while reading article content data")) { 468 if($row = mysql_fetch_array($result)) { 469 $content["title"] = $row["acontent_title"]; 470 $content["subtitle"] = $row["acontent_subtitle"]; 471 $content["visible"] = $row["acontent_visible"]; 472 $content["before"] = $row["acontent_before"]; 473 $content["after"] = $row["acontent_after"]; 474 $content["top"] = $row["acontent_top"]; 475 $content["type"] = $row["acontent_type"]; 476 $content["sorting"] = $row["acontent_sorting"]; 477 $content["block"] = $row["acontent_block"]; 478 $content["anchor"] = $row["acontent_anchor"]; 479 $content['module'] = $row["acontent_module"]; 480 $content['comment'] = $row["acontent_comment"]; 481 $content['paginate_title'] = $row["acontent_paginate_title"]; 482 $content["paginate_page"] = $row["acontent_paginate_page"]; 483 $content["granted"] = $row["acontent_granted"]; 484 $content["tab"] = $row["acontent_tab"]; 485 486 if($content["type"] != 30 && is_file(PHPWCMS_ROOT.'/include/inc_lib/content/cnt'.$content["type"].'.takeval.inc.php')) { 487 488 include(PHPWCMS_ROOT.'/include/inc_lib/content/cnt'.$content["type"].'.takeval.inc.php'); 489 490 } elseif($content["type"] == 30 && is_file($phpwcms['modules'][$content['module']]['path'].'inc/cnt.read.php')) { 491 492 $content['comment'] = $row["acontent_comment"]; 493 494 // load module data 495 include($phpwcms['modules'][$content['module']]['path'].'inc/cnt.read.php'); 496 497 } else { 498 499 include (PHPWCMS_ROOT.'/include/inc_lib/content/cnt0.takeval.inc.php'); 500 501 } 502 } 503 mysql_free_result($result); 504 } 505 506 } else { 507 $content["id"] = 0; 508 $content["aid"] = intval($_GET["id"]); 509 510 if(isset($_POST["ctype"])) { 511 512 $content["type"] = explode(':', $_POST["ctype"]); 513 $content["module"] = empty($content["type"][1]) ? '' : trim($content["type"][1]); 514 $content["type"] = intval($content["type"][0]); 515 516 } else { 517 518 $content["type"] = 0; 519 $content["module"] = ''; 520 521 } 522 523 $content["sorting"] = isset($_POST["csorting"]) ? intval($_POST["csorting"]) : 0; 524 } 525 //list($content["category"], $content["article"], $content["template_id"]) = explode("#|#", $_SESSION["article_path"]); 526 527 //if form posted 528 if(isset($_POST["caktion"]) && intval($_POST["caktion"])) { 529 530 include_once (PHPWCMS_ROOT."/include/inc_lib/article.readform.inc.php"); //get posted values from form 531 532 if(!isset($content["error"])) { //if no error 533 534 $SQL = "acontent_aid = '".$content["aid"]."', "; 535 $SQL .= "acontent_uid = '".$_SESSION["wcs_user_id"]."', "; 536 $SQL .= "acontent_title = '".aporeplace($content["title"])."', "; 537 $SQL .= "acontent_subtitle = '".aporeplace($content["subtitle"])."', "; 538 $SQL .= "acontent_type = '".$content["type"]."', "; 539 $SQL .= "acontent_sorting = '".$content["sorting"]."', "; 540 $SQL .= "acontent_visible = '".$content["visible"]."', "; 541 $SQL .= "acontent_before = '".aporeplace($content["before"])."', "; 542 $SQL .= "acontent_after = '".aporeplace($content["after"])."', "; 543 $SQL .= "acontent_top = '".$content["top"]."', "; 544 $SQL .= "acontent_block = '".aporeplace($content["block"])."', "; 545 $SQL .= "acontent_anchor = '".$content["anchor"]."', "; 546 $SQL .= "acontent_module = '".aporeplace($content["module"])."', "; 547 $SQL .= "acontent_comment = '".aporeplace($content["comment"])."', "; 548 $SQL .= "acontent_paginate_page = '".aporeplace($content["paginate_page"])."', "; 549 $SQL .= "acontent_paginate_title = '".aporeplace($content["paginate_title"])."', "; 550 $SQL .= "acontent_granted = '".$content["granted"]."', "; 551 $SQL .= "acontent_tab = '".aporeplace($content["tab"])."', "; 552 553 $WHERE = ''; 554 555 // load SQL addition for special content part 556 if($content['type'] != 30 && file_exists(PHPWCMS_ROOT.'/include/inc_lib/content/cnt'.$content['type'].'.sql.inc.php')) { 557 558 include(PHPWCMS_ROOT.'/include/inc_lib/content/cnt'.$content['type'].'.sql.inc.php'); 559 560 } elseif($content['type'] == 30 && file_exists($phpwcms['modules'][$content['module']]['path'].'inc/cnt.sql.php')) { 561 562 include($phpwcms['modules'][$content['module']]['path'].'inc/cnt.sql.php'); 563 564 } else { 565 566 include (PHPWCMS_ROOT.'/include/inc_lib/content/cnt0.sql.inc.php'); 567 568 } 569 570 // clean up SQL and remove ending "," 571 $SQL = trim($SQL); 572 if(substr($SQL, -1, 1) == ',') $SQL = substr($SQL, 0, -1); 573 574 if(!$content["id"]) { //if new content part should be created 575 576 // use SET method for INSERT too 577 $SQL = "INSERT INTO ".DB_PREPEND."phpwcms_articlecontent SET acontent_created=NOW(), " . $SQL; 578 579 //insert data into DB and get content part ID 580 if(!$content["update_type"]) { //if content type wasn't changed 581 if($result = mysql_query($SQL, $db) or die("error while creating new article content: ".mysql_error())) { 582 $content["id"] = mysql_insert_id($db); //successful created 583 change_articledate($content["aid"]); //update article date too 584 update_cache(); // set cache timeout = 0 585 if(!empty($_POST['SubmitClose'])) { 586 headerRedirect(PHPWCMS_URL."phpwcms.php?do=articles&p=2&s=1&id=".$content["aid"]); 587 } 588 } 589 } else { 590 $content["type"] = $content["target_type"]; 591 } 592 } else { //if content part should be updated 593 594 $SQL = "UPDATE ".DB_PREPEND."phpwcms_articlecontent SET " . $SQL; 595 $SQL .= " WHERE acontent_id=".$content['id']; 596 if(empty($ctype_change_aid) || $ctype_change_aid != 'DO_CHANGE') { 597 $SQL .= " AND acontent_aid=".$content['aid']; 598 } 599 $SQL .= $WHERE; 600 601 if($result = mysql_query($SQL, $db) or die("error while updating content: ".$SQL)) { 602 603 if($content["update_type"]) { //If content part type was changed 604 $sql = "UPDATE ".DB_PREPEND."phpwcms_articlecontent SET"; 605 $sql .= " acontent_type=".$content["target_type"]; 606 $sql .= " WHERE acontent_id=".$content["id"]; 607 $sql .= " AND acontent_aid=".$content["aid"]; 608 mysql_query($sql, $db) or die("error while updating content type info"); 609 } 610 change_articledate($content["aid"]); //update article date too 611 update_cache(); // set cache timeout = 0 612 if(empty($_POST['SubmitClose'])) { 613 headerRedirect(PHPWCMS_URL."phpwcms.php?do=articles&p=2&s=1&aktion=2&id=".$content["aid"]."&acid=".$content["id"]); //erfolgreich neuer Content angelegt 614 } else { 615 headerRedirect(PHPWCMS_URL."phpwcms.php?do=articles&p=2&s=1&id=".$content["aid"]); 616 } 617 } 618 } //end update/insert 619 } //end error check 620 } 621 622 //form to edit article content parts 623 include (PHPWCMS_ROOT."/include/inc_tmpl/articlecontent.edit.tmpl.php"); 624 625 } 626 //end edit article content part 627 } 628 ?>
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
Generated: Sun Jan 29 16:31:14 2012 | Cross-referenced by PHPXref 0.7.1 |