Lines Matching refs:database
25 var $database = null; variable in helper_plugin_translator
92 if ( empty($this->database) ) {
103 $this->database->query("SHOW TABLES LIKE \"$tableName\";");
107 if ( $this->database->num_rows() != 1 ) {
109 $this->database->prepare($sqlStatement['statement']);
110 $this->database->execute();
114 $table = $this->database->databaseConnection->escape_string($tableName);
115 $this->database->prepare("SHOW COLUMNS FROM `$table`");
116 $this->database->execute();
118 if ( $this->database->num_rows() >= count($sqlStatement['fields']) ) {
121 $data = array(); $this->database->bind_assoc($data);
122 while ( $this->database->fetch() ) {
144 if ( empty($this->database) ) {
145 … if ( !$this->database =& plugin_load('helper', 'databaseconnector', true) ) { return false;}
147 $this->database->setType($this->getConf('DBType'));
148 …if ( $this->database->connect($this->getConf('DBName'), $this->getConf('DBUserName'), $this->getCo…
157 if ( !empty($this->database) ) {
158 $this->database->close();
159 $this->database = null;
178 $this->database->prepare("SELECT KeyID FROM tblMasterKey WHERE MD5KeyVal=?;");
179 $this->database->execute($HASHKEY);
181 if ( $this->database->num_rows() == 0 ) {
184 …$this->database->prepare("SELECT tblMasterKey.KeyID FROM tblMaster LEFT JOIN tblMasterKey ON tblMa…
185 $this->database->execute($key, $categoryID);
186 if ( $this->database->num_rows() > 0 ) {
187 $data = array(); $this->database->bind_assoc($data); $this->database->fetch();
191 … $this->database->prepare("UPDATE tblMasterKey SET Value=?, Md5KeyVal=? WHERE KeyID=?;");
192 $this->database->execute($value, $HASHKEY, $KeyID);
195 …$this->database->prepare("INSERT INTO tblMasterKey (ResourceKey, Value, Md5KeyVal) VALUES(?, ?, ?)…
196 $this->database->execute($key, $value, $HASHKEY);
197 $KeyID = $this->database->insert_id();
201 $data = array(); $this->database->bind_assoc($data); $this->database->fetch();
205 …$this->database->prepare("SELECT KeyID FROM tblMaster WHERE KeyID=? AND CategoryID=? AND Version=?…
206 $this->database->execute($KeyID, $categoryID, $version);
207 if ( $this->database->num_rows() > 0 ) {
214 … $this->database->prepare("INSERT INTO tblMaster (KeyID, CategoryID, Version) VALUES(?, ?, ?);");
215 $this->database->execute($KeyID, $categoryID, $version);
250 $this->database->prepare("SELECT Name, CategoryID, FileName FROM tblCategory $additional;");
251 $this->database->execute($execute);
253 if ( $this->database->num_rows() == 0 ) {
257 $data = array(); $this->database->bind_assoc($data);
258 while ( $this->database->fetch() ) {
282 $this->database->prepare($SQL);
283 $this->database->execute($categoryID);
285 $languages = array(); $data = array(); $this->database->bind_assoc($data);
286 while ( $this->database->fetch() ) {
310 …$this->database->prepare("SELECT Lang FROM tblTranslation INNER JOIN tblMaster ON tblMaster.KeyID=…
311 $this->database->execute($EXECUTE);
313 $data = array(); $this->database->bind_assoc($data);
314 while ( $this->database->fetch() ) {
334 $this->database->prepare("SELECT Version FROM tblMaster $ADDITIONAL GROUP BY Version;");
335 $this->database->execute($EXECUTE);
337 $data = array(); $this->database->bind_assoc($data);
338 while ( $this->database->fetch() ) {
376 …$this->database->prepare("SELECT DISTINCT tblMasterKey.KeyID, Value FROM tblMasterKey INNER JOIN t…
377 $this->database->execute($CategoryID, $KeyName);
379 if ( $this->database->num_rows() > 0 ) {
380 $data = array(); $this->database->bind_assoc($data); $this->database->fetch();
403 $this->database->prepare($SQL);
404 $this->database->execute($CategoryID);
406 $data = array(); $this->database->bind_assoc($data);
407 while ( $this->database->fetch() ) {
439 $this->database->prepare("$SQL;");
440 $this->database->execute($execute);
442 if ( $this->database->num_rows() == 0 ) {
473 …$this->database->prepare("INSERT INTO tblTranslation (KeyID, Lang, Value, User, Date) VALUES(?, ?,…
474 $this->database->execute($KeyID, $Lang, $Value, $User, $Date);
500 $this->database->prepare($SQL);
501 $this->database->execute($Lang);
503 $data = array(); $this->database->bind_assoc($data);
504 while ( $this->database->fetch() ) {
535 …$this->database->prepare("INSERT INTO tblTranslation (KeyID, Lang, Value, User, Date) VALUES $INSE…
536 $this->database->execute($INSERTDATA);
545 …$this->database->prepare("SELECT ResourceKey, Value FROM tblMasterKey INNER JOIN tblMaster ON tblM…
546 $this->database->execute($Version, $CategoryID);
548 …$this->database->prepare("SELECT tblMasterKey.ResourceKey, tblTrans.Value FROM (tblMasterKey INNER…
549 $this->database->execute($Version, $CategoryID, $Language);
553 $data = array(); $this->database->bind_assoc($data);
554 while ( $this->database->fetch() ) {
568 $this->database->prepare("DELETE FROM tblTranslation WHERE Date=? AND Lang=? AND User=?;");
569 $this->database->execute($dateTime, $lang, $user);
571 return $this->database->num_rows();
717 $this->database->prepare("$SQL");
718 $this->database->execute(array_merge($EXECUTE, array('1000000000000', '0')));
719 $max = $this->database->num_rows();
725 $this->database->execute($EXECUTE);
727 if ( $this->database->num_rows() == 0 ) {
731 $data = array(); $this->database->bind_assoc($data);
732 while ( $this->database->fetch() ) {
761 $this->database->prepare("SELECT Lang FROM tblUserRights WHERE User=?");
762 $this->database->execute($_SERVER['REMOTE_USER']);
764 if ( $this->database->num_rows() == 0) {
768 $data = array(); $this->database->bind_assoc($data); $this->database->fetch();
1067 $this->database->prepare($SQL);
1068 $this->database->execute($language, $key, $user);
1069 $data = array(); $this->database->bind_assoc($data); $this->database->fetch();
1075 $this->database->prepare("DELETE FROM tblTranslation WHERE User=? AND Lang=? $ADDITIONAL");
1076 $this->database->execute($EXECUTE);
1078 return $this->database->num_rows();
1134 …$this->database->prepare("SELECT COUNT(tblMaster.KeyID) as amount FROM tblMasterKey INNER JOIN tbl…
1135 $this->database->execute($EXECUTE);
1137 $data=array(); $this->database->bind_assoc($data); $this->database->fetch();
1148 $this->database->prepare($SQL);
1149 $this->database->execute($lang, $categoryID, $version);
1151 $data=array(); $this->database->bind_assoc($data); $this->database->fetch();
1220 $this->database->databaseConnection->query("SET NAMES 'utf8' COLLATE 'utf8_general_ci'");
1221 $this->database->databaseConnection->query("SET CHARACTER SET 'utf8'");