Nostradamus
Member
- Joined
- Jun 2, 2007
- Messages
- 219
- Reaction score
- 6
My friend requested some functions so i decided to make and post to everyone.
Please note that i have been idle in PHP for one year or more.
Here it is:
Please note that i have been idle in PHP for one year or more.
Here it is:
PHP:
<?php
class MySQL
{
var $host;
var $user;
var $pass;
var $db;
function connect()
{
$cn = mysql_connect($this->sql['host'], $this->sql['user'], $this->sql['pass']);
mysql_select_db($this->sql['db']);
}
function disconnect()
{
mysql_close($this->$cn);
}
function __construct(&$sql)
{
$this->sql = $sql;
}
}
class AAC
{
function doGenerateAccount()
{
do
{
$rand = rand(100000, 9999999);
$query = mysql_query("SELECT `id` FROM accounts WHERE id = '$rand'");
}
while(mysql_num_rows($query) > 0));
return $rand;
}
function doCheckAccount($account)
{
$query = mysql_query("SELECT `id` FROM `accounts` WHERE id = '$account'");
if (mysql_num_rows($query) > 0)
return true;
else
return false;
}
function doCheckLogin($account, $password)
{
$query = mysql_query("SELECT * FROM `accounts` WHERE `id` = '$account' AND `password` = '$password'");
if (mysql_num_rows($query) > 0)
return true;
else
return false;
}
function doChangePassword($account, $oldpass, $newpass)
{
$check = mysql_query("SELECT `password` FROM `accounts` WHERE `password` = '$oldpass'");
if (mysql_num_rows($check) > 0)
{
$make = mysql_query("UPDATE `accounts` SET `password` = `$newpass` WHERE `id` = `$account`");
return true;
}
else
return false;
}
function doCreateAccount($email, $account, $password)
{
if ($this->doCheckAccount($account) == false)
{
if (eregi('^[0-9]+$', $account) || eregi('^[-_a-z0-9 ]+$', $password) || eregi('^[-_a-z0-9]+(\\.[-_a-z0-9]+)*\\@([-a-z0-9]+\\.)*([a-z]{2,4})$', $email))
{
if (strlen($account) >= 6 || strlen($account) <= 7 || strlen($password) >= 3 || strlen($password) <= 20)
{
$make = mysql_query("INSERT INTO `accounts` VALUES ($account, $password, 0, 0, '', $email, '', 0");
return true;
}
}
}
else
return false;
}
}
?>
Last edited: