Lines Matching full:rowid
22 $row = $db->query("SELECT dump FROM eventlog WHERE rowid=$id")->fetch();
41 $row = $db->query("SELECT $mo FROM users WHERE rowid=$id")->fetch();
49 $row = $db->query("SELECT cert_pem FROM users WHERE rowid=$id")->fetch();
64 $db->exec("UPDATE users SET remediation='' WHERE rowid=$id");
67 $db->exec("UPDATE users SET remediation='user' WHERE rowid=$id");
70 $db->exec("UPDATE users SET remediation='machine' WHERE rowid=$id");
73 $db->exec("UPDATE users SET remediation='policy' WHERE rowid=$id");
76 $db->exec("UPDATE users SET remediation='free' WHERE rowid=$id");
79 $db->exec("UPDATE users SET fetch_pps=1 WHERE rowid=$id");
82 $db->exec("UPDATE users SET fetch_pps=0 WHERE rowid=$id");
85 $db->exec("UPDATE users SET password='ChangeMe' WHERE rowid=$id");
91 $db->exec("UPDATE users SET policy='$policy' WHERE rowid=$id");
97 $db->exec("UPDATE users SET shared=1 WHERE rowid=$id");
99 $db->exec("UPDATE users SET shared=0 WHERE rowid=$id");
107 $db->exec("UPDATE users SET osu_user='$osu_user', osu_password='$osu_password' WHERE rowid=$id");
128 $row = $db->query("SELECT rowid,* FROM users WHERE rowid=$id")->fetch();
168 $row['rowid'] . "\">add:user</a>]";
170 $row['rowid'] . "\">add:machine</a>]";
172 $row['rowid'] . "\">add:policy</a>]";
174 $row['rowid'] . "\">add:free</a>]";
177 $row['rowid'] . "\">clear</a>]";
180 $row['rowid'] . "\">clear</a>]";
183 $row['rowid'] . "\">clear</a>]";
186 $row['rowid'] . "\">clear</a>]";
192 $row['rowid'] . "&policy=' + this.value;\">\n";
209 $row['rowid'] . "&type=' + this.value;\">\n";
225 $row['rowid'] . "\">Reset AAA password</a><br>\n";
228 echo "<form action=\"users.php?cmd=set-osu-cred&id=" . $row['rowid'] .
267 $res = $db->query("SELECT rowid,* FROM eventlog ORDER BY timestamp DESC LIMIT $limit");
269 $res = $db->query("SELECT rowid,* FROM eventlog WHERE (user='$user' OR user='$osu_user') AND realm='$realm' ORDER BY timestamp DESC LIMIT $limit");
271 $res = $db->query("SELECT rowid,* FROM eventlog WHERE user='$user' AND realm='$realm' ORDER BY timestamp DESC LIMIT $limit");
284 echo "[<a href=\"users.php?cmd=eventlog&id=" . $row['rowid'] .
308 $res = $db->query('SELECT rowid,* FROM users WHERE phase2=1');
310 echo "<tr><td><a href=\"users.php?id=" . $row['rowid'] . "\"> " .
