@@ 270-272 (lines=3) @@ | ||
267 | if (false === $parentId && 0 < PMF_String::strlen($_query)) { |
|
268 | $query .= PMF_String::substr($_query, 4); |
|
269 | } |
|
270 | if (isset($this->language) && preg_match("/^[a-z\-]{2,}$/", $this->language)) { |
|
271 | $query .= " AND lang = '".$this->language."'"; |
|
272 | } |
|
273 | $query .= ' ORDER BY id'; |
|
274 | $result = $this->_config->getDb()->query($query); |
|
275 | while ($row = $this->_config->getDb()->fetchArray($result)) { |
|
@@ 295-297 (lines=3) @@ | ||
292 | FROM |
|
293 | %sfaqcategories', |
|
294 | PMF_Db::getTablePrefix()); |
|
295 | if (isset($this->language) && preg_match("/^[a-z\-]{2,}$/", $this->language)) { |
|
296 | $query .= " WHERE lang = '".$this->language."'"; |
|
297 | } |
|
298 | $result = $this->_config->getDb()->query($query); |
|
299 | while ($row = $this->_config->getDb()->fetchArray($result)) { |
|
300 | $this->categories[$row['id']] = $row; |
|
@@ 323-325 (lines=3) @@ | ||
320 | PMF_Db::getTablePrefix() |
|
321 | ); |
|
322 | ||
323 | if (isset($this->language) && preg_match("/^[a-z\-]{2,}$/", $this->language)) { |
|
324 | $query .= sprintf(" WHERE lang = '%s'", $this->language); |
|
325 | } |
|
326 | ||
327 | $result = $this->_config->getDb()->query($query); |
|
328 | ||
@@ 1437-1439 (lines=3) @@ | ||
1434 | FROM |
|
1435 | %sfaqcategories', |
|
1436 | PMF_Db::getTablePrefix()); |
|
1437 | if (isset($this->language) && preg_match("/^[a-z\-]{2,}$/", $this->language)) { |
|
1438 | $query .= " WHERE lang != '".$this->language."'"; |
|
1439 | } |
|
1440 | $query .= ' ORDER BY id'; |
|
1441 | $result = $this->_config->getDb()->query($query); |
|
1442 | while ($row = $this->_config->getDb()->fetchArray($result)) { |