if (strlen($rowName) > 0) {
$return['environ'][] = $rowName;
}
}
$stmt->close();
$stmt = $mysqli->prepare("SELECT CM.name FROM mm_creatures CB\n\t\t\t\t\t\t\t\t\t\t INNER JOIN mm_minions M ON CB.id = M.boss_id\n\t\t\t\t\t\t\t\t\t\t INNER JOIN mm_creatures CM ON M.minion_id = CM.id\n\t\t\t\t\t\t\t\t\t\t WHERE CB.name = ?");
$stmt->bind_param("s", $name);
$stmt->execute();
$stmt->bind_result($rowName);
while ($stmt->fetch()) {
if (strlen($rowName) > 0) {
$return['minion'][] = "<a href='MonsterDisplay.html?name=" . $rowName . "'>" . $rowName . "</a>";
}
}
$stmt->close();
$stmt = $mysqli->prepare("\tSELECT CB.name\n\t\t\t\t\t\t\t\t\t\tFROM mm_creatures CB\n\t\t\t\t\t\t\t\t\t\tINNER JOIN mm_minions M ON CB.id = M.boss_id\n\t\t\t\t\t\t\t\t\t\tWHERE M.minion_id = (SELECT id FROM mm_creatures WHERE name = ?)");
$stmt->bind_param("s", $name);
$stmt->execute();
$stmt->bind_result($rowName);
while ($stmt->fetch()) {
if (strlen($rowName) > 0) {
$return['bosses'][] = "<a href='MonsterDisplay.html?name=" . $rowName . "'>" . $rowName . "</a>";
}
}
$stmt->close();
return json_encode($return);
}
}
$ajaxRequest = new ajaxRequest();
echo $ajaxRequest->requestLists();
