<?php
// Select your MySQL host, username and password
$con = mysql_connect('localhost','DB_USERNAME','DB_PASSWORD');
if (!$con)
{
     echo "Failed to make connection.";
     exit;
}
// Select the database. Enter the name of your database 
$db = mysql_select_db('MY_JOOMLA_DATABASE');
if (!$db)
{
     echo "Failed to select db.";
     exit;
}
 
$username   = $_POST['username'];
$password   = $_POST['password'];
$names       = $_POST['names'];
$email       = $_POST['email'];
$usertype   = $_POST['usertype'];
 
$sql          = "SELECT username FROM jos_users WHERE username = '" . $username . "'";
$query       = mysql_query($sql);
if (mysql_num_rows($query) > 0)
{
     echo "That username already exists";
}
else
{
     $insert = "INSERT INTO jos_users (id,name,username,email,password,usertype,block,sendEmail,gid,registerDate,lastvisitDate,activation,params) VALUES ('','" . $names . "','" . $username . "','" . $email . "','" . $password . "','" . $usertype . "','0','0','31','','','','')";
     $query  = mysql_query($insert);
     
     $sql2 = "SELECT id FROM jos_users ORDER BY id DESC LIMIT 1";
     $query2 = mysql_query($sql2);
     $rownew = mysql_fetch_array($query2);
     $id = $rownew['id'];
     $newid = $id++;
     
     $insert2 = "INSERT INTO jos_core_acl_aro (id,section_value,value,order_value,name,hidden) VALUES ('','users','" . $newid . "','0','" . $names . "','0')";
     $query3 = mysql_query($insert2);
     $sql3 = "SELECT id FROM jos_core_acl_aro WHERE value = '" . $newid . "'";
     $query4 = mysql_query($sql3);
     $row2 = mysql_fetch_array($query4);
     $id2 = $row2['id'];
     $insert3 = "INSERT INTO jos_core_acl_groups_aro_map (group_id,section_value,aro_id) VALUES ('31','','" . $id2 . "')";
     $query5 = mysql_query($insert3);
     if ($query || $query2 || $query3)
     {
          echo "Thanks for registering. You may now login. $id. $newid";
     }
     else
     {
          echo "Creating account failed";
     }
}
?>