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; }
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; }