Enhanced Hearth Tabard

[ergo12]

Hey everyone! This is my very first post. anyway, I got bored and decided to share this tabard. The title explains what the tabard is and does.

Copy and paste this code into a .sql file *note that the entry is 200050*

 INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES (200050,4,1,-1,"Hearth Tabard","Hearth Tabard","Hearth Tabard","Hearth Tabard",37080,3,0,0000,0000,19,-1,-1,0,0,0,0,0,0,0,0,0,0,1,0,1,30,3,5,4,5,5,5,7,5,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,50,0,0,0,0,0,0,0,0,0,8690,0,0,200,1141,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,1,"No wait this time!, Great for paladins...",0,0,0,0,0,-1,0,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

Copy and paste this code into a .sql file if youd like created characters to start out with this tabard

 INSERT INTO playercreateinfo_items VALUES ('1', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('2', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('3', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('4', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('5', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('6', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('7', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('8', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('44', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('56', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('9', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('10', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('45', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('50', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('11', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('12', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('15', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('16', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('17', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('46', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('51', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('18', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('19', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('20', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('21', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('22', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('23', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('24', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('52', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('25', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('26', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('27', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('28', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('29', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('47', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('53', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('30', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('31', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('32', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('48', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('34', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('35', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('36', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('37', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('49', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('54', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('38', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('39', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('40', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('41', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('55', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('42', '200050', '18', '1');
INSERT INTO playercreateinfo_items VALUES ('43', '200050', '18', '1');

Screenshot:ImageShack - Hosting :: screenshot114vi5.png

[SectorSeven]

nice im not trying it yet
let me test it... initial +rep for effort
more rep tomorrow if it works

[Illidan1]

Meh, it is rather easy to make it mate, But you took the time into doing it, some great job, post a picture of what it looks like an Stats, then it will be great

[The Kingofbeast]

Good job +Rep

[beltic]

Im still teaching myself a bit about the database, the 1 at the end of the statement, is that quantity to give? I would like my players to start with 4 mooncloth bags (20 slotters), and preferably make them already equiped. If I replace your item ID with the bag, and change the 1 to 4, it would put 4 bags in thier inv?

tia..

(Also, it seems to have a cool down timer, but nothing is displayed as such. )

[ergo12]

Not completely sure about that beltic but try ORN - SQL Generator
and about the cooldown problem... just tested it and the way to fix that is to log out hope that helps