/* Chocobos */ /***********************************************/ $material = 1; $Type = "MOUNT"; for ($i = 0; $i < 19; $i++) { if ($i == 17 || $i == 18) { continue; } $e = str_pad($i, 4, 0, STR_PAD_LEFT); $ID = "D0001E" . $e . "E" . $e . "E" . $e . "E" . $e; $DWN = 'chara/demihuman/d0001/obj/equipment/e0001/model/d0001e0001_dwn.mdl'; if ($i == 9) { $DWN = 'chara/demihuman/d0001/obj/equipment/e0009/model/d0001e0009_dwn.mdl'; } $SQL_Values[] = "('" . $ID . "'\n\t\t\t\t\t\t, 'chara/demihuman/d0001/obj/equipment/e" . $e . "/model/d0001e" . $e . "_top.mdl'\n\t\t\t\t\t\t, 'chara/demihuman/d0001/obj/equipment/e" . $e . "/model/d0001e" . $e . "_sho.mdl'\n\t\t\t\t\t\t, '" . $DWN . "'\n\t\t\t\t\t\t, 'chara/demihuman/d0001/obj/equipment/e" . $e . "/model/d0001e" . $e . "_met.mdl'\n\t\t\t\t\t\t, '" . $material . "'\n\t\t\t\t\t\t, '" . translate_name($ID, "en") . "'\n\t\t\t\t\t\t, '" . translate_name($ID, "de") . "'\n\t\t\t\t\t\t, '" . translate_name($ID, "fr") . "'\n\t\t\t\t\t\t, '" . translate_name($ID, "jp") . "'\n\t\t\t\t\t\t, '" . ($ID == translate_name($ID, "TYPE") ? $Type : translate_name($ID, "TYPE")) . "'\n\t\t\t\t\t\t, '" . $ICON . "')"; } /***********************************************/ /* Naked monsters */ /***********************************************/ $material = 1; $Type = "BEASTMAN"; $BMs = array(array("d1007", "e0001"), array("d1007", "e0002"), array("d1005", "e0001"), array("d1005", "e0002")); foreach ($BMs as $BM) { $ID = strtoupper($BM[0]) . strtoupper($BM[1]); $SQL_Values[] = "('" . $ID . "'\n\t\t\t\t\t, 'chara/demihuman/" . $BM[0] . "/obj/equipment/" . $BM[1] . "/model/" . $BM[0] . "" . $BM[1] . "_top.mdl'\n\t\t\t\t\t, ''\n\t\t\t\t\t, ''\n\t\t\t\t\t, ''\n\t\t\t\t\t, '" . $material . "'\n\t\t\t\t\t, '" . translate_name($ID, "en") . "'\n\t\t\t\t\t, '" . translate_name($ID, "de") . "'\n\t\t\t\t\t, '" . translate_name($ID, "fr") . "'\n\t\t\t\t\t, '" . translate_name($ID, "jp") . "'\n\t\t\t\t\t, '" . ($ID == translate_name($ID, "TYPE") ? $Type : translate_name($ID, "TYPE")) . "'\n\t\t\t\t\t, '" . $ICON . "')"; } Show($SQL_Values); $SQL .= implode(",", $SQL_Values) . " ON DUPLICATE KEY UPDATE \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ID=VALUES(ID)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Type=VALUES(Type)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Body=VALUES(Body)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Hands=VALUES(Hands)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Icon=VALUES(Icon)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Legs=VALUES(Legs)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Head=VALUES(Head)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Material=VALUES(Material)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Name_EN=VALUES(Name_EN)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Name_DE=VALUES(Name_DE)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Name_FR=VALUES(Name_FR)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Name_JP=VALUES(Name_JP)"; //print_r($SQL); $DB->IUSQL($SQL); echo "<h2>Complete</h2>";
// only interested in materials //print $file->getFilename(); $m = substr($PathArray[3], -4); $b = substr($PathArray[6], -4); $material = (int) substr($PathArray[8], -4); if ($m < 7000) { $Type = 'MONSTER'; } else { if ($m >= 7000 && $m < 8000) { $Type = 'SUMMON'; } else { if ($m > 8000 && $m < 9000) { $Type = 'PET'; } else { if ($m >= 9000) { $Type = 'MONSTER'; } } } } $Model = "chara/monster/m" . $m . "/obj/body/b" . $b . "/model/m" . $m . "b" . $b . ".mdl"; $ID = "m" . $m . "b" . $b . "_" . $material; Show("ID :" . $ID . " | TYPE: " . $Type . " FUNC | " . translate_name($ID, "TYPE")); $SQL_Values[] = "('" . $ID . "', '" . $Model . "', '" . $material . "', '" . translate_name($ID, "en") . "', '" . translate_name($ID, "de") . "', '" . translate_name($ID, "fr") . "', '" . translate_name($ID, "jp") . "', '" . ($ID == translate_name($ID, "TYPE") ? $Type : translate_name($ID, "TYPE")) . "', '" . $ICON . "')"; } } } $SQL .= implode(",", $SQL_Values) . " ON DUPLICATE KEY UPDATE \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t Model=VALUES(Model)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Type=VALUES(Type)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Material=VALUES(Material)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Icon=VALUES(Icon)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Name_DE=VALUES(Name_DE)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Name_FR=VALUES(Name_FR)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Name_FR=VALUES(Name_FR)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t, Name_JP=VALUES(Name_JP)"; //print_r($SQL); $DB->IUSQL($SQL); echo "<h2>Complete</h2>";