I'm working on a renewal of Fajn.si and for this I'm using Joomla 1.5 and events extension written by Schlu.

I want to enable venue owners ability to insert their places by them selves.

Original EventList component has cities inserted in venues table as a string. And that is bad. Bad because of two things. Sooner or later users will insert inconsistent city names for their venues. And second argument is that city sorting can become slow when we have large number of venues. Large number for mysql indexed field should start with thousands if not ten or hundred thousands records so don't panic :) But still this is not proper database design and normalization.

Since I was working for an end client (myself) I didn't packed things together and they can not be installed trough administration interface of Joomla. At ooaykac (EventList forums) request I put mysql dump and files into a zip and you'll have to hack them manually.

To do so I recommend to use comparison software as BeyondCompare (google it - but unfortunately is not free -  however I believe there are tons of free alternatives). First install EventList extension and then compare it with my files to see differences. You should change database as well. Add cities and country table and add cityid filed to venues.

Beside cities and country adding I also added fields for GPS coordinates. In my experience coordinates are much more reliable (and I belive faster too) then address searching on Google maps.

Public part is not finished yet but I'm working on it. Check here in few weeks for further progress. If you have any questions please leave it as a comment below. I'll try to answer them as soon as possible.

If anyone creates installer out of this code, please let me know :) If you hack additional code, please let me know.


btw - any back-linking to my site would be appreciated ;)

Administration area

#1 download location - please use this one  
#2 download location
#3 download location

Component

#1 download location - please use this one  
#2 download location

Module

#1 download location - please use this one  
#2 download location

My critique on EventList by Schlu

It's free software and Schlu put many hours of work into it I'm sure. And I am thankful that he shares code with rest of us.
However there are some things that bother me.

Filters and lists for example. I don't know why they are done in each view separately when it is obvious that this should be done in a single place and then included where necessary!




UPDATES:

27. 12. 2008 - since problems with downloading have been reported I added third download mirror
28. 12. 2008 - started on frontend developement ... problems with duplicated filters and lists described at "My critique on .."
31. 12. 2008 - component and module modifications available for download

December 16, 2008     

...

I realy liked what you did. I installed it and tested. It will be nice after it done. Just, I mean, countries table is not neccessary. Because this is an event component. people don't look event in other countries. Only for one country we can use this component. that's why, it would be better if you can't delete countries. I don't have much knowladge about php but I can do something. I will be waiting your next. Orçun

Orcun | 78.163.62.217

December 16, 2008     

...

by the way , can you reupload it?
Orcun | 78.163.62.217

December 16, 2008     

use #2 location if #1 not available

use #2 location if #1 not available
Miha Trtnik | 193.77.156.218

December 16, 2008     

it depends in what context this is used

Hey! I'm glad you like it. About countries it depends in what context you use this component. Still this should be a proper way to manage countries in the database. Countries however should not be deleted if cities are linked to them. And cities should not be allowed to be deleted if there are venues linked to them. If this is not the case, I must have made a mistake and I'll look at it next week when I get home. Hope guys at schlu.net will take a look at this modification as well and implement it at future releases of event list. till next week, Miha

Miha Trtnik | 193.77.156.218

December 20, 2008     

...

hi Miha. there is no downloadable link. check it please.
orcun | 78.163.54.74

December 20, 2008     

...

I need your files again
orcun | 78.163.54.74

December 27, 2008     

...

hi, what about eventlist:) ? did you do frontpage of eventlist?
Orcun | 78.163.58.243

December 30, 2008     

...

hi Miha, nice to see you again. İt would be great.I have been waiting for the completed version. did you do some new modifications?
orcun | 78.163.58.243

January 05, 2009     

...

hi miha. how is going the modification? :) did you do front end venue add page? we will be realy happy....
orcun | 78.167.36.43

September 16, 2009     

reg checker with countries and cities integrated ?

Why not do this for Joomla user management? or for CB 1.2.1 so it could be used everywhere for many reg processes etc all the best!
ssnobben | 83.251.210.81

November 22, 2009     

Installation?

Hi, Thank you so much for writing/coding this!! I really appreciate your time and efforts you put in. A couple of queries about installing the same: 1. Should I download only the first package or all the three packages to enable selecting by cities possible? 2. I downloaded all the three packages. Which folders should I manually overwrite? A Read Me file would have been great. I can run the MySQL script. Thanks a lot! Awaiting your reply, Praveen.

Praveen | 117.192.9.202

December 20, 2009     

Public Part ?

Hi Miha, any luck with the public part? Would appreciate if you can do that! - Praveen.
Praveen | 117.192.28.233

December 22, 2009     

event list project is closed

Hi! Since my client terminated his order I have no intentions to finish this addon. Unless someone else offers to pay for the work ... :)
Miha Trtnik | 193.77.156.218