@@ 278-280 (lines=3) @@ | ||
275 | if (false === $parentId && 0 < PMF_String::strlen($_query)) { |
|
276 | $query .= PMF_String::substr($_query, 4); |
|
277 | } |
|
278 | if (isset($this->language) && preg_match("/^[a-z\-]{2,}$/", $this->language)) { |
|
279 | $query .= " AND lang = '".$this->language."'"; |
|
280 | } |
|
281 | $query .= ' ORDER BY id'; |
|
282 | $result = $this->_config->getDb()->query($query); |
|
283 | while ($row = $this->_config->getDb()->fetchArray($result)) { |
|
@@ 303-305 (lines=3) @@ | ||
300 | FROM |
|
301 | %sfaqcategories', |
|
302 | PMF_Db::getTablePrefix()); |
|
303 | if (isset($this->language) && preg_match("/^[a-z\-]{2,}$/", $this->language)) { |
|
304 | $query .= " WHERE lang = '".$this->language."'"; |
|
305 | } |
|
306 | $result = $this->_config->getDb()->query($query); |
|
307 | while ($row = $this->_config->getDb()->fetchArray($result)) { |
|
308 | $this->categories[$row['id']] = [ |
|
@@ 341-343 (lines=3) @@ | ||
338 | PMF_Db::getTablePrefix() |
|
339 | ); |
|
340 | ||
341 | if (isset($this->language) && preg_match("/^[a-z\-]{2,}$/", $this->language)) { |
|
342 | $query .= sprintf(" WHERE lang = '%s'", $this->language); |
|
343 | } |
|
344 | ||
345 | $result = $this->_config->getDb()->query($query); |
|
346 | ||
@@ 1460-1462 (lines=3) @@ | ||
1457 | FROM |
|
1458 | %sfaqcategories', |
|
1459 | PMF_Db::getTablePrefix()); |
|
1460 | if (isset($this->language) && preg_match("/^[a-z\-]{2,}$/", $this->language)) { |
|
1461 | $query .= " WHERE lang != '".$this->language."'"; |
|
1462 | } |
|
1463 | $query .= ' ORDER BY id'; |
|
1464 | $result = $this->_config->getDb()->query($query); |
|
1465 | while ($row = $this->_config->getDb()->fetchArray($result)) { |