PHP script

I have tabel named " ap_referral_traffic ", in this tabel i have the fields: id, affiliate_id ip, cpc_earnings, datetime. (USER ID IS " affiliate_id"). First Script for specific id – that will taken from previous page ling with $id = $_GET['id'] command; 1. Counting all Duplicate ip's FROM "ip" field 2 Show ALL duplicate ip – example – [login to view URL] : 8 TIMES [login to view URL] all duplicate including the first ip (129.20….) - 1 duplicate ip = 0.30, for example 8 duplicate ip's is 2.4. 4. Collect and calculate in the same way an invalid IP address beginning with 1 number only. example : 5.120.20.30. 4. Update balance field in ap_members tabel with the new balance example : balance filed have 100 and now 97.6 user id in this tabel is id and not affiliate_id 5. Delete all fields duplicate ip's from specific user id (, affiliate_id) in ap_referral table second script the only difference is instead of counting only specific id, this will run on all users Proper code writing and clean code is required An explanation of the actions is required