X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=0.2.1%2Fshow_bonus.php;h=7e83f9b096f05262f7d724fabc37ba1629198e94;hb=8e1498142233eff66b72904ad0428876eee1ce15;hp=ebf4acd774e3dd32a244a7bb1ffaeee25a036d88;hpb=985d79f06163e5957c3f40b5a71ce85be9048f8e;p=mailer.git diff --git a/0.2.1/show_bonus.php b/0.2.1/show_bonus.php index ebf4acd774..7e83f9b096 100644 --- a/0.2.1/show_bonus.php +++ b/0.2.1/show_bonus.php @@ -1,140 +1,140 @@ - 0) && ($_GET['d'] > 0) && (!empty($_GET['t']))) - { - // Set row name - $t = ""; - switch ($_GET['t']) - { - case "bonusid": - $t = "bonus_id"; - break; - - case "mailid": - $t = "mail_id"; - break; - } - if (!empty($t)) - { - // Check for data - $result = SQL_QUERY_ESC("SELECT DISTINCT d.sex, d.surname, d.family, b.level, b.points -FROM "._MYSQL_PREFIX."_user_data AS d -RIGHT JOIN "._MYSQL_PREFIX."_bonus_turbo AS b -ON d.userid=b.userid -WHERE d.status='CONFIRMED' AND d.userid=%d AND b.".$t."='%s' LIMIT 1", - array(bigintval($_GET['uid']), bigintval($_GET['d'])), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) - { - // Load data - list($sex, $sname, $fname, $level, $points) = SQL_FETCHROW($result); - - // Prepare constants for the pre-template - define('__SALUT' , TRANSLATE_SEX($sex)); - define('__SNAME' , $sname); - define('__FNAME' , $fname); - define('__RANK' , $level); - define('__POINTS' , $points); - define('__MAILID' , $_GET['d']); - define('__RANK_ROWS', BONUS_MAKE_RANK_ROWS(bigintval($_GET['d']), $t, bigintval($_GET['uid']))); - - // Constant created within previous function which contains informations for current user's ranking position: - // __YOUR_RANKING_LINE - - // Load pre-template - define('__BONUS_MSG', LOAD_TEMPLATE("show_bonus_msg", true)); - } - else - { - // No data found - define('__BONUS_MSG', "".BONUS_SHOW_NO_DATA.""); - } - - // Free memory - SQL_FREERESULT($result); - } - else - { - // Wrong type entered - define('__BONUS_MSG', "".BONUS_SHOW_WRONG_TYPE.""); - } - } - else - { - // Wrong call! - define('__BONUS_MSG', "".BONUS_SHOW_WRONG_CALL.""); - } - - // Load send_bonus header template (for your banners, e.g.?) - define('__BONUS_HEADER', LOAD_TEMPLATE("show_bonus_header", true)); - - // Load show_bonus footer template (for your banners, e.g.?) - define('__BONUS_FOOTER', LOAD_TEMPLATE("show_bonus_footer", true)); - - // Total ranks who can win - define('__BONUS_TOTAL_RANKS', $CONFIG['bonus_ranks']); - - // Load final template - LOAD_TEMPLATE("show_bonus"); - - // Include footer - include(PATH."inc/footer.php"); -} - else -{ - // You have to configure first! - LOAD_URL(URL."/install.php"); -} -// Really all done here... ;-) -?> + 0) && ($_GET['d'] > 0) && (!empty($_GET['t']))) + { + // Set row name + $t = ""; + switch ($_GET['t']) + { + case "bonusid": + $t = "bonus_id"; + break; + + case "mailid": + $t = "mail_id"; + break; + } + if (!empty($t)) + { + // Check for data + $result = SQL_QUERY_ESC("SELECT DISTINCT d.sex, d.surname, d.family, b.level, b.points +FROM "._MYSQL_PREFIX."_user_data AS d +RIGHT JOIN "._MYSQL_PREFIX."_bonus_turbo AS b +ON d.userid=b.userid +WHERE d.status='CONFIRMED' AND d.userid=%d AND b.".$t."='%s' LIMIT 1", + array(bigintval($_GET['uid']), bigintval($_GET['d'])), __FILE__, __LINE__); + if (SQL_NUMROWS($result) == 1) + { + // Load data + list($sex, $sname, $fname, $level, $points) = SQL_FETCHROW($result); + + // Prepare constants for the pre-template + define('__SALUT' , TRANSLATE_SEX($sex)); + define('__SNAME' , $sname); + define('__FNAME' , $fname); + define('__RANK' , $level); + define('__POINTS' , $points); + define('__MAILID' , $_GET['d']); + define('__RANK_ROWS', BONUS_MAKE_RANK_ROWS(bigintval($_GET['d']), $t, bigintval($_GET['uid']))); + + // Constant created within previous function which contains informations for current user's ranking position: + // __YOUR_RANKING_LINE + + // Load pre-template + define('__BONUS_MSG', LOAD_TEMPLATE("show_bonus_msg", true)); + } + else + { + // No data found + define('__BONUS_MSG', "".BONUS_SHOW_NO_DATA.""); + } + + // Free memory + SQL_FREERESULT($result); + } + else + { + // Wrong type entered + define('__BONUS_MSG', "".BONUS_SHOW_WRONG_TYPE.""); + } + } + else + { + // Wrong call! + define('__BONUS_MSG', "".BONUS_SHOW_WRONG_CALL.""); + } + + // Load send_bonus header template (for your banners, e.g.?) + define('__BONUS_HEADER', LOAD_TEMPLATE("show_bonus_header", true)); + + // Load show_bonus footer template (for your banners, e.g.?) + define('__BONUS_FOOTER', LOAD_TEMPLATE("show_bonus_footer", true)); + + // Total ranks who can win + define('__BONUS_TOTAL_RANKS', $CONFIG['bonus_ranks']); + + // Load final template + LOAD_TEMPLATE("show_bonus"); + + // Include footer + include(PATH."inc/footer.php"); +} + else +{ + // You have to configure first! + LOAD_URL(URL."/install.php"); +} +// Really all done here... ;-) +?>