Eventlist reg users plugin

works just fine!... Love it.. Just have to prettyup Eventlist now.. but its all cool

hey, cool plugin!

thx!!

but i have one question.
how can i show only events in the future?
old events are not interesting on my site.

where can i download the plugin plug_eventlist_reg.zip? The link is broken!

Thanks!

work perfect tested on CB 1.1 Joomla 1.0.15 event list 0.8.12 alpha
thank you! try to see if some new functionalities could be included as direct subscription or un form the tab

I have change the code of eventlis_reg.plugin.php - Replace with the original and only events in the future will shown - exactly only events they are published, but i think that you archive your events in a few days...

the code was changing on line 54 from

$query = "SELECT r.rdid, r.uid, s.titel, s.dates, s.locid, l.club, l.city"
. "\n FROM `#__eventlist_register` r,"
. "\n `#__eventlist_dates` s, `#__eventlist_locate` l"
. "\n WHERE r.uid = ".$user->id .""
. "\n AND r.rdid = s.id AND s.locid = l.id"
. "\n ORDER BY s.dates"
. "\n LIMIT 5";

TO

---

$query = "SELECT r.rdid, r.uid, s.titel, s.published, s.dates, s.locid, l.club, l.city"
. "\n FROM `#__eventlist_register` r,"
. "\n `#__eventlist_dates` s, `#__eventlist_locate` l"
. "\n WHERE r.uid = ".$user->id .""
. "\n AND r.rdid = s.id AND s.locid = l.id"
. "\n AND s.published = 1 "
. "\n ORDER BY s.dates"
. "\n LIMIT 5";

Post edited by: embasic, at: 2008/04/18 14:38

Post edited by: embasic, at: 2008/04/18 14:39

embasic wrote:

I have change the code of eventlis_reg.plugin.php - Replace with the original and only events in the future will shown - exactly only events they are published, but i think that you archive your events in a few days...

the code was changing on line 54 from

$query = "SELECT r.rdid, r.uid, s.titel, s.dates, s.locid, l.club, l.city"
. "\n FROM `#__eventlist_register` r,"
. "\n `#__eventlist_dates` s, `#__eventlist_locate` l"
. "\n WHERE r.uid = ".$user->id .""
. "\n AND r.rdid = s.id AND s.locid = l.id"
. "\n ORDER BY s.dates"
. "\n LIMIT 5";

TO

---

$query = "SELECT r.rdid, r.uid, s.titel, s.published, s.dates, s.locid, l.club, l.city"
. "\n FROM `#__eventlist_register` r,"
. "\n `#__eventlist_dates` s, `#__eventlist_locate` l"
. "\n WHERE r.uid = ".$user->id .""
. "\n AND r.rdid = s.id AND s.locid = l.id"
. "\n AND s.published = 1 "
. "\n ORDER BY s.dates"
. "\n LIMIT 5";

Post edited by: embasic, at: 2008/04/18 14:38

Post edited by: embasic, at: 2008/04/18 14:39