This will simply create a new gameobject_template.entry based on three parameters:
1. New name
2. DisplayID
3. Size
MYSQL:
1. New name
2. DisplayID
3. Size
MYSQL:
SQL:
-- ##########################
-- ### Gameobject Creator ###
-- ##########################
-- Simple gameobject creator for m2s
set
@gameobjectEntry = (select max(dev_world.gameobject_template.entry) from dev_world.gameobject_template);
set
@gameobjectName = 'Dropped Tradegoods',
@gameobjectDisplay = 117328,
@gameobjectSize = 2;
INSERT INTO `dev_world`.`gameobject_template` (`entry`, `type`, `displayId`, `name`, `size`) VALUES
(@gameobjectEntry+1, '5', @gameobjectDisplay, @gameobjectName, @gameobjectSize);
-- (SELECT gameobject_template.displayId FROM gameobject_template WHERE gameobject_template.entry=519229)
Liked By 1 member :