/** * */ function takeover_getBidding($caveCount = 0) { global $db; // prepare query $sql = $db->prepare("SELECT * FROM " . CAVE_TAKEOVER_TABLE . " WHERE playerID = :playerID"); $sql->bindValue('playerID', $_SESSION['player']->playerID, PDO::PARAM_INT); // return NULL on error or if recordSet is empty, as there is no bidding if (!$sql->execute()) { return NULL; } // fetch row $row = $sql->fetch(); if (!$row) { return NULL; } // fill return value $bidding = array('caveID' => $row['caveID'], 'xCoord' => $row['xCoord'], 'yCoord' => $row['yCoord'], 'status' => $row['status'], 'caveName' => $row['name'], 'uh_caveName' => unhtmlentities($row['name'])); // get own status $bidding += takeover_getStatusPic($row['status']); // get sent resources $sum = 0; $resources = array(); foreach ($GLOBALS['resourceTypeList'] as $resource) { $amount = $row[$resource->dbFieldName]; if ($amount > 0) { $resources[] = array('name' => $resource->name, 'value' => $amount); $sum += $amount * $resource->takeoverValue; } } // merge $resources with bidding if (sizeof($resources)) { $bidding['resource'] = $resources; $bidding['sum'] = $sum; $bidding['proportion'] = $sum > 0 && $caveCount > 0 ? round($sum / (200 * pow($caveCount, 2)), 3) : 0; } // get other bidders $bidders = array(); $sql = $db->prepare("SELECT p.name, p.playerID, ct.status \n FROM " . CAVE_TAKEOVER_TABLE . " ct, Player p \n WHERE caveID = :caveID AND ct.playerID = p.playerID \n AND ct.playerID != :playerID"); $sql->bindValue('caveID', $row['caveID'], PDO::PARAM_INT); $sql->bindValue('playerID', $_SESSION['player']->playerID, PDO::PARAM_INT); if ($sql->execute()) { while ($row = $sql->fetch()) { $temp = array('playername' => $row['name'], 'playerID' => $row['playerID']); $temp += takeover_getStatusPic($row['status']); $bidders[] = $temp; } } // merge $bidders with bidding if (sizeof($bidders)) { $bidding['bidder'] = $bidders; } return $bidding; }
/** * */ function takeover_getBidding() { global $db, $params, $resourceTypeList; // prepare query $query = sprintf('SELECT * FROM Cave_takeover WHERE playerID = %d', $params->SESSION->player->playerID); // execute query $result = $db->query($query); // return NULL on error or if recordSet is empty, as there is no bidding if (!$result || $result->isEmpty()) { return NULL; } // fetch row $row = $result->nextrow(); // fill return value $bidding = array('caveID' => $row['caveID'], 'xCoord' => $row['xCoord'], 'yCoord' => $row['yCoord'], 'status' => $row['status'], 'caveName' => $row['name'], 'uh_caveName' => unhtmlentities($row['name'])); // get own status $bidding += takeover_getStatusPic($row['status']); // get sent resources $sum = 0; $resources = array(); foreach ($resourceTypeList as $resource) { $amount = $row[$resource->dbFieldName]; if ($amount > 0) { $resources[] = array('name' => $resource->name, 'value' => $amount); $sum += $amount * $resource->takeoverValue; } } // merge $resources with bidding if (sizeof($resources)) { $bidding['RESOURCE'] = $resources; $bidding['SUM'] = array('sum' => $sum); } else { $bidding['NONE'] = array('iterate' => ''); } // get other bidders $bidders = array(); $query = sprintf('SELECT p.name, p.playerID, ct.status ' . 'FROM Cave_takeover ct, Player p ' . 'WHERE caveID = %d AND ct.playerID = p.playerID ' . 'AND ct.playerID != %d', $row['caveID'], $params->SESSION->player->playerID); $result = $db->query($query); if ($result) { while ($row = $result->nextrow()) { $temp = array('playername' => $row['name'], 'playerID' => $row['playerID']); $temp += takeover_getStatusPic($row['status']); $bidders[] = $temp; } } // merge $bidders with bidding if (sizeof($bidders)) { $bidding['BIDDER'] = $bidders; } else { $bidding['NOONE'] = array('iterate' => ''); } return $bidding; }