I'm wanting to create a costume package release here on Hercules for all official headgears. I already have an idea of how I'd like to generate the client-side files, but what I'm having difficulty with is taking the ASCII from the idnum2resnametable.txt and placing it within an SQL database (to later be extracted to generate the client-side files).
Originally I thought I'd be able to simply do a quick macro with the text editor I use to create sql inserts to insert the ASCII name found in the .txt file into a database table, to then use php/sql to extract this "resname" field to generate new inserts for use client-side.
If anyone could help, I'd be most appreciative, as this is the only foreseeable issue I'm having in generating this release for public release. I basically just need instructions on how to take the data from the idnum2resnametable.txt and import it into a new field in the item_db_re sql table, to later be extracted in a generation script.
Hello friends!
I'm wanting to create a costume package release here on Hercules for all official headgears. I already have an idea of how I'd like to generate the client-side files, but what I'm having difficulty with is taking the ASCII from the idnum2resnametable.txt and placing it within an SQL database (to later be extracted to generate the client-side files).
Originally I thought I'd be able to simply do a quick macro with the text editor I use to create sql inserts to insert the ASCII name found in the .txt file into a database table, to then use php/sql to extract this "resname" field to generate new inserts for use client-side.
If anyone could help, I'd be most appreciative, as this is the only foreseeable issue I'm having in generating this release for public release. I basically just need instructions on how to take the data from the idnum2resnametable.txt and import it into a new field in the item_db_re sql table, to later be extracted in a generation script.
Thank you in advance!
Share this post
Link to post
Share on other sites