62325 Classified Ads Script Changes

Hi I have the Classified Ads Script from [login to view URL] and I need some changes to it. 01. When the customer posts a classified ad, down at the bottom for the FEATURED option and the EXTENDED option, please show the country corrected price in the dropdown so that people will know what they are being charged. 02. Add a template for a new email to be sent when the ad is about to expire. I would like the system to send an email at 7 days before expiration and a final email 2 days before expiration. 03. On the classified site you can set the number of columns displayed in the config file. However the program automatically decides to put an equal number of categories in each column. I would like to decide which categories go in which columns. 04. CUSTOMER MANAGE ADS CHANGE A1. Add a customer selected password field to each ad submission in the ad posting screen (free form text field) This makes each ad unique. A2. Add this password field and all other personal details to the email that the customer receives A3. Create a login box on the front page : email address and password associated with each ad submission. Both are required. This goes on the left side of the front page under POST IMAGE A4. The new screen code can be copied from the administrators MANAGE ADS screen. It will show every classified ad associated with the email address and password A5. The new screen will have search capability the same as the current admin screen for "manage ads" A6. The new screen will have a line item for each classified ad showing details for the ad like the manage ads screen. A7. Each line item will also have a dropdown field showing all possible payment selections for EXTENDED AD A8. Each line item will also have a dropdown field showing all possible payment selections for FEATURED AD A9. The new screen will have a selection checkbox for each ad. A10. When the SUBMIT button is pushed, the total cost for ALL ad extensions or features checked are calculated A11. The total is presented along with credit card inputs for Paypal and ECHO (copy existing code) A12. After payment is complete the paid for ads have their expiration dates extended according to what they have paid A13. The screen is redisplayed with the newly updated ads showing the updated expiration dates A14. This ad screen should have the [login to view URL] file and the [login to view URL] included so that all paid advertising also displays on it. ------------------------------------------------------------ 05. Goal - Prevent Internet Marketers from flooding the system with millions of duplicate ads from the same person. B1. Ad Posting Security - Before post - Parse classified ad message and extract email addresses, domain names, phone numbers from ad. Change all email addresses in message to spaces (email addresses are not allowed in ads) Create one table of email addresses (from personal info input) in all classified ads (cleaned every XX hours) Create one table of domain names in all classified ads (cleaned every XX hours) Create one table of phone numbers in all classified ads (cleaned every XX hours) Create one table of message titles in all classified ads (cleaned every XX hours) Using the tables: Set limit of number of classified ads posted per time period by any EMAIL ADDRESS (personal details) Set limit of number of classified ads posted per time period by any DOMAIN NAME in message Set limit of number of classified ads posted per time period by any PHONE NUMBER in message Set limit of number of classified ads posted per time period by any MESSAGE TITLE The time periods are set from the admin screen If the ad is determined to be in violation of the set parameters, send the "ad posted" screen AND the email verification BUT do not post the ad. [login to view URL] Searching Security - Set limit of the number of requests per IP ADDRESS per time period (stop email harvesting) The limit & time period is set from the admin screen. B3. Ad Management Security - Any ad that is not verified within a set time period (minutes) is automatically deleted fromthe database. The time period is set from the admin screen. B4. Input data security - Insure that all input data (classified ads, personal data, location, etc)only accepts Upper Case, Lower Case, and Numbers numbers to prevent SQL Injection attack. 06. This script may or may not correctly cleanup the database AND directories when a classified ad expires or is cancelled. Verify that it does a proper cleanup. Add code if necessary. 07. Upper and Lower Banner Ad space - I have an adserver called AdsDX 3.05. I need an area added to the upper header and lower header so I can insert ads in the system. I will send the adserver for you to test with. All changes must be commented in the code. All program and database changes must be described in a text file. What modules changed, etc All database changes must be supplied in an SQL file that I can run against an existing database WITHOUT hurting any existing data. ESTIMATE TIME IS 8 TO 10 HOURS