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;
}
