Lines Matching refs:database

239 		$this->functions->database->prepare("SELECT User, Lang FROM tblUserRights;");
240 		$this->functions->database->execute();
242 		if ( $this->functions->database->num_rows() != 0 ) {
244 			$data = array(); $this->functions->database->bind_assoc($data);
245 			while ( $this->functions->database->fetch() ) {
270 				$this->functions->database->prepare("DELETE FROM tblUserRights WHERE User=?;");
271 				$this->functions->database->execute($user);
278 			$this->functions->database->prepare("SELECT * FROM tblUserRights WHERE User=?;");
279 			$this->functions->database->execute($user);
280 			if ( $this->functions->database->num_rows() > 0 )
281 			$this->functions->database->prepare("UPDATE tblUserRights SET Lang=? WHERE User=?;");
283 			$this->functions->database->prepare("INSERT INTO tblUserRights (Lang, User) VALUES(?, ?);");
285 			$this->functions->database->execute($lang, $user);
300 		$this->functions->database->prepare("SELECT * FROM tblCategory WHERE Name=?;");
301 		$this->functions->database->execute($categoryName);
302 		if ( $this->functions->database->num_rows() > 0 ) {
308 		$this->functions->database->prepare("INSERT INTO tblCategory (Name, FileName) VALUES (?,?);");
309 		$this->functions->database->execute($categoryName, $fileName);
329 			$this->functions->database->prepare("DELETE FROM tblCategory WHERE CategoryID=?;");
330 			$this->functions->database->execute($name);
433 …$this->functions->database->prepare("DELETE FROM tblTranslation WHERE KeyID=? AND User=? AND Lang=…
436 			$this->functions->database->execute($KeyID, $User, $Lang);
437 			$removed += $this->functions->database->num_rows();
472 …$this->functions->database->prepare("SELECT tblTranslation.KeyID FROM tblTranslation INNER JOIN tb…
474 		$this->functions->database->execute($EXECUTE);
475 		$data = array(); $this->functions->database->bind_assoc($data);
476 		while ( $this->functions->database->fetch() ) {
498 …$this->functions->database->prepare("DELETE FROM tblMaster WHERE CategoryID=? AND Version LIKE ? $…
499 		$this->functions->database->execute($EXECUTE);
500 		if ( $this->functions->database->num_rows() > 0 ) {
502 …msg($this->functions->_messageReplacer('RemovedEntries', array($this->functions->database->num_row…
526 			$this->functions->database->prepare("DELETE FROM tblMaster WHERE CategoryID=? AND Version=?;");
527 			$this->functions->database->execute($CategoryID, $version);
575 …$this->functions->database->prepare("SELECT tblCategory.CategoryID, tblCategory.Name FROM (tblTran…
576 		$this->functions->database->execute($user);
578 		if ( $this->functions->database->num_rows() == 0 ) {
584 		$categories=array(); $data=array(); $this->functions->database->bind_assoc($data);
585 		while ( $this->functions->database->fetch()) {
613 …$this->functions->database->prepare("SELECT Version, COUNT(tblTranslation.KeyID) as Amount FROM tb…
614 			$this->functions->database->execute($user, $CategoryID);
616 			$data=array(); $this->functions->database->bind_assoc($data);
617 			while ( $this->functions->database->fetch()) {
629 …$this->functions->database->prepare("SELECT Date, Lang, COUNT(tblTranslation.KeyID) as Amount FROM…
630 		$this->functions->database->execute($user);
632 		$data=array(); $this->functions->database->bind_assoc($data);
633 		while ( $this->functions->database->fetch()) {