예제 #1
0
 /**
  * This function replaces a string identifier <var>$prefix</var> with the
  * string held is the <var>_table_prefix</var> class variable.
  *
  * @param   string    The SQL query
  * @param   string    The common table prefix
  *
  * @return  string
  */
 public function replacePrefix($sql, $prefix = '#__')
 {
     $app = JFactory::getApplication();
     $package = $app->getUserStateFromRequest('com_fabrik.package', 'package', 'fabrik', 'cmd');
     $sql = str_replace('{package}', $package, $sql);
     return parent::replacePrefix($sql, $prefix);
 }
예제 #2
0
 /**
  * Execute the SQL statement.
  *
  * @param   boolean  $replacePrefixQuotes  Replace the prefixes inside the quotes too
  *
  * @return  mixed  A database cursor resource on success, boolean false on failure.
  *
  * @since   12.1
  * @throws  RuntimeException
  */
 public function execute($replacePrefixQuotes = false)
 {
     if ($replacePrefixQuotes) {
         $this->sql = $this->replacePrefix((string) $this->sql, '#__', $replacePrefixQuotes);
     }
     return parent::execute();
 }
예제 #3
0
 /**
  * Get the generic name of the table, converting the database prefix to the wildcard string.
  *
  * @param   string  $table	The name of the table.
  *
  * @return  string  The name of the table with the database prefix replaced with #__.
  * @since   11.1
  */
 protected function getGenericTableName($table)
 {
     // TODO Incorporate into parent class and use $this.
     $prefix = $this->db->getPrefix();
     // Replace the magic prefix if found.
     $table = preg_replace("|^{$prefix}|", '#__', $table);
     return $table;
 }
예제 #4
0
 /**
  * Build where like conditions from strings with spaces
  * @param string $value
  * @param string $fieldName
  * @return string
  */
 protected function _buildLikeBySpaces($value, $fieldName)
 {
     $values = $this->_separateValue($value);
     foreach ($values as $key => $value) {
         $values[$key] = $this->_db->quote('%' . $value . '%');
     }
     return '(' . $fieldName . ' LIKE ' . implode(' AND ' . $fieldName . ' LIKE ', $values) . ' )';
 }
예제 #5
0
 /**
  * Load log types and prepare them as an array with options.
  *
  * <code>
  * $filters    = new CrowdFundingFilters(JFactory::getDbo());
  * $options = $filters->getLogTypes();
  * </code>
  *
  * @return array
  */
 public function getLogTypes()
 {
     $query = $this->db->getQuery(true);
     $query->select("a.type AS value, a.type AS text")->from($this->db->quoteName("#__crowdf_logs", "a"))->group("a.type");
     $this->db->setQuery($query);
     $types = $this->db->loadAssocList();
     if (!$types) {
         $types = array();
     }
     return $types;
 }
예제 #6
0
 /**
  * Returns all rows of given table
  * @param string $table
  * @throws SPException
  * @return array
  */
 public function getColumns($table)
 {
     static $cache = array();
     if (!isset($cache[$table])) {
         $this->setQuery("SHOW COLUMNS FROM {$table}");
         try {
             $cache[$table] = $this->loadResultArray();
         } catch (Exception $e) {
         }
         if ($this->db->getErrorNum()) {
             throw new SPException($this->db->stderr());
         }
     }
     return $cache[$table];
 }
예제 #7
0
 /**
  * Merges the incoming structure definition with the existing structure.
  *
  * @return  void
  *
  * @since   11.1
  * 
  * @throws  Exception on error.
  * @note    Currently supports XML format only.
  * @todo    IF it is not in XML format, convert it first.
  */
 protected function mergeStructure()
 {
     // Currently only support XML format anyway.
     // Initialise variables.
     $prefix = $this->db->getPrefix();
     $tables = $this->db->getTableList();
     $result = true;
     if ($this->from instanceof SimpleXMLElement) {
         $xml = $this->from;
     } else {
         $xml = new SimpleXMLElement($this->from);
     }
     // Get all the table definitions.
     $xmlTables = $xml->xpath('database/table_structure');
     foreach ($xmlTables as $table) {
         // Convert the magic prefix into the real table name.
         $tableName = (string) $table['name'];
         $tableName = preg_replace('|^#__|', $prefix, $tableName);
         if (in_array($tableName, $tables)) {
             // The table already exists. Now check if there is any difference.
             if ($queries = $this->getAlterTableSQL($xml->database->table_structure)) {
                 // Run the queries to upgrade the data structure.
                 foreach ($queries as $query) {
                     $this->db->setQuery((string) $query);
                     if (!$this->db->query()) {
                         $this->addLog('Fail: ' . $this->db->getQuery());
                         throw new Exception($this->db->getErrorMsg());
                     } else {
                         $this->addLog('Pass: '******'Fail: ' . $this->db->getQuery());
                 throw new Exception($this->db->getErrorMsg());
             } else {
                 $this->addLog('Pass: ' . $this->db->getQuery());
             }
         }
     }
 }
예제 #8
0
파일: mysqli.php 프로젝트: Fellah/govnobaki
 /**
  * Execute a batch query
  *
  * @abstract
  * @access public
  * @return mixed A database resource if successful, FALSE if not.
  */
 function query_batch($abort_on_error = true, $p_transaction_safe = false)
 {
     return parent::queryBatch($abort_on_error, $p_transaction_safe);
 }
 public function query()
 {
     $sql = is_a($this->sql, "JDatabaseQueryMySQLi") ? (string) $this->sql : $this->sql;
     if ($this->skipjf) {
         return parent::query();
     }
     if ($this->translate === false || !stristr($sql, 'SELECT')) {
         return parent::query();
     }
     $jfmCount = 0;
     $jfManager = JoomFishManager::getInstance();
     $defaultlang = $jfManager->getDefaultLanguage();
     if (is_a($this->sql, "JDatabaseQueryMySQLi") && !isset($this->sql->jfprocessed) && ($this->sql->where !== null && is_a($this->sql->where, "JDatabaseQueryElement"))) {
         $elements = $this->sql->where->getElements();
         foreach ($elements as &$element) {
             if (strstr($element, 'language')) {
                 //str_ireplace("\,\'\*\'", "\,\'\*\',\'".$defaultlang."'", $value);
                 $element = str_ireplace(",'*'", ",'*','" . $defaultlang . "'", $element);
                 $jfmCount++;
             }
         }
         $this->sql->clear('where');
         $this->sql->where($elements);
     }
     $tablewithprefix = $this->getTableName();
     $table = str_ireplace('#__', '', $tablewithprefix);
     //$key = $jfManager->getPrimaryKey($table);   obsolete
     $ce = $jfManager->getContentElement($table);
     $key = is_object($ce) ? $ce->getReferenceId() : false;
     $isnative = is_object($ce) && $ce->getTarget() == 'native' ? true : false;
     // last check - do we have content element for this and is this table native??
     if ($key === false || $isnative === false) {
         return parent::query();
     }
     if ($this->translate === true && is_a($this->sql, "JDatabaseQueryMySQLi") && !isset($this->sql->jfprocessed) && ($this->sql->select !== null && is_a($this->sql->select, "JDatabaseQueryElement"))) {
         $elements2 = $this->sql->select->getElements();
         $keyfound = false;
         $asfound = false;
         foreach ($elements2 as $element2) {
             // is there id column or * in the select query
             if (stristr($element2, ' ' . $key . ' ') || stristr($element2, ',' . $key) || stristr($element2, ' ' . $key . ',') || strstr($element2, '*') || stristr($element2, '.' . $key . ',') || stristr($element2, ' ' . $key . ' ,') || stristr($element2, '.' . $key . ' ,')) {
                 $keyfound = true;
             }
             // is any column named as soemthing else or has table prepended, then do join
             if (preg_match('/FROM(.*?) AS/is', $element2) || stristr($element2, '.')) {
                 $asfound = true;
             }
         }
         if ($keyfound === false && $asfound == true) {
             // OUR JOIN NEEDS TO BE FIRST FOR "USING" TO WORK PROPERLY
             if (is_array($this->sql->join)) {
                 $joinelements = array();
                 $joinprevious = $this->sql->join;
                 $this->sql->clear('join');
                 $this->sql->innerJoin($tablewithprefix . ' AS jfself USING (' . $key . ')');
                 foreach ($joinprevious as $joinprev) {
                     $name = JoomlaProtectedFixDatabaseQueryElement::getInstance($joinprev)->get('name');
                     $type = str_ireplace(' JOIN', '', $name);
                     $elements = $joinprev->getElements();
                     $this->sql->join($type, $elements);
                 }
             } else {
                 $this->sql->innerJoin($tablewithprefix . ' AS jfself USING (' . $key . ')');
             }
             $this->sql->select('jfself.' . $key . ' AS ' . $key);
             $jfmCount++;
         } else {
             if ($keyfound === false && $asfound === false) {
                 $this->sql->select($key);
                 $jfmCount++;
             }
         }
     } else {
         if ($this->translate === true && is_string($this->sql) && !isset($this->sql->jfprocessed) && stristr($this->sql, 'SELECT') && stristr($this->sql, 'FROM')) {
             $keyfound = false;
             $asfound = false;
             preg_match('/SELECT(.*?)FROM/is', $this->sql, $selectstring);
             $selectstring = $selectstring[0];
             if (stristr($selectstring, ' ' . $key . ' ') || stristr($selectstring, ',' . $key) || stristr($selectstring, ' ' . $key . ',') || strstr($selectstring, '*') || stristr($selectstring, '.' . $key . ',') || stristr($selectstring, ' ' . $key . ' ,') || stristr($selectstring, '.' . $key . ' ,')) {
                 $keyfound = true;
             }
             if (preg_match('/FROM(.*?) AS/is', $selectstring) || stristr($selectstring, '.')) {
                 $asfound = true;
             }
             if ($keyfound === false && $asfound == true) {
                 //$this->sql = preg_replace('/SELECT(.*?)FROM/i', 'SELECT '. $selectstring . ', jfself.'.$key.' AS '.$key .' FROM', $this->sql  );
                 $this->sql = preg_replace('/SELECT /i', 'SELECT jfself.' . $key . ' AS ' . $key . ', ', $this->sql, 1);
                 //make sure our join comes first
                 $replacejoin = preg_match('/( left| right| inner| outer| join| where)/i', $this->sql, $matches);
                 if ($replacejoin) {
                     $this->sql = preg_replace('/( left| right| inner| outer| join| where)/i', ' JOIN ' . $tablewithprefix . ' AS jfself USING (' . $key . ') ' . $matches[0], $this->sql, 1);
                 } else {
                     $this->sql .= ' JOIN ' . $tablewithprefix . ' AS jfself USING (' . $key . ') ';
                 }
                 $jfmCount++;
             } else {
                 if ($keyfound === false && $asfound === false) {
                     //$this->sql = preg_replace('/SELECT /i', 'SELECT '.$key. ', ', $this->sql, 1);
                     $this->sql = preg_replace('/ FROM/is', ',' . $key . ' FROM', $this->sql, 1);
                     $jfmCount++;
                 }
             }
         }
     }
     // NEW SYSTEM disabled for now - the query handling for joins etc. is too complex
     /*if (false && is_a($this->sql, "JDatabaseQuery") && !isset($this->sql->jfprocessed))
     		{
     			// Do the from first
     			$sql = $this->replacePrefix((string) $this->sql);
     			//$jfManager = JoomFishManager::getInstance();
     			//$contentElements = $jfManager->getContentElements( );
     			// search for
     			// AND a.language in \(.*,\*\) using regexp !
     			// Before joomfish manager is created since we can't translate so skip this anaylsis
     			$jfManager = JoomFishManager::getInstance();
     			if (!$jfManager)
     				return;
     			$language = false;
     			if (isset($jfManager))
     			{
     				$this->setLanguage($language);
     			}
     			$from = $this->sql->from;
     			$joins = $this->sql->join;
     			if ($from || $join)
     			{
     				$joinElements = array();
     				if ($joins){
     					foreach ($joins as $join) {
     						 $joinElements = array_merge($joinElements, $join->getElements() );
     					}
     				}
     				$fromElements = $from->getElements();
     				if ($fromElements)
     				{
     					foreach ($fromElements as $fromElement)
     					{
     						// remove surplus spaces
     						$fromElement = preg_replace('/\s{2}/', '', $fromElement);
     						$fromElement = preg_replace('/' . $this->getPrefix() . '/', '', $fromElement);
     						$fromElement = preg_replace('/#__/', '', $fromElement);
     						$parts = explode(" ", $fromElement);
     						$table = trim($parts[0]);
     						//if ($this->translatedContentAvailable($table))
     						// TODO need new translatedContentAvailable method !
     						// This is the mapping table method!!
     						// NEW SYSTEM
     						if (in_array($table,array("menu", "content", "modules",  "categories")))
     						//if (in_array($table,array("content",  "categories")))
     						{
     							$alias = trim($parts[count($parts) - 1]);
     							$jfalias = 'jftm' . $jfmCount;
     							$jfmCount++;
     							// TODO needs to get primary key for this table not assume it is id
     							$this->sql->leftJoin("#__jf_translationmap AS $jfalias ON $jfalias.reference_table = " . $this->quote($table) . "   AND $jfalias.reference_id = $alias.id AND $jfalias.language= " . $this->quote($language));
     							$this->sql->where(" $jfalias.reference_id IS NULL ");
     						}
     					}
     				}
     			}
     			if ($jfmCount>0){
     				$this->sql->jfprocessed = true;
     			}
     		} */
     $sqlfinal = is_a($this->sql, "JDatabaseQueryMySQLi") ? (string) $this->sql : $this->sql;
     $result = parent::query();
     /*if ($jfmCount>0){
     			$this->sql->jfprocessed = true;
     		}*/
     return $result;
 }
예제 #10
0
 /**
  * Test Test method - there really isn't a lot to test here, but
  * this is present for the sake of completeness
  */
 public function testTest()
 {
     $this->assertThat(JDatabaseMySQLi::test(), $this->isTrue(), __LINE__);
 }