/**
* (non-PHPdoc)
* @see lib/Recipe/Database/Recipe_Database_Table#getSelect()
*/
public function getSelect()
{
$select = parent::getSelect();
$select->join(array("g" => "galaxy"), array("p" => "planetid", "g" => "planetid"))->join(array("gm" => "galaxy"), array("p" => "planetid", "gm" => "moonid"))->join(array("u" => "user"), array("u" => "userid", "p" => "userid"));
$select->attributes(array("p" => array("planetid", "planetname", "userid", "ismoon", "picture", "temperature", "diameter", "last", "metal", "silicon", "hydrogen", "solar_satellite_prod"), "u" => array("username"), "IFNULL(g.`galaxy`, gm.`galaxy`) AS galaxy", "IFNULL(g.`system`, gm.`system`) AS system", "IFNULL(g.`position`, gm.`position`) AS position"));
return $select;
}
/**
* (non-PHPdoc)
* @see lib/Recipe/Database/Recipe_Database_Table#getSelect()
*/
public function getSelect()
{
$select = parent::getSelect();
$select->join(array("p" => "planet"), array("p" => "planetid", "g" => "planetid"));
$select->attributes(array("g" => array("metal", "silicon"), "p" => array("userid")));
return $select;
}
/**
* Retrieves a raw select object for the table.
*
* @return Recipe_Database_Select
*/
public function getSelect()
{
$select = parent::getSelect();
$select->attributes(array("n" => array("title", "text", "user_id", "time"), "u" => array("username", "userid")));
$select->join(array("u" => "user"), array("u" => "userid", "n" => "user_id"));
return $select;
}
/**
* Retrieves a raw select object for the table.
*
* @return Recipe_Database_Select
*/
public function getSelect()
{
$select = parent::getSelect();
$select->join(array("p" => "planet"), array("p" => "planetid", "a" => "planetid"))->join(array("g" => "galaxy"), "a.planetid = g.planetid OR a.planetid = g.moonid");
$select->attributes(array("a" => array(new Recipe_Database_Expr("*")), "g" => array("galaxy", "system", "position"), "p" => array("planetname")));
return $select;
}
/**
* (non-PHPdoc)
* @see lib/Recipe/Database/Recipe_Database_Table#getSelect()
*/
public function getSelect()
{
$select = parent::getSelect();
$select->join(array("u" => "user"), array("u" => "userid", "m" => "sender"));
$select->join(array("g" => "galaxy"), array("g" => "planetid", "u" => "hp"));
$select->attributes(array("m.*", "u" => array("username"), "g" => array("galaxy", "system", "position")));
return $select;
}
/**
* Retrieves a raw select object for the table.
*
* @return Recipe_Database_Select
*/
public function getSelect()
{
$select = parent::getSelect();
$select->attributes(array(new Recipe_Database_Expr("COUNT(u2a.userid) AS member"), new Recipe_Database_Expr("SUM(u.points) AS points"), new Recipe_Database_Expr("SUM(u.fpoints) AS fpoints"), new Recipe_Database_Expr("SUM(u.dpoints) AS dpoints"), new Recipe_Database_Expr("SUM(u.rpoints) AS rpoints"), "a" => array("aid", "name", "tag", "textextern", "textintern", "founder", "foundername", "logo", "homepage", "showmember", "showhomepage")));
$select->join(array("u2a" => "user2ally"), array("u2a" => "aid", "a" => "aid"))->join(array("u" => "user"), array("u" => "userid", "u2a" => "userid"));
$select->group(array("u2a" => "aid"));
return $select;
}
/**
* (non-PHPdoc)
* @see lib/Recipe/Database/Recipe_Database_Table#getSelect()
*/
public function getSelect()
{
$select = parent::getSelect();
$select->attributes($this->getAttributes());
$select->order(array("c" => "display_order"), "ASC");
$select->order(array("c" => "buildingid"), "ASC");
return $select;
}
public function getSelect()
{
$select = parent::getSelect();
$select->join(array("u2a" => "user2ally"), array("u" => "userid", "u2a" => "userid"));
$select->join(array("a" => "alliance"), array("a" => "aid", "u2a" => "aid"));
$select->attributes(array("u.*", "a" => array("aid", "alliance_name" => "name", "alliance_tag" => "tag", "logo")));
return $select;
}
/**
* Retrieves a raw select object for the table.
*
* @return Recipe_Database_Select
*/
public function getSelect()
{
$select = parent::getSelect();
$select->join(array("u" => "user"), array("u" => "userid", "s" => "userid"))->attributes(array("s" => array("sessionid", "userid", "ipaddress", "useragent", "time"), "u" => array("username")));
return $select;
}
/**
* Retrieves the select object for the model.
*
* @return Recipe_Database_Select
*/
public function getSelect()
{
$select = parent::getSelect();
$select->attributes(array("p" => array("profile_id", "name", "type")));
return $select;
}
/**
* Initilizing method.
*
* @return Bengine_Game_Model_Resource_Event_Type
*/
protected function init()
{
$this->setMainTable("event_type");
return parent::init();
}
protected function init()
{
$this->setMainTable("achievement_reward");
return parent::init();
}
/**
* (non-PHPdoc)
* @see lib/Recipe/Database/Recipe_Database_Table#getSelect()
*/
public function getSelect()
{
$select = parent::getSelect();
$select->join(array("et" => "event_type"), array("et" => "event_type_id", "e" => "mode"))->join(array("p1" => "planet"), array("p1" => "planetid", "e" => "planetid"))->join(array("p2" => "planet"), array("p2" => "planetid", "e" => "destination"))->join(array("g1" => "galaxy"), array("g1" => "planetid", "e" => "planetid"))->join(array("g2" => "galaxy"), array("g2" => "planetid", "e" => "destination"))->join(array("m1" => "galaxy"), array("m1" => "moonid", "e" => "planetid"))->join(array("m2" => "galaxy"), array("m2" => "moonid", "e" => "destination"))->join(array("u1" => "user"), array("u1" => "userid", "e" => "user"))->join(array("u2" => "user"), array("u2" => "userid", "p2" => "userid"))->attributes(array("e" => array("eventid", "parent_id", "mode", "start", "time", "planetid", "destination", "data", "userid" => "user"), "et" => array("code", "base_type"), "p1" => array("planetname", "ismoon"), "p2" => array("destination_planetname" => "planetname", "destination_ismoon" => "ismoon", "destination_user_id" => "userid"), "u1" => array("points", "username"), "u2" => array("destination_username" => "username"), new Recipe_Database_Expr("IFNULL(`g1`.`galaxy`, `m1`.`galaxy`) AS `galaxy`, IFNULL(`g1`.`system`, `m1`.`system`) AS `system`, IFNULL(`g1`.`position`, `m1`.`position`) AS `position`, `g1`.`destroyed`"), new Recipe_Database_Expr("IFNULL(`g2`.`galaxy`, `m2`.`galaxy`) AS `galaxy2`, IFNULL(`g2`.`system`, `m2`.`system`) AS `system2`, IFNULL(`g2`.`position`, `m2`.`position`) AS `position2`, `g2`.`destroyed` as destination_destroyed")));
return $select;
}
protected function init()
{
$this->setMainTable(array("b" => "buddylist"));
return parent::init();
}
/**
* @return Recipe_Database_Select
*/
public function getSelect()
{
$select = parent::getSelect();
$this->addL10nOverlay($select, array("name", "description"));
return $select;
}
