BeGa Admin Tool

[MOT7]

Hey ragezoners,
i'm currently developing an admin software for our own server. i finished some of the tools and now i want to share it with you, because i want to help and maybe some people find it useful!

News: (what i'm currently working on...)
--- New Version V 2.0.2.1 ---

Warning:
DO NOT change the xml file's unless you know what you are doing!

Advice:
- check your ports in firewall, your ip etc. IF the tool needs more then 5 seconds to establish the database connection, then you made a mistake somewhere (or i did :blink

- you need a bit knowledge to use this tool (basics: what is the "UserNum" and "ID" of an account etc., nothing difficult)

- please tell me your problems with this tool and i'm sorry for the ugly design, but didn't put any great effort on it yet, because i think a working tool is way better then some buggy nice-looking one...

Update Notes:

Spoiler

Release
available tools:
- account management
- mail system

- font changed (suggested by GODSKIN)
- design changed a bit
- tapping through boxes and buttons corrected, now it's easier to enter values and change entries

2013-03-18
- account management
=> You can now search a character by his Name and get Account ID, UserNum and Name, CharIdx and Level

2013-03-19
- changed design a lot (should be better now)
- new tools available:
1) statistics (nice little addition, nothing special but maybe interesting)
2) mission dungeon (delete and fix dungeon times (like those pesty "00" ones and maybe catch hackers))
3) character management (delete and restore characters)

- mail system
=> you're now able to send up to 25 items with pressing the send mail button once

2013-03-21
- new tool available:
1) character editor
=> change values belonging to one specific character
=> deactivated "change nation", "change skill points" and "change class rank"
reason: still have some smaller issues. solution for class rank is probably found (new formula) and i'm testing it, CREDITS to emi

- new design (YES, here it comes):
1) new form which helps to find data about accounts, characters...
2) you can hide and show it, saves up a lot of space at the tools and makes work faster
3) tools rezised

2013-03-27
- mail system
1) you can now send mails with your own text or standard text (leave field blank) CREDITS to JemCanoy
2) layout changed
3) characterIdx, quantity and mail text stay the same after sending the mail
- character editor
1) changed maximum and minimum values for different fields
2) more/better detailed data shown for character information
3) small layout change
4) button for class rank change enabled
- new tool available: ItemShop
1) works only with the database from chumpy and it's the non-upgraded version! please be careful if you're using an absolute different shop in database
- statistics
1) shows all users being online and interesting data for that characters CREDTIS to elvise

2013-04-10
- new tool available: Pet Management
1) get the slot information for every pet
2) change the slot information
3) rename the pet
4) get all data about pets and their owner
5) change the pets level and exp
- new tool available: Item Creation
1) CreateItem Codes (ItemId, OptionCode, DurationIdx)
2) Supports 1-4 slots, craft, vanishing items, extended items, upgrades from 0 to 15
- new tool available: Global Management
1) ban IPs / IP ranges
2) release IP bans
3) get hack attemp- and bot report lists
- Character Editor:
1) changed the warp/map codes available (now you can select every map with their warp points)
- Mail system and Item creation:
1) you can now create an item, save it to a file and then reload the item in the mail system and send it. no need to create the same item a hundred times again
- General Changes:
1) changed some values that remain after retrieving some data for easy refreshing data views
2) layouts changed/corrected
- manual:
1) added some small manual which contains some interesting and basic information belonging to the tool. just take a look maybe it helps.

2013-10-05
1) New Tool Available: Guild Mail System
- Send mail to all guild members and fill it with items and/or alz.
Note: Just click on the upper left corner in the table with the listed guilds
(same row as the chosen guild) and the tool lists all the members of the guild.

Fixes:

Spoiler

- mail system => Show Account Chars, database problem fixed
- small fixes at the new basic functions
- Fixed using alphanumeric keys in database Username and Password CREDITS to Drav3n
- Fixed problem with class rank (loosing face,haircolor, hairstyle...)

Requirements:

Spoiler

- run the sql statement on your database to fix the procedure i'm using! (Database Fix Download Link below)
- .NET framework 3.5 or 4.0 (only tested with 4.0)

HELP NEEDED:
--- No Help Needed anymore ---

Because forum uploader hates me:

BeGa Admin Tool V 2.0.0.0 FULL Release :

To view the content, you need to sign in or register

BeGa Admin Tool Manual :

To view the content, you need to sign in or register

Database Fix :

To view the content, you need to sign in or register

!Files are 100% clean and safe to download!

Announcement:
The Project is alive again and i'll try to find some free time to recode it (professional version) with more functions and all you ever could ever think of !!!:scared:
I hope that i sticked with my word and here you have the full release. Have fun!

Greetings
MOT7

 

[emi]

I haven't run your Tool but I can say the way you manage the class ranks(grade) is totally wrong, not to mention that all chars would be probably male, and if you got any hair/face change, you'll loose it when you change your class rank.

You may also want to use some sort of protection software, so that people can't see your source code, which in this case can.

 

[MOT7]

Ah, first thing which should be fixed then ! Thanks!
I'll see if it will work after changing the algorithm and test it again!

Greetings
MOT7

 

[toast2250]

Simple classic look, Its not ugly at all.

 

[GODSKIN]

Front Ugly Pls To Classic Front

 

[MOT7]

@GODSKIN
Do you mean "FONT" ?
i'll change that later to some classic font, realized that some values are difficult to read with that font! Thanks for your reply.

Greetings
MOT7

 

[4pLay]

@GODSKIN
Do you mean "FONT" ?
i'll change that later to some classic font, realized that some values are difficult to read with that font! Thanks for your reply.

Greetings
MOT7

Is This Gonna Be Released A Full Version?!.. Or Just Account Management?...

Thanks!!!

 

[MOT7]

@4pLay
it is the full version, but atm i just activated the account management and i'll update the version step by step, so i have time to fix bugs and problems.
to explain what i mean:
the project consists of "tools" which all support different functions. they are ready to use, but i control them and try to find major problems atm. so it's complete but i don't want to activate all functions for you yet, because i don't want to destroy your database if i made some big mistake somewhere. that's why i wasn't sure if i post in "development" or "release" section...

@Moderator
if it's wrong here, then pls move it!

Greetings
MOT7

 

[toast2250]

I did a quick evaluation of the tool and everything seems to work fine from the Account management tab.

 

[MOT7]

I did a quick evaluation of the tool and everything seems to work fine from the Account management tab.

THANKS !!!!!!
i'll always control everything 1000 million times before releasing or giving to other people! but it's always helpfull to get some response and people helping to test it and maybe help with other things !

Greetings
MOT7

Edit:
I just need time to get the class rang thing fixed and maybe someone can help with the following:
I need the warp and map codes for the different maps, till now you just can select the code for the basic 3 maps (bi, gd, ds) or all maps (until porta inferno). it would be perfect if someone knows the algorithm for the maps/warps in order. Means: bi,gd,ds OR bi,gd,ds,port lux OR bi,gd,ds,port lux, undead ground etc.!

 

[Drav3n]

HEX DEC
4000000 67108864 = Gender (Female)
200000 2097152 = Aura
20000 131072 = Hair Style
2000 8192 = Hair Color
100 256 = Face

Hope this can help for class rank (style)

 

[MOT7]

Hope this can help for class rank (style)

I'll see, next thing will probably be Mail System (cuz i read that there are some problems with sending items to players and i discovered a few ways to do so and this one should work in 95% of all cases), then the Statistical tool, and while releasing them, i'll try to use your post, to get the style thing working...

THANKS!

Greetings
MOT7

 

[Drav3n]

I'll see, next thing will probably be Mail System (cuz i read that there are some problems with sending items to players and i discovered a few ways to do so and this one should work in 95% of all cases), then the Statistical tool, and while releasing them, i'll try to use your post, to get the style thing working...

THANKS!

Greetings
MOT7

I suggest, if you can add a function to disconnect a player on specified channel like on IRIS with yamachi.

 

[MOT7]

I suggest, if you can add a function to disconnect a player on specified channel like on IRIS with yamachi.

Hm... i thought about that! tried it a few days before, but it didn't work. i think if i can do it, i'll add it on the account management. because it has nothing to do with character management or character editor.

thx for your suggestion, i try implementing this...

Greetings
MOT7

 

[emi]

Hope this can help for class rank (style)

Not really, but it's a start.There is another formula.

THANKS !!!!!!
i'll always control everything 1000 million times before releasing or giving to other people! but it's always helpfull to get some response and people helping to test it and maybe help with other things !

Greetings
MOT7

Edit:
I just need time to get the class rang thing fixed and maybe someone can help with the following:
I need the warp and map codes for the different maps, till now you just can select the code for the basic 3 maps (bi, gd, ds) or all maps (until porta inferno). it would be perfect if someone knows the algorithm for the maps/warps in order. Means: bi,gd,ds OR bi,gd,ds,port lux OR bi,gd,ds,port lux, undead ground etc.!

2570 would give you all map and warp codes till porta inferno.

 

[MOT7]

Yes emi, 2570 is for all and 7 is for the first three.
that's not the problem. i tried to figure out, how to get one map after another with the code but i wasn't able to figure that algorithm out.

like this way:
Code Maps
7 bloody ice, green despair, desert scream
X bloody ice, green despair, desert scream, port lux
Y bloody ice, green despair, desert scream, port lux, undead ground
Z ...
2570 bloody ice, ..., porta inferno

Greetings
MOT7

Sry, sometimes i explain some situations a bit strange... hope it helps to understand what i mean...

 

[jaguar666]

Great job bro... I would suggest if you can resize the height of the Account Mgnt and Mail System TAB because we can't see the CLOSE button below.

Edit: NVM, this is a small issue, it will close when i press the ESC key.

What I really like this tool is there's a reset sub-pass function.

#####

Another suggestion:
Will you please add a function of searching a Character Name so that we will see his CharIdx. If we can have this function we can see his ID Name by using your ShowUserInfo function, after we knew his ID Name, we will know his UserNumber from a function of Find UserNum.
We want this function so that we will no longer look at at the DB on his AccountNum and AccountName by using a formula of deviding by 8 from his charIdx = User/AccountID

Note: We can show the blocked accounts only if we used this tool to block an account. But those manually blocked or blocked by using CT4, it doesn't show when click the ShowBlockedAccounts Button.

Add nice MOT7 icon for ur trademark, hehe.

 

[MOT7]

Ok, the size is indeed a problem here, i tried to find out what to do to get some nice overview without having to scroll all day or to see all information only at half so you have to size the columns.
i'll resize the grids and let's see if next version is better!

By the way: i started developing with a size of 1280x960. that's the reason why the tabs are that huge and i've got two monitors so i had no problems with that at all! i began resizing after finishing the first tools! we'll see what i can do on that

Yes, ESC key works, because i know that people love to press ESC and its faster then clicking buttons

The reset-sub , he he he. YES, that was something i implemented in the beginning, did you ever look into the official cabal forums ? People blocking there accounts every two minutes because of forgetting there sub or main password...
(by the way, that one was easy to do )

About your suggestion:
i've seen this way of finding a character so i'll implement that, i hope i can get it to work and i know what you mean. the thing is: i just implement it in account mgnt because the software allows to open more than one tool at a time! every tool opens and closes his own database connection! that's because of security reasons and a bit performance saving!

Thanks for your suggestion!

Greetings
MOT7

Trademark ?
Hmm... perhaps in the future : tool goes first !

 

[Drav3n]

got an error on your last update. any idea?

 

[MOT7]

Just tell me when exactly did the error occur ?
(i don't have the log system implemented yet)
did you press the acc mngt button and it throws that one ?

Greetings
MOT7