function updUser() { if (!!$_FILES['userimg']['tmp_name']) { // is the file uploaded yet? global $todir, $time, $connection; $id = mysqli_real_escape_string($connection, $_POST['hidden']); $name = mysqli_real_escape_string($connection, $_POST['name']); $username = mysqli_real_escape_string($connection, $_POST['username']); $email = mysqli_real_escape_string($connection, $_POST['email']); $usertel = mysqli_real_escape_string($connection, $_POST['usertel']); $gender = mysqli_real_escape_string($connection, $_POST['gender']); if ($oneuser['userimg']) { getone(); unlink($todir . $oneuser['userimg']); } move_uploaded_file($_FILES['userimg']['tmp_name'], $todir . basename($_FILES['userimg']['name'])); $sql = "UPDATE users SET name='" . $name . "', username='******', email='" . $email . "', gender='" . $gender . "', usertel='" . $usertel . "', userimg='" . $_FILES['userimg']['name'] . "', regdate='" . $time . "' WHERE id=" . $id . ""; $connection->query($sql); } else { global $connection, $time; $id = mysqli_real_escape_string($connection, $_POST['hidden']); $name = mysqli_real_escape_string($connection, $_POST['name']); $username = mysqli_real_escape_string($connection, $_POST['username']); $email = mysqli_real_escape_string($connection, $_POST['email']); $usertel = mysqli_real_escape_string($connection, $_POST['usertel']); $gender = mysqli_real_escape_string($connection, $_POST['gender']); $sql = "UPDATE users SET name='" . $name . "', username='******', gender='" . $gender . "', usertel='" . $usertel . "', email='" . $email . "', regdate='" . $time . "' WHERE id=" . $id . ""; $connection->query($sql); } header("Location: index.php"); die; }
if (isset($_POST['send'])) { if (isset($_POST['all']) && $_POST['all']) { $db->query("DELETE FROM rhs_adminsessions WHERE lastactivity<='" . (time() - $shopconfig['shopconfig_adminsession_timeout']) . "'"); } else { $kicksession = $_POST['kicksession']; if (is_array($kicksession) && count($kicksession)) { $sessionlist = str_replace(",", "','", implode(",", $kicksession)); $db->query("DELETE FROM rhs_adminsessions WHERE hash IN ('{$sessionlist}') AND lastactivity<='" . (time() - $shopconfig['shopconfig_adminsession_timeout']) . "'"); } } } $result = $db->query("SELECT a.*, u.customer_admin_name FROM rhs_adminsessions a, rhs_customer u WHERE a.userid = u.customer_id"); $i = 0; while ($row = $db->fetch_array($result)) { if ($row['lastactivity'] > time() - $shopconfig['shopconfig_adminsession_timeout']) { $row['disabled'] = " DISABLED"; } else { $row['disabled'] = ""; } $row['starttime'] = date("H:i:s d-m-Y", $row['starttime']); $row['lastactivity'] = date("H:i:s d-m-Y", $row['lastactivity']); if (strlen($row['useragent']) > 50) { $row['useragent'] = substr($row['useragent'], 0, 48) . "..."; } $row['class'] = getone($count++, "firstrow", "secondrow"); $sessiondata[$i] = $row; $smarty->assign("sessiondata", $sessiondata); $i++; } $smarty->display("a_adminsessions.tpl.php"); exit;
$temp = $_MooClass['MooMySQL']->getOne("select count(1) as num FROM {$dbTablePre}service_leer WHERE receiveuid = '{$userid}' and receive_del=0 AND stat = '0'"); $num_li['qiubo'] = $temp['num'] ? $temp['num'] : 0; //邮件 $ret_count1 = $_MooClass['MooMySQL']->getOne("SELECT count(s_uid) as c FROM {$dbTablePre}services WHERE s_uid = '{$userid}' and flag = '1' and s_uid_del='0' and s_status = '0' ", true); $num_li['youjian'] = $ret_count1['c'] ? $ret_count1['c'] : 0; //2009-11-22日修改(得到总数) //SELECT mid,stat,other_contact_you as uid FROM {$dbTablePre}service_contact WHERE you_contact_other = '$userid' AND stat < 4 and send_del=0 and is_server=0 order by sendtime desc LIMIT $start,$pagesize //委托 $contact = $_MooClass['MooMySQL']->getOne("SELECT count(other_contact_you) as c FROM {$dbTablePre}service_contact WHERE you_contact_other = '{$userid}' AND stat = '1' and send_del=0 and is_server=0"); $num_li['weituo'] = $contact['c'] ? $contact['c'] : 0; //1分钟内浏览量 $time = time() - 61; $ret_count = $_MooClass['MooMySQL']->getOne("SELECT count(uid) as c FROM {$dbTablePre}service_visitor WHERE uid >0 and visitorid = '{$userid}' AND who_del !=2 and visitortime > '{$time}' "); $num_li['oneminite'] = $ret_count['c'] ? $ret_count['c'] : 0; echo return_data($num_li, true); //print_r($num_li); exit; } /**************************************************控制层*******************************/ $c = $_GET['c'] = empty($_GET['c']) ? '' : $_GET['c']; switch ($c) { case 'getone': getone(); break; case 'count': count_no(); break; default: getone(); break; }