Custom GOs

[777devil777]

Just made some custom GOs

 
insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `spellfocus`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('800001','14','647','Cement wood thing','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `spellfocus`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('800000','5','675','Cage','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `spellfocus`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('800002','5','7149','Instance Portal','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `spellfocus`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('800003','14','7246','Zul'Aman','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `spellfocus`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('800004','5','730','Fire','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `spellfocus`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('800005','5','753','Tauren Rock','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');

I'm going to keep adding more but so far:

A tauren style rock (With paintings)
A cage (No bottom and not buggy)
A weird chimney/tarp thing, graphics make it look like it was from WoW Alpha
Tauren Fire, slightly diffrent colring of rock than any of the spawnable ones.
And lastly the new ZulAman temple thing

Note: Two of these look like existing gos but arn't. All of these gos use skipped over displays.

[Illidan1]

Very, Nice M8
Thanks Keep it up :wave:

[Yjama]

Well, I must admit that I'm rather of a noob at this thing, but I try my best. So, I ask, where do I insert those codes?
Most heartfelt thanks.

[Daxo]

Open a notepad, Copy and past the code into notepad, save it and name it anything... then execute it into your database.

[Yjama]

Managed it - simply copy-pasted it into a Query.

[Daxo]

Managed it - simply copy-pasted it into a Query.

What? i thought i just posted that

[Syllabus]

Nice one, thanks.

[Yjama]

Sorry for double post - but guess what... I got another problem. After I put it into the gobject_names table through a query, and type .gobject spawn 800003 (the entry for the gobject I wish to spawn) it just says it doesn't exist. Does it just need time to register, or do I need to fix something?
Regards.

[Daxo]

You need to make sure you saved it and type
.reload gameobject_names Or
restart you server

[Illidan1]

Yeah What Daxo said
Simple Command or Restart server
If you have done that then you have to much Gameobjects
and it wont let you spawn it

[jordash]

Whenever I try to make it into notepad it just turns into a text document

[Illidan1]

When you are in a note pad, go to File > Save as > and name it something
and put a .sql at the End, and then some were on your Desktop will be a Sql one
The note pad stays it makes a new one

[jordash]

Yeah i did that and saved it as a SQL file , Then i execute it and it keeps saying "[Err] 1062 - Duplicate entry '800006' for key 1
[Msg] Finished - Unsuccessfully"