Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server > Shaiya PServer Guides & Releases
You last visited: Today at 07:54

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


give players items in gift box (item mall)

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Nov 2012
Posts: 317
Received Thanks: 144
give players items in gift box (item mall)

at tiems you nedd to add items to the players ingame right?


Quote:
USE [PS_GameData]
GO

declare @UserUID as int
declare @Slot as tinyint
declare @ItemID as int
declare @ItemCount as tinyint

set @UserUID = 4 /* Insert UserUID here */
set @ItemID = 100215 /* Insert ItemID here */
set @ItemCount = 1 /* Insert No of Items here */



set @Slot = case when (select max(Slot)+1 from PS_GameData.dbo.UserStoredPointItems with (nolock) where UserUID = @UserUID) is null then 0 else (select max(Slot)+1 from PS_GameData.dbo.UserStoredPointItems with (nolock) where UserUID = @UserUID) end


INSERT INTO [dbo].[UserStoredPointItems]
([UserUID]
,[Slot]
,[ItemID]
,[ItemCount]
,[BuyDate])
VALUES
(@UserUID
,@Slot
,@ItemID
,@ItemCount
,getdate())


/* Shows what the account have */
select * from PS_GameData.dbo.UserStoredPointItems with (nolock) where UserUID = @UserUID

GO
this will give the selected account what you want to give them in gift shop in item mall.


done anything wrong?

Quote:
UPDATE PS_GameData.dbo.UserStoredPointItems
SET ItemID = 'new itemuid'
WHERE UserUID = 'useruid the number'
and ItemID = 'old item uid'
this will fix it right up :-)

hope you like it..



GMCronus is offline  
Thanks
7 Users
Old 11/24/2014, 07:17   #2
 
elite*gold: 0
Join Date: Jun 2013
Posts: 12
Received Thanks: 1
How do I add items in all new creation character?

Thanks


MaskARRA is offline  
Thanks
1 User
Old 11/24/2014, 09:09   #3
 
elite*gold: 0
Join Date: Nov 2012
Posts: 317
Received Thanks: 144
all created characters is under here in sql

if you right click that BaseItemnDefs you can add what charachter should start with when you create them as i think this is what your after.

to change this you have to lookup family and job and what they mean.

when you know that you can just add items to the diffrent ones and any time you create a character you will get this in them
GMCronus is offline  
Thanks
1 User
Old 11/25/2014, 02:10   #4
 
elite*gold: 0
Join Date: Jun 2013
Posts: 12
Received Thanks: 1
Quote:
Originally Posted by GMCronus View Post
all created characters is under here in sql

if you right click that BaseItemnDefs you can add what charachter should start with when you create them as i think this is what your after.

to change this you have to lookup family and job and what they mean.

when you know that you can just add items to the diffrent ones and any time you create a character you will get this in them
Copy mate, and it works thanks


MaskARRA is offline  
Old 05/26/2015, 09:01   #5
 
elite*gold: 0
Join Date: Jun 2012
Posts: 10
Received Thanks: 0
How do I add a present to all accounts in game ?
askaterboys is offline  
Old 05/26/2015, 11:11   #6
 
elite*gold: 0
Join Date: Sep 2011
Posts: 386
Received Thanks: 361
You can use this tool from nubness [Release] Admin Panel


momocruz is offline  
Reply



« [Release] Critical Attack 100% Ep 4.5 | Perfect Enchant Lapisia Game Service »

Similar Threads
Specific items no ITEM MALL
12/09/2013 - SRO PServer Ask the Experts - 1 Replies
now insert the item in the db and I can access it by GM CONSOLE. How do I enter in the item mall? ITEM_MALL_PET_WATCH .......
Help.... how to remove items from item mall
09/25/2012 - SRO PServer Ask the Experts - 0 Replies
i wanna to know how to remove items from item mall and will be great if told me how to put it in npc ... Thxx
i cant buy some items in Item Mall
09/16/2012 - SRO PServer Ask the Experts - 1 Replies
Hi, i cant buy some items in Item mall. May files : RefPackageItem : ...
item mall enable items
03/28/2012 - SRO PServer Ask the Experts - 5 Replies
alot of items in my item mall are disabled if anyone tries to buy they get dc can someone tell me which databases i need to edit as _RefShopGoods if i set the disabled items to 1 gameserver crashes after getting cert from shard



All times are GMT +2. The time now is 07:54.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.