I purchased a open source application for classifieds, because I did not want to reinvent the wheel. I now almost wish I would have reinvented it. Here is the problems that I am needing to deal with and maybe I can just get a little advise on how to proceed. Keep in mind that everything is tied togther pretty well, and variable naming conventions are terrible at best. IE: <cfinput type="text" name="S01">This is a search field</cfinput>.
1. The application is set-up to where a buyer cannot sell and a seller cannot buy. A client would have to set-up 2 seperate accounts in order to do both. This will do nothing but piss people off. I need to make it where clients can either buy or sell when they register. I have 2 seperate folder, one for buyers and one for sellers and each has different login pages etc. 2. Currently the application uses a database to store the cart content (Which is fine). The weird thing is the way it is set-up. A client who wishes to place an ad has to buy a subscription service and pay for their ad before being able to place it. I need to change this to where the client logs-in places their ad and then checks out. I would not like the idea of paying for my food at a restaraunt before I was able to eat it. :) 3. The application has queries that are in the CFC's and lines are anywhere from 200 lines to 600 lines and not a single query is using <cfquerparam> The app does have it's good points. It has pleasing asthetics and a nice back-end mgt system for managing ads and clients. You also have the ability to change the overall look and feel through the admin section. Anyway any help on where to start fixing this thing is appreciated. I am flustered beyond belief. Doug ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262585 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

