[Epic Help] Got a missing item? Ill give it to you!

[P1raten]

So this is how its going to be done.. You tell me which item that isnt in your database.. and ill try my best to fix it for you..

SQL Query For the Dagger Murder, which wasnt in my database..

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, ReqDisenchantSkill, unk2)
					VALUES (40368,2,15,-1,"Murder","Murder","Murder","Murder",54974,4,0,20,0000,13,-1,-1,213,80,0,0,0,0,0,0,0,0,1,0, 3,25, 7,46, 31,21, 36,33, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,164,306,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1500,0,0,15829,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,1,"",0,0,0,0,0,1,3,0,0,0,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

[ForcesAlike]

Idk if you can help me, But I have the items Table its just... Blank xD

[P1raten]

Idk if you can help me, But I have the items Table its just... Blank xD

I can upload a new one for you..

[Wishmaster317]

If you know of a way to add the Judgement of Light skill to my Paladin trainers, I would be most appreciative. I can't find any skill IDs in my database. Thanks.

[razorwolf49]

Lol , i've been looking for frostmourn , and i no i could just go on WoW-V and get it but i was wondering if you could just gimme it real fast ?

[P1raten]

Lol , i've been looking for frostmourn , and i no i could just go on WoW-V and get it but i was wondering if you could just gimme it real fast ?

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, ReqDisenchantSkill, unk2) 
VALUES (46609,2,8,-1,"Frostmourne","Frostmourne","Frostmourne","Frostmourne",46609,6,0,0000,0000,17,-1,-1,189,80,0,0,0,0,0,0,0,2,1,0, 4,100, 7,200, 5,150, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,597,896,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4000,0,0,7600,1,0,0,0,0,34696,2,0,0,0,0,35844,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"You will become the new lich king!",0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1,0,2,0,1585,0,0,0);

[lillfjanten]

I would be very pleased if you could upload Wotlk Vendors for Ultimate_3.0.3_Server

[rofldestroyer]

I would be very pleased if you could upload Wotlk Vendors for Ultimate_3.0.3_Server

you mean custom mall vendors?

[lillfjanten]

Yea, with Dk's armor and all the new stuffs. Yea Custom vendors

[Tornad0z]

Could you give me the SQL for the Naxx quest, please?

[P1raten]

Could you give me the SQL for the Naxx quest, please?

Which one?

Apolyon, the Soul-Render

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,ScaledStatsDistributionId,ScaledStatsDistributionFlags,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,ReqDisenchantSkill,unk2,ItemLimitCategoryId)
Values(34247,2,8,-1,Apolyon, the Soul-Render,,,,48023,4,0,207710,1038554,17,-1,-1,164,70,0,0,0,0,0,0,0,0,1,0,7,75,36,32,32,42,-1,0,-1,0,-1,0,0,0,0,0,0,0,0,0,0,0,404,607,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3400,0,0,39885,1,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,1,,0,0,0,0,0,1,1,0,0,0,0,120,0,0,0,0,2,0,2,0,2,0,2868,0,300,0,);

[Tornad0z]

THe one needed for Naxxramas in level 80, please :-)

[JaRRu]

P1raten, can ya fix for me

INSERT INTO creature_names (entry, name, subname, info_str, Flags1, type, family, rank, male_displayid, female_displayid, male_displayid2, female_displayid2, civilian, leader) VALUES ('25462','The Lich King','','','2','6','0','3','24191','0','0','0','0','0')

INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipmodel2, equipmodel3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, auras, boss, money, invisibility_type, death_state, walk_speed, run_speed, fly_speed) VALUES ('25462','83','83','2082','13945','13945','0','2','2000','1','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2','0','0','0','0','0','2.5','8','14')

^
| Need fix Greature_proto, its not work my database, its says something row1...

INSERT INTO creature_names (entry, name, subname, info_str, Flags1, type, family, rank, male_displayid, female_displayid, male_displayid2, female_displayid2, civilian, leader) VALUES ('29101','Death Knight Champion','','','0','6','0','0','25907','25908','25909','25910','0','0')

INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipmodel2, equipmodel3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, auras, boss, money, invisibility_type, death_state, walk_speed, run_speed, fly_speed) VALUES ('29101','56','56','2084','26990','26990','21630','0','2000','1','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','4','0','0','0','0','0','2.5','8','14')

INSERT INTO creature_names (entry, name, subname, info_str, Flags1, type, family, rank, male_displayid, female_displayid, male_displayid2, female_displayid2, civilian, leader) VALUES ('29196','Lord Thorval','','','0','6','0','1','25459','0','0','0','0','0')

INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipmodel2, equipmodel3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, auras, boss, money, invisibility_type, death_state, walk_speed, run_speed, fly_speed) VALUES ('29196','1','1','0','100','100','100','0','1500','0','0','0','0','0','0','0','0','0','36000','0','0','0','0','0','0','0','1','0','0','0','0','0','2.5','8','14')

^
| same here :F, +rep for help

[Tornad0z]

The one needed for Naxxramas in level 80, please :-)

Are you gonna upload the sql for it?

[The Reaper]

I need all the new wotlk items cause none of them are loading correctly or just not working. thank you i hope you will be able to help me.