<?php
	include 'config.php';

	// Check if the user is logged in

	if ((!isSet($_SESSION['loginname'])) || ($loggin <> '1')) {
		header("Location: login.php");
		exit;
	}

	foreach ($arraylangcode as $langcode => $langname) {
		$content[$langcode] = preg_replace("/'/", "\'", $_POST["content_".$langcode]);
		$content[$langcode] = str_replace("<br />","",$content[$langcode]);
	}


	$sql2 = "update rolling_text set sort = sort + 1 where deleted = ?";

	if (!($sth2 = $dbh->prepare($sql2))) {
		throw new Exception('[' . $sth2->errorCode() . ']: ' . print_r($sth2->errorInfo()));
	}

	if (!$sth2->execute(array("0"))) {
		throw new Exception('[' . $sth2->errorCode() . ']: ' . print_r($sth2->errorInfo()));
	}

	$sql = "insert into rolling_text (content_en, content_tc, content_sc, sort, createdate, createby, lastupdate, lastupby) values (?, ?, ?, ?, ?, ?, ?, ?)";

	if (!($sth = $dbh->prepare($sql))) {
		throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
	}

	$parameters = array($content["en"], $content["tc"], $content["sc"], "1", $nowdate, $_SESSION['cmsloginid'], $nowdate, $_SESSION['cmsloginid']);

	if (!$sth->execute($parameters)) {
		throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
	}

	$dbh = null;

	header("Location: rolling_text_index.php?msg=新增成功");
?>