Finding out the amount of Silver/Gold an account has

[alexzzzzz]

Hello, my name is Zander.

I have been making my Perfect World server for about a week now, PerfectZan, It's been going well.

I'm almost set to open, but as i'm making my script to give cubi,silver,gold whichever you want to call it. I need to know how much the person has in there account at that time.

The MySql server some how adds the gold into the pw db, so you should be able to reverse that and find how much the account has.

That is the biggest downfall of this server so far, not using only SQL. But some other database that I don't know how to mess with yet.

So, if anyone can help me find out how MySql can add the Gold to the account, or just knows how to find the amount a account has. It would be much appreciated!

Thanks,
- Zander

[MentaL]

[DaMadBoy]

You can see that information on pwAdmin but clicking on one of the characters on that account, you can then see how much they have, what they have spent and what they have purchased.

[alexzzzzz]

Thank you for your reply.

The pwAdmin tells me how many i have purchased, and how much gold is in your stash. It does not tell, on that page, how many they can spend in the cash shop. I have 18 silver, 0.18 gold(cubi), on the pwAdmin it says i have 0.

[tbnanubis]

basically, the jsp can only ask the gamedb how much has been added, and how much has been spend.. everything else is calculated from those values.

[alexzzzzz]

Okay, thank you.

We need a PW that is 100% SQL.
Posted via Mobile Device

[343]

We need a PW that is 100% SQL.

Not gonna happen =\ (not including any upcoming emulators)

[faqiir]

is cubi/gold can find in char xml?

[alexzzzzz]

I can add up all of the records for the account on how much gold they got in usercashlog.

Is there any way to see in SQL how much they used?

and figure from there, like the jsp, the amount they have.