13 	var $functions = null;		// Helper  variable in admin_plugin_translator
33 		if ( !$this->functions->checkDatabase() ) {
34 			$this->functions = null;
87 		$this->functions->_handleRequest($fn);
118 			$this->functions->_exportManager($this);
128 		$categories = array_keys($this->functions->_getCategories());
143 		$this->functions->_revertManager($this, $this->revertableUpload);
148 		$categories = $this->functions->_getCategories();
156 			foreach ( $this->functions->_getAvailableVersions($category['CategoryID']) as $Version ) {
174 		$categories = $this->functions->_getCategories();
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);
341 		list($CategoryID, $CategoryRegex)  = $this->functions->_getCategoryFromName($category);
355 …msg($this->functions->_messageReplacer('MasterFileNotInFormat', array($FILE['name'], $CategoryRege…
412 				list($CategoryID, $FileName) = $this->functions->_getCategoryFromName($Category);
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();
440 		msg($this->functions->_messageReplacer('RemovedUserEntries', array($removed, $User)));
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() ) {
485 			$Category = array_shift(array_keys($this->functions->_getCategories($CategoryID, true)));
487 			list($CategoryID, $FileName) = $this->functions->_getCategoryFromName($Category);
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);
557 …      $this->functions->_createMasterTableEntry($translation, $CategoryID, $version, $finalStatus);
561 		    $this->functions->_checkForMasterKeyIDs($translation, $finalStatus, $CategoryID);
562 …    $this->functions->_insertTranslationArray($translation, $finalStatus, $Lang, $currentDateTime);
565 		return $this->functions->_statusResult($finalStatus, $Lang, $FileName);
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()) {
589 …$form = $this->_startFieldSet($this->functions->_messageReplacer('RemoveUserLanguage', $user), 'tr…
599 …$formByDate = $this->_startFieldSet($this->functions->_messageReplacer('RemoveUserLanguageByDate',…
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()) {
658 		if ( !$this->functions =& plugin_load('helper', 'translator') ) {
664 		return $this->functions->init_database(true);