forked from tylerhall/Shine
-
Notifications
You must be signed in to change notification settings - Fork 1
/
users.php
126 lines (116 loc) · 4.27 KB
/
users.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<?PHP
require 'includes/master.inc.php';
$Auth->requireAdmin('login.php');
$db = Database::getDatabase();
if(isset($_GET['q']))
{
$q = $_GET['q'];
$_q = $db->escape($q);
$search_sql = " AND (username LIKE '%$_q%' OR email LIKE '%$_q%') ";
}
else
{
$q = '';
$search_sql = '';
}
/**
* Add pager information
* $total_num_orders = $db->getValue("SELECT COUNT(*) FROM users WHERE 1 = 1 $search_sql ");
* $pager = new Pager(@$_GET['page'], 50, $total_num_orders);
*/
$users = DBObject::glob('User', "SELECT * FROM users WHERE 1 = 1 $search_sql ORDER BY username"); // LIMIT {$pager->firstRecord}, {$pager->perPage}");
$where = '';
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>Shine</title>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" >
<link rel="stylesheet" href="http://yui.yahooapis.com/2.7.0/build/reset-fonts-grids/reset-fonts-grids.css" type="text/css">
<link rel="stylesheet" href="css/yuiapp.css" type="text/css">
<link rel="stylesheet" href="js/jquery.fancybox.css" type="text/css" media="screen">
</head>
<body class="rounded">
<div id="doc3" class="yui-t6">
<div id="hd">
<h1>Shine</h1>
<div id="navigation">
<ul id="primary-navigation">
<li><a href="index.php">Applications</a></li>
<li><a href="orders.php">Orders</a></li>
<li><a href="feedback.php">Feedback</a></li>
<li><a href="stats.php">Sparkle Stats</a></li>
</ul>
<ul id="user-navigation">
<li class="active"><a href="users.php">Users</a></li>
<li><a href="settings.php">Settings</a></li>
<li><a href="logout.php">Logout</a></li>
</ul>
<div class="clear"></div>
</div>
</div>
<div id="bd">
<div id="yui-main">
<div class="yui-b"><div class="yui-g">
<div class="block tabs spaces">
<div class="hd">
<h2>Users</h2>
<ul>
<li class="active"><a href="users.php">Users</a></li>
<li><a href="user-new.php">Create new user</a></li>
</ul>
<div class="clear"></div>
</div>
<div class="bd">
<table>
<thead>
<tr>
<td>Username</td>
<td>Level</td>
<td>Email</td>
<td>Actions</td>
</tr>
</thead>
<tbody>
<?PHP foreach($users as $u) : ?>
<tr>
<td><?PHP echo $u->username; ?></td>
<td><?PHP echo $u->level; ?></td>
<td><?PHP echo $u->email; ?></td>
<td>
<a href="user-edit.php?id=<?PHP echo $u->id; ?>">Edit</a>
<a href="user-edit.php?id=<?PHP echo $u->id; ?>&action=delete" onclick="return confirm('Are you sure?');">Delete</a>
</td>
</tr>
<?PHP endforeach; ?>
</tbody>
</table>
</div>
</div>
</div></div>
</div>
<div id="sidebar" class="yui-b">
<div class="block">
<div class="hd">
Search Users
</div>
<div class="bd">
<form action="users.php" method="get">
<p><input type="text" name="q" value="<?PHP echo @$q; ?>" id="q" class="text">
<span class="info">Searches Username and Email address.</span></p>
<p><input type="submit" name="btnSearch" value="Search" id="btnSearch"></p>
</form>
</div>
</div>
</div>
</div>
<div id="ft"></div>
</div>
<script type="text/javascript" src="js/jquery-1.3.2.min.js"></script>
<script type="text/javascript" src="js/jquery.fancybox-1.2.1.pack.js"></script>
<script type="text/javascript" charset="utf-8">
$(".fb").fancybox({ 'zoomSpeedIn': 300, 'zoomSpeedOut': 300, 'overlayShow': false });
</script>
</body>
</html>