install.php (59651B)
1 <?php // install.php création des tables 2 3 include('kernel/functions.php'); 4 include('config.php'); 5 $link = opendb(); 6 7 $start = getmicrotime(); 8 9 if (isset($_GET["page"])) { 10 $page = $_GET["page"]; 11 if ($page == 2) { second(); } 12 elseif ($page == 3) { third(); } 13 elseif ($page == 4) { fourth(); } 14 elseif ($page == 5) { fifth(); } 15 else { first(); } 16 } else { first(); } 17 18 function dobatch ($p_query) { 19 $query_split = preg_split ("/[;]+/", $p_query); 20 foreach ($query_split as $command_line) { 21 $command_line = trim($command_line); 22 if ($command_line != '') { 23 $query_result = mysql_query($command_line); 24 if ($query_result == 0) { 25 break; 26 }; 27 }; 28 }; 29 return $query_result; 30 } 31 32 33 function getmicrotime() { 34 list($usec, $sec) = explode(" ",microtime()); 35 return ((float)$usec + (float)$sec); 36 } 37 38 39 function first() { 40 41 $page = '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> 42 <html> 43 <head> 44 <title>Installation de RPG illusion : Etape 1</title> 45 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> 46 <link rel="stylesheet" href="styles/css_login.css" type="text/css"> 47 </head> 48 <body> 49 <div><br><span class="mauve1"><b>Installation de RPG illusion: Etape 1</b></span><br><br> 50 <span class="alerte">Note:</span> Veuillez vous assurer que les infos dans config.php, ont été complétées correctement avant de continuer. L\'installation échouera si ces infos ne sont pas correctes. En outre, la base de données de MySQL doit exister déjà. Ce script d\'installation prendra soin d\'installer la structure et le contenu du jeu, mais la base de données elle-même doit déjà exister sur votre serveur MySQL avant d\'éxécuter l\'installation.<br><br> 51 L\'installation de RPG illusion est un processus en deux étapes simple: installez les tables de la base de données, puis créez l\'utilisateur d\'administration. Après ces deux étapes le jeu sera totalement installé.<br><br></div> 52 <form action="install.php?page=2" method="post"> 53 <div><input type="submit" name="complete" value="Commencer l\'installation"><br></div> 54 </form></body> 55 </html>'; 56 57 echo $page; 58 59 } 60 61 function second() { // Deuxième page - Installation des tables mysql. 62 63 global $dbsettings; 64 65 echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> 66 <html><head><title>Installation de RPG illusion</title> 67 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> 68 <link rel="stylesheet" href="styles/css_login.css" type="text/css"> 69 </head><body><div><br><span class="mauve1"><b>Installation de RPG illusion: Etape 1</b></span><br><br>'; 70 71 $prefix = $dbsettings["prefix"]; 72 $babble = $prefix . "_babble"; 73 $control = $prefix . "_control"; 74 $menu_users = $prefix . "_menu_users"; 75 $drops = $prefix . "_drops"; 76 $history = $prefix . "_history"; 77 $items = $prefix . "_items"; 78 $levels = $prefix . "_levels"; 79 $monsters = $prefix . "_monsters"; 80 $news = $prefix . "_news"; 81 $partners = $prefix . "_partners"; 82 $poll = $prefix . "_poll"; 83 $poll_ip = $prefix . "_poll_ip"; 84 $spells = $prefix . "_spells"; 85 $towns = $prefix . "_towns"; 86 $users = $prefix . "_users"; 87 if (isset($_POST["complete"])) { $full = true; } else { $full = false; } 88 89 $query = " 90 CREATE TABLE `$babble` ( 91 `id` int(10) unsigned NOT NULL auto_increment, 92 `postdate` date NOT NULL default '0000-00-00', 93 `author` varchar(30) NOT NULL default '', 94 `babble` varchar(120) NOT NULL default '', 95 PRIMARY KEY (`id`) 96 ) TYPE=MyISAM; 97 "; 98 if (dobatch($query) == 1) { echo 'La table Babble Box a été crée.<br>'; } else { echo '<span class="alerte">Erreur</span> de création de la table Babble Box.<br>'; } 99 unset($query); 100 101 102 $query = " 103 CREATE TABLE `$control` ( 104 `id` tinyint(3) unsigned NOT NULL auto_increment, 105 `gamename` varchar(50) NOT NULL default '', 106 `gamesize` smallint(5) unsigned NOT NULL default '0', 107 `gameopen` tinyint(3) unsigned NOT NULL default '0', 108 `gameurl` varchar(200) NOT NULL default '', 109 `adminemail` varchar(100) NOT NULL default '', 110 `forumtype` tinyint(3) unsigned NOT NULL default '0', 111 `forumaddress` varchar(200) NOT NULL default '', 112 `class1name` varchar(50) NOT NULL default '', 113 `class2name` varchar(50) NOT NULL default '', 114 `class3name` varchar(50) NOT NULL default '', 115 `diff1name` varchar(50) NOT NULL default '', 116 `diff1mod` float unsigned NOT NULL default '0', 117 `diff2name` varchar(50) NOT NULL default '', 118 `diff2mod` float unsigned NOT NULL default '0', 119 `diff3name` varchar(50) NOT NULL default '', 120 `diff3mod` float unsigned NOT NULL default '0', 121 `compression` tinyint(3) unsigned NOT NULL default '0', 122 `verifyemail` tinyint(3) unsigned NOT NULL default '0', 123 `shownews` tinyint(3) unsigned NOT NULL default '0', 124 `showbabble` tinyint(3) unsigned NOT NULL default '0', 125 `showonline` tinyint(3) unsigned NOT NULL default '0', 126 `copyright` varchar(200) NOT NULL default '0', 127 PRIMARY KEY (`id`) 128 ) TYPE=MyISAM; 129 "; 130 if (dobatch($query) == 1) { echo 'La table Control a été crée.<br>'; } else { echo '<span class="alerte">Erreur</span> de création de la table Control.<br>'; } 131 unset($query); 132 133 $query = " 134 INSERT INTO `$control` VALUES (1, 'RPG illusion v1.3', 250, 1, '', '', 1, '', 'Mage', 'Guerrier', 'Paladin', 'Facile', '1', 'Moyen', '1.2', 'Dur', '1.5', 1, 1, 1, 1, 1, '© RPGillusion.net - Tous droits réservés - 2005-2007. Images protégés par les droits d\'auteurs.'); 135 "; 136 if (dobatch($query) == 1) { echo 'La table Control a été complétée.<br>'; } else { echo '<span class="alerte">Erreur</span> lorsque la table Control a été complétée.<br>'; } 137 unset($query); 138 139 $query = " 140 CREATE TABLE `$menu_users` ( 141 `id` tinyint(3) unsigned NOT NULL auto_increment, 142 `content` text NOT NULL, 143 PRIMARY KEY (`id`) 144 ) TYPE=MyISAM; 145 "; 146 if (dobatch($query) == 1) { echo 'La table Menu_users a été crée.<br>'; } else { echo '<span class="alerte">Erreur</span> de création de la table Menu_users.<br>'; } 147 unset($query); 148 $query = " 149 INSERT INTO `$menu_users` VALUES (1, 'Menu à éditer depuis l\'administration'); 150 "; 151 if (dobatch($query) == 1) { echo 'La table Menu_users a été complétée.<br>'; } else { echo '<span class="alerte">Erreur</span> lorsque la table Menu_users a été complétée.<br>'; } 152 unset($query); 153 154 155 $query = " 156 CREATE TABLE `$drops` ( 157 `id` mediumint(8) unsigned NOT NULL auto_increment, 158 `name` varchar(30) NOT NULL default '', 159 `mlevel` smallint(5) unsigned NOT NULL default '0', 160 `type` smallint(5) unsigned NOT NULL default '0', 161 `attribute1` varchar(30) NOT NULL default '', 162 `attribute2` varchar(30) NOT NULL default '', 163 PRIMARY KEY (`id`) 164 ) TYPE=MyISAM; 165 "; 166 if (dobatch($query) == 1) { echo 'La table Drops a été crée.<br>'; } else { echo '<span class="alerte">Erreur</span> de création de la table Drops.<br>'; } 167 unset($query); 168 169 if ($full == true) { 170 $query = " 171 INSERT INTO `$drops` VALUES (1, 'Life Pebble', 1, 1, 'maxhp,10', 'X'); 172 INSERT INTO `$drops` VALUES (2, 'Life Stone', 10, 1, 'maxhp,25', 'X'); 173 INSERT INTO `$drops` VALUES (3, 'Life Rock', 25, 1, 'maxhp,50', 'X'); 174 INSERT INTO `$drops` VALUES (4, 'Magic Pebble', 1, 1, 'maxmp,10', 'X'); 175 INSERT INTO `$drops` VALUES (5, 'Magic Stone', 10, 1, 'maxmp,25', 'X'); 176 INSERT INTO `$drops` VALUES (6, 'Magic Rock', 25, 1, 'maxmp,50', 'X'); 177 INSERT INTO `$drops` VALUES (7, 'Dragon\'s Scale', 10, 1, 'defensepower,25', 'X'); 178 INSERT INTO `$drops` VALUES (8, 'Dragon\'s Plate', 30, 1, 'defensepower,50', 'X'); 179 INSERT INTO `$drops` VALUES (9, 'Dragon\'s Claw', 10, 1, 'attackpower,25', 'X'); 180 INSERT INTO `$drops` VALUES (10, 'Dragon\'s Tooth', 30, 1, 'attackpower,50', 'X'); 181 INSERT INTO `$drops` VALUES (11, 'Dragon\'s Tear', 35, 1, 'strength,50', 'X'); 182 INSERT INTO `$drops` VALUES (12, 'Dragon\'s Wing', 35, 1, 'dexterity,50', 'X'); 183 INSERT INTO `$drops` VALUES (13, 'Demon\'s Sin', 35, 1, 'maxhp,-50', 'strength,50'); 184 INSERT INTO `$drops` VALUES (14, 'Demon\'s Fall', 35, 1, 'maxmp,-50', 'strength,50'); 185 INSERT INTO `$drops` VALUES (15, 'Demon\'s Lie', 45, 1, 'maxhp,-100', 'strength,100'); 186 INSERT INTO `$drops` VALUES (16, 'Demon\'s Hate', 45, 1, 'maxmp,-100', 'strength,100'); 187 INSERT INTO `$drops` VALUES (17, 'Angel\'s Joy', 25, 1, 'maxhp,25', 'strength,25'); 188 INSERT INTO `$drops` VALUES (18, 'Angel\'s Rise', 30, 1, 'maxhp,50', 'strength,50'); 189 INSERT INTO `$drops` VALUES (19, 'Angel\'s Truth', 35, 1, 'maxhp,75', 'strength,75'); 190 INSERT INTO `$drops` VALUES (20, 'Angel\'s Love', 40, 1, 'maxhp,100', 'strength,100'); 191 INSERT INTO `$drops` VALUES (21, 'Seraph\'s Joy', 25, 1, 'maxmp,25', 'dexterity,25'); 192 INSERT INTO `$drops` VALUES (22, 'Seraph\'s Rise', 30, 1, 'maxmp,50', 'dexterity,50'); 193 INSERT INTO `$drops` VALUES (23, 'Seraph\'s Truth', 35, 1, 'maxmp,75', 'dexterity,75'); 194 INSERT INTO `$drops` VALUES (24, 'Seraph\'s Love', 40, 1, 'maxmp,100', 'dexterity,100'); 195 INSERT INTO `$drops` VALUES (25, 'Ruby', 50, 1, 'maxhp,150', 'X'); 196 INSERT INTO `$drops` VALUES (26, 'Pearl', 50, 1, 'maxmp,150', 'X'); 197 INSERT INTO `$drops` VALUES (27, 'Emerald', 50, 1, 'strength,150', 'X'); 198 INSERT INTO `$drops` VALUES (28, 'Topaz', 50, 1, 'dexterity,150', 'X'); 199 INSERT INTO `$drops` VALUES (29, 'Obsidian', 50, 1, 'attackpower,150', 'X'); 200 INSERT INTO `$drops` VALUES (30, 'Diamond', 50, 1, 'defensepower,150', 'X'); 201 INSERT INTO `$drops` VALUES (31, 'Memory Drop', 5, 1, 'expbonus,10', 'X'); 202 INSERT INTO `$drops` VALUES (32, 'Fortune Drop', 5, 1, 'goldbonus,10', 'X'); 203 "; 204 if (dobatch($query) == 1) { echo 'La table Drops a été complétée.<br>'; } else { echo '<span class="alerte">Erreur</span> lorsque la table Drops table a été complétée.<br>'; } 205 unset($query); 206 } 207 208 209 $query = " 210 CREATE TABLE `$history` ( 211 `id` bigint(255) NOT NULL auto_increment, 212 `time` int(11) NOT NULL default '0', 213 `content` text NOT NULL, 214 `charname` varchar(100) NOT NULL default '', 215 UNIQUE KEY `id` (`id`) 216 ) TYPE=MyISAM; 217 "; 218 if (dobatch($query) == 1) { echo 'La table History a été crée.<br>'; } else { echo '<span class="alerte">Erreur</span> de création de la table History.<br>'; } 219 unset($query); 220 221 $query = " 222 CREATE TABLE `$items` ( 223 `id` smallint(5) unsigned NOT NULL auto_increment, 224 `type` tinyint(3) unsigned NOT NULL default '0', 225 `name` varchar(30) NOT NULL default '', 226 `buycost` smallint(5) unsigned NOT NULL default '0', 227 `attribute` smallint(5) unsigned NOT NULL default '0', 228 `special` varchar(50) NOT NULL default '', 229 `image` tinyint(3) unsigned NOT NULL default '0', 230 `description` varchar(100) NOT NULL default '', 231 PRIMARY KEY (`id`) 232 ) TYPE=MyISAM; 233 "; 234 if (dobatch($query) == 1) { echo 'La table Items a été crée.<br>'; } else { echo '<span class="alerte">Erreur</span> de création de la table Items.<br>'; } 235 unset($query); 236 237 if ($full == true) { 238 $query = " 239 INSERT INTO `$items` VALUES (1, 1, 'Branche', 10, 2, 'Aucun',1, 'Aucune description'); 240 INSERT INTO `$items` VALUES (2, 1, 'Bilboquet', 30, 4, 'Aucun',2, 'Aucune description'); 241 INSERT INTO `$items` VALUES (3, 1, 'Epée sacrée', 35, 5, 'Aucun',3, 'Aucune description'); 242 INSERT INTO `$items` VALUES (4, 1, 'Épée Soleil', 200, 9, 'Aucun',4, 'Aucune description'); 243 INSERT INTO `$items` VALUES (5, 1, 'Épée Volca', 650, 13, 'maxhp,-8',5, 'Aucune description'); 244 INSERT INTO `$items` VALUES (6, 1, 'Hache', 200, 16, 'Aucun',8, 'Aucune description'); 245 INSERT INTO `$items` VALUES (7, 1, 'Bombes rechargeable', 300, 25, 'Aucun',7, 'Aucune description'); 246 INSERT INTO `$items` VALUES (8, 3, 'Pull anti flames', 50, 4, 'Aucun',8, 'Aucune description'); 247 INSERT INTO `$items` VALUES (9, 3, 'Manteau de proction', 120, 5, 'Aucun',9, 'Aucune description'); 248 INSERT INTO `$items` VALUES (10, 2, 'Carapace', 1200, 20, 'maxhp,60',10, 'Aucune description'); 249 INSERT INTO `$items` VALUES (11, 2, 'Casque millitaire', 190, 6, 'Aucun',11, 'Aucune description'); 250 INSERT INTO `$items` VALUES (12, 2, 'Super casque', 3000, 56, 'expbonus,100',12, 'Aucune description'); 251 INSERT INTO `$items` VALUES (13, 2, 'Casque taureau', 4500, 90, 'goldbonus,120',13, 'Aucune description'); 252 INSERT INTO `$items` VALUES (14, 1, 'Baguette magique', 6000, 200, 'expbonus,230',14, 'Aucune description'); 253 INSERT INTO `$items` VALUES (15, 3, 'Pantalon millitaire', 420, 12, 'Aucun',15, 'Aucune description'); 254 INSERT INTO `$items` VALUES (16, 3, 'Pantalon de Génoa', 850, 15, 'Aucun',16, 'Aucune description'); 255 INSERT INTO `$items` VALUES (17, 2, 'Cobra de Gobi', 6000, 220, 'goldbonus,210',17, 'Aucune description'); 256 INSERT INTO `$items` VALUES (18, 1, 'Pierre', 120, 5, 'Aucun',18, 'Aucune description'); 257 INSERT INTO `$items` VALUES (19, 1, 'Arc', 360, 10, 'Aucun',19, 'Aucune description'); 258 INSERT INTO `$items` VALUES (20, 1, 'Super arc', 960, 16, 'maxtp,18',20, 'Aucune description'); 259 INSERT INTO `$items` VALUES (21, 3, 'Lunette anti-éclairs', 300, 11, 'Aucun',21, 'Aucune description'); 260 INSERT INTO `$items` VALUES (22, 3, 'Gans', 310, 11, 'Aucun',22, 'Aucune description'); 261 INSERT INTO `$items` VALUES (23, 3, 'Super gans', 752, 14, 'Aucun',23, 'Aucune description'); 262 INSERT INTO `$items` VALUES (24, 1, 'Masse ronde', 800, 17, 'maxhp,-20',24, 'Aucune description'); 263 INSERT INTO `$items` VALUES (25, 1, 'Dent de requin', 60, 4, 'expbonus,-2',25, 'Aucune description'); 264 INSERT INTO `$items` VALUES (26, 1, 'Couteau sacré', 180, 8, 'expbonus,2',26, 'Aucune description'); 265 INSERT INTO `$items` VALUES (27, 1, 'Marteau', 500, 200, 'dexterity,-10',27, 'Aucune description'); 266 INSERT INTO `$items` VALUES (28, 2, 'Botte de Stella', 2500, 86, 'maxtp,200',28, 'Aucune description'); 267 INSERT INTO `$items` VALUES (29, 3, 'Chaussure de randonnée', 100, 4, 'maxtp,2',29, 'Aucune description'); 268 INSERT INTO `$items` VALUES (30, 3, 'Bonnet', 90, 2, 'Aucun',30, 'Aucune description'); 269 INSERT INTO `$items` VALUES (31, 1, 'Pioche', 750, 8, 'Aucun',31, 'Aucune description'); 270 INSERT INTO `$items` VALUES (32, 1, 'Poison foudroyant', 1000, 60, 'Aucun',32, 'Aucune description'); 271 INSERT INTO `$items` VALUES (33, 3, 'Potion blanche', 95, 100, 'maxhp,50',33, 'Aucune description'); 272 INSERT INTO `$items` VALUES (34, 3, 'Potion bleu', 120, 100, 'maxhp,50',34, 'Aucune description'); 273 INSERT INTO `$items` VALUES (35, 3, 'Potion rouge', 155, 100, 'maxhp,50',35, 'Aucune description'); 274 "; 275 if (dobatch($query) == 1) { echo 'La table Items a été complétée.<br>'; } else { echo '<span class="alerte">Erreur</span> lorsque la table Items a été complétée.<br>'; } 276 unset($query); 277 } 278 279 $query = " 280 CREATE TABLE `$levels` ( 281 `id` smallint(5) unsigned NOT NULL auto_increment, 282 `1_exp` mediumint(8) unsigned NOT NULL default '0', 283 `1_hp` smallint(5) unsigned NOT NULL default '0', 284 `1_mp` smallint(5) unsigned NOT NULL default '0', 285 `1_tp` smallint(5) unsigned NOT NULL default '0', 286 `1_strength` smallint(5) unsigned NOT NULL default '0', 287 `1_dexterity` smallint(5) unsigned NOT NULL default '0', 288 `1_spells` tinyint(3) unsigned NOT NULL default '0', 289 `2_exp` mediumint(8) unsigned NOT NULL default '0', 290 `2_hp` smallint(5) unsigned NOT NULL default '0', 291 `2_mp` smallint(5) unsigned NOT NULL default '0', 292 `2_tp` smallint(5) unsigned NOT NULL default '0', 293 `2_strength` smallint(5) unsigned NOT NULL default '0', 294 `2_dexterity` smallint(5) unsigned NOT NULL default '0', 295 `2_spells` tinyint(3) unsigned NOT NULL default '0', 296 `3_exp` mediumint(8) unsigned NOT NULL default '0', 297 `3_hp` smallint(5) unsigned NOT NULL default '0', 298 `3_mp` smallint(5) unsigned NOT NULL default '0', 299 `3_tp` smallint(5) unsigned NOT NULL default '0', 300 `3_strength` smallint(5) unsigned NOT NULL default '0', 301 `3_dexterity` smallint(5) unsigned NOT NULL default '0', 302 `3_spells` tinyint(3) unsigned NOT NULL default '0', 303 PRIMARY KEY (`id`) 304 ) TYPE=MyISAM; 305 "; 306 if (dobatch($query) == 1) { echo 'La table Levels a été crée.<br>'; } else { echo '<span class="alerte">Erreur</span> de création de la table Levels.<br>'; } 307 unset($query); 308 309 if ($full == true) { 310 $query = " 311 INSERT INTO `$levels` VALUES (1, 0, 15, 0, 5, 5, 5, 0, 0, 15, 0, 5, 5, 5, 0, 0, 15, 0, 5, 5, 5, 0); 312 INSERT INTO `$levels` VALUES (2, 15, 2, 5, 1, 0, 1, 1, 18, 2, 4, 1, 2, 1, 1, 20, 2, 5, 1, 0, 2, 1); 313 INSERT INTO `$levels` VALUES (3, 45, 3, 4, 2, 1, 2, 0, 54, 2, 3, 2, 3, 2, 0, 60, 2, 3, 2, 1, 3, 0); 314 INSERT INTO `$levels` VALUES (4, 105, 3, 3, 2, 1, 2, 6, 126, 2, 3, 2, 3, 2, 0, 140, 2, 4, 2, 1, 3, 0); 315 INSERT INTO `$levels` VALUES (5, 195, 2, 5, 2, 0, 1, 0, 234, 2, 4, 2, 2, 1, 6, 260, 2, 4, 2, 0, 2, 6); 316 INSERT INTO `$levels` VALUES (6, 330, 4, 5, 2, 2, 3, 0, 396, 3, 4, 2, 4, 3, 0, 440, 3, 5, 2, 2, 4, 0); 317 INSERT INTO `$levels` VALUES (7, 532, 3, 4, 2, 1, 2, 11, 639, 2, 3, 2, 3, 2, 0, 710, 2, 3, 2, 1, 3, 0); 318 INSERT INTO `$levels` VALUES (8, 835, 2, 4, 2, 0, 1, 0, 1003, 2, 3, 2, 2, 1, 11, 1115, 2, 4, 2, 0, 2, 11); 319 INSERT INTO `$levels` VALUES (9, 1290, 5, 3, 2, 3, 4, 2, 1549, 4, 2, 2, 5, 4, 0, 1722, 4, 2, 2, 3, 5, 0); 320 INSERT INTO `$levels` VALUES (10, 1973, 10, 3, 2, 4, 3, 0, 2369, 10, 2, 2, 6, 3, 0, 2633, 10, 3, 2, 4, 4, 0); 321 INSERT INTO `$levels` VALUES (11, 2997, 5, 2, 2, 3, 4, 0, 3598, 4, 1, 2, 5, 4, 2, 3999, 4, 1, 2, 3, 5, 2); 322 INSERT INTO `$levels` VALUES (12, 4533, 4, 2, 2, 2, 3, 7, 5441, 4, 1, 2, 4, 3, 0, 6047, 4, 2, 2, 2, 4, 0); 323 INSERT INTO `$levels` VALUES (13, 6453, 4, 3, 2, 2, 3, 0, 7745, 4, 2, 2, 4, 3, 0, 8607, 4, 2, 2, 2, 4, 0); 324 INSERT INTO `$levels` VALUES (14, 8853, 5, 4, 2, 3, 4, 17, 10625, 4, 3, 2, 5, 4, 7, 11807, 4, 4, 2, 3, 5, 7); 325 INSERT INTO `$levels` VALUES (15, 11853, 5, 5, 2, 3, 4, 0, 14225, 4, 4, 2, 5, 4, 0, 15808, 4, 4, 2, 3, 5, 0); 326 INSERT INTO `$levels` VALUES (16, 15603, 5, 3, 2, 3, 4, 0, 18725, 5, 2, 2, 5, 4, 0, 20807, 5, 3, 2, 3, 5, 0); 327 INSERT INTO `$levels` VALUES (17, 20290, 4, 2, 2, 2, 3, 12, 24350, 4, 1, 2, 4, 3, 0, 27057, 4, 1, 2, 2, 4, 0); 328 INSERT INTO `$levels` VALUES (18, 25563, 4, 2, 2, 2, 3, 0, 30678, 3, 1, 2, 4, 3, 14, 34869, 3, 2, 2, 2, 4, 17); 329 INSERT INTO `$levels` VALUES (19, 31495, 4, 5, 2, 2, 3, 0, 37797, 3, 4, 2, 4, 3, 0, 43657, 3, 4, 2, 2, 4, 0); 330 INSERT INTO `$levels` VALUES (20, 38169, 10, 6, 2, 3, 3, 0, 45805, 10, 5, 2, 5, 3, 0, 53543, 10, 6, 2, 3, 4, 0); 331 INSERT INTO `$levels` VALUES (21, 45676, 4, 4, 2, 2, 3, 0, 54814, 4, 3, 2, 4, 3, 0, 64664, 4, 3, 2, 2, 4, 0); 332 INSERT INTO `$levels` VALUES (22, 54121, 5, 5, 2, 3, 4, 0, 64949, 4, 4, 2, 5, 4, 12, 77175, 4, 5, 2, 3, 5, 12); 333 INSERT INTO `$levels` VALUES (23, 63622, 5, 3, 2, 3, 4, 0, 76350, 4, 2, 2, 5, 4, 0, 91250, 4, 2, 2, 3, 5, 0); 334 INSERT INTO `$levels` VALUES (24, 74310, 5, 5, 2, 3, 4, 0, 89176, 4, 4, 2, 5, 4, 0, 107083, 4, 5, 2, 3, 5, 0); 335 INSERT INTO `$levels` VALUES (25, 86334, 4, 4, 2, 2, 3, 3, 103605, 3, 3, 2, 4, 3, 17, 124895, 3, 3, 2, 2, 4, 14); 336 INSERT INTO `$levels` VALUES (26, 99861, 6, 3, 2, 4, 5, 0, 119837, 5, 2, 2, 6, 5, 0, 144933, 5, 3, 2, 4, 6, 0); 337 INSERT INTO `$levels` VALUES (27, 115078, 6, 2, 2, 4, 5, 0, 138098, 5, 1, 2, 6, 5, 0, 167475, 5, 1, 2, 4, 6, 0); 338 INSERT INTO `$levels` VALUES (28, 132197, 4, 2, 2, 2, 3, 0, 158641, 4, 1, 2, 4, 3, 0, 192835, 4, 2, 2, 2, 4, 0); 339 INSERT INTO `$levels` VALUES (29, 151456, 6, 3, 2, 4, 5, 0, 181751, 5, 2, 2, 6, 5, 3, 221365, 5, 2, 2, 4, 6, 3); 340 INSERT INTO `$levels` VALUES (30, 173121, 10, 4, 3, 4, 4, 0, 207749, 10, 3, 3, 6, 4, 0, 253461, 10, 4, 3, 4, 5, 0); 341 INSERT INTO `$levels` VALUES (31, 197494, 5, 5, 3, 3, 4, 8, 236996, 4, 3, 3, 5, 4, 0, 289568, 4, 3, 3, 3, 5, 0); 342 INSERT INTO `$levels` VALUES (32, 224913, 6, 4, 3, 4, 5, 0, 269898, 5, 3, 3, 6, 5, 0, 330188, 5, 4, 3, 4, 6, 0); 343 INSERT INTO `$levels` VALUES (33, 255758, 5, 4, 3, 3, 4, 0, 306912, 5, 3, 3, 5, 4, 0, 375885, 5, 3, 3, 3, 5, 0); 344 INSERT INTO `$levels` VALUES (34, 290458, 6, 4, 3, 4, 5, 0, 348552, 5, 3, 3, 6, 5, 8, 427294, 5, 4, 3, 4, 6, 8); 345 INSERT INTO `$levels` VALUES (35, 329495, 5, 3, 3, 3, 4, 0, 395397, 4, 2, 3, 5, 4, 0, 485126, 4, 2, 3, 3, 5, 0); 346 INSERT INTO `$levels` VALUES (36, 373412, 4, 3, 3, 2, 3, 18, 448097, 5, 2, 3, 4, 3, 0, 550188, 5, 3, 3, 2, 4, 0); 347 INSERT INTO `$levels` VALUES (37, 422818, 5, 4, 3, 3, 4, 0, 507384, 5, 3, 3, 5, 4, 0, 623383, 5, 3, 3, 3, 5, 0); 348 INSERT INTO `$levels` VALUES (38, 478399, 6, 5, 3, 4, 5, 0, 574081, 5, 4, 3, 6, 5, 15, 705726, 5, 5, 3, 4, 6, 18); 349 INSERT INTO `$levels` VALUES (39, 540927, 6, 4, 3, 4, 5, 0, 649115, 5, 3, 3, 6, 5, 0, 798362, 5, 3, 3, 4, 6, 0); 350 INSERT INTO `$levels` VALUES (40, 611271, 15, 3, 3, 5, 5, 13, 733528, 15, 2, 3, 7, 5, 0, 902577, 15, 3, 3, 5, 6, 0); 351 INSERT INTO `$levels` VALUES (41, 690408, 7, 3, 3, 5, 2, 0, 828492, 6, 2, 3, 7, 2, 0, 1019818, 6, 2, 3, 5, 3, 0); 352 INSERT INTO `$levels` VALUES (42, 779437, 7, 4, 3, 5, 6, 0, 935326, 6, 3, 3, 7, 6, 0, 1151714, 6, 4, 3, 5, 7, 0); 353 INSERT INTO `$levels` VALUES (43, 879592, 8, 5, 3, 6, 7, 0, 1055514, 7, 4, 3, 8, 7, 0, 1300096, 7, 4, 3, 6, 8, 0); 354 INSERT INTO `$levels` VALUES (44, 992268, 6, 3, 3, 4, 5, 0, 1190725, 5, 2, 3, 6, 5, 0, 1448478, 5, 3, 3, 4, 6, 0); 355 INSERT INTO `$levels` VALUES (45, 1119028, 5, 8, 3, 3, 4, 4, 1325936, 5, 8, 3, 5, 4, 18, 1596860, 5, 8, 3, 3, 5, 4); 356 INSERT INTO `$levels` VALUES (46, 1245788, 6, 5, 3, 4, 5, 0, 1461147, 5, 4, 3, 6, 5, 0, 1745242, 5, 5, 3, 4, 6, 0); 357 INSERT INTO `$levels` VALUES (47, 1372548, 7, 4, 3, 5, 6, 0, 1596358, 6, 3, 3, 7, 6, 0, 1893624, 6, 3, 3, 5, 7, 0); 358 INSERT INTO `$levels` VALUES (48, 1499308, 6, 4, 3, 4, 5, 0, 1731569, 5, 3, 3, 6, 5, 0, 2042006, 5, 4, 3, 4, 6, 0); 359 INSERT INTO `$levels` VALUES (49, 1626068, 5, 3, 3, 3, 4, 0, 1866780, 4, 2, 3, 5, 4, 0, 2190388, 4, 2, 3, 3, 5, 0); 360 INSERT INTO `$levels` VALUES (50, 1752828, 15, 3, 3, 5, 5, 0, 2001991, 15, 2, 3, 7, 5, 0, 2338770, 15, 3, 3, 5, 6, 0); 361 INSERT INTO `$levels` VALUES (51, 1879588, 6, 2, 3, 4, 5, 9, 2137202, 5, 1, 3, 6, 5, 13, 2487152, 5, 1, 3, 4, 6, 13); 362 INSERT INTO `$levels` VALUES (52, 2006348, 7, 2, 3, 5, 6, 0, 2272413, 6, 1, 3, 7, 6, 0, 2635534, 6, 2, 3, 5, 7, 0); 363 INSERT INTO `$levels` VALUES (53, 2133108, 8, 2, 3, 6, 7, 0, 2407624, 7, 1, 3, 8, 7, 0, 2783916, 7, 1, 3, 6, 8, 0); 364 INSERT INTO `$levels` VALUES (54, 2259868, 8, 4, 3, 6, 7, 0, 2542835, 7, 3, 3, 8, 7, 0, 2932298, 7, 4, 3, 6, 8, 0); 365 INSERT INTO `$levels` VALUES (55, 2386628, 7, 4, 3, 5, 6, 0, 2678046, 6, 3, 3, 7, 6, 0, 3080680, 6, 3, 3, 5, 7, 0); 366 INSERT INTO `$levels` VALUES (56, 2513388, 7, 4, 3, 5, 6, 0, 2813257, 6, 3, 3, 7, 6, 0, 3229062, 6, 4, 3, 5, 7, 9); 367 INSERT INTO `$levels` VALUES (57, 2640148, 6, 5, 3, 4, 5, 0, 2948468, 6, 4, 3, 6, 5, 0, 3377444, 6, 4, 3, 4, 6, 0); 368 INSERT INTO `$levels` VALUES (58, 2766908, 5, 5, 3, 3, 4, 0, 3083679, 5, 4, 3, 5, 4, 19, 3525826, 5, 5, 3, 3, 5, 0); 369 INSERT INTO `$levels` VALUES (59, 2893668, 8, 3, 3, 6, 7, 0, 3218890, 7, 2, 3, 8, 7, 0, 3674208, 7, 2, 3, 6, 8, 0); 370 INSERT INTO `$levels` VALUES (60, 3020428, 15, 4, 4, 6, 6, 19, 3354101, 15, 3, 4, 8, 6, 0, 3822590, 15, 4, 4, 6, 7, 15); 371 INSERT INTO `$levels` VALUES (61, 3147188, 8, 5, 4, 6, 7, 0, 3489312, 7, 4, 4, 8, 7, 0, 3970972, 7, 4, 4, 6, 8, 0); 372 INSERT INTO `$levels` VALUES (62, 3273948, 8, 4, 4, 6, 7, 0, 3624523, 7, 3, 4, 8, 7, 0, 4119354, 7, 4, 4, 6, 8, 0); 373 INSERT INTO `$levels` VALUES (63, 3400708, 9, 5, 4, 7, 8, 0, 3759734, 8, 4, 4, 9, 8, 0, 4267736, 8, 4, 4, 7, 9, 0); 374 INSERT INTO `$levels` VALUES (64, 3527468, 5, 5, 4, 3, 4, 0, 3894945, 5, 4, 4, 5, 4, 0, 4416118, 5, 5, 4, 3, 5, 0); 375 INSERT INTO `$levels` VALUES (65, 3654228, 6, 4, 4, 4, 5, 0, 4030156, 6, 3, 4, 6, 5, 0, 4564500, 6, 3, 4, 4, 6, 0); 376 INSERT INTO `$levels` VALUES (66, 3780988, 8, 4, 4, 6, 7, 0, 4165367, 8, 3, 4, 8, 7, 0, 4712882, 8, 4, 4, 6, 8, 0); 377 INSERT INTO `$levels` VALUES (67, 3907748, 7, 3, 4, 5, 6, 0, 4300578, 7, 2, 4, 7, 6, 0, 4861264, 7, 2, 4, 5, 7, 0); 378 INSERT INTO `$levels` VALUES (68, 4034508, 9, 3, 4, 7, 8, 0, 4435789, 8, 2, 4, 9, 8, 0, 5009646, 8, 3, 4, 7, 9, 0); 379 INSERT INTO `$levels` VALUES (69, 4161268, 5, 4, 4, 3, 4, 0, 4571000, 5, 3, 4, 5, 4, 0, 5158028, 5, 3, 4, 3, 5, 0); 380 INSERT INTO `$levels` VALUES (70, 4288028, 20, 4, 4, 6, 6, 5, 4706211, 20, 3, 4, 8, 6, 16, 5306410, 20, 4, 4, 6, 7, 0); 381 INSERT INTO `$levels` VALUES (71, 4414788, 5, 5, 4, 3, 4, 0, 4841422, 5, 4, 4, 5, 4, 0, 5454792, 5, 4, 4, 3, 5, 0); 382 INSERT INTO `$levels` VALUES (72, 4541548, 6, 2, 4, 4, 5, 0, 4976633, 5, 1, 4, 6, 5, 0, 5603174, 5, 2, 4, 4, 6, 0); 383 INSERT INTO `$levels` VALUES (73, 4668308, 8, 4, 4, 6, 7, 0, 5111844, 8, 3, 4, 8, 7, 0, 5751556, 8, 3, 4, 6, 8, 0); 384 INSERT INTO `$levels` VALUES (74, 4795068, 7, 5, 4, 5, 6, 0, 5247055, 6, 4, 4, 7, 6, 0, 5899938, 6, 5, 4, 5, 7, 0); 385 INSERT INTO `$levels` VALUES (75, 4921828, 5, 3, 4, 3, 4, 0, 5382266, 5, 2, 4, 5, 4, 0, 6048320, 5, 2, 4, 3, 5, 0); 386 INSERT INTO `$levels` VALUES (76, 5048588, 6, 3, 4, 4, 5, 0, 5517477, 6, 2, 4, 6, 5, 0, 6196702, 6, 3, 4, 4, 6, 0); 387 INSERT INTO `$levels` VALUES (77, 5175348, 6, 4, 4, 4, 5, 0, 5652688, 7, 3, 4, 6, 5, 0, 6345084, 7, 3, 4, 4, 6, 0); 388 INSERT INTO `$levels` VALUES (78, 5302108, 7, 4, 4, 5, 6, 0, 5787899, 7, 3, 4, 7, 6, 0, 6493466, 7, 4, 4, 5, 7, 0); 389 INSERT INTO `$levels` VALUES (79, 5428868, 8, 4, 4, 6, 7, 10, 5923110, 7, 3, 4, 8, 7, 0, 6641848, 7, 3, 4, 6, 8, 0); 390 INSERT INTO `$levels` VALUES (80, 5555628, 20, 5, 4, 6, 7, 0, 6058321, 20, 4, 4, 8, 7, 0, 6790230, 20, 5, 4, 6, 8, 0); 391 INSERT INTO `$levels` VALUES (81, 5682388, 7, 3, 4, 5, 6, 0, 6193532, 7, 2, 4, 7, 6, 0, 6938612, 7, 2, 4, 5, 7, 0); 392 INSERT INTO `$levels` VALUES (82, 5809148, 6, 4, 4, 4, 5, 0, 6328743, 5, 3, 4, 6, 5, 0, 7086994, 5, 4, 4, 4, 6, 0); 393 INSERT INTO `$levels` VALUES (83, 5935908, 6, 2, 4, 4, 5, 0, 6463954, 6, 1, 4, 6, 5, 0, 7235376, 6, 1, 4, 4, 6, 0); 394 INSERT INTO `$levels` VALUES (84, 6062668, 5, 4, 4, 3, 4, 0, 6599165, 5, 3, 4, 5, 4, 0, 7383758, 5, 4, 4, 3, 5, 0); 395 INSERT INTO `$levels` VALUES (85, 6189428, 7, 4, 4, 5, 6, 0, 6734376, 6, 3, 4, 7, 6, 0, 7532140, 6, 3, 4, 5, 7, 0); 396 INSERT INTO `$levels` VALUES (86, 6316188, 8, 5, 4, 6, 7, 0, 6869587, 8, 4, 4, 8, 7, 0, 7680522, 8, 5, 4, 6, 8, 0); 397 INSERT INTO `$levels` VALUES (87, 6442948, 8, 4, 4, 6, 7, 0, 7004798, 7, 3, 4, 8, 7, 0, 7828904, 7, 3, 4, 6, 8, 0); 398 INSERT INTO `$levels` VALUES (88, 6569708, 9, 5, 4, 7, 8, 0, 7140009, 8, 4, 4, 9, 8, 0, 7977286, 8, 5, 4, 7, 9, 0); 399 INSERT INTO `$levels` VALUES (89, 6696468, 5, 2, 4, 3, 4, 0, 7275220, 5, 1, 4, 5, 4, 0, 8125668, 5, 1, 4, 3, 5, 0); 400 INSERT INTO `$levels` VALUES (90, 6823228, 20, 2, 5, 7, 8, 0, 7410431, 20, 1, 5, 9, 8, 0, 8274050, 20, 2, 5, 7, 9, 0); 401 INSERT INTO `$levels` VALUES (91, 6949988, 5, 3, 5, 3, 4, 0, 7545642, 5, 2, 5, 5, 4, 0, 8422432, 5, 2, 5, 3, 5, 0); 402 INSERT INTO `$levels` VALUES (92, 7076748, 6, 3, 5, 4, 5, 0, 7680853, 4, 2, 5, 6, 5, 0, 8570814, 4, 3, 5, 4, 6, 0); 403 INSERT INTO `$levels` VALUES (93, 7203508, 8, 4, 5, 6, 7, 0, 7816064, 6, 2, 5, 8, 7, 0, 8719196, 6, 2, 5, 6, 8, 0); 404 INSERT INTO `$levels` VALUES (94, 7330268, 4, 4, 5, 3, 3, 0, 7951275, 4, 3, 5, 5, 3, 0, 8867578, 4, 4, 5, 3, 4, 0); 405 INSERT INTO `$levels` VALUES (95, 7457028, 3, 3, 5, 5, 2, 0, 8086486, 4, 2, 5, 7, 2, 0, 9015960, 4, 2, 5, 5, 3, 0); 406 INSERT INTO `$levels` VALUES (96, 7583788, 5, 3, 5, 4, 3, 0, 8221697, 5, 2, 5, 7, 3, 0, 9164342, 5, 3, 5, 4, 4, 0); 407 INSERT INTO `$levels` VALUES (97, 7710548, 5, 4, 5, 4, 5, 0, 8356908, 5, 3, 5, 7, 5, 0, 9312724, 5, 3, 5, 4, 6, 0); 408 INSERT INTO `$levels` VALUES (98, 7837308, 4, 5, 5, 4, 3, 0, 8492119, 4, 3, 5, 7, 3, 0, 9461106, 4, 4, 5, 4, 4, 0); 409 INSERT INTO `$levels` VALUES (99, 7964068, 50, 5, 5, 6, 5, 0, 8627330, 50, 3, 5, 9, 5, 0, 9609488, 50, 4, 5, 6, 6, 0); 410 INSERT INTO `$levels` VALUES (100, 16777215, 0, 0, 0, 0, 0, 0, 16777215, 0, 0, 0, 0, 0, 0, 16777215, 0, 0, 0, 0, 0, 0); 411 "; 412 if (dobatch($query) == 1) { echo 'La table Levels a été complétée.<br>'; } else { echo '<span class="alerte">Erreur</span> lorsque la table Levels a été complétée.<br>'; } 413 unset($query); 414 } 415 416 $query = " 417 CREATE TABLE `$monsters` ( 418 `id` smallint(5) unsigned NOT NULL auto_increment, 419 `name` varchar(50) NOT NULL default '', 420 `maxhp` smallint(5) unsigned NOT NULL default '0', 421 `maxdam` smallint(5) unsigned NOT NULL default '0', 422 `armor` smallint(5) unsigned NOT NULL default '0', 423 `level` smallint(5) unsigned NOT NULL default '0', 424 `maxexp` smallint(5) unsigned NOT NULL default '0', 425 `maxgold` smallint(5) unsigned NOT NULL default '0', 426 `immune` tinyint(3) unsigned NOT NULL default '0', 427 PRIMARY KEY (`id`) 428 ) TYPE=MyISAM; 429 "; 430 if (dobatch($query) == 1) { echo 'La table Monsters a été crée.<br>'; } else { echo '<span class="alerte">Erreur</span> de création de la table Monsters.<br>'; } 431 unset($query); 432 433 if ($full == true) { 434 $query = " 435 INSERT INTO `$monsters` VALUES (1, 'Blue Slime', 4, 3, 1, 1, 1, 1, 0); 436 INSERT INTO `$monsters` VALUES (2, 'Red Slime', 6, 5, 1, 1, 2, 1, 0); 437 INSERT INTO `$monsters` VALUES (3, 'Critter', 6, 5, 2, 1, 4, 2, 0); 438 INSERT INTO `$monsters` VALUES (4, 'Creature', 10, 8, 2, 2, 4, 2, 0); 439 INSERT INTO `$monsters` VALUES (5, 'Shadow', 10, 9, 3, 2, 6, 2, 1); 440 INSERT INTO `$monsters` VALUES (6, 'Drake', 11, 10, 3, 2, 8, 3, 0); 441 INSERT INTO `$monsters` VALUES (7, 'Shade', 12, 10, 3, 3, 10, 3, 1); 442 INSERT INTO `$monsters` VALUES (8, 'Drakelor', 14, 12, 4, 3, 10, 3, 0); 443 INSERT INTO `$monsters` VALUES (9, 'Silver Slime', 15, 100, 200, 30, 15, 1000, 2); 444 INSERT INTO `$monsters` VALUES (10, 'Scamp', 16, 13, 5, 4, 15, 5, 0); 445 INSERT INTO `$monsters` VALUES (11, 'Raven', 16, 13, 5, 4, 18, 6, 0); 446 INSERT INTO `$monsters` VALUES (12, 'Scorpion', 18, 14, 6, 5, 20, 7, 0); 447 INSERT INTO `$monsters` VALUES (13, 'Illusion', 20, 15, 6, 5, 20, 7, 1); 448 INSERT INTO `$monsters` VALUES (14, 'Nightshade', 22, 16, 6, 6, 24, 8, 0); 449 INSERT INTO `$monsters` VALUES (15, 'Drakemal', 22, 18, 7, 6, 24, 8, 0); 450 INSERT INTO `$monsters` VALUES (16, 'Shadow Raven', 24, 18, 7, 6, 26, 9, 1); 451 INSERT INTO `$monsters` VALUES (17, 'Ghost', 24, 20, 8, 6, 28, 9, 0); 452 INSERT INTO `$monsters` VALUES (18, 'Frost Raven', 26, 20, 8, 7, 30, 10, 0); 453 INSERT INTO `$monsters` VALUES (19, 'Rogue Scorpion', 28, 22, 9, 7, 32, 11, 0); 454 INSERT INTO `$monsters` VALUES (20, 'Ghoul', 29, 24, 9, 7, 34, 11, 0); 455 INSERT INTO `$monsters` VALUES (21, 'Magician', 30, 24, 10, 8, 36, 12, 0); 456 INSERT INTO `$monsters` VALUES (22, 'Rogue', 30, 25, 12, 8, 40, 13, 0); 457 INSERT INTO `$monsters` VALUES (23, 'Drakefin', 32, 26, 12, 8, 40, 13, 0); 458 INSERT INTO `$monsters` VALUES (24, 'Shimmer', 32, 26, 14, 8, 45, 15, 1); 459 INSERT INTO `$monsters` VALUES (25, 'Fire Raven', 34, 28, 14, 9, 45, 15, 0); 460 INSERT INTO `$monsters` VALUES (26, 'Dybbuk', 34, 28, 14, 9, 50, 17, 0); 461 INSERT INTO `$monsters` VALUES (27, 'Knave', 36, 30, 15, 9, 52, 17, 0); 462 INSERT INTO `$monsters` VALUES (28, 'Goblin', 36, 30, 15, 10, 54, 18, 0); 463 INSERT INTO `$monsters` VALUES (29, 'Skeleton', 38, 30, 18, 10, 58, 19, 0); 464 INSERT INTO `$monsters` VALUES (30, 'Dark Slime', 38, 32, 18, 10, 62, 21, 0); 465 INSERT INTO `$monsters` VALUES (31, 'Silver Scorpion', 30, 160, 350, 40, 63, 2000, 2); 466 INSERT INTO `$monsters` VALUES (32, 'Mirage', 40, 32, 20, 11, 64, 21, 1); 467 INSERT INTO `$monsters` VALUES (33, 'Sorceror', 41, 33, 22, 11, 68, 23, 0); 468 INSERT INTO `$monsters` VALUES (34, 'Imp', 42, 34, 22, 12, 70, 23, 0); 469 INSERT INTO `$monsters` VALUES (35, 'Nymph', 43, 35, 22, 12, 70, 23, 0); 470 INSERT INTO `$monsters` VALUES (36, 'Scoundrel', 43, 35, 22, 12, 75, 25, 0); 471 INSERT INTO `$monsters` VALUES (37, 'Megaskeleton', 44, 36, 24, 13, 78, 26, 0); 472 INSERT INTO `$monsters` VALUES (38, 'Grey Wolf', 44, 36, 24, 13, 82, 27, 0); 473 INSERT INTO `$monsters` VALUES (39, 'Phantom', 46, 38, 24, 14, 85, 28, 1); 474 INSERT INTO `$monsters` VALUES (40, 'Specter', 46, 38, 24, 14, 90, 30, 0); 475 INSERT INTO `$monsters` VALUES (41, 'Dark Scorpion', 48, 40, 26, 15, 95, 32, 1); 476 INSERT INTO `$monsters` VALUES (42, 'Warlock', 48, 40, 26, 15, 100, 33, 1); 477 INSERT INTO `$monsters` VALUES (43, 'Orc', 49, 42, 28, 15, 104, 35, 0); 478 INSERT INTO `$monsters` VALUES (44, 'Sylph', 49, 42, 28, 15, 106, 35, 0); 479 INSERT INTO `$monsters` VALUES (45, 'Wraith', 50, 45, 30, 16, 108, 36, 0); 480 INSERT INTO `$monsters` VALUES (46, 'Hellion', 50, 45, 30, 16, 110, 37, 0); 481 INSERT INTO `$monsters` VALUES (47, 'Bandit', 52, 45, 30, 16, 114, 38, 0); 482 INSERT INTO `$monsters` VALUES (48, 'Ultraskeleton', 52, 46, 32, 16, 116, 39, 0); 483 INSERT INTO `$monsters` VALUES (49, 'Dark Wolf', 54, 47, 36, 17, 120, 40, 1); 484 INSERT INTO `$monsters` VALUES (50, 'Troll', 56, 48, 36, 17, 120, 40, 0); 485 INSERT INTO `$monsters` VALUES (51, 'Werewolf', 56, 48, 38, 17, 124, 41, 0); 486 INSERT INTO `$monsters` VALUES (52, 'Hellcat', 58, 50, 38, 18, 128, 43, 0); 487 INSERT INTO `$monsters` VALUES (53, 'Spirit', 58, 50, 38, 18, 132, 44, 0); 488 INSERT INTO `$monsters` VALUES (54, 'Nisse', 60, 52, 40, 19, 132, 44, 0); 489 INSERT INTO `$monsters` VALUES (55, 'Dawk', 60, 54, 40, 19, 136, 45, 0); 490 INSERT INTO `$monsters` VALUES (56, 'Figment', 64, 55, 42, 19, 140, 47, 1); 491 INSERT INTO `$monsters` VALUES (57, 'Hellhound', 66, 56, 44, 20, 140, 47, 0); 492 INSERT INTO `$monsters` VALUES (58, 'Wizard', 66, 56, 44, 20, 144, 48, 0); 493 INSERT INTO `$monsters` VALUES (59, 'Uruk', 68, 58, 44, 20, 146, 49, 0); 494 INSERT INTO `$monsters` VALUES (60, 'Siren', 68, 400, 800, 50, 10000, 50, 2); 495 INSERT INTO `$monsters` VALUES (61, 'Megawraith', 70, 60, 46, 21, 155, 52, 0); 496 INSERT INTO `$monsters` VALUES (62, 'Dawkin', 70, 60, 46, 21, 155, 52, 0); 497 INSERT INTO `$monsters` VALUES (63, 'Grey Bear', 70, 62, 48, 21, 160, 53, 0); 498 INSERT INTO `$monsters` VALUES (64, 'Haunt', 72, 62, 48, 22, 160, 53, 0); 499 INSERT INTO `$monsters` VALUES (65, 'Hellbeast', 74, 64, 50, 22, 165, 55, 0); 500 INSERT INTO `$monsters` VALUES (66, 'Fear', 76, 66, 52, 23, 165, 55, 0); 501 INSERT INTO `$monsters` VALUES (67, 'Beast', 76, 66, 52, 23, 170, 57, 0); 502 INSERT INTO `$monsters` VALUES (68, 'Ogre', 78, 68, 54, 23, 170, 57, 0); 503 INSERT INTO `$monsters` VALUES (69, 'Dark Bear', 80, 70, 56, 24, 175, 58, 1); 504 INSERT INTO `$monsters` VALUES (70, 'Fire', 80, 72, 56, 24, 175, 58, 0); 505 INSERT INTO `$monsters` VALUES (71, 'Polgergeist', 84, 74, 58, 25, 180, 60, 0); 506 INSERT INTO `$monsters` VALUES (72, 'Fright', 86, 76, 58, 25, 180, 60, 0); 507 INSERT INTO `$monsters` VALUES (73, 'Lycan', 88, 78, 60, 25, 185, 62, 0); 508 INSERT INTO `$monsters` VALUES (74, 'Terra Elemental', 88, 80, 62, 25, 185, 62, 1); 509 INSERT INTO `$monsters` VALUES (75, 'Necromancer', 90, 80, 62, 26, 190, 63, 0); 510 INSERT INTO `$monsters` VALUES (76, 'Ultrawraith', 90, 82, 64, 26, 190, 63, 0); 511 INSERT INTO `$monsters` VALUES (77, 'Dawkor', 92, 82, 64, 26, 195, 65, 0); 512 INSERT INTO `$monsters` VALUES (78, 'Werebear', 92, 84, 65, 26, 195, 65, 0); 513 INSERT INTO `$monsters` VALUES (79, 'Brute', 94, 84, 65, 27, 200, 67, 0); 514 INSERT INTO `$monsters` VALUES (80, 'Large Beast', 96, 88, 66, 27, 200, 67, 0); 515 INSERT INTO `$monsters` VALUES (81, 'Horror', 96, 88, 68, 27, 210, 70, 0); 516 INSERT INTO `$monsters` VALUES (82, 'Flame', 100, 90, 70, 28, 210, 70, 0); 517 INSERT INTO `$monsters` VALUES (83, 'Lycanthor', 100, 90, 70, 28, 210, 70, 0); 518 INSERT INTO `$monsters` VALUES (84, 'Wyrm', 100, 92, 72, 28, 220, 73, 0); 519 INSERT INTO `$monsters` VALUES (85, 'Aero Elemental', 104, 94, 74, 29, 220, 73, 1); 520 INSERT INTO `$monsters` VALUES (86, 'Dawkare', 106, 96, 76, 29, 220, 73, 0); 521 INSERT INTO `$monsters` VALUES (87, 'Large Brute', 108, 98, 78, 29, 230, 77, 0); 522 INSERT INTO `$monsters` VALUES (88, 'Frost Wyrm', 110, 100, 80, 30, 230, 77, 0); 523 INSERT INTO `$monsters` VALUES (89, 'Knight', 110, 102, 80, 30, 240, 80, 0); 524 INSERT INTO `$monsters` VALUES (90, 'Lycanthra', 112, 104, 82, 30, 240, 80, 0); 525 INSERT INTO `$monsters` VALUES (91, 'Terror', 115, 108, 84, 31, 250, 83, 0); 526 INSERT INTO `$monsters` VALUES (92, 'Blaze', 118, 108, 84, 31, 250, 83, 0); 527 INSERT INTO `$monsters` VALUES (93, 'Aqua Elemental', 120, 110, 90, 31, 260, 87, 1); 528 INSERT INTO `$monsters` VALUES (94, 'Fire Wyrm', 120, 110, 90, 32, 260, 87, 0); 529 INSERT INTO `$monsters` VALUES (95, 'Lesser Wyvern', 122, 110, 92, 32, 270, 90, 0); 530 INSERT INTO `$monsters` VALUES (96, 'Doomer', 124, 112, 92, 32, 270, 90, 0); 531 INSERT INTO `$monsters` VALUES (97, 'Armor Knight', 130, 115, 95, 33, 280, 93, 0); 532 INSERT INTO `$monsters` VALUES (98, 'Wyvern', 134, 120, 95, 33, 290, 97, 0); 533 INSERT INTO `$monsters` VALUES (99, 'Nightmare', 138, 125, 100, 33, 300, 100, 0); 534 INSERT INTO `$monsters` VALUES (100, 'Fira Elemental', 140, 125, 100, 34, 310, 103, 0); 535 INSERT INTO `$monsters` VALUES (101, 'Megadoomer', 140, 128, 105, 34, 320, 107, 0); 536 INSERT INTO `$monsters` VALUES (102, 'Greater Wyvern', 145, 130, 105, 34, 335, 112, 0); 537 INSERT INTO `$monsters` VALUES (103, 'Advocate', 148, 132, 108, 35, 350, 117, 0); 538 INSERT INTO `$monsters` VALUES (104, 'Strong Knight', 150, 135, 110, 35, 365, 122, 0); 539 INSERT INTO `$monsters` VALUES (105, 'Liche', 150, 135, 110, 35, 380, 127, 0); 540 INSERT INTO `$monsters` VALUES (106, 'Ultradoomer', 155, 140, 115, 36, 395, 132, 0); 541 INSERT INTO `$monsters` VALUES (107, 'Fanatic', 160, 140, 115, 36, 410, 137, 0); 542 INSERT INTO `$monsters` VALUES (108, 'Green Dragon', 160, 140, 115, 36, 425, 142, 0); 543 INSERT INTO `$monsters` VALUES (109, 'Fiend', 160, 145, 120, 37, 445, 148, 0); 544 INSERT INTO `$monsters` VALUES (110, 'Greatest Wyvern', 162, 150, 120, 37, 465, 155, 0); 545 INSERT INTO `$monsters` VALUES (111, 'Lesser Devil', 164, 150, 120, 37, 485, 162, 0); 546 INSERT INTO `$monsters` VALUES (112, 'Liche Master', 168, 155, 125, 38, 505, 168, 0); 547 INSERT INTO `$monsters` VALUES (113, 'Zealot', 168, 155, 125, 38, 530, 177, 0); 548 INSERT INTO `$monsters` VALUES (114, 'Serafiend', 170, 155, 125, 38, 555, 185, 0); 549 INSERT INTO `$monsters` VALUES (115, 'Pale Knight', 175, 160, 130, 39, 580, 193, 0); 550 INSERT INTO `$monsters` VALUES (116, 'Blue Dragon', 180, 160, 130, 39, 605, 202, 0); 551 INSERT INTO `$monsters` VALUES (117, 'Obsessive', 180, 160, 135, 40, 630, 210, 0); 552 INSERT INTO `$monsters` VALUES (118, 'Devil', 184, 164, 135, 40, 666, 222, 0); 553 INSERT INTO `$monsters` VALUES (119, 'Liche Prince', 190, 168, 138, 40, 660, 220, 0); 554 INSERT INTO `$monsters` VALUES (120, 'Cherufiend', 195, 170, 140, 41, 690, 230, 0); 555 INSERT INTO `$monsters` VALUES (121, 'Red Dragon', 200, 180, 145, 41, 720, 240, 0); 556 INSERT INTO `$monsters` VALUES (122, 'Greater Devil', 200, 180, 145, 41, 750, 250, 0); 557 INSERT INTO `$monsters` VALUES (123, 'Renegade', 205, 185, 150, 42, 780, 260, 0); 558 INSERT INTO `$monsters` VALUES (124, 'Archfiend', 210, 190, 150, 42, 810, 270, 0); 559 INSERT INTO `$monsters` VALUES (125, 'Liche Lord', 210, 190, 155, 42, 850, 283, 0); 560 INSERT INTO `$monsters` VALUES (126, 'Greatest Devil', 215, 195, 160, 43, 890, 297, 0); 561 INSERT INTO `$monsters` VALUES (127, 'Dark Knight', 220, 200, 160, 43, 930, 310, 0); 562 INSERT INTO `$monsters` VALUES (128, 'Giant', 220, 200, 165, 43, 970, 323, 0); 563 INSERT INTO `$monsters` VALUES (129, 'Shadow Dragon', 225, 200, 170, 44, 1010, 337, 0); 564 INSERT INTO `$monsters` VALUES (130, 'Liche King', 225, 205, 170, 44, 1050, 350, 0); 565 INSERT INTO `$monsters` VALUES (131, 'Incubus', 230, 205, 175, 44, 1100, 367, 1); 566 INSERT INTO `$monsters` VALUES (132, 'Traitor', 230, 205, 175, 45, 1150, 383, 0); 567 INSERT INTO `$monsters` VALUES (133, 'Demon', 240, 210, 180, 45, 1200, 400, 0); 568 INSERT INTO `$monsters` VALUES (134, 'Dark Dragon', 245, 215, 180, 45, 1250, 417, 1); 569 INSERT INTO `$monsters` VALUES (135, 'Insurgent', 250, 220, 190, 46, 1300, 433, 0); 570 INSERT INTO `$monsters` VALUES (136, 'Leviathan', 255, 225, 190, 46, 1350, 450, 0); 571 INSERT INTO `$monsters` VALUES (137, 'Grey Daemon', 260, 230, 190, 46, 1400, 467, 0); 572 INSERT INTO `$monsters` VALUES (138, 'Succubus', 265, 240, 200, 47, 1460, 487, 1); 573 INSERT INTO `$monsters` VALUES (139, 'Demon Prince', 270, 240, 200, 47, 1520, 507, 0); 574 INSERT INTO `$monsters` VALUES (140, 'Black Dragon', 275, 250, 205, 47, 1580, 527, 1); 575 INSERT INTO `$monsters` VALUES (141, 'Nihilist', 280, 250, 205, 47, 1640, 547, 0); 576 INSERT INTO `$monsters` VALUES (142, 'Behemoth', 285, 260, 210, 48, 1700, 567, 0); 577 INSERT INTO `$monsters` VALUES (143, 'Demagogue', 290, 260, 210, 48, 1760, 587, 0); 578 INSERT INTO `$monsters` VALUES (144, 'Demon Lord', 300, 270, 220, 48, 1820, 607, 0); 579 INSERT INTO `$monsters` VALUES (145, 'Red Daemon', 310, 280, 230, 48, 1880, 627, 0); 580 INSERT INTO `$monsters` VALUES (146, 'Colossus', 320, 300, 240, 49, 1940, 647, 0); 581 INSERT INTO `$monsters` VALUES (147, 'Demon King', 330, 300, 250, 49, 2000, 667, 0); 582 INSERT INTO `$monsters` VALUES (148, 'Dark Daemon', 340, 320, 260, 49, 2200, 733, 1); 583 INSERT INTO `$monsters` VALUES (149, 'Titan', 360, 340, 270, 50, 2400, 800, 0); 584 INSERT INTO `$monsters` VALUES (150, 'Black Daemon', 400, 400, 280, 50, 3000, 1000, 1); 585 INSERT INTO `$monsters` VALUES (151, 'Lucifuge', 600, 600, 400, 50, 10000, 10000, 2); 586 "; 587 if (dobatch($query) == 1) { echo 'La table Monsters a été complétée.<br>'; } else { echo '<span class="alerte">Erreur</span> lorsque la table Monsters a été complétée.<br>'; } 588 unset($query); 589 } 590 591 592 $query = 593 "CREATE TABLE `$news`( 594 `id` int(6) NOT NULL auto_increment, 595 `date` int(11) NOT NULL default '0', 596 `title` VARCHAR(200) NOT NULL default '', 597 `content` VARCHAR(200) NOT NULL default '', 598 `resume` VARCHAR(200) NOT NULL default '', 599 PRIMARY KEY(id) 600 )"; 601 602 if (dobatch($query) == 1) { echo 'La table News a été crée.<br>'; } else { echo '<span class="alerte">Erreur</span> de création de la table News.<br>'; } 603 unset($query); 604 605 $query = " 606 INSERT INTO `$news` VALUES (1, '2008-01-01', 'Bienvenue sur rpg illusion','Ceci est la première news de rpg illusion, utilisez l\'administration pour ajouter une news','RPG illusion est un jeu entièrement gratuit en php. Il est téléchargeable sur le site officiel http://www.rpgillusion.net.'); 607 "; 608 if (dobatch($query) == 1) { echo 'La table News a été complétée.<br>'; } else { echo '<span class="alerte">Erreur</span> lorsque la table News a été complétée.<br>'; } 609 unset($query); 610 611 612 $query = " 613 CREATE TABLE `$partners`( 614 `id` int(6) NOT NULL auto_increment, 615 `name` VARCHAR(200) NOT NULL default '', 616 `url` VARCHAR(200) NOT NULL default '', 617 `button` text NOT NULL default '', 618 `description` VARCHAR(200) NOT NULL default '', 619 PRIMARY KEY(id) 620 )"; 621 622 if (dobatch($query) == 1) { echo 'La table Partners a été crée.<br>'; } else { echo '<span class="alerte">Erreur</span> de création de la table Partners.<br>'; } 623 unset($query); 624 625 $query = " 626 INSERT INTO `$partners` VALUES (1, 'RPG illusion', 'http://www.rpgillusion.net','','Le site officiel de RPG illusion'); 627 "; 628 if (dobatch($query) == 1) { echo 'La table Partners a été complétée.<br>'; } else { echo '<span class="alerte">Erreur</span> lorsque la table Partners a été complétée.<br>'; } 629 unset($query); 630 631 $query = " 632 CREATE TABLE `$poll`( 633 `id` int(6) NOT NULL auto_increment, 634 `question` VARCHAR(200) NOT NULL default '', 635 `answer1` VARCHAR(200) NOT NULL default '', 636 `answer2` VARCHAR(200) NOT NULL default '', 637 `answer3` VARCHAR(200) NOT NULL default '', 638 `answer4` VARCHAR(200) NOT NULL default '', 639 `resultat1` int(6) NOT NULL default '0', 640 `resultat2` int(6) NOT NULL default '0', 641 `resultat3` int(6) NOT NULL default '0', 642 `resultat4` int(6) NOT NULL default '0', 643 644 PRIMARY KEY(id) 645 )"; 646 if (dobatch($query) == 1) { echo 'La table Poll a été crée.<br>'; } else { echo '<span class="alerte">Erreur</span> de création de la table Poll.<br>'; } 647 unset($query); 648 649 if ($full == true) { 650 $query = " 651 INSERT INTO `$poll` VALUES (1, 'Vous trouvez le jeu','Très bien', 'Bien', 'Bof', 'Nul', '0', '0', '0', '0'); 652 "; 653 if (dobatch($query) == 1) { echo 'La table Poll a été complétée.<br>'; } else { echo '<span class="alerte">Erreur</span> lorsque la table Poll a été complétée.<br>'; } 654 unset($query); 655 } 656 657 658 $query = " 659 CREATE TABLE `$poll_ip`( 660 `numero` VARCHAR(10) NOT NULL default '', 661 `ip` VARCHAR(100) NOT NULL default '' 662 )"; 663 if (dobatch($query) == 1) { echo 'La table Poll_ip a été crée.<br>'; } else { echo '<span class="alerte">Erreur</span> de création de la table Poll_ip.<br>'; } 664 unset($query); 665 666 $query = " 667 CREATE TABLE `$spells` ( 668 `id` smallint(5) unsigned NOT NULL auto_increment, 669 `name` varchar(30) NOT NULL default '', 670 `mp` smallint(5) unsigned NOT NULL default '0', 671 `attribute` smallint(5) unsigned NOT NULL default '0', 672 `type` smallint(5) unsigned NOT NULL default '0', 673 PRIMARY KEY (`id`) 674 ) TYPE=MyISAM; 675 "; 676 if (dobatch($query) == 1) { echo 'La table Spells a été crée.<br>'; } else { echo '<span class="alerte">Erreur</span> de création de la table Spells.<br>'; } 677 unset($query); 678 679 if ($full == true) { 680 $query = " 681 INSERT INTO `$spells` VALUES (1, 'Heal', 5, 10, 1); 682 INSERT INTO `$spells` VALUES (2, 'Revive', 10, 25, 1); 683 INSERT INTO `$spells` VALUES (3, 'Life', 25, 50, 1); 684 INSERT INTO `$spells` VALUES (4, 'Breath', 50, 100, 1); 685 INSERT INTO `$spells` VALUES (5, 'Gaia', 75, 150, 1); 686 INSERT INTO `$spells` VALUES (6, 'Hurt', 5, 15, 2); 687 INSERT INTO `$spells` VALUES (7, 'Pain', 12, 35, 2); 688 INSERT INTO `$spells` VALUES (8, 'Maim', 25, 70, 2); 689 INSERT INTO `$spells` VALUES (9, 'Rend', 40, 100, 2); 690 INSERT INTO `$spells` VALUES (10, 'Chaos', 50, 130, 2); 691 INSERT INTO `$spells` VALUES (11, 'Sleep', 10, 5, 3); 692 INSERT INTO `$spells` VALUES (12, 'Dream', 30, 9, 3); 693 INSERT INTO `$spells` VALUES (13, 'Nightmare', 60, 13, 3); 694 INSERT INTO `$spells` VALUES (14, 'Craze', 10, 10, 4); 695 INSERT INTO `$spells` VALUES (15, 'Rage', 20, 25, 4); 696 INSERT INTO `$spells` VALUES (16, 'Fury', 30, 50, 4); 697 INSERT INTO `$spells` VALUES (17, 'Ward', 10, 10, 5); 698 INSERT INTO `$spells` VALUES (18, 'Fend', 20, 25, 5); 699 INSERT INTO `$spells` VALUES (19, 'Barrier', 30, 50, 5); 700 "; 701 if (dobatch($query) == 1) { echo 'La table Spells a été complétée.<br>'; } else { echo '<span class="alerte">Erreur</span> lorsque la table Spells a été complétée.<br>'; } 702 unset($query); 703 } 704 705 $query = " 706 CREATE TABLE `$towns` ( 707 `id` tinyint(3) unsigned NOT NULL auto_increment, 708 `name` varchar(30) NOT NULL default '', 709 `latitude` smallint(6) NOT NULL default '0', 710 `longitude` smallint(6) NOT NULL default '0', 711 `innprice` tinyint(4) NOT NULL default '0', 712 `mapprice` smallint(6) NOT NULL default '0', 713 `travelpoints` smallint(5) unsigned NOT NULL default '0', 714 `itemslist` text NOT NULL, 715 PRIMARY KEY (`id`) 716 ) TYPE=MyISAM; 717 "; 718 if (dobatch($query) == 1) { echo 'La table Towns a été crée.<br>'; } else { echo '<span class="alerte">Erreur</span> de création de la table Towns.<br>'; } 719 unset($query); 720 721 if ($full == true) { 722 $query = " 723 INSERT INTO `$towns` VALUES (1, 'Midworld', 0, 0, 5, 0, 0, '1,2,3,17,18,19,28,29'); 724 INSERT INTO `$towns` VALUES (2, 'Roma', 30, 30, 10, 25, 5, '2,3,4,18,19,29'); 725 INSERT INTO `$towns` VALUES (3, 'Bris', 70, -70, 25, 50, 15, '2,3,4,5,18,19,20,29.30'); 726 INSERT INTO `$towns` VALUES (4, 'Kalle', -100, 100, 40, 100, 30, '5,6,8,10,12,21,22,23,29,30'); 727 INSERT INTO `$towns` VALUES (5, 'Narcissa', -130, -130, 60, 500, 50, '4,7,9,11,13,21,22,23,29,30,31'); 728 INSERT INTO `$towns` VALUES (6, 'Hambry', 170, 170, 90, 1000, 80, '10,11,12,13,14,23,24,30,31'); 729 INSERT INTO `$towns` VALUES (7, 'Gilead', 200, -200, 100, 3000, 110, '12,13,14,15,24,25,26,32'); 730 INSERT INTO `$towns` VALUES (8, 'Endworld', -250, -250, 125, 9000, 160, '16,27,33'); 731 "; 732 if (dobatch($query) == 1) { echo 'La table Towns a été complétée.<br>'; } else { echo '<span class="alerte">Erreur</span> lorsque la table Towns a été complétée.<br>'; } 733 unset($query); 734 } 735 736 737 738 $query = " 739 CREATE TABLE `$users` ( 740 `id` smallint(5) unsigned NOT NULL auto_increment, 741 `username` varchar(30) NOT NULL default '', 742 `password` varchar(32) NOT NULL default '', 743 `email` varchar(100) NOT NULL default '', 744 `verify` varchar(8) NOT NULL default '0', 745 `charname` varchar(30) NOT NULL default '', 746 `regdate` datetime NOT NULL default '00-00-0000 00:00:00', 747 `onlinetime` datetime NOT NULL default '00-00-0000 00:00:00', 748 `authlevel` tinyint(3) unsigned NOT NULL default '0', 749 `latitude` smallint(6) NOT NULL default '0', 750 `longitude` smallint(6) NOT NULL default '0', 751 `difficulty` tinyint(3) unsigned NOT NULL default '0', 752 `avatar` tinyint(4) unsigned NOT NULL default '0', 753 `charclass` tinyint(4) unsigned NOT NULL default '0', 754 `currentaction` varchar(30) NOT NULL default 'En ville', 755 `currentfight` tinyint(4) unsigned NOT NULL default '0', 756 `currentmonster` smallint(6) unsigned NOT NULL default '0', 757 `currentmonsterhp` smallint(6) unsigned NOT NULL default '0', 758 `currentmonstersleep` tinyint(3) unsigned NOT NULL default '0', 759 `currentmonsterimmune` tinyint(4) NOT NULL default '0', 760 `currentuberdamage` tinyint(3) unsigned NOT NULL default '0', 761 `currentuberdefense` tinyint(3) unsigned NOT NULL default '0', 762 `currenthp` smallint(6) unsigned NOT NULL default '15', 763 `currentmp` smallint(6) unsigned NOT NULL default '15', 764 `currenttp` smallint(6) unsigned NOT NULL default '10', 765 `maxhp` smallint(6) unsigned NOT NULL default '15', 766 `maxmp` smallint(6) unsigned NOT NULL default '15', 767 `maxtp` smallint(6) unsigned NOT NULL default '10', 768 `level` smallint(5) unsigned NOT NULL default '1', 769 `gold` mediumint(8) unsigned NOT NULL default '100', 770 `experience` mediumint(8) unsigned NOT NULL default '0', 771 `goldbonus` smallint(5) NOT NULL default '0', 772 `expbonus` smallint(5) NOT NULL default '0', 773 `strength` smallint(5) unsigned NOT NULL default '5', 774 `dexterity` smallint(5) unsigned NOT NULL default '5', 775 `attackpower` smallint(5) unsigned NOT NULL default '5', 776 `defensepower` smallint(5) unsigned NOT NULL default '5', 777 `weaponid` smallint(5) unsigned NOT NULL default '0', 778 `armorid` smallint(5) unsigned NOT NULL default '0', 779 `shieldid` smallint(5) unsigned NOT NULL default '0', 780 `slot1id` smallint(5) unsigned NOT NULL default '0', 781 `slot2id` smallint(5) unsigned NOT NULL default '0', 782 `slot3id` smallint(5) unsigned NOT NULL default '0', 783 `weaponname` varchar(30) NOT NULL default 'Aucun', 784 `armorname` varchar(30) NOT NULL default 'Aucun', 785 `shieldname` varchar(30) NOT NULL default 'Aucun', 786 `slot1name` varchar(30) NOT NULL default 'Aucun', 787 `slot2name` varchar(30) NOT NULL default 'Aucun', 788 `slot3name` varchar(30) NOT NULL default 'Aucun', 789 `dropcode` mediumint(8) unsigned NOT NULL default '0', 790 `spells` varchar(50) NOT NULL default '0', 791 `towns` varchar(50) NOT NULL default '0', 792 PRIMARY KEY (`id`) 793 ) TYPE=MyISAM; 794 "; 795 if (dobatch($query) == 1) { echo 'La table Users a été crée.<br>'; } else { echo '<span class="alerte">Erreur</span> de création de la table Users.<br>'; } 796 unset($query); 797 798 if ($full == true) { 799 $query = " 800 INSERT INTO `$users` VALUES(2, 'Mickael', 'ad0234829205b9033196ba818f7a872b', 'anonyme2@email.com', '1', 'Mickael', '2005-12-06 13:21:23', '2007-10-31 12:36:17', 0, 0, 0, 1, 1, 1, 'En ville', 3, 2, 4, 0, 0, 0, 0, 15, 15, 10, 15, 15, 10, 1, 3585, 0, 210, 0, 5, 5, 15, 225, 19, 17, 0, 0, 0, 0, 'Arc', 'Cobra de Gobi', 'Aucun', 'Aucun', 'Aucun', 'Aucun', 0, '0', '0,8,7,6'); 801 INSERT INTO `$users` VALUES(3, 'Sarah', '27f98a7d253b3bb9ec4703ff4e61bd90', 'anonyme3@email.com', '1', 'Sarah', '2006-07-30 18:58:09', '2006-12-17 01:18:29', 0, 0, 0, 1, 5, 1, 'En ville', 0, 0, 0, 0, 0, 0, 0, 43, 26, 19, 43, 26, 19, 10, 0, 3078, 210, 20, 21, 15, 31, 239, 19, 17, 29, 31, 31, 1, 'Arc', 'Cobra de Gobi', 'Chaussure de randonnée', 'Memory Drop', 'Memory Drop', 'Life Pebble', 0, '0,1', '0,1,2,3,4'); 802 INSERT INTO `$users` VALUES(4, 'Clara', '17946929196fa8db90453ec82d5f52e7', 'anonyme4@email.com', '1', 'Clara', '2005-11-05 19:40:18', '2007-11-09 19:54:13', 0, 0, 0, 3, 4, 2, 'En ville', 7, 13, 24, 0, 1, 0, 0, 938, 15, 1022, 1010, 15, 1022, 41, 501, 190, 630, 0, 5, 5, 5, 224, 18, 17, 29, 1, 0, 0, 'Pierre', 'Cobra', 'Chaussure', 'Life', 'Aucun', 'Aucun', 0, '0', '0,1,13,6'); 803 INSERT INTO `$users` VALUES(5, 'Nicolas', 'e7af287f7d896a07485ff47fed078512', 'anonyme5@email.com', '1', 'Nicolas', '2005-10-06 01:52:42', '2006-02-16 07:22:33', 0, 0, 0, 1, 5, 2, 'En ville', 3, 3, 3, 0, 0, 0, 0, 1, 20, 293, 17, 20, 423, 2, 372, 34, 210, 0, 5, 6, 10, 5, 19, 0, 29, 0, 0, 0, 'Arc', 'Aucun', 'Chaussure', 'Aucun', 'Aucun', 'Aucun', 0, '0,1', '0,5,1,8,7,6,2,3,4'); 804 INSERT INTO `$users` VALUES(6, 'Michelle', 'ad0234829205C9033196ba818f7a872b', 'anonyme6@email.com', '1', 'Michelle', '2005-12-09 13:21:23', '2007-10-31 12:36:17', 0, 0, 0, 1, 4, 1, 'En ville', 1, 0, 0, 0, 0, 0, 0, 15, 15, 15, 15, 15, 215, 1, 1, 0, 0, 0, 0, 0, 19, 81, 2, 28, 29, 0, 0, 0, 'Bilboquet', 'Botte de Stella', 'Chaussure de randonnée', 'Aucun', 'Aucun', 'Aucun', 0, '0', '0'); 805 INSERT INTO `$users` VALUES (7, 'Andrew', 'e7af287f7c896a07485ff47fed078512', 'anonyme7@email.com', '1', 'Andrew', '2005-12-06 01:52:42', '2006-02-16 07:22:33', 0, 0, 0, 1, 5, 1, 'En ville', 3, 3, 3, 0, 0, 0, 0, 1, 20, 293, 17, 20, 423, 2, 372, 34, 210, 0, 5, 6, 10, 5, 19, 0, 29, 0, 0, 0, 'Arc', 'Aucun', 'Chaussure', 'Aucun', 'Aucun', 'Aucun', 0, '0,1', '0,5,1,8,7,6,2,3,4'); 806 "; 807 if (dobatch($query) == 1) { echo 'La table Users a été complétée.<br>'; } else { echo '<span class="alerte">Erreur</span> lorsque la table Users a été complétée.<br>'; } 808 unset($query); 809 } 810 811 812 813 global $start; 814 $time = round((getmicrotime() - $start), 4); 815 echo '<br>Tables Mysql crées en <b>'.$time.'</b> secondes.<br><br><a href="install.php?page=3">Cliquez ici pour poursuivre l\'installation.</a></div></body></html>'; 816 817 } 818 819 function third() { // Troisième page: Récupération des infos du futur admin. 820 821 $page = '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> 822 <html> 823 <head> 824 <title>Installation de RPG illusion : Etape 2</title> 825 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> 826 <link rel="stylesheet" href="styles/css_login.css" type="text/css"> 827 </head> 828 <body> 829 <div><br><span class="mauve1"><b>Installation de RPG illusion: Etape 2</b></span><br><br> 830 Maintenant vous devez créer un compte d\'administrateur ainsi vous pourrez employer le menu d\'administration du jeu. Complétez les champs ci-dessous pour créer votre compte. Vous pourrez modifier vos infos par la suite dans le menu d\'administration.<br><br></div> 831 <form action="install.php?page=4" method="post"> 832 <table width="580" border="0" cellspacing="0" cellpadding="0"> 833 834 <tr valign="top"><td style="width:110px">ID:</td><td><input type="text" name="username" size="30" maxlength="30"><br><br></td></tr> 835 <tr valign="top"><td style="width:110px">PW:</td><td><input type="password" name="password1" size="30" maxlength="30"></td></tr> 836 <tr valign="top"><td style="width:110px">Retapez PW:</td><td><input type="password" name="password2" size="30" maxlength="30"><br><br></td></tr> 837 <tr valign="top"><td style="width:110px">Votre Email:</td><td><input type="text" name="email1" size="30" maxlength="100"></td></tr> 838 <tr valign="top"><td style="width:110px">Retapez Email:</td><td><input type="text" name="email2" size="30" maxlength="100"><br><br></td></tr> 839 <tr valign="top"><td style="width:110px">Nom du perso:</td><td><input type="text" name="charname" size="30" maxlength="30"><br><br></td></tr> 840 <tr valign="top"><td style="width:110px">Avatar du perso:</td><td><select name="avatar"><option value="1">numéro 1</option><option value="2">numéro 2</option><option value="3">numéro 3</option><option value="4">numéro 4</option><option value="5">numéro 5</option><option value="6">numéro 6</option><option value="7">numéro 7</option><option value="8">numéro 8</option><option value="9">numéro 9</option><option value="10">numéro 10</option></select><br>Pour voir tous les avatars <a href="#" onClick="window.open(\'avatars.php\',\'_blank\',\'toolbar=0, location=0, directories=0, status=0, scrollbars=0, resizable=0, copyhistory=0, menuBar=0, width=400, height=265\');return(false)">cliquez ici.</a><br><br></td></tr> 841 <tr valign="top"><td style="width:110px">Classe du perso:</td><td><select name="charclass" ><option value="1">Mage</option><option value="2">Guerrier</option><option value="3">Paladin</option></select><br><br></td></tr> 842 <tr valign="top"><td style="width:110px">Difficultée:</td><td><select name="difficulty"><option value="1">Facile</option><option value="2">Moyen</option><option value="3">Dur</option></select><br><br></td></tr> 843 <tr valign="top"><td style="width:1px"></td><td> 844 845 <div><input type="submit" name="submit" value="Valider"> <input type="button" value="Retour" OnClick="javascript:location=\'index.php\'"/></div></td></tr> 846 </table> 847 </form> 848 </body> 849 </html> 850 '; 851 852 echo $page; 853 854 } 855 856 function fourth() { // Page final : inserer un nouveau utilisateur, et le féliciter en cas de réussite. 857 858 extract($_POST); 859 if (!isset($username)) { die('L\'ID doit être renseigné.'); } 860 if (!isset($password1)) { die('Le PW doit être renseigné.'); } 861 if (!isset($password2)) { die('Retapez PW doit être renseigné.'); } 862 if ($password1 != $password2) { die('Les PW ne correspondent pas.'); } 863 if (!isset($email1)) { die('L\'Email doit être renseigné.'); } 864 if (!isset($email2)) { die('Retapez Email doit être renseigné.'); } 865 if ($email1 != $email2) { die('Les Emails ne correspondent pas.'); } 866 if (!isset($charname)) { die('Le Nom du perso doit être renseigné.'); } 867 $password = md5($password1); 868 869 global $dbsettings; 870 $users = $dbsettings["prefix"] . "_users"; 871 $query = mysql_query("INSERT INTO $users SET id='1',username='$username',password='$password',email='$email1',verify='1',charname='$charname',charclass='$charclass',avatar='$avatar',regdate=NOW(),onlinetime=NOW(),authlevel='1'") or die(mysql_error()); 872 873 $page = '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> 874 <html> 875 <head> 876 <title>Installation de RPG illusion : Etape 2</title> 877 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> 878 <link rel="stylesheet" href="styles/css_login.css" type="text/css"> 879 </head> 880 <body> 881 <div><br><span class="mauve1"><b>Installation de RPG illusion: Etape 2</b></span><br><br> 882 Votre compte d\'administrateur a été crée avec succès. l\'installation est terminée.<br><br> 883 Pour des raisons de sécurité, vous devrez éffacer le fichier install.php pour continuer<br><br> 884 Vous être maintenant prêt à <a href="index.php">jouer au jeu</a>. Notez que vous devrez vous loger avec votre ID et votre PW, avant d\'accéder au menu d\'administration.<br><br/> 885 Merci d\'utiliser RPG illusion<br><br><br><br> 886 <b>Optionel:</b> Une option vous permet de prevenir l\'auteur de RPG illusion que vous avez installer son jeu. Pour utiliser cette option, 887 <a href="install.php?page=5">cliquez ici</a>.</div> 888 </body> 889 </html>'; 890 891 echo $page; 892 893 } 894 895 function fifth() { // Appelle de l'auteur de jeu. 896 897 $url = "http://".$_SERVER["SERVER_NAME"].$_SERVER["PHP_SELF"]; 898 if (mail("ffstory1@hotmail.com", "", "$url") != true) { die('L\'ajout de votre URL a échouée, vous pouvez recommencer ou terminer l\'installation <a href="index.php">du jeu</a>.'); } 899 900 $page = '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> 901 <html> 902 <head> 903 <title>Installation de RPG illusion : Etape 2</title> 904 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> 905 <link rel="stylesheet" href="styles/css_login.css" type="text/css"> 906 </head> 907 <body> 908 <div><br><span class="mauve1"><b>Installation de RPG illusion: Etape 2</b></span><br><br> 909 Merci de votre contribution <br><br> 910 Vous desormais <a href="index.php">jouer au jeu</a>. Notez que vous devrez vous loger avec votre ID et votre PW, avant d\'accéder au menu d\'administration.</div> 911 </body> 912 </html>'; 913 914 echo $page; 915 916 } 917 918 ?>