@Lighta has updated and extended trunk/tools/item_db.pl to convert the entire Pre-Renewal and Renewal item databases. All Script/DB Developers will likely be using this tool from this point forward to update our SQL files.
The new script: http://pastebin.com/AwXBYEii
Perl, if you don't have it: http://www.perl.org/get.html
To run the script, specify an input, output, target, and table. For example:
item_db.pl --i=item_db.txt --o=item_db_re.sql --t=re --table=item_db_reThe output:
item_db_re.sql
Current file: trunk/sql-files/item_db_re.sql
If you diff the files against each other, you'll notice that some null fields differ in how they're displayed - we currently have different defaults for each item type, whereas the converter uses a single array for all defaults. Once imported into the SQL database, there are no differences between the previous and new displays.
Please post your opinion (even if you don't care!) regarding the change in formatting. We'll be following through with this shortly unless people disagree.