Jump to content

Need php/mysql advice, store lots of ip numbers


Trevors

Recommended Posts

Hi all,

Im runnin a blog toplist and im using evotopsite but im about to trash it cuz it pretty much blows.
So there for im writing my own but im looking for some advice how to code the tracker that tracks
unique visitors on the blogs.

This tracker (a image) stores all ip numbers in a mysql table and for each unique visitor the blog ranks higher.
So the blogs are ranked depending on the unique visitors.

So whats the best way and most optimized, i was thinking of having a a bit of code which runs once every 15 minutes and counts the unique visitors to the blog toplist which ranks em.
When it runs it flags those ip numbers that have already been counted, the ip column will be set to unique so it only stores same ip once only.

Does this sound like a good idea?


Best Regards
Link to comment
Share on other sites

the only other option i'd throw out is that if it's not an extraordinary amount of sites, you could actually "rate" them when the page loads. if you're talking about hundreds of thousands of records you're having to have SQL count up, then your idea is definitely the better option.
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.