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'])) {
