help with sql acremu register account

[markbatt]

i am modifiing phpfusion 7.1 for arcemu account game activation

Please have a look at this section of code and tell me if i am on the right track.



connection.php

<?php
DEFINE ('DB_USER', 'root');
DEFINE ('DB_PASSWORD', 'ascent');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'logon_all_realms');

$dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not
connect to MySQL: '.mysql_error());

@mysql_select_db (DB_NAME) OR die ('Could not connect to database: '
.mysql_error());


?>



register.php

//this line make by asicstar and blitztech
include("includes/connection.php");
$password2=md5($password);
mysql_select_db(DB_NAME);
$query="INSERT INTO accounts(login,password,email,gm,flags,banned,lastlogin,lastip) VALUES ('".$username."','".$password2."','".$email."',0,24,0,'0000-00-00 00:00:00','".USER_IP."')";
mysql_query($query);