342 $conf_formtype =
null;
343 $conf_valuetype =
null;
346 if (
'xoopsconfigitem' != strtolower(get_class($config))) {
349 if (!$config->isDirty()) {
352 if (!$config->cleanVars()) {
355 foreach ($config->cleanVars as $k => $v) {
359 if ($config->isNew()) {
360 $conf_id = $db->genId(
'config_conf_id_seq');
361 $sql = sprintf(
'INSERT INTO %s (conf_id, conf_modid, conf_catid, conf_name, conf_title, conf_value, conf_desc, conf_formtype, conf_valuetype, conf_order) VALUES (%u, %u, %u, %s, %s, %s, %s, %s, %s, %u)', $db->prefix(
'config'), $conf_id, $conf_modid, $conf_catid, $db->quoteString($conf_name), $db->quoteString($conf_title), $db->quoteString($conf_value), $db->quoteString($conf_desc), $db->quoteString($conf_formtype), $db->quoteString($conf_valuetype), $conf_order);
363 $sql = sprintf(
'UPDATE %s SET conf_modid = %u, conf_catid = %u, conf_name = %s, conf_title = %s, conf_value = %s, conf_desc = %s, conf_formtype = %s, conf_valuetype = %s, conf_order = %u WHERE conf_id = %u', $db->prefix(
'config'), $conf_modid, $conf_catid, $db->quoteString($conf_name), $db->quoteString($conf_title), $db->quoteString($conf_value), $db->quoteString($conf_desc), $db->quoteString($conf_formtype), $db->quoteString($conf_valuetype), $conf_order, $conf_id);
365 if (!$result = $db->query($sql)) {
368 if (empty($conf_id)) {
369 $conf_id = $db->getInsertId();
371 $config->assignVar(
'conf_id', $conf_id);
400 public function &
getObjects($criteria =
null, $id_as_key =
false)
405 $sql =
'SELECT * FROM '.$db->prefix(
'config');
406 if (isset($criteria) && $criteria instanceof \criteriaelement) {
407 $sql .=
' '.$criteria->renderWhere();
408 $sql .=
' ORDER BY conf_order ASC';
409 $limit = $criteria->getLimit();
410 $start = $criteria->getStart();
412 $result = $db->query($sql, $limit, $start);
416 while ($myrow = $db->fetchArray($result)) {
418 $config->assignVars($myrow);
422 $ret[$myrow[
'conf_id']] =& $config;