rpicms

commit 766512120e5c860107e4ed5c0cec1c540b5fc813
parent e0bee0a6a6d639ef62d0593eba086cdb865bc856
Author: MTRNord <MTRNord1@gmail.com>
Date:   Thu,  9 Oct 2014 06:24:28 +0200

Create register_activation.php
Diffstat:
A
core/admin/user/register_activation.php
 | 
38
++++++++++++++++++++++++++++++++++++++

1 file changed, 38 insertions(+), 0 deletions(-)
diff --git a/core/admin/user/register_activation.php b/core/admin/user/register_activation.php
@@ -0,0 +1,38 @@
+<?php
+/**
+* Activate Users
+* 
+* This script activate the Users in the Database 
+*
+* @author		Marcel Radzio <info@nordgedanken.de>
+* @version	0.2 17/08/2014 19:52
+*/
+
+	//Set global variables
+	$DatabaseHost = "localhost";
+	$DatabaseUser = "root";
+	$DatabasePassword = "1199Mtr3#";
+	$Database = "blog";
+	$TableAktivierung = "users";
+	
+	//Check for the ID of the user and the Activationcode
+	if($_REQUEST['ID'] && $_REQUEST['Aktivierungscode']){
+		//Open Database connection
+		$DatabasePointer = mysqli_connect($DatabaseHost, $DatabaseUser, $DatabasePassword);
+		mysql_select_db($Database, $DatabasePointer);
+
+		$_REQUEST['ID']               = mysql_real_escape_string($_REQUEST['ID']);
+		$_REQUEST['Aktivierungscode'] = mysql_real_escape_string($_REQUEST['Aktivierungscode']);
+
+		//Get variables from Database
+		$ResultPointer = mysql_query("SELECT ID FROM $TableAktivierung WHERE ID = '".$_REQUEST['ID']."' AND Aktivierungscode = '".$_REQUEST['Aktivierungscode']."'", $DatabasePointer);
+
+		//Check if $ResultPointer filled
+		if(mysql_num_rows($ResultPointer) > 0){
+			//Activate the User
+        		@mysql_query("UPDATE $TableAktivierung SET Aktiviert = '1' WHERE ID = '".$_REQUEST['ID']."'", $DatabasePointer);
+       			echo"Vielen Dank f&uuml;r Ihre Registrierung. Der Aktivierungsprozess ist nun abgeschlossen.";
+    		}
+	}
+?>
+