Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 14:48

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

Advertisement



need query add item in char

Discussion on need query add item in char within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: May 2012
Posts: 3
Received Thanks: 0
need query add item in char

hi all

im need query for add item in char by code item and char name
™AmeerKing™ is offline  
Old 09/16/2012, 18:33   #2
 
A new hope's Avatar
 
elite*gold: 0
Join Date: Sep 2012
Posts: 753
Received Thanks: 711
use the _ADD_ITEM_EXTERN SP
A new hope is offline  
Old 09/16/2012, 21:28   #3
 
IceAmStiel's Avatar
 
elite*gold: 0
Join Date: Jul 2011
Posts: 1,058
Received Thanks: 1,118
Depending on the location where you'd like to put the item to you could also use _SMC_ADD_ITEM, it has more options than _ADD_ITEM_EXTERN - but probably harder for you to use
IceAmStiel is offline  
Old 09/16/2012, 23:57   #4
 
elite*gold: 0
Join Date: Nov 2011
Posts: 303
Received Thanks: 44
declare @CharName varchar(64)

set @CharName = 'Serend'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_W_NASRUN_UNIQUE',1,250
Serenduk is offline  
Thanks
2 Users
Reply


Similar Threads Similar Threads
Add Item to NPC Query
12/16/2016 - SRO Guides & Templates - 13 Replies
if someone needs it, use it - will faster many things up :) and you'll get punished for sloppy done work in the past. USE SRO_VT_SHARD /* ITEMS TO NPC FOR GOLD by Caipi */ Declare @ItemID int Declare @yourPrice int Declare @WhichTAB varchar(74) SET @ItemID = 23 /* The Item ID of the Item you want to add to the NPC*/ --## <--
INSERT INTO Item Query?
01/07/2012 - Flyff Private Server - 4 Replies
Gibts ne query um items direkt per query ins inventory / als mail zu senden? Insanityflyff hat dieses ja zB,wenn man ein item auf der homepage auswählt,wirds sofort ins inventory gepackt.. kennt wer den oder einen ähnlichen query :/?
Query für bestimmtes Item löschen
10/10/2011 - Metin2 Private Server - 2 Replies
Wie kann ich alle Items in der Itemtable mit z.b Value 70007 löschen danke im Voraus.
Insert item query
07/31/2011 - Rappelz - 7 Replies
HI all, My commands game001 didnt working, what is the way to inser this : USE GO DECLARE @return_value int EXEC @return_value = .



All times are GMT +1. The time now is 14:49.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

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