WebsiteBaker 2.13.9 is now available!
R.I.P Dietmar (luisehahne) and thank you for all your valuable work for WBhttps://forum.websitebaker.org/index.php/topic,32355.0.html
//:Show next $max events//:only section_id of procal installation is required//:get categorie id from categorie link or form procal database//:usage: [[eventlist?section_id=<xx>&datestart=<yyyy-mm-dd>&dateend=<yyyy-mm-dd>&kat=<categorie id>&max=<max entries to show>]]// Get eventsglobal $database, $wb;require_once(WB_PATH."/modules/procalendar/functions.php");// Show how many items, defaults to 10?if ( !isset($max) ){ $max = 10; };// year and month and section defaultsif(!isset($datestart)) {$datestart = date('Y-n-d', time()); }if(!isset($dateend)) {$dateend = date('Y-n-d', time()); }if(!isset($section_id)) {$section_id = 0 ; }if(isset($_GET['categorie'])) {$kat = $_GET['categorie'];}// Fetch base page link, if event_id = set$page_id = 0;$page_link ='';if ($section_id<>0) { $sql = "SELECT link FROM ".TABLE_PREFIX."sections AS s, ".TABLE_PREFIX."pages AS p WHERE s.section_id = '".$section_id."' AND s.page_id = p.page_id LIMIT 1"; $result = $database->query($sql); while( $row = $result->fetchRow() ) { $page_link = page_link($row['link']); }}// Fetch the itemsif (!isset($actions) || empty($actions)) $actions = fillActionArray($datestart, $dateend, $section_id);$mod_list = "";//print_r($actions); // KEVIN NEW$categories = array();if (is_array($actions)){ foreach($actions as $row){ $categories[$row['acttype']] = array($row['act_name'],$row['act_format'],$row['acttype']); if (isset($kat) && $kat !== $row['acttype']) continue; $page_url = $page_link.'?id='.$row['id'].'&detail=1'; }}$mod_list.= '<div class="proCalCategoryContainer"><div class="proCalFilter">Prikaži Samo:</div>';foreach ($categories as $cat) { $link = '?categorie='.$cat[2]; $mod_list.='<div class="proCalCategory" style="background:'.$cat[1].'";><a href="'.$link.'">'.$cat[0].'</a></div>';}$mod_list.='<div class="proCalCategory"><a href="?">Prikaži Vse</a></div><div class="clear"></div></div>';// END KEVIN NEW$mod_list .= '<table class="proCalTable">';$printDay = "";$categories = array();if (is_array($actions)){ foreach($actions as $row){ $categories[$row['acttype']] = array($row['act_name'],$row['act_format'],$row['acttype']); if (isset($kat) && $kat !== $row['acttype']) continue; // Build url like : pages/kalendar.php?id=2&detail=1 $page_url = $page_link.'?id='.$row['id'].'&detail=1'; if ($row['date_start'] !== $printDay) { $printTime = ""; if ($printDay !== "") $mod_list.= '</td></tr>'; $printDay = $row['date_start']; $mod_list.= '<tr><td colspan = 2><div class="proCalDate"><span class="proCalDateBig">'.date('l', strtotime($printDay)).' </span><span class="proCalDateSmall">'.date('F j', strtotime($printDay)).'</span></div>'; } if ($row['time_start'] !== $printTime) { $printTime = $row['time_start']; $mod_list.= '</td></tr><tr><td class="proCalTime"><span class="proCalTimeStart">'.substr($printTime,0,5).'</span></td><td>'; //$mod_list.= '</td></tr><tr><td class="proCalTime"><span class="proCalTimeStart">'.substr($printTime,0,5).'</span></td><td>';tr><tr><td width="40px"><span class="timeStart">'.substr($printTime,0,5).'</span></td><td>'; } $mod_list .= '<p class="proCalBand" style="background:'.$row["act_format"].'";><a target="_blank" href="'.$page_url.'"><b>'.$row["name"].'</a></p>'; //.$page_url. }}$mod_list.= '</td></tr></table>';$mod_list.= '<div class="proCalCategoryContainer"><div class="proCalFilter">Prikaži Samo:</div>';foreach ($categories as $cat) { $link = '?categorie='.$cat[2]; $mod_list.='<div class="proCalCategory" style="background:'.$cat[1].'";><a href="'.$link.'">'.$cat[0].'</a></div>';}$mod_list.='<div class="proCalCategory"><a href="?">Prikaži Vse</a></div><div class="clear"></div></div>';return $mod_list;
$mod_list .= '<p class="proCalBand" style="background:'.$row["act_format"].'";><a target="_blank" href="'.$page_url.'"><b>'.$row["name"].'</a></p>'; //.$page_url. }
$mod_list .= '<p class="proCalBand" style="background:'.$row["act_format"].'";><a target="_blank" href="'.$page_url.'"><img src="'.$row["custom4"].'" class="slikca" /></a><a target="_blank" href="'.$page_url.'"><b>'.$row["name"].'</a></p>'; //.$page_url. }
Ok, I somehow made it with an image
Here is what I did...
But the language still stays mistery to me??? Anyone?
setlocale ( LC_TIME, ['de_DE', 'deu'] );
$mod_list.= '<tr><td colspan = 2><div class="proCalDate"><span class="proCalDateBig">'.strftime('%A', strtotime($printDay)).' </span><span class="proCalDateSmall">'.strftime('%B %d', strtotime($printDay)).'</span></div>';
setlocale( LC_TIME,"sl_SI.utf-8");
$mod_list .= '<p class="proCalBand" style="background:'.$row["act_format"].'";><a target="_blank" href="'.$page_url.'"></a><a target="_blank" href="'.$page_url.'"><b>'.$row["name"].'</a></p>'; //.$page_url.
if(isset($row['custom4']) && $row['custom4']) { // custom4 exists $mod_list .= '<p class="proCalBand" style="background:'.$row["act_format"].'";><a target="_blank" href="'.$page_url.'"><img src="'.$row["custom4"].'" class="eventimage" /></a><a target="_blank" href="'.$page_url.'"><b>'.$row["name"].'</a></p>'; //.$page_url.}} else { // custom4 doesn't exist $mod_list .= '<p class="proCalBand2" style="background:'.$row["act_format"].'";><a target="_blank" href="'.$page_url.'"><b>'.$row["name"].'</a></p>'; //.$page_url.}} }
//:Show next #N events//:// Get_Concertsglobal $database, $wb;setlocale (LC_ALL, 'sl_SI.UTF-8'); //za vse kategorije setlocale (LC_TIME, 'sl_SI.UTF-8'); //za datumske funkcije// Show how many items, defaults to 10?if ( !isset($max) ){ $max = 10; };// year and month and section defaultsif(!isset($year)) {$year = date('Y', time()); }if(!isset($month)) {$month = date('n', time()); }if(!isset($section_id)) {$section_id = 0 ; }// Set dateformat to suit your needs, add timeformat if needed$dateformat = 'd'; // Standard php date formats$datemonth = 'M'; // Standard php date formats$dateyear = 'Y'; // Standard php date formats// Fetch base page link, if event_id = set$extrasql = '';$page_id = 0;$page_link ='';if ($section_id<>0) { $extrasql = " section_id = '".$section_id."' AND "; $sql = "SELECT page_id FROM ".TABLE_PREFIX."sections WHERE section_id = '".$section_id."'";$result = $database->query($sql);if ( $result->numRows() > 0 ) {while( $row = $result->fetchRow() ) {$page_id = $row['page_id'];}}if ($page_id <> 0) {$sql = "SELECT link FROM ".TABLE_PREFIX."pages WHERE page_id = '".$page_id."'";$result = $database->query($sql);if ( $result->numRows() > 0 ) {while( $row = $result->fetchRow() ) {$page_link = page_link($row['link']);}}}}// Set start- and end date for query// $datestart = "$year-$month-1"; ORIGINAL = show all events in this month$datestart = date("Y-m-d"); // ALTERNATIVE = show all events in this month, starting today$dateend = "$year-$month-".cal_days_in_month(CAL_GREGORIAN, $month,$year);$mod_list = "";// Fetch the items$sql = "SELECT DAY(date_start) AS day, id, custom1, date_start, time_start, date_end, time_end, name FROM ".TABLE_PREFIX."mod_procalendar_actions WHERE ".$extrasql." date_start >='$datestart' AND public_stat = 0 ORDER BY date_start,time_start LIMIT 0, ".$max." ";$mod_query = $database->query($sql);while ( $row =& $mod_query->fetchRow()){// Build url like : pages/kalendar.php?id=2&detail=1 $page_url = $page_link.'?id='.$row['id'].'&detail=1';$ds = $row['date_start']." ".substr($row['time_start'],0,5);$de = $row['date_end']." ".substr($row['time_end'],0,5);$datetime_start = mktime(substr($ds,11,2),substr($ds,14,2),0,substr($ds,5,2),substr($ds,8,2),substr($ds,0,4));$datetime_end = mktime(substr($de,11,2),substr($de,14,2),0,substr($de,5,2),substr($de,8,2),substr($de,0,4));if ($row['time_start'] !== $printTime) { $printTime = $row['time_start']; $mod_list.= '<ul class="upcoming-events"><li><div class="date"><span><span class="day">'.date($dateformat,$datetime_start).'</span><span><span class="month">'.date($datemonth,$datetime_start).'</span><span><span class="year">'.date($dateyear,$datetime_start).'</span></div>';$mod_list.= '<div class="event-content"><h6><a href="'.$page_url.'">'.$row["name"].'</a></h6><ul class="event-meta"><li><i class="fa fa-clock-o"> </i>'.substr($printTime,0,5).'<sup>h</sup></li><!-- <li><i class="fa fa-info-circle"> </i>'.$row["custom1"].'</li> --></ul></div></li></ul>'; }$mod_list .= "<hr>"; }$mod_list .= '<a href="[wblink13]" class="button transparent button-arrow" style="margin-top:-10px;">Napovednik</a><br></br>'; return $mod_list;
[[procal-events?section_id=73&max=20]]
Where is the problem?