/nacridan/map/scripts-initialisation/createCityBuildings.php

https://gitlab.com/nacridan/Nacridan · PHP · 214 lines · 143 code · 59 blank · 12 comment · 36 complexity · 8af6f5ad6c8c435497df513ce5e64fba MD5 · raw file 

    

  1. <?php
    2. 

  2. require_once ("../conf/config.ini.php");
    3. 

  3. require_once (HOMEPATH . "/lib/DB.inc.php");
    4. 

  4. require_once (HOMEPATH . "/lib/utils.inc.php");
    5. 

  5. require_once (HOMEPATH . "/lib/MapInfo.inc.php");
    6. 

  6. $db = DB::getDB();
    7. 

  7. 

  8. set_time_limit(300);
    9. 

  9. 

  10. // Choix de la carte
    11. 

  11. $map = 1;
    12. 

  12. 

  13. function getBuildingCoord($idCity, $X, $Y, $map, $distX, $distY, $mapinfo, $logfile, $db)
    14. 

  14. {
    15. 

  15.     $possiblePosition = array();
    16. 

  16.     
    17. 

  17.     for ($i = 0; $i < 11; $i ++) {
    18. 

  18.         for ($j = 0; $j < 11; $j ++) {
    19. 

  19.             $Xtest = $X - 5 + $i;
    20. 

  20.             $Ytest = $Y - 5 + $j;
    21. 

  21.             
    22. 

  22.             $validzone = $mapinfo->getValidMap($Xtest, $Ytest, 0, $map);
    23. 

  23.             
    24. 

  24.             $freePlace = 1;
    25. 

  25.             $dbp = new DBCollection("SELECT id FROM Building WHERE  x=" . $Xtest . " AND y=" . $Ytest . " AND map=" . $map, $db);
    26. 

  26.             if (! $dbp->eof())
    27. 

  27.                 $freePlace = 0;
    28. 

  28.             
    29. 

  29.             if ($validzone[0][0] && $freePlace && (distHexa($X, $Y, $Xtest, $Ytest) < 4))
    30. 

  30.                 $possiblePosition[] = array(
    31. 

  31.                     "x" => $Xtest,
    32. 

  32.                     "y" => $Ytest
    33. 

  33.                 );
    34. 

  34.         }
    35. 

  35.     }
    36. 

  36.     
    37. 

  37.     if (count($possiblePosition) == 0) {
    38. 

  38.         fputs($logfile, "\nPROBLEME DE PLACE DANS LE BOURG id= ");
    39. 

  39.         fputs($logfile, $idCity . " validzone= " . $validzone[0][0] . " freePlace=" . $freePlace . "\n");
    40. 

  40.         return 0;
    41. 

  41.     }
    42. 

  42.     
    43. 

  43.     $randKey = array_rand($possiblePosition);
    44. 

  44.     return $possiblePosition[$randKey];
    45. 

  45. }
    46. 

  46. 

  47. $mapinfo = new MapInfo($db);
    48. 

  48. 

  49. // ----- Bâtiments des Bourgs
    50. 

  50. 

  51. $logfile = fopen('buildingcreation.log', 'a');
    52. 

  52. 

  53. $dbc = new DBCollection("SELECT id,x,y FROM City WHERE type='Bourg' AND map=" . $map, $db, 0, 0);
    54. 

  54. 

  55. fputs($logfile, "Bourgs récupérés \n");
    56. 

  56. 

  57. while (! $dbc->eof()) {
    58. 

  58.     
    59. 

  59.     // ---- Création du temple, centre du bourg
    60. 

  60.     
    61. 

  61.     $X = $dbc->get("x");
    62. 

  62.     $Y = $dbc->get("y");
    63. 

  63.     
    64. 

  64.     $dbi = new DBCollection("INSERT INTO `Building` (`name`, `id_BasicBuilding`, `id_City`, `id_Player`, `sp`, `currsp`, `x`, `y`, `map`) VALUES
    65. 

  65. ('Temple', 14, " . $dbc->get("id") . ", 0, 100, 100, " . $X . ", " . $Y . ", " . $map . ")", $db, 0, 0);
    66. 

  66.     
    67. 

  67.     echo '</br>Bourg ';
    68. 

  68.     echo $dbc->get("id") . "</br>";
    69. 

  69.     
    70. 

  70.     fputs($logfile, "\n Village id= ");
    71. 

  71.     fputs($logfile, $dbc->get("id"));
    72. 

  72.     fputs($logfile, "\n Temple créé ");
    73. 

  73.     
    74. 

  74.     // Coordonnées de l'auberge, proche du temple
    75. 

  75.     
    76. 

  76.     $coord = getBuildingCoord($dbc->get("id"), $X, $Y, $map, 1, 1, $mapinfo, $logfile, $db);
    77. 

  77.     if ($coord != 0) {
    78. 

  78.         $Xtest = $coord["x"];
    79. 

  79.         $Ytest = $coord["y"];
    80. 

  80.         
    81. 

  81.         $dbi = new DBCollection("INSERT INTO `Building` (`name`, `id_BasicBuilding`, `id_City`, `id_Player`, `sp`, `currsp`, `x`, `y`, `map`) VALUES
    82. 

  82. ('Auberge', 1, " . $dbc->get("id") . ", 0, 100, 100, " . $Xtest . ", " . $Ytest . ", " . $map . ")", $db, 0, 0);
    83. 

  83.         
    84. 

  84.         fputs($logfile, "\n Auberge créée ");
    85. 

  85.     } else {
    86. 

  86.         fputs($logfile, "\n Il manque une Auberge ");
    87. 

  87.     }
    88. 

  88.     
    89. 

  89.     // Coordonnées de l'échoppe
    90. 

  90.     
    91. 

  91.     $coord = getBuildingCoord($dbc->get("id"), $X, $Y, $map, 3, 3, $mapinfo, $logfile, $db);
    92. 

  92.     if ($coord != 0) {
    93. 

  93.         $Xtest = $coord["x"];
    94. 

  94.         $Ytest = $coord["y"];
    95. 

  95.         
    96. 

  96.         $dbi = new DBCollection("INSERT INTO `Building` (`name`, `id_BasicBuilding`, `id_City`, `id_Player`, `sp`, `currsp`, `x`, `y`, `map`) VALUES
    97. 

  97. ('Échoppe', 5, " . $dbc->get("id") . ", 0, 100, 100, " . $Xtest . ", " . $Ytest . ", " . $map . ")", $db, 0, 0);
    98. 

  98.         
    99. 

  99.         fputs($logfile, "\n Echope créée ");
    100. 

  100.     } else {
    101. 

  101.         fputs($logfile, "\n Il manque une Echope ");
    102. 

  102.     }
    103. 

  103.     
    104. 

  104.     // Coordonnées de la guilde des Artisans
    105. 

  105.     
    106. 

  106.     $coord = getBuildingCoord($dbc->get("id"), $X, $Y, $map, 3, 3, $mapinfo, $logfile, $db);
    107. 

  107.     if ($coord != 0) {
    108. 

  108.         $Xtest = $coord["x"];
    109. 

  109.         $Ytest = $coord["y"];
    110. 

  110.         
    111. 

  111.         $dbi = new DBCollection("INSERT INTO `Building` (`name`, `id_BasicBuilding`, `id_City`, `id_Player`, `sp`, `currsp`, `x`, `y`, `map`) VALUES
    112. 

  112. ('Guilde des Artisans', 9, " . $dbc->get("id") . ", 0, 100, 100, " . $Xtest . ", " . $Ytest . ", " . $map . ")", $db, 0, 0);
    113. 

  113.         
    114. 

  114.         fputs($logfile, "\n Guilde des Artisans créée ");
    115. 

  115.     } else {
    116. 

  116.         fputs($logfile, "\n Il manque une Guilde des Artisans ");
    117. 

  117.     }
    118. 

  118.     
    119. 

  119.     // Coordonnées de l'école des métiers
    120. 

  120.     
    121. 

  121.     $coord = getBuildingCoord($dbc->get("id"), $X, $Y, $map, 3, 3, $mapinfo, $logfile, $db);
    122. 

  122.     if ($coord != 0) {
    123. 

  123.         $Xtest = $coord["x"];
    124. 

  124.         $Ytest = $coord["y"];
    125. 

  125.         
    126. 

  126.         $dbi = new DBCollection("INSERT INTO `Building` (`name`, `id_BasicBuilding`, `id_City`, `id_Player`, `sp`, `currsp`, `x`, `y`, `map`) VALUES
    127. 

  127. ('École des Métiers', 8, " . $dbc->get("id") . ", 0, 100, 100, " . $Xtest . ", " . $Ytest . ", " . $map . ")", $db, 0, 0);
    128. 

  128.         
    129. 

  129.         fputs($logfile, "\n École des Métiers créée ");
    130. 

  130.     } else {
    131. 

  131.         fputs($logfile, "\n Il manque une École des Métiers ");
    132. 

  132.     }
    133. 

  133.     
    134. 

  134.     // Coordonnées de la maison
    135. 

  135.     
    136. 

  136.     $coord = getBuildingCoord($dbc->get("id"), $X, $Y, $map, 4, 4, $mapinfo, $logfile, $db);
    137. 

  137.     if ($coord != 0) {
    138. 

  138.         $Xtest = $coord["x"];
    139. 

  139.         $Ytest = $coord["y"];
    140. 

  140.         
    141. 

  141.         $dbi = new DBCollection("INSERT INTO `Building` (`name`, `id_BasicBuilding`, `id_City`, `id_Player`, `sp`, `currsp`, `x`, `y`, `map`) VALUES
    142. 

  142. ('Maison', 10, " . $dbc->get("id") . ", 0, 100, 100, " . $Xtest . ", " . $Ytest . ", " . $map . ")", $db, 0, 0);
    143. 

  143.         
    144. 

  144.         fputs($logfile, "\n Maison créée ");
    145. 

  145.     } else {
    146. 

  146.         fputs($logfile, "\n Il manque une Maison ");
    147. 

  147.     }
    148. 

  148.     
    149. 

  149.     // Coordonnées de la maison
    150. 

  150.     
    151. 

  151.     $coord = getBuildingCoord($dbc->get("id"), $X, $Y, $map, 4, 4, $mapinfo, $logfile, $db);
    152. 

  152.     if ($coord != 0) {
    153. 

  153.         $Xtest = $coord["x"];
    154. 

  154.         $Ytest = $coord["y"];
    155. 

  155.         
    156. 

  156.         $dbi = new DBCollection("INSERT INTO `Building` (`name`, `id_BasicBuilding`, `id_City`, `id_Player`, `sp`, `currsp`, `x`, `y`, `map`) VALUES
    157. 

  157. ('Maison', 10, " . $dbc->get("id") . ", 0, 100, 100, " . $Xtest . ", " . $Ytest . ", " . $map . ")", $db, 0, 0);
    158. 

  158.         
    159. 

  159.         fputs($logfile, "\n Maison créée ");
    160. 

  160.     } else {
    161. 

  161.         fputs($logfile, "\n Il manque une Maison ");
    162. 

  162.     }
    163. 

  163.     
    164. 

  164.     // Coordonnées de la maison
    165. 

  165.     
    166. 

  166.     $coord = getBuildingCoord($dbc->get("id"), $X, $Y, $map, 4, 4, $mapinfo, $logfile, $db);
    167. 

  167.     if ($coord != 0) {
    168. 

  168.         $Xtest = $coord["x"];
    169. 

  169.         $Ytest = $coord["y"];
    170. 

  170.         
    171. 

  171.         $dbi = new DBCollection("INSERT INTO `Building` (`name`, `id_BasicBuilding`, `id_City`, `id_Player`, `sp`, `currsp`, `x`, `y`, `map`) VALUES
    172. 

  172. ('Maison', 10, " . $dbc->get("id") . ", 0, 100, 100, " . $Xtest . ", " . $Ytest . ", " . $map . ")", $db, 0, 0);
    173. 

  173.         
    174. 

  174.         fputs($logfile, "\n Maison créée ");
    175. 

  175.     } else {
    176. 

  176.         fputs($logfile, "\n Il manque une Maison ");
    177. 

  177.     }
    178. 

  178.     
    179. 

  179.     // Coordonnées de la maison
    180. 

  180.     
    181. 

  181.     $coord = getBuildingCoord($dbc->get("id"), $X, $Y, $map, 4, 4, $mapinfo, $logfile, $db);
    182. 

  182.     if ($coord != 0) {
    183. 

  183.         $Xtest = $coord["x"];
    184. 

  184.         $Ytest = $coord["y"];
    185. 

  185.         
    186. 

  186.         $dbi = new DBCollection("INSERT INTO `Building` (`name`, `id_BasicBuilding`, `id_City`, `id_Player`, `sp`, `currsp`, `x`, `y`, `map`) VALUES
    187. 

  187. ('Maison', 10, " . $dbc->get("id") . ", 0, 100, 100, " . $Xtest . ", " . $Ytest . ", " . $map . ")", $db, 0, 0);
    188. 

  188.         
    189. 

  189.         fputs($logfile, "\n Maison créée \n");
    190. 

  190.     } else {
    191. 

  191.         fputs($logfile, "\n Il manque une Maison \n ");
    192. 

  192.     }
    193. 

  193.     
    194. 

  194.     // Coordonnées du Comptoir de Commerce
    195. 

  195.     
    196. 

  196.     $coord = getBuildingCoord($dbc->get("id"), $X, $Y, $map, 4, 4, $mapinfo, $logfile, $db);
    197. 

  197.     if ($coord != 0) {
    198. 

  198.         $Xtest = $coord["x"];
    199. 

  199.         $Ytest = $coord["y"];
    200. 

  200.         
    201. 

  201.         $dbi = new DBCollection("INSERT INTO `Building` (`name`, `id_BasicBuilding`, `id_City`, `id_Player`, `sp`, `currsp`, `x`, `y`, `map`) VALUES
    202. 

  202. ('Comptoir Commercial', 4, " . $dbc->get("id") . ", 0, 100, 100, " . $Xtest . ", " . $Ytest . ", " . $map . ")", $db, 0, 0);
    203. 

  203.         
    204. 

  204.         fputs($logfile, "\n Comptoir créé \n");
    205. 

  205.     } else {
    206. 

  206.         fputs($logfile, "\n Il manque le comptoir de commerce \n ");
    207. 

  207.     }
    208. 

  208.     
    209. 

  209.     $dbc->next();
    210. 

  210. }
    211. 

  211. 

  212. fclose($logfile);
    213. 

  213. 

  214. ?>
    215.