Importing items into the DB (Lots of information) (Mangos 2.4.3 noobpack by 711)

[Omahz]

Hey, I posted this on another forum where I thought someone would know how to solve it because of that page being a wow-emu-item page kinda. But it's not solved yet and it have been some days.
So im relying to mmowned :wave:

This is what I posted:

Hey all!

I have a little problem, I can't add items into the Database, im using SQLyog, but it says "Import unsuccessful", but the item will be in-game and everything, except that it has on Icon and no model, it's just that white/blue box.

I have searched everywhere on this forum and other forums (and google...), but haven't find any solution.
Are the creatortools on this page updated for 2.4.3? Might be that that is the problem otherwise.

If it's to any help I am using the "MaNGOS 2.4.3 Noobpack by 711" (yes, I am a noob (it's my first server and it was very easy to setup)).

Appreciating all kind of help and please spare me any kind of flame.

Some more information I posted later in the thread:

I am downloading the right batch (the one for Mangos TBC), that's not the problem.
However, while i were comparing the .sql file downloaded from here and the item_template columns I found that the item_template has 9 columns that isn't in the .sql file. So I added these at their right places and made them "0". Then when I tried to Query I got 1 Warning, and because I'm new to this I didn't know where to see this warning, but the ScriptName column looked wierd so I deleted the "internalitemhanler". Then everything went fine when i Queried it but when trying to "Restore From SQL Dump" I get some sort of error, and after pressing OK i get "Query(s) Executed: 1, Import unsuccessful". The item is in-game but the model it's still that blue and white square.

I'm making custom items with WoW Vendetta. That's what I'm trying to import.

This is how an item looks like that I've made, it it's to any help:

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, 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, 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) 
VALUES (890605,2,4,-1,'Den`shalar, Shatterer of Kaldorei',17105,5,0,0,00000,167824,21,-1,-1,85,60,0,0,0,0,0,0,0,0,0,0, 4,84, 7,60, 1,0, 1,0, 1,0, 1,0, 1,0, 1,0, 1,0, 1,0,223,398,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1200,0,0,0,0,0,0,0,0,24661,2,0,0,0,0,35760,2,0,0,0,0,45302,2,0,0,0,0,0,0,0,0,0,0,1,'Redemption comes by the will of the old titans',0,0,0,0,0,1,3,0,0,0,0,145,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'internalitemhanler',0);

Don't know if I should say it but I will give +rep to anyone who help me make it work or at least tried to help me.

Thanks in advance.

[simple69]

this is very confusing -.-
also... in your opinion which private server like..idk... repack? o_o antrix or mangos:confused:

*i dont like the ive been here more than a month and havent been able to get 5 rep >_> lowers my self esteem D:*

[Yamajee]

I got a fix for that, use Quice betetr than using websites to execute the script. Quice - MaNGOS DataBase Editor

Very very easy to use!

[Omahz]

I got a fix for that, use Quice betetr than using websites to execute the script. Quice - MaNGOS DataBase Editor

Very very easy to use!

That seems like a very nice program, thanks you for that +Rep as well.
But how do I for example take Sulfuras, Hand of Ragnaros and change it to as i want it to be and then make a new item and not replace the real Sulfuras?