I am looking for someone that can write a PHP script to do the following:
1. Copy the server details from here to a MySQL database table: [login to view URL]
2. The only columns I would like added from this file to the table are: HostName, IP, Ping, Speed, CountryLong, CountryShort, OpenVPN_ConfigData_Base64
3. If the speed is 0.00 Mbps OR if the ping is '-' the server should not be included in the list.
4. I would also like a custom hostname to be inserted at the front. This hostname should change for each server and should be CountryShort-VPN-Count. For example: US-VPN-1, US-VPN-2, RU-VPN-1
5. I will be running this script across 15 - 20 servers and combining all discovered servers into this same database table. As a result, when the script runs on each server, the new information should overwrite the information that that server last passed to it. For example: Server 1 will insert servers into the list, 15 minutes later (when it runs again) it will remove the previous servers and import the new list.
6. If two different servers find the same server information, the script should not write the server information a second time - the script will ignore this as it already exists.
Please let me know a time frame and price for this work. Please only apply if you have a good understanding of the English language.
29 威客就此工作平均出价 $45
Respected Sir, We have 7+ year exp in php and wordpress. We have expertise in content management system in wordpress. Relevant Skills and Experience MYSQL,PHP Proposed Milestones $30 AUD - Project
Hi there! Looking forward to solve this for you. I have done similar scripts recently. Hope to hear from you. Regards. Relevant Skills and Experience php, mysql Proposed Milestones $55 AUD - finish project