Chumpy's 2009 Cabal gift box

Results 1 to 7 of 7
  1. #1
    The Dinosaur chumpywumpy is offline
    MemberRank
    Jun 2008 Join Date
    /f451/Location
    5,127Posts

    idea Chumpy's 2009 Cabal gift box

    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 ;)
    Last edited by chumpywumpy; 21-12-09 at 11:49 PM.


  2. #2
    Valued Member GhostBaster is offline
    MemberRank
    Oct 2008 Join Date
    MalaysiaLocation
    141Posts

    Re: Chumpy's 2009 Cabal gift box

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

    thnks

  3. #3
    The Dinosaur chumpywumpy is offline
    MemberRank
    Jun 2008 Join Date
    /f451/Location
    5,127Posts

    Re: Chumpy's 2009 Cabal gift box

    Quote Originally Posted by GhostBaster View Post
    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!

  4. #4
    Software Person TimeBomb is offline
    ModeratorRank
    May 2008 Join Date
    United StatesLocation
    1,252Posts

    Re: Chumpy's 2009 Cabal gift box

    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 by TimeBomb; 04-01-10 at 09:18 AM.

  5. #5
    Novice salt0nlnja is offline
    MemberRank
    Feb 2010 Join Date
    1Posts

    Re: Chumpy's 2009 Cabal gift box

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

  6. #6
    Apprentice bonparadorn is offline
    MemberRank
    Dec 2009 Join Date
    6Posts

    Re: Chumpy's 2009 Cabal gift box

    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


    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.

    Attached Thumbnails Attached Thumbnails untitled.bmp  
    Last edited by bonparadorn; 19-04-10 at 01:20 AM.

  7. #7
    The Dinosaur chumpywumpy is offline
    MemberRank
    Jun 2008 Join Date
    /f451/Location
    5,127Posts

    Re: Chumpy's 2009 Cabal gift box

    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.



Advertisement