The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Custom Scheduled Task - Looping through users in a usergroup
Right, i've now made a subscription in accordance with the Coins i recently added thanks to some of the guys here.
But, there are quite a few subscriptions and i don't exactly want to manually add coins to each member in every subscription group. So, im making some Sceduled Tasks, but i need to know a method that loops through every member in usergroup id x and does actions. Thanks in advance. |
#2
|
||||
|
||||
[sql]
$uquery = $db->query_read("Select userid from user where usergroupid=something); while ($users = $db->fetch_array($uquery)) { do_somthing($users[userid]); } [/sql] Alternatively, if it is exactly the same thing you want to do to every user... [sql] $db->query_write("Update user set coins=something where usergroupid=something") [/sql] |
#3
|
|||
|
|||
I'm not familiar with the coin subscriptions, but finding members of a certain usergroup, modifying their accounts, and continuing to the next is fairly generic.
You'd need to create a query that accurately describes the users you want $myusers = $vbulletin->db->query_read(" SELECT userid, (... etc) FROM " . TABLE_PREFIX . "user WHERE usergroupid=2 (or whichever group you want) "); then just: while ($myuser = $vbulletin->db->fetch_array($myusers)) { do your thing } I'd recommend downloading a few different scheduled task add-ons and examining their code to get a better understanding of how to accomplish your goal. A bit of time with some example code and a test installation of your board, and you should have a working script in short order. Hope that helps. |
#4
|
|||
|
|||
Thanks alot guys, just what i needed.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|