Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host_mysql = 'localhost';
- $user_mysql = 'root';
- $passwd_mysql = 'password';
- header('Content-Type: text/html; charset=utf-8');
- $rank = [1 => "S_PAWN", 2 => "KNIGHT", 3 => "S_KNIGHT", 4 => "BOSS", 5 => "KING",];
- $typeee = [1 => "NPC", 2 => "STONE", 3 => "WARP", 4 => "DOOR", 5 => "BUILDING", 7 => "POLYMORPH_PC", 8 => "HORSE", 9 => "GOTO",];
- $battletype = [2 => "RANGE", 3 => "MAGIC", 4 => "SPECIAL", 5 => "POWER", 6 => "TANKER",];
- function get_rank($level)
- {
- global $rank;
- if (in_array($level, $rank))
- {
- return "\"" + $rank[$level] + "\"";
- }
- else
- {
- return "\"PAWN\"";
- }
- }
- function get_type($typee)
- {
- global $typeee;
- if (in_array($typee, $typeee))
- {
- return "\"" + $typeee[$typee] + "\"";
- }
- else
- {
- return "\"MONSTER\"";
- }
- }
- function get_battletype($battle)
- {
- global $battletype;
- if (in_array($battle, $battletype))
- {
- return "\"" + $battletype[$battle] + "\"";
- }
- else
- {
- return "\"MELEE\"";
- }
- }
- function get_flag($flag)
- {
- if ($flag == "")
- {
- return $flag;
- }
- else
- {
- return "\"" + $flag + "\"";
- }
- }
- function get_race($race)
- {
- if ($race == "")
- {
- return $race;
- }
- else
- {
- return "\"" + $race + "\"";
- }
- }
- function get_immune($immune)
- {
- if ($immune == "")
- {
- return $immune;
- }
- else
- {
- return "\"" + $immune + "\"";
- }
- }
- function get_folder($folder)
- {
- if ($folder == "")
- {
- return "\"wolf\"";
- }
- else
- {
- return "\"" + $folder + "\"";
- }
- }
- try {
- $conn = new PDO("mysql:host=$host_mysql;dbname=player;charset=UTF8", $user_mysql, $passwd_mysql);
- $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- }
- catch(PDOException $e)
- {
- echo "Connection failed: " . $e->getMessage();
- die();
- }
- $sth = $conn->prepare("select * from mob_proto");
- $sth->execute();
- $result = $sth->fetchAll();
- $mob_proto_line = '';
- $mob_names_line = '';
- foreach ($result as $row)
- {
- $mob_proto_line .= sprintf("%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\r\n", $row[0], "\"" + $row[1] + "\"", get_rank($row[3]), get_type($row[4]), get_battletype($row[5]), $row[6], $row[7], get_flag($row[8]), $row[9], get_race($row[10]), get_immune($row[11]), $row[12], get_folder($row[13]), $row[14], $row[15], $row[16], $row[17], $row[18], $row[19], $row[20], $row[21], $row[22], $row[23], $row[24], $row[25], $row[26], $row[27], $row[28], $row[29], $row[30], $row[31], $row[32], $row[33], $row[34], $row[35], $row[36], $row[37], $row[38], $row[39], $row[40], $row[41], $row[42], $row[43], $row[44], $row[45], $row[46], $row[47], $row[48], $row[49], $row[50], $row[51], $row[52], $row[53], $row[54], $row[55], $row[56], $row[57], $row[58], $row[59], $row[60], $row[61], $row[62], $row[63], $row[64], $row[65], $row[66], $row[67], $row[68], $row[69], $row[70], $row[71]);
- #$mob_names_line .= sprintf("%s\t%s\r\n", $row[0], $row[2]);
- }
- echo $mob_proto_line;
- #echo $mob_names_line;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement