function get_bestiary_data($database_connection, $mat0, $mat1, $mat2) { $mat0 = trim(preg_replace('/[0-9]+/', '', $mat0)); $mat1 = trim(preg_replace('/[0-9]+/', '', $mat1)); $mat2 = trim(preg_replace('/[0-9]+/', '', $mat2)); /* This returns all the enemies in one lump, but we want to sort them by materials * So, we use the get_enemy_materials function and supply materials one by one $result = mysqli_query($database_connection, "SELECT * FROM `Bestiary` WHERE `Bestiary`.`Drops0` ='" . $mat0 . "' OR `Bestiary`.`Drops0` ='" . $mat1 . "'OR `Bestiary`.`Drops0` ='" . $mat2 . "' OR `Bestiary`.`Drops1` ='" . $mat0 . "' OR `Bestiary`.`Drops1` ='" . $mat1 . "'OR `Bestiary`.`Drops1` ='" . $mat2 . "' OR `Bestiary`.`Drops2` ='" . $mat0 . "' OR `Bestiary`.`Drops2` ='" . $mat1 . "'OR `Bestiary`.`Drops2` ='" . $mat2 . "' OR `Bestiary`.`Drops3` ='" . $mat0 . "' OR `Bestiary`.`Drops3` ='" . $mat1 . "'OR `Bestiary`.`Drops3` ='" . $mat2 . "' OR `Bestiary`.`Drops4` ='" . $mat0 . "' OR `Bestiary`.`Drops4` ='" . $mat1 . "'OR `Bestiary`.`Drops4` ='" . $mat2 . "' OR `Bestiary`.`Drops5` ='" . $mat0 . "' OR `Bestiary`.`Drops5` ='" . $mat1 . "'OR `Bestiary`.`Drops5` ='" . $mat2 . "' OR `Bestiary`.`Drops6` ='" . $mat0 . "' OR `Bestiary`.`Drops6` ='" . $mat1 . "'OR `Bestiary`.`Drops6` ='" . $mat2 . "';"); */ $mat0_data = array(); $mat0_data = get_enemy_material($database_connection, $mat0); $mat1_data = array(); $mat1_data = get_enemy_material($database_connection, $mat1); $mat2_data = array(); $mat2_data = get_enemy_material($database_connection, $mat2); // 3D array?! $results = array(); $results[0] = $mat0_data; $results[1] = $mat1_data; $results[2] = $mat2_data; return $results; }
function get_skell_frame_bestiary_data($database_connection, $mat0, $mat1, $mat2, $mat3, $mat4, $mat5) { $mat0 = trim(preg_replace('/[0-9]+/', '', $mat0)); $mat1 = trim(preg_replace('/[0-9]+/', '', $mat1)); $mat2 = trim(preg_replace('/[0-9]+/', '', $mat2)); $mat3 = trim(preg_replace('/[0-9]+/', '', $mat3)); $mat4 = trim(preg_replace('/[0-9]+/', '', $mat4)); $mat5 = trim(preg_replace('/[0-9]+/', '', $mat5)); $mat0_data = array(); $mat0_data = get_enemy_material($database_connection, $mat0); $mat1_data = array(); $mat1_data = get_enemy_material($database_connection, $mat1); $mat2_data = array(); $mat2_data = get_enemy_material($database_connection, $mat2); $mat3_data = array(); $mat3_data = get_enemy_material($database_connection, $mat3); $mat4_data = array(); $mat4_data = get_enemy_material($database_connection, $mat4); $mat5_data = array(); $mat5_data = get_enemy_material($database_connection, $mat5); // 3D array?! $results = array(); $results[0] = $mat0_data; $results[1] = $mat1_data; $results[2] = $mat2_data; $results[3] = $mat3_data; $results[4] = $mat4_data; $results[5] = $mat5_data; return $results; }