Quote:
Biteronboard wrote:
I am running the latest version of this module.
I have scoured every possible knowledgebase on this subject.
Yet I am having a somewhat similar problem.
Via admin Panel, when looking at Events.
The events are not chronological, instead they are sorted by last modification.
Does anyone know of a method to force the events to sort chronologically here?
Also, Does anyone know where to find the hack to sort the category's alphabetically?
Zoullou's site has 0 usable info.
Took me some time to see how I did it (long ago)
fixes the user-side yearly sorting for by-date-sorting
open /class/event.php
around line 165 look for:
le="color: #000000"><?php } return $this->getObjects($criteriaCompo); } function getEventMonth($month, $year, $user, $cats=0) { $userStartTime = mktime(0,0,0,$month,1,$year); $userEndTime = mktime(23,59,59,$month+1,0,$year); $monthStart = userTimeToServerTime($userStartTime, $this->_extcalTime->_getUserTimeZone($user)); $monthEnd = userTimeToServerTime($userEndTime, $this->_extcalTime->_getUserTimeZone($user)); $criteriaCompo = new CriteriaCompo(); $authorizedAccessCats = $this->_extcalPerm->getAuthorizedCat($user, 'extcal_cat_view'); $criteriaCompo->add(new Criteria('event_start', $monthEnd, '<=')); $criteriaCompo->add(new Criteria('event_end', $monthStart, '>=')); $criteriaCompo->add(new Criteria('event_approved', 1)); if(!is_array($cats) && $cats > 0) { $criteriaCompo->add(new Criteria('cat_id', $cats)); } if(is_array($cats)) { if(array_search(0, $cats) === false) { $in = '('.current($cats); array_shift($cats); foreach($cats as $cat) { $in .= ','.$cat; } $in .= ')'; $criteriaCompo->add(new Criteria('cat_id', $in, 'IN')); } } $count = count($authorizedAccessCats); if($count > 0) { $in = '('.$authorizedAccessCats[0]; array_shift($authorizedAccessCats); foreach($authorizedAccessCats as $authorizedAccessCat) { $in .= ','.$authorizedAccessCat; } $in .= ')'; $criteriaCompo->add(new Criteria('cat_id', $in, 'IN')); } else { $criteriaCompo->add(new Criteria('cat_id', '(0)', 'IN')); } return $this->getObjects($criteriaCompo); } function getEventYear($year, $user, $cat=0) { $userStartTime = mktime(0,0,0,1,1,$year); $userEndTime = mktime(23,59,59,12,31,$year); $yearStart = userTimeToServerTime($userStartTime, $this->_extcalTime->_getUserTimeZone($user)); $yearEnd = userTimeToServerTime($userEndTime, $this->_extcalTime->_getUserTimeZone($user)); $criteriaCompo = new CriteriaCompo(); $authorizedAccessCats = $this->_extcalPerm->getAuthorizedCat($user, 'extcal_cat_view'); $criteriaCompo->add(new Criteria('event_start', $yearEnd, '<=')); $criteriaCompo->add(new Criteria('event_end', $yearStart, '>=')); $criteriaCompo->add(new Criteria('event_approved', 1)); if($cat > 0) { $criteriaCompo->add(new Criteria('cat_id', $cat)); } $count = count($authorizedAccessCats); if($count > 0) { $in = '('.$authorizedAccessCats[0]; array_shift($authorizedAccessCats); foreach($authorizedAccessCats as $authorizedAccessCat) { $in .= ','.$authorizedAccessCat; } $in .= ')'; $criteriaCompo->add(new Criteria('cat_id', $in, 'IN')); } else { $criteriaCompo->add(new Criteria('cat_id', '(0)', 'IN')); } return $this->getObjects($criteriaCompo); }
replace with
le="color: #000000"><?php } $criteriaCompo->setSort('event_start'); return $this->getObjects($criteriaCompo); } function getEventThisDay($user, $limit, $cats) { $time = mktime(0,0,0,date("n"),date("j"),date("Y")); $dayStart = userTimeToServerTime($time, $this->_extcalTime->_getUserTimeZone($user)); $dayEnd = userTimeToServerTime($time+86399, $this->_extcalTime->_getUserTimeZone($user)); $criteriaCompo = new CriteriaCompo(); $authorizedAccessCats = $this->_extcalPerm->getAuthorizedCat($user, 'extcal_cat_view'); $criteriaCompo->add(new Criteria('event_start', $dayEnd, '<=')); $criteriaCompo->add(new Criteria('event_end', $dayStart, '>=')); $criteriaCompo->add(new Criteria('event_approved', 1)); if(!is_array($cats) && $cats > 0) { $criteriaCompo->add(new Criteria('cat_id', $cats)); } if(is_array($cats)) { if(array_search(0, $cats) === false) { $in = '('.current($cats); array_shift($cats); foreach($cats as $cat) { $in .= ','.$cat; } $in .= ')'; $criteriaCompo->add(new Criteria('cat_id', $in, 'IN')); } } $criteriaCompo->setSort('event_start'); return $this->getObjects($criteriaCompo); } function getEventMonth($month, $year, $user, $cats=0) { $userStartTime = mktime(0,0,0,$month,1,$year); $userEndTime = mktime(23,59,59,$month+1,0,$year); $monthStart = userTimeToServerTime($userStartTime, $this->_extcalTime->_getUserTimeZone($user)); $monthEnd = userTimeToServerTime($userEndTime, $this->_extcalTime->_getUserTimeZone($user)); $criteriaCompo = new CriteriaCompo(); $authorizedAccessCats = $this->_extcalPerm->getAuthorizedCat($user, 'extcal_cat_view'); $criteriaCompo->add(new Criteria('event_start', $monthEnd, '<=')); $criteriaCompo->add(new Criteria('event_end', $monthStart, '>=')); $criteriaCompo->add(new Criteria('event_approved', 1)); if(!is_array($cats) && $cats > 0) { $criteriaCompo->add(new Criteria('cat_id', $cats)); } if(is_array($cats)) { if(array_search(0, $cats) === false) { $in = '('.current($cats); array_shift($cats); foreach($cats as $cat) { $in .= ','.$cat; } $in .= ')'; $criteriaCompo->add(new Criteria('cat_id', $in, 'IN')); } } $count = count($authorizedAccessCats); if($count > 0) { $in = '('.$authorizedAccessCats[0]; array_shift($authorizedAccessCats); foreach($authorizedAccessCats as $authorizedAccessCat) { $in .= ','.$authorizedAccessCat; } $in .= ')'; $criteriaCompo->add(new Criteria('cat_id', $in, 'IN')); } else { $criteriaCompo->add(new Criteria('cat_id', '(0)', 'IN')); } $criteriaCompo->setSort('event_start'); $criteriaCompo->setOrder('DESC'); return $this->getObjects($criteriaCompo); } function getEventYear($year, $user, $cat=0) { $userStartTime = mktime(0,0,0,1,1,$year); $userEndTime = mktime(23,59,59,12,31,$year); $yearStart = userTimeToServerTime($userStartTime, $this->_extcalTime->_getUserTimeZone($user)); $yearEnd = userTimeToServerTime($userEndTime, $this->_extcalTime->_getUserTimeZone($user)); $criteriaCompo = new CriteriaCompo(); $authorizedAccessCats = $this->_extcalPerm->getAuthorizedCat($user, 'extcal_cat_view'); $criteriaCompo->add(new Criteria('event_start', $yearEnd, '<=')); $criteriaCompo->add(new Criteria('event_end', $yearStart, '>=')); $criteriaCompo->add(new Criteria('event_approved', 1)); if($cat > 0) { $criteriaCompo->add(new Criteria('cat_id', $cat)); } $count = count($authorizedAccessCats); if($count > 0) { $in = '('.$authorizedAccessCats[0]; array_shift($authorizedAccessCats); foreach($authorizedAccessCats as $authorizedAccessCat) { $in .= ','.$authorizedAccessCat; } $in .= ')'; $criteriaCompo->add(new Criteria('cat_id', $in, 'IN')); } else { $criteriaCompo->add(new Criteria('cat_id', '(0)', 'IN')); } $criteriaCompo->setSort('event_start'); $criteriaCompo->setOrder('DESC'); return $this->getObjects($criteriaCompo); }
I'm using version 2 with XOOPS 2.2.x
