function addEvents()
{
global $ax, $birthdayID, $dFormat, $tFormat;
$msg = '';
$nofEvents = count($_POST['title']);
$added = $dropped = 0;
for ($i = 0; $i < $nofEvents; $i++) {
if (empty($_POST['delete'][$i])) {
$title = addslashes(strip_tags($_POST['title'][$i]));
$venue = addslashes(strip_tags($_POST['venue'][$i]));
$descr = addslashes(strip_tags($_POST['descr'][$i], '<a>'));
//allow URLs
$sDate = DDtoID($_POST['sDate'][$i], $dFormat);
$eDate = $_POST['eDate'][$i] ? DDtoID($_POST['eDate'][$i], $dFormat) : "9999-00-00";
$sTime = DTtoIT($_POST['sTime'][$i], $tFormat);
$eTime = $_POST['eTime'][$i] ? DTtoIT($_POST['eTime'][$i], $tFormat) : "99:00:00";
$catID = $_POST['catID'][$i] ? $_POST['catID'][$i] : 1;
//no cat
$rType = $rInterval = $rPeriod = $rMonth = 0;
if (!empty($_POST['birthday'][$i]) or $catID == $birthdayID) {
//birthday
$rType = 1;
$rInterval = 1;
$rPeriod = 4;
$eDate = "9999-00-00";
$catID = $birthdayID;
}
if (!eventInDb($title, $sDate, $eDate, $sTime, $eTime)) {
//update events db
$q = "INSERT INTO [db]events VALUES (NULL,DEFAULT,'{$title}','{$descr}',DEFAULT,DEFAULT,{$catID},'{$venue}',{$_SESSION['uid']},DEFAULT,DEFAULT,DEFAULT,DEFAULT,'{$sDate}','{$eDate}',DEFAULT,'{$sTime}','{$eTime}',{$rType},{$rInterval},{$rPeriod},{$rMonth},DEFAULT,DEFAULT,DEFAULT,'" . date("Y-m-d H:i") . "', '" . date("Y-m-d H:i") . "',DEFAULT)";
$result = dbQuery($q);
if (!$result) {
$msg = $ax['iex_db_error'];
}
$added++;
} else {
$dropped++;
}
}
}
if (!$msg) {
$msg = "{$added} {$ax['iex_events_added']}" . ($dropped > 0 ? " / {$dropped} {$ax['iex_events_dropped']}" : '');
}
return $msg;
}
} else {
if ($sti) {
$stime = DTtoIT($sti);
if (!$stime) {
$eMsg .= $xx['evt_bad_time'] . ": " . $sti . "<br>";
break;
}
} elseif ($edate[0] != '9') {
$stime = '00:00';
$sti = ITtoDT('00:00');
} else {
$eMsg .= $xx['evt_no_start_time'] . "<br>";
break;
}
if ($eti) {
$etime = DTtoIT($eti);
if (!$etime) {
$eMsg .= $xx['evt_bad_time'] . ": " . $eti . "<br>";
break;
} elseif (($edate[0] == '9' or $edate == $sdate) and $etime < $stime) {
$eMsg .= $xx['evt_end_before_start_time'] . "<br>";
break;
}
if ($stime == $etime and $edate[0] == '9') {
$etime = '99:00';
}
} else {
$etime = $edate[0] != '9' ? '23:59' : '99:00';
}
}
if ($stime == '00:00' and $etime == '23:59') {
function addEvents()
{
global $ax, $defcatID;
$msg = "";
$nofEvents = count($_POST['title']);
$added = $dropped = 0;
for ($i = 0; $i < $nofEvents; $i++) {
if (empty($_POST['delete'][$i]) and $_POST['r_t'][$i] >= 0) {
//if delete not ticked and repeat-type is valid
$title = mysql_real_escape_string(htmlspecialchars_decode(trim($_POST['title'][$i])));
$venue = mysql_real_escape_string(htmlspecialchars_decode(trim($_POST['venue'][$i])));
$descr = str_ireplace(array("\r\n", "\n", "\r"), "<br>", strip_tags(trim($_POST['descr'][$i]), '<a>'));
//allow URLs and replace newline by <br>
$descr = mysql_real_escape_string($descr);
$sDate = DDtoID($_POST['sDate'][$i]);
$eDate = $_POST['eDate'][$i] ? DDtoID($_POST['eDate'][$i]) : "9999-00-00";
$sTime = DTtoIT($_POST['sTime'][$i]);
$eTime = $_POST['eTime'][$i] ? DTtoIT($_POST['eTime'][$i]) : "99:00:00";
$r_t = $_POST['r_t'][$i];
$r_i = $_POST['r_i'][$i];
$r_p = $_POST['r_p'][$i];
$r_m = $_POST['r_m'][$i];
$r_u = $_POST['r_u'][$i] ? DDtoID($_POST['r_u'][$i]) : "9999-00-00";
$catID = $_POST['catID'][$i] ? $_POST['catID'][$i] : 1;
//no cat
if (!eventInDb($title, $sDate, $eDate, $sTime, $eTime)) {
//add event to db
$q = "INSERT INTO [db]events VALUES (NULL,DEFAULT,'{$title}','{$descr}',DEFAULT,DEFAULT,{$catID},'{$venue}',{$_SESSION['uid']},DEFAULT,DEFAULT,DEFAULT,DEFAULT,'{$sDate}','{$eDate}',DEFAULT,'{$sTime}','{$eTime}',{$r_t},{$r_i},{$r_p},{$r_m},'{$r_u}',DEFAULT,DEFAULT,'" . date("Y-m-d H:i") . "','" . date("Y-m-d H:i") . "',DEFAULT)";
$result = dbQuery($q);
if (!$result) {
$msg = $ax['iex_db_error'];
}
$added++;
} else {
$dropped++;
}
}
}
if (!$msg) {
$msg = $added . " " . $ax['iex_events_added'] . ($dropped > 0 ? " / {$dropped} {$ax['iex_events_dropped']}" : "");
}
return $msg;
}
function addEvents()
{
global $ax, $birthdayID, $dFormat, $tFormat;
$msg = '';
$nofEvents = count($_POST['title']);
$added = $dropped = 0;
for ($i = 0; $i < $nofEvents; $i++) {
if (empty($_POST['ignore'][$i])) {
$title = strip_tags($_POST['title'][$i]);
$venue = strip_tags($_POST['venue'][$i]);
$descr = strip_tags($_POST['descr'][$i], '<a>');
//allow URLs
$descr = addUrlImgTags($descr, 'x-');
//add URL link tags
$sDate = DDtoID($_POST['sDate'][$i], $dFormat);
$eDate = $_POST['eDate'][$i] ? DDtoID($_POST['eDate'][$i], $dFormat) : "9999-00-00";
$sTime = DTtoIT($_POST['sTime'][$i], $tFormat);
$eTime = $_POST['eTime'][$i] ? DTtoIT($_POST['eTime'][$i], $tFormat) : "99:00:00";
if (empty($sTime)) {
//all day
$sTime = '00:00';
$eTime = '23:59';
}
$catID = $_POST['catID'][$i] ? $_POST['catID'][$i] : 1;
//no cat
$rType = $rInterval = $rPeriod = $rMonth = 0;
if (!empty($_POST['birthday'][$i]) or $catID == $birthdayID) {
//birthday
$catID = $birthdayID;
$rType = 1;
$rInterval = 1;
$rPeriod = 4;
$eDate = "9999-00-00";
}
if (!eventInDb($title, $sDate, $eDate, $sTime, $eTime)) {
//add event to db
$q = "INSERT INTO `events` (`title`,`venue`,`text1`,`catID`,`userID`,`sDate`,`eDate`,`sTime`,`eTime`,`rType`,`rInterval`,`rPeriod`,`rMonth`,`aDateTime`,`mDateTime`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
$stH = stPrep($q);
$result = stExec($stH, array($title, $venue, $descr, $catID, $_SESSION['uid'], $sDate, $eDate, $sTime, $eTime, $rType, $rInterval, $rPeriod, $rMonth, date("Y-m-d H:i"), date("Y-m-d H:i")));
if ($result) {
$added++;
} else {
$msg = $ax['iex_db_error'];
}
} else {
$dropped++;
}
}
}
if (!$msg) {
$msg = "{$added} {$ax['iex_events_added']}" . ($dropped > 0 ? " / {$dropped} {$ax['iex_events_dropped']}" : '');
}
return $msg;
}
if ($sti) {
$sTime = DTtoIT($sti);
if (!$sTime) {
$eMsg .= $xx['evt_bad_time'] . ": " . $sti . "<br>";
break;
}
} elseif ($eDate[0] != '9') {
$sTime = '00:00';
$sti = ITtoDT('00:00');
} else {
$eMsg .= $xx['evt_no_start_time'] . "<br>";
break;
}
if ($eti) {
//end time specified
$eTime = DTtoIT($eti);
if (!$eTime) {
$eMsg .= $xx['evt_bad_time'] . ": " . $eti . "<br>";
break;
} elseif (($eDate[0] == '9' or $eDate == $sDate) and $eTime < $sTime) {
$eMsg .= $xx['evt_end_before_start_time'] . "<br>";
break;
}
if ($sTime == $eTime and $eDate[0] == '9') {
$eTime = '99:00';
}
} else {
//no end time
if ($eDate[0] != '9') {
//end date specified
$eTime = '23:59';
function addEvents()
{
global $ax, $defcatID;
$msg = "";
$nofEvents = count($_POST['title']);
$added = $dropped = 0;
for ($i = 0; $i < $nofEvents; $i++) {
if (empty($_POST['delete'][$i]) and $_POST['r_t'][$i] >= 0) {
//if delete not ticked and repeat-type is valid
$title = htmlspecialchars_decode(trim($_POST['title'][$i]));
$venue = htmlspecialchars_decode(trim($_POST['venue'][$i]));
$descr = strip_tags(trim($_POST['descr'][$i]), '<a>');
$descr = addUrlImgTags($descr, 'x-');
//add URL link tags
$descr = str_ireplace(array("\r\n", "\n", "\r"), "<br>", $descr);
//allow URLs and replace newline by <br>
$sDate = DDtoID($_POST['sDate'][$i]);
$eDate = $_POST['eDate'][$i] ? DDtoID($_POST['eDate'][$i]) : "9999-00-00";
$sTime = DTtoIT($_POST['sTime'][$i]);
$eTime = $_POST['eTime'][$i] ? DTtoIT($_POST['eTime'][$i]) : "99:00:00";
if (empty($sTime)) {
//all day
$sTime = '00:00';
$eTime = '23:59';
}
$r_t = $_POST['r_t'][$i];
$r_i = $_POST['r_i'][$i];
$r_p = $_POST['r_p'][$i];
$r_m = $_POST['r_m'][$i];
$r_u = $_POST['r_u'][$i] ? DDtoID($_POST['r_u'][$i]) : "9999-00-00";
$catID = $_POST['catID'][$i] ? $_POST['catID'][$i] : 1;
//no cat
if (!eventInDb($title, $sDate, $eDate, $sTime, $eTime)) {
//add event to db
$q = "INSERT INTO `events` (`title`,`venue`,`text1`,`catID`,`userID`,`sDate`,`eDate`,`sTime`,`eTime`,`rType`,`rInterval`,`rPeriod`,`rMonth`,`rUntil`,`aDateTime`,`mDateTime`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
$stH = stPrep($q);
$result = stExec($stH, array($title, $venue, $descr, $catID, $_SESSION['uid'], $sDate, $eDate, $sTime, $eTime, $r_t, $r_i, $r_p, $r_m, $r_u, date("Y-m-d H:i"), date("Y-m-d H:i")));
if ($result) {
$added++;
} else {
$msg = $ax['iex_db_error'];
}
} else {
$dropped++;
}
}
}
if (!$msg) {
$msg = $added . " " . $ax['iex_events_added'] . ($dropped > 0 ? " / {$dropped} {$ax['iex_events_dropped']}" : "");
}
return $msg;
}