Lines Matching refs:prepare
239 $this->functions->database->prepare("SELECT User, Lang FROM tblUserRights;");
270 $this->functions->database->prepare("DELETE FROM tblUserRights WHERE User=?;");
278 $this->functions->database->prepare("SELECT * FROM tblUserRights WHERE User=?;");
281 $this->functions->database->prepare("UPDATE tblUserRights SET Lang=? WHERE User=?;");
283 $this->functions->database->prepare("INSERT INTO tblUserRights (Lang, User) VALUES(?, ?);");
300 $this->functions->database->prepare("SELECT * FROM tblCategory WHERE Name=?;");
308 $this->functions->database->prepare("INSERT INTO tblCategory (Name, FileName) VALUES (?,?);");
329 $this->functions->database->prepare("DELETE FROM tblCategory WHERE CategoryID=?;");
433 …$this->functions->database->prepare("DELETE FROM tblTranslation WHERE KeyID=? AND User=? AND Lang=…
472 …$this->functions->database->prepare("SELECT tblTranslation.KeyID FROM tblTranslation INNER JOIN tb…
498 …$this->functions->database->prepare("DELETE FROM tblMaster WHERE CategoryID=? AND Version LIKE ? $…
526 $this->functions->database->prepare("DELETE FROM tblMaster WHERE CategoryID=? AND Version=?;");
575 …$this->functions->database->prepare("SELECT tblCategory.CategoryID, tblCategory.Name FROM (tblTran…
613 …$this->functions->database->prepare("SELECT Version, COUNT(tblTranslation.KeyID) as Amount FROM tb…
629 …$this->functions->database->prepare("SELECT Date, Lang, COUNT(tblTranslation.KeyID) as Amount FROM…