Lines Matching defs:db

5 $db = new PDO($osu_db);
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='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();
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");
308 $res = $db->query('SELECT rowid,* FROM users WHERE phase2=1');