Chumpy's 2009 Cabal gift box

[chumpywumpy]

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



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

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

Please use the button instead of saying thanks if you like it ;)

[MentaL]

[GhostBaster]

have any clue how to run this file ....

thnks

[chumpywumpy]

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!

[TimeBomb]

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:

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

[salt0nlnja]

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

[bonparadorn]

how to find

		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


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]

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.