Location search and community tools?
Posted: Tue Aug 14, 2007 1:09 pm
Hello
I am a fairly competent non-web programmer who has volunteered to extend a Charity's website. It's a smashing and unique little charity which recieves no funding. We can't find an experienced web programmer to do this and its down to this old slave to corporate telephony api's to try my best. Being new to the web and open-source I am looking for feed back about what might be possible, and how I might best proceed.
What we have now
A php5 website with public pages and a limited members area. A mysql db holds various tables supporting detailed membership records/attributes, login etc.
What we want
We would like to add some community areas for members by location. That is, we would like members to select a region (of the real world i.e London) and see a forum, a calender and a list of members, all relevant to the selected region.
The charities membership is currently European wide but in theory anyone from anywhere in the world might join. Any solution must be hosted on our server, and be customizable in looks and must be secure. It must use our existing members tables. The solution must be free or very cheap.
I imagine a system which stores a location with everything, every forum thread and calender entry, etc. A user can search with a varying distance form any location (ie within 1 mile, 10 miles etc) and see a forum, members and calender containing data that falls within the location scope. Like combining an estate agents location functionality but displaying a calender, members and a forum instead of houses. To achieve this I am, maybe optimistically, hoping I might be able to combine something like the google api with some already available community tools.
The idea of a location based forum might just be too much and too db intensive - but I thought I'd put it out there - it could work by associating a location with each thread but it could easily become a quagmire. Location based calender and members searches seems a more reasonable first stage. But I have no idea what mechanisms are available to store queriable locations in the db. How smart can this location stuff be for free? What choices do I have using php/javascript?
Also, what existing community tools/scripts is it worth me looking at, that might be adapted to suit my needs?
Apologies that my questions might be daft and please tell me if you think I am looking at this all wrong. Thanks in advance for any responses.
Phil
I am a fairly competent non-web programmer who has volunteered to extend a Charity's website. It's a smashing and unique little charity which recieves no funding. We can't find an experienced web programmer to do this and its down to this old slave to corporate telephony api's to try my best. Being new to the web and open-source I am looking for feed back about what might be possible, and how I might best proceed.
What we have now
A php5 website with public pages and a limited members area. A mysql db holds various tables supporting detailed membership records/attributes, login etc.
What we want
We would like to add some community areas for members by location. That is, we would like members to select a region (of the real world i.e London) and see a forum, a calender and a list of members, all relevant to the selected region.
The charities membership is currently European wide but in theory anyone from anywhere in the world might join. Any solution must be hosted on our server, and be customizable in looks and must be secure. It must use our existing members tables. The solution must be free or very cheap.
I imagine a system which stores a location with everything, every forum thread and calender entry, etc. A user can search with a varying distance form any location (ie within 1 mile, 10 miles etc) and see a forum, members and calender containing data that falls within the location scope. Like combining an estate agents location functionality but displaying a calender, members and a forum instead of houses. To achieve this I am, maybe optimistically, hoping I might be able to combine something like the google api with some already available community tools.
The idea of a location based forum might just be too much and too db intensive - but I thought I'd put it out there - it could work by associating a location with each thread but it could easily become a quagmire. Location based calender and members searches seems a more reasonable first stage. But I have no idea what mechanisms are available to store queriable locations in the db. How smart can this location stuff be for free? What choices do I have using php/javascript?
Also, what existing community tools/scripts is it worth me looking at, that might be adapted to suit my needs?
Apologies that my questions might be daft and please tell me if you think I am looking at this all wrong. Thanks in advance for any responses.
Phil