X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=0.2.1%2Finc%2Flibs%2Fdoubler_functions.php;h=057c76bd039b6131fccd2cc889db66f7af01ffb1;hb=7bc25dd08431c94ce9edca131d56c1a36b13c28a;hp=307d12273e3277a3606e0cbf9c792724794b6fdb;hpb=157ee010917df5ca07e6d31b42f67417b2516d74;p=mailer.git diff --git a/0.2.1/inc/libs/doubler_functions.php b/0.2.1/inc/libs/doubler_functions.php index 307d12273e..057c76bd03 100644 --- a/0.2.1/inc/libs/doubler_functions.php +++ b/0.2.1/inc/libs/doubler_functions.php @@ -1,160 +1,160 @@ - 0) - { - // Load entries only from a single user - $ADD = " AND userid='".bigintval($uid)."'"; - $MODE = "member"; $COLS = "4"; $DT_MODE = "2"; - $NOT_FOUND = DOUBLER_MEMBER_NO_ENTRIES_FOUND; - } - else - { - // Guest mode! - $MODE = "guest"; $COLS = "3"; $DT_MODE = "3"; - $NOT_FOUND = DOUBLER_GUEST_NO_ENTRIES_FOUND; - } - - if (($done == "Y") && ($sort == "ASC")) - { - // Already payed out points (latest payouts first) - $limit = $CONFIG['doubler_display_old']; - } - elseif ($sort == "ASC") - { - // List entries which will receive their payout soon - $limit = $CONFIG['doubler_display_pay']; - } - elseif ($sort == "DESC") - { - // Newest entries - $limit = $CONFIG['doubler_display_new']; - } - - // List entries - $result = SQL_QUERY("SELECT userid, refid, points, timemark -FROM "._MYSQL_PREFIX."_doubler -WHERE completed='".$done."' AND is_ref='".$ref."'".$ADD." -ORDER BY timemark ".$sort." -LIMIT ".$limit, __FILE__, __LINE__); - - if (SQL_NUMROWS($result) > 0) - { - // List entries - $OUT = ""; $SW = 2; - while(list($uid, $rid, $points, $time) = SQL_FETCHROW($result)) - { - if (IS_ADMIN()) - { - // Set links to admin area - if ($uid > 0) { $uid = ADMIN_USER_PROFILE_LINK($uid); } else { $uid = "---"; } - if ($rid > 0) { $rid = ADMIN_USER_PROFILE_LINK($rid); } else { $rid = "---"; } - } - - // Prepare data for the row template - $content = array( - 'uid' => $uid, - 'rid' => $rid, - 'points' => TRANSLATE_COMMA($points), - 'stamp' => MAKE_DATETIME($time, $DT_MODE), - 'sw' => $SW, - ); - - // Load template and switch color - $OUT .= LOAD_TEMPLATE($MODE."_doubler_list_rows", true, $content); - $SW = 3 - $SW; - } - - // Free memory - SQL_FREERESULT($result); - } - else - { - // List no entries - $OUT = " - - ".LOAD_TEMPLATE("admin_settings_saved", true, $NOT_FOUND)." - -\n"; - } - - // Return template - return LOAD_TEMPLATE($MODE."_doubler_list", true, $OUT); -} -// -function DOUBLER_GET_TOTAL_POINTS_LEFT() -{ - global $CONFIG; - // Initialize variables - $points = "0"; - - if ($CONFIG['doubler_own'] == "Y") - { - // Take points from doubler's own account - $points += $CONFIG['doubler_points'] - $CONFIG['doubler_used']; - } - - if ($CONFIG['doubler_jackpot'] == "Y") - { - // Load jackpot - $result = SQL_QUERY("SELECT points FROM "._MYSQL_PREFIX."_jackpot WHERE ok='ok' LIMIT 1", __FILE__, __LINE__); - list($jackpot) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - - if (!empty($jackpot)) $points += $jackpot; - } - - if ($CONFIG['doubler_uid'] > 0) - { - // Get user's points - $user = GET_TOTAL_DATA($CONFIG['doubler_uid'], "user_points", "points"); - $points += $user; - } - - // Return value - return $points; -} -// -?> + 0) + { + // Load entries only from a single user + $ADD = " AND userid='".bigintval($uid)."'"; + $MODE = "member"; $COLS = "4"; $DT_MODE = "2"; + $NOT_FOUND = DOUBLER_MEMBER_NO_ENTRIES_FOUND; + } + else + { + // Guest mode! + $MODE = "guest"; $COLS = "3"; $DT_MODE = "3"; + $NOT_FOUND = DOUBLER_GUEST_NO_ENTRIES_FOUND; + } + + if (($done == "Y") && ($sort == "ASC")) + { + // Already payed out points (latest payouts first) + $limit = $CONFIG['doubler_display_old']; + } + elseif ($sort == "ASC") + { + // List entries which will receive their payout soon + $limit = $CONFIG['doubler_display_pay']; + } + elseif ($sort == "DESC") + { + // Newest entries + $limit = $CONFIG['doubler_display_new']; + } + + // List entries + $result = SQL_QUERY("SELECT userid, refid, points, timemark +FROM "._MYSQL_PREFIX."_doubler +WHERE completed='".$done."' AND is_ref='".$ref."'".$ADD." +ORDER BY timemark ".$sort." +LIMIT ".$limit, __FILE__, __LINE__); + + if (SQL_NUMROWS($result) > 0) + { + // List entries + $OUT = ""; $SW = 2; + while(list($uid, $rid, $points, $time) = SQL_FETCHROW($result)) + { + if (IS_ADMIN()) + { + // Set links to admin area + if ($uid > 0) { $uid = ADMIN_USER_PROFILE_LINK($uid); } else { $uid = "---"; } + if ($rid > 0) { $rid = ADMIN_USER_PROFILE_LINK($rid); } else { $rid = "---"; } + } + + // Prepare data for the row template + $content = array( + 'uid' => $uid, + 'rid' => $rid, + 'points' => TRANSLATE_COMMA($points), + 'stamp' => MAKE_DATETIME($time, $DT_MODE), + 'sw' => $SW, + ); + + // Load template and switch color + $OUT .= LOAD_TEMPLATE($MODE."_doubler_list_rows", true, $content); + $SW = 3 - $SW; + } + + // Free memory + SQL_FREERESULT($result); + } + else + { + // List no entries + $OUT = " + + ".LOAD_TEMPLATE("admin_settings_saved", true, $NOT_FOUND)." + +\n"; + } + + // Return template + return LOAD_TEMPLATE($MODE."_doubler_list", true, $OUT); +} +// +function DOUBLER_GET_TOTAL_POINTS_LEFT() +{ + global $CONFIG; + // Initialize variables + $points = "0"; + + if ($CONFIG['doubler_own'] == "Y") + { + // Take points from doubler's own account + $points += $CONFIG['doubler_points'] - $CONFIG['doubler_used']; + } + + if ($CONFIG['doubler_jackpot'] == "Y") + { + // Load jackpot + $result = SQL_QUERY("SELECT points FROM "._MYSQL_PREFIX."_jackpot WHERE ok='ok' LIMIT 1", __FILE__, __LINE__); + list($jackpot) = SQL_FETCHROW($result); + SQL_FREERESULT($result); + + if (!empty($jackpot)) $points += $jackpot; + } + + if ($CONFIG['doubler_uid'] > 0) + { + // Get user's points + $user = GET_TOTAL_DATA($CONFIG['doubler_uid'], "user_points", "points"); + $points += $user; + } + + // Return value + return $points; +} +// +?>