The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Help with a cron script needed.
Hi,
I need a cron script for my website. I know what I want the script to do, but as I am not a coder I need help writing it. It will be dealing with two tables: "adv_links" and "adv_links_cfields_entries". There is a column in adv_links named "linkid", one named "dateline" and another named "valid". In the adv_links_cfields_entries the relevant columns are "lid" and "field5". "lid" in adv_links_cfields_entries will be == "linkid" in adv_links So what I need is for the scipt to do: look in the adv_links table for rows where valid=0 find the corresponding row in adv_links_cfields_entries where field5=approved out of these (valid=0 AND field5=approved) find the one with the oldest dateline and then Update that one row - valid=1 and dateline=TIMENOW I hope all of this makes sense. Cheers, Ian |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|