PDA

View Full Version : Amount in bank for all users ?

mindbuster
04 Feb 2005, 21:47
How do i see how many points each member have in the bank ?
Link14716
04 Feb 2005, 22:51
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
mindbuster
05 Feb 2005, 01:08
I get no results when running that query :ermm:

I kinda need 1 query that shows all users amount in the bank.
Link14716
05 Feb 2005, 02:36
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
05 Feb 2005, 03:34
Yes, several members have points in the bank.
Link14716
05 Feb 2005, 03:42
There, I changed the query a bit. Try it now.
mindbuster
05 Feb 2005, 11:58
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
07 Feb 2005, 19:15
:/

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
07 Feb 2005, 21:01
You would need to forcibly remove parts of the bank script.
fly
24 Feb 2005, 17:17
There, I changed the query a bit. Try it now.
Just this gives nothing:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------


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
24 Feb 2005, 21:03
It should be stored in the bank table as well. Otherwise the table would serve no purpose.
fly
24 Feb 2005, 21:15
I dont think it does serve a purpose. Otherwise, wouldn't my SQL query have returned something?
Link14716
24 Feb 2005, 21:21
It looks like it doesn't from looking at my dev forum. I guess this would be a bug, then.
fly
24 Feb 2005, 21:43
LOL. Should have mentioned that a while ago then, when I was trying to find out where the bank data was.
Link14716
24 Feb 2005, 22:00
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
25 Feb 2005, 13:10
Sweet! Thanks man!
cashpath
03 Mar 2005, 23:43
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