|
@@ 170-178 (lines=9) @@
|
| 167 |
|
$criteria->setOrder($order); |
| 168 |
|
|
| 169 |
|
$sql = 'SELECT * FROM '.$this->db->prefix('mimetypes'); |
| 170 |
|
if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
| 171 |
|
$sql .= ' '.$criteria->renderWhere(); |
| 172 |
|
if ($criteria->getSort() != '') { |
| 173 |
|
$sql .= ' ORDER BY '.$criteria->getSort().' '.$criteria->getOrder(); |
| 174 |
|
} |
| 175 |
|
|
| 176 |
|
$limit = $criteria->getLimit(); |
| 177 |
|
$start = $criteria->getStart(); |
| 178 |
|
} |
| 179 |
|
|
| 180 |
|
$result = $this->db->query($sql, $limit, $start); |
| 181 |
|
if (!$result) { |
|
@@ 300-307 (lines=8) @@
|
| 297 |
|
$ret = array(); |
| 298 |
|
$limit = $start = 0; |
| 299 |
|
$sql = 'SELECT * FROM '.$this->db->prefix('mimetypes'); |
| 300 |
|
if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
| 301 |
|
$sql .= ' '.$criteria->renderWhere(); |
| 302 |
|
if ($criteria->getSort() != '') { |
| 303 |
|
$sql .= ' ORDER BY '.$criteria->getSort().' '.$criteria->getOrder(); |
| 304 |
|
} |
| 305 |
|
$limit = $criteria->getLimit(); |
| 306 |
|
$start = $criteria->getStart(); |
| 307 |
|
} |
| 308 |
|
$result = $this->db->query($sql, $limit, $start); |
| 309 |
|
if (!$result) { |
| 310 |
|
return $ret; |
|
@@ 510-517 (lines=8) @@
|
| 507 |
|
$this->db->prefix("mimetypes") . ' t on p.mperm_mime = t.mime_id LEFT JOIN ' . |
| 508 |
|
$this->db->prefix("modules") . ' m on p.mperm_module = m.mid'; |
| 509 |
|
|
| 510 |
|
if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
| 511 |
|
$sql .= ' '.$criteria->renderWhere() . $criteria->getGroupby(); |
| 512 |
|
if ($criteria->getSort() != '') { |
| 513 |
|
$sql .= ' ORDER BY '.$criteria->getSort().' '.$criteria->getOrder(); |
| 514 |
|
} |
| 515 |
|
$limit = $criteria->getLimit(); |
| 516 |
|
$start = $criteria->getStart(); |
| 517 |
|
} |
| 518 |
|
|
| 519 |
|
$result = $this->db->query($sql, $limit, $start); |
| 520 |
|
if (!$result) { |
XoopsModules25x /
xoopsinfo
