|
You last visited: Today at 01:13
Advertisement
[Query Help] Adding item to inventory
Discussion on [Query Help] Adding item to inventory within the SRO Private Server forum part of the Silkroad Online category.
04/15/2013, 17:24
|
#1
|
elite*gold: 45 
Join Date: Nov 2010
Posts: 411
Received Thanks: 112
|
[Query Help] Adding item to inventory
Hello, a simple question , how would a query be if i want to add a specific item to a player's inventory(not a new player) .. thanks in advanced
|
|
|
|
04/15/2013, 19:58
|
#2
|
elite*gold: 0
Join Date: Jan 2012
Posts: 66
Received Thanks: 13
|
Use _SMC_ADD_ITEM procedure.
|
|
|
|
|
04/15/2013, 20:14
|
#3
|
elite*gold: 45
Join Date: Nov 2010
Posts: 411
Received Thanks: 112
|
... a query. like insert into , but what table?
|
|
|
|
|
04/15/2013, 20:26
|
#4
|
elite*gold: 0
Join Date: Dec 2007
Posts: 3,210
Received Thanks: 6,289
|
Quote:
Originally Posted by ahmadbilto
... a query. like insert into , but what table?
|
|
|
|
|
|
04/15/2013, 20:32
|
#5
|
elite*gold: 45
Join Date: Nov 2010
Posts: 411
Received Thanks: 112
|
well .. sorry for being noobish , but would be great if u answered,,
|
|
|
|
|
04/15/2013, 20:33
|
#6
|
elite*gold: 0
Join Date: Feb 2009
Posts: 1,064
Received Thanks: 539
|
Quote:
Originally Posted by ^AquaFresh^
Use _SMC_ADD_ITEM procedure.
|
Quote:
Originally Posted by ahmadbilto
well .. sorry for being noobish , but would be great if u answered,,
|
...
|
|
|
|
|
04/15/2013, 22:36
|
#7
|
elite*gold: 0
Join Date: Sep 2012
Posts: 753
Received Thanks: 711
|
exec _add_item_extern charname, itemcodename, optlevel, data
|
|
|
|
|
04/15/2013, 22:50
|
#8
|
Chat Killer In Duty
elite*gold: 5
Join Date: May 2008
Posts: 16,309
Received Thanks: 6,470
|
Quote:
Originally Posted by ahmadbilto
... a query. like insert into , but what table?
|
the query is already on the database
open the stored procedures and you will find it here
|
|
|
|
 |
Similar Threads
|
[Release]Query fast adding item to npc.
05/21/2016 - SRO PServer Guides & Releases - 12 Replies
Today I'd like to share a query with you. This query will quickly add an item to an NPC - test it and rate it.
USE
----------By Nefetis--------------
DECLARE @PRICETYPE VARCHAR (70)
DECLARE @PRICE VARCHAR (70)
DECLARE @TAB VARCHAR (70)
DECLARE @CODENAME128 VARCHAR (70)
DECLARE @OPTLEVEL VARCHAR (70)
|
Query for adding silk for new accounts
04/27/2012 - SRO PServer Guides & Releases - 1 Replies
Hi Guy's :mofo:
$ jidque = @ mssql_fetch_array (@ mssql_query ("SELECT * FROM WHERE dbo.TB_User StrUserID = '$ user'"));
jidque realjid = $ $ ;
$ silkver = mssql_query ("INSERT INTO SK_Silk (JID, Silk_own) values ('$ realjid', '1000000 ')");
yourself who is the name of the variable $ user to record, edit account id. '1000000 'Is the amount of silk box unchecked in the record section of your website, add and change.
|
Requesting a query for adding new columns in db
01/28/2012 - SRO Private Server - 3 Replies
Hi i'm requesting a query to add more columns into a table, i need 3 more columns at shardservice since cleaned the db it only appears one column atm.
So if anyone got one feel free to post it.
Thanks in advance!
|
Issue on adding pet in the inventory
08/16/2011 - Rappelz - 6 Replies
Ok i Tried almost everything, btw I created a pg named Avenger and tried to put a wd in the inventory whit this line
#insert_item(540037, 1, 1, 1, -2147483648, "Avenger")
I'm writing this into the captainharlok server file but when i check the inventory nothing happens
Should I close the game before doing this ?
edit : my player is 300lv and in the trainee island if this could help
|
Adding Pets Query
05/03/2010 - EO PServer Hosting - 0 Replies
Ok So I Know This Is Me Being Lazy In A Way And Maybe Asking A Bit Much But What I Got To Lose Lol?
Can Some 1 Make A Guide Of Just The Db Query And Actions And With What Needs To Be Put In And Changed EveryTime You Wanna Add A Pet?
Cq_Action Is Whats Really Gettin Me COnfused I have Tried
|
All times are GMT +2. The time now is 01:13.
|
|
![[Query Help] Adding item to inventory](https://www.elitepvpers.com/forum/iconimages/sro-private-server/query-help-adding-item-inventory_ltr.gif){kind=small}
