The Arcive of vBulletin Modifications Site.

What's the sql queries for uttpoints? · **Released**: 12-09-2005

Ok,a reference thread for myself and all.Anyone have any other useful queries to add in too?I mean,those really common ones that everyone was asking about?Please help and post some in,Thanks

Found some queries myself.......

-Donate amount to a specific usergroup.

Code:

UPDATE user SET uttpoints=uttpoints+X WHERE usergroupid=Y;

-Reset all users points

Code:

UPDATE user SET uttpoints=X;

-Mass donate to all users

Code:

UPDATE user SET uttpoints=XXX;

-Display total points held by a usergroup
Put in index.php

Code:

$usergroup1=$DB_site->query_first(" 
SELECT SUM( uttpoints ) AS sumuttpoints 
FROM user 
WHERE usergroupid = '10' 
");

Put in your template

Code:

$usergroup1[sumuttpoints]

-Clear the bank of all accounts

Code:

DELETE FROM utt_store_bank;
UPDATE user SET uttstore_bankdata='';

I found all of the above by going though these 18 pages.If there's any wrong with any of these queries i found,please correct me.Thanks alot guys.