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ᵔ• View Post
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 :)