[Tool] Kal-online Helper

[Old fisher]

OK, having met demand for this tool, I'm posting it here along with some illustrated instructions...
Here's link to current version of Helper: KAL Helper
To use it, you will need Microsoft Access 2003 of Miscrosoft Office. It will connect to ODBC sources KAL_DB and KAL_AUTH.
After opening it, go to Forms and open form Main. Later I'll add autostart and other comfies.

First things is fields for importing and exporting InitMonster.txt and ItemGroup.txt, along with buttons for import and export. You have to manually type exact paths.
Also from this form you can go to accounts screen, monster screen and item groups screen.
Let's look at accounts screen:

Here you can see all the accounts and character name finder. You cannot create, change or delete accounts from here. But you can right-click on either account ID or account name. Right-clicking on ID brings character list

where you can alter character's attributes and access his inventory and skills.

Inventory editor shows contents of character inventory and allows to modify, delete and add items. Upper left portion is item selector, where you can select item that will be added to inventory with "Add" button. Button "Change" replaces currently selected item with item shown in selector. Button "Max stats" adds appropriate maximum stats to currently selected armor or weapon piece. It doesn't work on other kinds of items. Mixing part works only on weapons. If you didn't spot it, items in list can be selected with leftmost selection column. Del will remove currently selected item from list.

 

[Pure_evil]

Re: KAL Helper

acces gives me an error with following explanation when i try to import:

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

my paths are 100% correct, i c/p them to start => run and they both work!


edit: and in just about any other thing i try to do :s

 

[Old fisher]

Re: KAL Helper

Right-clicking on "Item" combo box here or in drop group editor brings up neat item selector:

Also from character list you can go to skill editor. There you can add skills and edit their grade. The list shows maximum grade of skills, but nothing prevents you from going above it.

To add skill, find it in the selector combo at the top and press button next to it. To remove skill, use removal button in the line of that skill.

Most interesting thing in monster list is nice-looking combined droplist, but it cannot be used for editing. Combo box above is informative helper for selecting monster you want to view. Quest and item group selectors can be used for initial management of droplists. Order is internal field (not used in actual lists) that determines exact sequence of entries. Right-clicking at item group number brings screen that allows you to edit droplist in its native representation. And the most dreaded thing is mass stat changer that requires very detailed explanation you're not gonna get. In short, you can use formula to calc any stat, using any VBA-compatible expression, user functions and stat names in figure brackets.

This editor can be called from monster list or from main form. If you call it from main form, you can right-click on monster finder to look at monster who has selected item group. To clear things up, you can look at item group screen from monster window, or you can bring up monster window from item group window, but that's it - no more cross-navigation. Well, this screen is kind of self-explanatory, I just need to say that you can't add items to group using empty string, but right-clicking at order field does the trick. Remember that right-clicking at item name brings up item selector.

Well, so long and thanks for the fish... In time I'll improve and modify this thingie... maybe... especially if I'm not the only one who uses it...

 

[Old fisher]

Re: KAL Helper

acces gives me an error with following explanation when i try to import:

edit: and in just about any other thing i try to do :s

Could you look what references you're missing? I didn't include any additional libraris or anything...

 

[Pure_evil]

Re: KAL Helper

Could you look what references you're missing? I didn't include any additional libraris or anything...

and how do i find that? my experience with acces is close to zero hours

 

[Ace-SG1-]

Re: KAL Helper

hmm cant use this... i dont use Kal_AUTH or Kal_DB. but it looks realy realy good.

 

[HandsOfGod]

Re: KAL Helper

looks good

good job :O

 

[DeathArt]

Re: KAL Helper

hmm cant use this... i dont use Kal_AUTH or Kal_DB. but it looks realy realy good.

most likely fixable

 

[Old fisher]

Re: KAL Helper

and how do i find that? my experience with acces is close to zero hours

You provided link that described the error. They said how to look for broken references there. In short, press Alt-F11, Tools->References. Look for references marked red.


And about KAL_DB and KAL_AUTH - without these you can't use account/character/skill/inventory editors, but you can still work with droplist and monster properties.

 

[Pure_evil]

Re: KAL Helper

You provided link that described the error. They said how to look for broken references there. In short, press Alt-F11, Tools->References. Look for references marked red.


And about KAL_DB and KAL_AUTH - without these you can't use account/character/skill/inventory editors, but you can still work with droplist and monster properties.

nothing missing according to that menu :/

which ones should i have there? maybe i got something short there?

 

[johnson764]

Re: (REL) Kal-online Helper

How To Make An Account I Use Solidus 2.0 Repack Server Working
I Try To Make Account In Database But Error Account Not Allowed To Connect When I Login

 

[GERmarco]

Re: (REL) Kal-online Helper

wtf?
what is an *.MDB?
I cant open it...
Can you write it in *.exe? plz

 

[Pure_evil]

Re: (REL) Kal-online Helper

google it for **** sake
mdb is an acces document, u can't make a friggin exe from that file

 

[Old fisher]

Re: KAL Helper

nothing missing according to that menu :/

which ones should i have there? maybe i got something short there?

First thing that comes to my mind is do you have Access installed with all the features (well, maybe you don't really need sample databases) and do you have all Visual Basic for Applications stuff installed too, in Office tools or something like that?

 

[Pure_evil]

Re: (REL) Kal-online Helper

i re installed it when i couldn't get it to work and i installed with all features, still same prob :s
vba is installed too

 

[Old fisher]

Re: (REL) Kal-online Helper

i re installed it when i couldn't get it to work and i installed with all features, still same prob :s
vba is installed too

And when you open it, you have to agree to use Visual Basic procedures and macros (they are called "unsafe expressions" or something like that - can't be sure about exact terms because my Access says that **** in Russian). That stupid thing asks 2 times and then asks again if you want to open the database. I wasn't using any non-standard libraries or something like that, only native Access features.

 

[Pure_evil]

Re: (REL) Kal-online Helper

did all that shizzle too :s

 

[PAnimal]

Re: (REL) Kal-online Helper

I have Kal_Auth and Kal_DB and this wont work on mine, gives me an error saying this:

"Microsoft Access
The expression On Click you entered as the event property setting produced the following error: A problem occured while Microsoft Access was communicating with the OLE server or ActiveX Control.

*The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.

I dont know anything about it as I never used access before but I got the program thing open and clicked accounts and that came up, clicked other things and same thing.. I have server up and running as well so I know its operating, unless the Kal_Auth and Kal_DB are case sentitive words?

Also maybe a Microsoft Access version difference? what version are you using and are there plugins maybe I am missing that you have installed?

 

[Pure_evil]

Re: (REL) Kal-online Helper

I have Kal_Auth and Kal_DB and this wont work on mine, gives me an error saying this:

"Microsoft Access
The expression On Click you entered as the event property setting produced the following error: A problem occured while Microsoft Access was communicating with the OLE server or ActiveX Control.

*The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.

I dont know anything about it as I never used access before but I got the program thing open and clicked accounts and that came up, clicked other things and same thing.. I have server up and running as well so I know its operating, unless the Kal_Auth and Kal_DB are case sentitive words?

Also maybe a Microsoft Access version difference? what version are you using and are there plugins maybe I am missing that you have installed?

Same error as me, only i have it in dutch and i don't know if he understands that + i was too lazy to translate it

 

[PAnimal]

Re: (REL) Kal-online Helper

I had my woman type that, it would have taken me 24 hours to type it.. lol