<?php require_once 'common.php'; check_logged_in(); if (isset($_SESSION['user']) && $_SESSION['user']['is_logged'] == 1) { $PageTitle = getLang('ptitle_logged'); } else { $PageTitle = getLang('ptitle_notlogged'); } $db = new DBConnection(); $query = 'SELECT user_firstname, trading_type,user_lastname,user_account_num FROM users WHERE user_account_num="' . $_SESSION['user']['user_account_num'] . '" LIMIT 1'; $res = $db->rq($query); $username = $db->fetch($res); $userProfile = ''; //--------------------------------------------- $total_trading = 0; $total_trading2 = 0; $total_total_fees = 0; $total_purchase = 0; $total_sales = 0; $total_fees = 0; $query = 'SELECT SUM(trade_value) AS total_purchase FROM trades WHERE trade_type=1 AND trade_status IN (1,4) AND user_account_num="' . $_SESSION['user']['user_account_num'] . '"'; $res = $db->rq($query); $row = $db->fetch($res); $total_trading -= $row['total_purchase']; $total_trading2 -= $row['total_purchase']; $total_purchase += $row['total_purchase']; $query = 'SELECT SUM(trade_value) AS total_purchase FROM stock_trades WHERE trade_type=1 AND trade_status IN (1,4) AND user_account_num="' . $_SESSION['user']['user_account_num'] . '"'; $res = $db->rq($query); $row = $db->fetch($res); $total_trading -= $row['total_purchase'];
<?php //header("Content-type: application/xml"); require_once("include/check_logged_in.php"); if (!check_logged_in()){ echo "False"; } // 4. Set Person id for example 1 and example 2 $person_id = "1190740"; /*$url = sprintf("https://www.planningcenteronline.com/people/$person_id.xml"); $content = '<person><first-name>Johnny</first-name><last-name>Sheppard</last-name></person>'; $response = get_pco_data($url,"PUT",$content); */ $url = sprintf("https://www.planningcenteronline.com/organization.xml"); $response = get_pco_data($url); $organization = simplexml_load_string($response); foreach ($organization->{'service-types'}->{'service-type'} as $service){ echo "<h2>" . $service->name . "</h2>\n"; echo "<table border=1>\n"; $service_id = $service->id; $url = sprintf("https://www.planningcenteronline.com/service_types/" . $service_id. "/plans.xml"); $response2 = get_pco_data($url); $plans = simplexml_load_string($response2); foreach($plans->plan as $plan){ echo "<tr><td>" . $plan->{'plan-title'} . " </td><td>" . $plan->dates . "</td></tr>\n"; }
function is_oto_all($menu, $link_oto, $userid = '') { check_logged_in($this->session->userdata('userid')); $userid == '' ? $uid = $this->session->userdata('userid') : ($uid = $userid); if ($uid == 'Superuser') { $link_oto; } else { if ($this->is_oto($menu, 'c', $uid) == 'Y' || $this->is_oto($menu, 'e', $uid) == 'Y' || $this->is_oto($menu, 'v', $uid) == 'Y' || $this->is_oto($menu, 'p', $uid) == 'Y' || $this->is_oto($menu, 'd', $uid) == 'Y') { $link_oto; } else { //$this->load->view("admin/no_authorisation"); no_auth(); } } }
display_items('All Lists', get_all_lists(), 'information', 'show-archive', ''); break; case 'show-archive': display_items('Archive For ' . get_list_name($_GET['id']), get_archive($_GET['id']), 'view-html', 'view-text', ''); break; case 'information': display_information($_GET['id']); break; default: if (!check_logged_in()) { display_login_form($action); } break; } //all other actions require user to be logged in if (check_logged_in()) { switch ($action) { case 'account-settings': display_account_form(get_email(), get_real_name(get_email()), get_mimetype(get_email())); break; case 'show-other-lists': display_items('Unsubscribed Lists', get_unsubscribed_lists(get_email()), 'information', 'show-archive', 'subscribe'); break; case 'subscribe': subscribe(get_email(), $_GET['id']); display_items('Subscribed Lists', get_subscribed_lists(get_email()), 'information', 'show-archive', 'unsubscribe'); break; case 'unsubscribe': unsubscribe(get_email(), $_GET['id']); display_items('Subscribed Lists', get_subscribed_lists(get_email()), 'information', 'show-archive', 'unsubscribe'); break;
function getProgressUnit($unit, $details = false, $verbose = true) { check_logged_in(); global $mysqli, $user; $sql = 'SELECT correct, layers FROM UnitProgress WHERE unitId=? AND userId=?'; $stmt = $mysqli->prepare($sql); $userid = $user->userid(); $stmt->bind_param('ii', $unit, $userid); $stmt->execute(); $stmt->bind_result($correct, $layers); // try to fetch $result = array('correct' => 0, 'layers' => 1); if ($stmt->fetch()) { $result['correct'] = $correct; $result['layers'] = $layers; } $stmt->close(); // exit if (!$details) { if ($verbose) { echo json_encode($result); } return $result; } $sql = 'SELECT layerId, successes, failures, averageTime, bestTime, (SELECT AVG(bestScore) FROM Progress p WHERE p.layerId = id) AS averageScore FROM Progress JOIN Layers ON layerId = id WHERE parent=? AND userId=?'; $stmt = $mysqli->prepare($sql); $userid = $user->userid(); $stmt->bind_param('ii', $unit, $userid); $stmt->execute(); $stmt->bind_result($layer, $successes, $failures, $avg, $best, $score); // try to fetch $result['layer_results'] = array(); while ($stmt->fetch()) { $result['layer_results'][] = array('layerId' => $layer, 'successes' => $successes, 'failures' => $failures, 'averageTime' => $avg, 'bestTime' => $best, 'score' => $score); } $stmt->close(); if ($verbose) { echo json_encode($result); } return $result; }
function __construct() { parent::__construct(); check_logged_in() or redirect('login'); $this->load->model('jobs_model', 'jobs'); }