chumpy's GM tools v0.61a

This is just a preview as a lot of stuff still needs adding. As our current tools are either very limited or in Chinese i decided to release an early version.

This has mostly been tested on MSSQL 2000 but 2005 should be ok too.

v0.62a Changes:
* Several minor fixes
* Updated OCX files broken by MS Windows updates
v0.62a Download -> http://www.mediafire.com/download.php?yndog1ngwyo

v0.61a Changes:
* Fixed PremPayMinutes not getting saved
* Added DurationIdx dropdown to CabalCash tools
+ Also made some space for new controls (hint hint)
* Added honour editing
* Tidied the char panel up
* Added date picker for premium expiry date
* Added serveridx to config options
* Added premium servicekind and map/warpcode info buttons
* All search boxes on Chars tab now work
* Added a "set all offline" button

v0.61a Download -> http://mrmagoo.psiblade.net/EC6/chum...ools v0.61a.7z
Mirror-> http://www.mediafire.com/download.php?2nwm3z3nmyn

v0.60a Changes:
* Some other minor tweaks
* Failed SQL calls now written to a logfile for easier debugging
* Added config .ini file support
* Added basic online user view
* Fixed prem type/kind to what they should be
* Added some char editing ability

v0.60a Download -> http://mrmagoo.psiblade.net/EC6/Chum...-v0.60a.exe.7z
Mirror-> http://www.mediafire.com/download.php?51xxwydyity

v0.51a Changes:
* Improved error checking around queries
* Added NT authentication support
* Added the ability to use custom database names

v0.51a Download -> http://www.mediafire.com/download.php?pm2iygkqky8

v0.50a Download -> http://www.mediafire.com/download.php?u5uyebwgo1j

Features:
* Adding logins
* Changing passwords
* Altering premium
* Banning / Unbanning
* Giving CabalCash items (any ServerIdx or DurationIdx)
* Clearing unclaimed CabalCash items (i.e. bugged ones)
* VERY basic GM ingame messages
* Connecting to non-standard MSSQL ports (for hitcurst)

Notes
There is no NT authentication yet so use your sa login. Also, connection is now via TCP/IP rather than named pipes to allow for alternate MSSQL ports so make sure TCP/IP connections are allowed in your SQL security config.

Premium expiry cannot be edited because of the weird way VB6 handles dates. It will be fixed soon.

GM messaging is limited to just 1 type and basic text only for now but more will be added.

The tabs at the top don't work yet before anyone asks.

Enjoy ;)

Re: chumpy's GM tools v0.50a

thx's chumpy, that save my time, don't much time to make that... But ban and unban can't use..

Re: chumpy's GM tools v0.50a

cheers, two thumbs up chump. ;)

by the way "find by name = username (not character name)"

if i enter character name = user not found in database"

(unless if you really intended it to be username ^^)

clear bugged items work.

sending items work.

so far the mail has not reached me yet ^^.

and so ill just wait =P

Re: chumpy's GM tools v0.50a

Quote:

Originally Posted by [hidden]

by the way "find by name = username (not character name)"

if i enter character name = user not found in database"

(unless if you really intended it to be username ^^)

It is supposed to be username only for now but more controls will be added. This is still very early and scruffy stuff tidied for an early release so it is a bit limited.

Mail sending speed absolutely sucks which i did expect, guybrush said the same in a post a while ago, and there isn't much i can do about it as it seemes to be a server-side problem similar to the delay with cash item deliveries. I have run into some other funny problems sending items and alz via the mail system as well which is why that is limited to GM messages only in this version.

Re: chumpy's GM tools v0.50a

@chumpywumpy
i think u account detail is not correct... i dont know, tell me if not correct...

Type (here you set free or premium account)
0 = Free
1 = Charged (premium state)
2 = Free time (everyday PM 21~22)(old style)

ServiceKind (only work with Type 1)(here you set premium style)
0 = Free
1 = Premium 1
2 = Premium 2
...
...
8 = Premium 8

Re: chumpy's GM tools v0.50a

Thx!

PS: It is possible mandar 1 message to GM for all users?
PS2: Item list no work, need itemlist.xml

Re: chumpy's GM tools v0.50a

thank you ^ ^
but my database use Gamedb name >> Gamedb_sonic
it don't work for my db

Re: chumpy's GM tools v0.50a

options for DB is a good idea...
make ini with sql param and login using cabal_managerdb "cabal_account_table" (oficial gm manager account)
other idea
when you open a program and you "cabal_account_table" table is empty, will open new windows for create manager account...

Re: chumpy's GM tools v0.50a

I got message

Run time error '380'
Invalid Property Value

when I search a user. How to fix it, sir?

Re: chumpy's GM tools v0.50a

weeeee..nice release...thank you very much ChumpyWumpy....

regards to Messaging system:

Message sent but no notification pop ups on screen..

once again thanks. nice released

Re: chumpy's GM tools v0.50a

@chacina - My own knowledge of the premium values is a bit basic but that info helps a lot, thank you.

@darkxl - Yes it does need an itemlist and the xls file i have isn't my release so i though it would be cheeky to include it without first checking with the author. Just put your own excel file there for now. When i add some better configuration options this won't be hard-coded.

@jaeker1/chacina - I wasn't really expecting different db names but it is a good point. I will add some options to support this. Some othe good ideas there too chacina ;)

@normalblue - I'm not sure on that one, error checking is really quite basic at the moment so it doesn't give too many clues. I suspect it is running into problems querying the db so make sure you use your sa logon. I will add some extra checks around that part of the code tonight to see if i can work it out. Do you use sql 2000 or 2005?

@hacker08/darkxl - The speed of delivery is very slow and it can take a long time for messages to be delivered. I have also noticed that my GP client doesn't have the popup box telling you there is new mail like the EU client does, you have to actually go into the message panel to see it has arrived. I suspect this is a client-side difference between the EU and US clients but i won't know without some more testing.

As for messaging all users this is the bit i am not sure about, the messaging function is really to allow us to find out. The stored procedures don't have an option to send to all and my only guess is that setting the dest char to something special like 0 might do it but i have not got it to work yet. If it doesn't then it won't be too difficult to write a new SP to do it but obviously everyone would need the same SP for the tools to support it.

The actual values that go into the DB seem to be different for different mail types. For example sending a GM message/War compensation with no sender name/charidx works ok but for other mail types the delivery never happens no matter what you do unless you add sender details. This is why the type is greyed out as i didn't want lots of complaints about mail delivery failing until i know the types better. I also suspect i am going to have to put messaging on it's own tab as a lot more controls and options are going to be needed to support all mail types i think.

Re: chumpy's GM tools v0.50a

I should have watched my mouth and not said/talked shit to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

Re: chumpy's GM tools v0.50a

Um question about cash item ive already try 1-16 in duration id is there a way make a thing permanent or a code that i type in duration id.... tnx adv for reply..... GOOD work :busted_co

Re: chumpy's GM tools v0.50a

Quote:

Originally Posted by Revmed

Um question about cash item ive already try 1-16 in duration id is there a way make a thing permanent or a code that i type in duration id.... tnx adv for reply..... GOOD work :busted_co

set DurationIdx to 0 the item will be permanent but you cant receive in cashitem... lol :bad:

i also create a trigger but still cant receive from cashitem

Code:

CREATE TRIGGER [permanentitem] ON [dbo].[MyCashItem] FOR INSERT, UPDATE, DELETE AS UPDATE [cabalcash].[dbo].[MyCashItem] SET [DurationIdx] = 0

btw: here is your sig http://www.geocities.com/elitus_joni...noy_dimple.gif

Re: chumpy's GM tools v0.50a

try this,PRE
CREATE TRIGGER [permanentitem] ON [dbo].[MyCashItem]
FOR INSERT, UPDATE, DELETE
AS
UPDATE [cabalcash].[dbo].[MyCashItem] SET
[DurationIdx] = 31

Re: chumpy's GM tools v0.50a

Quote:

Originally Posted by flyba

try this,PRE
CREATE TRIGGER [permanentitem] ON [dbo].[MyCashItem]
FOR INSERT, UPDATE, DELETE
AS
UPDATE [cabalcash].[dbo].[MyCashItem] SET
[DurationIdx] = 31

Thanks pre

i will post the result after test...

EDIT: Works Perfect... Good Job

Re: chumpy's GM tools v0.50a

one more thing that's why u cant get those items maybe because of the date/time settings between Windows os and Centos ex:windows date 2008 centos date 2015,,, for me i have no problem of it because i don't use vmware i use 2 PC 1 Linux another 1 WinXp
@JoniverPH
pls check yahoo msgr i got pm thanx

Re: chumpy's GM tools v0.50a

Quote:

@normalblue - I'm not sure on that one, error checking is really quite basic at the moment so it doesn't give too many clues. I suspect it is running into problems querying the db so make sure you use your sa logon. I will add some extra checks around that part of the code tonight to see if i can work it out. Do you use sql 2000 or 2005?

I use sql 2000. It shows only when I search to my username(GM account > may cause I edit charactor status.) DB user cabal...

I will try sa, report soon.

Edited : sa is the same.

Re: chumpy's GM tools v0.50a

@normalblue
just try mo make new acc example >>aktoni12
you will have run time error because chumpys editor cant read 7 letters account or 2 same name at a time ex :hakotay and the other acc hakotay12

Re: chumpy's GM tools v0.50a

There shouldn't be any problems with reading 7 letter account names. I had a bit of a play around last night to try and figure it out but i couldn't.

I will be posting a new version later today that has some extra checks to try and work it out. If you use MSN then add me (my address is on my profile) just in case i need to add some extra things to figure the problem out.

I have also added config options for alternate database names and added NT authentication for those that need it. I just need to do a little more testing on the alternate DB names before i post it.

Re: chumpy's GM tools v0.50a

Quote:

Originally Posted by flyba

try this,PRE
CREATE TRIGGER [permanentitem] ON [dbo].[MyCashItem]
FOR INSERT, UPDATE, DELETE
AS
UPDATE [cabalcash].[dbo].[MyCashItem] SET
[DurationIdx] = 31

NIce1 :busted_co tnx PRE

re: chumpy's GM tools v0.61a

Hey, I have problem in use GM tool v0.51a pls help

http://www.uppic.net/show/b43510faac...1a2e96d9155296

http://www.uppic.net/show/5e00e3020e...b75c7cbb61717b

re: chumpy's GM tools v0.61a

Those screenshots show 0.50a. If you use NT authentication instead of SQL authentication you MUST use 0.51a and you MUST tick the "NT Auth" tickbox on the login screen of the connection will fail.

The SQL server must have TCP/IP connections enabled and don't use the "hide ports" option in the SQL 2000 server network util as it does fail according to the testing i did.

If you use SQL 2005 and the SQL server is not on the PC you are connecting from (i assume it is fromt he IP address you are connecting to) then make sure remote connections are enabled in the surface area config tool as they are disabled by defalt. Also, SQL2005 installs as an instance by default and i have not even tested that type of setup as using and instance is not a good idea unless you already know how to use sql pretty well.

If the sql server is on the same machine you are connecting from then use 127.0.0.1 instead of it's lan ip.

re: chumpy's GM tools v0.61a

chumpy

when im trying to trigger this

CREATE TRIGGER [permanentitem] ON [dbo].[MyCashItem]
FOR INSERT, UPDATE, DELETE
AS
UPDATE [cabalcash].[dbo].[MyCashItem] SET
[DurationIdx] = 31

i get error that permanentitem exist

re: chumpy's GM tools v0.61a

Quote:

Originally Posted by ellemen

chumpy

when im trying to trigger this

CREATE TRIGGER [permanentitem] ON [dbo].[MyCashItem]
FOR INSERT, UPDATE, DELETE
AS
UPDATE [cabalcash].[dbo].[MyCashItem] SET
[DurationIdx] = 31

i get error that permanentitem exist

permanentitem exist??? meaning that you already create that trigger

re: chumpy's GM tools v0.61a

i didnt created it so idk how its exist..

re: chumpy's GM tools v0.61a

Why would you need a trigger to make the items all permanent when you can just add them with a durationidx of 31 in the first place? JoniverPH is correct though it does mean that the trigger already exists.

re: chumpy's GM tools v0.61a

hmm chumpy when im giving the item i can see it in Cash Menu but i cant recive it

thats what it says:

the item implementation has failed

re: chumpy's GM tools v0.61a

Quote:

Originally Posted by ellemen

hmm chumpy when im giving the item i can see it in Cash Menu but i cant recive it

thats what it says:

the item implementation has failed

the problem maybe on your centos DATE & Time, be sure to check if it the same date and time of your windows, in this case maybe your sent item is already expired.

in other problem it occurs depend on the item you are sending like divine weapon that can be only use on tierra gloriosa, nxt time plz indicate what item is your sending so we know what item you have problem ok..

About that trigger that johnph is mention um sorry bro but i dont recommend that because it auto insert of 31 on the duration id on every item you send, so it does no allow other id to be edited ( in my case ok i dont know to others ) aside of that when you sent blessing beads using this trigger it say it already expired instead of being permanent.... this is what i experience using that trigger so i remove it:native:

re: chumpy's GM tools v0.61a

Quote:

the item implementation has failed

This can also be caused by bad durationidx's like 0.

re: chumpy's GM tools v0.61a

Well thank you for this relese chumpy ^_^ ... its a grate job ...

I have 1 suggestion ... can you make a save option to save the IP / ID / Password?

Thanks again ... this is very useful .

re: chumpy's GM tools v0.61a

Quote:

Originally Posted by mmoobb

Well thank you for this relese chumpy ^_^ ... its a grate job ...

I have 1 suggestion ... can you make a save option to save the IP / ID / Password?

Thanks again ... this is very useful .

Awww. Ok.

Quote:

Originally Posted by First Post

v0.60a Changes:
* Some other minor tweaks
* Failed SQL calls now written to a logfile for easier debugging
* Added config .ini file support
* Added basic online user view
* Fixed prem type/kind to what they should be
* Added some char editing ability

re: chumpy's GM tools v0.61a

:) waiting more update...
tip:
1- cabalcash item > serveridx and server messaging > serveridx
can u make 1 line in config.php for choose/or save serveridx, all time i open program i need change 24 for 1 ^^

2- account detail > expiration date...
when you click button (+6m | right side | change plz :P) open a box like this, or similar for choose expire date...
http://img526.imageshack.us/img526/5880/exkr1.th.jpg
or box like account detail...
1- 30 days
2- 60 days
3- 90 days

3- cabalcash item > duration...
box for choose duration... same as account detail...
1 - 1 hour
2 - 2 hour
3 - 5 hour
4 - 10 hour
5 - 1 day
6 - 3 days
7 - 5 days
8 - 7 days
9 - 10 days
10 - 15 days
11 - 30 days
12 - 60 days
13 - 90 days
14 - 100 days
15 - 120 days
16 - 345 days
31 - permanent

re: chumpy's GM tools v0.61a

Yes the serveridx does need adding to the config.ini support. I will add it.

The +6m button doesn't actually work yet (i forgot to take it out), it is really just a placeholder and i already had a plan to do exactly what you said for both the prem expiry and the cabalcash duration. I actually didn't plan to release until i had added the rest of the char editing stuff but that last request was an easy one to fill and i'm still trying to work out why some people get the duplicate account error when no such account exists. I'm hoping the extra checks will give me some clues.

re: chumpy's GM tools v0.61a

premmium is not good
the other stuffs great release =)

re: chumpy's GM tools v0.61a

Quote:

Originally Posted by Chobito

premmium is not good

In what way? I have messed premium up once already, i don't want more bugs :/

re: chumpy's GM tools v0.61a

Thanks for listening to my suggestion :)

Nice release again ^_^

1 Problem ... the premium is not good ... it always give me error when i try to write my account and for me type 5 and option 1 is platinum ... and btw the script that auto give premium to all accounts don't let me change the premium :\ ... and i don't see there Platinum service ... only Diamond -.-" ...

EDIT : i forgot ... in the next release you will include an option to change the class rank and give aura code and change from mate to female and from female to male??
oh and i hope the skills will be available too ... :P ... because i see there is a window named Skill Info but nothing in it ^_^ or at last to give skill rank ... dual trans and skill points and not in last place what about honor setting ?

hehe i know i want too many ^_^ don't accuse me lol ... but it is a very useful tool and to edit those infos from DB is very annoying in special if you have more then 1k users -.-"

Another suggestion : a character delete command if its possible :-??

PS: if you search by character name its not working :(( ...

re: chumpy's GM tools v0.61a

The premium was changed to how it is now as people comments i had it wrong before and having tested it i found they were right. The Type should be 1 and not 5 and the ServiceType sets what type of prem it is, this is confirmed by examining the stored procedures that handle premum and also by the "unknown pay type 5" in the server logs if you set Type to 5. If your registerAccount SP has the old way of setting the Type to 5 you will get an error and the tools will correct it to prevent errors.

When testing i didn't see the results i was expecting in the client either but it is displaying what the client thinks the premium stats are and not what is in const.scp so it is yet another client desync bug. I am putting in a box that tells you exactly what premium option does what though.

The skills box was supposed to be completed before this version got released, i just got impatient. Searching by char name or idx doesn't work yet, nor does the +6m button on premium and lots of things are missing from the chars tab but i will be working hard on those bits this week.

Editing class and skills ranks is easy enough to do (that is what that enpty box is for) and so is honour, but adding aura codes might be harder as the battle aura is a skill not an attribute so i will have to decode the skill data binary i think. My plan is to do both item binaries and skill binaries at the same time as i want an item creator like the one in john_d's cabaltoolz.

Char and also account deletion is also coming but i need to be sure on what other things need removing too like clearing the charge_auth_table entry for deleted accounts, clearing quest data, inventory, warehouse and things like that for chars. Getting that wrong will cause problems for new accounts/chars so i need to be careful.

re: chumpy's GM tools v0.61a

Well adding aura code is easy ... and adding bike / combo skills too ... we already decrypted a part of binary text from skilllist but we are not 100% done ...

For adding the aura code you need to edit the character Style not the character skill list ... and for changing sex too ... from female to male and male to female ... and i think the hair style / color etc too ...

Here is an example ... if you have a WI female put this into style box : 142794915 ... this will make the wizz class rank 20 / give aqua aura code / change the sex to male and the hair style to normal 1 with a normal color ... if you want this for other classes just + or - with 1 untiled you find your class ...

We didn't worked on this untied now so we only know how to give aqua aura codes ...

About the delete characters ... you can't use the delcharacter stored procedure? i didn't tryed it yet but i think when you delete a character from the client it uses a procedure ... so maybe you can use it too in your tool :-\ ... sry if i'm wrong at this point ...

And about premium i will consult with our team and maybe change the auto give script to give type 1 and option 5 not type5 and option 1 ...

re: chumpy's GM tools v0.61a

Tnx chumpywumpy! i love your tool :)

Q:
When i set Type 1, ServiceKind=1 i am gain in game EXP like normal user, why? :) I test it... ServiceKind=2 realy give +25% EXP... but ServiceKind=1... no, strange :)

Re: chumpy's GM tools v0.61a

Updated. A few wishes granted ;)

Quote:

Originally Posted by changelog

* Fixed PremPayMinutes not getting saved
* Added DurationIdx dropdown to CabalCash tools
+ Also made some space for new controls (hint hint)
* Added honour editing
* Tidied the char panel up
* Added date picker for premium expiry date
* Added serveridx to config options
* Added premium servicekind and map/warpcode info buttons
* All search boxes on Chars tab now work
* Added a "set all offline" button

Premium is still not right. Values here are from the server files but the GP client does not agree.

Re: chumpy's GM tools v0.61a

Damn chumpywumpy, you fast work!!! :)

If you set Type 1, ServiceKind=1 - you get full prem accsess, i read this in game... but realy its fake, i am right undestand what you mean? Then when we can get sync. with server? I am use GP client.

I can ask this q here? How i can fix cost for items in server files... what file and how? I have bug report about HP poitions lvl2. They have wrong price in game. If you want buy 7 of them... you got D/C why? because in game you see price for 7 = 7000 alz, but realy you need 35 000 alz. If you not have 35 k ... you D/C..

Thank you for tool, work fine :)

Re: chumpy's GM tools v0.61a

@chumpywumpy
nice update, you tool help alot ;)
waiting more...
about premium, caz.enc, us client decripted...

Code:

<duration_svc id="0" name="duration_svc_00" type="0" exp="25" skill_exp="25" drop="25" craft="25" craft_success="0" inventory="0" warehouse="0" str="0" dex="0" int="0" attk="0" mgattk="0" ar="0" dr="0" defense="0" move_speed="0" sp="0" use_sp="0" bomb_alz="200" gps="1" inventory2="0" warehouse2="0" wexp="25" dummy="0" desc="duration_svc_desc_00" /> <duration_svc id="1" name="duration_svc_01" type="0" exp="25" skill_exp="50" drop="25" craft="25" craft_success="0" inventory="1" warehouse="1" str="0" dex="0" int="0" attk="0" mgattk="0" ar="0" dr="0" defense="0" move_speed="0" sp="0" use_sp="0" bomb_alz="0" gps="1" inventory2="1" warehouse2="0" wexp="25" dummy="1" desc="duration_svc_desc_01" /> <duration_svc id="2" name="duration_svc_02" type="0" exp="25" skill_exp="25" drop="0" craft="0" craft_success="0" inventory="0" warehouse="0" str="0" dex="0" int="0" attk="0" mgattk="0" ar="0" dr="0" defense="0" move_speed="0" sp="0" use_sp="0" bomb_alz="0" gps="1" inventory2="0" warehouse2="0" wexp="0" dummy="0" desc="duration_svc_desc_02" /> <duration_svc id="3" name="duration_svc_03" type="0" exp="0" skill_exp="0" drop="0" craft="25" craft_success="0" inventory="1" warehouse="0" str="0" dex="0" int="0" attk="0" mgattk="0" ar="0" dr="0" defense="0" move_speed="0" sp="0" use_sp="0" bomb_alz="0" gps="1" inventory2="0" warehouse2="0" wexp="0" dummy="0" desc="duration_svc_desc_03" /> <duration_svc id="4" name="duration_svc_04" type="0" exp="0" skill_exp="0" drop="25" craft="0" craft_success="0" inventory="1" warehouse="0" str="0" dex="0" int="0" attk="0" mgattk="0" ar="0" dr="0" defense="0" move_speed="0" sp="0" use_sp="0" bomb_alz="0" gps="1" inventory2="0" warehouse2="0" wexp="0" dummy="0" desc="duration_svc_desc_04" /> <duration_svc id="5" name="duration_svc_05" type="0" exp="50" skill_exp="50" drop="50" craft="50" craft_success="0" inventory="1" warehouse="1" str="0" dex="0" int="0" attk="0" mgattk="0" ar="0" dr="0" defense="0" move_speed="0" sp="0" use_sp="0" bomb_alz="0" gps="1" inventory2="0" warehouse2="0" wexp="0" dummy="0" desc="duration_svc_desc_05" />

@gpadmin
type = 1 and servicekind = 1 works fine for me...
i use sauron patch...
and a potion problem u need change here "/etc/cabal/data/data_world/worldXX-npc.scp"
XX = world ID, find all shop and change price

Code:

[ShopLst] NpcsIdx NSetIdx ItemKind ItemOpt ReputationClass DurationIdx Price 12 50 16 3 7 -19 0 420 13 50 17 4 7 -19 0 5600 14 50 18 5 7 -19 0 35000 <-- here 15 50 19 6 7 -19 0 420 16 50 20 7 7 -19 0 5600 17 50 21 8 7 -19 0 35000 <-- here

@chumpywumpy
about durability, just check this...
product.scp
chinese client

Code:

[ItemDuration] DurationIdx ItemType Day Hour 0 1 1 0 1 1 2 1 0 2 2 3 1 0 5 3 4 1 0 10 4 5 1 1 0 5 6 1 3 0 6 7 1 5 0 7 8 1 7 0 8 9 1 10 0 9 10 1 15 0 10 11 1 30 0 11 12 1 60 0 12 13 1 90 0 13 14 1 100 0 14 15 1 120 0 15 16 1 365 0 16 17 1 4 0 17 18 1 0 0 18 19 1 0 0 19 20 1 0 0 20 21 1 0 0 21 22 1 0 0 22 23 1 0 0 23 24 1 0 0 24 25 1 0 0 25 26 1 0 0 26 27 1 0 0 27 28 1 0 0 28 29 1 0 0 29 30 1 0 0 30 31 1 0 0

english client

Code:

[ItemDuration] DurationIdx ItemType Day Hour 0 1 0 0 1 1 2 0 0 2 2 3 0 0 3 3 4 0 0 5 4 5 0 0 10 5 6 0 0 12 6 7 0 1 0 7 8 0 2 0 8 9 0 3 0 9 10 0 5 0 10 11 0 7 0 11 12 0 10 0 12 13 0 14 0 13 14 0 20 0 14 15 0 30 0 15 16 0 45 0 16 17 0 60 0 17 18 0 90 0 18 19 0 100 0 19 20 0 180 0 20 21 0 270 0 21 22 0 365 0 22 23 0 15 0 23 24 0 0 0 24 25 0 0 0 25 26 0 0 0 26 27 0 0 0 27 28 0 0 0 28 29 0 0 0 29 30 0 0 0 30 31 0 0 0

need remake product.scp ((0 ~ 57) item_type) for works fine... (using sauron patch)

Re: chumpy's GM tools v0.61a

yep... in first time i run this new version i get similar error... but now... work fine...
maybe chumpywumpy can tell us what is this...

Re: chumpy's GM tools v0.61a

The error is because of a missing dependency, the one used to add the date picker in this version. I didn't include that one as i thought everyone would have it already but obviously not. I have updated the links and added it so just re-download and it should work. If not run the "regocxs.bat" or better yet copy all of the files apart from the .bat and the .exe to c:\windows\system32 and then run the .bat to register the controls with the OS.

@chacina - Thanks once again for the info. You have saved me digging around to find the client values :D

Re: chumpy's GM tools v0.61a

I have a theory for 'mail', maybe we should send packet to server for force the client verify 'mail'
(for show mail button on middle/right side and change mail type)..
is just theory ^^
maybe don't work...

same for cashitem, have delay time but if you open internal cash shop and close you client update instantly...

Re: chumpy's GM tools v0.61a

2chacina
Thank you so much man :)

Maybe you know where i can find SAUR0N descrypter for cabal files???

And what game client you use and server? how your compability server+ client? I am use atm GP client and chump server. All work very fine.. i have only little bug with 7 HP potions... What you think about SAUR0N patch?

Re: chumpy's GM tools v0.61a

SAUR0N descrypter for cabal files???
i never see... i have suggestion for you
download decripted us client files from sauron, *OLD POST*
and try sync some files or download sauron patch... works fine...

Re: chumpy's GM tools v0.61a

i got a problem with 61a

rutine error 76
path not found

Re: chumpy's GM tools v0.61a

Quote:

Originally Posted by chacina

SAUR0N descrypter for cabal files???
i never see... i have suggestion for you
download decripted us client files from sauron, *OLD POST*
and try sync some files or download sauron patch... works fine...

Ok, i see, tnx

Starting testing SAUR0N patch atm... work fine. Intrestin, you fix somthing in your server after install this patch?

Re: chumpy's GM tools v0.61a

yes... const.scp and product.scp
const.scp

Code:

[DurationSvc] DurationSvcIdx Type Exp SklExp Drop Craft CraftSuccess Inventory Warehouse Str Dex Int Attk MgAttk AR DR Defense MoveSpeed SP UseSP BombAlz Inventory2 Warehouse2 dummy 0 0 0 25 25 25 25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 200 0 0 0 1 1 0 25 50 25 25 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 2 2 0 25 25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 3 0 0 0 0 25 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 4 0 0 0 25 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 5 0 50 50 50 50 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 [BlessingbeadSvc] BlessingbeadSvcIdx Type Exp SklExp Drop Craft CraftSuccess Inventory Warehouse Str Dex Int Attk MgAttk AR DR Defense MoveSpeed SP UseSP BombAlz Inventory2 Warehouse2 dummy 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 2 1 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 3 1 25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 4 1 0 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 5 1 0 25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 6 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 8 2 25 25 25 25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 200 0 0 1 8 9 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 9 10 1 0 50 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

product.scp

Code:

[ItemDuration] DurationIdx ItemType Day Hour 0 1 0 0 1 1 2 0 0 2 2 3 0 0 3 3 4 0 0 5 4 5 0 0 10 5 6 0 0 12 6 7 0 1 0 7 8 0 2 0 8 9 0 3 0 9 10 0 5 0 10 11 0 7 0 11 12 0 10 0 12 13 0 14 0 13 14 0 20 0 14 15 0 30 0 15 16 0 45 0 16 17 0 60 0 17 18 0 90 0 18 19 0 100 0 19 20 0 180 0 20 21 0 270 0 21 22 0 365 0 22 23 0 15 0 23 24 0 0 0 24 25 0 0 0 25 26 0 0 0 26 27 0 0 0 27 28 0 0 0 28 29 0 0 0 29 30 0 0 0 30 31 0 0 0

this one u need make 57 itemtype
like this

Code:

31 1 1 0 1 .... .... 61 31 1 0 0 62 1 2 0 1 .... .... 92 31 2 0 0

Re: chumpy's GM tools v0.61a

Quote:

Originally Posted by chacina

I have a theory for 'mail', maybe we should send packet to server for force the client verify 'mail'
(for show mail button on middle/right side and change mail type)..
is just theory ^^
maybe don't work...

same for cashitem, have delay time but if you open internal cash shop and close you client update instantly...

I think you might be right. Trying different clients doesn't make any difference. I don't know for sure that the US cabalmain.exe we are using actually does have a popup when new mail arrived though. The cabalcash item popup appears ok (but after a delay) so i can't see any reason why the mail one does not. I have been testing all of the different mail types and none of them show it :(

@mirceagab - I suspect it is having trouble creating config.ini in the folder you are running the tools from as the ini is about the only thing it uses a path for. There is no way it can be erroring reading the ini as that is set to ignore all errors and continue regardless, but i can see how it could error writing to one. Try running it from c:\ and see if that helps as i don't think that function will handle long pathnames or paths with spaces well as it is. I will have to fix that.

Re: chumpy's GM tools v0.61a

Hey Chumpy anytime I try to run the program I keep getting this error.

http://img440.imageshack.us/img440/3295/57634417no7.jpg

No matter what version I use.

Re: chumpy's GM tools v0.61a

Do you get that when actually starting the tools, or when using the "online chars" tab? Also, what operating system do you use and i have been told about errors on Vista but i have no Vista machine to test with.

Re: chumpy's GM tools v0.61a

It's when I start the tools. And I'm using XP Home.

Re: chumpy's GM tools v0.61a

Code:

I'm using XP Home

try XP Pro SP2

Re: chumpy's GM tools v0.61a

Quote:

Originally Posted by willow01

It's when I start the tools. And I'm using XP Home.

I can't get this to happen at all. I can guess what is causing it but i need more info really. I'll add some new checks where i think it is having problems and post a new version either tonight or tomorrow.

Re: chumpy's GM tools v0.61a

Quote:

Originally Posted by chacina

Code:

I'm using XP Home

try XP Pro SP2

Tried it, same error. Thanks though.

Quote:

Originally Posted by chumpywumpy

I can't get this to happen at all. I can guess what is causing it but i need more info really. I'll add some new checks where i think it is having problems and post a new version either tonight or tomorrow.

It's odd it's the same the owner of the server running and he says his is working fine.....well I shouldn't say he says it, because I know his is working fine.

Thanks Chumpy I'll let you know if the updated one works or not on my system when you get it up.

Re: chumpy's GM tools v0.61a

Requesting to Add Gift for all

Example i want to put all account 30days Astral bike.

Re: chumpy's GM tools v0.61a

Quote:

Originally Posted by willow01

It's odd it's the same the owner of the server running and he says his is working fine.....well I shouldn't say he says it, because I know his is working fine.

Thanks Chumpy I'll let you know if the updated one works or not on my system when you get it up.

Sorry i took so long. I have had to think about this one a bit.

It is very odd and the more i look think the more i am convinced it is actually not my code throwing that up as there is no way it should run out of memory on ANY system (it takes ~10kb). I use several external libs and controls for doing various things and i think one of these is causing the error when i am loading it and it is taking the tools down with it.

If i am right this will tell me exactly what. Below is a set of small exes and each one tests one of the controls or external functions used by the tools. Run them one by one and you should either see an "i work" window or a popup box saying it worked. If any of them fail then i need to know which test as that one is the problem.
http://www.mediafire.com/download.php?ztuomiqjojz

Quote:

Originally Posted by netlink

Requesting to Add Gift for all

Example i want to put all account 30days Astral bike.

With the tools you can just give the bike to the players :P The tools are not the best way to do this really as it is better being done in the database itself or people registering via a webpage or something like that wouldn't get the bike. I know people really want to be able to do stuff like this though ;)

Re: chumpy's GM tools v0.61a

Done, the exe marked test_comctrl6 came up with this error.

http://img262.imageshack.us/img262/3606/3456yz8.jpg

Everything else worked just fine. Hope this helps you out Chumpy. And no worries about how long it takes. I'm not one to pressure people to fix it.

Re: chumpy's GM tools v0.61a

Ah i thought so. Ok google for MSCOMCTL.OCX v6.1 or later and put it in c:\windows\system32. Now click Start->Run and put the following in:

Code:

regsvr32 MSCOMCTL.OCX

Click Ok and it should say successful. Try the tools again and hopefully it should work.

Here is a link to the one i am using.
http://www.mediafire.com/download.php?jzezekin11y

Re: chumpy's GM tools v0.61a

Done, used the OCX file you use. Did the regserv

I ran the diag tests just to be sure this time. test_com26.exe gives me the error now. But the test_comctrl6.exe doesn't.

Re: chumpy's GM tools v0.61a

Same thing but the command is "regsvr32 mscomct2.ocx" this time.

http://www.mediafire.com/download.php?mje1deqnkdn

I will include these in the next release so it doesn't cause problems again. This is why i hate using external libs when i can't confirm they actually exist in my code :P

Re: chumpy's GM tools v0.61a

Everything worked perfectly this time around, after I ran the regserv32, then the tests all tests passed. Then I ran the GM tools itself, and it's now working. Thanks Chumpy.

Re: chumpy's GM tools v0.61a

I try add ithem but there is it in game? =(

Re: chumpy's GM tools v0.61a

Do you mean where are the CabalCash items? They don't appear right away and you must remember to send them to the right ServerIdx that you set in the server ini files.

Re: chumpy's GM tools v0.61a

Great job chumpy, just want to say thanks here :D
btw, will u keep workin on the messaging sys?

Re: chumpy's GM tools v0.61a

Yes i am still working on the messaging system though to be honest there is only so much i can do from the tools themselves as there are limitations at the server end (such as delivery speed) that i cannot influence. The "send to all online" was pretty much just a quick hack to get the ability in as so many people wanted it.

At the moment i am working on class editing and beginning work on an itemopt creator similar to the one in cabaltoolz. Once i have the itemopt creator and refined the cabcalcash interface slightly it will be linked to the mail interface if you really want to know what is next ;)

Re: chumpy's GM tools v0.61a

Quote:

Originally Posted by chumpywumpy

Yes i am still working on the messaging system though to be honest there is only so much i can do from the tools themselves as there are limitations at the server end (such as delivery speed) that i cannot influence. The "send to all online" was pretty much just a quick hack to get the ability in as so many people wanted it.

At the moment i am working on class editing and beginning work on an itemopt creator similar to the one in cabaltoolz. Once i have the itemopt creator and refined the cabcalcash interface slightly it will be linked to the mail interface if you really want to know what is next ;)

Awesome, thanks again and keep ut the good work :thumbup:

Re: chumpy's GM tools v0.61a

the item implementation has failed
forcium cube and the bracelet of fighter +4

Re: chumpy's GM tools v0.61a

You used an invalid DurationIdx, try 31.

1 Attachment(s)

Re: chumpy's GM tools v0.61a

ya im using the (31)(permanent) on your tools wit serverldx =24
item opt = 0
item id = 1164

im using the gp client wit sauron sync patch
and all of files and guide

dunno wats the problem i check the centos clock also its just a 2 hour away from my windows clock
screenshot below

Re: chumpy's GM tools v0.61a

Well, first of all, hi there :D. Second: I'd like to say a huge THANK YOU! to chumpy, because he made it possible for me to put my server up :D So here is my problem: a couple of weeks a go i downloaded the v0.60a of the GM tools, worked like a charm, except for the last tab (crashed a lot when i tried to do stuff with it) and now with the newest release I get some weird error: "Run-time error "380" Invalid property value". I googled it, nothing that actually helped me turned out... I'm using Windows Vista 32bit, i hate xp thats the reason. I tried making it run under xp with the "Compatibility" tab, runned it as an administator etc. nothing works, so if you have an idea, please share it :D Thanks in advance

cheers,
Deko

Re: chumpy's GM tools v0.61a

Quote:

Originally Posted by perwisyo

ya im using the (31)(permanent) on your tools wit serverldx =24
item opt = 0
item id = 1164

im using the gp client wit sauron sync patch
and all of files and guide

dunno wats the problem i check the centos clock also its just a 2 hour away from my windows clock
screenshot below

Hmmm, i think you have something non-standard in your gp client. This sounds very like some problems i had before i rebuilt the client and i am certainly not getting the problem now as i checked it.

Does it affect all durationidx or just some? Also, have you patched the const.scp values and product.scp in the server data as mentioned on SAUR0N's post?

Quote:

Originally Posted by deso_2006

Well, first of all, hi there :D. Second: I'd like to say a huge THANK YOU! to chumpy, because he made it possible for me to put my server up :D So here is my problem: a couple of weeks a go i downloaded the v0.60a of the GM tools, worked like a charm, except for the last tab (crashed a lot when i tried to do stuff with it) and now with the newest release I get some weird error: "Run-time error "380" Invalid property value". I googled it, nothing that actually helped me turned out... I'm using Windows Vista 32bit, i hate xp thats the reason. I tried making it run under xp with the "Compatibility" tab, runned it as an administator etc. nothing works, so if you have an idea, please share it :D Thanks in advance

cheers,
Deko

This sounds very much like one of the controls acting up, similar to this problem so i would try that first ->http://forum.ragezone.com/f459/chump...ml#post4163070

This is the exact error in Vista i have heard of but i have had no info to try and fix it with so far so hopefully you can help me get to the bottom of it :ott:

Re: chumpy's GM tools v0.61a

@chumpy
just some item and i already patched the product and const
is there any patch needed to my client or is it the gp and sauron patch only coz some are still in chinese like in my character selection screen after i have log in the "premium user" is in chinese

edit: errr sory it was the first client shared by darkxl hahahaha i thought it was the gp client but when i try to seach the gp client is the gamersplanet official client lol hahahaha..... anyway thanks for the reply chumpy ^_^ god bless u bro

edit: i cant seem to download to ogplanet can anyone share a fully updated client of gp? or bets if ur private server using thx!

Re: chumpy's GM tools v0.61a

Quote:

This sounds very much like one of the controls acting up, similar to this problem so i would try that first ->http://forum.ragezone.com/f459/chump...ml#post4163070

This is the exact error in Vista i have heard of but i have had no info to try and fix it with so far so hopefully you can help me get to the bottom of it :ott:

Well mate, i downloaded the archive, ran all the test but i passed everything. I MAY have found something... It's called autopatcher, google actually rocks :D I'm currently downloading some updates via the app and i'm gonna post an update (edit mode) later.

Quote:

7) Run-time error '380': Invalid property value
Copy files from C:\Program Files\AutoPatcher\bin to C:\Windows\System32

this quote is taken from the autopatcher's faq page.

Re: chumpy's GM tools v0.61a

Hello,i downloaded this cabal GM`s tools 0,62 version and i need a hint!!!
when i open it
it says server:127.0.0.1 port:1433
what to put in login tab? and password tab? i mean what account?
and below is account:account cabalcash:cabalcash
gamedb:gamedb manager:cabalmanager_db

i`m interested what should i put in all these fields?And what kind of software this is...i mean what does this software? With best regards

Re: chumpy's GM tools v0.61a

My tools are designed for basic management of cabal accounts and players. The login and pass fields want the user and pass needed to access your game database and i recommend using your "sa" logon (the password was set when you installed mssql) to log into the db. The other fields can be ignored unless you use custom db names.

Well,thanks for ur reply
and what is SA logon...???
and what is mssql and where i can download it?

With best regards

OK,i`ve installed and configured mssql 2005 on ur guide that u posted and i made databases..etc..
and i downladed chumpy`s cabal GM tool v 0.62 alpha...and i logged in WITH (SA) login..and i had success
And now i need help how to log in my cabal acc in that tool..how to manage it....
I`m wondering could u post tutorial on this tool...please i need it...
answer as soon is possible!!!

Re: chumpy's GM tools v0.61a

Quote:

Originally Posted by Kapamadzin

OK,i`ve installed and configured mssql 2005 on ur guide that u posted and i made databases..etc..
and i downladed chumpy`s cabal GM tool v 0.62 alpha...and i logged in WITH (SA) login..and i had success
And now i need help how to log in my cabal acc in that tool..how to manage it....
I`m wondering could u post tutorial on this tool...please i need it...
answer as soon is possible!!!

Once you have created your account you need to download a client (GP or US) and then log in.

http://forum.ragezone.com/f459/how-p...-client-478710

Re: chumpy's GM tools v0.61a

Hehe thank u...but my cabal client is EUROPE...i hope it works for EU cabal client version..
and after i did all that in ur guide which u posted creating ,bat file....what should i do next ?

Re: chumpy's GM tools v0.61a

Yes the EU client does work ok, i have tested it myself and i know a few people that prefer it over the US one. Next you run the .bat file and try logging in ;)

When i start this .bat file it start my cabal and when i need to type my username and password it says
U`VE BEEN DISCONNECTED FROM THE SERVER BY PROTECTION HACKING SYSTEM...like when u try to use old version bot...and gameguard discovers it...
please help me out.....

And i get one more disconnection...
when i start .bat file...it start cabal and when i want to enter and login within my cabal account it says
U got disconnected from the server...please exit game...and try again...
i`m sure u know the reason why that error and DC occured....

Re: chumpy's GM tools v0.61a

You are using your official EU cabalmain.exe and this won't work, also gameguard stopped cabalmain.exe from running.

You will need to find a hexed cabalmain.exe from one of the stickies here. I would suggest SAUR0N's synch patch, though that is best used with the US client.

Re: chumpy's GM tools v0.61a

Where i can download SAURON`S synch patch?

Re: chumpy's GM tools v0.61a

What No-ip Port ?

Re: chumpy's GM tools v0.61a

Which ip is the sql server ip and where can i see what port i need to access sql ?

Re: chumpy's GM tools v0.61a

Quote:

Originally Posted by palm1212

What No-ip Port ?

No-ip is nothing to do with SQL. I would recommend starting the tools from the db server to start with to ensure it works from there, then test remotely and if the remote connections fail then either a firewall or a surface area config is wrongh. The default port for mssql is 1433.

Quote:

Originally Posted by Hamscer

Which ip is the sql server ip and where can i see what port i need to access sql ?

The ip is whichever windows machine you installed the DB on and the default port is 1433.

Re: chumpy's GM tools v0.61a

Hello,

I've a problem about Expired Date after adding item by this tool (select DurationIdx 31).
When receiving new item, it says that the item has no limited time.
after accepted it, moved to inventory, still no limited.
but in the "Instant Item" on the left side, it shows that item has "Expired Date: 2008-xx-xx xx.xx" and it will expire immediately after that time.
Anyway, when drag mouse on the item name, it shows no limited. I'm so confused about this.

The date value wont be fixed, may be 1 or 2 hours or few day but i added it with DurationIdx=31 only.

Is this my server's problem?

Thanks in advance.

Re: chumpy's GM tools v0.61a

Different clients use different values for the durationidx. For example the chinese client uses different values than the us client. To make matters worse different clients display different things and what the client displays could be different to what it actually is. I don't think we will ever have a 100% accurate client until we can edit the enc files :(

Re: chumpy's GM tools v0.61a

where can i get itemlist.xls?

Re: chumpy's GM tools v0.61a

V.0.50a and V.0.51a is OFF.... =(

Re: chumpy's GM tools v0.61a

Yes i have removed the older versions now as i needed to clean up my mediafire account a bit. I see no point running older buggier versions.

Re: chumpy's GM tools v0.61a

Sir Chump, it would be nice to see cashshop admin included in your future releases. ;)

1 Attachment(s)

Re: chumpy's GM tools v0.61a

Help me please program chumpy's GMTools error

Re: chumpy's GM tools v0.61a

At long last somebody has finally told me what the error they get on Vista is!! I have has several reports but nobody would tell me what the error is so thank you :D

I will check that as soon as i get home from work which should be about 4 hours so so.

Re: chumpy's GM tools v0.61a

i know the login and pass for my ms sql server but it wont connect?

i dont know what ip i put in the server box :?:

i try to use m computers ip for my internet connection but it didnt work.......

Re: chumpy's GM tools v0.61a

Quote:

Originally Posted by xXxGUITARISTxXx

i know the login and pass for my ms sql server but it wont connect?

i dont know what ip i put in the server box :?:

i try to use m computers ip for my internet connection but it didnt work.......

If you're running the GM tool on the same machine where the database reside, you can use the default 127.0.0.1 (localhost) to log in. As for the user name and password, you can use the default "sa" password is whatever u put in when u install MSSQL or create another user name in the security tab in the database.

Re: chumpy's GM tools v0.61a

well, its still not working. im using the right ip(i tried both local host and my ip), the right username(sa) and pass(i made when i installed sql). i allowed the tcp connection through sql but still no luck, i still get an error............ maybe the port but idk how to get the right port