$sql = "SELECT * FROM orbs WHERE id = '{$oid}'";
$result = $db->query($sql);
$orb = $db->fetch_array($result);
$orb["uses"] = rand($orb["min_uses"], $orb["max_uses"]);
$sql = "INSERT INTO accorbs (account, orb, uses) VALUES ('{$acc['id']}', '{$oid}', '{$orb['uses']}')";
$result = $db->query($sql);
$orb["id"] = $db->insert_id();
$amount = rand($orb["min_gems"], $orb["max_gems"]);
// select all gems by rarity
$signs = array();
$totalchance = 0.0;
$sql = "SELECT id, rarity, type FROM signs ORDER BY type ASC, rarity ASC";
$nresult = $db->query($sql);
while ($row = $db->fetch_array($nresult)) {
// get rarity multiplier
$raritymultiplier = gGetRarityMultiplier($row["type"], $row["rarity"]);
// set chance
$row["chance"] = $orb["rarity_mod"] + (1 - $orb["rarity_mod"]) * (1 / $raritymultiplier);
// update total chance
$totalchance += $row["chance"];
// add to sign list
$signs[] = $row;
}
// pick random signs
$picked = array();
while ($amount > 0) {
// random pick
$pick = rand() / getrandmax() * $totalchance;
// get sign
$prev = 0.0;
$signid = 0;
$result = $db->query($sql);
$numrows = $db->num_rows($result);
if ($numrows == 0) {
echo 'Unfortunately, you do not have any gems.<br>';
} else {
echo 'Select a gem from the list to give it to him.<br><br>';
}
$array = array();
while ($row = $db->fetch_array($result)) {
$raritymultiplier = gGetRarityMultiplier($row["signtype"], $row["rarity"]) * $gdGemTypeMultiplier[$row["signtype"]];
$row["power"] = round($row["glevel"] * gdRudolfPowerMultiplier * $gdGemQuality[$row["quality"]]["value"] * $raritymultiplier);
$array[] = $row;
}
$array = gSortArray($array, "power", "DESC");
foreach ($array as $row) {
$raritymultiplier = gGetRarityMultiplier($row["signtype"], $row["rarity"]) * $gdGemTypeMultiplier[$row["signtype"]];
$resources = round($row["glevel"] * gdRudolfResourceMultiplier * $gdGemQuality[$row["quality"]]["value"] * $raritymultiplier);
echo '<a href="index.php?page=travel&action=rudolf&gid=', $row["gid"], '">', gEchoGem($row), ' (gain ', $row["power"], ' power, pay ', $resources, ' brimstone, ', $resources, ' crystal, ', $resources, ' essence and ', $resources, ' granite).</a><br>';
}
}
if ($encounter == 2) {
echo '
You encounter ', $gdEncounters[$encounter][0], '!!!<br>
Run, run, run!<br>
';
$sql = "UPDATE accounts SET x = '1337', y = '1337' WHERE id = '{$acc['id']}'";
$result = $db->query($sql);
$acc["x"] = 1337;
$acc["y"] = 1337;
}
if ($encounter == 3) {
