function readSettings()
{
global $dbName, $config, $adminOptions, $failImg;
if ($db = new PDO('sqlite:' . $dbName . '-settings.db')) {
$statement = $db->prepare("SELECT * FROM Settings");
if ($statement) {
$statement->execute();
} else {
showHTML("{$failImg} Settings reading failed!");
}
$tempData = $statement->fetchAll();
$config['appId'] = $tempData[0]['appid'];
$config['secret'] = $tempData[0]['secret'];
$adminOptions = readOptions($tempData[0]['adminoptions']);
if (!isset($adminOptions['language'])) {
$adminOptions['language'] = 'en';
}
if (!isset($adminOptions['enableDemo'])) {
$adminOptions['enableDemo'] = 0;
}
if (!isset($adminOptions['enableNUR'])) {
$adminOptions['enableNUR'] = 1;
}
if (!isset($adminOptions['enableARA'])) {
$adminOptions['enableARA'] = 1;
}
if (!isset($adminOptions['minimumDelay'])) {
$adminOptions['minimumDelay'] = 1;
}
if (!isset($adminOptions['defaultDelay'])) {
$adminOptions['defaultDelay'] = 5;
}
if (!isset($adminOptions['adminTimeZone'])) {
$adminOptions['adminTimeZone'] = 'Asia/Karachi';
}
if (!isset($adminOptions['adminTimeZoneId'])) {
$adminOptions['adminTimeZoneId'] = 243;
}
if (!isset($adminOptions['useCron'])) {
$adminOptions['useCron'] = 0;
}
if (!isset($adminOptions['lang'])) {
$adminOptions['lang'] = 'en';
}
if (!isset($adminOptions['theme'])) {
$adminOptions['theme'] = 'modern';
}
if (!isset($adminOptions['scriptTitle'])) {
$adminOptions['scriptTitle'] = '';
}
if (!isset($adminOptions['scriptHeading'])) {
$adminOptions['scriptHeading'] = '';
}
if (!isset($adminOptions['scriptFooter'])) {
$adminOptions['scriptFooter'] = '';
} else {
$adminOptions['scriptFooter'] = urldecode($adminOptions['scriptFooter']);
}
if (!isset($adminOptions['scriptLogo'])) {
$adminOptions['scriptLogo'] = 'img/logo.png';
} else {
$adminOptions['scriptLogo'] = urldecode($adminOptions['scriptLogo']);
}
if (!isset($adminOptions['modernMBGC'])) {
$adminOptions['modernMBGC'] = '#FFFFFF';
}
if (!isset($adminOptions['modernCBGC'])) {
$adminOptions['modernCBGC'] = '#FFFFFF';
}
if (!isset($adminOptions['modernHBGC'])) {
$adminOptions['modernHBGC'] = '#081E42';
}
date_default_timezone_set($adminOptions['adminTimeZone']);
$db = null;
} else {
showHTML("{$failImg} Unable to open settings database. Exiting...");
}
}
<option></option>
<option value="Enabled">Enabled</option>
<option value="Disabled">Disabled</option>
<option value="Awaiting Approval">Awaiting Approval</option>
</select>
<table class="user footable table" cols=7 data-page-size="20" data-filter="#filter">
<thead><tr>
<th class="ui-widget-header" colspan=2 data-hide="phone" data-type="alpha">FB ' . $lang['User'] . '
<th class="ui-widget-header" data-type="alpha">' . $lang['Username'] . '
<th class="ui-widget-header" data-hide="phone" data-type="alpha">' . $lang['Email'] . '
<th class="ui-widget-header" data-type="numeric" data-hide="phone">' . $lang['Register'] . ' ' . $lang['Date'] . '
<th class="ui-widget-header" data-type="numeric" data-hide="phone">' . $lang['Last'] . ' ' . $lang['Visit'] . '
<th class="ui-widget-header">' . $lang['Operations'] . '</tr></thead>
<tbody>';
foreach ($tempData as $s) {
$userOptions = readOptions($s['useroptions']);
$userOptions = checkUserOptions($userOptions);
if ($hardDemo) {
$tempID = $s['userid'];
$s['username'] = $s['userid'] = $userOptions['email'] = '[hidden in demo]';
if ($s['fullname']) {
$s['fullname'] = substr($s['fullname'], 0, 1) . str_repeat('*', strlen($s['fullname']) - 1);
}
}
$userIdentity = $s['userid'] != '' ? $s['userid'] : $s['username'];
if (is_numeric($userIdentity) && $s['userid'] == '') {
//fix for all numeric usernames from prev. versions
$userIdentity .= "#";
}
$message .= "<tr><td data-value='" . $s['fullname'] . "'><img ";
if ($hardDemo && $tempID) {
$roles = json_decode(readURL('https://graph.facebook.com/v2.3/' . $config['appId'] . '/roles?limit=10000&access_token=' . $config['appId'] . '|' . $config['secret']));
$role = "";
foreach ($roles->data as $r) {
if ($r->user == $userId) {
$role = $r->role;
break;
}
}
$statement = $db->prepare("SELECT * FROM FB WHERE username = \"{$suun}\"");
if ($statement) {
$statement->execute();
} else {
showHTML("Statement Error during ARA");
}
$tempData = $statement->fetchAll();
$userOptions = readOptions($tempData[0]['useroptions']);
$userOptions["role"] = "";
$tempUserIdHolder = $userId;
$userId = $suun;
saveUserOptions();
$userId = $tempUserIdHolder;
if (!isset($adminOptions["admintoken"]) || $adminOptions["admintoken"] == "") {
if ($role == "administrators") {
$adminOptions["admintoken"] = $longUserToken;
saveAdminOptions();
} else {
//No admin token yet and a new user who is not admin :(
}
} elseif ($role == "" && $adminOptions['enableARA']) {
try {
$response = $fb->api("/v2.3/" . $config['appId'] . "/roles", "POST", array("access_token" => $adminOptions["admintoken"], "user" => $userOptions["guid"], "role" => "testers"));
