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.
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
by 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:
changed to
and
changed to
Has anything changed on this part in later versions?
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
by 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!
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!
-

Geraint - Posts: 30518
- Joined: Fri Feb 15, 2008 6:14 pm
Re: Search: not show all event repetions
by 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
by 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!
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!
-

Geraint - Posts: 30518
- Joined: Fri Feb 15, 2008 6:14 pm
Problems with sorting after changing dbmodel.php like Ryanwo
by 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
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
by 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
16 posts
• Page 2 of 2 • 1, 2
Return to Jevents 2.x (Free Access)
Who is online
Users browsing this forum: No registered users

