Post: #2

Converting XuN and Ben's SQLite .add system to use MySQL table:

NOTICE: Don’t do this yet! I was too quick to post the script that I didn’t think to explain that we are only dealing with CHARDEFS here, so you should leave the .add script alone until we can get ITEMDEFS exported as well. I do have a PHP script for that in the works, it’s s just a little different because we have to handle dupelists.

If you know what you’re doing, you can use the PHP script for CHARDEFS and just get rid of the CHARDEF loop in the .add script. You’d still convert fully to MySQL but you’ll need to modify the ITEMDEF loop to insert to MySQL rather than SQLite, and then of course, everything should SELECT from MySQL, where the CHARDEFS table was populated by the PHP script and the ITEMDEF table by the .add Sphere script. Hope that makes sense.

Working with file "sphere_add_sqlite.scp":
1. Make sure "def.Item_DB" and "def.Char_DB" are set accordingly
2. Find "[function f_add_search]"
3. Replace all instances of "ldb" under that with "db"

That's it!

If you use my PHP script above, you won't really need all the build and setup functions.

You now have a PHP function to build your database with more data than you can get from within Sphere AND you have XuN and Ben's awesome .add function to read from it!