Help with importing weapons into db menu

User Tag List

Results 1 to 9 of 9
  1. #1
    combinefreak's Avatar Private
    Reputation
    1
    Join Date
    Feb 2010
    Posts
    13
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Help with importing weapons into db

    Hello i cant import a custom weapon that i made on wow-v.com ,
    i know how to do it but now i cant, this is how my server looks like in HeidiSQL:
    [IMG]C:\Users\daniel\Pictures\untitled.jpg[/IMG]
    and i dont have a database called ascent or mangos or antrix and when i Press F9 it says: SQL Error (1146): Table 'character.items' Doesnt exist.
    please help me!
    PS im have patch 3.3.0a and im using this repack: http://devilnetwork.com/Forum/showthread.php?246-{Release}-AtreeServer-3-2-2a-x2 it says its for 3.2.2a but its updated so :/ Pls Help really need it.

    Help with importing weapons into db
  2. #2
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You need to open the database, and go to a table named "world" or something resembling that, then open "items" and then execute it.




  3. #3
    combinefreak's Avatar Private
    Reputation
    1
    Join Date
    Feb 2010
    Posts
    13
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Kiev View Post
    You need to open the database, and go to a table named "world" or something resembling that, then open "items" and then execute it.
    dont work just says :SQL Error (1054): Unknown Column 'name2' in 'field list'

  4. #4
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    In which case your database is out of date, in WoW-V select the one saying a earlier rev.




  5. #5
    combinefreak's Avatar Private
    Reputation
    1
    Join Date
    Feb 2010
    Posts
    13
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Link pls cant find it

  6. #6
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Its unique. I cant give you a link to a item you made can i? Becasue it gives the SQL queries there and then.




  7. #7
    TehUberkitten's Avatar Corporal
    Reputation
    2
    Join Date
    Feb 2010
    Posts
    33
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by combinefreak View Post
    dont work just says :SQL Error (1054): Unknown Column 'name2' in 'field list'
    Sounds to me like you are using ArcEmu since your database is called 'world', and the SQL Error (1054): Unknown Column 'name2' in 'field list' comes from teh fact that you chose the wrong SQL download when you were making you're item. There are two options -1.ArcEmu < v2801=Your revision is smaller 2.ArcEmu > v2801=Your revision is bigger

    I had exactly teh same problem, so I know . Teh one you probably want is Option numba 2!

    -Hope This Helps!

  8. #8
    combinefreak's Avatar Private
    Reputation
    1
    Join Date
    Feb 2010
    Posts
    13
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by TehUberkitten View Post
    Sounds to me like you are using ArcEmu since your database is called 'world', and the SQL Error (1054): Unknown Column 'name2' in 'field list' comes from teh fact that you chose the wrong SQL download when you were making you're item. There are two options -1.ArcEmu < v2801=Your revision is smaller 2.ArcEmu > v2801=Your revision is bigger

    I had exactly teh same problem, so I know . Teh one you probably want is Option numba 2!

    -Hope This Helps!
    +rep !!! works ty

  9. #9
    TehUberkitten's Avatar Corporal
    Reputation
    2
    Join Date
    Feb 2010
    Posts
    33
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    No problemo dude! Glad I could be of some help

Similar Threads

  1. I need help with custom weapon...
    By drewstersupreme in forum WoW ME Questions and Requests
    Replies: 2
    Last Post: 12-21-2007, 01:25 PM
  2. Need help with Weapon change with Hex editor:)
    By shveg in forum WoW ME Questions and Requests
    Replies: 1
    Last Post: 12-02-2007, 09:38 AM
  3. Help with two weapon skins
    By Authil in forum WoW ME Questions and Requests
    Replies: 1
    Last Post: 10-28-2007, 12:50 PM
  4. Need help with putting Mpqs into Data folder, not working!!!
    By Korey16 in forum WoW ME Questions and Requests
    Replies: 2
    Last Post: 12-26-2006, 12:15 PM
  5. Need help with weapon model edit!
    By Chewbbaca in forum WoW ME Questions and Requests
    Replies: 0
    Last Post: 09-20-2006, 07:02 PM
All times are GMT -5. The time now is 10:53 AM. 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