WoD Treasury Tracking

[Curiousity]

Hi WoD folks! I have admired the way you have been handling the tracking of the potion fund, and I would like to set up something similar for Open Hands clan funds. After the last chaos storm, we finally regained access to our clan bank account! The fix mentioned in the 'what's new' for 191 is a direct result of my efforts to finally resolve this matter for our clan. Others had tried, and we had submitted /bug reports about 2-3 months ago but nothing happened. I finally took up the problem myself last week. I sent an e-mail to Joe asking for explicit instructions to remove a non-clan member as treasurer and got a response from Ann with explicit instructions. Step 1 was to get Suu'ub to bump the assistant manager, but we had tried this MANY times before. I replied telling Ann as much. Still, it had been a few versions since we tried, so I found Suu'ub and we tried to follow them but got a text log showing that step 1 was indeed broken. I sent this to Ann as well. I got no acknowledgement that DT was looking into the problem, though, until I saw the 'what's new' for 191 :(.

[Kiriel]

Glad to see that helped you. We still want to remove a clan member that we haven't seen in ages from our treasurer list, but we've been unable to do so. They tell us we can do it by removing him from the clan, but it turns out you can't remove someone from the clan who isn't in the lands, so we're just hoping right now that his account doesn't get sold, and I'm periodically bugging Ann about it, but she seems unsympathetic.

Regarding the treasury tracker, I'd be happy to give you guys the code I wrote for it, but to use it you'll need a server to run it on that supports PHP and MySQL. If you don't have one, you could probably write your own using Perl and a flat file, but you'll definitely need some sort of server side scripting. Let me know if you want me to send you my files for it.

[Aerick]

I was so excited by the 'whats new' treasury fix. Rushed right over to the bank, I was one of the first 10-15 people on after the storm, and it didn't do what we needed. When the assistant manager got all haughty with me, I gave him a piece of my mind, but he just wouldn't help. *sigh* I do hope the situation gets resolved.

[Erasmus]

Hi guys,

All went well, was a little while out of the lands. But I'm back. Curi told me about your fabulous tracking system. I use PHP + PostgreSQL but with a few adjustments that could easily be done. I'm interested in the code to be used for Open Hands and maybe I could help you also with a few ideas :-)

Regards,

Erasmus.

[Kiriel]

Sounds good Erasmus. Welcome to our messageboard! Just let me know what address to send the files to and I'll mail over a copy and an example of the database structure. Shouldn't be hard to port- it was originally in PostgreSQL but personally I prefer MySQL.

[Aerick]

Kiri, do you think you could integrate bank fees into deposits more cleanly? So the form doesn't need to be filled out twice, but still logs the deposit for its full value? Would be a nice convenience, but not critical. What we have now works well enough.

[Althus]

The problem with that is that it's a bit unclear exactly how the rate drops as the deposit increases, so it would be tough to get enough data points to make it worthwhile without wasting a lot of money.

[Konoko]

would it be possible to have the form have 2 boxes:
1: total amount requested to be deposited
2: bank fees

so then 1 - 2 = end result


I don't know what's there now - I don't think I've ever deposited to the clan account directly. I'll let the treasurer types do that so they feel needed... :)

Konoko

[Sargon]

Hi

I support Konoko's proposal. :)

Sargon

[Konoko]

Thanks Sargon but you have to have more text than that to have your post considered to be valid Sargon! :)

And you're falling WAY behind anyways!

Aerick has pulled ahead of Kiri and I'm almost at 500! Woo! :)

Konoko

[Aerick]

Konoko, you basically have it right.

The issue is that the deposit is credited for the amount before bank fees, but the amount in the account is the amount after the bank fees. So I guess there'd have to be an extra display field, resulting in a Deposit / Bank Fee / End Result view.

[Kiriel]

Sounds like a good idea
I'll implement it when I get a chance
The one problem I can see is in the case of potion deposits where we have deposits from multiple people going in at once. In that case I usually enter multiple deposits and just one bank withdrawl. Not sure the best way to handle that situation.