18     private $sqlitehelper;  variable in helper_plugin_blogtng_comments
26         $this->sqlitehelper = plugin_load('helper', 'blogtng_sqlite');
50         $resid = $this->sqlitehelper->getDB()->query($query, $cid);
54         if ($this->sqlitehelper->getDB()->res2count($resid) == 0) {
57         $result = $this->sqlitehelper->getDB()->res2arr($resid);
70         if (!$this->sqlitehelper->ready()) return 0;
88         $res = $this->sqlitehelper->getDB()->query($sql,$args);
89         $res = $this->sqlitehelper->getDB()->res2row($res,0);
99         if (!$this->sqlitehelper->ready()) {
109             $this->sqlitehelper->getDB()->query($query,
146         $this->sqlitehelper->getDB()->query($query,
166         $res = $this->sqlitehelper->getDB()->query(
172         $cid = $this->sqlitehelper->getDB()->res2single($res);
193         if (!$this->sqlitehelper->ready()) return false;
195         return (bool) $this->sqlitehelper->getDB()->query($query, $cid);
205         if (!$this->sqlitehelper->ready()) return false;
207         return (bool) $this->sqlitehelper->getDB()->query($sql,$pid);
218         if (!$this->sqlitehelper->ready()) return false;
220         return (bool) $this->sqlitehelper->getDB()->query($query, $status, $cid);
234         if (!$this->sqlitehelper->ready()) return;
240         $res = $this->sqlitehelper->getDB()->query($sql, $comment->getPid());
241         $entry = $this->sqlitehelper->getDB()->res2row($res,0);
283         $res = $this->sqlitehelper->getDB()->query($sql, $comment->Pid());
284         $rows = $this->sqlitehelper->getDB()->res2arr($res);
335         if (!$this->sqlitehelper->ready()) {
343         $this->sqlitehelper->getDB()->query($sql,$pid,strtolower($mail));
349             $this->sqlitehelper->getDB()->query($sql,strtolower($mail),$optin,md5(time()));
353             $this->sqlitehelper->getDB()->query($sql,strtolower($mail),$optin,md5(time()));
357             $res = $this->sqlitehelper->getDB()->query($sql,strtolower($mail));
358             $row = $this->sqlitehelper->getDB()->res2row($res,0);
362                 $this->sqlitehelper->getDB()->query($sql,strtolower($mail));
376         if (!$this->sqlitehelper->ready()) {
381         $res = $this->sqlitehelper->getDB()->query($sql, $key);
382         $row = $this->sqlitehelper->getDB()->res2row($res);
398         if (!$this->sqlitehelper->ready()) {
403         $res = $this->sqlitehelper->getDB()->query($sql, $pid, $mail);
404         $upd = $this->sqlitehelper->getDB()->countChanges($res);
419         if (!$this->sqlitehelper->ready()) {
425         $res = $this->sqlitehelper->getDB()->query($sql,$key);
426         $upd = $this->sqlitehelper->getDB()->countChanges($res);
590         if (!$this->sqlitehelper->ready()) return;
606         $res = $this->sqlitehelper->getDB()->query($sql,$args);
607         $res = $this->sqlitehelper->getDB()->res2arr($res);
646         if(!$this->sqlitehelper->ready()) return false;
650             $types  = $this->sqlitehelper->getDB()->quote_and_join($types,',');
656                        $this->sqlitehelper->getDB()->quote_and_join($blogs,
668         $res = $this->sqlitehelper->getDB()->query($query);
670         if(!$this->sqlitehelper->getDB()->res2count($res)) return false; // no results found
671         $res = $this->sqlitehelper->getDB()->res2arr($res);