\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') == "N")) $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'))); // Remove entry from table $result = 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__); // 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']); } // Transfer data to constants for the template define('__GENDER', TRANSLATE_GENDER($data['gender'])); define('__SNAME', $data['surname']); define('__FNAME', $data['family']); define('__GIFT' , $data['points']); // Load message from template define('__MSG', LOAD_TEMPLATE("birthday_msg", true)); } else { // Unconfirmed / locked accounts cannot get points define('__MSG', BIRTHDAY_CANNOT_STATUS_1.TRANSLATE_STATUS($data['status']).BIRTHDAY_CANNOT_STATUS_2); } } else { // Cannot load data! define('__MSG', BIRTHDAY_CANNOT_LOAD_DATA); } // Free memory SQL_FREERESULT($result); // Set this because we have no module in URI $GLOBALS['module'] = "birthday_confirm"; // Include header include(PATH."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 include(PATH."inc/footer.php"); } else { // You have to configure first! LOAD_URL("install.php"); } // Really all done here... ;-) ?>