function xoops_debug_vardump($var) { if (class_exists('MyTextSanitizer')) { $myts = MyTextSanitizer::getInstance(); xoops_debug($myts->displayTarea(var_export($var, true))); } else { xoops_debug(var_export($var, true)); } }
/** * insert a new object in the database * * @param object $obj reference to the object * @param bool $force whether to force the query execution despite security settings * @param bool $checkObject check if the object is dirty and clean the attributes * @return bool FALSE if failed, TRUE if already present and unchanged or successful */ function insert(&$obj, $force = false, $checkObject = true, $debug = false) { if ($checkObject != false) { if (!is_object($obj)) { return false; } /** * @TODO: Change to if (!(class_exists($this->className) && $obj instanceof $this->className)) when going fully PHP5 */ if (!is_a($obj, $this->className)) { $obj->setError(get_class($obj) . " Differs from " . $this->className); return false; } if (!$obj->isDirty()) { $obj->setErrors("Not dirty"); //will usually not be outputted as errors are not displayed when the method returns true, but it can be helpful when troubleshooting code - Mith return true; } } if ($obj->seoEnabled) { // Auto create meta tags if empty $smartobject_metagen = new SmartMetagen($obj->title(), $obj->getVar('meta_keywords'), $obj->summary()); if (!$obj->getVar('meta_keywords') || !$obj->getVar('meta_description')) { if (!$obj->meta_keywords()) { $obj->setVar('meta_keywords', $smartobject_metagen->_keywords); } if (!$obj->meta_description()) { $obj->setVar('meta_description', $smartobject_metagen->_meta_description); } } // Auto create short_url if empty if (!$obj->short_url()) { $obj->setVar('short_url', $smartobject_metagen->generateSeoTitle($obj->title('n'), false)); } } $eventResult = $this->executeEvent('beforeSave', $obj); if (!$eventResult) { $obj->setErrors("An error occured during the BeforeSave event"); return false; } if ($obj->isNew()) { $eventResult = $this->executeEvent('beforeInsert', $obj); if (!$eventResult) { $obj->setErrors("An error occured during the BeforeInsert event"); return false; } } else { $eventResult = $this->executeEvent('beforeUpdate', $obj); if (!$eventResult) { $obj->setErrors("An error occured during the BeforeUpdate event"); return false; } } if (!$obj->cleanVars()) { $obj->setErrors('Variables were not cleaned properly.'); return false; } $fieldsToStoreInDB = array(); foreach ($obj->cleanVars as $k => $v) { if ($obj->vars[$k]['data_type'] == XOBJ_DTYPE_INT) { $cleanvars[$k] = intval($v); } elseif (is_array($v)) { $cleanvars[$k] = $this->db->quoteString(implode(',', $v)); } else { $cleanvars[$k] = $this->db->quoteString($v); } if ($obj->vars[$k]['persistent']) { $fieldsToStoreInDB[$k] = $cleanvars[$k]; } } if ($obj->isNew()) { if (!is_array($this->keyName)) { if ($cleanvars[$this->keyName] < 1) { $cleanvars[$this->keyName] = $this->db->genId($this->table . '_' . $this->keyName . '_seq'); } } $sql = "INSERT INTO " . $this->table . " (" . implode(',', array_keys($fieldsToStoreInDB)) . ") VALUES (" . implode(',', array_values($fieldsToStoreInDB)) . ")"; } else { $sql = "UPDATE " . $this->table . " SET"; foreach ($fieldsToStoreInDB as $key => $value) { if (!is_array($this->keyName) && $key == $this->keyName || is_array($this->keyName) && in_array($key, $this->keyName)) { continue; } if (isset($notfirst)) { $sql .= ","; } $sql .= " " . $key . " = " . $value; $notfirst = true; } if (is_array($this->keyName)) { $whereclause = ""; for ($i = 0; $i < count($this->keyName); $i++) { if ($i > 0) { $whereclause .= " AND "; } $whereclause .= $this->keyName[$i] . " = " . $obj->getVar($this->keyName[$i]); } } else { $whereclause = $this->keyName . " = " . $obj->getVar($this->keyName); } $sql .= " WHERE " . $whereclause; } if ($debug) { xoops_debug($sql); } if (false != $force) { $result = $this->db->queryF($sql); } else { $result = $this->db->query($sql); } if (!$result) { $obj->setErrors($this->db->error()); return false; } if ($obj->isNew() && !is_array($this->keyName)) { $obj->assignVar($this->keyName, $this->db->getInsertId()); } $eventResult = $this->executeEvent('afterSave', $obj); if (!$eventResult) { $obj->setErrors("An error occured during the AfterSave event"); return false; } if ($obj->isNew()) { $obj->unsetNew(); $eventResult = $this->executeEvent('afterInsert', $obj); if (!$eventResult) { $obj->setErrors("An error occured during the AfterInsert event"); return false; } } else { $eventResult = $this->executeEvent('afterUpdate', $obj); if (!$eventResult) { $obj->setErrors("An error occured during the AfterUpdate event"); return false; } } return true; }