<?php
// to not repeat all that stuff
include 'quickstart.php';
// creates new players list object
$players = new OTS_Players_List();
// creates filter
$filter = new OTS_SQLFilter();
// sets filter to choose only players with level 8
$filter->compareField('level', 8);
// sets filter on list
$players->setFilter($filter);
// iterates throught selected players
foreach ($players as $index => $player) {
echo $player->getName(), "\n";
}
/**
* List of characters on account.
*
* <p>
* In difference to {@link OTS_Account::getPlayers() getPlayers() method} this method returns filtered {@link OTS_Players_List OTS_Players_List} object instead of array of {@link OTS_Player OTS_Player} objects. It is more effective since OTS_Player_List doesn't perform all rows loading at once.
* </p>
*
* <p>
* Note: Returned object is only prepared, but not initialised. When using as parameter in foreach loop it doesn't matter since it will return it's iterator, but if you will wan't to execute direct operation on that object you will need to call {@link OTS_Base_List::rewind() rewind() method} first.
* </p>
*
* @version 0.1.4
* @since 0.0.5
* @return OTS_Players_List List of players from current account.
* @throws E_OTS_NotLoaded If account is not loaded.
*/
public function getPlayersList()
{
if (!isset($this->data['id'])) {
throw new E_OTS_NotLoaded();
}
// creates filter
$filter = new OTS_SQLFilter();
$filter->compareField('account_id', (int) $this->data['id']);
// creates list object
$list = new OTS_Players_List();
$list->setFilter($filter);
return $list;
}
$main_content .= '<OPTION VALUE="' . $id . '">' . $world_n . '</OPTION>';
}
$main_content .= '</SELECT> </TD><TD><INPUT TYPE=image NAME="Submit" ALT="Submit" SRC="' . $layout_name . '/images/buttons/sbutton_submit.gif">
</TD></TR></TABLE></TABLE></FORM></TABLE>';
foreach ($config['site']['worlds'] as $idd => $world_n) {
if ($idd == (int) $_REQUEST['world']) {
$world_id = $idd;
$world_name = $world_n;
}
}
if (!isset($world_id)) {
$world_id = 0;
$world_name = $config['server']['serverName'];
}
$filter = new OTS_SQLFilter();
$filter->compareField('world_id', (int) $world_id);
$guilds_list = $ots->createObject('Guilds_List');
$guilds_list->setFilter($filter);
$guilds_list->orderBy('name');
$main_content .= '<h2><center><i>World:</i> ' . $world_name . '</center></h2><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
<TR BGCOLOR=' . $config['site']['vdarkborder'] . '><TD COLSPAN=3 CLASS=white><B>Guilds on ' . $world_name . '</B></TD></TR>
<TR BGCOLOR=' . $config['site']['darkborder'] . '><TD WIDTH=64><B>Logo</B></TD>
<TD WIDTH=100%><B>Description</B></TD>
<TD WIDTH=56><B> </B></TD></TR>';
$showed_guilds = 1;
if (count($guilds_list) > 0) {
foreach ($guilds_list as $guild) {
if (is_int($showed_guilds / 2)) {
$bgcolor = $config['site']['darkborder'];
} else {
$bgcolor = $config['site']['lightborder'];
/**
* Returns list of VIPs.
*
* <p>
* It means list of players which this player have on his/her list.
* </p>
*
* @version 0.1.3
* @since 0.1.3
* @return OTS_Players_List List of VIPs.
* @throws E_OTS_NotLoaded If player is not loaded.
* @throws PDOException On PDO operation error.
*/
public function getVIPsList()
{
if (!isset($this->data['id'])) {
throw new E_OTS_NotLoaded();
}
$list = new OTS_Players_List();
// foreign table fields identifiers
$field1 = new OTS_SQLField('player_id', 'player_viplist');
$field2 = new OTS_SQLField('vip_id', 'player_viplist');
// creates filter
$filter = new OTS_SQLFilter();
$filter->addFilter($field1, $this->data['id']);
$filter->compareField('id', $field2);
// puts filter onto list
$list->setFilter($filter);
return $list;
}
<?php
// to not repeat all that stuff
include 'quickstart.php';
// creates new players list object
$players = new OTS_Players_List();
// creates filter
$filter = new OTS_SQLFilter();
// sets filter to choose players with capacity equal to hit points
$filter->addFilter(new OTS_SQLField('cap'), new OTS_SQLField('health'));
// another filter
$sub = new OTS_SQLFilter();
// only players with level 8 and higher...
$sub->compareField('level', 8, OTS_SQLFilter::OPERATOR_NLOWER);
// ... OR magic level 5 and higher
$sub->compareField('maglevel', 5, OTS_SQLFilter::OPERATOR_NLOWER, OTS_SQLFilter::CRITERIUM_OR);
// final result is:
// "cap" = "health" AND ("level" = 8 OR "maglevel" = 5)
$filter->addFilter($sub);
// sets filter on list
$players->setFilter($filter);
// iterates throught selected players
foreach ($players as $index => $player) {
echo $player->getName(), "\n";
}
/**
* Returns list of killers.
*
* @version 0.2.0+SVN
* @since 0.2.0+SVN
* @return OTS_Kills_List List of killers.
* @throws E_OTS_NotLoaded If death is not loaded.
* @throws PDOException On PDO operation error.
*/
public function getKillsList()
{
if (!isset($this->data['id'])) {
throw new E_OTS_NotLoaded();
}
// creates filter
$filter = new OTS_SQLFilter();
$filter->compareField('death_id', (int) $this->data['id']);
// puts filter onto list
$list = new OTS_Kills_List();
$list->setFilter($filter);
return $list;
}
