public function join($guild_name, $player_name) { $guild_name = (int) $guild_name; $player_name = (int) $player_name; $ide = new IDE(); if (empty($guild_name) or empty($player_name)) { $ide->redirect(WEBSITE . "/index.php/guilds"); } $ots = POT::getInstance(); $ots->connect(POT::DB_MYSQL, connection()); $guild = $ots->createObject('Guild'); $guild->load($guild_name); if (!$guild->isLoaded()) { $ide->redirect(WEBSITE . "/index.php/guilds"); } $player = new OTS_Player(); $player->load($player_name); if (!$player->isLoaded()) { $ide->redirect(WEBSITE . "/index.php/guilds"); } if ($player->getAccount()->getId() != $_SESSION['account_id']) { $ide->redirect(WEBSITE . "/index.php/guilds"); } require_once 'system/application/libraries/POT/InvitesDriver.php'; new InvitesDriver($guild); $invited_list = $guild->listInvites(); if (!in_array($player->getId(), $invited_list)) { $ide->redirect(WEBSITE . "/index.php/guilds"); } $guild->acceptInvite($player); $ide->redirect(WEBSITE . "/index.php/guilds/view/" . $guild->getId() . "/1"); }
public function createGuild($name, $character) { $ots = POT::getInstance(); $ots->connect(POT::DB_MYSQL, connection()); $player = new OTS_Player(); $player->load($character); $new_guild = new OTS_Guild(); $new_guild->setCreationData(time()); $new_guild->setName($name); $new_guild->setOwner($player); $new_guild->save(); $new_guild->setCustomField('motd', 'New guild. Leader must edit this text :)'); $new_guild->setCustomField('creationdata', time()); $new_guild->setCustomField('world_id', $player->getWorld()); $ranks = $new_guild->getGuildRanksList(); $ranks->orderBy('level', POT::ORDER_DESC); foreach ($ranks as $rank) { if ($rank->getLevel() == 3) { $player->setRank($rank); $player->save(); } } $ide = new IDE(); $ide->redirect(WEBSITE . "/index.php/guilds/view/" . $new_guild->getId()); success("{$name} has been created."); }
function create() { $ide = new IDE(); if ($ide->isLogged()) { $ide->redirect('../account'); } $this->load->helper('form'); if ($_POST) { $this->load->library('form_validation'); $this->form_validation->set_rules('name', 'Account Name', 'required|min_length[4]|max_length[32]|callback__account_exists|alpha'); $this->form_validation->set_rules('password', 'Password', 'required|matches[repeat]|min_length[4]|max_length[255]'); $this->form_validation->set_rules('email', 'Email', 'required|valid_email'); if ($this->form_validation->run() == TRUE) { require APPPATH . 'config/ide_default.php'; $ots = POT::getInstance(); $ots->connect(POT::DB_MYSQL, connection()); $account = new OTS_Account(); $name = $account->createNamed($_POST['name']); $account->setPassword($_POST['password']); $account->setEmail($_POST['email']); $account->setCustomField('premdays', PREMDAYS); try { $account->save(); $_SESSION['logged'] = 1; $_SESSION['name'] = $_POST['name']; $ide->redirect('../account'); } catch (Exception $e) { error($e->getMessage()); } } } #Load view of creating account $this->load->view('create'); }
/** * Returns string representation of object. * * <p> * If any display driver is currently loaded then it uses it's method. * </p> * * @version 0.1.3 * @since 0.1.0 * @return string String representation of object. */ public function __toString() { $ots = POT::getInstance(); // checks if display driver is loaded if ($ots->isDisplayDriverLoaded()) { return $ots->getDisplayDriver()->displayAccountsList($this); } return (string) $this->count(); }
echo 'Database error - can\'t connect to MySQL database. Possible reasons:<br>1. MySQL server is not running on host.<br>2. MySQL user, password, database or host isn\'t configured in: <b>' . $config['site']['server_path'] . 'config.lua</b> .<br>3. MySQL user, password, database or host is wrong.'; exit; } } elseif (strtolower($config['server']['sqlType']) == "sqlite") { $link_to_sqlitedatabase = $config['site']['server_path'] . $sqlitefile; try { $ots->connect(POT::DB_SQLITE, array('database' => $link_to_sqlitedatabase)); } catch (PDOException $error) { echo 'Database error - can\'t open SQLite database. Possible reasons:<br><b>' . $link_to_sqlitedatabase . '</b> - file isn\'t valid SQLite database.<br><b>' . $link_to_sqlitedatabase . '</b> - doesn\'t exist.'; exit; } } else { echo 'Database error. Unknown database type in <b>' . $config['site']['server_path'] . 'config.lua</b> . Must be equal to: "<b>mysql</b>" or "<b>sqlite</b>". Now is: "<b>' . strtolower($config['server']['sqlType']) . '"</b>'; exit; } $SQL = POT::getInstance()->getDBHandle(); $config['site']['install'] = 3; saveconfig_ini($config['site']); } if ($step == '3') { echo '<h1>STEP ' . $step . '</h1>Add tables and columns to DB<br>'; echo 'Installer try to add new tables and columns to database.<br>'; $config['server'] = parse_ini_file($config['site']['server_path'] . 'config.lua'); if ($config['server']['sqlType'] == "sqlite") { try { $SQL->query('ALTER TABLE accounts ADD "key" VARCHAR(255) NOT NULL DEFAULT "";'); } catch (PDOException $error) { } try { $SQL->query('ALTER TABLE accounts ADD "page_lastday" INTEGER(11) NOT NULL DEFAULT 0;'); } catch (PDOException $error) {
/** * Returns string representation of object. * * <p> * If any display driver is currently loaded then it uses it's method. Else it returns group name. * </p> * * @version 0.1.3 * @since 0.1.0 * @return string String representation of object. */ public function __toString() { $ots = POT::getInstance(); // checks if display driver is loaded if ($ots->isDisplayDriverLoaded()) { return $ots->getDisplayDriver()->displayGroup($this); } return $this->getName(); }
if (isset($server_config['mysqlHost'])) { //new (0.2.6+) ots config.lua file $mysqlhost = $server_config['mysqlHost']; $mysqluser = $server_config['mysqlUser']; $mysqlpass = $server_config['mysqlPass']; $mysqldatabase = $server_config['mysqlDatabase']; $sqlitefile = $server_config['sqliteDatabase']; } elseif (isset($server_config['sqlHost'])) { //old (0.2.4) ots config.lua file $mysqlhost = $server_config['sqlHost']; $mysqluser = $server_config['sqlUser']; $mysqlpass = $server_config['sqlPass']; $mysqldatabase = $server_config['sqlDatabase']; $sqlitefile = $server_config['sqliteDatabase']; } // loads #####POT mainfile##### include '../pot/OTS.php'; // PDO and POT connects to database $ots = POT::getInstance(); if ($server_config['sqlType'] == "mysql") { $ots->connect(POT::DB_MYSQL, array('host' => $mysqlhost, 'user' => $mysqluser, 'password' => $mysqlpass, 'database' => $mysqldatabase)); } elseif ($server_config['sqlType'] == "sqlite") { $ots->connect(POT::DB_SQLITE, array('database' => $config_ini['server_path'] . $sqlitefile)); } $name_db = new OTS_Player(); $name_db->find($name); if ($name_db->isLoaded()) { echo '<font color="red"><b>Já existe um personagem com esse nome.</b></font>'; } else { echo '<font color="green">O seu nome será: "<b>' . ucwords($name) . '</b>"</font>'; }
public function __construct(OTS_Guild $guild) { $this->guild = $guild; $this->db = POT::getInstance()->getDBHandle(); $this->guild->invitesDriver = $this; }
/** * Magic PHP5 method. * * <p> * Allows object unserialisation. * </p> */ public function __wakeup() { $this->db = POT::getInstance()->getDBHandle(); }
/** * Returns string representation for WHERE clause. * * <p> * Returned string can be easily inserted into SQL query. * </p> * * @version 0.1.0 * @since 0.1.0 * @return string String WHERE clause. */ public function __toString() { // database handle $db = POT::getInstance()->getDBHandle(); // basic name $name = $db->fieldName($this->name); // prepends table name if (!empty($this->table)) { $name = $db->tableName($this->table) . '.' . $name; } return $name; }
/** * @ignore */ function __autoload($class) { POT::getInstance()->loadClass($class); }
/** * Returns type of item. * * @version 0.1.0 * @since 0.1.0 * @return OTS_ItemType Returns item type of item (null if not exists). * @throws E_OTS_NotLoaded If global items list wasn't loaded. */ public function getItemType() { return POT::getInstance()->getItemsList()->getItemType($this->id); }
/** * Returns string representation of XML. * * <p> * If any display driver is currently loaded then it uses it's method. Otherwise just returns spell XML format. * </p> * * @version 0.1.3 * @since 0.1.0 * @return string String representation of object. */ public function __toString() { $ots = POT::getInstance(); // checks if display driver is loaded if ($ots->isDataDisplayDriverLoaded()) { return $ots->getDataDisplayDriver()->displaySpell($this); } return $this->element->ownerDocument->saveXML($this->element); }
public function view($name = null) { $ide = new IDE(); if (!empty($name)) { $data['character'] = $name; $ots = POT::getInstance(); $ots->connect(POT::DB_MYSQL, connection()); $player = $ots->createObject('Player'); $player->find($name); if (!$player->isLoaded()) { $ide->redirect("../../character/view/"); } else { $data['player'] = $player; $data['account'] = $player->getAccount(); } $this->load->view('view_character.php', $data); } else { $this->load->helper("form"); if ($_POST) { $name = $_POST['name']; $ots = POT::getInstance(); $ots->connect(POT::DB_MYSQL, connection()); $player = new OTS_Player(); $player->find($name); if ($player->isLoaded()) { $ide->redirect("../character/view/{$name}"); } else { error("{$name} could not be found."); } } $this->load->view('character_search.php'); } }
/** * Returns string representation of XML. * * <p> * If any display driver is currently loaded then it uses it's method. Otherwise just returns monster XML content. * </p> * * @version 0.1.3 * @since 0.1.0 * @return string String representation of object. */ public function __toString() { $ots = POT::getInstance(); // checks if display driver is loaded if ($ots->isDataDisplayDriverLoaded()) { return $ots->getDataDisplayDriver()->displayMonster($this); } return $this->saveXML(); }