Hey guys !
I'm here again with a new tool that i use to convert text file from list_root into SQL format.
0000053183.all 404522913ab0414b25ec8f4c0d836fd1 sound/music/citymusic/darnassus/darnassus intro.mp3
INSERT INTO `FileDataComplete_Legion` VALUES (53183,"darnassus intro.mp3","sound/music/citymusic/darnassus/");
README : How to use ?
Place Listfile.txt / root (from casc) into tool folder.
Run the .bat file i provided.
Wait till finished you will see a file named Root_File.sql
Create a table Named : FileDataComplete_Legion in database (File_ID/Filename/Filepath)
Import Root_File.sql into the database.
You're done !
* This method is use full when you want to find/retro-port massive db2 > SQL lines.
Thanks for Roccus for compiling the list_root.exe and bloerwald for binaries
Thanks for bloerwald for the listfile.
And obviously CASC Developpers !
Enjoy and let me know if it was use full for you too !
Alpha Pack Download Link :
Patch-C : Creature & Textures
Patch-I : Item Cata-Mop-WoD
Patch-L : Item Legion 7.0.1 > 7.1.5 (Not Fully Added in dbc)
Patch-W : Buildings
Patch-H : HD Pack (HD Pack Required For 3D Belt) Credits to Thrind
Server Side : DBC
Server Side : Item_Template SQL
-- Update 1 :
Added : Spell.dbc (enGB, frFR, enUS)
Added : SqlScript.sql
Added : Patch-enGB-4.MPQ (Spell for enGB client)
Added : Patch-enUS-4.MPQ (Spell for enUS client)
Added : CoreScript
- Transmog Script for 3D Belt
Added : Readme.
-- Update 2 :
Added Sql for Legion Artifact Weapons
PS : Looking for extra hands to work with me on this project.
-- Update 3
Updated Spell.dbc brings 314 New Compagnon list here : http://www.wowhead.com/spells/compan...lls:200+1+17+2
-- Update 4
Patch-W Should no more cause the game to have green texture in some place of azeroth.
Say Thanks also help me continue the project !
The Goal :
I'm aiming to help every new and old server to get a decent content. Patches won't be encrypted.
A Community Top Site will be launched.
A Community Launcher is in preparation (in c#)
A Community DBC Files Checker is in preparation (so we see if your server is compatible)
the idea is that all server / player use this client as a base. and server would only make download their custom maps if they have one.
Join the retrolution : https://www.facebook.com/WoWRetrolution/
Easy BLPConverter share the similar idea of
But instead the Easy BLPConverter call directly the BLPConverter.exe program with argument which is faster. argument are parsed from given directory and sub-directory (it exclude cape because they appear green if you convert them. *optional).
Rename BLP :
Will rename all _.blp into .blp
Print Listfile :
Will print a suitable (casc) Listfile of given directory.
How to use :
BlpConverter Path : if you're not using given BLPConverter.exe please include his path and the .exe program
Blp Folder Path : Go into your folder and copy link > Paste it in the textbox
Press Convert Blp's Button wait to finish, then Run Rename BLP and you're done.
hopefully this will save you some extra time enjoy.
Hello ! i'm currently working on a generator to make life easier. for 3.3.5a
This is an extended work for the retrolution project.
you can join the Retrolution on our main thread http://www.ac-web.org/forums/showthread.php?226933-Upcoming-New-Wotlk-Client&p=2267680#post2267680
V2.0.0 Is Out.
Mount Generator. + Item Creator + ItemDisplayInfo Icon
Pet Generator. + Item Creator + ItemDisplayInfo Icon
Extended Cost Generator.
Gem Generator. + SQL
Creature & Model DBC. (V.1)
SpellIcon Generator. (By checking Custom Icon).
Planned Work :
Tier Set Generator. Based on S8+ and T10+
Off Set Generator. Based on S8+ and T10+
Main Form :
Option Form :
C# Open Source Project :
V2.0.0 Release :
This small program coded in c# allow you to download xml/html files from wowhead. you can download in any language.
for now item/spell/npc are added by default but you can put any desire url.
particularity of this program is that it download extremely fast files that you can parse later locally on your machine.
around 50000 files /min for 1GB speed.
around 1000 files/min for 10 MB speed.
(it's not 100 % exact since it's not constant)
plus it overpass client limitations in 9/10 of the time.
external Download link :