[Archive] List_Root Text > SQL Converter 1.0.0
[Archive] List_Root Text > SQL Converter 1.0.0
Original source
Original source
Hey guys !
I'm here again with a new tool that i use to convert text file from list_root into SQL format.
example :
Input :
0000053183.all 404522913ab0414b25ec8f4c0d836fd1 sound/music/citymusic/darnassus/darnassus intro.mp3
Output :
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.
https://github.com/bloerwald/LegionFiles
And obviously CASC Developpers !
Enjoy and let me know if it was use full for you too !
![[Image: ConverterScreenshot.png.96863eaf87788462...636059.png]](https://www.wowmodding.net/uploads/monthly_2017_12/ConverterScreenshot.png.96863eaf8778846253114ad33f636059.png)
rektbyfaith
12-04-2017, 12:42 PM #1Archived author: importer • Posted: 2017-12-04T12:42:57+00:00
Original source
Original source
Hey guys !
I'm here again with a new tool that i use to convert text file from list_root into SQL format.
example :
Input :
0000053183.all 404522913ab0414b25ec8f4c0d836fd1 sound/music/citymusic/darnassus/darnassus intro.mp3
Output :
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.
https://github.com/bloerwald/LegionFiles
And obviously CASC Developpers !
Enjoy and let me know if it was use full for you too !
1 Guest(s)
1 Guest(s)