\n"; // Is an entry there? if (SQL_NUMROWS($result) == 1) { // Ok, congratulation again! Here's your gift from us... $data = SQL_FETCHARRAY($result, false); // Is the account confirmed? if ($data['status'] == 'CONFIRMED') { // Set mode depending on how many mails the member has to confirm $locked = false; if (($data['ref_payout'] > 0) && (getConfig('allow_direct_pay') != 'Y')) $locked = true; // Add points to account unset($GLOBALS['ref_level']); ADD_POINTS_REFSYSTEM('birthday_confirm', $uid, $data['points'], false, '0', $locked, strtolower(getConfig('birthday_mode'))); // Update mediadata if version is 0.0.4 or newer if (GET_EXT_VERSION('mediadata') >= '0.0.4') { // Update database MEDIA_UPDATE_ENTRY(array('total_points'), 'add', $data['points']); } // Remove entry from table SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_birthday` WHERE userid=%s AND chk_value='%s' LIMIT 1", array($uid, $chk), __FILE__, __LINE__); // Transfer data to constants for the template define('__GENDER', TRANSLATE_GENDER($data['gender'])); define('__SNAME' , $data['surname']); define('__FNAME' , $data['family']); define('__GIFT' , TRANSLATE_COMMA($data['points'])); // Load message from template define('__MSG', LOAD_TEMPLATE('birthday_msg', true)); } else { // Unconfirmed / locked accounts cannot get points define('__MSG', sprintf(getMessage('BIRTHDAY_CANNOT_STATUS'), TRANSLATE_STATUS($data['status']))); } } else { // Cannot load data! define('__MSG', getMessage('BIRTHDAY_CANNOT_LOAD_DATA')); } // Free memory SQL_FREERESULT($result); // Set this because we have no module in URI $GLOBALS['module'] = 'birthday_confirm'; // Include header LOAD_INC('inc/header.php'); // Load birthday header template (for your banners, e.g.?) define('__BIRTHDAY_HEADER', LOAD_TEMPLATE('birthday_header', true)); // Load birthday footer template (for your banners, e.g.?) define('__BIRTHDAY_FOOTER', LOAD_TEMPLATE('birthday_footer', true)); // Load final template and output it LOAD_TEMPLATE('birthday_confirm'); // Include footer LOAD_INC('inc/footer.php'); } else { // You have to install first! LOAD_URL('install.php'); } // Really all done here... ;-) shutdown(); // ?>