Lines Matching refs:db
5 $db = new PDO($osu_db); variable
6 if (!$db) {
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='reenroll' WHERE rowid=$id");
76 $db->exec("UPDATE users SET remediation='policy' WHERE rowid=$id");
79 $db->exec("UPDATE users SET remediation='free' WHERE rowid=$id");
82 $db->exec("UPDATE users SET fetch_pps=1 WHERE rowid=$id");
85 $db->exec("UPDATE users SET fetch_pps=0 WHERE rowid=$id");
88 $db->exec("UPDATE users SET password='ChangeMe' WHERE rowid=$id");
94 $db->exec("UPDATE users SET policy='$policy' WHERE rowid=$id");
100 $db->exec("UPDATE users SET shared=1 WHERE rowid=$id");
102 $db->exec("UPDATE users SET shared=0 WHERE rowid=$id");
110 $db->exec("UPDATE users SET osu_user='$osu_user', osu_password='$osu_password' WHERE rowid=$id");
114 $db->exec("UPDATE users SET t_c_timestamp=NULL WHERE rowid=$id");
135 $row = $db->query("SELECT rowid,* FROM users WHERE rowid=$id")->fetch();
291 $res = $db->query("SELECT rowid,* FROM eventlog ORDER BY timestamp DESC LIMIT $limit");
293 …$res = $db->query("SELECT rowid,* FROM eventlog WHERE (user='$user' OR user='$osu_user') AND realm…
295 …$res = $db->query("SELECT rowid,* FROM eventlog WHERE user='$user' AND realm='$realm' ORDER BY tim…
332 $res = $db->query('SELECT rowid,* FROM users WHERE (phase2=1 OR methods=\'TLS\') ORDER BY identity'…