User Tag List

Page 1 of 2 1 2 LastLast
Results 1 to 7 of 12

Thread: Put together a little tool to make Item.dbc files easier for Mangos and Trinity.

  1. #1
    Epic Member Anthonys-Toolbox's Avatar
    Join Date
    Apr 2013
    Location
    Sacramento, Ca
    Posts
    528
    XP
    8,460
    Level
    27
    Thanks
    134
    Thanked 346 Times in 127 Posts

    Put together a little tool to make Item.dbc files easier for Mangos and Trinity.

    You can do the tutorial in two ways, either View the Video or scroll down to the Text Version. Anyway I'm not a Programmer, so this is kind of clunky and Requires you to put the stuff on the root of your [C:\] Drive. Will not work by default for people that do not have a Hard Drive with the Letter C:\

    Download Links and small explainations:
    • Mangos (Tested on Psykko's Repack):

    • TrinityCore with SoundOverrideSubClass column in `item_template`:

    • TrinityCore with Unk0 column in `item_template`:




    For those that don't wish to view a video, here's some Text to explain the process.
    • Download the correct version that suites your project.
    • Extract the Folder from the Rar Archive to the Root/Front/Begiinning of your C:\ Drive so that it's address is C:\ItemdbcGenMangos or C:\ItemdbcGenTC_SndOver or C:\ItemdbcGenTC_unk0
      ....It HAS To be your C:\ Drive.
    • Open the zStuff.bat file in a text editor and make sure the DB Login Credentials are Correct, I have default general settings, if your information differs, please change them so it's correct.
    • Example of Login Info for TC zStuff.bat:
      Code:
      SET host=localhost
      SET user=root
      SET pass=ascent
      SET world_db=world
      SET charset=UTF8
      SET port=3306
    • After that's done and correct and you've verified that your MySQL DB is active, run the zStuff.bat and within 5-6 seconds it should be done and you should have an Item.dbc file.
    • For those that have issues with the text explaination, please view the video as it is more informative.


    Also if you do not have a Drive with the Letter C:\ , You'll have to edit the Drive Letter or path of the `OutputTableToCsvFile.sql` File in the dep\sparse\ folder. The line that says
    Code:
    INTO OUTFILE 'C:/ItemdbcGenTC_SndOver/Item.dbc.csv' 
    You'll have to change the C:/ to another letter. You can also change it's directory entirely but I am not going to provide support for that as that goes beyond my controlled environment.

    If I knew how to code and program, It would have been written with an installer to input variables and thus creating the batch file including the SQL Files with said variables but sadly I'm not.

    A Few Credits That need to be Given:
    CSV to DBC Converter in this Setup: https://code.google.com/p/cntc2/down...r2_Build98.rar
    The MySQL Function in the Batch File(not the SQL Scripts): Snipped from SkyFire's Database Installer.
    Everything Else by me.

    Last edited by Anthonys-Toolbox; 04-25-2013 at 03:32 AM.
    Awards:
    Support LOL Picasso Facepalm!

  2. The Following 7 Users Say Thank You to Anthonys-Toolbox For This Useful Post:


  3. #2
    Founder <span style='color: #FF4500'>Tommy</span>'s Avatar
    Join Date
    Apr 2013
    Posts
    7,391
    XP
    3,449,104
    Level
    378
    Thanks
    889
    Thanked 1,856 Times in 1,119 Posts
    Very nice tutorial, thanks for sharing!

  4. #3
    Respected Member <span style='color: #000000'><span class='glow_FFFFFF'>Selik</span></span>'s Avatar
    Join Date
    Apr 2013
    Location
    Tommy's mom.
    Posts
    141
    XP
    4,070
    Level
    18
    Thanks
    26
    Thanked 13 Times in 13 Posts
    Yes, this should be really helpful to everyone. Thanks!
    Awards:
    LOL Facepalm! Raffle Winner
    [Nom Entertainment] Click click.

  5. #4
    Original Poster
    Epic Member Anthonys-Toolbox's Avatar
    Join Date
    Apr 2013
    Location
    Sacramento, Ca
    Posts
    528
    XP
    8,460
    Level
    27
    Thanks
    134
    Thanked 346 Times in 127 Posts
    Thanks guys. :D

  6. #5
    Respected Member <span style='color: #006400'><span class='glow_000000'>Mathex</span></span>'s Avatar
    Join Date
    Apr 2013
    Location
    Copenhagen, Denmark
    Posts
    107
    XP
    3,316
    Level
    16
    Thanks
    27
    Thanked 56 Times in 16 Posts
    Very nice.

  7. #6
    Banned
    Join Date
    Apr 2013
    Posts
    237
    Thanks
    34
    Thanked 82 Times in 38 Posts
    Thank you.

  8. #7
    Epic Member <span style='color: #9400D3'><span class='glow_000000'>AlexeWarr</span></span>'s Avatar
    Join Date
    Apr 2013
    Location
    Romania
    Posts
    324
    XP
    6,622
    Level
    24
    Thanks
    46
    Thanked 107 Times in 46 Posts
    Nice tutorial :)
    Awards:
    Repacker Scripter
    Epic win LoL


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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