Flying carpet Item with Vendor

[chaoticd35]

"Flying Carpet Item and Vendor"


Ok, I have gotten a few pm's on this so I decided to make a guide.

I have the sql codes for you to use and will show you how I made the Item.
(Very simple)


Sql codes:

The Item:

INSERT INTO `items` VALUES ('39150', '15', '0', '-1', 'Flying Carpet', 'Flying Carpet', 'Flying Carpet', 'Flying Carpet', '47773', '4', '0', '1000000', '1', '0', '-1', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '43343', '0', '0', '0', '330', '3000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Fly anywhere!!!', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, '0', null, '0', '0', '0', '0', '0', '0', '0', null, null, '0', '-1', '0');

Creature name:

INSERT INTO `creature_names` VALUES ('99000', 'Flying Carpet Vendor', 'Flying Carpet Vendor', '0', '0', '7', '0', '1', '0', null, '9786', '0', '0', '0', '1', '1', null, null);

Creature proto:

INSERT INTO `creature_proto` VALUES ('99000', '100', '100', '35', '245717', '245717', '34120', '1', '4224', '1800', '150', '250', '1800', '500', '650', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '36000', '0', '0', '0', '0', '0', '0', '0', '1', '0', 'MEMO', '0', '0', '0', '0', '4', '8', '12', '0');

Vendors:

INSERT INTO `vendors` VALUES ('99000', '39150', '1');

Or all sql 's together:

INSERT INTO `items` VALUES ('39150', '15', '0', '-1', 'Flying Carpet', 'Flying Carpet', 'Flying Carpet', 'Flying Carpet', '47773', '4', '0', '1000000', '1', '0', '-1', '-1', '70', '70', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '43343', '0', '0', '0', '330', '3000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Fly anywhere!!!', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, '0', null, '0', '0', '0', '0', '0', '0', '0', null, null, '0', '-1', '0');


INSERT INTO `creature_names` VALUES ('99000', 'Flying Carpet Vendor', 'Flying Carpet Vendor', '0', '0', '7', '0', '1', '0', null, '9786', '0', '0', '0', '1', '1', null, null);

INSERT INTO `creature_proto` VALUES ('99000', '100', '100', '35', '245717', '245717', '34120', '1', '4224', '1800', '150', '250', '1800', '500', '650', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '36000', '0', '0', '0', '0', '0', '0', '0', '1', '0', 'MEMO', '0', '0', '0', '0', '4', '8', '12', '0');

INSERT INTO `vendors` VALUES ('99000', '39150', '1');

Be sure and change the Item number, Vendor number,Creature number, Creature proto number to fit in your database if this number already exist.

Vendor and Item #'s are below.
Vendor 99000
Item 39150


Here is a pic of the Vendor and Item




---------------------------------How I made the Item---------------------------------------

This is done in Navicat!!

Ok, all I did to make the Item is bring up an item in my database with a display I liked. Then went to Thotbot to lookup the spell Id##. Pic below...





Example below:

Pic a Item you want to use its display like Example: "Flying machine control"
(This is only the display for your item,NOT the Flying machine)

Make a new line in Navicat, pic below..





Make a Entry number not used in your Item table .



Now all you need to do is copy the line everything just like the other Item except
the name of the Item(Flying Carpet) down to the spellid1. In spellid1 put the spell
number here 43343. Continue copying down the row and save. (Save is the check mark).




Spellid1 example below..



I hope this better explains the Item making..

Made by Chaoticd35

[EatUrBrains]

not bad ill try it out

[Saedusii]

This hardly explains how you created the item.

And WoW-V items are not allowed, unless you have tier sets or other big compilations.

(Edit: Oh well, +Rep.)

[chaoticd35]

Thanks for the reply guys. I will update the Item making..:P

Edit: Updated the item making,, hope its better understood. ty

[King Shaun]

Lots of these have been released mate, but this is one of the best ones I have seen, with a guide too etc!

Thanks for the great contribution mate.

Rep added (x6)

[Lilltimmy]

Lols i made an Flying Carpet to my Server Long time ago... :P