33 lines
717 B
PHP
33 lines
717 B
PHP
<?php
|
|
|
|
class beta5_sale_getPlanetSale {
|
|
var $index = array();
|
|
|
|
|
|
function beta5_sale_getPlanetSale($lib) {
|
|
$this->lib = $lib;
|
|
$this->db = $this->lib->game->db;
|
|
}
|
|
|
|
|
|
function run($id) {
|
|
$q = $this->db->query("SELECT id,expires,finalized,sold_to FROM sale WHERE planet=$id");
|
|
if (!($q && dbCount($q))) {
|
|
return null;
|
|
}
|
|
$r = dbFetchHash($q);
|
|
|
|
$q = $this->db->query("SELECT price FROM public_offer WHERE offer=".$r['id']);
|
|
if ($q && dbCount($q)) {
|
|
$r['public'] = true;
|
|
list($r['price']) = dbFetchArray($q);
|
|
return $r;
|
|
}
|
|
|
|
$q = $this->db->query("SELECT price,to_player FROM private_offer WHERE offer=".$r['id']);
|
|
list($r['price'],$r['sold_to']) = dbFetchArray($q);
|
|
return $r;
|
|
}
|
|
}
|
|
|
|
?>
|