function delete() { global $config_vars, $db; //delete all cat_auths related to this usergroup $sql = "DELETE FROM " . $config_vars['table_prefix'] . get_class($this) . "s WHERE (id = {$this->id})"; if (!($result = $db->sql_query($sql))) { $error = new phreak_error(E_WARNING, SQL_ERROR, __LINE__, __FILE__, 'delete', $this->id, 0, 0, $sql); $error->commit(); // error_report(SQL_ERROR, 'delete' , __LINE__, __FILE__,$sql); } }
function calc_child_comments_amount() { global $db, $config_vars; //get the comments from cat $sql = 'SELECT count(cat_comments.id) FROM ' . $config_vars['table_prefix'] . 'cat_comments AS cat_comments WHERE cat_comments.owner_id = ' . $this->id; if (!($result = $db->sql_query($sql))) { $error = new phreak_error(E_WARNING, SQL_ERROR, __LINE__, __FILE__, 'calc_child_comments_amoount', $this->id, 0, 0, $sql); $error->commit(); error_report(SQL_ERROR, 'commit', __LINE__, __FILE__, $sql); } $row = $db->sql_fetchrow($result); $amount = $row[0]; //get the comments from content $sql = 'SELECT count(content_comments.id) FROM ' . $config_vars['table_prefix'] . 'content_comments AS content_comments, ' . $config_vars['table_prefix'] . 'content_in_cat AS content_in_cat WHERE (content_in_cat.cat_id = ' . $this->id . ') AND (content_in_cat.content_id = content_comments.owner_id)'; if (!($result = $db->sql_query($sql))) { error_report(SQL_ERROR, 'commit', __LINE__, __FILE__, $sql); } $row = $db->sql_fetchrow($result); $amount += $row[0]; $child_cats = get_cats_of_cat($this->id); for ($i = 0; $i < sizeof($child_cats); $i++) { if ($child_cats[$i]->id != $config_vars['root_categorie']) { $amount += $child_cats[$i]->calc_child_comments_amount(); } } return $amount; }
function start_view() { global $db, $config_vars, $userdata; $now = date("Y-m-d H:i:s"); $sql = 'INSERT INTO ' . $config_vars['table_prefix'] . 'views (user_id,content_id,start) VALUES (' . $userdata['user_id'] . ',' . $this->id . ",'{$now}')"; if (!($result = $db->sql_query($sql))) { $error = new phreak_error(E_WARNING, SQL_ERROR, __LINE__, __FILE__, 'start_view', $this->id, 0, 0, $sql); $error->commit(); // error_report(SQL_ERROR, 'start_view' , __LINE__, __FILE__,$sql); } return $now; }
function delete() { global $db, $config_vars; if (check_auth_action_allowed()) { // remove from content table $sql = "DELETE FROM " . $config_vars['table_prefix'] . get_class($this) . " WHERE (usergroup_id = {$this->usergroup_id}) and (usergroupgroup_id = {$this->usergroupgroup_id})"; if (!($result = $db->sql_query($sql))) { $error = new phreak_error(E_WARNING, SQL_ERROR, __LINE__, __FILE__, 'delete', $this->id, 0, 0, $sql); $error->commit(); // error_report(SQL_ERROR, 'delete' , __LINE__, __FILE__,$sql); } unset($this->id); } else { return OP_NP_MISSING_DELETE; } }
function stop_view($start_view, $content_id) { global $db, $config_vars, $userdata, $HTTP_SESSION_VARS; // delete files in $HTTP_SESSION_VARS['delete_files']. actually it doesnt really belong here, but this funtion is called at start of every page so its a good place if (is_array($HTTP_SESSION_VARS['delete_files'])) { foreach ($HTTP_SESSION_VARS['delete_files'] as $index => $file) { unlink($file); unset($HTTP_SESSION_VARS['delete_files'][$index]); } } if ($start_view == 0 or !isset($start_view) or !isset($content_id)) { return OP_FAILED; } $now = date("Y-m-d H:i:s"); $sql = 'UPDATE ' . $config_vars['table_prefix'] . "views SET" . KEY_QUOTE . 'end' . KEY_QUOTE . " = '{$now}'\n\t\tWHERE (user_id = " . $userdata['user_id'] . ") and (start = '{$start_view}') and (content_id = {$content_id})"; if (!($result = $db->sql_query($sql))) { $error = new phreak_error(E_WARNING, SQL_ERROR, __LINE__, __FILE__, 'stop_view', $this->id, 0, 0, $sql); $error->commit(); // error_report(SQL_ERROR, 'stop_view' , __LINE__, __FILE__,$sql); } }
} if (is_object($surrounding_content['prev'])) { $smarty->assign('is_prev_content', true); $smarty->assign('prev_thumb', $surrounding_content['prev']->get_thumb()); } if (is_object($surrounding_content['next'])) { $smarty->assign('is_next_content', true); $smarty->assign('next_thumb', $surrounding_content['next']->get_thumb()); if (isset($HTTP_GET_VARS['slideshow'])) { $smarty->assign('meta', "<meta http-equiv=\"refresh\" content=\"{$HTTP_GET_VARS['slideshow']}; URL=view_content.php?cat_id={$HTTP_GET_VARS['cat_id']}&content_id={$surrounding_content['next']->id}&slideshow={$HTTP_GET_VARS['slideshow']}&{$sid}#pic\">"); } } // get meta fields $sql = "SELECT * from " . $config_vars['table_prefix'] . "content_meta_fields"; if (!($result = $db->sql_query($sql))) { $error = new phreak_error(E_WARNING, SQL_ERROR, __LINE__, __FILE__, 'get_meta_fields', $this->id, 0, 0, $sql); $error->commit(); // error_report(AUTH_ERROR, 'get_groups' , __LINE__, __FILE__,$sql); } while ($row = $db->sql_fetchrow($result)) { $meta_fields[$row['id']] = $row['fieldname']; } $smarty->assign('meta_fields', $meta_fields); // get meta data $meta = new content_meta_data(); $meta->generate_from_content_id($content->get_id()); // meta edit allowed ? if ($content->check_perm('edit_meta_data')) { $smarty->assign('allow_meta_edit', true); //submits if (isset($HTTP_POST_VARS['edit_meta_add']) or isset($HTTP_POST_VARS['edit_meta'])) {