Register for your free account! | Forgot your password?

Go Back   elitepvpers › Popular Games › Silkroad Online › SRO Private Server
[Error] creating char error [Error] creating char error
You last visited: Today at 12:04

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

[Error] creating char error

Discussion on [Error] creating char error within the SRO Private Server forum part of the Silkroad Online category.

Reply
Page 2 of 2 1 2
 
Old   #16
 
Zodiao's Avatar
 
elite*gold: 0
The Black Market: 6/0/0
Join Date: Aug 2012
Posts: 748
Received Thanks: 227
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.
Zodiao is offline  
Old   #17


 
​Exo's Avatar
 
elite*gold: 28
The Black Market: 33/0/0
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,654
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.
​Exo is offline  
Old   #18
 
elite*gold: 15
The Black Market: 0/0/0
Join Date: Jul 2014
Posts: 146
Received Thanks: 6
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 
MissinGDeaTh is offline  
Old   #19


 
​Exo's Avatar
 
elite*gold: 28
The Black Market: 33/0/0
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,654
Try using this one
​Exo is offline  
Old   #20
 
elite*gold: 15
The Black Market: 0/0/0
Join Date: Jul 2014
Posts: 146
Received Thanks: 6
same problem :/
MissinGDeaTh is offline  
Old   #21
 
Zodiao's Avatar
 
elite*gold: 0
The Black Market: 6/0/0
Join Date: Aug 2012
Posts: 748
Received Thanks: 227
Code:
_IsExistingCharName
Check this procedure. or post it here.
Zodiao is offline  
Old   #22
 
elite*gold: 15
The Black Market: 0/0/0
Join Date: Jul 2014
Posts: 146
Received Thanks: 6
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 ?
MissinGDeaTh is offline  
Old   #23
 
Zodiao's Avatar
 
elite*gold: 0
The Black Market: 6/0/0
Join Date: Aug 2012
Posts: 748
Received Thanks: 227
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
Zodiao is offline  
Old   #24
 
Muhab*'s Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2014
Posts: 885
Received Thanks: 1,420
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.
Muhab* is offline  
Old   #25
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 177
Received Thanks: 11
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 ?
Little Messi is offline  
Old   #26


 
​Exo's Avatar
 
elite*gold: 28
The Black Market: 33/0/0
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,654
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.
​Exo is offline  
Old   #27
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 177
Received Thanks: 11
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.
Little Messi is offline  
Old   #28
 
Muhab*'s Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2014
Posts: 885
Received Thanks: 1,420
Char names added automatically to This table but seems you have deleted them or you have removed Insert line from _AddNewChar
Muhab* is offline  
Old   #29
 
elite*gold: 15
The Black Market: 0/0/0
Join Date: Jul 2014
Posts: 146
Received Thanks: 6
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
it's here :/
MissinGDeaTh is offline  
Reply
Page 2 of 2 1 2

« Data Sources (ODBC) Error ! | VSRO .258 NEED HELP! »

Similar Threads Similar Threads
SHardManager - ODBC error while creating a new char
12/20/2016 - SRO Private Server - 10 Replies
Hello ! I ve downloaded the Blue-Sro DB cuz it has a lot of good edits. I can make my char ,play etc... But when i make a new acc and try to make a new char i get an error in-game and at shardmaneger too. I tired it with 3-4 accs , sometimes it works but sometimes not and crash the shared manager. I ve used db clearing queries , but still not working. Please help me ! Thanks !
help me fix this error when creating patch!!!
02/09/2014 - Flyff Private Server - 9 Replies
Help me fix this error please . Img»Simple File Sharing and Storage. Img»https://fbcdn-sphotos-b-a.akamaihd.net/hphoto s-ak-prn1/t1/15126_348198991985962_579784067_n.jpg
SMP error while creating account
11/01/2012 - Rappelz Private Server - 0 Replies
SMP problem solved on my own *lol* 2nd LUA problem solved on my own, too XD
error while creating a new char
03/24/2012 - SRO Private Server - 2 Replies
http://www10.0zz0.com/2012/03/23/22/244814214.jpg
error creating guild
03/22/2012 - Dekaron Private Server - 3 Replies
every time I try to create guild'' says FAILED TO CREATE GUILD 'already restored the DB is more in the same things I've been editing each type before deleting manually give each guild did this annoying problem for my DB and Character.bak aloken I hope you can help me ...



All times are GMT +2. The time now is 12:04.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.