[Freerealty] Upsoming feature(s)

[Patrick Fleming]

Hey all,
Recently in working with a live site I discovered something interesting. 
When an agent who had listings leaves the firm, the listings remain. 
While there is nothing wrong with listings remaining on a site, there 
are queries that cause the listing to never be shown. Right now, a 
listing without an agent still cycles through the featured code but 
clicking on the image results in a failed query. ie you can never view 
the listing if the query doesn't find an agent since it is a joined 
query. For now, one 'fix' that I am working on involves a warning of 
sorts at the top of the admin/admin.php page which gives a link to the 
listing that needs to be fixed. Additional options would be to email the 
  broker for an office, but that would require some other additional 
work and may not always be the best solution (eg. when there isn't an 
'office' or broker as in fsbo sites)

Check out the listing by logging in here:
http://www.rwcinc.net/freerealty/demo/admin
demo_user/demo_password

Don't worry about messing this listing up- I have the db updated every 
20 minutes to add the 'offending' listing back in...

Other ideas? I'm open... let the list crank back to life ;)




Patrick Fleming,
Lead developer Free Realty.

PS- in case no one noticed, Jon is getting back to development of the 
original code that we forked from.
http://jonroig.com/freecode/phpBB/viewtopic.php?t=1440