Error in Start Items

03/27/2012 20:01 �_Vindictive_�#1

i using ecsro filles
and i had error after execute
the code

Quote:

exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',20, 1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_SKILL_GOLD_TIME_SERVICE_TICKE T_4W',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_DAMAGE_ABS_20P_SCROLL',11,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_DAMAGE_INC_20P_SCROLL',11,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',11,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_HP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_MP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_COS_P_FLUTE_WHITE',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_COS_P_MYOWON_SCROLL',1,1

screen of gameserver
[Only registered and activated users can see links. Click Here To Register...]

03/27/2012 20:05 �ᵔBeGodOfWarᵔ�#2

Add them into your db { start items } + make sure that you have increased your inventory space

Quote:

ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',20, 1
ITEM_MALL_SKILL_GOLD_TIME_SERVICE_TICKE T_4W',1,1
ITEM_MALL_DAMAGE_ABS_20P_SCROLL',11,1
ITEM_MALL_DAMAGE_INC_20P_SCROLL',11,1
ITEM_MALL_REVERSE_RETURN_SCROLL',11,1
ITEM_MALL_HP_SUPERSET_5_BAG',1000,1
ITEM_MALL_MP_SUPERSET_5_BAG',1000,1
ITEM_COS_P_FLUTE_WHITE',1,1
ITEM_COS_P_MYOWON_SCROLL',1,1

03/27/2012 20:08 �_Vindictive_�#3

Quote:

Originally Posted by �ᵔBeGodOfWarᵔ�

Add them into your db

O_o they are in db brah
SR_CHINA_CS >> Programmability >> add New Char >> Modify >>

Quote:

INSERT _CharNameList VALUES(@CharName, @NewCharID)
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',20, 1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_SKILL_GOLD_TIME_SERVICE_TICKE T_4W',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_DAMAGE_ABS_20P_SCROLL',11,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_DAMAGE_INC_20P_SCROLL',11,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',11,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_HP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_MP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_COS_P_FLUTE_WHITE',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_COS_P_MYOWON_SCROLL',1,1
COMMIT TRANSACTION

RETURN @NewCharID

should i put them in another area ?
i puted them in db only
in dbo.addnewchar

03/27/2012 21:33 H34D_B4NG3R#4

You were getting this error before adding these lines?
Idk where is the problem but you can try my items to see if are working for you;

Code:

    INSERT _CharNameList VALUES(@CharName, @NewCharID)       
         
exec_ADD_ITEM_EXTERN@CharName,'ITEM_EVENT_PREMIUM_VIETNAM_GOLDTIME_PLUS',1,1   
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_SKILL_GOLD_TIME_SERVICE_TICKET_4W',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_INVENTORY_ADDITION',1,1 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_HP_SUPERSET_5_BAG',1000,1 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_MP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',20,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',50,1 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_GLOBAL_CHATTING',11,1   
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_INVENTORY_ADDITION',1,1   
exec _ADD_ITEM_EXTERN @CharName,'ITEM_COS_P_MYOWON_SCROLL',1,1 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_COS_P_FLUTE_WHITE_SMALL',1,1 

   UPDATE [dbo].[_Char] set HwanLevel='4' where CharName16=@CharName   
         
    -- Quick Slot ���� �����!!!       
    exec _AddNewClientConfig @NewCharID 

COMMIT TRANSACTION

If mines are working it means that you made a mistake (but i didn't see one),you can find the mistake adding the items you want one by one

03/27/2012 22:11 �_Vindictive_�#5

i'll try

Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table '_AddNewClientConfig'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.

03/28/2012 00:27 H34D_B4NG3R#6

Code:

 exec _AddNewClientConfig @NewCharID

You were missing '_AddNewClientConfig' so it was created.

Enter in SRO_VT_SHARD_INIT -> _Char and delete the char with CharID 66.

You can run now the server without any problem :)