$config_file = '/var/www/mikbill/admin/app/etc/config.xml';
#$config_file = 'D:\\WORK\\SOFT\\OpenServer\\domains\\admin2x\\app\\etc\\config.xml';
$pathToLogFile = './iptv.log';
$syncConfig = array();
echo "<pre>";
include './iptvportal_helper.php';
$link = connectToDB($CONF_MYSQL_HOST, $CONF_MYSQL_USERNAME, $CONF_MYSQL_PASSWORD, $CONF_MYSQL_DBNAME);
# получить сис. опции
$IPTVOptions = getSystemOptionsIPTV($link);
if (!isset($IPTVOptions['iptvportal_login'], $IPTVOptions['iptvportal_pass'], $IPTVOptions['iptvportal_subdomain'])) {
die('IPTVPortal does not configured in system options.');
}
$_auth_uri = 'https://admin.' . $IPTVOptions['iptvportal_subdomain'] . '.iptvportal.ru/api/jsonrpc/';
$_jsonsql_uri = 'https://admin.' . $IPTVOptions['iptvportal_subdomain'] . '.iptvportal.ru/api/jsonsql/';
$_iptvportal_header = null;
authorize_user($_auth_uri, $IPTVOptions['iptvportal_login'], $IPTVOptions['iptvportal_pass']);
//$user = authorize_user($_auth_uri, $_username, $_password);
//echo 'authorize user result: ';
//print_r($user);
echo "In!\n";
if (!empty($syncConfig['clear_services'])) {
# удаление тарифов
jsonsql_call("delete", array("from" => "package"));
}
if (!empty($syncConfig['clear_terminals'])) {
# удаление терминалов
jsonsql_call("delete", array("from" => "terminal"));
}
if (!empty($syncConfig['clear_users'])) {
# удаление абонентов
jsonsql_call("delete", array("from" => "subscriber"));
<?php
require_once '../scripts/app_config.php';
require_once '../scripts/authorize.php';
require_once '../scripts/database_connection.php';
require_once '../scripts/view.php';
// Only Administrators can access this page
authorize_user(array("Administrators"));
// Build the SELECT statement
$select_users = "SELECT user_id, first_name, last_name, email " . " FROM users";
// Run the query
$result = mysql_query($select_users);
// Display the view to users
$delete_user_script = <<<EOD
function delete_user(user_id) {
if (confirm("Are you sure you want to delete this user? " +
"There's really no going back!")) {
window.location = "delete_user.php?user_id=" + user_id;
}
}
EOD;
page_start("Current Users", $delete_user_script, $_REQUEST['success_message'], $_REQUEST['error_message']);
?>
<div id="content">
<ul>
<?php
while ($user = mysql_fetch_array($result)) {
$user_row = sprintf("<li><a href='show_user.php?user_id=%d'>%s %s</a> " . "(<a href='mailto:%s'>%s</a>) " . "<a href='javascript:delete_user(%d);'><img " . "class='delete_user' src='../images/delete.png' " . "width='15' /></a></li>", $user['user_id'], $user['first_name'], $user['last_name'], $user['email'], $user['email'], $user['user_id']);
echo $user_row;
}
));
// Если не удалось удалить абонента, то блокируем его
if (!$res) {*/
$res = change_abonent_state($p_account, true);
//}
return $res;
}
// Проверка разрешенных IP для доступа
if (array_search($current_ip, explode(";", $allowed_ips)) === FALSE) {
response(1, 'Wrong request IP');
exit;
}
// Выполняем заявку
if ($_POST) {
save_to_log('START');
$user = authorize_user($_auth_uri, $_username, $_password);
if (isset($_POST['reqtype']) && isset($_POST['account'])) {
// Для М2000 перекодируем, для Бриза оставляем как есть.
if (isset($_POST['name']) && isset($_POST['branch'])) {
if ($breez_ip != $current_ip) {
$v_name = iconv('windows-1251', 'utf-8', $_POST['name']);
$_POST['name'] = $v_name;
$v_branch = iconv('windows-1251', 'utf-8', $_POST['branch']);
$_POST['branch'] = $v_branch;
} else {
$v_name = $_POST['name'];
$v_branch = $_POST['branch'];
}
}
if (isset($_POST['param'])) {
if ($breez_ip != $current_ip) {
function jsonsql_call($cmd, $params)
{
global $_jsonsql_uri, $_iptvportal_header;
//echo 'iptvportal_header: '; print_r ($_iptvportal_header);
return jsonrpc_call($_jsonsql_uri, $cmd, $params, $extra_headers = $_iptvportal_header);
}
function authorize_user($auth_uri, $username, $password)
{
global $_iptvportal_header;
$res = jsonrpc_call($auth_uri, $cmd = "authorize_user", $params = array('username' => $username, 'password' => $password));
if (isset($res) && array_key_exists('session_id', $res)) {
$_iptvportal_header = array('Iptvportal-Authorization: ' . 'sessionid=' . $res['session_id']);
}
return $res;
}
$user = authorize_user($auth_uri = $_auth_uri, $username = $_username, $password = $_password);
echo 'authorize user result: ';
print_r($user);
# выборка списка абонентов
$res = jsonsql_call("select", array("data" => array("username", "password"), "from" => "subscriber"));
echo 'select cmd result: ';
print_r($res);
# выборка списка тв медиа
$res = jsonsql_call("select", array("data" => array("name", array("concat" => array("protocol", "://", "inet_addr", array("coalesce" => array(array("concat" => array(":", "port")), "")), array("coalesce" => array(array("concat" => array("/", "path")), ""))), "as" => "mrl")), "from" => "media", "where" => array("eq" => array("is_tv", true))));
#echo 'select cmd result: '; print_r ($res);
# выборка списка терминалов
$res = jsonsql_call("select", array("data" => array(array("t" => "inet_addr"), array("t" => "mac_addr"), array("s" => "username")), "from" => array(array("table" => "terminal", "as" => "t"), array("join" => "subscriber", "join_type" => "left", "as" => "s", "on" => array("eq" => array(array("t" => "subscriber_id"), array("s" => "id"))))), "order_by" => array("s" => "username")));
echo 'select cmd result: ';
print_r($res);
# добавление абонента "123456" с паролем "111"
$res = jsonsql_call("insert", array("into" => "subscriber", "columns" => array("username", "password"), "values" => array("username" => "123456", "password" => "111"), "returning" => "id"));
<legend>Login Information</legend>
<label >Username:</label>
<input id="username" name="username">
<br>
<br>
<label >Password:</label>
<input id="password" type="password" name="password">
<br>
</fieldset>
<br>
<input type="submit" value="Login">
</form>
</div>
</body>
<?php
//
// Getting the variables from the form
if (!isset($_POST['username'])) {
die;
}
if (!isset($_POST['password'])) {
die;
}
//
// authorizing login
authorize_user(trim($_POST['username']), $_POST['password']);
echo "<script>location.href = 'home_page.php'</script>";
?>
</html>
<?php
require_once '../scripts/app_config.php';
require_once '../scripts/authorize.php';
require_once '../scripts/database_connection.php';
require_once '../scripts/view.php';
session_start();
// Authorize any user, as long as they're logged in
authorize_user();
// Get the user ID of the user to show
$user_id = $_REQUEST['user_id'];
if (!isset($user_id)) {
$user_id = $_SESSION['user_id'];
}
// Build the SELECT statement
$select_query = "SELECT * FROM users WHERE user_id = " . $user_id;
// Run the query
$result = mysql_query($select_query);
if ($result) {
$row = mysql_fetch_array($result);
$first_name = $row['first_name'];
$last_name = $row['last_name'];
$bio = preg_replace("/[\r\n]+/", "</p><p>", $row['bio']);
$email = $row['email'];
$facebook_url = $row['facebook_url'];
$twitter_handle = $row['twitter_handle'];
$user_image = get_web_path($row['user_pic_path']);
// Turn $twitter_handle into a URL
$twitter_url = "http://www.twitter.com/" . substr($twitter_handle, $position + 1);
} else {
handle_error("There was a problem finding your " . "information in our system.", "Error locating user with ID {$user_id}");