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