Finale conclusion!! Hope this is correct If you see any errors let me know ill change it ...
when starting to work with Shop items and there menu above Statements are true some what Yes you use these 2 tables ...
StringDB <-- Titles and Sub Titles in your menu's
NewShopInfo <-- Items for your menu's
To start you first need to make Menu's and sub menu's. here is a example and these will be used for all your menu's Diamond, Ruby's and Phirius.
INSERT [dbo].[StringDB] ([KeyStr], [Content], [level], [sort]) VALUES
-- Main Catagorys --
(N'SYS_ACCOUNTSTORE_TYPE_
01', N'
Consumables', 1, 1),
(N'SYS_ACCOUNTSTORE_TYPE_02', N'Upgrading', 1, 2),
(N'SYS_ACCOUNTSTORE_TYPE_03', N'Costumes', 1, 3),
-- Sub folder Consumables
(N'SYS_ACCOUNTSTORE_TYPE_
01_
01', N'
EXP & TP', 2, 1),
(N'SYS_ACCOUNTSTORE_TYPE_01_02', N'Must-Haves', 2, 2),
(N'SYS_ACCOUNTSTORE_TYPE_01_03', N'Transformation', 2, 3),
Ok menus are done for now it looks like i have 6 menus but everything is based off the KeyStr (SYS_ACCOUNTSTORE_TYPE_01) and i do mean everything ... Look at it this way in a computer sense we are assigning
01 - Consumables and so on ect for main category...
So if 01 is consumables that makes EXP & TP part of Consumables since it has
01_01.
the first
01 is Using Consumables the next 01 is assigning
01 -
Exp & TP with this being said you see how it works for this table ...
as for adding item to the topics ... Example that works with the table above
Base on what part of the table you use for NewShopInfo if you use
[
Sell_Cost] <--- Item will sell with
Diamond's
[
Sell_Cost_Bonus] <-- Item will sell with
Ruby's
[
Sell_Cost_Free] <-- Item will sell with
Token's
INSERT INTO dbo.NewShopInfo
([World1], [
SellType], [
SellType1], [
SellType2], [
Sell_Cost_Bonus], [Sell_Get_Bonus], [Item_DisplayerObjID], [Item_OrgObjID1], [Item_Count1]) VALUES
-- Sub Folder xp tp RUBYS
(1,
1,
1,
0,
280, 0, 0, 203574, 1), /* High Quality Experience Potion */
-- Sub Folder Must-Have RUBYS
(1,
1,
2,
0,
20, 0, 0, 201136, 1), /* Convenient Mailbox */
As you can see with the color code i have made ... when assigning items you need to find the item ID either in Game or else ways... Here i have decided to use Item 203574 (High Quality Experience Potion) the number following it is a 1 Its Means I'am only selling 1 for 280 Ruby's, since i used 1 [
SellType] and 1 [
SellType1] it automatically put this item in the Consumable Category. The first 1 will always mean Consumables where [
SellType1] would be category since i added a 2 to convenient Mailbox it places it in Sub category
EXP & TP', 2, So far this has worked 100% and i know I'am just getting into it where there should be a lot more, [SellType2] for example unknown at this time but i think its the 3rd Sub category.. Here is the whole Table for NewShopInfo. As you can tell we are just using a very small part of that Table..
Code:
TABLE [dbo].[NewShopInfo] (
[GUID] int IDENTITY(1,1) NOT NULL,
[World30] bit DEFAULT ((0)) NOT NULL,
[World29] bit DEFAULT ((0)) NOT NULL,
[World28] bit DEFAULT ((0)) NOT NULL,
[World27] bit DEFAULT ((0)) NOT NULL,
[World26] bit DEFAULT ((0)) NOT NULL,
[World25] bit DEFAULT ((0)) NOT NULL,
[World24] bit DEFAULT ((0)) NOT NULL,
[World23] bit DEFAULT ((0)) NOT NULL,
[World22] bit DEFAULT ((0)) NOT NULL,
[World21] bit DEFAULT ((0)) NOT NULL,
[World20] bit DEFAULT ((0)) NOT NULL,
[World19] bit DEFAULT ((0)) NOT NULL,
[World18] bit DEFAULT ((0)) NOT NULL,
[World17] bit DEFAULT ((0)) NOT NULL,
[World16] bit DEFAULT ((0)) NOT NULL,
[World15] bit DEFAULT ((0)) NOT NULL,
[World14] bit DEFAULT ((0)) NOT NULL,
[World13] bit DEFAULT ((0)) NOT NULL,
[World12] bit DEFAULT ((0)) NOT NULL,
[World11] bit DEFAULT ((0)) NOT NULL,
[World10] bit DEFAULT ((0)) NOT NULL,
[World9] bit DEFAULT ((0)) NOT NULL,
[World8] bit DEFAULT ((0)) NOT NULL,
[World7] bit DEFAULT ((0)) NOT NULL,
[World6] bit DEFAULT ((0)) NOT NULL,
[World5] bit DEFAULT ((0)) NOT NULL,
[World4] bit DEFAULT ((0)) NOT NULL,
[World3] bit DEFAULT ((0)) NOT NULL,
[World2] bit DEFAULT ((0)) NOT NULL,
[World1] bit DEFAULT ((1)) NOT NULL,
[SortNumber] int DEFAULT ((0)) NOT NULL,
[NeedMemberID] int DEFAULT ((-1)) NOT NULL,
[SellType] int DEFAULT ((0)) NOT NULL,
[SellType1] int DEFAULT ((-1)) NOT NULL,
[SellType2] int DEFAULT ((-1)) NOT NULL,
[Sell_BeginTime] smalldatetime DEFAULT ('1991-01-01') NOT NULL,
[Sell_EndTime] smalldatetime DEFAULT ('2031-01-01') NOT NULL,
[Sell_Count] int DEFAULT ((0)) NOT NULL,
[Sell_MaxCount] int DEFAULT ((0)) NOT NULL,
[Sell_Cost] int DEFAULT ((0)) NOT NULL,
[Sell_Cost_Bonus] int DEFAULT ((0)) NOT NULL,
[Sell_Cost_Free] int DEFAULT ((0)) NOT NULL,
[Sell_Get_Bonus] int DEFAULT ((0)) NOT NULL,
[Icon] int DEFAULT ((0)) NOT NULL,
[Item_DisplayerObjID] int DEFAULT ((0)) NOT NULL,
[Item_Name] nvarchar(32) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
[Item_Note] nvarchar(256) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
[Item_OrgObjID1] int DEFAULT ((0)) NOT NULL,
[Item_OrgObjID2] int DEFAULT ((0)) NOT NULL,
[Item_OrgObjID3] int DEFAULT ((0)) NOT NULL,
[Item_OrgObjID4] int DEFAULT ((0)) NOT NULL,
[Item_OrgObjID5] int DEFAULT ((0)) NOT NULL,
[Item_OrgObjID6] int DEFAULT ((0)) NOT NULL,
[Item_OrgObjID7] int DEFAULT ((0)) NOT NULL,
[Item_OrgObjID8] int DEFAULT ((0)) NOT NULL,
[Item_Count1] int DEFAULT ((0)) NOT NULL,
[Item_Count2] int DEFAULT ((0)) NOT NULL,
[Item_Count3] int DEFAULT ((0)) NOT NULL,
[Item_Count4] int DEFAULT ((0)) NOT NULL,
[Item_Count5] int DEFAULT ((0)) NOT NULL,
[Item_Count6] int DEFAULT ((0)) NOT NULL,
[Item_Count7] int DEFAULT ((0)) NOT NULL,
[Item_Count8] int DEFAULT ((0)) NOT NULL,
[Gamble_Count] smallint DEFAULT ((0)) NOT NULL,
[Gamble_Rate1] smallint DEFAULT ((0)) NOT NULL,
[Gamble_Rate2] smallint DEFAULT ((0)) NOT NULL,
[Gamble_Rate3] smallint DEFAULT ((0)) NOT NULL,
[Gamble_Rate4] smallint DEFAULT ((0)) NOT NULL,
[Gamble_Rate5] smallint DEFAULT ((0)) NOT NULL,
[Gamble_Rate6] smallint DEFAULT ((0)) NOT NULL,
[Gamble_Rate7] smallint DEFAULT ((0)) NOT NULL,
[Gamble_Rate8] smallint DEFAULT ((0)) NOT NULL,
[EffectDay] int DEFAULT ((-1)) NOT NULL
Ill make corrections when i find things that may be different then what i wrote , Or if you see anything i have incorrect I will check it out first then change it here and give you credit ,... thanks all for your help.
andelwol26,
Drewww,
Mageoski.
Jane