PDA

View Full Version : scheduled queries

kyrenator
05-28-2009, 07:35 AM
How can i make the vb to run a query every 2 hours?

the query i want to run is:
UPDATE post
SET showsignature = 1
Biker_GA
05-28-2009, 07:38 AM
Create a .php file that will run the query, then add it to your scheduled tasks via AdminCP. :)
Michael.A
05-28-2009, 07:42 AM
what ever he said, but idk about that .php file what is it for anyway??
Biker_GA
05-28-2009, 07:47 AM
Look in your includes/cron folder in your forum installation. Those are the .php files used to run your cron jobs (scheduled tasks) within vBulletin.
kyrenator
05-28-2009, 07:50 AM
what should i write into the php file?
Michael.A
05-28-2009, 10:58 AM
thank's Biker_GA i didnt know that.
Lynne
05-28-2009, 12:10 PM
Why do you want to run a cron job to show signatures in posts every two hours? It seems to me if you are having some sort of problem, you should fix that problem at the source.