function lhg_get_guid_from_uid($uid)
{
$guid = lhg_get_guid($uid);
return $guid;
}
function lhg_update_donation_settings()
{
global $lang;
global $lhg_price_db;
error_log("Update settings");
//echo "Found??: ".$_POST['lhg_user_donation_target'];
if (!isset($_POST['lhg_user_donation_target'])) {
return;
}
//validate submitted value otherwise set to default
$user_donation_target = $_POST['lhg_user_donation_target'];
// get user id
// check if own or other user's profile is edited
$user_id = get_current_user_id();
$edituser = $_POST['user_id'];
if ($edituser > 0 && $edituser != $user_id) {
#error_log("Editing of other user: "******"UID settings to be conged for changed: $user_id - $guid");
}
// first add to history DB before value is overwritten
$timestamp = time();
// check if old value exists, if not, store for history reasons
$sql = "SELECT id FROM `lhgtransverse_donations` WHERE guid = \"" . $guid . "\" ";
$result = $lhg_price_db->get_var($sql);
if ($result == "") {
# old value was not stored. Entry needed. First get old value
#error_log("No entry found for $guid");
$sql = "SELECT * FROM `lhgtransverse_users` WHERE id = \"" . $guid . "\" ";
$results = $lhg_price_db->get_results($sql);
#var_dump($results);
#error_log("DB res: ".$results[0]->donation_target_com);
#error_log("DB res: ".$results[0]->donation_target_de);
if ($results[0]->donation_target_com != "" && $results[0]->donation_target_date_com > $results[0]->donation_target_date_de) {
# found an old and valid com value
$sql = "INSERT INTO lhgtransverse_donations (guid, timestamp, donation_target) VALUES (%s, %s, %s) ";
$safe_sql = $lhg_price_db->prepare($sql, $guid, $timestamp - 1, $results[0]->donation_target_com);
$result = $lhg_price_db->query($safe_sql);
} elseif ($results[0]->donation_target_d != "" && $results[0]->donation_target_date_de > $results[0]->donation_target_date_com) {
# found an old and valid de value
$sql = "INSERT INTO lhgtransverse_donations (guid, timestamp, donation_target) VALUES (%s, %s, %s) ";
$safe_sql = $lhg_price_db->prepare($sql, $guid, $timestamp - 1, $results[0]->donation_target_de);
$result = $lhg_price_db->query($safe_sql);
} else {
#nothing found, fallback value used
# found an old and valid de value
$sql = "INSERT INTO lhgtransverse_donations (guid, timestamp, donation_target) VALUES (%s, %s, %s) ";
$safe_sql = $lhg_price_db->prepare($sql, $guid, $timestamp - 1, 1);
$result = $lhg_price_db->query($safe_sql);
}
}
#write new settings to DB
$sql = "INSERT INTO lhgtransverse_donations (guid, timestamp, donation_target) VALUES (%s, %s, %s) ";
$safe_sql = $lhg_price_db->prepare($sql, $guid, $timestamp, $user_donation_target);
$result = $lhg_price_db->query($safe_sql);
//afterwards, modify user entires (locally and in transverse DB)
update_user_meta($user_id, 'user_donation_target', $user_donation_target);
//also store in priceDB
if ($lang != "de") {
lhg_update_userdb_by_uid("donation_target_com", $user_id, $user_donation_target);
}
if ($lang == "de") {
lhg_update_userdb_by_uid("donation_target_de", $user_id, $user_donation_target);
}
if ($lang != "de") {
lhg_update_userdb_by_uid("donation_target_date_com", $user_id, time());
}
if ($lang == "de") {
lhg_update_userdb_by_uid("donation_target_date_de", $user_id, time());
}
}
function lhg_donation_testing($attr, $content)
{
global $lang;
$uid = get_current_user_id();
$guid = lhg_get_guid($uid);
# user accounts are currently hard coded. Will be removed after beta testing
if ($lang != "de" and $uid == 24294 or $guid == 1 or $uid == 1) {
return do_shortcode($content);
}
return;
}
