Welcome to AC Web.
Page 1 of 3 123 LastLast
Results 1 to 15 of 31
  1. #1

    Smile How to add custom items on Trinity/Mangos/Arcemu/etc.


    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Alright guys, so today I'm going to teach you all how to add custom items through your db with wow-v. Sorry but wow-v does not support undercover emu, but, I will be making a guide on how to add it to undercover emu soon!. Alright so you guys probably already have a repack if not you could look around these forums or on some other wow repack forum. Trust me theres lots. Make sure their trinity/mangos/ascent/arcemu/aspire. Those are the only ones that work with wow-v. Alright anyway let's get started. You're going to need a mysql editor. I suggest getting navicat or heidisql.

    Navicat-http://navicat.com/download/download.html
    Heidisql-http://www.heidisql.com/download.php

    For navicat get the lite version and on Heidisql use the first mirror.

    Alright now you're going to need to open up your mysql, which should be in the server section of your repack. Then, launch either navicat or heidisql.

    Navicat
    1.Go to wow-v.com sign up and hit create.
    2.Customize your item, hit submit, download and click your emulater.
    3.Open up the sql file and copy the whole thing
    4. Click file, new connect, mysql
    5. For your connection name write anything you want ex: db1
    6. Keep the hostname/IP Adress localhost or 127.0.0.1
    7. Username and password are usually root, ascent
    8.Once done go into world and click query.
    9. Now Click New Query
    10. Paste the sql into the query.
    11. Hit run and your done!


    Heidisql
    1.Go to wow-v.com sign up and hit create.
    2.Customize your item, hit submit, download and click your emulater.
    3.If you've already gone into heidisql it should download as a heidisql file, just open it and enter in your server info.
    4.Keep everything the same and your username and password should be root and ascent
    5.Hit the blue arrow at the top(Execute sql)
    6.And your done!

    Alright now start up your server and test out your item. If you have any problems please post a reply and I'll be happy to answer

  2. #2
    Don't work for trinity 4.0.6

  3. #3
    Quote Originally Posted by tommyhil View Post
    Don't work for trinity 4.0.6
    wow-v only supports 3.3.5a so you better add it manually

  4. #4
    ok, i know this is a huge bump, and i apologize,
    however, I'm getting the primary key error.

    [Err] 1062 - Duplicate entry '49999' for key 'PRIMARY'
    I can't find the way to delete the primary key though..
    I'm newb, still learning, so some help would very much be appriceated.

    Thanks and i'm sorry for this bump

    Ok, digging up my schoolbooks seemed to be enough, sorry.
    Last edited by kuposaidee; 10-20-2011 at 02:09 PM.

  5. #5
    weird like that

    Join Date
    Feb 2010
    Location
    Lazy - dont msg me
    Posts
    4,308
    Use another number as entry.
    So do not use 49999, use some other number in it's place that is not already used.

  6. #6

    Unhappy Cant use it

    When i do that i get my bags full of the item and i cant equip it cause the itemicon is a ?

  7. #7
    Crimoxic

    Join Date
    Oct 2010
    Location
    Crimoxic
    Posts
    5,571
    Quote Originally Posted by Dustor View Post
    When i do that i get my bags full of the item and i cant equip it cause the itemicon is a ?

    That means its a custom item you gotta manually add it... and i heard that there was a thread on Ac-web to fix the '?' icon.

  8. #8

    help please!!

    hi, i have trinity repack and when i click on "run" on navicat it gives me this error
    [Err] 1054 - Unknown column 'dmg_min1' in 'field list'
    you know what im making wrong or how to fix it?

  9. #9
    weird like that

    Join Date
    Feb 2010
    Location
    Lazy - dont msg me
    Posts
    4,308
    I slightly doubt you have trinitycore and if you actually do, then its not up to date.

    Tell us what core you have in more detail than "trinitycore", since it does not look like trinitycore to me.

  10. #10
    I just got an error:
    SQL Error (1054): Unknown column 'itemstatscount' in 'field list'.
    I'm using ArcEmu (2.4.3 - TBC). Any idea how can I fix it?
    Happens anytime I try to add a custom weapon.

    // Nvm, fixed already
    Last edited by Quoth; 01-13-2012 at 02:39 PM.

  11. #11
    im getting error 1054 unkowncolumn 'unko' in 'fieldlist' running 1.12 prebc private server.

  12. #12
    weird like that

    Join Date
    Feb 2010
    Location
    Lazy - dont msg me
    Posts
    4,308
    Quote Originally Posted by mok819 View Post
    im getting error 1054 unkowncolumn 'unko' in 'fieldlist' running 1.12 prebc private server.
    Since this is a guide on how to create items with wow-v, I assume you are trying to execute wow-v created SQLs to your 1.12 Pserver, which wow-v does not support.

    The DB structure is different and some columns might have different names or types and so on and some might not exist.

    You should try creating your own items on your own or find a 1.12 creator for your core.
    You could also try removing the erroring columns and their values from the SQL and then try to execute.

    WoW-V supports 3.3.5a patch cores

  13. #13
    2012-02-12 03:02:01 ERROR: Item (Entry: 997799) does not have a correct material (1), must be 5 .
    2012-02-12 03:02:01 ERROR: Item (Entry: 997798) does not have a correct material (1), must be 5 .
    2012-02-12 03:02:01 ERROR: Item (Entry: 997798) has wrong BuyCount value (0), set to default(1).
    2012-02-12 03:02:01 ERROR: Item (Entry: 998896) does not have a correct material (8), must be 6 .
    2012-02-12 03:02:01 ERROR: Item (Entry: 998898) does not have a correct material (7), must be 6 .
    2012-02-12 03:02:01 ERROR: Item (Entry: 998897) does not have a correct material (7), must be 6 .
    2012-02-12 03:02:01 ERROR: Item (Entry: 998897) does not have a correct sheathid (0), must be 7 .
    2012-02-12 03:02:01 ERROR: Item (Entry: 998893) does not have a correct material (8), must be 6 .
    2012-02-12 03:02:01 ERROR: Item (Entry: 998895) does not have a correct material (7), must be 6 .
    2012-02-12 03:02:01 ERROR: Item (Entry: 998899) does not have a correct material (6), must be 5 .
    2012-02-12 03:02:01 ERROR: Item (Entry: 998899) has wrong BuyCount value (0), set to default(1).
    2012-02-12 03:02:01 ERROR: Item (Entry: 998894) does not have a correct material (7), must be 6 .
    2012-02-12 03:02:01 ERROR: Item (Entry: 998894) does not have a correct sheathid (0), must be 7 .



    This is what happens in worldserver when i try starting it up. I ran wrator and generated the patch for it, put things where they needed to go, including the new dbc with the items. Im running on Jeuties 3.3.5a Blizzlike Repack, TrinityCore Can anyone help :/



    --I know the BuyCount values is okay, more talking towards the material and sheath errors
    Last edited by strikin6; 02-12-2012 at 07:08 AM. Reason: realized a mistake

  14. #14
    How do I make customs for a Cata server?

  15. #15
    Retired

    Join Date
    Aug 2010
    Location
    Repack Maker | C# | HTML| PHP | SQL | PAWN | CSS | Some GFX | Forum Expert
    Posts
    2,097

    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Quote Originally Posted by Mlight123 View Post
    How do I make customs for a Cata server?
    You can't. Cataclysm cores are not made for custom items...

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •