示例#1
0
function get_sponsor_list($strItemId = 'Blue Dragon')
{
    $strReturn = '';
    $objTmpUser = new clsUser(1);
    $resSQL = mysql_query("SELECT item_number as rank, quantity, option_selection1 as username, unix_timestamp, payment_gross as money FROM phpsuppo_3.paypal WHERE (item_name = 'One Week Sponsorship' OR item_name = 'Three Months Sponsorship') AND item_number = '{$strItemId}' AND payment_status = 'Completed' ORDER BY unix_timestamp DESC") or die(mysql_error());
    while ($arrPayPal = mysql_fetch_array($resSQL)) {
        if (check_valid_sponsor($arrPayPal) && $arrPayPal['username'] != 'NULL') {
            $strSafe = quote_smart($arrPayPal['username']);
            $resSQL2 = mysql_query("SELECT id FROM " . TBL_USER . " WHERE username = {$strSafe}") or die(mysql_error());
            $arrRes2 = mysql_fetch_array($resSQL2);
            if ($arrRes2[ID] > 0) {
                $objTmpUser->set_userid($arrRes2[ID]);
                $strReturn .= stripslashes($objTmpUser->get_stat(NAME)) . '<br />';
            } else {
                // Missing an acc in one server, or if deleted (missing user)
                //                 $strReturn .= 'Fierce ' . $arrPayPal['rank'] . '<br />';
            }
        } elseif (check_valid_sponsor($arrPayPal)) {
            $strReturn .= 'Anonymous ' . $arrPayPal['rank'] . '<br />';
        }
    }
    return $strReturn;
}
示例#2
0
function get_sponsor_badge($iUserid)
{
    $strImg = '';
    // Check if user still exists in the DB
    $strSQL = "SELECT * FROM " . TBL_USER . " WHERE id = {$iUserid}";
    if (mysql_num_rows(mysql_query($strSQL)) > 0) {
        // Sponsor Dragons
        $objTmpUser = new clsUser($iUserid);
        $strUsername = $objTmpUser->get_user_info(USERNAME);
        $resSQL = mysql_query("SELECT item_number as rank, quantity, option_selection1 as username, unix_timestamp, payment_gross as money FROM phpsuppo_3.paypal WHERE (item_name = 'One Week Sponsorship' OR item_name = 'Three Months Sponsorship') AND option_selection1 = '{$strUsername}' AND payment_status = 'Completed' ORDER BY unix_timestamp DESC LIMIT 1");
        $arrPayPal = mysql_fetch_array($resSQL);
        $iRows = mysql_num_rows($resSQL);
        if ($iRows == 1) {
            $strRank = $arrPayPal['rank'];
            include_once 'inc/pages/sponsors.inc.php';
            if (check_valid_sponsor($arrPayPal)) {
                $strPic = explode(" ", $strRank);
                $strPic = $strPic[1] . "_" . $strPic[0];
                $strImg = HOST_PICS . strtolower($strPic) . '.gif';
                $strImg = '<img src="' . $strImg . '" alt="' . $strRank . '" border="0">';
            }
        }
    }
    return $strImg;
}