activate.php

<?php

define('INSIDE', true);

$_EnginePath = './';
include($_EnginePath.'common.php');

includeLang('activate');

$Activated = false;

$_GET['code'] = (isset($_GET['code']) ? trim($_GET['code']) : null);
if(!empty($_GET['code']))
{
    if(preg_match('/^[0-9a-zA-Z]{32}$/D', $_GET['code']))
    {
        $SQLResult = doquery("SELECT `id`, `username` FROM {{table}} WHERE `activation_code` = '{$_GET['code']}' LIMIT 1;", 'users');
        if($SQLResult->num_rows > 0)
        {
            $SQLRowData = $SQLResult->fetch_assoc();

            $Username = $SQLRowData['username'];

            doquery("UPDATE {{table}} SET `activation_code` = '' WHERE `id` = '{$SQLRowData['id']}';", 'users');

            $Msg = sprintf($_Lang['activation_completed'], $Username, 'overview.php', 3);
            $Activated = true;
        }
        else
        {
            $Msg = $_Lang['no_code_in_db'];
        }
    }
    else
    {
        $Msg = $_Lang['invalid_code_format'];
    }
}
else
{
    $Msg = $_Lang['empty_code'];
}

if($Activated)
{
    $Color = 'lime';
}
else
{
    $Color = 'red';
}

message("<span style=\"color: {$Color}\">{$Msg}</span><br/><br/>{$_Lang['go_back']}", $_Lang['title']);

?>