X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=0.2.1%2Finc%2Fmodules%2Fadmin%2Fwhat-add_points.php;fp=0.2.1%2Finc%2Fmodules%2Fadmin%2Fwhat-add_points.php;h=2a840db9b19c9ed785a1d29d151262805e555814;hp=173d1d6976383cd9c3b38dae8b38b07c83c13d8d;hb=7bc25dd08431c94ce9edca131d56c1a36b13c28a;hpb=157ee010917df5ca07e6d31b42f67417b2516d74 diff --git a/0.2.1/inc/modules/admin/what-add_points.php b/0.2.1/inc/modules/admin/what-add_points.php index 173d1d6976..2a840db9b1 100644 --- a/0.2.1/inc/modules/admin/what-add_points.php +++ b/0.2.1/inc/modules/admin/what-add_points.php @@ -1,144 +1,144 @@ - 0)) - { - define('__POINTS_VALUE', $_POST['points']); - $result_main = SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE status='CONFIRMED' ORDER BY userid", __FILE__, __LINE__); - while (list($uid) = SQL_FETCHROW($result_main)) - { - // User ID found in URL so we use this give him some credits - $result = SQL_QUERY_ESC("SELECT surname, family, email FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d AND status='CONFIRMED' LIMIT 1", - array(bigintval($uid)), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) - { - // Selected user does exist - list($sname, $fname, $email) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - - if ((isset($_POST['ok'])) && (!empty($_POST['points']))) - { - // Ok, add points and send an email to him... - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET points=points+(%s) WHERE userid=%d AND ref_depth='0' LIMIT 1", - array($_POST['points'], bigintval($uid)), __FILE__, __LINE__); - - // Update mediadata as well - if (GET_EXT_VERSION("mediadata") >= "0.0.4") - { - // Update database - MEDIA_UPDATE_ENTRY(array("total_points"), "add", $_POST['points']); - } - - // Load email template and send email away - $msg = LOAD_EMAIL_TEMPLATE("add-points", $_POST['reason'], $uid); - SEND_EMAIL($email, ADMIN_ADD_SUBJ, $msg); - } - } - } - - // Free memory - SQL_FREERESULT($result_main); - - // Output message - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_ALL_POINTS_ADDED); - } - else - { - // Display form add points - LOAD_TEMPLATE("admin_add_points_all"); - } -} - elseif (!empty($_GET['u_id'])) -{ - // User ID found in URL so we use this give him some credits - $result = SQL_QUERY_ESC("SELECT surname, family, email FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d AND status='CONFIRMED' LIMIT 1", - array(bigintval($_GET['u_id'])), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) - { - // Selected user does exist - list($sname, $fname, $email) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - - if ((isset($_POST['ok'])) && (!empty($_POST['points']))) - { - // Ok, add points and send an email to him... - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET points=points+(%s) WHERE userid=%d AND ref_depth='0' LIMIT 1", - array($_POST['points'], bigintval($_GET['u_id'])), __FILE__, __LINE__); - - // Remember points in constant - define('__POINTS_VALUE', $_POST['points']); - - // Message laden - $msg = LOAD_EMAIL_TEMPLATE("add-points", $_POST['reason'], $_GET['u_id']); - - SEND_EMAIL($email, ADMIN_ADD_SUBJ, $msg); - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_POINTS_ADDED); - } - else - { - // Opps, missing form here - define('__USER_VALUE', "".$sname." ".$fname.""); - define('__UID_VALUE', $_GET['u_id']); - LOAD_TEMPLATE("admin_add_points"); - } - } - else - { - // User not found! - OUTPUT_HTML ("".ADMIN_MEMBER_404_1.$_GET['u_id'].ADMIN_MEMBER_404_2.""); - } -} - else -{ - // Output selection form with all confirmed user accounts listed - ADD_MEMBER_SELECTION_BOX(true); -} -CLOSE_TABLE(); -// -?> + 0)) + { + define('__POINTS_VALUE', $_POST['points']); + $result_main = SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE status='CONFIRMED' ORDER BY userid", __FILE__, __LINE__); + while (list($uid) = SQL_FETCHROW($result_main)) + { + // User ID found in URL so we use this give him some credits + $result = SQL_QUERY_ESC("SELECT surname, family, email FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d AND status='CONFIRMED' LIMIT 1", + array(bigintval($uid)), __FILE__, __LINE__); + if (SQL_NUMROWS($result) == 1) + { + // Selected user does exist + list($sname, $fname, $email) = SQL_FETCHROW($result); + SQL_FREERESULT($result); + + if ((isset($_POST['ok'])) && (!empty($_POST['points']))) + { + // Ok, add points and send an email to him... + $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET points=points+(%s) WHERE userid=%d AND ref_depth='0' LIMIT 1", + array($_POST['points'], bigintval($uid)), __FILE__, __LINE__); + + // Update mediadata as well + if (GET_EXT_VERSION("mediadata") >= "0.0.4") + { + // Update database + MEDIA_UPDATE_ENTRY(array("total_points"), "add", $_POST['points']); + } + + // Load email template and send email away + $msg = LOAD_EMAIL_TEMPLATE("add-points", $_POST['reason'], $uid); + SEND_EMAIL($email, ADMIN_ADD_SUBJ, $msg); + } + } + } + + // Free memory + SQL_FREERESULT($result_main); + + // Output message + LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_ALL_POINTS_ADDED); + } + else + { + // Display form add points + LOAD_TEMPLATE("admin_add_points_all"); + } +} + elseif (!empty($_GET['u_id'])) +{ + // User ID found in URL so we use this give him some credits + $result = SQL_QUERY_ESC("SELECT surname, family, email FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d AND status='CONFIRMED' LIMIT 1", + array(bigintval($_GET['u_id'])), __FILE__, __LINE__); + if (SQL_NUMROWS($result) == 1) + { + // Selected user does exist + list($sname, $fname, $email) = SQL_FETCHROW($result); + SQL_FREERESULT($result); + + if ((isset($_POST['ok'])) && (!empty($_POST['points']))) + { + // Ok, add points and send an email to him... + $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET points=points+(%s) WHERE userid=%d AND ref_depth='0' LIMIT 1", + array($_POST['points'], bigintval($_GET['u_id'])), __FILE__, __LINE__); + + // Remember points in constant + define('__POINTS_VALUE', $_POST['points']); + + // Message laden + $msg = LOAD_EMAIL_TEMPLATE("add-points", $_POST['reason'], $_GET['u_id']); + + SEND_EMAIL($email, ADMIN_ADD_SUBJ, $msg); + LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_POINTS_ADDED); + } + else + { + // Opps, missing form here + define('__USER_VALUE', "".$sname." ".$fname.""); + define('__UID_VALUE', $_GET['u_id']); + LOAD_TEMPLATE("admin_add_points"); + } + } + else + { + // User not found! + OUTPUT_HTML ("".ADMIN_MEMBER_404_1.$_GET['u_id'].ADMIN_MEMBER_404_2.""); + } +} + else +{ + // Output selection form with all confirmed user accounts listed + ADD_MEMBER_SELECTION_BOX(true); +} +CLOSE_TABLE(); +// +?>