Ejemplo n.º 1
0
/* 			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>";
Ejemplo n.º 2
0
            // 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>";