<table class="listing" cellpadding="0" cellspacing="0">
<tr>
<th class="first" width="177">User Name</th>
<th>Email</th>
<th>Status</th>
<th>Active</th>
<th>IP Address</th>
<th>Edit</th>
<th class="last">Delete</th>
</tr>
<?php
ad_connect_db("yard");
//$qh = ad_query("select user,email from users");
$qh = user_query("SELECT user,email,status,active,ip,id FROM users order by id desc");
if (!$qh) {
die("Database Error");
}
$nr = ad_queryrows($qh);
$ct = 0;
if ($nr > 0) {
while ($nr > $ct) {
$user = ad_fetch($qh);
?>
<tr>
<td class="first style1">- <?php
echo $user[user];
?>
</td>
<td><?php
if (!isset($_POST["email"])) {
$email = "";
} else {
$email = $_POST["email"];
}
//die($email);
$result = user_register($username, $password, $email, $mysqli);
//$result = user_register($username, $password, $email, $mysqli);
$xml_output .= "<code>" . $result . "</code>";
}
/* SERVICE: Query user basic information */
} else {
if (isset($_GET['action']) && $_GET['action'] == 'query') {
if (isset($_GET['username'])) {
$username = $_GET['username'];
$user = user_query($username, $mysqli);
if ($user != null) {
$xml_output .= "<code>OK</code>";
$xml_output .= "<user_info>";
$xml_output .= "<id>" . $user['id'] . "</id>";
$xml_output .= "<username>" . $user['username'] . "</username>";
$xml_output .= "<email>" . $user['email'] . "</email>";
$xml_output .= "<is_online>" . $user['is_online'] . "</is_online>";
$xml_output .= "</user_info>";
} else {
$xml_output .= "<code>User non exist</code>";
}
}
/*SERVICE: Query user score*/
} else {
if (isset($_GET['action']) && $_GET['action'] == 'query_score') {
<?php
include "../include/db.php";
// include("../include/db1.php");
include "../include/functions.php";
//id //
if (isset($_POST['id'])) {
$id = mysql_real_escape_string($_POST['id']);
}
//end id//
//user//
if (isset($_POST['user'])) {
$user = mysql_real_escape_string($_POST['user']);
$userquery = user_query(null);
$userquery .= " AND trans.id={$user}";
// echo $userquery;
$userresult = mysql_query($userquery);
while ($userrow = mysql_fetch_array($userresult, MYSQL_ASSOC)) {
$nn = $userrow['nickname'];
$loc = $userrow['locale'];
$grp = $userrow['emp_group'];
$cred = $userrow['userroles'];
}
}
// end user //
// login page //
if (isset($_POST['pass'])) {
$pass = mysql_real_escape_string($_POST['pass']);
}
if (isset($_POST['user'])) {
$user = mysql_real_escape_string($_POST['user']);
function getuser($id)
{
$user = array();
$query = user_query(null);
$query .= " AND trans.id={$id}";
// echo $query;
$query = mysql_query($query);
while ($row = mysql_fetch_assoc($query)) {
$user = $row;
}
return $user;
}
