Resource icon

3.3.5a [MySQL] Simple Gameobject_template Create 1_0

Creates a new gameobject_template
This will simply create a new gameobject_template.entry based on three parameters:
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 :
Register & Get access to index
Frathir
Author Frathir
Divine

Posts

18

Likes

28

Resources

6

Version 1_0
Downloads 6
Views 797
Last Update
0.00 star(s) 0 ratings
None

3,376

1,252

9,523

410

Top