I have a script I would like modified to include extra functionality. I've a MySQL db that stores website stats. One table in the db stores the visitors 'user agent' & IP. Another table stores IP's of known search bots. The script looks for defined strings in the 'user agent' field and if found, it then checks the IP of that entry against the bot table. All IP's that aren't matched i.e. 'unknown', are printed out to a web page in table format. Each entry has a hyperlink which allows me to run a manual RDNS without having to input the IP. If after a manual check the IP is found to be a bot, I add it to the bot table. The draw back of this is that the script doesn't keep track of IP's that were manually checked & found not to be bots. This causes those entries to be re-displayed the next time the script is run. So the solution is to have another table created that will store these IP's. This table would then also be checked for matching IP's the next time the script is run. If a match is found, it would not be printed out. i.e. the logic would be: If new_IP != bot_Ip & != prev_checked_IP then print. The other function I would like is for the script to automatically run a RDNS & parse the returned result & print that to the page. There are a couple more items I require, but these are mainly cosmetic in the outputting of the results. Please reply by PM with a time frame to have the script re-written & estimated cost. If you need further info, please ask. Only apply if you very competent in PHP & MySQL.
I can do this for $40. 3 Years php/mysql/html experience, good iTrader you can check for previous feedback.