register.php

<?php
mysql_connect('localhost:3306', 'mysql_user', 'mysql_pass');
mysql_select_db('realmd');

$username = strtoupper(mysql_real_escape_string($_GET['username']));
$email    = mysql_real_escape_string($_GET['email']);
$pass     = strtoupper(mysql_real_escape_string($_GET['password']));
$sha_pass = SHA1($username.':'.$pass);
$ip       = $_SERVER['REMOTE_ADDR'];

mysql_query(
    'INSERT INTO account (username,sha_pass_hash,email,last_ip,expansion)
     VALUES ("'.$username.'", "'.$sha_pass.'", "'.$email.'", "'.$ip.'", 2)'
);
?>