[Error] creating char error

Page 2 of 2 1 2
01/28/2015 14:20 Zodiao#16
Can I see your _AddNewChar SP?

Quote:
Originally Posted by xExorcist View Post
Use a clean database or another _AddNewChar SP
And, xExorcist, you can't tell anyone to use a clean database as a solution, that's stupid tbh, most-likely he at least has changed one thing in his database, that he is not willing to re-change.
01/29/2015 06:24 ​Exo#17
Quote:
Originally Posted by Zodiao View Post
Can I see your _AddNewChar SP?



And, xExorcist, you can't tell anyone to use a clean database as a solution, that's stupid tbh, most-likely he at least has changed one thing in his database, that he is not willing to re-change.
That's why we said try a different _AddNewChar procedure, probably something is wrong there.
01/29/2015 08:13 MissinGDeaTh#18
here's my _AddNewChar SP

PHP Code:
USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddNewChar]    Script Date: 1/29/2015 8:12:20 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




ALTER PROCEDURE [dbo].[_AddNewChar]
    @UserJID            INT,        
    --@CharSlot            INT,        
    @RefCharID            INT,        
    @CharName            varchar (64),        
    @CharScale            tinyINT,        
    @StartRegionID            INT,        
    @StartPos_X            real,        
    @StartPos_Y            real,        
    @StartPos_Z            real,        
    @DefaultTeleport    INT,        
    @RefMailID            INT,        
    @RefPantsID            INT,        
    @RefBootsID            INT,        
    @RefWeaponID        INT,        
    @RefShield            INT,        
    @DurMail            tinyINT,        
    @DurPants            tinyINT,        
    @DurBoots            tinyINT,        
    @DurWeapon            tinyINT,        
    @DurShield            tinyINT,        
    @DefaultArrow        INT
AS    
    
SET NOCOUNT ON      

    DECLARE @Slot  INT        
    DECLARE @temp  INT        
            
    DECLARE @NewCharID  INT        
    SET @NewCharID = 0        
       
       
    -----------------------------------------------------------------------------        
    -- 1. Ä³¸¯ÅÍ ½½·Ô ³Ñ¹ö°¡ validÇÑ °ÍÀÎÁö, ±×¸®°í ºó½½·ÔÀÌ ¸Â´ÂÁö ¸ÕÀú Ã¼Å©ÇÑ´Ù.        
    -----------------------------------------------------------------------------        
         
    -- start by novice.        
    SELECT @temp = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = @UserJID        
          
    IF (@temp >= 4)        
    BEGIN        
        -- ³Ê¹« ¸¹ÀÚ³ª        
        RETURN -2        
    END        
    -- finish by novice.        
      
    -----------------------------------------------------------------------------        
    -- 2. Ä³¸¯ÅÍ Ãß°¡Çϱ⠠      
    -----------------------------------------------------------------------------        
    IF (@CharScale > 68) -- 0100 0100 --> 68 ÀÌ´Ù!        
    BEGIN        
        -- Ä³¸¯ÅÍ »ý¼º ½ÇÆÐ! ½ºÄÉÀÏ °ªÀÌ ÀÌ»óÇÏ´Ù!         
        RETURN -3        
    END
        
    EXEC @temp = _IsExistingCharName @CharName        
    IF (@temp <> 0)        
    BEGIN        
        -- À̹̠»ç¿ëÁßÀΠÀ̸§À̶ó´Âµ¥?        
        RETURN -4        
    END        
    
BEGIN TRANSACTION
    
    -- Àδø½Ã½ºÅÛÀÌ Àû¿ëµÇ¸é¼* ¸¶Áö¸·¿¡ WorldID¿Í 1°ªÀ» ´õ ³Ö¾î ÁÖ¾ú´Ù!      
    INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect, LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,      
                LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber, WorldID)      
    VALUES (@RefCharID, @CharName, @CharScale, 20, 20, 27091, 853.681, 622.920532, 966.03125, 2094, 109,
                GetDate(), 1, 1, 5000000, 0,1000000, 200,200, 1, 1, 1, 1)   
    
    SET @NewCharID = @@IDENTITY        
    IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)        
    BEGIN        
        -- Ä³¸¯ÅÍ »ý¼º ½ÇÆÐ!        
        ROLLBACK TRANSACTION        
        RETURN -5        
    END        
        
           
    -- start by novice.        
    -- ÀÌÁ¦ Slot ¾È¾´´Ù.. ±×³É Insert ¸¸..        
    INSERT INTO _User VALUES (@UserJID, @NewCharID)        
    -- finish by novice.        
      
      
     -----------------------------------------------------------------------------        
     -- 3-1. Àåºñ ½½·Ô Ã¤¿ì±â        
     -- [Àκ¥Å丮 ½½·Ô 96°³] + [Àåºñ½½·Ô 13°³] <- Àκ¥Å丮 È®Àå ¼*ºñ½º ÈÄ 48°³¿¡¼* 96°³·Î Áõ°¡!!!(woos0)
     -----------------------------------------------------------------------------        
     --PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!        
     INSERT INTO _Inventory(CharID, Slot, ItemID)        
      SELECT @NewCharID, cnt, 0        
       FROM _RefDummySlot with( nolock )       
        WHERE cnt < 109        

          
    IF (@@ERROR <> 0)        
    BEGIN        
        -- Àκ¥Å丮 »ý¼º ½ÇÆÐ!        
        ROLLBACK TRANSACTION        
        RETURN -7         
    END        

    --PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!        
           
    -- µðÆúÆ®·Î ¼±ÅÃÇÑ ¾ÆÀÌÅÛÀ» ´Ù½Ã ³Ö¾îÁÖÀÚ...        
    /* ¿ä·± ¼ø¼*·Î  Á¤ÀǵǾî ÀÖ´Ù.        
    0: EQUIP_SLOT_HELM        
    1: EQUIP_SLOT_MAIL,        
    2: EQUIP_SLOT_SHOULDERGUARD,        
    3: EQUIP_SLOT_GAUNTLET,        
    4: EQUIP_SLOT_PANTS,        
    5: EQUIP_SLOT_BOOTS,        
    6: EQUIP_SLOT_WEAPON,        
    7: EQUIP_SLOT_SHIELD or ARROW,        
    8: EQUIP_SLOT_EARRING,        
    9: EQUIP_SLOT_NECKLACE,        
    10: EQUIP_SLOT_L_RING,        
    11: EQUIP_SLOT_R_RING,        
    */        
           
    DECLARE @ItemID BIGINT        
    SET @ItemID = 0        
    -- »ó°©        
    IF (@RefMailID <> 0)        
    BEGIN        
        EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 1, @RefMailID, @DurMail        
        IF (@ItemID <= 0)        
        BEGIN        
            ROLLBACK TRANSACTION        
            RETURN -8       
        END        
    END        
    -- ¹ÙÁö        
    IF (@RefPantsID <> 0)        
    BEGIN        
        EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 4, @RefPantsID, @DurPants        
        IF (@ItemID <= 0)        
        BEGIN        
            ROLLBACK TRANSACTION        
            RETURN -9        
        END        
    END        
    -- Boots        
    IF (@RefBootsID <> 0)        
    BEGIN        
        EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 5, @RefBootsID, @DurBoots        
        IF (@ItemID <= 0)        
        BEGIN        
            ROLLBACK TRANSACTION        
            RETURN -10        
        END        
    END        
    -- Weapon        
    IF (@RefWeaponID <> 0)        
    BEGIN        
        EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 6, @RefWeaponID, @DurWeapon        
        IF (@ItemID <= 0)        
        BEGIN        
            ROLLBACK TRANSACTION        
            RETURN -11        
        END        
    END        
    -- ¹æÆР       
    IF (@RefShield <> 0)        
    BEGIN        
        EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @RefShield, @DurShield        
        IF (@ItemID <= 0)        
        BEGIN        
            ROLLBACK TRANSACTION        
            RETURN -12        
        END        
    END        
    -- È¤½Ã default·Î ¼±ÅÃÇÑ ¹«±â°¡ È°À̶ó¸é È*»ì 250°³µéÀÌ È°Åëµµ ÇÔ²² ÁØ´Ù. ÁÒÄ¡?        
    IF (@DefaultArrow <> 0)        
    BEGIN        
        EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @DefaultArrow, 250        
        IF (@ItemID <= 0)        
        BEGIN        
            ROLLBACK TRANSACTION        
            RETURN -13        
        END        
    END


     -----------------------------------------------------------------------------        
     -- 3-2. ¾Æ¹ÙŸ Inventory ½½·Ô Ã¤¿ì±â        
     -- [¾Æ¹ÙŸ Àκ¥Å丮 ½½·Ô 5°³]
     -- APPLY_AVATAR_SYSTEMÀÌ Àû¿ëµÇ¸é¼* Ãß°¡µÇ´Â ºÎºÐ
     -----------------------------------------------------------------------------        
     --PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!        
          
    -----------------------------------------------------------------------------        
    -- default skill³Ö¾îÁֱ⠠      
    -----------------------------------------------------------------------------        
    DECLARE @country tinyINT        
    EXEC @country = _GetObjCountry @RefCharID        
           
    INSERT INTO _CharSkillMastery (CharID, MasteryID, Level)        
    SELECT @NewCharID, MasteryID, 0        
    FROM _RefCharDefault_SkillMastery  with(nolock)      
    WHERE Race = @country or Race = 3        
    IF (@@error <> 0)        
    BEGIN        
        ROLLBACK TRANSACTION        
        RETURN -15        
    END        
    INSERT INTO _CharSkill (CharID,SkillID,Enable)        
    SELECT @NewCharID, SkillID, 1        
    FROM  _RefCharDefault_Skill  with(nolock)      
    WHERE Race = @country or Race = 3        
    IF (@@error <> 0)        
    BEGIN        
        ROLLBACK TRANSACTION        
        RETURN -16        
    END        
    -----------------------------------------------------------------------------        
    -- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â
    -----------------------------------------------------------------------------        
    INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2)        
    SELECT @NewCharID, ID, 1, 0, getdate(), getdate(), 0, 0        
    FROM _RefQuest
    WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest  with(nolock) WHERE (Race = @country or Race = 3) and RequiredLevel = 1 and Service = 1)
    IF (@@error <> 0)
    BEGIN
        ROLLBACK TRANSACTION        
        RETURN -17        
    END    
    -----------------------------------------------------------------------------        
    -- Static Avatar Initial Record ³Ö±â        
    -----------------------------------------------------------------------------        
    INSERT INTO _StaticAvatar(CharID) values(@NewCharID)        
    IF (@@ERROR <> 0)        
    BEGIN        
        ROLLBACK TRANSACTION        
        RETURN -18        
    END         
          
    -----------------------------------------------------------------------------        
    -- Trijob Ã¤¿ö³Ö±â!!!!!        
    -----------------------------------------------------------------------------        
    INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0)        
    IF (@@ERROR <> 0)        
    BEGIN        
        -- Àκ¥Å丮 »ý¼º ½ÇÆÐ!        
        ROLLBACK TRANSACTION        
        RETURN -19        
    END         
    -------------------------
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_COS_C_PEGASUS_SCROLL',5,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',8000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',8000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_ARCHEMY_POTION_SPEED_11',10,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HWAN_POTION',3,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_M_ADMIRAL',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_M_ADMIRAL_ATTACH',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_M_ADMIRAL_HAT',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_W_ADMIRAL',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_W_ADMIRAL_ATTACH',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_W_ADMIRAL_HAT',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_REVERSE_RETURN_SCROLL',11,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_NASRUN',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_NASRUN',1,1
  -- Start Euro Full Gear ----
if @RefCharID <=14887 And @RefCharID >=14875 And @RefMailID = '11623' -- Euro Male Germant
begin
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 12175, 39     --HAT 
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 12211, 39     --SHOULDER
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 12319, 39    --HAND
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0    --Earring   
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0       --NECKLACE
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0      --RING
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0   --RING
 END
 
 if @RefCharID <=14887 And @RefCharID >=14875 And @RefMailID = '11617' -- Euro Male Armor
begin
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 11671, 45     --HAT 
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 11707, 45     --SHOULDER
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 11815, 45    --HAND
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0    --Earring   
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0       --NECKLACE
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0      --RING
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0   --RING
 END
 
  if @RefCharID <=14887 And @RefCharID >=14875 And @RefMailID = '11620' -- Euro Male protector
begin
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 11923, 39     --HAT 
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 11959, 39     --SHOULDER
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 12067, 39    --HAND
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0    --Earring   
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0       --NECKLACE
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0      --RING
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0   --RING
 END
 
 --- Female Side ! ------
 
if @RefCharID <=14900 And @RefCharID >=14888 And @RefMailID = '11632' -- Euro female Germant
begin
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 13687, 32     --HAT 
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 13723, 32     --SHOULDER
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 13831, 32    --HAND
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0    --Earring   
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0       --NECKLACE
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0      --RING
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0   --RING
 END

if @RefCharID <=14900 And @RefCharID >=14888 And @RefMailID = '11626' -- Euro female Armor
begin
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 13183, 45     --HAT 
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 13219, 45     --SHOULDER
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 13327, 45    --HAND
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0    --Earring   
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0       --NECKLACE
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0      --RING
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0   --RING
 END

 if @RefCharID <=14900 And @RefCharID >=14888 And @RefMailID = '11629' -- Euro female protector
begin
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 13435, 39     --HAT 
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 13471, 39     --SHOULDER
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 13579, 39    --HAND
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0    --Earring   
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0       --NECKLACE
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0      --RING
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0   --RING
 END

 
   -- End --
   
   -- Start China Full Gear ----
 IF @RefCharID<=1919 AND @RefCharID>=1907 and @RefMailID = '3643' -- Chinesse Male Gear CLOTHES
 BEGIN
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 791, 39     --HAT 
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 863, 39     --SHOULDER
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 971, 39    --HAND
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0    --Earring   
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0       --NECKLACE
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0      --RING
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0   --RING
 
 END
 IF @RefCharID<=1919 AND @RefCharID>=1907 and @RefMailID = '3637'  -- Chinesse Male Gear ARRMOR
 begin
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 287, 48     --HAT 
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 359, 48     --SHOULDER
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 467, 48    --HAND
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0    --Earring   
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0       --NECKLACE
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0      --RING
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0   --RING
 end
 IF @RefCharID<=1919 AND @RefCharID>=1907 and @RefMailID = '3640'  -- Chinesse Male Gear LIGHT
 begin
  EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 539, 44     --HAT 
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 611, 44     --SHOULDER
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 719, 44    --HAND
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0    --Earring   
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0       --NECKLACE
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0      --RING
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0   --RING
  END
 
 --- Female Side ! ------
     IF @RefCharID<=1932 AND @RefCharID>=1920 and @RefMailID = '3652' -- Chinesse Woman Gear CLOTHES
 BEGIN
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 1547, 39     --HAT 
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 1619, 39     --SHOULDER
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 1727, 39    --HAND
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0    --Earring   
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0       --NECKLACE
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0      --RING
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0   --RING
 END
  IF @RefCharID<=1932 AND @RefCharID>=1920 and @RefMailID = '3646'  -- Chinesse Woman Gear ARRMOR
 begin
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 1043, 48     --HAT 
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 1115, 48     --SHOULDER
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 1223, 48    --HAND
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0    --Earring   
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0       --NECKLACE
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0      --RING
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0   --RING 
 end
  IF @RefCharID<=1932 AND @RefCharID>=1920 and @RefMailID = '3649'  -- Chinesse Woman Gear LIGHT
 begin
  EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 1295, 44     --HAT 
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 1367, 44     --SHOULDER
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 1475, 44    --HAND
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0    --Earring   
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0       --NECKLACE
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0      --RING
 EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0   --RING  
  END
  ---
  insert into _InventoryForAvatar (CharID,slot,ItemID)  SELECT @NewCharID, cnt, 0
       FROM _RefDummySlot with( nolock )       
        WHERE cnt < 5
    -- Quick Slot Á¤º¸ ÀúÀå¿ë!!!        
    exec _AddNewClientConfig @NewCharID  -- by novice...... for saving client configurations...        

COMMIT TRANSACTION        
          
RETURN @NewCharID 
01/29/2015 08:49 ​Exo#19
Try using this one [Only registered and activated users can see links. Click Here To Register...]
01/29/2015 20:41 MissinGDeaTh#20
same problem :/
01/29/2015 21:32 Zodiao#21
Code:
_IsExistingCharName
Check this procedure. or post it here.
01/29/2015 21:42 MissinGDeaTh#22
Quote:
Originally Posted by Zodiao View Post
Code:
_IsExistingCharName
Check this procedure. or post it here.
PHP Code:
USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_IsExistingCharName]    Script Date: 1/29/2015 9:41:39 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO



----------------------------------------------------------------------
-- 4. Á÷¾÷ ¸í ¹× Á÷¾÷°¡¸í Áߺ¹ »ý¼º ¹æÁö ¹ö±× ÇȽº ÆÐÄ¡
----------------------------------------------------------------------

ALTER PROCEDURE [dbo].[_IsExistingCharName]   
@CharNameToCheck AS VARCHAR(64)  
 AS  
 IF (EXISTS(SELECT CharID FROM _CharNameList WITH (NOLOCK) WHERE CharName16 = @CharNameToCheck))  
 BEGIN  
  RETURN 1  
 END  

 --------------------------------------------------------------------------------------------  
 -- ¹«¿ª »ï°¢ 2Â÷ ÆÐÄ¡¸¦ À§ÇØ Nick Name¿ª½Ãµµ ÇÔ²² Áߺ¹ Ã¼Å© ´ë»ó¿¡ Æ÷ÇԵǾî¾ß ÇÑ´Ù.   
 -- 2006/5/29 overdrv  
 --------------------------------------------------------------------------------------------  
 IF (EXISTS(SELECT CharID FROM _CharNickNameList WITH (NOLOCK) WHERE NickName16 = @CharNameToCheck))  
 BEGIN  
  RETURN 1  
 END  

 RETURN 0 
here it is, and if there's a way to add start item with Full Blue and depending on char gender items ?
01/30/2015 02:45 Zodiao#23
Obviously you deleted your charname from specific table but not all.
clean up your database.
also consider to add in your check @ _Char too..not sure if it's legit.
Code:
USE [SRO_VT_SHARD] 
GO 
/****** Object:  StoredProcedure [dbo].[_IsExistingCharName]    Script Date: 1/29/2015 9:41:39 PM ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER OFF 
GO 



---------------------------------------------------------------------- 
-- 4. Á÷¾÷ ¸í ¹× Á÷¾÷°¡¸í Áߺ¹ »ý¼º ¹æÁö ¹ö±× ÇȽº ÆÐÄ¡ 
---------------------------------------------------------------------- 

ALTER PROCEDURE [dbo].[_IsExistingCharName]    
@CharNameToCheck AS VARCHAR(64)   
 AS   
 IF (EXISTS(SELECT CharID FROM _CharNameList WITH (NOLOCK) WHERE CharName16 = @CharNameToCheck))   
 BEGIN   
  RETURN 1   
 END   

 --------------------------------------------------------------------------------------------   
 -- ¹«¿ª »ï°¢ 2Â÷ ÆÐÄ¡¸¦ À§ÇØ Nick Name¿ª½Ãµµ ÇÔ²² Áߺ¹ üũ ´ë»ó¿¡ Æ÷ÇԵǾî¾ß ÇÑ´Ù.    
 -- 2006/5/29 overdrv   
 --------------------------------------------------------------------------------------------   
 IF (EXISTS(SELECT CharID FROM _CharNickNameList WITH (NOLOCK) WHERE NickName16 = @CharNameToCheck))   
 BEGIN   
  RETURN 1   
 END   
--------------------------------------------------------------------------------------------
 IF (EXISTS(SELECT CharID FROM _Char WITH (NOLOCK) WHERE CharName16 = @CharNameToCheck))   
 BEGIN   
  RETURN 1   
 END   

 RETURN 0
01/31/2015 23:25 Muhab*#24
Quote:
Originally Posted by MissinGDeaTh View Post
ye, this error only when i try to create char with such a name exists.
Then you are missing exist char names at _CharNameList.
02/01/2015 11:45 Little Messi#25
Quote:
Originally Posted by Muhab Ashraf View Post
Then you are missing exist char names at _CharNameList.
can you tell me how to fix it ?
02/01/2015 11:48 ​Exo#26
Quote:
Originally Posted by Little Messi View Post
can you tell me how to fix it ?
I don't know if that's the problem but, add all the char names @ this table.
02/01/2015 12:12 Little Messi#27
Quote:
Originally Posted by xExorcist View Post
I don't know if that's the problem but, add all the char names @ this table.
it must be automatic, i mean every sec a char is being created. i wont be able to add all char names to that table. if you know what i mean.
02/01/2015 15:31 Muhab*#28
Char names added automatically to This table but seems you have deleted them or you have removed Insert line from _AddNewChar
[Only registered and activated users can see links. Click Here To Register...]
02/01/2015 16:10 MissinGDeaTh#29
Quote:
Originally Posted by Muhab Ashraf View Post
Char names added automatically to This table but seems you have deleted them or you have removed Insert line from _AddNewChar
[Only registered and activated users can see links. Click Here To Register...]
it's here :/

[Only registered and activated users can see links. Click Here To Register...]
Page 2 of 2 1 2