Making a Gasha

[Drewww]

Someone asked about this a while ago.

So this Gasha holds 8 Tier Stones, T5 to T12, has a sell limit of 999, with a start and end time and various luck values, 1-10000, where 10000 = 100%

Ive used a lot of spaces so it lines up and you should be able to see which value goes where.

USE [ROM_ImportDB]
GO
INSERT [dbo].[NewShopInfo]
([World1], [SortNumber], [SellType], [SellType1], [SellType2], [Sell_BeginTime],                              [Sell_EndTime],                               [Sell_MaxCount], [Sell_Cost], [Sell_Cost_Bonus], [Sell_Cost_Free], [Sell_Get_Bonus], [Item_DisplayerObjID], [Item_Name],   [Item_OrgObjID1], [Item_OrgObjID2], [Item_OrgObjID3], [Item_OrgObjID4], [Item_OrgObjID5], [Item_OrgObjID6], [Item_OrgObjID7], [Item_OrgObjID8], [Item_Count1], [Item_Count2], [Item_Count3], [Item_Count4], [Item_Count5], [Item_Count6], [Item_Count7], [Item_Count8], [Gamble_Count], [Gamble_Rate1], [Gamble_Rate2], [Gamble_Rate3], [Gamble_Rate4], [Gamble_Rate5], [Gamble_Rate6], [Gamble_Rate7], [Gamble_Rate8], [EffectDay]) VALUES
(1,        0,            1,          1,           0,           CAST(N'2016-02-01 00:00:00' AS SmallDateTime), CAST(N'2017-01-01 00:00:00' AS SmallDateTime),999,             5,           0,                 0,                1,                206103,                N'Happy poop', 202844,           202845,           202846,           202847,           202848,           202849,           202850,           202851,           1,             1,             1,             1,             1,             1,             1,             1,             8,              3000,           2000,           1000,           500,            400,            300,            200,            100,            -1);
GO

When you paste in Notpad++ the format should look better then what you see here

 

[CDWriter]

Thank Drewww ill test it ......

REMOVED

Very nice