phpwcms Support Forum

Code: Select all

error while connecting to database:
INSERT INTO phpwcms_article (article_cid, article_uid, article_username, article_title, article_keyword, article_public, article_aktiv, article_begin, article_end, article_subtitle, article_redirect, article_sort, article_notitle, article_created, article_cache, article_nosearch, article_nositemap, article_aliasid, article_headerdata, article_morelink) VALUES ('33','1','Pieter van der Spek','test','','0','1','2005-10-09 17:45:45','2010-12-31 23:59:59','','', 0,0, '1128872745', '', '', 1, 0, 0, 1);

Code: Select all

//Auswerten der neuen Artikeldaten
$article_cid = isset($_GET["struct"]) ? intval($_GET["struct"]) : 0;

$article_aktiv  = 1;
$article_public = 1;
$article_timeout = '';
$article_nosearch = '';
$article_title = '';
$article_subtitle = '';
$article_notitle = 0;
$set_begin = 0;
$set_end = 0;
$article_begin = '';
$article_end = '';
$article_redirect = '';
$article_keyword = '';
$article_nositemap = 1;
$article_aliasid = 0;
$article_headerdata = 0;
$article_morelink = 1;
			
if(isset($_POST["article_aktion"]) && intval($_POST["article_aktion"])) {
	$article_cid		= intval($_POST["article_cid"]);
	$article_title		= clean_slweg($_POST["article_title"]);
	$article_keyword	= clean_slweg($_POST["article_keyword"]);
	$article_aktiv		= isset($_POST["article_aktiv"]) ? 1 : 0;
	$article_notitle	= isset($_POST["article_notitle"]) ? 1 : 0;
	$article_public		= isset($_POST["article_public"]) ? 1 : 0;
	$article_hidesummary= isset($_POST["article_hidesummary"]) ? 1 : 0;
	$article_begin		= clean_slweg($_POST["article_begin"]);
	$article_end		= clean_slweg($_POST["article_end"]);
	$article_subtitle	= clean_slweg($_POST["article_subtitle"]);
	$article_redirect	= clean_slweg($_POST["article_redirect"]);
	$article_nosearch	= isset($_POST['article_nosearch']) ? '1' : '';
	$article_nositemap	= isset($_POST['article_nositemap']) ? 1 : 0;
	$set_begin			= isset($_POST["set_begin"]) ? 1 : 0;
	$set_end			= isset($_POST["set_end"]) ? 1 : 0;
	$article_aliasid	= intval($_POST["article_aliasid"]);
	$article_headerdata	= isset($_POST["article_headerdata"]) ? 1 : 0;
	$article_morelink	= isset($_POST["article_morelink"]) ? 1 : 0;
	
	if(isEmpty($article_title)) $article_err = "> ".$BL['be_article_err1']."\n";
	if($article_begin) { //Check date
		$article_begin = strtotime($article_begin);
		if($article_begin == -1) {
			$article_begin = date("Y-m-d H:i:s");
			$set_begin = 1;
			$article_err  .= "> ".$BL['be_article_err2']."\n"; 
		} else {
			$article_begin = date("Y-m-d H:i:s", $article_begin);
			$set_begin = 1;
		}
	} else {
		$article_begin=date("Y-m-d H:i:s");
		$set_begin = 0;
	}
	if($article_end) { //Check date
		$article_end = strtotime($article_end);
		if($article_end == -1) {
			$article_end = date("Y-m-d H:i:s");
			$set_end = 1;
			$article_err  .= "> ".$BL['be_article_err3']."\n"; 
		} else {
			$article_end = date("Y-m-d H:i:s", $article_end);
			$set_end = 1;
		}
	} else {
		$article_end="2010-12-31 23:59:59";
		$set_end = 0;
	}	//Ende Check Date
	
	$article_timeout = clean_slweg($_POST["article_timeout"]);
	if(isset($_POST['article_cacheoff']) && intval($_POST['article_cacheoff'])) $article_timeout = '0'; //check if cache = Off
	
	if(isEmpty($article_err)) {
		$sql =	"INSERT INTO ".DB_PREPEND."phpwcms_article (".
				"article_cid, article_uid, article_username, article_title, ".
				"article_keyword, article_public, article_aktiv, article_begin, ".
				"article_end, article_subtitle, article_redirect, ".
				"article_sort, article_notitle, article_created, article_cache, ".
				"article_nosearch, article_nositemap, article_aliasid, article_headerdata, article_morelink) VALUES ('".
				$article_cid."','".
				$_SESSION["wcs_user_id"]."','".
				$_SESSION["wcs_user_name"]."','".
				aporeplace($article_title)."','".
				aporeplace($article_keyword)."','".
				$article_public."','".
				$article_aktiv."','".
				$article_begin."','".
				$article_end."','".
				aporeplace($article_subtitle)."','".
				aporeplace($article_redirect)."', ".
				"0,".$article_notitle.", '".time()."', '".$article_timeout."', '".
				$article_nosearch."', ".$article_nositemap.", ".$article_aliasid.", ".
				$article_headerdata.", ".$article_morelink.");";
		if($result = mysql_query($sql, $db) or die("error while connecting to database: <br><pre>".$sql."</pre>")) {
			$article_id = mysql_insert_id($db);
			header("Location: ".PHPWCMS_URL."phpwcms.php?do=articles&p=2&s=1&aktion=1&id=".$article_id);
			exit();
		}
	}			
}	
		
?>