$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}");