function get_plugin_data()
{
$query = "SELECT * FROM `" . $this->db->table('plugin') . "` ORDER BY `basename`;";
$result = $this->db->query($query);
$this->plugin_data = array();
while ($row = $this->db->fetch($result, SQL_ASSOC)) {
$this->plugin_data[$row['basename']] = $row;
}
}
function process_step4()
{
global $DEFAULTS;
$tpl = new Template_Wrap();
$tpl->set_handle('body', 'install_step4.html');
/**
* Get our posted data
*/
$user_password1 = post_or_db('user_password1');
$user_password2 = post_or_db('user_password2');
/**
* Update admin account
*/
include ROSTER_BASE . 'conf.php';
define('ROSTER_DB_DIR', ROSTER_LIB . 'dbal' . DIR_SEP);
switch ($db_config['dbtype']) {
case 'mysql':
include_once ROSTER_DB_DIR . 'mysql.php';
break;
case 'PDO':
include_once ROSTER_DB_DIR . 'pdo.php';
break;
default:
include_once ROSTER_DB_DIR . 'mysql.php';
break;
}
$db = new roster_db($db_config['host'], $db_config['database'], $db_config['username'], $db_config['password'], $db_config['table_prefix']);
$db->log_level();
$db->error_die();
if (!is_resource($db->link_id)) {
$tpl->message_die('Failed to connect to database <strong>' . $db_config['database'] . '</strong> as <strong>' . $db_config['username'] . '@' . $db_config['host'] . '</strong><br /><br /><a href="index.php">Restart Installation</a>');
}
/**
* Insert account data. This isn't in the data sql file because we don't
* want to include it in a settings reset
*/
if ($user_password1 == '' || $user_password2 == '') {
$pass_word = md5('admin');
} elseif ($user_password1 == $user_password2) {
$pass_word = md5($user_password1);
} else {
$pass_word = md5('admin');
}
$db->query("INSERT INTO `" . $db->table('user_members') . "` (`usr`) VALUES\t('Admin');");
$db->query("UPDATE `" . $db->table('user_members') . "` SET `pass` = '" . $pass_word . "',`access` = '11:0',`active`='1',`user_permissions` = '{\"id\":\"1\",\"roster_cp\":\"1\",\"gp_update\":\"1\",\"cp_update\":\"1\",\"lua_update\":\"1\"}' WHERE `usr` = 'Admin';");
$tpl->message_append('The WoWRoster Admin account has created<br />Please do not forget your password');
/**
* Rewrite the config file to its final form
*/
$config_file = file(ROSTER_BASE . 'conf.php');
$config_file[] = "\ndefine('ROSTER_INSTALLED', true);";
$config_file = implode('', $config_file);
// Set our permissions to execute-only
@umask(0111);
if (!($fp = @fopen('conf.php', 'w'))) {
$error_message = 'The <strong>conf.php</strong> file couldn\'t be opened for writing.<br />Paste the following in to conf.php and save the file to continue:<br /><pre>' . htmlspecialchars($config_file) . '</pre>';
$tpl->error_append($error_message);
} else {
@fwrite($fp, $config_file, strlen($config_file));
@fclose($fp);
}
/**
* Print out the login form
*/
if ($user_password1 != $user_password2 || $user_password1 == '' || $user_password2 == '') {
$tpl->message_append('<span style="font-weight:bold;font-size:14px;" class="negative">NOTICE</span><br /><br />Your passwords did not match, so it has been reset to <strong>admin</strong><br />You can change it by logging in and going to your account settings.');
}
$tpl->message_append('Your administrator account has been created, log in to be taken to the WoWRoster configuration page.');
$tpl->sql_output($db);
$tpl->page_header();
$tpl->page_tail();
}
function char_status_role($character_data)
{
if ($this->user['SiteRank'] >= 4) {
$charData = @roster_db::role_status($character_data['character'], $character_data['server']);
json::resp(array('success' => 'true', 'data' => $charData));
}
}
function claimCharacter()
{
global $usrInfo;
$char = $_GET['Char'];
$serv = $_GET['Server'];
$dbLookup = roster_db::lookup($char, $serv);
// Result
$claim = roster_db::claim($char, $serv, $usrInfo['Username'], json_decode($dbLookup->lookupData['Data'], true));
if ($claim == true) {
echo '
<div id="claimCharCompleteWindow" class="wbox" data-height="110px" data-width="320px" data-max-width="100%">
<div class="wbox-title">Character Claim</div>
<div class="wbox-content">
Character Claimed!
</div>
<div class="WBoxBtns">
<input type="button" class="WBox-btn btn-blue aniObj" value="Cool!" onclick="wbox.close();">
</div>
</div>
<script>
wbox.show(\'claimCharCompleteWindow\');
</script>';
} else {
echo '
<div id="claimCharStepsWindow" class="wbox" data-height="110px" data-width="320px" data-max-width="100%">
<div class="wbox-title">Steps to claim character</div>
<div class="wbox-content">
To claim this character you must unequip the following: Helm, Shoulders, & Main Hand. After that, reload your character and click Claim again!
</div>
<div class="WBoxBtns">
<input type="button" class="WBox-btn btn-blue aniObj" value="Got it!" onclick="wbox.close();">
</div>
</div>
<script>
wbox.show(\'claimCharStepsWindow\');
</script>';
}
checkUserDat();
}
