Home
last modified time | relevance | path

Searched refs:query (Results 1 – 14 of 14) sorted by relevance

/web-master/manage/
H A Dusers.php64 $query = "SELECT userid FROM users" variable
74 $res = db_query_safe($query, [$id]);
140 $query->add(
144 $query->add(',pchanged=?', [$ts]);
146 $query->add(' WHERE userid=?', [$id]);
151 db_query($query);
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");
[all …]
H A Devent.php85 $query = new Query('UPDATE phpcal SET '); variable
87 $query->add('sdato=?, ', [$sdato]);
90 $query->add('edato=?, ', [$edato]);
93 $query->add('recur=?, ', [$recur]);
95 $query->add(
99 db_query($query);
251 $query->addQuery($searchby);
252 $res = db_query($query);
256 $query->addQuery($searchby);
267 $query->add(" ORDER BY $order $ext");
[all …]
H A Duser-notes.php93 $query->add('note.id = ?', [$_REQUEST['keyword']]);
100 $query->add(
104 $result = db_query_safe($query->get());
456 $query = new Query('UPDATE note SET sect = ? WHERE ', [$_REQUEST["new_sect"]]); variable
457 $query->addQuery($where);
458 db_query($query);
462 $query = new Query('SELECT COUNT(*) FROM note WHERE '); variable
463 $query->addQuery($where);
464 $result = db_query($query);
770 foreach ($stats_sql as $key => $query) {
[all …]
/web-master/fetch/
H A Duser-notes.php18 … $query = "SELECT DISTINCT note.id,note.sect,note.user,note.note,UNIX_TIMESTAMP(note.ts) AS ts,"; variable
19 $query .= "SUM(votes.vote) AS up, (COUNT(votes.vote) - SUM(votes.vote)) AS down,";
20 $query .= "ROUND((SUM(votes.vote) / COUNT(votes.vote)) * 100) AS rate";
21 $query .= " FROM note";
22 $query .= " LEFT JOIN (votes) ON (note.id = votes.note_id)";
24 $query .= " WHERE note.status is NULL";
25 $query .= " GROUP BY note.id";
26 $query .= " ORDER BY note.sect,ts DESC";
28 $stmt = $dbh->prepare($query);
H A Duser-notes-rss.php13 $query = new Query('SELECT DISTINCT id,sect,user,note,UNIX_TIMESTAMP(ts) AS ts FROM note'); variable
15 $query->add(" WHERE id = ?", [$_GET['id']]);
17 $query->add(" WHERE sect LIKE ");
20 $query->add('? OR sect LIKE ', [strtr($sect[$i],'*','%')]);
22 $query->add('?', [strtr($sect[count($sect) - 1],'*','%')]);
24 $query->add(" ORDER BY sect,ts DESC");
25 $query->add(" LIMIT ?", [$limit]);
27 $res = db_query($query);
/web-master/entry/
H A Devent.php46 …$query = "INSERT INTO phpcal SET tipo=1, sdato=?, sdesc=?, url=?, email=?, ldesc=?, country=?, cat… variable
47 …db_query_safe($query, ["$syear-$smonth-$sday", $sdesc, $url, $email, $ldesc, $country, $category]);
64 $query = "INSERT INTO phpcal SET tipo=2," variable
66 db_query_safe($query, [
77 $query = "INSERT INTO phpcal SET tipo=3," variable
79 db_query_safe($query, ["$recur:$recur_day", $sdesc, $url, $email, $ldesc, $country, $category]);
H A Duser-note.php68 $query = 'SELECT COUNT(*) FROM note WHERE ts >= (NOW() - INTERVAL 1 MINUTE)'; variable
69 $result = db_query_safe($query);
74 "Query Failed: $query\nError: ".mysql_error(),
104 $query = "INSERT INTO note (user, note, sect, ts, status) VALUES (?, ?, ?,NOW(), NULL)"; variable
105 if (db_query_safe($query, [$user, $note, $sect])) {
149 "Query Failed: $query\nError: ".mysql_error(),
H A Dsvn-account.php76 $query = "INSERT INTO users (name,email,svnpasswd,username) VALUES (?, ?, ?, ?)"; variable
77 if (db_query_safe($query, [$name, $email, $svnpasswd, $username])) {
/web-master/scripts/
H A Demail-note-summaries9 $query = "SELECT COUNT(*) AS count,sect FROM note" variable
12 $res = mysql_query($query)
24 $query = "SELECT COUNT(*) FROM note"; variable
26 $res = mysql_query($query)
H A Devent-weekly-email10 $query = 'SELECT COUNT(*) FROM phpcal WHERE NOT approved';
11 $count = db_get_one($query);
H A Dpregen_news113 $nodes = $xpath->query('//body/div/*');
/web-master/include/
H A Dfunctions.inc110 private $query = '';
132 $this->query .= $q->get();
136 return $this->query;
140 function db_query(Query $query)
142 $query = $query->get();
143 //var_dump($query);
144 $res = mysql_query($query);
152 function db_query_safe($query, array $params = [])
154 return db_query(new Query($query, $params));
157 function db_get_one($query)
[all …]
/web-master/
H A Dforgot.php71 $query = "UPDATE users SET forgot=? WHERE userid=?"; variable
72 $res = db_query_safe($query, [$newpass, $row['userid']]);
/web-master/.phan/internal_stubs/
H A Dmysql.phan_php117 * Send a MySQL query
119 * @param string $query <p>
120 * An SQL query
152 * the query.
162 * @param string $query <p>
163 * The SQL query to execute.
189 * @param string $query <p>
190 * The MySQL query.
301 * If the last query was a DELETE query with no WHERE clause, all
310 * the query.
[all …]

Completed in 20 milliseconds