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');
}
/**
* @version 0.0.5
* @param OTS_Account $account Account to be deleted.
* @deprecated 0.0.5 Use OTS_Account->delete().
*/
public function deleteAccount(OTS_Account $account)
{
$this->db->query('DELETE FROM ' . $this->db->tableName('account') . ' WHERE ' . $this->db->fieldName('id') . ' = ' . $account->getId());
}
}
}
if ($step == '5') {
echo '<h1>STEP ' . $step . '</h1>Set Admin Account<br>';
$config['server'] = parse_ini_file($config['site']['server_path'] . 'config.lua');
if (empty($_REQUEST['saveaccpassword'])) {
echo 'Admin account number is: <b>1</b><br/>Set new password to this account.<br>';
echo 'New password: <form action="install.php" method=POST><input type="text" name="newpass" size="35">(Don\'t give it password to anyone!)';
echo '<input type="hidden" name="saveaccpassword" value="yes"><input type="hidden" name="page" value="step"><input type="hidden" name="step" value="5"><input type="submit" value="SET"></form><br>If account with number 1 doesn\'t exist installator will create it and set your password.';
} else {
$newpass = $_POST['newpass'];
if (!check_password($newpass)) {
echo 'Password contains illegal characters. Please use only a-Z and 0-9. <a href="install.php?page=step&step=5&server_conf=yes">GO BACK</a> and write other password.';
} else {
$newpass_to_db = password_ency($newpass);
$account = new OTS_Account();
$account->load(1);
if ($account->isLoaded()) {
$account->setPassword($newpass_to_db);
$account->save();
$account->setCustomField("page_access", 6);
} else {
$number = $account->create(1, 1, 1);
$account->setPassword($newpass_to_db);
$account->unblock();
$account->save();
$account->setCustomField("page_access", 6);
}
$_SESSION['account'] = 1;
$_SESSION['password'] = $newpass;
$logged = TRUE;
/**
* Assigns character to account.
*
* <p>
* This method only updates object state. To save changes in database you need to use {@link OTS_Player::save() save() method} to flush changed to database.
* </p>
*
* @param OTS_Account $account Owning account.
* @throws E_OTS_NotLoaded If passed <var>$account</var> parameter is not loaded.
*/
public function setAccount(OTS_Account $account)
{
$this->data['account_id'] = $account->getId();
}
$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['site_ini']['server_path'] . $sqlitefile));
}
$email_db = new OTS_Account();
$email_db->findByEMail($email);
if ($email_db->isLoaded()) {
echo '<font color="red">Account with this e-mail already exist.</font>';
} else {
echo '<font color="green">Good e-mail.</font>';
}
} else {
echo '<font color="green">Good e-mail.</font>';
}
} else {
echo '<font color="red">Wrong e-mail format.</font>';
}
} else {
echo '<font color="red">E-mail is too long (max. 255 chars).</font>';
}
<?php // to not repeat all that stuff include 'quickstart.php'; // creates new account object $account = new OTS_Account(); // generates new account $name = $account->createNamed(); // give user his name echo 'Your account name is: ', $name;
$mysqlhost = $server_config['sqlHost'];
$mysqluser = $server_config['sqlUser'];
$mysqlpass = $server_config['sqlPass'];
$mysqldatabase = $server_config['sqlDatabase'];
$sqlitefile = $server_config['sqliteDatabase'];
}
// loads #####POT mainfile#####
include '../libs/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));
}
$email_db = new OTS_Account();
$email_db->find($email);
if ($email_db->isLoaded()) {
echo '<image src="../images/false.gif"> <font color="red">Account with this e-mail already exist.</font>';
} else {
echo '<image src="../images/true.gif"> <font color="green">Good e-mail.</font>';
}
} else {
echo '<image src="../images/true.gif"> <font color="green">Good e-mail.</font>';
}
} else {
echo '<image src="../images/false.gif"> <font color="red">Wrong e-mail format.</font>';
}
} else {
echo '<image src="../images/false.gif"> <font color="red">E-mail is too long (max. 255 chars).</font>';
}
echo '<image src="../images/false.gif"> <font color="red">Invalid account name format. Use only A-Z and numbers 0-9.</font>';
exit;
}
//connect to DB
$server_config = parse_ini_file($config_ini['server_path'] . 'config.lua');
if (isset($server_config['sqlHost'])) {
$mysqlhost = $server_config['sqlHost'];
$mysqluser = $server_config['sqlUser'];
$mysqlpass = $server_config['sqlPass'];
$mysqldatabase = $server_config['sqlDatabase'];
$sqlitefile = $server_config['sqliteDatabase'];
}
// loads #####POT mainfile#####
include '../libs/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));
}
$account_db = new OTS_Account();
$account_db->load($account);
if ($account_db->isLoaded()) {
echo '<image src="../images/false.gif"> <font color="red">Account with this name already exist.</font>';
} else {
echo '<image src="../images/true.gif"> <font color="green">Your account name will be: ' . $account . '</font>';
}
} else {
echo '<image src="../images/false.gif"> <font color="red">Account name is too long (max. 30 chars).</font>';
}
} elseif (!$config['site']['create_account_verify_mail']) {
if (!check_password($reg_password)) {
$reg_form_errors[] = "Password contains illegal chars (a-z, A-Z and 0-9 only!) or lenght.";
}
}
//SECOND check
## check e-mail address in database
if (empty($reg_form_errors)) {
if ($config['site']['one_email']) {
$test_email_account = $ots->createObject('Account');
$test_email_account->findByEmail($reg_email);
if ($test_email_account->isLoaded()) {
$reg_form_errors[] = "Account with this e-mail address already exist in database.";
}
}
$account_db = new OTS_Account();
$account_db->find($reg_name);
if ($account_db->isLoaded()) {
$reg_form_errors[] = 'Account with this name already exist.';
}
if ($config['site']['referrer']) {
$ref_check = $SQL->query('SELECT id FROM accounts WHERE id = ' . $reg_referrer . ' LIMIT 1')->fetch();
if ($reg_referrer > 0 && $ref_check['id'] < 1) {
$reg_form_errors[] = 'Uzywany przez Ciebie numer gracza, ktory polecil Ci nasz serwer nie istnieje. Popros go o poprawny link lub ponow rejestracje, aby kontynowac rejestracje bez polecajacego.';
}
}
}
// ----------creates account-------------(save in database)
if (empty($reg_form_errors)) {
//create object 'account' and generate new acc. number
if ($config['site']['create_account_verify_mail']) {
$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));
}
$account_db = new OTS_Account();
$account_db->find($account);
if ($account_db->isLoaded()) {
echo '<font color="red">Account with this name already exist.</font>';
} else {
echo '<font color="green">Good account name ( ' . $account . ' ). You can create account.</font>';
}
} else {
echo '<font color="red">Account name is too long (max. 32 chars).</font>';
}
<?php // to not repeat all that stuff include 'quickstart.php'; // creates new account objects $account = new OTS_Account(111111); // this is your password $password = '******'; // so if you use for example SHA1 hashing simply before any operation do $password = sha1($password); // saves password hash into database $account->setPassword($password); $account->save();
}
}
}
echo "</table>";
if (!$ide->isLogged()) {
alert("You need to be logged in to access any options.");
} else {
require_once 'system/application/libraries/POT/InvitesDriver.php';
new InvitesDriver($guild);
$invited_list = $guild->listInvites();
if (count($invited_list) == 0) {
echo "<center><b>This guild did not invite anyone.</b></center>";
} else {
$ots = POT::getInstance();
$ots->connect(POT::DB_MYSQL, connection());
$account_logged = new OTS_Account();
$account_logged->load($_SESSION['account_id']);
$account_players = $account_logged->getPlayers();
echo "<table width='100%'>";
echo "<tr><td><center><b>Name</b></center></td><td><center><b>Join</b></center></td></tr>";
$characters = array();
foreach ($account_players as $player_from_acc) {
$characters[] = $player_from_acc->getName();
}
foreach ($invited_list as $invited_player) {
if (in_array($invited_player->getName(), $characters)) {
echo "<tr><td><center><a href='" . WEBSITE . "/index.php/character/view/" . $invited_player->getName() . "'>" . $invited_player->getName() . "</a></center></td><td><center><a href='" . WEBSITE . "/index.php/guilds/join/" . $guild->getId() . "/" . $invited_player->getId() . "'>Join</a></center></td></tr>";
} else {
echo "<tr><td><center><a href='" . WEBSITE . "/index.php/character/view/" . $invited_player->getName() . "'>" . $invited_player->getName() . "</a></center></td><td><center>Cannot join</center></td></tr>";
}
}
function add_points(OTS_Account $account, $number_of_points)
{
if ($account->isLoaded()) {
$account->setCustomField('premium_points', $account->getCustomField('premium_points') + $number_of_points);
return true;
} else {
return false;
}
}
<?php
// to not repeat all that stuff
include 'quickstart.php';
// creates new account object
$account = new OTS_Account();
// loads account with ID (account number) 111111
$account->load(111111);
// alternative way - shorter
$account2 = new OTS_Account(111111);
// WARNING! This one won't work!
//$account2 = new OTS_Account('111111');
// '111111' is a string! not integer
// shows results of loading account
echo '111111 e-mail address: ', $account->getEMail();
