register php?

Admin Posts : 4 Join date : 2008-09-09 Age : 30

ok u o me steven..
do not just c+p you have to edit this is ment for rs server and i didnt know all the info u need to wow so here you go.
html code

Code:: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Register</title>
</head>

<body>
<div align="center">
<form id="form1" name="form1" method="post" action="register.php">
<p>Username:
<input type="text" name="username" />
</p>
<p>Password:
<input type="password" name="password" />
</p>
<p>Confirm Password:
<input type="password" name="cpassword" />
</p>
<p>
<input type="submit" name="Submit" value="Submit" />
</p>
</form>
</div>
</body>
</html>

php? code

Code:: <?php

//SQL variables
$sqlHost = 'localhost';
$sqlName = 'root';
$sqlPass = 'password';
$sqlData = '459server';

$sql = mysql_connect($sqlHost, $sqlName, $sqlPass);
mysql_select_db($sqlData, $sql);

//Player post variables
$username = $_POST['username'];
$password = $_POST['password'];
$cpassword = $_POST['cpassword'];
$rights = 0; //Player rights
$members = 0; //Player is member? (0 = No, 1 = Yes)
$absx = 0; //Starting position X
$absy = 0; //Starting position Y

//Check variables
$u = mysql_query("SELECT * FROM characters WHERE username = '{$username}'", $sql);
$i = mysql_insert_id($sql);

function valid_user($name) {
$regex= "/^[a-zA-Z0-9][\w]+[a-zA-Z0-9]$/i";
if (!preg_match($regex, $name)) {
return false;
}
return true;
}
function valid_pass($pass) {
$regex= "/^[a-zA-Z0-9][\w]+[a-zA-Z0-9]$/i";
if (!preg_match($regex, $pass)) {
return false;
}
return true;
}

if(valid_user($username))
{
if($password == $cpassword)
{
if(valid_pass($password))
{
if(!mysql_num_rows($u))
{
//Successful
mysql_query("INSERT INTO characters(id, username, password, height, posx, posy, rights, ismember, messages, lastconnection, lastlogin, energy, look0, look1, look2, look3, look4, look5, skillxp0, skillxp1, skillxp2, skillxp3, skillxp4, skillxp5, skillxp6, skillxp7, skillxp8, skillxp9, skillxp10, skillxp11, skillxp12, skillxp13, skillxp14, skillxp15, skillxp16, skillxp17, skillxp18, skillxp19, skillxp20, skillxp21, skillxp22, skillxp23, skillxp24, level0, level1, level2, level3, level4, level5, level6, level7, level8, level9, level10, level11, level12, level13, level14, level15, level16, level17, level18, level19, level20, level21, level22, level23, level24, skillxpTotal, levelTotal)
VALUES($i, '{$username}', '{$password}', 0, $absx, $absy, $rights, $members, 0, 'Not connected', '0', 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1154, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 10, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1154, 30)", $sql);
mysql_query("INSERT INTO moreinfo(username, ancients, questpoints, head, torso, arms, hands, legs, feet, beard, mime1, mime2, mime3, mime4, specialattack)
VALUES('{$username}', 0, 0, 0, 18, 26, 33, 36, 42, 10, 0, 0, 0, 0, 100)", $sql);
mysql_query("INSERT INTO equipment(username, equip0, equip1, equip2, equip3, equip4, equip5, equip6, equip7, equip8, equip9, equip10, equip11, equip12, equip13, equipN0, equipN1, equipN2, equipN3, equipN4, equipN5, equipN6, equipN7, equipN8, equipN9, equipN10, equipN11, equipN12, equipN13)
VALUES('{$username}', -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)", $sql);
} else {
print "Username exists!";
}
} else {
print "Invalid password!";
}
} else {
print "Please confirm the password!";
}
} else {
print "Invalid username!";
}

mysql_close($sql);
?>