PDA

View Full Version : Amount in bank for all users ?

mindbuster
02-04-2005, 07:47 PM
How do i see how many points each member have in the bank ?
Link14716
02-04-2005, 08:51 PM
SELECT bank.*, user.username FROM utt_store_bank bank LEFT JOIN user user ON (user.userid=bank.userid);
mindbuster
02-04-2005, 11:08 PM
I get no results when running that query :ermm:

I kinda need 1 query that shows all users amount in the bank.
Link14716
02-05-2005, 12:36 AM
Well, I can't test that further, since no one has anything in the bank where I tested it. ;)

Are you sure there is someone with anything in the bank?
mindbuster
02-05-2005, 01:34 AM
Yes, several members have points in the bank.
Link14716
02-05-2005, 01:42 AM
There, I changed the query a bit. Try it now.
mindbuster
02-05-2005, 09:58 AM
Still no worky :/

Also need a way to put all members bank points back in their pocket so i can close the bank.

I wanted the above as security, to have a list of what the members had in bank before closing it down.
mindbuster
02-07-2005, 05:15 PM
:/

umm, how about this then....

Where can i remove the link "Deposit" so only withdraw is left, so ppl only can withdraw but NOT deposit ?

thnx
Link14716
02-07-2005, 07:01 PM
You would need to forcibly remove parts of the bank script.
fly
02-24-2005, 03:17 PM
There, I changed the query a bit. Try it now.
Just this gives nothing:

SELECT * FROM utt_store_bank;
iirc, its stored in an array in the user table, not in the utt_store_bank table...

edit: yeah, its in uttstore_bankdata in the user table, but I have no idea how to get it out of an array. LOL
Link14716
02-24-2005, 07:03 PM
It should be stored in the bank table as well. Otherwise the table would serve no purpose.
fly
02-24-2005, 07:15 PM
I dont think it does serve a purpose. Otherwise, wouldn't my SQL query have returned something?
Link14716
02-24-2005, 07:21 PM
It looks like it doesn't from looking at my dev forum. I guess this would be a bug, then.
fly
02-24-2005, 07:43 PM
LOL. Should have mentioned that a while ago then, when I was trying to find out where the bank data was.
Link14716
02-24-2005, 08:00 PM
I guess this just shows how much that table is used. ;) It is useful when trying to query for what users have in their bank, but pretty useless otherwise. I'll fix the bug and alter the table a little bit, and in the upgrade to 1.00, populate the table from the uttstore_bankdata field in the user table.
fly
02-25-2005, 11:10 AM
Sweet! Thanks man!
cashpath
03-03-2005, 09:43 PM
So is it true that once that is fixed and 1.00 comes out there will be not only a way to see what all users have in the bank but also it would then be possible to see the actual amount (Bank+Pocket) in the richest member section? ANy timeframe on when 1.00 will be released?

Thanks, love the Hack BTW