chumpy's GM tools v0.61a

[chumpywumpy]

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 ->

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

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 ->

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

Mirror->

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

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 ->

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

Mirror->

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

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

v0.51a Download ->

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

v0.50a Download ->

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

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

 

[myliquid]

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

 

[[hidden]]

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

 

[chumpywumpy]

Re: chumpy's GM tools v0.50a

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.

 

[chacina]

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

 

[darkxl]

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

 

[jaeker1]

Re: chumpy's GM tools v0.50a

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

 

[chacina]

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

 

[normalblue]

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?

 

[hacker08]

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

 

[chumpywumpy]

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.

 

[cypher]

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.

 

[Revmed]

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

 

[JoniverPH]

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

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

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

btw: here is your sig

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

 

[flyba]

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

 

[JoniverPH]

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

Thanks pre

i will post the result after test...

EDIT: Works Perfect... Good Job

 

[flyba]

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

 

[normalblue]

Re: chumpy's GM tools v0.50a

@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.

 

[flyba]

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

 

[chumpywumpy]

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.