Broom's Help.

[jokerjokes]

Alright so i added the brooms to my database and it all works but when i add them and then click on them it mounts but i dont see them. What is wrong please help all thanks!!

[jokerjokes]

Anyone help? Lol i wanna get a dam broom. They so sexy.

[Illidan1]

1 : you have wrong Spell Id for "Broom"
1 a : Find the Id at WoWHead

2 : your Server is not capable of Supporting the last Patch's
2 a : Get a one of the Latest Revision, or a new Repack (Ac-Web's, or Chirsspee's)

[godkiller7]

can you give me the .sql for the broom?

[Illidan1]

can you give me the .sql for the broom?

Here you go. Godkiller7

Broom Mount

[godkiller7]

i have an antrix database, not ascent.. i tried that already, do you have one for antrix? not ascnet

[Illidan1]

Just yous the Sql values to add them into your Database
Tell me how your Sql Format for the follow is set up \/

creature_names
creature_proto
items

Tell me how those Sql Format's is set up and i will make you an Sql for it

[godkiller7]

how do i find that out? lol i'm a newb

[jokerjokes]

go into your navicat or sqlyog and look at the colum creature_name and stuff and jsut write like name1 name 2 or whatever it has.

[godkiller7]

oh!! ok thats cool hang on

[godkiller7]

just as you had them

creature_names
creature_proto
items

[jokerjokes]

Lol thats not what he meant. Like when u open it and look at the tables how is it set up is it entry|Name1|Name2|name3|Health stuff like that.

[Illidan1]

Lol i mean the "Sql Format"

entry,create name,subname

lol the Format of what is in the Table
Creature_names
creature_proto
Items

not the Format of the name of the table

[jokerjokes]

heh like i said

[godkiller7]

alright then maby this is what you mean

heres one for the pumpkin head

INSERT INTO items (entry, class, subclass, field4, name, 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 (33292,4,1,-1,"Hallowed Helm","Hallowed Helm","Hallowed Helm","Hallowed Helm",46514,3,0,0000,0002,1,-1,-1,1,1,0,0,0,0,0,0,0,0,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,54,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,"There's a hole for your head...",0,0,0,0,0,7,0,0,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);