function commit()
{
global $db, $config_vars;
// check if allowed
if (true) {
if (!isset($this->id)) {
// this is object is not yet in the datebase, make a new entry
$sql = 'INSERT INTO ' . $config_vars['table_prefix'] . "content_meta_fields (fieldname)\n\t\t\t\t\tVALUES ('" . database_encode($this->fieldname) . "')";
if (!($result = $db->sql_query($sql))) {
error_report(SQL_ERROR, 'commit', __LINE__, __FILE__, $sql);
}
// set id;
$this->id = $db->sql_nextid();
return OP_SUCCESSFULL;
} else {
// object is already in the database just du an update
$sql = 'UPDATE ' . $config_vars['table_prefix'] . "content_meta_fields\n\t\t\t\t\tSET \tfieldname = '" . database_encode($this->fieldname) . "'\n\t\t\t\t\tWHERE id = {$this->id}";
if (!($result = $db->sql_query($sql))) {
error_report(SQL_ERROR, 'commit', __LINE__, __FILE__, $sql);
}
return OP_SUCCESSFULL;
}
}
return OP_NP_MISSING_EDIT;
}
function commit()
{
//if the object is already in the db it is updated by the changes made to this object, otherwise a new db entry is made
global $db, $config_vars;
if (!isset($this->id)) {
if ($this->is_serie === false) {
$is_serie = 0;
} else {
$is_serie = 1;
}
// this is object is not yet in the datebase, make a new entry
$sql = 'INSERT INTO ' . $config_vars['table_prefix'] . "cats (name, current_rating, parent_id, catgroup_id,is_serie,content_amount,description,child_content_amount,child_comments_amount)\n\t\t\t\tVALUES ('" . database_encode($this->name) . "', '{$this->current_rating}', '{$this->parent_id}', '{$this->catgroup_id}', '{$is_serie}', '{$this->content_amount}', '" . database_encode($this->description) . "', '{$this->child_content_amount}', '{$this->child_comments_amount}')";
if (!($result = $db->sql_query($sql))) {
$error = new phreak_error(E_WARNING, SQL_ERROR, __LINE__, __FILE__, 'commit', $this->id, 0, 0, $sql);
$error->commit();
// error_report(SQL_ERROR, 'commit' , __LINE__, __FILE__,$sql);
}
$this->id = $db->sql_nextid();
return OP_SUCCESSFUL;
} else {
// object is already in the database just du an update
$sql = 'UPDATE ' . $config_vars['table_prefix'] . "cats \n\t\t\t\tSET \tname = '" . database_encode($this->name) . "',\n\t\t\t\t\tcurrent_rating = '{$this->current_rating}', \n\t\t\t\t\tparent_id = '{$this->parent_id}', \n\t\t\t\t\tcatgroup_id = '{$this->catgroup_id}',\n\t\t\t\t\tis_serie = '{$this->is_serie}',\n\t\t\t\t\tcontent_amount = '{$this->content_amount}',\n\t\t\t\t\tdescription = '" . database_encode($this->description) . "',\n\t\t\t\t\tchild_content_amount = '{$this->child_content_amount}',\n\t\t\t\t\tchild_comments_amount = '{$this->child_comments_amount}'\n\t\t\t\tWHERE id like {$this->id}";
if (!($result = $db->sql_query($sql))) {
$error = new phreak_error(E_WARNING, SQL_ERROR, __LINE__, __FILE__, 'commit', $this->id, 0, 0, $sql);
$error->commit();
// error_report(SQL_ERROR, 'commmit' , __LINE__, __FILE__,$sql);
}
// recalc child content_amount
if ($this->get_id() != $config_vars['root_categorie']) {
$cat = new categorie();
$cat->generate_from_id($this->get_parent_id());
$cat->set_child_content_amount($cat->calc_child_content_amount());
$cat->commit();
}
if (isset($this->commit_parent_cat)) {
$this->commit_parent_cat->commit();
}
return OP_SUCCESSFUL;
}
}
function commit()
{
//commits all changes of the actual object to the database and/or filesystem
//or create a new db entry if object is not yet in db
global $db, $config_vars;
// fill palce_in_cat and cat_ids array if they are not yet filled;
if (isset($this->id)) {
if (!isset($this->cat_ids) or !isset($this->place_in_cat)) {
$this->generate_content_in_cat_data();
}
}
// if content is in no cat anymore
if (sizeof($this->cat_ids) == 0) {
// move content in the deleted pics cat.
$del_content_cat = new categorie();
$del_content_cat->generate_from_id($config_vars['deleted_content_cat']);
$del_content_cat->content_amount++;
$this->cat_ids[0] = $config_vars['deleted_content_cat'];
$this->new_filename = $this->generate_filename();
}
// move to the new calculated localtaion (may be the same)
if (isset($this->new_filename)) {
if (!is_dir(dirname($this->new_filename))) {
makedir(dirname($this->new_filename));
}
// echo "rename({$this->file},$new_file)<br>";
if (rename($this->file, $this->new_filename)) {
$this->set_file($this->new_filename);
} else {
die('content rename failed ' . $this->file . ' to ' . $this->new_filename);
}
//echo "rename pic" .$this->file." -> ".$new_file."<br>";
// move thumb
if (!is_dir(dirname($this->get_thumbfile()))) {
makedir(dirname($this->get_thumbfile()));
}
}
//echo "rename thumb" .$this->thumbfile." -> ".$this->get_thumbfile()."<br>";
// but first check if thumb exists
//echo "rename({/*$this->thumbfile*/},".$this->get_thumbfile().")<br>";
if (is_file($this->thumbfile)) {
if (rename($this->thumbfile, $this->get_thumbfile())) {
$this->thumbfile = $this->get_thumbfile();
} else {
die('thumb rename failed');
}
}
// check if already in db)
if (isset($this->id)) {
// already in db
// update entry in content table
$sql = "UPDATE " . $config_vars['table_prefix'] . "content\n\t\t\t\tSET\n\t\t\t\t\tfile = '{$this->file}',\n\t\t\t\t\tname = '" . database_encode($this->name) . "',\n\t\t\t\t\tviews = '{$this->views}',\n\t\t\t\t\tcurrent_rating = '{$this->current_rating}',\n\t\t\t\t\tcreation_date = '{$this->creation_date}',\n\t\t\t\t\tcontentgroup_id = '{$this->contentgroup_id}',\n\t\t\t\t\tlocked = '{$this->locked}',\n\t\t\t\t\twidth = '{$this->width}',\n\t\t\t\t\theight = '{$this->height}',\n\t\t\t\t\tcomments_amount = '{$this->comments_amount}'\n\t\t\t\tWHERE id = {$this->id}";
if (!($result = $db->sql_query($sql))) {
$error = new phreak_error(E_WARNING, SQL_ERROR, __LINE__, __FILE__, 'commit', $this->id, 0, 0, $sql);
$error->commit();
//error_report(SQL_ERROR, 'commit' , __LINE__, __FILE__,$sql);
}
// update content_in_cat table
// i will do this by first deleting all entry with this content and then generate them all new
$this->clear_content_in_cat();
} else {
$this->calc_size();
//not in db
$this->creation_date = date("Y-m-d H:i:s");
// add content to the content table
//using a shorter version of boolean transmission for locked
$sql = "INSERT INTO " . $config_vars['table_prefix'] . "content\n\t\t\t\t(file,name,views,current_rating,creation_date,contentgroup_id,locked,width,height,comments_amount)\n\t\t\t\tVALUES ('{$this->file}', '" . database_encode($this->name) . "', '{$this->views}', '{$this->current_rating}', '{$this->creation_date}', '{$this->contentgroup_id}', '" . ($this->locked ? '1' : '0') . "','{$this->width}','{$this->height}','{$this->comments_amount}')";
if (!($result = $db->sql_query($sql))) {
$error = new phreak_error(E_WARNING, SQL_ERROR, __LINE__, __FILE__, 'commit', $this->id, 0, 0, $sql);
$error->commit();
// error_report(SQL_ERROR, 'commit' , __LINE__, __FILE__,$sql);
}
// set id of object to the id of the insert
$this->id = $db->sql_nextid();
}
// add content to the cats
$this->fill_content_in_cat();
if (is_object($del_content_cat)) {
$del_content_cat->commit();
}
if (is_object($this->add_to_cat)) {
$this->add_to_cat->commit();
}
if (is_object($this->remove_from_cat)) {
$this->remove_from_cat->commit();
}
if (is_array($this->commit_parent_cats)) {
foreach ($this->commit_parent_cats as $parent_cat) {
$parent_cat->commit();
}
}
return OP_SUCESSFUL;
}
function commit()
{
global $db, $config_vars;
if (!isset($this->id)) {
$this->creation_date = date("Y-m-d H:i:s");
// this is object is not yet in the datebase, make a new entry
$sql = 'INSERT INTO ' . $config_vars['table_prefix'] . get_class($this) . "s \n\t\t\t\t(owner_id, feedback, user_id, creation_date, changed_count, parent_id, topic, last_changed_date, poster_name)\n\t\t\t\tVALUES ('{$this->owner_id}', '" . database_encode($this->feedback) . "', '{$this->user_id}', '{$this->creation_date}', '{$this->changed_count}', '{$this->parent_id}', '" . database_encode($this->topic) . "', '{$this->last_changed_date}', '" . database_encode($this->poster_name) . "')";
if (!($result = $db->sql_query($sql))) {
error_report(SQL_ERROR, 'commit', __LINE__, __FILE__, $sql);
}
return OP_SUCCESSFULL;
// set id;
$this->id = $db->sql_nextid();
// TODO: update child_comments of cats
} else {
// object is already in the database just du an update
$sql = 'UPDATE ' . $config_vars['table_prefix'] . get_class($this) . "s \n\t\t\t\tSET\towner_id = '{$this->owner_id}',\n\t\t\t\t\tfeedback = '" . database_encode($this->feedback) . "',\n\t\t\t\t\tuser_id = '{$this->user_id}',\n\t\t\t\t\tcreation_date = '{$this->creation_date}',\n\t\t\t\t\tchanged_count = '{$this->changed_count}', \n\t\t\t\t\tparent_id = '{$this->parent_id}', \n\t\t\t\t\ttopic = '" . database_encode($this->topic) . "',\n\t\t\t\t\tlast_changed_date = '{$this->last_changed_date}',\n\t\t\t\t\tposter_name = '" . database_encode($this->poster_name) . "'\n\t\t\t\tWHERE id like {$this->id}";
if (!($result = $db->sql_query($sql))) {
error_report(SQL_ERROR, 'commit', __LINE__, __FILE__, $sql);
}
return OP_SUCCESSFULL;
}
}
