Loading...   

[Show Table of Contents]


  • So, have you ever wanted to know how to place a trade skill object? Well, it's really quite simple. You really only need to worry about the icon, model file, location, and heading.
  • Doors in the database are stored in the object table

§What you need:

  • SQL tools from MySQL (Just get them, there very useful for everything.)
  • Calculator (For heading)
  • Basic SQL knowledge (Not necessary but useful)
INSERT INTO object VALUES (ItemID, ZoneID, LocYPos, LocXPos, Height, Heading, 0, 0, 'Model', Type, Icon, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

§LocYPos, LocXPos, and Height

  • While in game, do the command /loc. Now I belive that loc is listed as x,y,z but objects use the cords from the real map. So x and y are backwards in /loc z is height (Not in real 3d, in real 3d x and z are the level plain and y is up and down.)

§Icon

  • When you click a trade skill container it has an icon. This is the icon list.
Icon ID Icon 
892 loom
1112 Pottery wheel
1113 Pottery Kiln
1114 Stove
1115 forge
1116 Brew barrel
1142 Augment Bath

§Model files (objectname)

  • This is what the container will look like. Do I really need to clarify?
Model File ID Model
IT66_ACTORDEF Forge
IT69_ACTORDEF Stove
IT70_ACTORDEF Brew barrel
IT73_ACTORDEF Pottery Kiln
IT74_ACTORDEF Pottery wheel
IT128_ACTORDEF Loom
IT10714_ACTORDEF Augment Bath

§Heading

  • Use #loc, it displays heading ^-^

§Type

  • This is the heart and soul of the clickable. This tells what it does.
ID Type
1  
2  
3  
4  
5  
6  
7  
8  
9  
10  Tool Box
11  Research
12  "Mortar" (Opens experiment combine window)
13  "Self Dusting" (Opens experiment combine window)
14  Baking
15  Baking
16  Tailoring
17  Forge
18  Fletching
19  Brew Barrel
20  Jewelcraft
21  Pottery Wheel
22  Pottery Kiln
23  
24  Wiz only combine container (Research container?)
25  Mage only
26  Necro only
27  Ench Only
28  Invalid or Class/Race limited (Client crash w/DEF NEC)
29  Invalid or Class/Race limited (Client crash w/DEF NEC)
30  "Always Works" (Opens experiment combine window)
31  High Elves Forge
32  Dark Elves Forge
33  Ogre Forge
34  Dwarve Forge
35  Gnome Forge
36  Barbarian Forge
37  
38  Iksar Forge
39  Human Forge
40  Human Forge
41  Halfling Tailoring kit
42  Erudite Tailor
43  Wood Elf Tailor
44  Wood Elf Fletching kit
45  Iksar Pottery Wheel
46  
47  Troll Forge
48  Wood Elf Forge
49  Halfling Forge
50  Erudite Forge
51  
52  
53  Augment