Completed

Optimize a PHP page (PHP/MySQL)

Hello Freelancers,

I run a filesharing website and need some minor optimisation to the file serving page. Nothing major if you know your PHP and MySQL.

To sum it up:

I use a JSON to get the IP address of the visitor and if the visitor is from country X, reward the file owner with X amount of points.. Country Y = Y amount of points etc etc.

This system is in place and works like a charm. Now I want to alter the code to only award those X or Y points for a unique IP download.

How to do this? By checking if the IP of the visitor is in the "downloads" table... If it is, award no points. If the IP is not found in the downloads table, add the points and then add the IP to the downloads table.

The "downloads" table will be trunicated every X hours so no worry about timestamps and such...

I offer 23€ for this quick job. (takes 10 min if you got it.)

If you understood this text, post your offer.. Do not post auto-offers, they will be ignored.

Thanks!

Skills: MySQL, PHP

See more: post a job freelancers, offers for php freelancers, mysql freelancers, how freelancers website works, freelancers php mysql, optimize php mysql apache cakephp, insert data php mysql page, joomla php force download mp3 mysql, download mysql file zip php, page search php mysql, populate web page database php mysql, login page ajax php mysql, web page authentication php mysql

About the Employer:
( 9 reviews ) Garching b. München, Germany

Project ID: #8237354

Awarded to:

coolguyinus2004

ready now i need ftp and cpanel access for this work. 11+ years of experience in programming PHP/MYSQL/API/WEB SCRAPING/DEBUG EXPERT/ANY KIND OF FIX IN [login to view URL] PHP CODING You can check my profile for my reputation More

€23 EUR in 1 day
(340 Reviews)
7.6

7 freelancers are bidding on average €25 for this job

arcdevsol

Hey, i understand - It's just a bunch of if else calls - Can complete it in the next hour :) Let me know if you have any questions.

€23 EUR in 3 days
(126 Reviews)
7.4
HiFiDesigner

I will do this ip related php job. We need to compare visitors ip to ip table in database. I am available to start this job right now. I am currently online please contact me via freelancer.com chat. For the time be More

€23 EUR in 1 day
(248 Reviews)
6.8
anamaria1979

Propunerea nu a fost încă furnizată

€29 EUR in 0 days
(155 Reviews)
6.6
rana100

Dear Sir, I am a professional developer in the following languages; PHP, MYSQL,Wordpress,Javascript, CSS, Boostrap, responsive design. I have 10 Years experience in Programming and can show with a portfolio. I als More

€27 EUR in 3 days
(27 Reviews)
5.2
endlesssloop

I have long experience in PHP and MySQL, and almost get Your request. I can start on this project right now. Fill free to contact me to discuss. Thank You. Best Regards

€23 EUR in 0 days
(0 Reviews)
0.0
MegaSoftIT

Hello, we are so sure that we will do your job, your description of the problem was so clear. we have some questions for you about the problem. Best Regards

€27 EUR in 3 days
(0 Reviews)
0.0