|
You last visited: Today at 16:07
Advertisement
add item to char problem
Discussion on add item to char problem within the SRO Private Server forum part of the Silkroad Online category.
01/02/2019, 19:59
|
#1
|
elite*gold: 0
Join Date: Dec 2018
Posts: 2
Received Thanks: 0
|
add item to char problem
i have problem for add item to char
This message appears
Msg 8114, Level 16, State 5, Procedure _ADD_ITEM_EXTERN, Line 0
Error converting data type varchar to int.

|
|
|
01/02/2019, 22:08
|
#2
|
elite*gold: 100
Join Date: Sep 2017
Posts: 1,110
Received Thanks: 907
|
You're implementing the procedure wrongly.
|
|
|
01/03/2019, 01:32
|
#3
|
elite*gold: 0
Join Date: Dec 2018
Posts: 139
Received Thanks: 29
|
USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @  varchar(64)
set @  = 'YourCharName'
exec _ADD_ITEM_EXTERN @  ,'ITEM_EU_TSTAFF_11_SET_B_RARE',1,1
|
|
|
01/03/2019, 02:53
|
#4
|
elite*gold: 100
Join Date: Sep 2017
Posts: 1,110
Received Thanks: 907
|
Then it might be your procedure code.
|
|
|
01/03/2019, 10:44
|
#5
|
elite*gold: 0
Join Date: Dec 2018
Posts: 2
Received Thanks: 0
|
same problem
|
|
|
01/03/2019, 15:23
|
#6
|
elite*gold: 23
Join Date: Feb 2011
Posts: 644
Received Thanks: 481
|
Quote:
USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)
set @CharName = 'YourCharName'
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_B_RARE',1,100
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_SET_B_RARE',1,100
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_SET_B_RARE',1,100
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_SET_B_RARE',1,100
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,100
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,100
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_HA_SET_B_RARE',1,1 00
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_SA_SET_B_RARE',1,1 00
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_LA_SET_B_RARE',1,1 00
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_FA_SET_B_RARE',1,1 00
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_AA_SET_B_RARE',1,1 00
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_BA_SET_B_RARE',1,1 00
|
|
|
|
01/03/2019, 20:50
|
#7
|
elite*gold: 100
Join Date: Sep 2017
Posts: 1,110
Received Thanks: 907
|
Check _ADD_ITEM_EXTERN arguments date types.
|
|
|
Similar Threads
|
[Question] about disable NPCs / add lucky powder 100% / add item to remove adv plus
02/27/2013 - SRO Private Server - 0 Replies
Hello guys i have searched too much but i didn't found any answer for my question
1. i have disabled NPCs from _refShop @ DB and media.pk
but the client don't open
2. how i can add lucky powder 100%
3. how to add item to remove adv plus
|
How do I add item item Mall
10/06/2011 - SRO Private Server - 3 Replies
Vsro
How do I add the Item mall new item?
|
looking for coder to add soul item npc and dmg- add npc
07/09/2011 - CO2 Private Server - 0 Replies
hey im looking for a coder that could add a npc which sells full dragon soul sets +12 -7 255 hp 2 soc for specific classes e.g. for a tro you would buy a soul set which has weapons armor coro necky boots armor and so on also i need a npc where you can buy dmg - to your equips for tortoise gems
|
All times are GMT +1. The time now is 16:08.
|
|