Database:Items - Revision history

Cynnar at 23:24, 31 January 2017

2017-01-31T23:24:19Z

2017-01-31T23:18:20Z

2017-01-31T23:13:12Z

2017-01-31T22:48:19Z

2017-01-31T22:34:10Z

2017-01-31T21:44:37Z

2017-01-31T21:44:05Z

2017-01-31T21:37:29Z

2016-01-31T02:55:44Z

2012-02-18T17:32:47Z

@@ Line 872: / Line 872: @@
 |}
 {|style="table-layout:fixed; width: 100%;"
 |{{TextBox
-|<h4>Damage High/Low:item_details_weapon</h4>
+|<h4>Food</h4>
 |Be sure to set the following fields:
-* items.item_type = 'Food'
+* items.item_type <nowiki>=</nowiki> 'Food'
-* items.slots = 4194304 (food slot)
+* items.slots <nowiki>=</nowiki> 4194304 (food slot)
 EG where the item ID is: 11
 <pre>
-UPDATE items SET slots = 4194304, item_type = 'Food' WHERE id = 11
+UPDATE items SET slots <nowiki>=</nowiki> 4194304, item_type <nowiki>=</nowiki> 'Food' WHERE id = 11
 </pre>
 You can then attach additional food information using the item_details_food table
 |BackgroundColor=3d78b4
 |FontColor=ffffff}}
 |}
 * item_id - the ID of the item (see items table)
-* type - 0 = water, 1 = food
+* type - 0 <nowiki>=</nowiki> water, 1 <nowiki>=</nowiki> food
 * level - The level this item is best suited for (usually in 10 increments), effects regen
@@ Line 952: / Line 911: @@
 INSERT INTO item_details_food (item_id,type,level,duration,satiation) VALUES (11,1,1,30,0);
 </pre>

@@ Line 304: / Line 304: @@
 |}
 {|style="table-layout:fixed; width: 100%;"
@@ Line 834: / Line 872: @@
 |}
 {|style="table-layout:fixed; width: 100%;"
 |{{TextBox
-|<h4>Food</h4>
+|<h4>Damage High/Low:item_details_weapon</h4>
 |Be sure to set the following fields:
 * items.item_type = 'Food'
@@ Line 852: / Line 928: @@
 You can then attach additional food information using the item_details_food table
 |BackgroundColor=3d78b4
@@ Line 857: / Line 937: @@
 |}
 * item_id - the ID of the item (see items table)
@@ Line 875: / Line 952: @@
 INSERT INTO item_details_food (item_id,type,level,duration,satiation) VALUES (11,1,1,30,0);
 </pre>

@@ Line 42: / Line 42: @@
 <br>
 * name <nowiki>=</nowiki> Name of item
-* slots <nowiki>=</nowiki> 32-bit value for slots ie 11 <nowiki>=</nowiki> Primary and Head
+* slots <nowiki>=</nowiki> 32-bit value for slots ie 11 <nowiki>=</nowiki> Primary & Head
 * stack_count <nowiki>=</nowiki> determines how this item will store in inventories (ie may stack 20)
 * description - the description directly under the item name.

@@ Line 41: / Line 41: @@
 |Generic item information like name, slots, nodrop, broker value etc
 <br>
-* name = Name of item
+* name <nowiki>=</nowiki> Name of item
-* slots = 32-bit value for slots ie 11 = Primary and Head
+* slots <nowiki>=</nowiki> 32-bit value for slots ie 11 <nowiki>=</nowiki> Primary and Head
-* stack_count = determines how this item will store in inventories (ie may stack 20)
+* stack_count <nowiki>=</nowiki> determines how this item will store in inventories (ie may stack 20)
 * description - the description directly under the item name.
 * attuneable  - 1 Adds the Attuneable tag to the weapon, but doesnt make the weapon attune when equipped

@@ Line 6: / Line 6: @@
 If your making custom items this is the normal database will be using these fields for their items at the moment. So if you want work on custom items for your server as well as keep the standard items, you could use 1-999 or an id above 300,000 for them, then they should not be erased unless development of the server requires critical database structures to change.
 *1000 - 13714 - Normal
 *20000 - 58949 - Armor
@@ Line 23: / Line 27: @@
 *250000 - 250055 - House Container
 *260000 - 260008 - Armor Set
 == Table Breakdown ==
 The following lists how fields function in the database
 === Generic Item Fields ===
@@ Line 81: / Line 122: @@
 == Examples ==
 * Step 1: Create the item in the items table
@@ Line 97: / Line 147: @@
 /reload items
 == Damage Types ==
@@ Line 112: / Line 171: @@
 * FALLING 11
 * PAIN 12
 == Wield Styles ==

← Older revision		Revision as of 02:55, 31 January 2016
Line 1:		Line 1:
−	~~== About ==~~	+	{{PageHeaderChild\|Database\|Items}}
−
	The items tables offer an extremely flexible system for generating new armour, tradeskill items, food and much more!		The items tables offer an extremely flexible system for generating new armour, tradeskill items, food and much more!

← Older revision	Revision as of 17:32, 18 February 2012
(No difference)