Going to make this script available to the Bebot community
Hopefully some of you find it useful or maybe some of you might find a better way to run the Parsing routines.
Read the header info in the attached file on how to use. Rename to .php of course.
Warning: Depending on the machine used be prepared to spend approx 30 to 45 mins letting this script run.
Do not use this on a production database. I suggest setting up a test database and copying to live bot db once your happy with the results.
EDIT: DOH!!! I would toss up the wrong copy of that file.
Correct copy attached now.
Edit #2: Found a problem already with my own script.
Change this part in the Attached script:
// Special sort cases to correctly set ID or QL Ranges
if (strstr($name, "Symbiant,")) { $lid = $hid; }
if (preg_match('/^Basic /i', $name)) { $hql = 100; }
if (preg_match('/^Augmented /i', $name)) { $lql= 101; }
if (preg_match('/^Worn /i', $name)) { $hql = 100; }
if (preg_match('/^High-Quality /i', $name)) { $lql= 101; }
if (preg_match('/^Inferior /i', $name)) {$hql = 100; }
if (preg_match('/^Flawless /i', $name)) { $lql= 101; }
To this (Makes it more accurate):
// Special sort cases to correctly set ID or QL Ranges
if (strstr($name, "Symbiant,")) { $lid = $hid; }
if (preg_match('/^Basic /i', $name) && $lql == $hql && $icon != '') { $hql = 100; }
if (preg_match('/^Augmented /i', $name) && $lql == $hql && $icon != '') { $lql= 101; }
if (preg_match('/^Worn /i', $name) && $lql == $hql && $icon != '') { $hql = 100; }
if (preg_match('/^High-Quality /i', $name) && $lql == $hql && $icon != '') { $lql= 101; }
if (preg_match('/^Inferior /i', $name) && $lql == $hql && $icon != '') { $hql = 100; }
if (preg_match('/^Flawless /i', $name) && $lql == $hql && $icon != '') { $lql= 101; }