PDA

View Full Version : need help


DeadGaze
08-07-2004, 11:27 AM
heyhey
ok i wanted to create a code that automatic change some points of all users
like doing everyday the query

$DB_site->query("UPDATE user SET replyed=replyed-1 WHERE userid='$bbuserinfo[userid]'");

but how can i let it do it automatic and to all users

thanxs in advange

nexialys
08-07-2004, 11:34 AM
to make it automatic, you can create a cronjob inside the system (/includes/cron) ... if you want it to all users, it'S mysql party:

$DB_site->query("UPDATE user SET replyed=replyed-1");
simple... if you don't specific the userid, ALL users will be set...

DeadGaze
08-07-2004, 11:47 AM
hmm cronjob
i think ya mean vbulletin gold ore higher
i dosnt have that yet iam still running on 2.8 i believe
dont ya know how i can do it in global.php ore something

thanxs

Colin F
08-07-2004, 12:02 PM
you would have to implement some kind of mechanism to check if it already executed the query, and if not to execute it...