What's the sql queries for uttpoints?

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.

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

-Reset all users points

UPDATE user SET uttpoints=X;

-Mass donate to all users

UPDATE user SET uttpoints=XXX;

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

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

Put in your template

$usergroup1[sumuttpoints]

-Clear the bank of all accounts

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.