<?php

  require_once('./config.php');
  require_once('./common.php');


  $atable = HDW_FRL_LocateTable($_GET["tb"]);
  define(HDW_TABLENAME, $atable["name"]);   
  $_GET["id"] = base64_decode($_GET["id"]);
  $registered = false;
       
  HDW_FRL_openDatabaseConnection();
  if (HDW_MYSQL)
  {
       mysql_select_db(HDW_DATABASE) or die("Could not select database");                                                          
       $result = mysql_query("SELECT * FROM ".HDW_TABLENAME." WHERE `".$atable["username"]."`='".HDW_FRL_rquote($_GET["id"])."'") or die("Query failed");               
       $registered = mysql_fetch_array($result);
       if ($registered)  
           mysql_query("UPDATE ".HDW_TABLENAME." SET hdw_active=1 WHERE `".$atable["username"]."`='".HDW_FRL_rquote($_GET["id"])."'") or die("Query failed");                  
          
       mysql_free_result($result);                   
  }
  else
  {
      $result = $db->executeQuery("SELECT * FROM ".HDW_TABLENAME." WHERE ".$atable["username"]."='".HDW_FRL_rquote($_GET["username"])."'");
      $rows = array();
      $registered = $result->next();    
      if ($registered)   
           $db->executeQuery("UPDATE ".HDW_TABLENAME." SET hdw_active=1 WHERE ".$atable["username"]."='".HDW_FRL_rquote($_GET["id"])."'");               
                
  }
  HDW_FRL_closeDatabaseConnection();
  
  if ($registered)
  {
      $mail = new PHPMailer();

      $mail->FromName = $atable["from"];
      $mail->From     = $atable["from"];
      $mail->AddAddress( $registered[$atable["emailfield"]] );
      $mail->WordWrap = 80;                              // set word wrap

      $mail->IsHTML(false);                               // send as HTML

      $t_mail = HDW_FRL_processMail("WelcomeMail.txt",array( 
                                                   "URL"=>$_SERVER["HTTP_HOST"],
                                                   "USERNAME"=>$registered[$atable["username"]],
                                                   "PASSWORD"=>$registered[$atable["password"]]
                                                  ));
      $mail->Subject  =  $t_mail["subject"];
      $mail->Body     =  $t_mail["body"];

      $result = $mail->Send();
      
      if (!$result)
      { 
          $mail->Mailer = "smtp";
          $result = $mail->Send();
      }
      if (!$result)
      {
          $mail->Mailer = "sendmail";
          $result = $mail->Send();
      }
      header("Location: ".$atable["activation_url"]);
  }
  else
      echo HDW_MESSAGE_ACTIVATION_FAILED;
  
  exit;
  
?>