BeGa Admin Tool

[Drav3n]

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

Yes, even Account Management or Mail got that error, Test Connection successfully connected.

 

[MOT7]

that makes no sense !
the test connection says, that the connections are fine ? and you can't connect to the tools then ?

i can't find any mistake yet, checked everything carefully!

Greetings
MOT7

Edit:
The problem is: i didn't changed that source code path for the new version, there can't be any mistake (i think, or better said: the chance is near 0)
i'll test some things, let's see! please control your database service and the db names!

I tested the version i released, everything works fine! i checked the source code and the error occures when the tool gets every xml data correctly but can't connect and something with IP, Port, database Username or password is wrong or the database service isn't running! hope that helps !

 

[Drav3n]

that makes no sense !
the test connection says, that the connections are fine ? and you can't connect to the tools then ?

i can't find any mistake yet, checked everything carefully!


Greetings
MOT7

Edit:
The problem is: i didn't changed that source code path for the new version, there can't be any mistake (i think, or better said: the change is near 0)
i'll test some things, let's see! please control your database service and the db names!

I tested the version i released, everything works fine! i checked the source code and the error occures when the tool gets every xml data correctly but can't connect and something with IP, Port, database Username or password is wrong or the database service isn't running! hope that helps !

Well, i tried to connect it on my local server, it works. but i when i try to connect on my Live server, that error cames out.

I guess the problem is, your password field does not support alphanumeric keys like @%^&*(

other tools can connect on my live server. only yours not.

 

[MOT7]

AH, yes, that could be possible!
i'll see if i can change that in the future sry for that but it explains why everything works fine but the connection to your server not, i'm glad that the fault is that "simple". i'll get it fixed as fast as possible! thanks for your help to find it ^^ indeed, i don't use alphanumeric ones on the testserver!

Greetings
MOT7

@Drav3n
The tool supports alphanumeric key, the only problem is the "&" key... rest should work! i can't figure out, how to fix this that fast, i'll try!

 

[Drav3n]

AH, yes, that could be possible!
i'll see if i can change that in the future sry for that but it explains why everything works fine but the connection to your server not, i'm glad that the fault is that "simple". i'll get it fixed as fast as possible! thanks for your help to find it ^^ indeed, i don't use alphanumeric ones on the testserver!

Greetings
MOT7

I'm glad to help and enhance your project. don't forget in username too. not all servers use "sa" username

 

[jaguar666]

There's another error on Show Account Chars function in Mail System tool, the tool closes after clicking the button.

Much better also if you can add another send item function (Send Item to UserNum).

 

[MOT7]

There's another error on Show Account Chars function in Mail System tool, the tool closes after clicking the button.

Much better also if you can add another send item function (Send Item to UserNum).

Hm.. be sure to use a valid userNum and not something like "a" or "872990" which isn't recognized in your system!
it only accepts integer values because the userNum is just filled with those!

Greetings
MOT7

Edit:
Checked the function, its working flawless! i got the fault, i changed the database!!!!!!! its not your fault, i have to look at it! thanks !!!! i know what the problem is ! will get fixed, nothing special! only small thing!

 

[jaguar666]

I would also suggest if you can add a function of deleting accounts without a character yet and never logged-in game. There might be a possibility that somebody with bad intention that will make a hundreds or thousands of accounts even if he has no plan to play the game.

 

[MOT7]

I would also suggest if you can add a function of deleting accounts without a character yet and never logged-in game. There might be a possibility that somebody with bad intention that will make a hundreds or thousands of accounts even if he has no plan to play the game.

That is some more risky thing! the reason: i learned "never delete data if it's not absolutely necessary". if i find a database procedure for that, i'll implement it, otherwise block the account permanent! i'll see what i can do on that!

Greetings
MOT7

 

[Drav3n]

Hi MOT7, on BeGa Admin Tool V 1.1.3.2 the password field support the alphanumeric keys ?

 

[emi]

That is some more risky thing! the reason: i learned "never delete data if it's not absolutely necessary". if i find a database procedure for that, i'll implement it, otherwise block the account permanent! i'll see what i can do on that!

Greetings
MOT7

There is no procedure for that and it doesn't need one.All chars that have not logined will have a certain field in cabal_character_table filled with NULL. I'll let you figure out which(it's easy).

 

[Caelann]

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) (...)

Really? Didn't know that! What kind of problems? I've been using the Cash Inventory method for a while and the only issues I've run into were 4slot items and some craft options not working properly, but I assumed that was due to outdated values (currently using Balq's EP2 tool for Option values).

Oh, and some quest items I tried spawning reverted to their option 0 forms, even though I checked the option value correctly in cabal_msg.enc. :V

 

[MOT7]

@Caelann
Yes, i read some posts where people said, that they got problems with sending items to characters! i just tried to figure out which would be the best way to send an item to someone. i read about 3 or 4 ways to send an items and i got one which should work in nearly all cases. maybe the people who got problems just made a mistake with there setup or i don't know. for me cash inventory, sending GM mail, normal mail etc. all work! i'll implement the item creation at the end because i'm not finished with it and maybe it solves your 4slot item thing

@emi
hm... ok,i know the cabal character table, what exactly do you mean with that field ? if i enter some kind of value, then the account gets deleted ? or what do you mean ?

@Drav3n
No, i focused on other things and just tried 2+ times to solve that alphanumeric one! please give me some time to test a few solutions with other computers and by the help of my community. i will highlight the fix if i got it and i'll post your name besides it cuz you found the bug! i just got an opinion which might solve the alphanumeric thing and also crytps the password in XML file, so you can give it to your GMs without publishing your database password! but that will take some time! i hope you can wait for that, i'm on it, i won't forget, promise!

Edit:
on the next updates, i'll try to implement a method that gives the opportunity to send 2 or more items with one time pressing the "send mail" button. i think it's realy nasty to send one core after the other :grr:

There is no procedure for that and it doesn't need one.All chars that have not logined will have a certain field in cabal_character_table filled with NULL. I'll let you figure out which(it's easy).

uh... checked the cabal_auth_table and cabal_character_table, they don't have any column filled with "NULL"... or am i blind ??? can you please tell me which one you mean ? at character_table there's only "Login" but its "0" not "NULL". so its filled and not unassigned!
and auth_table got some NULL filled columns, but i don't think you mean any of them...

Greetings
MOT7

 

[jaguar666]

Edit:
on the next updates, i'll try to implement a method that gives the opportunity to send 2 or more items with one time pressing the "send mail" button. i think it's realy nasty to send one core after the other :grr:

Very good idea bro... We will expect the updates on this very soon especially the Character Management Tool.

 

[4pLay]

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.

Maximized. Just Like He Said...

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

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

BUT!!! WORKS DAMN GREAT!

Keep It Up MOT! Your The 3rd One But I Think You Will Be Sticking With Your Word...

 

[jaguar666]

Keep It Up MOT! Your The 3rd One But I Think You Will Be Sticking With Your Word...

Agree, agree and agree....

 

[emi]

@Caelann
Yes, i read some posts where people said, that they got problems with sending items to characters! i just tried to figure out which would be the best way to send an item to someone. i read about 3 or 4 ways to send an items and i got one which should work in nearly all cases. maybe the people who got problems just made a mistake with there setup or i don't know. for me cash inventory, sending GM mail, normal mail etc. all work! i'll implement the item creation at the end because i'm not finished with it and maybe it solves your 4slot item thing

@emi
hm... ok,i know the cabal character table, what exactly do you mean with that field ? if i enter some kind of value, then the account gets deleted ? or what do you mean ?

@Drav3n
No, i focused on other things and just tried 2+ times to solve that alphanumeric one! please give me some time to test a few solutions with other computers and by the help of my community. i will highlight the fix if i got it and i'll post your name besides it cuz you found the bug! i just got an opinion which might solve the alphanumeric thing and also crytps the password in XML file, so you can give it to your GMs without publishing your database password! but that will take some time! i hope you can wait for that, i'm on it, i won't forget, promise!

Edit:
on the next updates, i'll try to implement a method that gives the opportunity to send 2 or more items with one time pressing the "send mail" button. i think it's realy nasty to send one core after the other :grr:



uh... checked the cabal_auth_table and cabal_character_table, they don't have any column filled with "NULL"... or am i blind ??? can you please tell me which one you mean ? at character_table there's only "Login" but its "0" not "NULL". so its filled and not unassigned!
and auth_table got some NULL filled columns, but i don't think you mean any of them...

Greetings
MOT7

Now that you mention it you have several ways to do that.one is by character_table and one is by cabal_auth_table.I'll let you figure it out which.
Login field tells you whether a character is online or not, nothing else.
Item sending works great if you do it the proper way,if you mess up,it won't work,obviously. If you want to send n items to a character just use a loop, easy as that.

 

[toast2250]

This topic will maybe help on how to delete accounts that dont have any characters or have never logged in,
http://forum.ragezone.com/f451/a-746094/

 

[MOT7]

@4pLay
THANKS for that! and about the close button:
Here we go:
tested a newly created layout! it fixes all the problems with the damnit "close" button. on the next version, you'll have a "show/hide" button at the menu, which shows or hides an extra form, where you can use the search functions (search ID by charachter name, get account infos and so on!) and the advantage: all tools will get smaller for about 20-50%, because i don't have to implement them into every single tool again! i hope this will end up the can't-reach-close-button-design-bulls***t (i hate it myself, but i'm not a designer, sry for that one)

(as you can see below, the new tools are WAY smaller then before)

@"i'll be sticking with my word"
yes, IF i'm able to solve the suggestions and to fix bugs, i will definitly develop the tool until full release! i'll use it myself and i always try to do my work perfectly, so let's see how far i can get with this one!

@emi
yeah, got the same idea. sending items was just some easy loop tested it and tested it again, then i found out, that it works and i was happy! thanks for the hints!

so, about the design:
i know that there's a possiblity that you can change the window resolution to your own needs, BUT design is the last thing i care about, while implementing the functions and fixing bugs! i'll figure out how to do that, if i have the time to do so!

@toast2250
i'll have a look, maybe it helps!

Greetings
MOT7

Edit:
@Drav3n
I'm sorry that you have to wait so long for the solution with the aplhanumeric keys, just wanted to say, that i wrote it down and i won't forget!

 

[Drav3n]

don't worry MOT7, You should not hurry to fix it, we can change/removed the alphanumeric key password anytime.
but in future, must be enable it to protect against brute force