Make sure the script isnt run twice in a set time

[PRSBOY]

i have created a script, but, i dont want it to be run twice within a set time.

I have created a feild in the db to input get_time_date() and i believe i can use this to add a security feature to add days onto this to make sure it isnt run before xx time.

How would i go about this?

im confused 😛

[nemonoman]

Create a table

scriptRun

scriptName
lastRun

=========
lastRun should be a DATETIME column

When you run the script:
UPDATE scriptRun
SET lastRun=NOW()
WHERE scriptName='ScriptToRun'

BEFORE you run the script

SELECT count(*)
FROM scriptRun
WHERE scriptName='ScriptToRun'
AND lastRun< NOW()-INTERVAL 1 DAY

This will return a 0 or 1 depending on whether the script has been run in the interval stated.

or
NOW()-INTERVAL 14 HOUR

etc...

[PRSBOY]

thats all good, but, i need it to check each user in the db

i have a users db and a column for "lastwarn", this needs to be checked every time the script is run.

If the user was only warned a day before, it will skip them and not...