charater creation failure

I cant create a new charater and when I check syntax in sp_newchar there is an eror
http://www.freeimagehosting.net/imag...e79f313c91.jpg

Here is mine. We are all using the same dbs though so i seriously doubt the SP is bugged. Char creation errors are almost always down to linked server settings so check your logs carefully for errors.

Code:

---

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

/****** Object:  Stored Procedure dbo.cabal_sp_newchar    Script Date: 2008-4-14 5:52:47 ******/

ALTER  PROCEDURE [dbo].[cabal_sp_newchar] (@charname varchar(16), @characteridx  int, @style int, @stylemast int)
AS
begin
SET NOCOUNT ON
        if( exists ( select * from cabal_badwoard where badword=@charname ) ) select convert(int,0x04)       
        else if( exists ( select * from cabal_character_table where Name=@charname ) ) select convert(int,0x03)
        else if( exists ( select * from cabal_character_table where characteridx=@characteridx ) ) select convert(int,0x02)
        else if( @stylemast < 0x01 or @stylemast > 0x06 ) select convert(int,0x02)
        else
        begin
                -----------------------------------------------------------------------------------------------
                declare @RegTime dateTime, @userNum int, @serverIdx int, @result int
                set @userNum = @characterIdx/8
                set @serverIdx = dbo.getServerIdx()
                set @RegTime = getDate()
                set @result = convert(int, 0xA0) + @stylemast
                ------------------------------------------------------------------------------------------------

                select charTable.*, etcTable.equipmentData, etcTable.inventoryData, etcTable.skillData,
                          etcTable.quickSlotData, etcTable.questData, etcTable.questFlagsData
                into #tempTable
                from account.dbo.cabal_newCharData_table as charTable,
                        account.dbo.cabal_newEtcData_table as etcTable,
                        ( select top 1 charDataIdx, etcDataIdx from account.dbo.cabal_newFlagData_table
                          where channel = @serverIdx) as flagTable
                where flagTable.etcDataIdx = etcTable.dataIdx and flagTable.charDataIdx = charTable.dataIdx
                          and charTable.classType = etcTable.classType and charTable.classType = @stylemast
               
                IF( NOT EXISTS ( select * from #tempTable))
                BEGIN
                        select convert(int, 0x01)
                        drop table #tempTable
                        return
                END
                -----------------------------------------------------------------------------------------------               
                -- 캐릭터 카운트 증가
                EXEC account.dbo.cabal_sp_update_character_count @userNum, @serverIdx, 1
               
                --캐릭터 생성
                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
               
                begin tran
                insert into cabal_equipment_table (characterIdx, data) select @characteridx, equipmentData from #TempTable
                insert into cabal_inventory_table (characterIdx, data) select @characteridx, inventoryData from #TempTable
                insert into cabal_skilllist_table (characterIdx, data) select @characteridx, skillData from #TempTable
                insert into cabal_quickslot_table (characterIdx, data) select @characteridx, quickSlotData from #TempTable
                insert into cabal_questdata_table (characterIdx, data, flags) select @characteridx, questData, questFlagsData from #TempTable
                commit tran
                ----------------------------------------------------------------------------------------------

                -- 리턴값 0xA1 ~ 0xA6
                drop table #tempTable
                select convert(int, @result)
                -----------------------------------------------------------------------------------------------       
        end

SET NOCOUNT OFF
end

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

---

thanks man that really helped

but now I need GM tools that gives me skills

and premium stats i CANT GIVE

Don't triple post like that again, there is an edit button you know :mellow:

My GM tools can be found on the link in my sig and they can do stuff like that. Don't expect anything good from gm commands though because they aren't in Cabal, plus if you enable them everybody gets them so best to keep them disabled.

okz sory...
but I want to gime to my self class rank but with youre tolss I dont see how or is it possible?

Possible but very hard. There are lots of possible problems editing the class binary value as well.

http://forum.ragezone.com/f459/php-s...-style-448801/

and how to make pets lvl upp?

You can't. Our server code is quite old and doesn't have pet levelling, chaos arena or anything newer. There isn't anything we can do about it unless newer server files get leaked.

damm it suck