[Question] Ship ID

[Gadella]

Any1 got a Ship ID ? :>

[TheZaronz]

What kinda ship you need?
Night elf, Booty bay style, or pirate?

[Gadella]

Pirate or Booty bay ;b

[Spartansp]

run this querry to have the ships:

 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 
   (70023, 14, 7087, 'NE Ship', 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 
   (70029, 14, 476, 'Ship', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

[TheZaronz]

The pirate isnt made in DB so you must make it same with booty
Pirate Displayid: 7552
Booty bay display: 476

[Gadella]

First: I don't know how ^^
Second: Just want a ship to stand still like .go spawn <ID> 1

[TheZaronz]

Argh, you're evil spartansp xD

Well open a notepad or a program like that, then copy spartansp query into it then save it as sql if you know, and then execute it to the db.

The ships stands still

[TheZaronz]

Ok i made you a file with pirate and booty bay , do you want me to post or upload it?

[Spartansp]

lol its as easy as copying the querry into notepad and saving it as .sql then execute batchfile or run querry and your done

[TheZaronz]

Uhm well this is it :P
Spartansp's query is good but it Have night elf and booty bay ship.
And soz for so many posts
This is the pirate ship:
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
(950002, 14, 7552, 'Pirate Ship', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

[Spartansp]

my querry is for the Nether ship and a regular pirate ship

[Gadella]

No i dont hehe ^^ how ? :b

[TheZaronz]

Uhm Nether?, But the regular ship, that's the booty bay one?
Gadella: How to copy and paste into notepad ? :P

[Spartansp]

yes in nether storm there is a ship landed on a rock

[TheZaronz]

Oh yeah that one is cool