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