Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Chumpy's 2009 Cabal gift box

The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
As it's that time of year i scraped around my drives for any little snippets i never posted. I put a few into a gift box for you. And no, this isn't my main xmas release :wink:

chumpywumpy - Chumpy's 2009 Cabal gift box - RaGEZONE Forums




To see what is in there you will have to open it!

Please use the
chumpywumpy - Chumpy's 2009 Cabal gift box - RaGEZONE Forums
button instead of saying thanks if you like it ;)
 
Last edited:
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
have any clue how to run this file ....

thnks

It is a collection of files that all do different things. If there is no readme.txt in the relevant folder there is another .txt file which explains what the item is and how to use it.

So far 11 "thank you" posts have been removed. Please use the button!
 
Joined
May 23, 2008
Messages
1,071
Reaction score
574
First: Holy %#%& thanks :p
Second, [and why I am posting this and not just giving thanks]: I tried to make your free item thingamajig SQL work, and it didn't at first. After testing just the base queries, I realized that the tables name that you give the creation sql for is FreeItemLog... while the name in the procedure edit is FreeItems. Either edit the procedure or edit the table name, to make them both match eachother, then it will work. Otherwise it wont work and people can't make new characters. Besides for this small issue, it works fine, GJ.
Third, if you want this to give alz instead of items, put this in the same spot in the sp newchar procedure where chumpy's edit goes, but instead of her edit to the procedure, put this:
Code:
		-- #### Free items only given once per account ####
		declare @AlzAmnt int

		-- Configure your free item here
		set @AlzAmnt = 40000000

		if(not exists (select * from cabalcash.dbo.FreeItemLog where UserNum=@userNum and ItemIdx=@alzamnt and ItemOpt=0 and DurationIdx=0))
		begin
update cabal_character_table set alz = alz + @AlzAmnt where characteridx = @characteridx 
		insert into cabalcash.dbo.FreeItemLog ( UserNum, ItemIdx, ItemOpt, DurationIdx, Claimed )
		values (@userNum,@alzamnt,0,0,GetDate())
		end
		-- #### Ends free items ####
Change 40000000 to the amount of alz you want to give.
Now, it will check and log whats its giving by putting the alz amount into ItemIdx, and keeping ItemOpt and DurationIdx equal to 0. This way it's less editing for you, which makes it simpler, yet it still works perfectly.
Tested on my server and works perfectly. HF!
 
Last edited:
Joined
Feb 6, 2010
Messages
1
Reaction score
0
-- #### Free items only given once per account ####
declare @AlzAmnt int

-- Configure your free item here
set @AlzAmnt = 40000000

if(not exists (select * from cabalcash.dbo.FreeItemLog where UserNum=@userNum and ItemIdx=@alzamnt and ItemOpt=0 and DurationIdx=0))
begin
update cabal_character_table set alz = alz + @AlzAmnt where characteridx = @characteridx
insert into cabalcash.dbo.FreeItemLog ( UserNum, ItemIdx, ItemOpt, DurationIdx, Claimed )
values (@userNum,@alzamnt,0,0,GetDate())
end
-- #### Ends free items ####
 
Newbie Spellweaver
Joined
Dec 15, 2009
Messages
5
Reaction score
0
how to find
Code:
		insert into cabal_character_table( CharacterIdx, Name, LEV, [EXP], [STR], DEX, [INT], PNT, Rank, Alz,
			WorldIdx, [Position], Style, HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation, Reserved1 )
		select  @characteridx, @charname, LEV, [EXP], [STR], [DEX], [INT], [PNT], Rank, Alz,
				WorldIdx, Position, @style, HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation, Reserved1
		from #TempTable
and how to change it :blush:


Gmtool login error ever user
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.IO.FileNotFoundException: Could not load file or assembly 'System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified.
File name: 'System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'
at ChumpyGMTools.Form1.read_itemlist()
at ChumpyGMTools.Form1.Form1_Load(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
GM Tools
Assembly Version: 2.0.0.0
Win32 Version: 2.0.0.0
CodeBase: file:///C:/Downloads/Chumpy's-Cabal-2009-xmas-gift-box/GM%20tools%20v2%20(alpha)/GM%20Tools.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

chumpywumpy - Chumpy's 2009 Cabal gift box - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
Last edited:
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
I'm not sure which mod you are using in the first one but it should be telling you which stored procedure to edit. It looks like cabal_tool_registerAccount which in the Stored Procedures folder inside the account db.

For the second one make sure you have .net 3.5 as the tools need the latest version.
 
Back
Top