Random Group Sort & Store Hack Thing Request

[VirtualHogwarts]

You helped him with this and I am sure your help was right but where should we put it and can you be a little more detailed to it?

What i got from it is you put this ...

$group=$DB_site->query_first("SELECT SUM(money) AS summoney FROM user WHERE usergroupid=XX")

in store.php somewhere? (but where)

and then change the XX to the usergroup you want to total their points right?

then in a template or whereever in the vB put ...

$group[summoney] and it will what? show all their points put together?

So you could do

Group 1: $group[summoney]
Group 2: $group[summoney] ... ahh ha! Problem .. its only 1 userid so i figured ...

back to this ...

$group=$DB_site->query_first("SELECT SUM(money) AS summoney FROM user WHERE usergroupid=XX")

lets say the usergouws were ... 8 9 10 and 11

$group=$DB_site->query_first("SELECT SUM(money) AS gryffindors FROM user WHERE usergroupid=8")

$group=$DB_site->query_first("SELECT SUM(money) AS slytherins FROM user WHERE usergroupid=9")

$group=$DB_site->query_first("SELECT SUM(money) AS ravenclaws FROM user WHERE usergroupid=10")

$group=$DB_site->query_first("SELECT SUM(money) AS hufflepuffs FROM user WHERE usergroupid=11")

put them somewhere in store and then ... put

$group[hufflepuffs]
$group[ravenclaws]
$group[slytherins]
$group[gryffindors]

right??? or what please either PM me back or reply! Thanks!