XOOPS /
XoopsCore25
| @@ 397-424 (lines=28) @@ | ||
| 394 | * @param bool $id_as_key return the config's id as key? |
|
| 395 | * @return array Array of {@link XoopsConfigItem} objects |
|
| 396 | */ |
|
| 397 | public function getObjects(CriteriaElement $criteria = null, $id_as_key = false) |
|
| 398 | { |
|
| 399 | $ret = array(); |
|
| 400 | $limit = $start = 0; |
|
| 401 | $sql = 'SELECT * FROM ' . $this->db->prefix('config'); |
|
| 402 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 403 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 404 | $sql .= ' ORDER BY conf_order ASC'; |
|
| 405 | $limit = $criteria->getLimit(); |
|
| 406 | $start = $criteria->getStart(); |
|
| 407 | } |
|
| 408 | $result = $this->db->query($sql, $limit, $start); |
|
| 409 | if (!$result) { |
|
| 410 | return false; |
|
| 411 | } |
|
| 412 | while ($myrow = $this->db->fetchArray($result)) { |
|
| 413 | $config = new XoopsConfigItem(); |
|
| 414 | $config->assignVars($myrow); |
|
| 415 | if (!$id_as_key) { |
|
| 416 | $ret[] =& $config; |
|
| 417 | } else { |
|
| 418 | $ret[$myrow['conf_id']] = &$config; |
|
| 419 | } |
|
| 420 | unset($config); |
|
| 421 | } |
|
| 422 | ||
| 423 | return $ret; |
|
| 424 | } |
|
| 425 | ||
| 426 | /** |
|
| 427 | * Count configs |
|
| @@ 233-259 (lines=27) @@ | ||
| 230 | * |
|
| 231 | * @return array Array of {@link XoopsConfigOption}s |
|
| 232 | */ |
|
| 233 | public function getObjects(CriteriaElement $criteria = null, $id_as_key = false) |
|
| 234 | { |
|
| 235 | $ret = array(); |
|
| 236 | $limit = $start = 0; |
|
| 237 | $sql = 'SELECT * FROM ' . $this->db->prefix('configoption'); |
|
| 238 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 239 | $sql .= ' ' . $criteria->renderWhere() . ' ORDER BY confop_id ' . $criteria->getOrder(); |
|
| 240 | $limit = $criteria->getLimit(); |
|
| 241 | $start = $criteria->getStart(); |
|
| 242 | } |
|
| 243 | $result = $this->db->query($sql, $limit, $start); |
|
| 244 | if (!$result) { |
|
| 245 | return $ret; |
|
| 246 | } |
|
| 247 | while ($myrow = $this->db->fetchArray($result)) { |
|
| 248 | $confoption = new XoopsConfigOption(); |
|
| 249 | $confoption->assignVars($myrow); |
|
| 250 | if (!$id_as_key) { |
|
| 251 | $ret[] =& $confoption; |
|
| 252 | } else { |
|
| 253 | $ret[$myrow['confop_id']] = &$confoption; |
|
| 254 | } |
|
| 255 | unset($confoption); |
|
| 256 | } |
|
| 257 | ||
| 258 | return $ret; |
|
| 259 | } |
|
| 260 | } |
|
| 261 | ||
| @@ 257-283 (lines=27) @@ | ||
| 254 | * @param bool $id_as_key return the tplsets id as key? |
|
| 255 | * @return array Array of {@link XoopsTplset} objects |
|
| 256 | */ |
|
| 257 | public function getObjects(CriteriaElement $criteria = null, $id_as_key = false) |
|
| 258 | { |
|
| 259 | $ret = array(); |
|
| 260 | $limit = $start = 0; |
|
| 261 | $sql = 'SELECT * FROM ' . $this->db->prefix('tplset'); |
|
| 262 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 263 | $sql .= ' ' . $criteria->renderWhere() . ' ORDER BY tplset_id'; |
|
| 264 | $limit = $criteria->getLimit(); |
|
| 265 | $start = $criteria->getStart(); |
|
| 266 | } |
|
| 267 | $result = $this->db->query($sql, $limit, $start); |
|
| 268 | if (!$result) { |
|
| 269 | return $ret; |
|
| 270 | } |
|
| 271 | while ($myrow = $this->db->fetchArray($result)) { |
|
| 272 | $tplset = new XoopsTplset(); |
|
| 273 | $tplset->assignVars($myrow); |
|
| 274 | if (!$id_as_key) { |
|
| 275 | $ret[] =& $tplset; |
|
| 276 | } else { |
|
| 277 | $ret[$myrow['tplset_id']] =& $tplset; |
|
| 278 | } |
|
| 279 | unset($tplset); |
|
| 280 | } |
|
| 281 | ||
| 282 | return $ret; |
|
| 283 | } |
|
| 284 | ||
| 285 | /** |
|
| 286 | * Count tplsets |
|
| @@ 227-253 (lines=27) @@ | ||
| 224 | * @param bool $id_as_key should the groups' IDs be used as keys for the associative array? |
|
| 225 | * @return mixed Array of groups |
|
| 226 | */ |
|
| 227 | public function getObjects(CriteriaElement $criteria = null, $id_as_key = false) |
|
| 228 | { |
|
| 229 | $ret = array(); |
|
| 230 | $limit = $start = 0; |
|
| 231 | $sql = 'SELECT * FROM ' . $this->db->prefix('groups'); |
|
| 232 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 233 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 234 | $limit = $criteria->getLimit(); |
|
| 235 | $start = $criteria->getStart(); |
|
| 236 | } |
|
| 237 | $result = $this->db->query($sql, $limit, $start); |
|
| 238 | if (!$result) { |
|
| 239 | return $ret; |
|
| 240 | } |
|
| 241 | while ($myrow = $this->db->fetchArray($result)) { |
|
| 242 | $group = new XoopsGroup(); |
|
| 243 | $group->assignVars($myrow); |
|
| 244 | if (!$id_as_key) { |
|
| 245 | $ret[] =& $group; |
|
| 246 | } else { |
|
| 247 | $ret[$myrow['groupid']] = &$group; |
|
| 248 | } |
|
| 249 | unset($group); |
|
| 250 | } |
|
| 251 | ||
| 252 | return $ret; |
|
| 253 | } |
|
| 254 | } |
|
| 255 | ||
| 256 | /** |
|
| @@ 412-438 (lines=27) @@ | ||
| 409 | * @param bool $id_as_key should the ID be used as the array's key? |
|
| 410 | * @return array array of references |
|
| 411 | */ |
|
| 412 | public function getObjects(CriteriaElement $criteria = null, $id_as_key = false) |
|
| 413 | { |
|
| 414 | $ret = array(); |
|
| 415 | $limit = $start = 0; |
|
| 416 | $sql = 'SELECT * FROM ' . $this->db->prefix('groups_users_link'); |
|
| 417 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 418 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 419 | $limit = $criteria->getLimit(); |
|
| 420 | $start = $criteria->getStart(); |
|
| 421 | } |
|
| 422 | $result = $this->db->query($sql, $limit, $start); |
|
| 423 | if (!$result) { |
|
| 424 | return $ret; |
|
| 425 | } |
|
| 426 | while ($myrow = $this->db->fetchArray($result)) { |
|
| 427 | $mship = new XoopsMembership(); |
|
| 428 | $mship->assignVars($myrow); |
|
| 429 | if (!$id_as_key) { |
|
| 430 | $ret[] =& $mship; |
|
| 431 | } else { |
|
| 432 | $ret[$myrow['linkid']] = &$mship; |
|
| 433 | } |
|
| 434 | unset($mship); |
|
| 435 | } |
|
| 436 | ||
| 437 | return $ret; |
|
| 438 | } |
|
| 439 | ||
| 440 | /** |
|
| 441 | * count how many memberships meet the conditions |
|
| @@ 245-271 (lines=27) @@ | ||
| 242 | * |
|
| 243 | * @return array Array of {@link XoopsGroupPerm}s |
|
| 244 | */ |
|
| 245 | public function getObjects(CriteriaElement $criteria = null, $id_as_key = false) |
|
| 246 | { |
|
| 247 | $ret = array(); |
|
| 248 | $limit = $start = 0; |
|
| 249 | $sql = 'SELECT * FROM ' . $this->db->prefix('group_permission'); |
|
| 250 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 251 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 252 | $limit = $criteria->getLimit(); |
|
| 253 | $start = $criteria->getStart(); |
|
| 254 | } |
|
| 255 | $result = $this->db->query($sql, $limit, $start); |
|
| 256 | if (!$result) { |
|
| 257 | return $ret; |
|
| 258 | } |
|
| 259 | while ($myrow = $this->db->fetchArray($result)) { |
|
| 260 | $perm = new XoopsGroupPerm(); |
|
| 261 | $perm->assignVars($myrow); |
|
| 262 | if (!$id_as_key) { |
|
| 263 | $ret[] =& $perm; |
|
| 264 | } else { |
|
| 265 | $ret[$myrow['gperm_id']] =& $perm; |
|
| 266 | } |
|
| 267 | unset($perm); |
|
| 268 | } |
|
| 269 | ||
| 270 | return $ret; |
|
| 271 | } |
|
| 272 | ||
| 273 | /** |
|
| 274 | * Count some {@link XoopsGroupPerm}s |
|
