Here's a reg page for cabal based on ODBC, enjoy
Requirements:
Requirements:
-
You must be registered to see links
-
You must be registered to see links
-
You must be registered to see links
Code:
<?php
define('MSSQL_HOST', 'IP');
define('MSSQL_USER', 'USER');
define('MSSQL_PASS', 'PASS');
$mssql = odbc_connect('Driver={SQL Server};Server='.MSSQL_HOST.';', MSSQL_USER, MSSQL_PASS);
require_once('ayah.php');
$ayah = new AYAH();
function mssql_escape_string($str){
$str = htmlentities($str);
if (ctype_alnum($str))
return $str;
else
return str_ireplace(array(';', '%', "'"), "", $str);
}
foreach ($_GET as $key=>$getvar){ $_GET[$key] = mssql_escape_string($getvar); }
foreach ($_POST as $key=>$postvar){ $_POST[$key] = mssql_escape_string($postvar); }
if (!isset($_POST['reg_username']))
$_POST['reg_username'] = '';
odbc_exec($mssql, 'USE [ACCOUNT]');
$checkacc = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [cabal_auth_table] WHERE ID=\'' . mssql_escape_string($_POST['reg_username']) . '\'');
$errors = array();
if (empty($_POST['reg_username']) || empty($_POST['reg_password']))
$errors[] = 'You must fill out all fields.';
if (!empty($_POST['reg_username']) && odbc_result($checkacc, 'count') > 0)
$errors[] = '' . $_POST['reg_username'] . ' is already in use.';
if (!empty($_POST['reg_username']) && (strlen($_POST['reg_username']) > 16 || strlen($_POST['reg_username']) < 6))
$errors[] = 'Usernames must be between 6 - 16 characters.';
if (!empty($_POST['reg_password']) && (strlen($_POST['reg_password']) > 16 || strlen($_POST['reg_password']) < 6))
$errors[] = 'Passwords must be between 6 - 16 characters.';
if (array_key_exists('reg_submit', $_POST)) {
$score = $ayah->scoreResult();
if ($score) {
if (count($errors) > 0) {
echo '<div class="fail">';
foreach ($errors as $error) {
echo $error . '<br/>';
}
echo '</div>';
} else {
odbc_exec($mssql, 'EXEC [dbo].[cabal_tool_registerAccount]"'.mssql_escape_string($_POST['reg_username']).'","'.mssql_escape_string($_POST['reg_password']).'"');
echo '<div class="success">Your account has been successfully created.</div>';
}
} else {
echo '<div class="fail">Invalid Captcha.</div>';
}
}
?>
<!DOCTYPE html>
<head>
<title>Cabal EP8 Registration</title>
<meta charset="utf-8" />
</head>
<body>
<form method="post" action="register.php">
<table>
<tr>
<td>Username:</td>
<td><input type="text" name="reg_username" autocomplete="off" maxlength="16"></td>
</tr>
<tr>
<td>Password:</td>
<td><input type="password" name="reg_password" autocomplete="off" maxlength="16"></td>
</tr>
<tr>
<td><?php echo $ayah->getPublisherHTML(); ?></td>
<td><input type="submit" name="reg_submit" value="Create Account"></td>
</tr>
</table>
</form>
</body>
</html>