<?php
/* Burns Depression Scale
* delete entries and retrieve all entries
* displaying the results (result.php) is initiated in the template file index.tpl */
//delete item
//print_r($user_data);
//TODO TESTING!!
if (!empty($_POST['submit_del'])) {
$del_scale = new ModifyEntry();
$del_scale->table = $tbl_bd_scale_results;
$del_scale->condition = "userID = '" . $user_data['ID'] . "' && date = '" . $_POST['date_to_delete'] . "' ";
$del_scale->delete();
unset($del_scale);
$bd_scale_scores_ser = explode('&fscores=', $bd_scale_data);
$get_latest_date = unserialize(substr($bd_scale_scores_ser[0], 7));
$latest_date = end($get_latest_date);
$bd_scale_scores = unserialize($bd_scale_scores_ser[1]);
$latest_key = array_keys($bd_scale_scores);
$new_latest_score = "";
//only if latest entry is deleted and at least 2 entries exist we have to update the aggregated numbers
if ($latest_date['date'] == $_POST['date_to_delete'] && end($latest_key) > 0) {
$new_latest_score = $bd_scale_scores[end($latest_key) - 1];
} else {
if (end($latest_key) == 0) {
$new_latest_score = -1;
}
}
if ($new_latest_score != "") {
$scale_data = new ModifyEntry();
$scale_data->table = $tbl_users;
$links_l_edit->changes = " visibility = '0' ";
$links_l_edit->update();
$count = 0;
foreach ($_POST["links_l_link"] as $element) {
$id = $links_l_id[$count];
if (isset($links_l_visibility["{$id}"])) {
$vis = 1;
} else {
$vis = 0;
}
$links_l_edit->condition = " id = '{$links_l_id[$count]}' ";
$links_l_edit->changes = " link = '{$links_l_link[$count]}', description = '{$links_l_description[$count]}', description_EN = '{$links_l_description_EN[$count]}', visibility = '{$vis}' ";
$links_l_edit->update();
$count++;
}
unset($links_l_edit);
}
/******************************************/
/* design :: Delete one or more entries */
if (count($_POST["links_l_del"]) > 0) {
$links_l_delete = new ModifyEntry();
$links_l_delete->table = $tbl_links;
if ($_POST["links_l_del"]) {
foreach ($_POST["links_l_del"] as $element) {
$links_l_delete->condition = " id = '{$element}' ";
$links_l_delete->delete();
}
}
unset($links_l_delete);
}
/******************************************/
function update_visiter_stats($tbl_visiter, $tbl_settings, $timestamp, $del_old_visiters, $time_new_visiter)
{
require_once 'lib/select.php';
require_once 'lib/modify.php';
require_once 'lib/exist.php';
$delimiter = $timestamp - $del_old_visiters * 60;
// delete entries older than 2 weeks 60*60*24*14
$visiter = new ModifyEntry();
$visiter->table = $tbl_visiter;
$visiter->condition = " UNIX_TIMESTAMP(date) < {$delimiter} ";
$visiter->delete();
unset($visiter);
$delimiter = $timestamp - $time_new_visiter * 60;
$visiter = new CheckExist();
$visiter->tableE = $tbl_visiter;
$visiter->conditionE = " IP = '" . $_SERVER['REMOTE_ADDR'] . "' AND UNIX_TIMESTAMP(date) >= {$delimiter} ";
$visiter_exist = $visiter->exist();
unset($visiter);
if ($visiter_exist == 0) {
//$country = file_get_contents('http://api.hostip.info/country.php?ip='.$_SERVER['REMOTE_ADDR']);
$date = date("Y-m-d H:i:s", $timestamp);
$visiter = new ModifyEntry();
$visiter->table = $tbl_visiter;
$visiter->cols = 'IP, date, browser, country, referer';
$visiter->values = " '" . $_SERVER['REMOTE_ADDR'] . "', '{$date}', '" . $_SERVER['HTTP_USER_AGENT'] . "', 'unknown', '" . $_SERVER['HTTP_REFERER'] . "' ";
$visiter->insert();
$visiter->table = $tbl_settings;
$visiter->changes = " visiters_total = visiters_total+1 ";
$visiter->condition = " id = '1' ";
$visiter->update();
unset($visiter);
}
return false;
}
<?php
$upd_data = new ModifyEntry();
$upd_data->table = $tbl_users;
$upd_data->condition = " id = '" . $user_data['ID'] . "' ";
$upd_data->changes = " fb_ID = '0', fb_name = '' ";
$upd_data->update();
unset($upd_data);
$friends_delete = new ModifyEntry();
$friends_delete->table = $tbl_friends;
$friends_delete->condition = " userID = '" . $user_data['ID'] . "' ";
$friends_delete->delete();
unset($friends_delete);
$prep_trigger = new SelectEntrys();
$prep_trigger->cols = 'userID';
$prep_trigger->table = $tbl_friends;
$prep_trigger->condition = " friendID = '" . $user_data['ID'] . "' ";
$prep_trigger->multiSelect = '1';
$ay_trigger = $prep_trigger->row();
if ($ay_trigger !== false) {
foreach ($ay_trigger as $key => $value) {
$arr[] = $value['userID'];
}
$str_trigger = implode(",", $arr);
$set_trigger = new ModifyEntry();
$set_trigger->table = $tbl_users;
$set_trigger->condition = " ID IN ({$str_trigger}) ";
$set_trigger->changes = " trigger_friends = 1 ";
$set_trigger->update();
unset($set_trigger);
}
$profile_new->insert();
$positionID++;
}
$count++;
}
unset($profile_new);
}
/******************************************/
/* Profile :: Edit one or more entries */
$profile_edit = new ModifyEntry();
$profile_edit->table = $tbl_profile;
$count = 0;
foreach ($_POST["profile_german"] as $element) {
$profile_edit->condition = " id = '{$profile_id[$count]}' ";
$profile_edit->changes = " german = '{$profile_german[$count]}', english = '{$profile_english[$count]}', value = '{$profile_value[$count]}', value_EN = '{$profile_value_EN[$count]}' ";
$profile_edit->update();
$count++;
}
unset($profile_edit);
/******************************************/
/* Profile :: Delete one or more entries */
$profile_delete = new ModifyEntry();
$profile_delete->table = $tbl_profile;
if ($_POST["profile_del"]) {
foreach ($_POST["profile_del"] as $element) {
$profile_delete->condition = " id = '{$element}' ";
$profile_delete->delete();
}
}
unset($profile_delete);
/******************************************/
$ref_new->insert();
$positionID++;
}
$count++;
}
unset($ref_new);
}
/******************************************/
/* References :: Edit one or more entries */
$ref_edit = new ModifyEntry();
$ref_edit->table = $tbl_ref;
$count = 0;
foreach ($_POST["ref_link"] as $element) {
$ref_edit->condition = " id = '{$ref_id[$count]}' ";
$ref_edit->changes = " link = '{$ref_link[$count]}', description = '{$ref_description[$count]}', description_EN = '{$ref_description_EN[$count]}' ";
$ref_edit->update();
$count++;
}
unset($ref_edit);
/******************************************/
/* Quicklinks :: Delete one or more entries */
$ref_delete = new ModifyEntry();
$ref_delete->table = $tbl_ref;
if ($_POST["ref_del"]) {
foreach ($_POST["ref_del"] as $element) {
$ref_delete->condition = " id = '{$element}' ";
$ref_delete->delete();
}
}
unset($ref_delete);
/******************************************/
<?php
/* Goals of the user */
//delete entry
if (!empty($_POST['submit_del'])) {
$del_goal = new ModifyEntry();
$del_goal->table = $tbl_goals;
$del_goal->condition = "userID = '" . $user_data['ID'] . "' && ID = '" . $_POST['id_to_delete'] . "' ";
$del_goal->delete();
unset($del_goal);
header("Location:" . ROOT_DIR . "improve/goals/index.html");
}
//default sort orders
$sort_goal = "ASC";
$sort_progress = "DESC";
$sort_created = "ASC";
//retrieve goal data
include "./././lib/functions/fetch_goals.php";
//display template
$tpl->assign('ay_goals', $ay_goals);
$tpl->assign('sort_goal', $sort_goal);
$tpl->assign('sort_progress', $sort_progress);
$tpl->assign('sort_created', $sort_created);
$tpl->assign('total_goals', $count);
$dir_thumbs = "gallery/{$folder}/thumbs/";
/******************************************/
/* Clear images directory */
$thumbs->directory = $dir_images;
$thumbs->listfolder('clear');
rmdir("gallery/{$folder}/images");
/******************************************/
/* Clear thumbs directory */
$thumbs->directory = $dir_thumbs;
$thumbs->listfolder('clear');
rmdir("gallery/{$folder}/thumbs");
/******************************************/
/* Delete entry */
$gallery->table = $tbl_gallery;
$gallery->condition = " id = '{$_POST['gid']}' ";
$gallery->delete();
/******************************************/
/* Delete :: Object INSERT */
unset($gallery);
/******************************************/
/* Get total rows */
$gallery = new CheckExist();
$gallery->tableE = $tbl_gallery;
$gallery->conditionE = "";
$TotalRows = $gallery->exist();
unset($gallery);
/******************************************/
/* Load :: Updated Main Content */
if (!isset($_GET['page'])) {
$page_current = '1';
} else {
$mysqldate = date('Y-m-d H:i:s', time());
$diary_note = mysql_real_escape_string($_POST['note']);
//insert new entry
$diary = new ModifyEntry();
$diary->table = $tbl_diary;
$diary->cols = 'userID, entry, date, picture';
$diary->values = " '" . $user_data['ID'] . "', '" . $diary_note . "', '" . $mysqldate . "', '" . $upload_pic . "' ";
$diary->insert();
unset($diary);
}
header("Location:" . ROOT_DIR . "improve/diary/index.html");
} elseif (!empty($_POST['submit_del'])) {
$del_diary_entry = new ModifyEntry();
$del_diary_entry->table = $tbl_diary;
$del_diary_entry->condition = "userID = '" . $user_data['ID'] . "' && ID = '" . $_POST['id_to_delete'] . "' ";
$confirm_del = $del_diary_entry->delete();
if ($confirm_del === true && $_POST['pid'] != '') {
$path = 'media/images/uploads/' . $user_data['ID'] . '/' . $_POST['pid'];
$i_full = explode(".", $_POST['pid']);
$path_full = 'media/images/uploads/' . $user_data['ID'] . '/' . $i_full[0] . '_full.' . $i_full[1];
unlink($path);
//delete thumbnail
unlink($path_full);
// delete fullsize image
}
unset($del_diary_entry);
//TODO
header("Location:" . ROOT_DIR . "improve/diary/index.html");
} else {
//require_once('././lib/functions/convert_date.php');
//Load Data that is displayed on landing page (diary, etc.)
$c_time = time() + 60 * $set[0]["time_ban"];
$spam->cookieIP($c_name, $c_content, $c_time, '/');
unset($spam);
}
/******************************************/
/* Load :: Updated Main Content */
header("Location:" . ROOT_DIR . $page_url);
/******************************************/
}
} else {
/* Delete :: Old blocked IPs */
$blog = new ModifyEntry();
$blog->table = $tbl_blog_spamban;
$differ = $timestamp - 60 * $set[0]['time_ban'];
$blog->condition = " UNIX_TIMESTAMP(time) < {$differ} ";
$blog->delete();
unset($blog);
/******************************************/
/* Print :: SELECT */
$blog = new SelectEntrys();
$blog->cols = "id, author, title_DE, message_DE, title_EN, message_EN, date, DATE_FORMAT(date,'%d. %m %Y') as date_formatted, file1, filename1, file2, filename2, file3, filename3, visibility, comments";
$blog->table = $tbl_blog;
if ($Myadmin == 1) {
$blog->condition = "id = '{$bid}'";
} else {
$blog->condition = " deleted = '0' AND visibility = '1' AND UNIX_TIMESTAMP(date) < {$timestamp} AND id = '{$bid}' ";
}
//$blog->order = 'date DESC';
//$blog->limit = "$begin, " . $set[0]['perpage_blog'];
$blog->module = 'blog';
$blog->template = 'blog/show.tpl';
<?php
//delete entry
if (!empty($_POST['submit_del'])) {
$del_thought = new ModifyEntry();
$del_thought->table = $tbl_distorted_thoughts;
$del_thought->condition = "userID = '" . $user_data['ID'] . "' && ID = '" . $_POST['id_to_delete'] . "' ";
$del_thought->delete();
unset($del_thought);
header("Location:" . ROOT_DIR . "improve/distorted_thoughts/index.html");
}
//retrieve goal data
include "./././lib/functions/fetch_thoughts.php";
//display template
$tpl->assign('ay_thoughts', $ay_thoughts);
if (isset($ay_thoughts[0])) {
$tpl->assign('total_thoughts', count($ay_thoughts));
} else {
$tpl->assign('total_thoughts', 0);
}
}
unset($design_new);
}
/******************************************/
/* design :: Edit one or more entries */
if (count($_POST["design_german"]) > 0) {
$design_edit = new ModifyEntry();
$design_edit->table = $tbl_design;
$count = 0;
foreach ($_POST["design_german"] as $element) {
$design_edit->condition = " id = '{$design_id[$count]}' ";
$design_edit->changes = " german = '{$design_german[$count]}', english = '{$design_english[$count]}', hexcode = '{$design_hexcode[$count]}', imgfolder = '{$design_imgfolder[$count]}' ";
$design_edit->update();
$count++;
}
unset($design_edit);
}
/******************************************/
/* design :: Delete one or more entries */
if (count($_POST["design_del"]) > 0) {
$design_delete = new ModifyEntry();
$design_delete->table = $tbl_design;
if ($_POST["design_del"]) {
foreach ($_POST["design_del"] as $element) {
$design_delete->condition = " id = '{$element}' ";
$design_delete->delete();
}
}
unset($design_delete);
}
/******************************************/
if (isset($links_c_visibility["{$id}"])) {
$vis = 1;
} else {
$vis = 0;
}
$links_c_edit->condition = " id = '{$id}' ";
$links_c_edit->changes = " german = '{$links_c_german[$count]}', english = '{$links_c_english[$count]}', visibility = '{$vis}' ";
$links_c_edit->update();
$count++;
}
unset($links_c_edit);
}
/******************************************/
/* design :: Delete one or more entries */
if (count(isset($_POST["links_c_del"])) > 0) {
$links_c_delete = new ModifyEntry();
$links_c_delete->table = $tbl_links_c;
if (isset($_POST["links_c_del"])) {
foreach ($_POST["links_c_del"] as $element) {
$links_l_delete = new ModifyEntry();
$links_l_delete->table = $tbl_links;
$links_l_delete->condition = " cid = '{$element}' ";
$links_l_delete->delete();
unset($links_l_delete);
$links_c_delete->condition = " id = '{$element}' ";
$links_c_delete->delete();
}
}
unset($links_c_delete);
}
/******************************************/
