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

[MentaL]

[myliquid]

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

[[hidden]]

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]

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]

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

Thx!

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

[jaeker1]

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

[chacina]

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]

I got message

Run time error '380'
Invalid Property Value

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

[hacker08]

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]

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

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]

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]

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 http://www.geocities.com/elitus_joni...noy_dimple.gif

[flyba]

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

[JoniverPH]

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]

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]

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

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

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.

[Revmed]

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

[kumpon]

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

[chumpywumpy]

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.

[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

[JoniverPH]

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