Adam21
12-09-2005, 10:06 AM
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.
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.