for ($i = 0; $i < $linear_results_count; $i++) {
// Replace spaces with +'s for url link
print "<li><a href =\"augment_search.php?search_term=" . preg_replace('/\\s+/', '+', $linear_results[$i]) . "\">" . $linear_results[$i] . "</a></li>";
}
print "</ul></div>";
}
die;
}
// Put all the augment's data in its own array
$augment_data = array();
for ($i = 0; $i < 6; $i++) {
$augment_data[$i] = $augment_raw_data[$i][$search_result];
}
// Search succeeded, time to get the rest of the data about the augment
$bestiary_data = get_bestiary_data($con, $augment_raw_data[2][$search_result], $augment_raw_data[3][$search_result], $augment_raw_data[4][$search_result]);
$frontiernav_data = get_frontiernav_data($con, $augment_data[5]);
print "<div class=\"box\">\n <p>\n <center><h3>Results for " . $augment_data[0] . "</h3></center>\n <br/>\n <br/>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <b>Augment Name</b>\n <td/>\n <td>\n <b>Effect</b>\n <td/>\n <td>\n <b>Material 1</b>\n <td/>\n <td>\n <b>Material 2</b>\n <td/>\n <td>\n <b>Material 3</b>\n <td/>\n <td>\n <b>Precious Resource</b>\n <td/>\n </tr>\n \n <tr>\n <td>" . $augment_data[0] . "<td/>\n <td>" . $augment_data[1] . "<td/>\n <td>" . $augment_data[2] . "<td/>\n <td>" . $augment_data[3] . "<td/>\n <td>" . $augment_data[4] . "<td/>\n <td>" . $augment_data[5] . "<td/>\n </tr>\n \n </table>\n \n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2><a href=\"material_search.php?search_term=" . preg_replace('/\\s+/', '+', trim(preg_replace('/[0-9]+/', '', $augment_data[2]))) . "\" target=\"_blank\">" . trim(preg_replace('/[0-9]+/', '', $augment_data[2])) . "</a></h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>";
print print_bestiary_table_head();
print print_bestiary_table($bestiary_data, 0);
print "</p>\n \n <p>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2><a href=\"material_search.php?search_term=" . preg_replace('/\\s+/', '+', trim(preg_replace('/[0-9]+/', '', $augment_data[3]))) . "\" target=\"_blank\">" . trim(preg_replace('/[0-9]+/', '', $augment_data[3])) . "</a></h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>";
print print_bestiary_table_head();
print print_bestiary_table($bestiary_data, 1);
print "</p>\n \n <p>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2><a href=\"material_search.php?search_term=" . preg_replace('/\\s+/', '+', trim(preg_replace('/[0-9]+/', '', $augment_data[4]))) . "\" target=\"_blank\">" . trim(preg_replace('/[0-9]+/', '', $augment_data[4])) . "</a></h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>";
print print_bestiary_table_head();
print print_bestiary_table($bestiary_data, 2);
print "</p>\n \n <p>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2>" . trim(preg_replace('/[0-9]+/', '', $augment_data[5])) . "</h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>\n <tr>\n <td>\n <b>FN Site: </b>\n <td/>\n <td>\n <b>Mining: </b>\n <td/>\n <td>\n <b>Research: </b>\n <td/>\n <td>\n <b>Battle: </b>\n <td/>\n <td>\n <b>Tourist Spots: </b>\n <td/>\n <td>\n <b>Rare Resources: </b>\n <td/>\n <td>\n <b>Connections: </b>\n <td/>\n </tr>";
print print_frontiernav_table($frontiernav_data);
}
?>
</p>
for ($i = 0; $i < $linear_results_count; $i++) {
// Replace spaces with +'s for url link
print "<li><a href =\"skell_frame_list.php?frame=" . preg_replace('/\\s+/', '+', $linear_results[$i]) . "\">" . $linear_results[$i] . "</a></li>";
}
print "</ul></div>";
}
die;
}
// Put all the frame's data in its own array
$skell_frame_data = array();
for ($i = 0; $i < 24; $i++) {
$skell_frame_data[$i] = $skell_frame_raw_data[$i][$search_result];
}
// Search succeeded, time to get the rest of the data about the augment
$bestiary_data = get_skell_frame_bestiary_data($con, $skell_frame_raw_data[17][$search_result], $skell_frame_raw_data[18][$search_result], $skell_frame_raw_data[19][$search_result], $skell_frame_raw_data[20][$search_result], $skell_frame_raw_data[21][$search_result], $skell_frame_raw_data[22][$search_result]);
$frontiernav_data = get_frontiernav_data($con, $skell_frame_data[23]);
print "<div class=\"box\">\n <p>\n <center><h3>Results for " . $skell_frame_data[0] . "</h3></center>\n <br/>\n <br/>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <b>Frame Name</b>\n <td/>\n <td>\n <b>Frame Type</b>\n <td/>\n <td>\n <b>Required Miranium</b>\n <td/>\n <td>\n <b>Armor Battle Traits</b>\n <td/>\n <td>\n <b>Material 1</b>\n <td/>\n <td>\n <b>Material 2</b>\n <td/>\n <td>\n <b>Material 3</b>\n <td/>\n <td>\n <b>Material 4</b>\n <td/>\n <td>\n <b>Material 5</b>\n <td/>\n <td>\n <b>Material 6</b>\n <td/>\n <td>\n <b>Rare Resource</b>\n <td/>\n </tr>";
print print_skell_frame_result($skell_frame_data);
print "\n </table>\n <hr/>";
print "<h3>Stats</h3>";
print print_skell_frame_stats($skell_frame_data);
print "<hr/>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2><a href=\"material_search.php?search_term=" . preg_replace('/\\s+/', '+', trim(preg_replace('/[0-9]+/', '', $skell_frame_data[17]))) . "\" target=\"_blank\">" . trim(preg_replace('/[0-9]+/', '', $skell_frame_data[17])) . "</a></h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>";
print print_bestiary_table_head();
print print_bestiary_table($bestiary_data, 0);
print "</p>\n \n <p>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2><a href=\"material_search.php?search_term=" . preg_replace('/\\s+/', '+', trim(preg_replace('/[0-9]+/', '', $skell_frame_data[18]))) . "\" target=\"_blank\">" . trim(preg_replace('/[0-9]+/', '', $skell_frame_data[18])) . "</a></h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>";
print print_bestiary_table_head();
print print_bestiary_table($bestiary_data, 1);
print "</p>\n \n <p>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2><a href=\"material_search.php?search_term=" . preg_replace('/\\s+/', '+', trim(preg_replace('/[0-9]+/', '', $skell_frame_data[19]))) . "\" target=\"_blank\">" . trim(preg_replace('/[0-9]+/', '', $skell_frame_data[19])) . "</a></h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>";
print print_bestiary_table_head();
print print_bestiary_table($bestiary_data, 2);
print "</p>\n \n <p>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2><a href=\"material_search.php?search_term=" . preg_replace('/\\s+/', '+', trim(preg_replace('/[0-9]+/', '', $skell_frame_data[20]))) . "\" target=\"_blank\">" . trim(preg_replace('/[0-9]+/', '', $skell_frame_data[20])) . "</a></h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>";
for ($i = 0; $i < $linear_results_count; $i++) {
// Replace spaces with +'s for url link
print "<li><a href =\"ground_gear_list.php?gear=" . preg_replace('/\\s+/', '+', $linear_results[$i]) . "\">" . $linear_results[$i] . "</a></li>";
}
print "</ul></div>";
}
die;
}
// Put all the gear's data in its own array
$ground_gear_data = array();
for ($i = 0; $i < 15; $i++) {
$ground_gear_data[$i] = $ground_gear_raw_data[$i][$search_result];
}
// Search succeeded, time to get the rest of the data about the augment
$bestiary_data = get_gear_bestiary_data($con, $ground_gear_raw_data[8][$search_result], $ground_gear_raw_data[9][$search_result], $ground_gear_raw_data[10][$search_result], $ground_gear_raw_data[11][$search_result], $ground_gear_raw_data[12][$search_result], $ground_gear_raw_data[13][$search_result]);
$frontiernav_data = get_frontiernav_data($con, $ground_gear_data[14]);
print "<div class=\"box\">\n <p>\n <center><h3>Results for " . $ground_gear_data[0] . "</h3></center>\n <br/>\n <br/>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <b>Gear Name</b>\n <td/>\n <td>\n <b>Gear Slot</b>\n <td/>\n <td>\n <b>Maker</b>\n <td/>\n <td>\n <b>Level</b>\n <td/>\n <td>\n <b>Defense</b>\n <td/>\n <td>\n <b>Battle Traits</b>\n <td/>\n <td>\n <b>Upgrades</b>\n <td/>\n <td>\n <b>Resistances</b>\n <td/>\n <td>\n <b>Material 1</b>\n <td/>\n <td>\n <b>Material 2</b>\n <td/>\n <td>\n <b>Material 3</b>\n <td/>\n <td>\n <b>Material 4</b>\n <td/>\n <td>\n <b>Material 5</b>\n <td/>\n <td>\n <b>Material 6</b>\n <td/>\n <td>\n <b>Rare Resource</b>\n <td/>\n </tr>";
print print_ground_gear_result($ground_gear_data);
print "\n </table>\n \n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2><a href=\"material_search.php?search_term=" . preg_replace('/\\s+/', '+', trim(preg_replace('/[0-9]+/', '', $ground_gear_data[8]))) . "\" target=\"_blank\">" . trim(preg_replace('/[0-9]+/', '', $ground_gear_data[8])) . "</a></h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>";
print print_bestiary_table_head();
print print_bestiary_table($bestiary_data, 0);
print "</p>\n \n <p>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2><a href=\"material_search.php?search_term=" . preg_replace('/\\s+/', '+', trim(preg_replace('/[0-9]+/', '', $ground_gear_data[9]))) . "\" target=\"_blank\">" . trim(preg_replace('/[0-9]+/', '', $ground_gear_data[9])) . "</a></h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>";
print print_bestiary_table_head();
print print_bestiary_table($bestiary_data, 1);
print "</p>\n \n <p>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2><a href=\"material_search.php?search_term=" . preg_replace('/\\s+/', '+', trim(preg_replace('/[0-9]+/', '', $ground_gear_data[10]))) . "\" target=\"_blank\">" . trim(preg_replace('/[0-9]+/', '', $ground_gear_data[10])) . "</a></h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>";
print print_bestiary_table_head();
print print_bestiary_table($bestiary_data, 2);
print "</p>\n \n <p>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2><a href=\"material_search.php?search_term=" . preg_replace('/\\s+/', '+', trim(preg_replace('/[0-9]+/', '', $ground_gear_data[11]))) . "\" target=\"_blank\">" . trim(preg_replace('/[0-9]+/', '', $ground_gear_data[11])) . "</a></h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>";
print print_bestiary_table_head();
print print_bestiary_table($bestiary_data, 3);
print "</p>\n \n <p>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2><a href=\"material_search.php?search_term=" . preg_replace('/\\s+/', '+', trim(preg_replace('/[0-9]+/', '', $ground_gear_data[12]))) . "\" target=\"_blank\">" . trim(preg_replace('/[0-9]+/', '', $ground_gear_data[12])) . "</a></h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>";
for ($i = 0; $i < $linear_results_count; $i++) {
// Replace spaces with +'s for url link
print "<li><a href =\"superweapon_list.php?superweapon=" . preg_replace('/\\s+/', '+', $linear_results[$i]) . "\">" . $linear_results[$i] . "</a></li>";
}
print "</ul></div>";
}
die;
}
// Put all the gear's data in its own array
$superweapons_data = array();
for ($i = 0; $i < 14; $i++) {
$superweapons_data[$i] = $superweapons_raw_data[$i][$search_result];
}
// Search succeeded, time to get the rest of the data about the augment
$bestiary_data = get_superweapon_bestiary_data($con, $superweapons_raw_data[9][$search_result], $superweapons_raw_data[10][$search_result], $superweapons_raw_data[11][$search_result], $superweapons_raw_data[12][$search_result]);
$frontiernav_data = get_frontiernav_data($con, $superweapons_data[13]);
print "<div class=\"box\">\n <p>\n <center><h3>Results for " . $superweapons_data[0] . "</h3></center>\n <br/>\n <br/>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <b>Weapon Name</b>\n <td/>\n <td>\n <b>Slot</b>\n <td/>\n <td>\n <b>Lv</b>\n <td/>\n <td>\n <b>Force</b>\n <td/>\n <td>\n <b>Ammo</b>\n <td/>\n <td>\n <b>Hits</b>\n <td/>\n <td>\n <b>Fuel</b>\n <td/>\n <td>\n <b>Attribute</b>\n <td/>\n <td>\n <b>Battle Traits</b>\n <td/>\n <td>\n <b>Material 1</b>\n <td/>\n <td>\n <b>Material 2</b>\n <td/>\n <td>\n <b>Material 3</b>\n <td/>\n <td>\n <b>Material 4</b>\n <td/>\n <td>\n <b>Rare Resource</b>\n <td/>\n </tr>";
print print_superweapons_result($superweapons_data);
print "\n </table>\n \n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2><a href=\"material_search.php?search_term=" . preg_replace('/\\s+/', '+', trim(preg_replace('/[0-9]+/', '', $superweapons_data[9]))) . "\" target=\"_blank\">" . trim(preg_replace('/[0-9]+/', '', $superweapons_data[9])) . "</a></h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>";
print print_bestiary_table_head();
print print_bestiary_table($bestiary_data, 0);
print "</p>\n \n <p>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2><a href=\"material_search.php?search_term=" . preg_replace('/\\s+/', '+', trim(preg_replace('/[0-9]+/', '', $superweapons_data[10]))) . "\" target=\"_blank\">" . trim(preg_replace('/[0-9]+/', '', $superweapons_data[10])) . "</a></h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>";
print print_bestiary_table_head();
print print_bestiary_table($bestiary_data, 1);
print "</p>\n \n <p>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2><a href=\"material_search.php?search_term=" . preg_replace('/\\s+/', '+', trim(preg_replace('/[0-9]+/', '', $superweapons_data[11]))) . "\" target=\"_blank\">" . trim(preg_replace('/[0-9]+/', '', $superweapons_data[11])) . "</a></h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>";
print print_bestiary_table_head();
print print_bestiary_table($bestiary_data, 2);
print "</p>\n \n <p>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2><a href=\"material_search.php?search_term=" . preg_replace('/\\s+/', '+', trim(preg_replace('/[0-9]+/', '', $superweapons_data[12]))) . "\" target=\"_blank\">" . trim(preg_replace('/[0-9]+/', '', $superweapons_data[12])) . "</a></h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>";
print print_bestiary_table_head();
print print_bestiary_table($bestiary_data, 3);
print "</p>\n \n <p>\n <table class=\"resultsTable\">\n <tr>\n <td>\n <h2>" . trim(preg_replace('/[0-9]+/', '', $superweapons_data[13])) . "</h2>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n <td>\n <p></p>\n <td/>\n </tr>\n <tr>\n <td>\n <b>FN Site: </b>\n <td/>\n <td>\n <b>Mining: </b>\n <td/>\n <td>\n <b>Research: </b>\n <td/>\n <td>\n <b>Battle: </b>\n <td/>\n <td>\n <b>Tourist Spots: </b>\n <td/>\n <td>\n <b>Rare Resources: </b>\n <td/>\n <td>\n <b>Connections: </b>\n <td/>\n </tr>";
