Creating a Woodworking Table

[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.