Creating a Woodworking Table
Posted: Mon Feb 21, 2011 11:08 am
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 --
You now have a new crafting station in your world.Create the Table objectAdd it to the permanent spawns for the zoneCode: Select all
/spawn create object 2346 1 1 'Woodworking Table'...and reload spawns so you have a valid object to work withCode: Select all
/spawn add new 'Woodworking Table'Open your MySQL tool, whichever one you do, and run the following query:Code: Select all
/reload spawnsIf you get 0 results, you have to create this entity_command (these are the commands that tie spawns to code handlers, explained later)Code: Select all
select * from entity_commands where command = 'create';
To create a new entity_command, run this query in your MySQL tool:(NOTE: if command_list_id 12 is already assigned, choose another... it doesn't matter what this # is)Code: Select all
insert into entity_commands (command_list_id, command_text, distance, command) values (12,'create',10,'create);
Once you verify your new entity_command is in the table, go back to your World and runThen target the new object and run these commands with the new object targeted to set it up for interaction --Code: Select all
/reload entity_commandsThis tells the server that when you right-click on the table, show the option "create".Code: Select all
/spawn set command_primary 12 /spawn set show_command_icon 1 /spawn set show_name 1 /reload spawns
And show the Hand icon on mouse-over
And show the object's name
And reload when done.