Jump to content

Recommended Posts

I have a text log that stores IP addresses for a poll, but I want to dump it everynight at midnight, and start fresh.  I have been doing it manually for about two weeks.  Is there a way it can be done automatically?

You can run a cron job.

 

Not particularly easy to get running (still cause me headaches even now) but they're definitely the way to go to have a script or scripts run at regular intervals.

 

http://en.wikipedia.org/wiki/Cron

If you don't want to use a chronjob, you can create a column that stores a date. Then store the date of the most recent time at which the IP table was cleared. Then everytime someone accesses the site, check that date. If it's still the same day, then do nothing. If it's from the day before, clear the IP table, and replace the old time with the current time.

BTW if anyone looks at this post in the future I would HIGHLY recommend making the PHP file that does it some random named document.  Not something stupid like erase.php

Or you could set a GET variable and make it trigger if that get variable isset and is equal to what it should be.

 

For the actual value I would make an md5 hash of something. That way it could be erase.php but without that variable it will not run.

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.