Welcome to AC Web.
Results 1 to 5 of 5
  1. #1


    Join Date
    Sep 2014
    Location
    nloli#6788 - I dont answer PMs
    Posts
    423

    [Exact] Quick Item.dbc Convert


    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Sup friendly people.

    It's about time to give a fucking working tutorial how to convert a DBC patch with CSVed. Since I've seen 3 tutorials and all of them were wrong.
    It's simple tho.

    Step 1:

    Download this .

    Pre-Step:

    Get your servers' item.dbc and drag and drop it on the DBCUtil.exe.
    Voila,
    *a wild item.dbc.csv appeared*

    Now use: Navicat, HeidiSQL or some other programs to connect to your database.
    Navigate to your world database and enter:
    Code:
    SELECT entry, class, subclass, SoundOverrideSubclass, material, displayid, InventoryType, sheath FROM item_template WHERE entry > 58000;
    After then right click on the summary of the query and select >Export grid rows<
    Select:
    Copy to Clipboard
    Delimited Text
    Field separator [ , ]

    Uncheck:
    Include column names

    READ THE NEXT 3 STEPS BEFORE CONTINUEING

    Step 2.1(Excel users):


    Open item.dbc.csv with excel, select 1 column and paste.
    Save file, (optional) -> Open the file with CSVed (drag and drop into the CSVed launcher) and check if everything is right.

    Step 2.2 (CSVed users):


    Drag and drop the item.dbc.csv into your CSVed launcher, scroll to the bottom of the file, right click the last row and select:
    "Paste below cursor pos"


    Step 2.3 (Notepad++ users):


    I don't know why I didn't write the tutorial for Notepad++ in the first place, as its much easier and faster. Just open the Item.dbc.csv with notepad++ and paste at the bottom of the file.

    Attention: If its an already edited Item.dbc, you'll most likely duplicate entries and add unnecessary size to the file, what I do: Have a default Item.dbc as Item2.dbc.csv in the folder and just copy/paste it to Item.dbc.csv each time I'm going to add new entries.


    Step 3, last step:

    warning: Make sure theres no other item.dbc in the folder, else it'll abort.

    Save your file, drag and drop the item.dbc.csv again on the DBCUtil.exe and done .

    Voila,
    *a wild item.dbc appeared*

    Hope it was useful.

    Since I've seen many problems and I had many problems with the converting, don't hesitate to write ur problems below.

    Tip: works also gr8 if you have to import custom spells from an enUS/GB spell.dbc into another language based spell.dbc
    Last edited by Project2k14; 02-04-2019 at 03:05 PM.

  2. #2
    (̅_̅_̅(̅_̅_̅_̅_̅_̅_̅_̅ ̅()

    Join Date
    Sep 2011
    Location
    Germany
    Posts
    2,371
    Thanks, nice Tutorial works fine as provided.

    +rep

  3. #3


    Join Date
    Aug 2009
    Location
    Bulgaria,Sofia
    Posts
    398
    Hail Project2k14

  4. #4
    Awesome. Thanks for this tut

  5. #5


    Join Date
    Sep 2014
    Location
    nloli#6788 - I dont answer PMs
    Posts
    423

    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Quote Originally Posted by Project2k14 View Post

    Step 2.3 (Notepad++ users):


    I don't know why I didn't write the tutorial for Notepad++ in the first place, as its much easier and faster. Just open the Item.dbc.csv with notepad++ and paste at the bottom of the file.

    Attention: If its an already edited Item.dbc, you'll most likely duplicate entries and add unnecessary size to the file, what I do: Have a default Item.dbc as Item2.dbc.csv in the folder and just copy/paste it to Item.dbc.csv each time I'm going to add new entries.
    Added a way for Notepad++

 

 

Posting Permissions

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