Every time i try to put the custom item i made in my database, it says "SQL Error: Table 'logon.items' does not exist" Does anyone know how to fix this? I would REALLY apreciate it.
Every time i try to put the custom item i made in my database, it says "SQL Error: Table 'logon.items' does not exist" Does anyone know how to fix this? I would REALLY apreciate it.
In your Sql, it sayschange it toINSERT INTO 'logon.items'INSERT INTO 'items'
It already says INSERT INTO items. still doesnt work
Paste the SQL here
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 (9999999990,2,2,-1,"The Wrath Of Bob Dylan","The Wrath Of Bob Dylan","The Wrath Of Bob Dylan","The Wrath Of Bob Dylan",34196,6,0,1000000000,60000,15,-1,-1,0,0,0,0,0,0,0,0,0,0,1,0, 3,1200, 7,600, 5,2000, 29,178, 20,653, 13,167, 0,0, 0,0, 0,0, 0,0,4200,6723,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,500,500,500,500,500,500,1500,2,100, 34696,2,0,0,0,0,34696,2,0,0,0,0,34696,2,0,0,0,0,34696,2,0,0,0,0,34696,2,0,0,0,0, 1,"BOB DYLAN!",0,0,0,0,0,1,0,0,0,0,0,1200,0,0,0,0,8,0,2,0,4,0,1585,0,0,0);
Hmm.. don't see anything wrong with it, I don't know what's happening
Ouch ok thanks anyway. Can anyone else help?
Last edited by Drelanarus; 04-26-2008 at 11:03 PM.
"SQL Error: Table 'logon.items' does not exist"
means you are trying to execute the batch file on your logon database wich has NO items table in it...
Make sure you execute it on the correct DB and make sure it has a items table
If that dosent work try to use Navicat....
If you want some tier 9 , go to my thread i've made at Emulator Server Discussion..
Ok thanks, ill edit if it still doesnt work.
latruwski is right, I believe you are trying to execute the sql file in your LOGON database. When really you need to execute it in your main database. (ex. Ascent)