fetch(PDO::FETCH_ASSOC); $stH = null; $adt = $row['aDateTime']; $mdt = $row['mDateTime'][0] != '9' ? $row['mDateTime'] : ""; $edr = $row['editor']; $tit = $row['title']; $ven = $row['venue']; $tx1 = str_replace('[cd]',$evDD,$row['text1']); $tx2 = str_replace('[cd]',$evDD,$row['text2']); $tx3 = str_replace('[cd]',$evDD,$row['text3']); $att = $row['attach']; $cid = $row['catID']; $sid = $row['scatID']; $uid = $row['userID']; $nal = ($row['notRecip']) ? $row["notRecip"] : $usr['mail']; $apd = $row['approved']; $pri = $row['private']; $sda = IDtoDD($row['sDate']); $eda = ($row['eDate'][0] != "9") ? IDtoDD($row['eDate']) : ""; $sti = $row['sTime']; $eti = $row['eTime']; $r_t = $row['rType']; $r_i = $row['rInterval']; $r_p = $row['rPeriod']; $r_m = $row['rMonth']; $rul = ($row['rUntil'][0] != "9") ? IDtoDD($row['rUntil']) : ''; $nom = $row['notEml'] > -1 ? $row['notEml'] : ''; $nos = $row['notSms'] > -1 ? $row['notSms'] : ''; $own = $row['own']; if ($viaGet) { //stand-alone use $p2 = strrpos(": {$tit}",': ') + 1; if (empty($_GET['k']) or $_GET['k'] != ord($tit[$p2])) { echo $xx['no_way']; //no or invalid key exit; } } //get category data $stH = stPrep("SELECT `name`,`approve`, `color`,`bgColor`,`subName1`,`subColor1`,`subBgrnd1`,`subName2`,`subColor2`,`subBgrnd2`,`subName3`,`subColor3`,`subBgrnd3`,`subName4`,`subColor4`,`subBgrnd4` FROM `categories` WHERE `ID` = ?"); stExec($stH,array($cid)); $row = $stH->fetch(PDO::FETCH_ASSOC); $stH = null; //release statement handle $cnm = $row['name']; $app = $row['approve']; if (!$sid) { //no subcat $snm = ''; $cco = $row['color']; $cbg = $row['bgColor']; } else { $snm = $row["subName{$sid}"]; $cco = $row["subColor{$sid}"] ? $row["subColor{$sid}"] : $row['color']; $cbg = $row["subBgrnd{$sid}"] ? $row["subBgrnd{$sid}"] : $row['bgColor']; } $repTxt = repeatText($r_t,$r_i,$r_p,$r_m,DDtoID($rul)); //make repeat text if ($sti == '00:00' and $eti == '23:59') { $ald = true; $sti = $eti = ''; } else { $ald = false; $sti = ITtoDT($sti); $eti = ($eti[0] != "9") ? ITtoDT($eti) : ""; } if (!$eda) { $sda = IDtoDD($evD); } if ($app and $apd) { //event approved echo "
{$xx['evt_apd_locked']}
\n"; } $evt = array ('ven' => $ven, 'cnm' => $cnm, 'des' => $tx1, 'xf1' => $tx2, 'xf2' => $tx3, 'att' => $att, 'snm' => $snm); //tx1 - tx3: with hyperlinks $eColor = ($cco or $cbg) ? " style='color:{$cco}; background:{$cbg};'" : ''; echo ""; if ($pri) { echo "\n"; } echo makeE($evt,$set['evtTemplGen'],'tx',"\n",'123458'); echo ""; echo "\n"; //make full date (display values) if ($r_t) { echo "\n"; } if (($nom != "" or $nos != "") and ($usr['privs'] > 2 or ($usr['privs'] == 2 and $uid == $usr['ID']))) { //has rights to see reminder address list echo "\n"; if ($nom != "") { echo "\n\n"; } if ($nos != "") { echo "\n\n"; } echo "\n"; } if (strpos($set['evtTemplGen'],'7') !== false) { echo "\n\n"; echo "
{$xx['evt_title']}:{$tit}
{$xx['evt_private']}
{$xx['evt_date_time']}:".makeFullDT(false,$sda,$eda,$sti,$eti)."
{$repTxt}
{$xx['evt_send_eml']}:{$nom} {$xx['evt_days_before_event']}
{$xx['evt_send_sms']}:{$nos} {$xx['evt_days_before_event']}
{$nal}
{$xx['evt_added']}:".IDTtoDDT($adt)." {$xx['by']} {$own}"; if ($mdt and $edr) { echo "
{$xx['evt_edited']}:".IDTtoDDT($mdt)." {$xx['by']} {$edr}"; } } echo "
\n"; if (!$viaGet) { echo "
\n"; } ?>