[Release] Crate system similar to CS:GO

well everything shows in the market tab now and i can buy the cases BUT after i buy the case ill check global and normal char invintory and NOTHING and it takes the gc/gd checked all logs no errors nothing. cuz this be due to having to alter the items for items_generic cuz i didnt have the last 3 columns for the table so i removed the stuff. at first i tried adding the columns but it was giving an error for no stored proc for itemFlag thus just removed last 3 columns.

edit nvm got it all sorted now

why we just make an item that open random item, so user can trade the box or use it like this:

https://www.youtube.com/watch?v=LpSxXCwMNfQ

Hello Guys,
I've done every procedure but i can't see the Cases in the market yet...
What could have I done wrong?
https://forum.ragezone.com/cache.php...338932d728.jpg

Quote:

---

Originally Posted by LukeFire

Hello Guys,
I've done every procedure but i can't see the Cases in the market yet...
What could have I done wrong?
https://forum.ragezone.com/cache.php...338932d728.jpg

---

you may forgot to place the cases in the itemDB

GG easy!!!


6 hours later...

http://i1054.photobucket.com/albums/...psexhsf43d.png

When I open the box I take disconect the server.
It shows nothing in r3dlog.
Can someone help me ?
As I make my ItensDB?
EX:

<LootBox itemID="301144" category="7" Weight="0">
<Model file="Data/ObjectsDepot/Weapons/item_lootcrate_01.sco" />
<Store name="Melee Case" icon="$Data/Weapons/StoreIcons/Item_LootCrate_01.dds" desc="Only Backpack spawns" LevelRequired="0" />
</LootBox>

Help-me.

all it done but when buy case item was random and add to inventory 30pcs !?!? how to fix it ???

Quote:

---

Originally Posted by LukasCCB

worth remind everyone to use this system.
is mandatory change ItemsID, by reason of that comes by default many emulators do not have the same ItemID.

---

Im added this system. But not showing. Im not add ItemDB. Because I don't know add . Please help me :)

http://image.prntscr.com/image/7f2fc...40e1450d95.png

Fixed sql query without syntax "else", ")" errors

Spoiler:

USE [warz]
GO
/****** Object: Table [dbo].[Items_CaseData] Script Date: 07/06/2015 20:33:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Items_CaseData](
[RecordID] [int] IDENTITY(1,1) NOT NULL,
[LootID] [int] NOT NULL,
[Chance] [float] NULL,
[ItemID] [int] NULL
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Items_CaseData] ON
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (4, 301145, 10, 201212)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (5, 301142, 35, 101068)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (6, 301145, 5, 101023)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (7, 301145, 20, 201107)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (11, 301138, 50, 101035)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (12, 301138, 50, 101037)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (13, 301138, 50, 101040)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (14, 301138, 50, 101045)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (15, 301138, 50, 101055)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (16, 301141, 49, 101158)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (17, 301143, 2, 101202)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (18, 301143, 20, 101198)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (19, 301143, 25, 101194)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (21, 301140, 5, 201085)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (22, 301138, 50, 101081)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (23, 301139, 50, 101084)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (24, 301139, 50, 101085)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (25, 301139, 50, 101087)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (26, 301139, 50, 101088)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (27, 301141, 39, 101004)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (28, 301141, 15, 101381)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (29, 301141, 30, 101032)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (30, 301140, 25, 277969)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (36, 301142, 1, 101088)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (37, 301142, 2, 101087)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (38, 301142, 25, 101247)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (39, 301142, 3, 101084)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (41, 301140, 50, 201087)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (42, 301140, 45, 191111)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (43, 301138, 48, 101172)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (47, 301138, 50, 101191)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (48, 301138, 50, 101193)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (50, 301141, 35, 101022)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (52, 301143, 20, 800020)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (54, 301138, 50, 101210)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (66, 301138, 50, 101246)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (67, 301139, 50, 101247)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (71, 301144, 5, 101268)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (72, 301147, 50, 101268)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (73, 301147, 50, 101269)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (74, 301147, 50, 101270)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (75, 301147, 50, 101271)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (76, 301147, 50, 101272)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (77, 301147, 50, 101273)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (78, 301147, 50, 101274)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (79, 301147, 50, 101275)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (80, 301147, 50, 101276)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (81, 301144, 25, 800027)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (82, 301144, 10, 102000)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (105, 301144, 15, 800024)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (106, 301144, 20, 800025)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (107, 301144, 22, 101381)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (132, 301138, 50, 101341)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (181, 301165, 50, 108002)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (182, 301165, 50, 108003)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (184, 301165, 50, 108006)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (185, 301165, 50, 108007)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (187, 301138, 50, 108012)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (188, 301165, 50, 108013)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (189, 301141, 50, 101040)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (190, 301143, 65, 800021)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (191, 301143, 60, 800022)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (192, 301150, 50, 108018)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (193, 301150, 50, 108019)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (194, 301150, 50, 108020)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (198, 301138, 50, 180018)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (200, 301143, 45, 800023)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (202, 301139, 50, 180023)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (203, 301139, 50, 180024)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (204, 301141, 45, 101200)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (205, 301143, 1, 800024)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (206, 301138, 50, 180276)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (207, 301138, 50, 180286)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (209, 301138, 50, 180289)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (211, 301139, 50, 181391)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (212, 301138, 50, 181392)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (213, 301138, 50, 181393)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (214, 301138, 50, 181394)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (215, 301143, 1, 800025)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (216, 301141, 25, 101055)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (217, 301138, 50, 181397)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (219, 301138, 50, 181401)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (220, 301138, 50, 181402)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (221, 301138, 50, 181403)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (222, 301138, 50, 182000)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (223, 301141, 2, 101088)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (224, 301141, 35, 101002)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (227, 301138, 50, 182019)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (231, 301143, 45, 101199)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (232, 301140, 45, 101196)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (233, 301141, 40, 101115)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (234, 301141, 40, 101111)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (237, 301139, 50, 182034)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (238, 301139, 50, 182035)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (239, 301150, 50, 182037)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (240, 301150, 50, 182038)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (241, 301150, 50, 182039)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (243, 301150, 50, 182041)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (244, 301150, 50, 182042)
INSERT [dbo].[Items_CaseData] ([RecordID], [LootID], [Chance], [ItemID]) VALUES (247, 301140, 15, 101195)
GO
print 'Processed 100 total records'
SET IDENTITY_INSERT [dbo].[Items_CaseData] OFF
/****** Object: StoredProcedure [dbo].[WZ_LootGetData] Script Date: 07/06/2015 20:33:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[WZ_LootGetData]
@in_LootID int
AS
BEGIN
SET NOCOUNT ON;




-- success
select 0 as ResultCode




-- report item category (loot box or mystery box)
declare @CaTegory int = 0
select @CaTegory=Category from Items_Generic where ItemID=@in_LootID
select @CaTegory as 'Category'




-- report content
select * from Items_CaseData where LootID=@in_LootID order by Chance asc
END
GO
/****** Object: StoredProcedure [dbo].[FN_AddItemToUserCase] Script Date: 07/06/2015 20:33:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[FN_AddItemToUserCase]
@in_CustomerID int,
@in_ItemID int,
@in_ExpDays int
AS
BEGIN
SET NOCOUNT ON;

select 0 as ResultCode
select @in_ItemID as ItemID


declare @inventoryID bigint = 0
declare @LeasedUntil datetime
declare @CurDate datetime = GETDATE()

-- check if this is stackable item, if so - get buying stack size.
-- stackable item defined where NumClips>0, Quantity is ClipSize
declare @BuyStackSize int = 1
select @BuyStackSize=ClipSize from Items_Weapons where ItemID=@in_ItemID and NumClips>0

-- see if we already have that item in inventory without modification vars
select @inventoryID=InventoryID, @LeasedUntil=LeasedUntil from UsersInventory
where (CustomerID=@in_CustomerID and CharID=0 and ItemID=@in_ItemID and Var1<0 and Var2<0)
if @inventoryID = 0)
begin
INSERT INTO UsersInventory (
CustomerID,
CharID,
ItemID,
LeasedUntil,
Quantity
)
VALUES (
@in_CustomerID,
0,
@in_ItemID,
DATEADD(day, @in_ExpDays, @CurDate),
@BuyStackSize
)
return
end

if @LeasedUntil < @CurDate)
set @LeasedUntil = DATEADD(day, @in_ExpDays, @CurDate)
else
set @LeasedUntil = DATEADD(day, @in_ExpDays, @LeasedUntil)

if @LeasedUntil > '2020-1-1')
set @LeasedUntil = '2020-1-1'

-- all items is stackable by default
UPDATE UsersInventory SET
LeasedUntil= @LeasedUntil,
Quantity=(Quantity+@BuyStackSize)
WHERE InventoryID = @inventoryID

return
END
GO