<?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); } /******************************************/