<?php
    define('IN_PHPBB', true);
    $phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
    $phpEx = substr(strrchr(__FILE__, '.'), 1);
    include($phpbb_root_path . 'common.' . $phpEx);

    $regid = request_var('regid', '');
    $mcname = request_var('mcname', '');
    // Check passed in data
    if ($regid == '' || $mcname == '') die('DENY');
    // Check if valid regcode
    $sql = 'SELECT user_id, username FROM ' . USERS_TABLE . " WHERE zeenix_regid = '" . $db->sql_escape($regid) . "' AND zeenix_mcname = '' LIMIT 1";
    $result = $db->sql_query($sql);
    $member = $db->sql_fetchrow($result);
    $db->sql_freeresult($result);
    if (!$member) die('DENY');
    // Update mcname
    $user_id = $member['user_id'];
    $sql = 'UPDATE ' . USERS_TABLE . " SET zeenix_mcname = '" . $db->sql_escape($mcname) . "' WHERE user_id = " . $user_id . ' LIMIT 1';
    $db->sql_query($sql);
    echo $member['username'];
?>