J and Beyond 2013 | An International Joomla! Conference - May 31st - 2nd, 2013, Noordwijkerhout, The Netherlands
It is currently Mon May 20, 2013 1:20 am

Search: not show all event repetions

Discuss JEvents 2.x for Joomla 1.5-2.5 here - club members can use the special club forum for faster response times.
Forum rules
When requesting support, please copy and paste the 'Version information for Support Forum' from the JEvents Control Panel into your post. If you cannot see this, please enable JEvents project news within it's configuration. Also, if you get a 500 Error, Enable Joomla! Maximum Error Reporting and view the page again, you should now have a more detailed error which will help us to resolve you issue quickly.

Re: Search: not show all event repetions

Postby rianwouters » Wed Feb 27, 2013 11:11 am

Why can't I use search to find all repeats of an event?
From the discussion above I take it that there are at least 3 different search scenarios:
- only the event, only the first repeat
- first repeat + next repeat
- all repeats

To do what I want I have patched dbmodel:

Code: Select all
$query2 = ...         
          ...
          . "\n ORDER BY rpt.startrepeat ASC limit 1";


changed to

Code: Select all
$query2 = ...         
          ...
          . "\n ORDER BY rpt.startrepeat ASC";


and

Code: Select all
$data = $db->loadObject();
// belts and braces - some servers have a MYSQLK bug on the  user of DISTINCT!
if (!$data->ev_id)
   continue;
$icalrows[] = $data;


changed to

Code: Select all
$rows = $db->loadObjectList();
foreach ($rows as $data)
{
    if (!$data->ev_id)
   continue;
    $icalrows[] = $data;
}




Has anything changed on this part in later versions?
rianwouters
Posts: 5
Joined: Wed Feb 27, 2013 10:17 am

Re: Search: not show all event repetions

Postby Geraint » Wed Feb 27, 2013 11:30 am

Your code should work
------------
JEvents club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits.

Join the JEvents club today!
User avatar
Geraint
Posts: 30518
Joined: Fri Feb 15, 2008 6:14 pm

Re: Search: not show all event repetions

Postby rianwouters » Wed Feb 27, 2013 12:49 pm

Yes but why is this not the default behaviour or an optional search argument. I should not have to patch my php to do this, right?
rianwouters
Posts: 5
Joined: Wed Feb 27, 2013 10:17 am

Re: Search: not show all event repetions

Postby Geraint » Wed Feb 27, 2013 2:55 pm

It is designed to show the next occuring repeat from where you can then reach all the other repeats.
------------
JEvents club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits.

Join the JEvents club today!
User avatar
Geraint
Posts: 30518
Joined: Fri Feb 15, 2008 6:14 pm

Problems with sorting after changing dbmodel.php like Ryanwo

Postby Picannick » Thu Apr 11, 2013 2:53 pm

I am wondering too, why this is not a core feature, but whit the solution from "Ryanwouters" i get really close to a perfect solution! (Thanx for that!)

After making these changes i got problem with sorting of entrys, i don't get a list with a <tr> for each day (and all events from this day).

Now i get all repeats from the first event, after that all repeats from next event, etc...

Is it possible to reorder (and group them by day), like jevents did it before?

Thanx
Picannick
Posts: 2
Joined: Tue Aug 31, 2010 11:33 am

Re: Search: not show all event repetions

Postby Picannick » Mon Apr 22, 2013 12:23 pm

Is there nobody who can help me?
Picannick
Posts: 2
Joined: Tue Aug 31, 2010 11:33 am

Previous

Return to Jevents 2.x (Free Access)

Who is online

Users browsing this forum: Google [Bot]

Main Menu

User Menu

Hosted By


Who is online

In total there is 1 user online :: 1 registered and 0 hidden (based on users active over the past 5 minutes)
Most users ever online was 94 on Tue Sep 01, 2009 12:33 am

Users browsing this forum: Google [Bot]

Login Form