Lines Matching refs:query
64 $query = "SELECT userid FROM users" variable
66 $res = db_query_safe($query, [$username, $username]);
73 $query = "SELECT * FROM users WHERE users.userid=?"; variable
74 $res = db_query_safe($query, [$id]);
127 $query = new Query("UPDATE users SET name=?,email=?", [$in['name'], $in['email']]); variable
129 $query->add(',svnpasswd=?', [$in['svnpasswd']]);
132 $query->add(',ssh_keys=?', [html_entity_decode($in['sshkey'],ENT_QUOTES)]);
135 $query->add(',username=?', [$in['username']]);
138 $query->add(',cvsaccess=?', [$cvsaccess]);
140 $query->add(
144 $query->add(',pchanged=?', [$ts]);
146 $query->add(' WHERE userid=?', [$id]);
151 db_query($query);
155 $query = "INSERT INTO users_note (userid, note, entered) VALUES (?, ?, NOW())"; variable
156 db_query_safe($query, [$id, $purpose]);
162 $query = "INSERT INTO users_profile (userid, markdown, html) VALUES (?, ?, ?) variable
164 … db_query_safe($query, [$id, $profile_markdown, $profile_html, $profile_markdown, $profile_html]);
329 $query = new Query("SELECT DISTINCT SQL_CALC_FOUND_ROWS users.userid,cvsaccess,username,name,email,… variable
330 $query->add(" LEFT JOIN users_note ON users_note.userid = users.userid ");
333 …$query->add("WHERE (MATCH(name,email,username) AGAINST (?) OR username = ?) ", [$search, $search]);
336 $query->add(' WHERE 1=1 ');
340 $query->add(' AND NOT cvsaccess ');
343 $query->add(" GROUP BY users.userid ");
355 $query->add(" ORDER BY $order $ext");
357 $query->add(" LIMIT ?int, ?int ", [$begin, $max]);
358 $res = db_query($query);
