SQL bug on 3.3.5a

[dvdvideo123]

Hi, all. I am using WoW private server based on Mangos 3.3.5a. I made my sword using SQL query like so:

INSERT INTO item_template (entry, `class`, subclass, unk0, `name`, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, 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, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, 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, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (55000, 2, 7, -1, "Dido's Sword of Fortune", 42379, 6, 0, 1, 100000000, 50000000, 13, -1, -1, 250, 75, 43, 150, 0, 0, 0, 0, 0, 5, 1, 0,  35, 10000,  3, 10000,  4, 10000,  5, 10000,  6, 10000,  7, 10000,  37, 10000,  13, 10000,  14, 10000,  44, 10000, 400000, 400000, 0, 400000, 400000, 2, 5000, 255, 255, 255, 255, 255, 255, 0.5, 0, 0, 17713, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, "Slays the slayers", 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 1, 0, 2, 0, 4, 0, 3303, 0, 0, 0, 'internalitemhanler', 0, 10);

The query has executed perfectly with no errors, so when i logon, I get 2 problems:

1. How to create an icon for my sword, because in inventory it is displaye with "?" ?

After I hit "Crusader Strike" on my pally, there is a warning "Requires melee weapon". With default 3.3.5a items ( Like Wrathful Gladiator's Sunderer - Item - World of Warcraft ) it's working perfectly??


Many 10x !

[stoneharry]

Blizzard change it so that all items must link into the DBC's to work properly, which means you need to find an unused ID that is legit within the DBC's, or replace one of blizzards items with your own.

[dvdvideo123]

Blizzard change it so that all items must link into the DBC's to work properly, which means you need to find an unused ID that is legit within the DBC's, or replace one of blizzards items with your own.

OMG that sucks i didn't thought it that way.

May be a lower server version will help for direct item insert in the database with a query.
But as u sat so editing lev 1 item should do the trick 10x!

[dvdvideo123]

Btw what is the needed lower version of WoW and the server, I can do inserting in database with. And the items to work just fine - only one query per item ...

[dvdvideo123]

Is there anybody who can answer my question pls ???

[stoneharry]

It's around patch 3.3 (can't be exact) that they changed it. I can still use custom items fine on 3.3.5a by replacing blizzard items.