Account Table
 

Anyone know what the sharedplat column is for in the accounts table? I thought maybe it was for plat amount in the accounts shared bank, but I am a tard and that's simply not it.

So what is it for?

I did a search and came up empty.

Is there a way to give a new account 100 plat in the shared bank?

Thanks

As far as I know, sharedplat may be unused in the C++ code as I did not see a field ref to it in the source. Thus I'm inclined to believe it not currently used.

.. but there's a tool for modifying plat between toons/accounts in my site called server stats if that helps any


GeorgeS

Thanks George, I did grab a copy of that tho I havent used it yet. I think what I will do is tweak the php account creation script and have it insert into the sharedbank table when a new user signs up.

Not sure if that will work tho as I don't think plat has an item id and I'm not sure as to what the slot id would be.

I'll mess around with it and post back if I make some progress.

The only way to give plat to characters out of the game (like using sql) is to use the editor because the plat data are stored in a binary profile field, that's pretty complex. No itemid for coin exist.


GeorgeS

I would have to manually add for each account correct?

I could create a "quest" item and insert that into the sharedbank table. Make it an item that's turned in for 100p.

It would seem shared bank is broken, at least for plat: http://www.eqemulator.net/forums/sho...ht=shared+bank

Items work?

That's not a bad idea :P

One thing you could also do, is for those that turn in their quest notes to the guildmasters, edit the quest to give them some starting coinage. :)

Items do in fact work.

The interesting thing about the shared platinum is that it is stored in the profile blob, so it is stored on each individual character. This means it will stay on the character when you log out & back in, but other characters on the same account won't have access to it.

In theory, it should be possible to have the server look at the database instead of the profile blob for the shared platinum. Unfortunately, I wouldn't know where to begin since there isn't a separate file for banking. It seems like it's just moving the coin from one slot to another, and the banker stuff is just done client side.

Thanks for the feedback guys!

I found out the hard way about plat in the shared bank. I now have an uplayable toon that I will probably have to destroy. It seems even a character restore from a previous backup will not restore to playable condition either. It simply crashes the zone upon log in. I have downloaded a blob editor, but still am unable to rectify the issue.

The wiki shows the address where the shared bank plat is stored, but when matching to the blob it already shows a zero value.

Now with the "quest" item that is turned in for some starting coin; I wanted to make sure this was going to be shared for an account. I want to make sure that it can not be abused. If it were character based, someone could simply make a toon for 100p anytime they needed cash. Making it shared for a single account eliminates this at least on our server. Our server is setup so that you may only have 1 account.