Help with executing custom item batch file to heidi sql? menu

User Tag List

Results 1 to 11 of 11
  1. #1
    Drelanarus's Avatar Member
    Reputation
    5
    Join Date
    Sep 2007
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Help with executing custom item batch file to heidi sql?

    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.

    Help with executing custom item batch file to heidi sql?
  2. #2
    Lich King's Avatar Contributor
    Reputation
    100
    Join Date
    May 2007
    Posts
    911
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    In your Sql, it says
    INSERT INTO 'logon.items'
    change it to
    INSERT INTO 'items'

  3. #3
    Drelanarus's Avatar Member
    Reputation
    5
    Join Date
    Sep 2007
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It already says INSERT INTO items. still doesnt work

  4. #4
    Lich King's Avatar Contributor
    Reputation
    100
    Join Date
    May 2007
    Posts
    911
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Paste the SQL here

  5. #5
    Drelanarus's Avatar Member
    Reputation
    5
    Join Date
    Sep 2007
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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);

  6. #6
    Lich King's Avatar Contributor
    Reputation
    100
    Join Date
    May 2007
    Posts
    911
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hmm.. don't see anything wrong with it, I don't know what's happening

  7. #7
    Drelanarus's Avatar Member
    Reputation
    5
    Join Date
    Sep 2007
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ouch ok thanks anyway. Can anyone else help?
    Last edited by Drelanarus; 04-26-2008 at 11:03 PM.

  8. #8
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    "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

  9. #9
    lol88998's Avatar Member
    Reputation
    2
    Join Date
    Mar 2008
    Posts
    33
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Navicat

    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..

  10. #10
    Drelanarus's Avatar Member
    Reputation
    5
    Join Date
    Sep 2007
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok thanks, ill edit if it still doesnt work.

  11. #11
    iccy's Avatar Member
    Reputation
    44
    Join Date
    Jul 2007
    Posts
    300
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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)

Similar Threads

  1. Help with LUA custom items?
    By Ageless in forum Programming
    Replies: 0
    Last Post: 11-18-2010, 12:30 PM
  2. Help with attaching deployment package to file
    By krazy12766 in forum WoW Scams Help
    Replies: 20
    Last Post: 08-08-2008, 07:12 PM
  3. Help with creating custom warper.
    By Shao111 in forum World of Warcraft Emulator Servers
    Replies: 5
    Last Post: 01-22-2008, 06:59 AM
  4. [C++]Need help with my Scripted Item
    By freezer1012 in forum World of Warcraft Emulator Servers
    Replies: 2
    Last Post: 01-13-2008, 05:55 PM
  5. Help with d2 Looking for a file
    By Phase228 in forum Gaming Chat
    Replies: 3
    Last Post: 09-27-2007, 08:05 PM
All times are GMT -5. The time now is 02:39 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search