Lines Matching refs:sql

72         $sql = 'SELECT COUNT(pid) as val
76             $sql .= ' AND status = \'visible\'';
86             $sql .= ' AND type IN ('.join(',',$qs).')';
88         $res = $this->sqlitehelper->getDB()->query($sql,$args);
160         $sql = "SELECT cid
167             $sql,
206         $sql = "DELETE FROM comments WHERE pid = ?";
207         return (bool) $this->sqlitehelper->getDB()->query($sql,$pid);
237         $sql = "SELECT title, page, mail
240         $res = $this->sqlitehelper->getDB()->query($sql, $comment->getPid());
278         $sql = "SELECT A.mail as mail, B.key as key
283         $res = $this->sqlitehelper->getDB()->query($sql, $comment->Pid());
341         $sql = "INSERT OR IGNORE INTO subscriptions
343         $this->sqlitehelper->getDB()->query($sql,$pid,strtolower($mail));
347             $sql = "INSERT OR REPLACE INTO optin
349             $this->sqlitehelper->getDB()->query($sql,strtolower($mail),$optin,md5(time()));
351             $sql = "INSERT OR IGNORE INTO optin
353             $this->sqlitehelper->getDB()->query($sql,strtolower($mail),$optin,md5(time()));
356             $sql = "SELECT optin, key FROM optin WHERE mail = ?";
357             $res = $this->sqlitehelper->getDB()->query($sql,strtolower($mail));
361                 $sql = "UPDATE optin SET optin = optin+1 WHERE mail = ?";
362                 $this->sqlitehelper->getDB()->query($sql,strtolower($mail));
380         $sql = 'SELECT mail FROM optin WHERE key = ?';
381         $res = $this->sqlitehelper->getDB()->query($sql, $key);
402         $sql = 'DELETE FROM subscriptions WHERE pid = ? AND mail = ?';
403         $res = $this->sqlitehelper->getDB()->query($sql, $pid, $mail);
424         $sql = 'UPDATE optin SET optin = 1 WHERE key = ?';
425         $res = $this->sqlitehelper->getDB()->query($sql,$key);
592         $sql = 'SELECT *
603             $sql .= ' AND type IN ('.join(',',$qs).')';
605         $sql .= ' ORDER BY created ASC';
606         $res = $this->sqlitehelper->getDB()->query($sql,$args);