Sandbox

Code: Select all

global $database;

# Set the register date

	$registerdate = date("Y-m-d H:i:s");

# Figure out what the last table id and determine the next one as $new_id

	$query = "SELECT MAX(id) FROM jos_users";

	

	$database->setQuery( $query );

	

	$old_id = $database->loadResult();

	

	$new_id = $old_id + 1;

# Figure out what the last table id and determine the next one as $new_aro_id



	$query_aro = "SELECT MAX(aro_id) FROM jos_core_acl_aro";



	$database->setQuery( $query_aro );

	

	$old_aro_id = $database->loadResult();

	

	$new_aro_id = $old_aro_id + 1;

# MD5 the Password as $encpassword



	$encpassword = md5($_POST['jos_users___password']);
	
	$query = "SELECT COUNT(username) from jos_users WHERE `username` = " .$_POST['jos_users___username']. "";

	

	$database->setQuery( $query );


	if ($database->getErrorNum()) {

		print("<font color=red>SQL error in jos_users in dupcheck" .$database->stderr(true). "</font><br />");

		return;

	}

		$dupCount = $database->loadResult();

		#echo "<br>For $username the count is $dupCount <br>";

	

	if ($dupCount > 0) {

	

		echo "Username Already Exists: " .$_POST['jos_users___username']. "<br>";

	

	} else {
		
		$query = "INSERT INTO jos_users VALUES (id, name, username, email, password , usertype, block, sendEmail, gid, registerDate, lastvisitDate) ('" .$new_id. "', '" .$_POST['jos_users___name']. "', '" .$_POST['jos_users___username']. "', '" .$_POST['jos_users___email']. "', '" .$encpassword. "', 'registered', '0', '0', '18', '" .$registerdate. "', '0000-00-00 00:00:00')";

		
		$database->setQuery( $query );

		

		$database->query();

		
		
		$query = "INSERT INTO jos_core_acl_aro (aro_id , section_value , value , order_value , name , hidden) VALUES ('" .$new_aro_id. "', 'users', '" .$new_id. "', '0', '" .$_POST['jos_users___name']. "', '0')";

		echo "INSERT INTO jos_core_acl_aro VALUES ('" .$new_aro_id. "', 'users', '" .$new_id. "', '0', '" .$_POST['jos_users___name']. "', '0')";

		$database->setQuery( $query );

		

		$database->query();


		$query = "INSERT INTO jos_core_acl_groups_aro_map VALUES (25, '', 10)";

		$database->setQuery( $query );

		

		$database->query();
	
	}