function delete($table, $bid, $cid, $pageid, $TotalRows)
{
$objResponse = new xajaxResponse();
include 'settings/config.php';
include 'settings/tables.php';
include 'settings/template.php';
require_once 'lib/modify.php';
if ($table == $tbl_blog_comments) {
$comment = new ModifyEntry();
$comment->table = $tbl_blog_comments;
$comment->changes = " deleted = '1' ";
$comment->condition = " id = '{$cid}' ";
$comment->update();
unset($comment);
}
$TotalRows = $TotalRows - 1;
$max_pages = ceil($TotalRows / $set[0]["perpage_comments"]);
if ($pageid > $max_pages) {
$pageid = $pageid - 1;
}
$p_name = "p_num_" . $bid;
$objResponse->assign($p_name, "innerHTML", $TotalRows);
if ($max_pages == 0) {
$p_main = "p_comments_" . $bid;
$p_out = "p_page_" . $bid;
$p_out2 = "p_page2_" . $bid;
$objResponse->remove($p_main);
$objResponse->remove($p_out);
$objResponse->remove($p_out2);
} else {
$objResponse->loadcommands(page($table, $bid, $pageid, $TotalRows));
}
return $objResponse;
}
$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);
}
$friends_upd = new ModifyEntry();
$friends_upd->table = $tbl_friends;
$friends_upd->condition = " friendID = '" . $user_data['ID'] . "' ";
$friends_upd->changes = " friendID = 0 ";
$friends_upd->update();
unset($friends_upd);
$user_data['fb_friends'] = array();
$user_data['fb_ID'] = 0;
$user_data['fb_name'] = "";
$mem_key1 = "user_data_" . $user_data['UserToken'];
$memcache->replace($mem_key1, $user_data, false);
//$memcache->delete('user_data_'.$user_data['ID']); //only replace
header("Location:" . ROOT_DIR . "account/connectwithfriends.html?e=disconnected");
}
if ($user_data == "" || $trigger_f == 1) {
$usr_data = new SelectEntrys();
$usr_data->token = $l["token"];
$usr_data->cols = 'ID, UserToken, UserEmail, UserPass, flash_categories_visible, fb_ID, fb_name, sections_public, language, last_online_time';
$usr_data->multiSelect = '1';
$ay_user = $usr_data->getUserData();
unset($usr_data);
if ($trigger_f == 1) {
$mem_key1 = "user_data_" . $l["token"];
$memcache->delete($mem_key1);
$upd_data = new ModifyEntry();
$upd_data->table = $tbl_users;
$upd_data->condition = " ID = '" . $ay_user[0]['ID'] . "' ";
$upd_data->changes = " trigger_friends = '0' ";
$upd_data->update();
unset($upd_data);
}
if ($ay_user[0]['fb_ID'] != 0) {
$get_friends = new SelectEntrys();
$get_friends->cols = 'fb_ID, friendID, fb_name, restricted';
$get_friends->table = $tbl_friends;
$get_friends->condition = " userID = '" . $ay_user[0]['ID'] . "' AND friendID > 0 ";
$get_friends->order = 'fb_name';
$get_friends->multiSelect = '1';
$friends_new = $get_friends->row();
if ($friends_new !== false) {
$ay_user[0]['fb_friends'] = $friends_new;
} else {
$ay_user[0]['fb_friends'] = array();
}
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
/* Create Object :: UPDATE */
require_once './lib/modify.php';
$cms = new ModifyEntry();
/******************************************/
/* Update entry */
$msg_cms = mysql_real_escape_string($_POST[message]);
$cms->table = $tbl_cms;
$cms->changes = " {$cms_content} = '{$msg_cms}' ";
$cms->condition = " lang = '{$lang_active}' ";
$cms->update();
/******************************************/
/* Delete :: Object INSERT */
unset($cms);
/******************************************/
/* Load :: Updated Main Content */
if ($cms_content == 'links') {
header("Location:" . ROOT_DIR . "admin/changecms/" . $cms_content . "/");
} else {
header("Location:" . ROOT_DIR . "cms/" . $cms_content . "/");
}
/******************************************/
if ($changeF) {
$changeF .= ",";
}
$changeF .= " file2 = '', filename2 = '' ";
unlink("attachments/{$_POST['attach2']}");
}
if ($del_attach3 == 1) {
if ($changeF) {
$changeF .= ",";
}
$changeF .= " file3 = '', filename3 = '' ";
unlink("attachments/{$_POST['attach3']}");
}
if ($changeF) {
$blog->changes = $changeF;
$blog->update();
}
/******************************************/
/* Attachments :: Upload */
$tempname1 = $_FILES["file1"]["tmp_name"];
$filename1 = $_FILES["file1"]["name"];
$tempname2 = $_FILES["file2"]["tmp_name"];
$filename2 = $_FILES["file2"]["name"];
$tempname3 = $_FILES["file3"]["tmp_name"];
$filename3 = $_FILES["file3"]["name"];
$blog->directory = 'attachments';
if ($filename1) {
$blog->tempname = $tempname1;
$blog->filename = $filename1;
$attachment1 = $blog->attach();
$changeF = " file1 = '{$attachment1['0']}', filename1 = '{$attachment1['1']}' ";
$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);
/******************************************/
function rate($site, $id, $rating)
{
global $memcache;
global $duration;
global $_COOKIE;
global $tpl;
include 'settings/tables.php';
$objResponse = new xajaxResponse();
if (!isset($_COOKIE["l"])) {
$objResponse->redirect(ROOT_DIR);
return $objResponse;
}
$l["token"] = substr($_COOKIE["l"], 3, -35);
$mem_key1 = "user_data_" . $l["token"];
$user_data = $memcache->get($mem_key1);
$mem_key2 = "trigger_f_" . $l["token"];
$trigger_f = $memcache->get($mem_key2);
include 'modules/logon/get_userdata.php';
$mem_key3 = "ay_flashes_voted_" . $l["token"];
$mem_key4 = "ay_flashes_rated_" . $l["token"];
$ay_flashes_voted = $memcache->get($mem_key3);
$ay_flashes_rated = $memcache->get($mem_key4);
$ay_flash_cats = $memcache->get('ay_flash_cats');
include 'modules/flash/flashfeed_add.php';
if ($site == 'flash') {
$likes_str = 'p_likes_' . $id;
$dislikes_str = 'p_dislikes_' . $id;
$rate_str = 'p_rate_' . $id;
$upd_data = new ModifyEntry();
$upd_data->table = $tbl_flashes;
$upd_data->condition = " ID = '{$id}' ";
if ($rating == "like") {
$upd_data->changes = " likes = likes+1, rating = rating+1 ";
}
if ($rating == "dislike") {
$upd_data->changes = " dislikes = dislikes+1, rating = rating-1 ";
}
$upd_data->update();
unset($upd_data);
$ins_data = new ModifyEntry();
$ins_data->table = $tbl_flash_ratings;
$ins_data->cols = 'flashID, userID, rating';
$ins_data->values = " '{$id}', '" . $user_data['ID'] . "', '{$rating}' ";
$ins_data->insert();
unset($ins_data);
$flash_result = new SelectEntrys();
$flash_result->cols = 'likes, dislikes';
$flash_result->table = $tbl_flashes;
$flash_result->condition = " ID = '{$id}' ";
$flash_result->multiSelect = 1;
$ay_flash_result = $flash_result->row();
unset($flash_result);
$ay_flashes_rated[] = $id;
sort($ay_flashes_rated);
$mem_key4 = "ay_flashes_rated_" . $l["token"];
$memcache->replace($mem_key4, $ay_flashes_rated, false);
$objResponse->assign($rate_str, "style.display", 'none');
$objResponse->assign($likes_str, "innerHTML", $ay_flash_result[0]['likes']);
$objResponse->assign($dislikes_str, "innerHTML", $ay_flash_result[0]['dislikes']);
}
return $objResponse;
}
<?php
if (isset($submit)) {
// Edit title or folder
/* Create Object :: UPDATE */
require_once './lib/modify.php';
$gallery = new ModifyEntry();
/******************************************/
/* Update entry */
//date format: 0000-00-00 00:00:00
$my_time = $_POST[d_year] . '-' . $_POST[d_month] . '-' . $_POST[d_day] . ' ' . $_POST[d_hour] . ':' . $_POST[d_minute] . ':00';
$gallery->table = $tbl_gallery;
$gallery->changes = " title = '{$_POST['title']}', title_EN = '{$_POST['title_EN']}', description = '{$_POST['description']}', description_EN = '{$_POST['description_EN']}', folder = '{$_POST['folder']}', date = '{$my_time}', visibility = '{$_POST['visibility']}' ";
$gallery->condition = " id = '{$_POST['gid']}' ";
$gallery->update();
/******************************************/
/* UPDATE :: RSS Feed */
include 'update_rss_gallery.php';
/******************************************/
/* Delete :: Object INSERT */
unset($gallery);
/******************************************/
/* Load :: Updated Main Content */
$GetPage = new SelectEntrys();
$GetPage->cols = 'date';
$GetPage->table = $tbl_gallery;
$GetPage->condition = " id = '{$_POST['gid']}' ";
$Tdate = $GetPage->row();
unset($GetPage);
$GetPage = new CheckExist();
$GetPage->tableE = $tbl_gallery;
<?php
if ($Myadmin == 1) {
require_once './lib/modify.php';
if (isset($submit_blocks) || isset($submit_blocks_x)) {
/* Update block on/off settings */
$blocks_edit = new ModifyEntry();
$blocks_edit->table = $tbl_blocks;
$blocks_edit->changes = " status = '0' ";
$blocks_edit->update();
foreach ($_POST["block_status"] as $array1 => $array2) {
$blocks_edit->condition = " id = '{$array1}' ";
$blocks_edit->changes = " status = '1' ";
$blocks_edit->update();
}
unset($blocks);
$anker = "#blocks";
/******************************************/
} else {
if (isset($submit_misc) || isset($submit_misc_x)) {
/* Update misc entries */
$up_set = new ModifyEntry();
$up_set->table = $tbl_settings;
$up_set->changes = " root_dir = '{$_POST['root_dir']}', title_hp = '{$_POST['title_hp']}', title_hp_EN = '{$_POST['title_hp_EN']}', main_title = '{$_POST['main_title']}', main_title_EN = '{$_POST['main_title_EN']}', main_description = '{$_POST['main_description']}', main_description_EN = '{$_POST['main_description_EN']}', keywords = '{$_POST['keywords']}', contact_mail = '{$_POST['contact_mail']}', perpage_blog = '{$_POST['perpage_blog']}', perpage_comments = '{$_POST['perpage_comments']}', perpage_gallery = '{$_POST['perpage_gallery']}', perpage_thumbs = '{$_POST['perpage_thumbs']}', perpage_users = '{$_POST['perpage_users']}', width_images = '{$_POST['width_images']}', height_images_max = '{$_POST['height_images_max']}', width_thumbs = '{$_POST['width_thumbs']}', height_thumbs_max = '{$_POST['height_thumbs_max']}', rss_german_url = '{$_POST['rss_german_url']}', rss_german_title = '{$_POST['rss_german_title']}', rss_english_title = '{$_POST['rss_english_title']}', rss_english_url = '{$_POST['rss_english_url']}', rss_extern_totalentries = '{$_POST['rss_extern_totalentries']}', rss_intern_totalentries = '{$_POST['rss_intern_totalentries']}', rss_msg_length = '{$_POST['rss_msg_length']}', rss_intern_left_totalentries = '{$_POST['rss_intern_left_totalentries']}', time_ban = '{$_POST['time_ban']}', del_old_visiters = '{$_POST['del_old_visiters']}', time_new_visiter = '{$_POST['time_new_visiter']}', twitter = '{$_POST['twitter']}', twitter_EN = '{$_POST['twitter_EN']}' ";
if ($_POST['twitter'] != $set[0]["twitter"] || $_POST['twitter_EN'] != $set[0]["twitter_EN"]) {
$up_set->changes .= ", twitter_time = '{$timestamp}' ";
}
$up_set->condition = " id = '1' ";
$up_set->update();
$set[0]['rss_intern_totalentries'] = $_POST['rss_intern_totalentries'];
$set[0]['rss_msg_length'] = $_POST['rss_msg_length'];
function insertdata($table, $data, $special = 0)
{
//global $tpl;
global $memcache;
global $l;
global $tpl;
global $user_data;
global $getmonth;
$objResponse = new xajaxResponse();
//include('settings/template.php');
include 'settings/tables.php';
if ($user_data == '' || !isset($user_data)) {
require_once 'lib/functions/get_userdata.php';
}
//enter new diary entry
if ($table == $tbl_diary) {
if ($special == 1) {
$html = $tpl->fetch("modules/improve/diary/add_pin.tpl");
// $objResponse->assign("add_pin","style.className",'pin');
$objResponse->assign("add_pin", "innerHTML", $html);
$objResponse->includeScript("js/pinterest.js");
$objResponse->call("m_reload");
} else {
if ($data['image_file'] != '') {
$objResponse->script("document.forms['insert'].submit();");
} else {
$mysqldate = date('Y-m-d H:i:s', time());
$diary_note = mysql_real_escape_string(strip_tags($data['note']));
//insert new entry
$diary = new ModifyEntry();
$diary->table = $table;
$diary->cols = 'userID, entry, date';
$diary->values = " '" . $user_data['ID'] . "', '" . $diary_note . "', '" . $mysqldate . "' ";
$diary->insert();
unset($diary);
//TODO check if first entry and if yes update user array with start_month and start_year
//refresh content
include "lib/functions/fetch_diary.php";
$tpl->assign('ay_diary', $ay_diary);
$tpl->assign('at_least_one_entry', 1);
//else $tpl->assign('at_least_one_entry', 0);
//TODO why is this needed now!?
$tpl->assign('user_data', $user_data);
$html = $tpl->fetch("modules/home/diary_entries.tpl");
$objResponse->assign("diary_entries", "innerHTML", $html);
$objResponse->assign("add_pin", "innerHTML", '');
$objResponse->includeScript("js/pinterest.js");
$objResponse->call("m_reload");
}
}
} elseif ($table == $tbl_goals) {
$mysqldate = date('Y-m-d H:i:s', time());
$note = strip_tags(mysql_real_escape_string($data['note']));
//insert new entry
$goals = new ModifyEntry();
$goals->table = $table;
$goals->cols = 'userID, goal, created';
$goals->values = " '" . $user_data['ID'] . "', '" . $note . "', '" . $mysqldate . "' ";
$goals->insert();
unset($goals);
//refresh content
$html1 = $tpl->fetch("modules/improve/goals/sortfields.tpl");
$objResponse->assign("sortfields", "innerHTML", $html1);
include "lib/functions/fetch_goals.php";
$tpl->assign('ay_goals', $ay_goals);
$html2 = $tpl->fetch("modules/improve/goals/goal_entries.tpl");
$objResponse->assign("goal_entries", "innerHTML", $html2);
$objResponse->call("reset_input");
} elseif ($table == $tbl_distorted_thoughts) {
$mysqldate = date('Y-m-d H:i:s', time());
$thought = strip_tags(mysql_real_escape_string($data['thought']));
$response = strip_tags(mysql_real_escape_string($data['response']));
$c_action = strip_tags(mysql_real_escape_string($data['c_action']));
//insert new entry
$thoughts = new ModifyEntry();
$thoughts->table = $table;
$thoughts->cols = 'userID, thought, response, action, created';
$thoughts->values = " '" . $user_data['ID'] . "', '" . $thought . "', '" . $response . "', '" . $c_action . "', '" . $mysqldate . "' ";
$thoughts->insert();
unset($thoughts);
//refresh content
include "lib/functions/fetch_thoughts.php";
$tpl->assign('ay_thoughts', $ay_thoughts);
$html = $tpl->fetch("modules/improve/distorted_thoughts/thought_entries.tpl");
$objResponse->assign("thought_entries", "innerHTML", $html);
$objResponse->call("reset_input");
} elseif ($table == $tbl_da_scale_results || $table == $tbl_bd_scale_results) {
$i = 0;
$dataValid = 1;
$mysqldate = date('Y-m-d H:i:s', time());
//check if all items have been answered
for ($i = 1; $i <= $data['items_total']; $i++) {
if (!isset($data[$i])) {
$objResponse->alert('Please answer all items');
// TODO put string in language file
$dataValid = 0;
break;
}
}
//TODO store aggregated values in user table
//all items have been answered
if ($dataValid == 1) {
$bd_total_score = 0;
$da_total_score[0] = $da_total_score[1] = $da_total_score[2] = $da_total_score[3] = $da_total_score[4] = $da_total_score[5] = $da_total_score[6] = 0;
//insert new entry
$scale_data = new ModifyEntry();
$scale_data->table = $table;
for ($i = 1; $i <= $data['items_total']; $i++) {
if (isset($data[$i])) {
$scale_data->cols = 'userID, itemID, value, date';
$scale_data->values = " '" . $user_data['ID'] . "', '" . $i . "', '" . $data[$i] . "', '" . $mysqldate . "' ";
$scale_data->insert();
if ($scale_data->errno() > 0) {
break;
}
if ($table == $tbl_da_scale_results) {
switch (true) {
case $i <= 5:
$da_total_score[0] = $da_total_score[0] + $data[$i];
break;
case $i <= 10:
$da_total_score[1] = $da_total_score[1] + $data[$i];
break;
case $i <= 15:
$da_total_score[2] = $da_total_score[2] + $data[$i];
break;
case $i <= 20:
$da_total_score[3] = $da_total_score[3] + $data[$i];
break;
case $i <= 25:
$da_total_score[4] = $da_total_score[4] + $data[$i];
break;
case $i <= 30:
$da_total_score[5] = $da_total_score[5] + $data[$i];
break;
case $i <= 35:
$da_total_score[6] = $da_total_score[6] + $data[$i];
break;
}
}
if ($table == $tbl_bd_scale_results) {
$bd_total_score = $bd_total_score + $data[$i];
}
}
}
unset($scale_data);
$scale_data = new ModifyEntry();
$scale_data->table = $tbl_users;
if ($table == $tbl_da_scale_results) {
ksort($da_total_score);
}
if ($table == $tbl_da_scale_results) {
$scale_data->changes = " da_latest_score = '" . serialize($da_total_score) . "' ";
} else {
$scale_data->changes = " bd_latest_score = '" . $bd_total_score . "' ";
}
$scale_data->condition = " ID = '" . $user_data['ID'] . "' ";
$scale_data->update();
if ($scale_data->errno() > 0) {
break;
}
if ($table == $tbl_da_scale_results) {
$user_data['da_latest_score'] = serialize($da_total_score);
}
if ($table == $tbl_bd_scale_results) {
$user_data['bd_latest_score'] = $bd_total_score;
}
if (mod_memcache == 1) {
$memcache->replace($mem_key1, $user_data, false);
} else {
$_SESSION['$mem_key1'] = $user_data;
}
}
//update cached data in memcache or session
//$l["token"] = substr($_COOKIE["l"], 3, -35);
if ($table == $tbl_da_scale_results) {
$mem_key2 = "da_scale_data_" . $l["token"];
$mem_key2a = "da_scale_sep_strings_" . $l["token"];
$mem_key2b = "da_scale_sep_dates_" . $l["token"];
if (mod_memcache == 1) {
$memcache->delete($mem_key2);
$memcache->delete($mem_key2a);
$memcache->delete($mem_key2b);
} else {
unset($_SESSION['$mem_key2']);
unset($_SESSION['$mem_key2a']);
unset($_SESSION['$mem_key2b']);
}
}
if ($table == $tbl_bd_scale_results) {
$mem_key3 = "bd_scale_data_" . $l["token"];
if (mod_memcache == 1) {
$memcache->delete($mem_key3);
} else {
unset($_SESSION['$mem_key3']);
}
}
//redirect to overview/result page
if ($dataValid == 1 && $scale_data->errno() == 0 && $table == $tbl_da_scale_results) {
$objResponse->redirect(ROOT_DIR . 'analyze/da_scale/index.html');
}
if ($dataValid == 1 && $scale_data->errno() == 0 && $table == $tbl_bd_scale_results) {
$objResponse->redirect(ROOT_DIR . 'analyze/bd_scale/index.html');
}
unset($scale_data);
}
return $objResponse;
}
$positionID++;
}
$count++;
}
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();
}
}
function updatedata($table, $part, $data, $id = NULL)
{
//global $tpl;
global $memcache;
global $l;
global $tpl;
global $user_data;
global $getmonth;
$objResponse = new xajaxResponse();
//include('settings/template.php');
include 'settings/tables.php';
if ($user_data == '') {
require_once 'lib/functions/get_userdata.php';
}
//update progress state of a goal
if ($table == $tbl_goals && $part == 'progress') {
require_once 'lib/functions/convert_date.php';
$goals = new ModifyEntry();
$goals->table = $table;
switch ($data) {
case 0:
$progress = 0;
break;
case 1:
$progress = 20;
break;
case 2:
$progress = 40;
break;
case 3:
$progress = 50;
break;
case 4:
$progress = 60;
break;
case 5:
$progress = 80;
break;
case 6:
$progress = 100;
break;
}
$achieved_date = date('Y-m-d H:i:s', time());
if ($progress == 100) {
$goals->changes = " progress = '" . $progress . "', achieved = '" . $achieved_date . "' ";
} else {
$goals->changes = " progress = '" . $progress . "', achieved = '' ";
}
$goals->condition = " ID = '{$id}' ";
$goals->update();
unset($goals);
$ay_goals["progress"] = $progress;
$ay_goals["achieved"] = convert_date($achieved_date, 0, $getmonth);
$tpl->assign('goal', $ay_goals);
$html = $tpl->fetch("modules/improve/goals/achieved.tpl");
$objResponse->assign("achieved_" . $id, "innerHTML", $html);
//no refresh necessary as dropdown has latest change
} elseif ($table == $tbl_goals && $part == 'update_entry') {
$goals = new ModifyEntry();
$goals->table = $table;
$ay_entry['entry_org'] = strip_tags($data);
// $diary->changes = " entry = '".$data['edit_entry_inp']."' ";
$goals->changes = " goal = '" . $ay_entry['entry_org'] . "' ";
$goals->condition = " ID = '{$id}' ";
$goals->update();
unset($goals);
$objResponse->setReturnValue($ay_entry);
} elseif ($table == $tbl_distorted_thoughts && $part == 'update_entry') {
$thoughts = new ModifyEntry();
$thoughts->table = $table;
$get_values = explode("%%%!", $data);
$ay_entry['thought'] = strip_tags($get_values[0]);
$ay_entry['response'] = strip_tags($get_values[1]);
$ay_entry['action'] = strip_tags($get_values[2]);
// $diary->changes = " entry = '".$data['edit_entry_inp']."' ";
$thoughts->changes = " thought = '" . $ay_entry['thought'] . "', response = '" . $ay_entry['response'] . "', action = '" . $ay_entry['action'] . "' ";
$thoughts->condition = " ID = '{$id}' ";
$thoughts->update();
unset($thoughts);
$objResponse->setReturnValue($ay_entry);
} elseif ($table == $tbl_distorted_thoughts && $part == 'update_status') {
$thoughts = new ModifyEntry();
$thoughts->table = $table;
// $diary->changes = " entry = '".$data['edit_entry_inp']."' ";
$thoughts->changes = " status = '" . $data . "' ";
$thoughts->condition = " ID = '{$id}' ";
$thoughts->update();
unset($thoughts);
} elseif ($table == $tbl_users && $part == 'update_desc') {
$update_desc = new ModifyEntry();
$update_desc->table = $table;
//$desc_me = mysql_real_escape_string($data['desc_me']);
$update_desc->changes = " description = '" . $data['desc_me'] . "' ";
$update_desc->condition = " ID = '" . $user_data['ID'] . "' ";
$update_desc->update();
unset($update_desc);
//update cached user object
// $mem_key1 = "user_data_".$l["token"];
$user_data['description'] = $data['desc_me'];
if (mod_memcache == 1) {
$memcache->replace($mem_key1, $user_data, false);
} else {
$_SESSION['$mem_key1'] = $user_data;
}
//TODO refresh view
$objResponse->assign("desc_me", "innerHTML", $data['desc_me']);
$objResponse->assign("inp_me", "value", $data['desc_me']);
$objResponse->assign("desc_me", "style.display", "block");
if ($user_data['description'] == '') {
$objResponse->assign("initial_msg", "style.display", "block");
$objResponse->assign("desc_input", "style.display", "block");
$objResponse->assign("desc_edit", "style.display", "none");
} else {
$objResponse->assign("desc_edit", "style.display", "block");
$objResponse->assign("initial_msg", "style.display", "none");
$objResponse->assign("desc_input", "style.display", "none");
}
} elseif ($table == $tbl_diary && $part == 'update_entry') {
$diary = new ModifyEntry();
$diary->table = $table;
$ay_entry['entry_org'] = strip_tags($data);
// $diary->changes = " entry = '".$data['edit_entry_inp']."' ";
$diary->changes = " entry = '" . $ay_entry['entry_org'] . "' ";
$diary->condition = " ID = '{$id}' ";
$diary->update();
unset($diary);
// The Regular Expression filter
$reg_exUrl = "!((?:www|http://)[^ ]+)!";
$ay_entry['entry_new_string'] = $ay_entry['entry_org'];
// Check if there is a url in the text
if (preg_match($reg_exUrl, $ay_entry['entry_org'], $url)) {
// make the urls hyper links
if (substr($url[0], 0, 3) == 'www') {
$ay_entry['entry_new_string'] = preg_replace($reg_exUrl, '<a href="http://' . $url[0] . '" target="_blank">' . $url[0] . '</a>', $ay_entry['entry_org']);
} else {
$ay_entry['entry_new_string'] = preg_replace($reg_exUrl, '<a href="' . $url[0] . '" target="_blank">' . $url[0] . '</a>', $ay_entry['entry_org']);
}
}
$objResponse->setReturnValue($ay_entry);
}
return $objResponse;
}
if ($links_c_new_german[$count] != "" && $links_c_new_english[$count] != "") {
$links_c_new->values = "'{$links_c_new_german[$count]}', '{$links_c_new_english[$count]}', '{$positionID}', '0' ";
$links_c_new->insert();
$positionID++;
}
$count++;
}
unset($links_c_edit);
}
/******************************************/
/* design :: Edit one or more entries */
if (count($_POST["links_c_german"]) > 0) {
$links_c_edit = new ModifyEntry();
$links_c_edit->table = $tbl_links_c;
$links_c_edit->changes = " visibility = '0' ";
$links_c_edit->update();
$count = 0;
foreach ($_POST["links_c_german"] as $element) {
$id = $links_c_id[$count];
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);
}
$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;
if ($new_latest_score == -1) {
$scale_data->changes = " bd_latest_score = '" . $new_latest_score . "' ";
} else {
$scale_data->changes = " bd_latest_score = '500' ";
}
$scale_data->condition = " ID = '" . $user_data['ID'] . "' ";
$scale_data->update();
unset($scale_data);
$user_data['bd_latest_score'] = $new_latest_score;
if (mod_memcache == 1) {
$memcache->replace($mem_key1, $user_data, false);
} else {
$_SESSION['$mem_key1'] = $user_data;
}
}
if (mod_memcache == 1) {
$memcache->delete($mem_key3);
} else {
unset($_SESSION['$mem_key3']);
}
header("Location:" . ROOT_DIR . "analyze/bd_scale");
}
$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);
/******************************************/
$links_l_new->values = "'{$links_l_new_cid[$count]}', '{$links_l_new_link[$count]}', '{$links_l_new_description[$count]}', '{$links_l_new_description_EN[$count]}', '{$positionID}', '0' ";
$links_l_new->insert();
$positionID++;
}
$count++;
}
unset($links_l_new);
}
/******************************************/
/* design :: Edit one or more entries */
if (count($_POST["links_l_link"]) > 0) {
$links_l_edit = new ModifyEntry();
$links_l_edit->table = $tbl_links;
$links_l_edit->condition = " cid = '{$links_l_cid['0']}' ";
$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);
}
function move($direction, $table, $position, $cid)
{
global $tpl;
$objResponse = new xajaxResponse();
/* Distinguish between up and down movement */
if ($direction == "up") {
$delimiter = "<";
$order = "DESC";
//$modify1 = "position = position-1";
//$modify2 = "position = position+1";
} else {
$delimiter = ">";
$order = "ASC";
//$modify1 = "position = position+1";
//$modify2 = "position = position-1";
}
/***********************************/
/* Let's move */
require_once 'lib/select.php';
require_once 'lib/modify.php';
$select = new SelectEntrys();
$select->table = $table;
$select->cols = 'position';
$select->condition = " position {$delimiter} '{$position}' ";
if ($cid) {
$select->condition .= " AND cid = '{$cid}' ";
}
$select->order = "position {$order}";
$select->limit = '1';
$select->module = '';
$select->template = '';
$position_less = $select->row();
$select->cols = 'id';
$position_less_id = $select->row();
$update = new ModifyEntry();
$update->table = $table;
if ($position > 1 && $direction == "up" || $position_less > 0 && $direction == "down") {
$update->condition = " position = '{$position}' ";
if ($cid) {
$update->condition .= " AND cid = '{$cid}' ";
}
$update->changes = " position = '{$position_less}' ";
$update->update();
$update->condition = " id = '{$position_less_id}' ";
if ($cid) {
$update->condition .= " AND cid = '{$cid}' ";
}
$update->changes = " position = '{$position}' ";
$update->update();
}
unset($select);
unset($update);
/***********************************/
/* Get data in new order */
require_once 'settings/config.php';
require_once 'settings/tables.php';
require_once 'settings/template.php';
if ($table == $tbl_profile) {
$profile = new SelectEntrys();
$profile->cols = 'id, german, english, value, value_EN, position';
$profile->table = $table;
$profile->order = 'position';
$profile->multiSelect = '1';
$tpl->assign('array_profile', $profile->row());
unset($profile);
$html = $tpl->fetch("shortprofile_content.tpl");
$objResponse->assign("layout_navi_profile", "innerHTML", $html);
$html = $tpl->fetch("admin/settings_profile_fields.tpl");
$objResponse->assign("layout_set_profile", "innerHTML", $html);
}
if ($table == $tbl_ref) {
$ref = new SelectEntrys();
$ref->cols = 'id, link, description, description_EN, position';
$ref->table = $table;
$ref->order = 'position';
$ref->multiSelect = '1';
$tpl->assign('array_ref', $ref->row());
unset($ref);
$html = $tpl->fetch("quicklinks_content.tpl");
$objResponse->assign("layout_navi_ref", "innerHTML", $html);
$html = $tpl->fetch("admin/settings_quicklinks_fields.tpl");
$objResponse->assign("layout_set_ref", "innerHTML", $html);
}
if ($table == $tbl_design) {
$design = new SelectEntrys();
$design->cols = 'id, german, english, hexcode, imgfolder, position';
$design->table = $table;
$design->order = 'position';
$design->multiSelect = '1';
$tpl->assign('array_design', $design->row());
unset($design);
$html = $tpl->fetch("set_design.tpl");
$objResponse->assign("layout_navi_design", "innerHTML", $html);
$html = $tpl->fetch("admin/settings_design_fields.tpl");
$objResponse->assign("layout_set_design", "innerHTML", $html);
$objResponse->includeScript("js/change_settings.js");
$objResponse->call("reload_tpl");
}
if ($table == $tbl_links_c) {
$links_c = new SelectEntrys();
$links_c->cols = ' id, german, english, position, visibility ';
$links_c->table = $tbl_links_c;
$links_c->order = "position";
$links_c->multiSelect = '1';
$array_c = $links_c->row();
unset($links_c);
$tpl->assign('array_c', $array_c);
$html = $tpl->fetch("admin/links_c.tpl");
$objResponse->assign("layout_links_c", "innerHTML", $html);
}
if ($table == $tbl_links) {
$links_l = new SelectEntrys();
$links_l->cols = 'id, cid, link, description, description_EN, position, visibility';
$links_l->table = $table;
$links_l->condition = "cid = '{$cid}' ";
// due to performance concerns
$links_l->order = 'cid, position';
$links_l->multiSelect = '1';
$array_l = $links_l->row();
foreach ($array_l as $array1 => $array2) {
$array[$array2["cid"]][$array2["id"]] = array('id' => $array2["id"], 'cid' => $array2["cid"], 'link' => $array2["link"], 'description' => $array2["description"], 'description_EN' => $array2["description_EN"], 'position' => $array2["position"], 'visibility' => $array2["visibility"]);
}
$tpl->assign("this", $cid);
$tpl->assign("array", $array);
unset($links_l);
$html = $tpl->fetch("admin/links_l.tpl");
$p_name = "layout_links_l_" . $cid;
$objResponse->assign($p_name, "innerHTML", $html);
}
return $objResponse;
/***********************************/
}
