Advertisement
Guest User

Konwerter Metin2 - Mob proto, Mob names (MySQL->PHP-

a guest
Sep 25th, 2016
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.41 KB | None | 0 0
  1. <?php
  2.  
  3. $host_mysql = 'localhost';
  4. $user_mysql = 'root';
  5. $passwd_mysql = 'password';
  6.  
  7. header('Content-Type: text/html; charset=utf-8');
  8.  
  9. $rank = [1 => "S_PAWN", 2 => "KNIGHT", 3 => "S_KNIGHT", 4 => "BOSS", 5 => "KING",];
  10. $typeee = [1 => "NPC", 2 => "STONE", 3 => "WARP", 4 => "DOOR", 5 => "BUILDING", 7 => "POLYMORPH_PC", 8 => "HORSE", 9 => "GOTO",];
  11. $battletype = [2 => "RANGE", 3 => "MAGIC", 4 => "SPECIAL", 5 => "POWER", 6 => "TANKER",];
  12.  
  13. function get_rank($level)
  14. {
  15.     global $rank;
  16.  
  17.         if (in_array($level, $rank))
  18.     {
  19.                 return "\"" + $rank[$level] + "\"";
  20.     }
  21.         else
  22.     {
  23.                 return "\"PAWN\"";
  24.     }
  25. }
  26.  
  27. function get_type($typee)
  28. {
  29.     global $typeee;
  30.         if (in_array($typee, $typeee))
  31.     {
  32.                 return "\"" + $typeee[$typee] + "\"";
  33.     }
  34.         else
  35.     {
  36.                 return "\"MONSTER\"";
  37.     }
  38. }
  39.  
  40. function get_battletype($battle)
  41. {
  42.     global $battletype;
  43.  
  44.         if (in_array($battle, $battletype))
  45.     {
  46.                 return "\"" + $battletype[$battle] + "\"";
  47.     }
  48.         else
  49.     {
  50.                 return "\"MELEE\"";
  51.     }
  52. }
  53.  
  54. function get_flag($flag)
  55. {
  56.         if ($flag == "")
  57.     {
  58.                 return $flag;
  59.     }
  60.         else
  61.     {
  62.                 return "\"" + $flag + "\"";
  63.     }
  64. }
  65.  
  66. function get_race($race)
  67. {
  68.         if ($race == "")
  69.     {
  70.                 return $race;
  71.     }
  72.         else
  73.     {
  74.                 return "\"" + $race + "\"";
  75.     }
  76. }
  77.  
  78. function get_immune($immune)
  79. {
  80.         if ($immune == "")
  81.     {
  82.                 return $immune;
  83.     }
  84.         else
  85.     {
  86.                 return "\"" + $immune + "\"";
  87.     }
  88. }
  89.  
  90. function get_folder($folder)
  91. {
  92.         if ($folder == "")
  93.     {
  94.                 return "\"wolf\"";
  95.     }
  96.         else
  97.     {
  98.                 return "\"" + $folder + "\"";
  99.     }
  100. }
  101.      
  102. try {
  103.     $conn = new PDO("mysql:host=$host_mysql;dbname=player;charset=UTF8", $user_mysql, $passwd_mysql);
  104.     $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  105. }
  106. catch(PDOException $e)
  107. {
  108.     echo "Connection failed: " . $e->getMessage();
  109.     die();
  110. }
  111.  
  112. $sth = $conn->prepare("select * from mob_proto");
  113. $sth->execute();
  114. $result = $sth->fetchAll();
  115.  
  116. $mob_proto_line = '';
  117. $mob_names_line = '';
  118.  
  119. foreach ($result as $row)
  120. {
  121.         $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]);
  122.         #$mob_names_line .= sprintf("%s\t%s\r\n", $row[0], $row[2]);
  123. }
  124. echo $mob_proto_line;
  125. #echo $mob_names_line;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement