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

User Tag List

Results 1 to 4 of 4
  1. #1
    Omahz's Avatar Master Sergeant
    Reputation
    52
    Join Date
    Dec 2007
    Posts
    85
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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:
    Code:
    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.
    Last edited by Omahz; 08-08-2008 at 05:30 PM.

    These ads disappear when you log in.

  2. #2
    simple69's Avatar Private
    Reputation
    1
    Join Date
    Jul 2008
    Posts
    1
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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:*

  3. #3
    Yamajee's Avatar Banned
    Reputation
    10
    Join Date
    Feb 2007
    Posts
    150
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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!

  4. #4
    Omahz's Avatar Master Sergeant
    Reputation
    52
    Join Date
    Dec 2007
    Posts
    85
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Yamajee View Post
    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?

Similar Threads

  1. How do you push items into the "void" ?
    By crunk001 in forum World of Warcraft General
    Replies: 1
    Last Post: 05-12-2015, 02:54 PM
  2. how do i put my custom item into the game?
    By soapygrinda in forum World of Warcraft Emulator Servers
    Replies: 6
    Last Post: 02-11-2008, 04:56 PM
  3. WSG into the horde river 2.0.1
    By abenobashi in forum World of Warcraft Exploits
    Replies: 3
    Last Post: 12-18-2006, 12:34 PM
  4. Get into the Tram Aquarium
    By Subvertigo in forum World of Warcraft Exploits
    Replies: 20
    Last Post: 08-22-2006, 01:46 PM
  5. Easy way into the hardest locations..
    By samishii23 in forum World of Warcraft Exploits
    Replies: 6
    Last Post: 07-25-2006, 02:02 PM
All times are GMT -5. The time now is 03:36 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2021 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search