Page 1 of 1

Creating a Woodworking Table

Posted: Mon Feb 21, 2011 11:08 am
by John Adams
Create the table object and commands needed to interact with it. This is all done in-game, except for adding the entity_commands directly to your EQ2DB --
Create the Table object

Code: Select all

/spawn create object 2346 1 1 'Woodworking Table'
Add it to the permanent spawns for the zone

Code: Select all

/spawn add new 'Woodworking Table'
...and reload spawns so you have a valid object to work with

Code: Select all

/reload spawns
Open your MySQL tool, whichever one you do, and run the following query:

Code: Select all

select * from entity_commands where command = 'create';
If you get 0 results, you have to create this entity_command (these are the commands that tie spawns to code handlers, explained later)
To create a new entity_command, run this query in your MySQL tool:

Code: Select all

insert into entity_commands (command_list_id, command_text, distance, command) values (12,'create',10,'create);
(NOTE: if command_list_id 12 is already assigned, choose another... it doesn't matter what this # is)

Once you verify your new entity_command is in the table, go back to your World and run

Code: Select all

/reload entity_commands
Then target the new object and run these commands with the new object targeted to set it up for interaction --

Code: Select all

/spawn set command_primary 12
/spawn set show_command_icon 1
/spawn set show_name 1
/reload spawns
This tells the server that when you right-click on the table, show the option "create".
And show the Hand icon on mouse-over
And show the object's name
And reload when done.
You now have a new crafting station in your world.