Exemple #1
0
<?php

include_once '../inc/config.inc.php';
$page_title = 'Login';
$msg = deQueueMsg();
if (!empty($_POST)) {
    extract($_POST);
    if (empty($username)) {
        enqueueMsg("Enter Username", "error");
    } else {
        $res = Query("SELECT * FROM admin_user WHERE user_name = '" . Encode($username) . "' AND password = '******' AND is_deleted = 'N'");
        if (Num($res) > 0) {
            $o = GetObj($res);
            if ($o->is_active == 'N') {
                enqueueMsg("This is not an  active user, please contact system administrator to activate!", "error");
            } else {
                $_SESSION["S_login"] = "******";
                $_SESSION["S_ID"] = $o->id;
                $_SESSION["S_username"] = $o->user_name;
                $_SESSION["S_full_name"] = $o->full_name;
                $_SESSION["S_email"] = $o->email;
                header("location:dashboard.php");
                exit;
            }
        } else {
            enqueueMsg("Invalid User Name/Password!", "error");
        }
    }
}
if ($msg == '') {
    //$msg = displayMsg('Please login with your Username and Password.');
Exemple #2
0
function GetCount($from, $where = '')
{
    if (!empty($where)) {
        $where = " where {$where}";
    }
    //echo "select count(*) as rows from $from $where";
    $r = Query("select count(*) as rows from {$from} {$where}");
    $o = GetObj($r);
    return $o->rows;
}
Exemple #3
0
function _tree_dropdown($table_name, $o_name, $selected, $where, $sort_order, $no_include, $parent_id, $level = 0)
{
    $output = "";
    $where2 = " WHERE parent_id = '{$parent_id}'";
    $where2 .= $where != "" ? " AND {$where}" : "";
    $sort_order2 = $sort_order != "" ? " ORDER BY {$sort_order}" : "";
    $sql = "select * from {$table_name} {$where2} {$sort_order2}";
    $r = Query($sql);
    while ($o = GetObj($r)) {
        $select_str = "";
        $indent = str_repeat('-', $level * 3);
        if ($o->id == $selected) {
            $select_str = 'selected="selected"';
        }
        if ($o->id != $no_include) {
            $output .= "<option {$select_str} value=\"{$o->id}\" >" . $indent . $o->{$o_name} . "</option>";
            $output .= _tree_dropdown($table_name, $o_name, $selected, $where, $sort_order, $no_include, $o->id, $level + 1);
        }
    }
    return $output;
}