[Development] BoI Account/User Manager

[Beatz89]

Okay so I am working on an application to manage users and characters.

This connects directly to MySql and MsSql and you are able to edit all editable areas.

MsSql manages Accounts

• Add Zen
• Add GM/Remove GM
• Password Change/Reset
• Anymore? Tell me and I will add it

MySql manages Users

• Unstick Character
• Change Stats
• Change Map
• Change Perfect Revives
• Ban Character
• More will be added when I figure out what can be changed

If there is anything else you think should/could be added to this please either leave a reply or PM me.

Will be posting BETA version in about a week.
**EDIT** Gonna be sooner than I thought... MsSql is very easy to work with haha




Major Update!

* Character Data now partially done
* Map ID, X & Y will go red if the character is in Confinement room
* Unstick will take the character to Atlantis(must be logged off)
* Still got to work out all the profession IDs
* User Data will be available in the BETA release
* Character Data might be editable in BETA version
* AddZen working (Read 'AddZen Screen')
* GM Options will set every character on that account as GM. (Possible fix)
* GM Options, if the character is already GM the cross will be the only option available, if they are not GM the tick will e the only option available
* Register, Fully working(will include a password generator soon)

Also you will see 'Monster Editor', its a little function I am going to work on and see if I cant get it working to edit monsters.

Just need to think of 2 more major functions that I could facilitate. If this really takes off and is worth while me keeping it updated I will eventually include a 'lightweight' windows side server. The game will still function properly and still need MsSql, MySql and VirtualBox but you wont get horrible boxes load up all over your screen, it will all be included in the BoI Tools Ulility.

Also if anyone knows how to log characters off while saving their data would be great if you would let me know so I can add it as a feature.

Still loads to do but thought I better keep you all updated...

Just added download, please make sure to change Config.ini before launching, also MySql and MsSql MUST be running

 

[atcool]

link DownLoad

 

[Beatz89]

Okay so I am working on an application to manage users and characters.

This connects directly to MySql and MsSql and you are able to edit all editable areas.

MsSql manages Accounts

• Add Zen
• Add GM/Remove GM
• Password Change/Reset
• Anymore? Tell me and I will add it

MySql manages Users

• Unstick Character
• Change Stats
• Change Map
• Change Perfect Revives
• Ban Character
• More will be added when I figure out what can be changed

If there is anything else you think should/could be added to this please either leave a reply or PM me.

Will be posting BETA version in about a week.

View attachment 115996

link DownLoad

Sorry my fault... dont think I made it clear enough.

 

[djbadboys38]

Maybe you can add to program of this,
- Add item/pet/mount (with name) to account
- Add salary/credit/bonus (with name) to account

and please release a in 1-2 days

 

[Beatz89]

Maybe you can add to program of this,
- Add item/pet/mount (with name) to account
- Add salary/credit/bonus (with name) to account

and please release a in 1-2 days

There are still alot of functions I have to figure out... Adding Items/Pets/Mounts will be quite hard as I would have to figure out where and how they are stored. I will keep this in mind though for when I release future versions of this program

As for salary/credit/bonus if I can find/someone knows where they are stored and if the can be changed I will add it..

I am working as hard as I can on this release as it will be helpful to alot of people. But I dont want to do a half butt job and not make it right as it could very easily break peoples databases, and we wouldnt want that.

Just finished adding the character create screen and done about 1/4 of the MySql functions.

 

[djbadboys38]

wow screen is very good for me I dont know where i can edit monster or other items... but i will search item/monster/credit/salary section. NOTICE: sorry for my bad English

 

[ranaza]

Beatz89 Help me please. I have not tried that only
http://forum.ragezone.com/f768/change-version-game-exe-885488/

 

[djbadboys38]

Beatz89 Help me please. I have not tried that only
http://forum.ragezone.com/f768/change-version-game-exe-885488/

i send post already...

 

[richexpert]

Show online players ( one click action ) and what to do with them , kick , mute , ban , whatever you want.
example , right click so a new drop list show wheres you have those options to choose

 

[djbadboys38]

@Beatz89

you can make a website?

You must be registered to see links

or

You must be registered to see links

same?

 

[Beatz89]

I will see if I can make the online players list as this would be really helpful for alot of people. As for the kicking out of game part this might be a bit tricky as I havent worked out a manual (server side) save function yet.

I could possibly make a website but I am more Windows dev than php or html.

Editing monsters and other stuff may be in a later version as this requires quite a bit of work to be done inside this program.

Thanks for all the ideas and keep em' coming... I should be releasing a BETA version of this in around 24 hours time if nothing gets in my way.

We will see how you guys like the beta and work from there.

 

[Beatz89]

So just done a few other things to BoI Tools.

Check first post for more info and a download link.

Please read the info bar at the bottom of the program before using...

 

[ranaza]

 

[Beatz89]

View attachment 116330

Hmmm seems like there is an unforseen bug... I will fix it tonight when I have a spare 5 minutes... Any other bugs you found?

 

[ranaza]

No other than that is not registered and does not display the characters in the main menu to add zen

 

[Beatz89]

No other than that is not registered and does not display the characters in the main menu to add zen

I will look at it in a bit Wanna post a screenshot of the Add Zen screen please

 

[ranaza]

 

[Beatz89]

View attachment 116338

o>O weird... it pulls up the same account library as the main program oO will have a look at that as well


Also can you please translate the top part of that error message for me?(on register) I cant read any other language apart from english lmao

 

[ranaza]

System.Data.SqlClientError.SqlException (0x80131904) bug while converting data type varchar to varbinary.

 

[Beatz89]

Hmmm I cant find any bugs in the program at all... Will have to wait see if anyone else has any problems with it...