Column code on row 1 on your file?
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title>{hotelName} - Register</title>
<script type="text/javascript" src="{url}/app/tpl/skins/habboextreme/js/visual.js"></script>
<script type="text/javascript" src="{url}/app/tpl/skins/habboextreme/js/common.js"></script>
<link rel="stylesheet" href="{url}/app/tpl/skins/habboextreme/styles/style.css" type="text/css">
<link rel="stylesheet" href="{url}/app/tpl/skins/habboextreme/styles/embedregistration.css" type="text/css">
<script type="text/javascript">
document.habboLoggedIn = true;
var habboName = null;
var habboId = null;
var habboReqPath = "";
var habboStaticFilePath = "{url}/app/tpl/skins/Habboextreme";
var habboImagerUrl = "http://www.habbo.com/habbo-imaging/";
var habboPartner = "";
var habboDefaultClientPopupUrl = "{url}/client";
window.name = "habboMain";
if (typeof HabboClient != "undefined") {
HabboClient.windowName = "client";
HabboClient.maximizeWindow = true;
}
</script>
<style type="text/css">
input[type="submit"], input[type="button"] {
background: url('{url}/app/tpl/skins/habboextreme/images/reg_btn.png') top;
font: bold 13px arial,sans-serif;
line-height: 25px;
color: black;
height: 25px;
width: 99px;
border: 0;
}
input[type="submit"]:hover, input[type="button"]:hover {
background-position: bottom;
cursor: pointer;
}
h1 a{height:51px!important;width:200px!important;background-image:url('{url}/app/tpl/skins/{skin}/images/logo.gif')!important;}
</style>
<!--[if IE 8]>
<link rel="stylesheet" href="{url}/app/tpl/skins/habboextreme/styles/ie8.css" type="text/css">
<![endif]-->
<!--[if lt IE 8]>
<link rel="stylesheet" href="{url}/app/tpl/skins/habboextreme/styles/ie.css" type="text/css" />
<![endif]-->
<!--[if lt IE 7]>
<link rel="stylesheet" href="{url}/app/tpl/skins/habboextreme/styles/ie6.css" type="text/css" />
<script type="text/javascript" src="{url}/app/tpl/skins/habboextreme/js/pngfix.js"></script>
<script type="text/javascript">
try { document.execCommand('BackgroundImageCache', false, true); } catch(e) {}
</script>
<style type="text/css">
body { behavior: url({url}/app/tpl/skins/habboextreme/js/csshover.htc); }
</style>
<![endif]-->
</head>
<body>
<center>
<div id="overlay"></div>
<div id="container" class="phase-0" style="margin-top: 10px;">
<div class="register-container clearfix">
<div class="register-header">Register at {hotelName} Hotel</div>
<div id="register-content">
<div id="subheader">Fill out the form below to register here!</div>
<div class="register-container-bottom-end register-content clearfix">
<div id="auth-providers" class="auth-providers">
<ul>
<p> At {HotelName} we try to be the best hotel out there.
</ul>
</div>
<div id="register-page" style="clear: left" class="phase-0 clearfix">
<center><img src='{url}/app/tpl/skins/{skin}/images/logo.gif'/></center>
<div class="phase-0">
<form method="post" id="phase-0-form">
<div id="error-messages-container"><?php if(isset($template->form->error)) { echo '<div class="error-messages-holder"><ul><li><p class="error-message">'.$template->form->error.'</p></li></ul></div>'; } ?></div>
<div id="name-field-container">
<div class="field field-habbo-name">
<label for="habbo-name"><b>Username</b></label>
<input type="text" id="habbo-name" size="35" value="<?php echo $template->form->reg_username; ?>" name="reg_username" class="text-field" maxlength="32">
</div>
</div>
<div class="field field-password">
<label for="password"><b>Password</b></label>
<input type="password" id="password" size="35" name="reg_password" value="" class="password-field" maxlength="32">
</div>
<div class="field field-password2">
<label for="password2"><b>Confirm Password</b></label>
<input type="password" id="password2" size="35" name="reg_rep_password" value="" class="password-field" maxlength="32">
</div>
<div class="field field-email">
<label for="email"><b>Email Address</b></label>
<input type="text" id="email" size="35" name="reg_email" value="<?php echo $template->form->reg_email; ?>" class="text-field" maxlength="48">
</div>
<div class="field field-seckey">
<label for="seckey"><b>Security Key</b></label>
<input type="password" id="seckey" size="35" name="reg_seckey" value="" class="text-field" maxlength="4">
</div>
<input type="submit" value="Register" name="register">
<input type="button" value="Cancel" onclick="location.href='{url}/'" style="float:right;margin-right:12px;">
</form>
</div>
</div>
</div>
</div>
<div class="register-container-bottom"></div>
<!--[if lt IE 7]>
<script type="text/javascript">
Pngfix.doPngImageFix();
</script>
<![endif]-->
</div>
</div>
<script type="text/javascript">
HabboView.run();
</script>
</body>
</html>
Straight from Register.phpCan you upload your register.PHP rather than the TPL for register?
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title>{hotelName} - Register</title>
<script type="text/javascript" src="{url}/app/tpl/skins/habboextreme/js/visual.js"></script>
<script type="text/javascript" src="{url}/app/tpl/skins/habboextreme/js/common.js"></script>
<link rel="stylesheet" href="{url}/app/tpl/skins/habboextreme/styles/style.css" type="text/css">
<link rel="stylesheet" href="{url}/app/tpl/skins/habboextreme/styles/embedregistration.css" type="text/css">
<script type="text/javascript">
document.habboLoggedIn = true;
var habboName = null;
var habboId = null;
var habboReqPath = "";
var habboStaticFilePath = "{url}/app/tpl/skins/Habboextreme";
var habboImagerUrl = "http://www.habbo.com/habbo-imaging/";
var habboPartner = "";
var habboDefaultClientPopupUrl = "{url}/client";
window.name = "habboMain";
if (typeof HabboClient != "undefined") {
HabboClient.windowName = "client";
HabboClient.maximizeWindow = true;
}
</script>
<style type="text/css">
input[type="submit"], input[type="button"] {
background: url('{url}/app/tpl/skins/habboextreme/images/reg_btn.png') top;
font: bold 13px arial,sans-serif;
line-height: 25px;
color: black;
height: 25px;
width: 99px;
border: 0;
}
input[type="submit"]:hover, input[type="button"]:hover {
background-position: bottom;
cursor: pointer;
}
h1 a{height:51px!important;width:200px!important;background-image:url('{url}/app/tpl/skins/{skin}/images/logo.gif')!important;}
</style>
<!--[if IE 8]>
<link rel="stylesheet" href="{url}/app/tpl/skins/habboextreme/styles/ie8.css" type="text/css">
<![endif]-->
<!--[if lt IE 8]>
<link rel="stylesheet" href="{url}/app/tpl/skins/habboextreme/styles/ie.css" type="text/css" />
<![endif]-->
<!--[if lt IE 7]>
<link rel="stylesheet" href="{url}/app/tpl/skins/habboextreme/styles/ie6.css" type="text/css" />
<script type="text/javascript" src="{url}/app/tpl/skins/habboextreme/js/pngfix.js"></script>
<script type="text/javascript">
try { document.execCommand('BackgroundImageCache', false, true); } catch(e) {}
</script>
<style type="text/css">
body { behavior: url({url}/app/tpl/skins/habboextreme/js/csshover.htc); }
</style>
<![endif]-->
</head>
<body>
<center>
<div id="overlay"></div>
<div id="container" class="phase-0" style="margin-top: 10px;">
<div class="register-container clearfix">
<div class="register-header">Register at {hotelName} Hotel</div>
<div id="register-content">
<div id="subheader">Fill out the form below to register here!</div>
<div class="register-container-bottom-end register-content clearfix">
<div id="auth-providers" class="auth-providers">
<ul>
<p> At {HotelName} we try to be the best hotel out there.
</ul>
</div>
<div id="register-page" style="clear: left" class="phase-0 clearfix">
<center><img src='{url}/app/tpl/skins/{skin}/images/logo.gif'/></center>
<div class="phase-0">
<form method="post" id="phase-0-form">
<div id="error-messages-container"><?php if(isset($template->form->error)) { echo '<div class="error-messages-holder"><ul><li><p class="error-message">'.$template->form->error.'</p></li></ul></div>'; } ?></div>
<div id="name-field-container">
<div class="field field-habbo-name">
<label for="habbo-name"><b>Username</b></label>
<input type="text" id="habbo-name" size="35" value="<?php echo $template->form->reg_username; ?>" name="reg_username" class="text-field" maxlength="32">
</div>
</div>
<div class="field field-password">
<label for="password"><b>Password</b></label>
<input type="password" id="password" size="35" name="reg_password" value="" class="password-field" maxlength="32">
</div>
<div class="field field-password2">
<label for="password2"><b>Confirm Password</b></label>
<input type="password" id="password2" size="35" name="reg_rep_password" value="" class="password-field" maxlength="32">
</div>
<div class="field field-email">
<label for="email"><b>Email Address</b></label>
<input type="text" id="email" size="35" name="reg_email" value="<?php echo $template->form->reg_email; ?>" class="text-field" maxlength="48">
</div>
<div class="field field-seckey">
<label for="seckey"><b>Security Key</b></label>
<input type="password" id="seckey" size="35" name="reg_seckey" value="" class="text-field" maxlength="4">
</div>
<input type="submit" value="Register" name="register">
<input type="button" value="Cancel" onclick="location.href='{url}/'" style="float:right;margin-right:12px;">
</form>
</div>
</div>
</div>
</div>
<div class="register-container-bottom"></div>
<!--[if lt IE 7]>
<script type="text/javascript">
Pngfix.doPngImageFix();
</script>
<![endif]-->
</div>
</div>
<script type="text/javascript">
HabboView.run();
</script>
</body>
</html>
ALTER TABLE `users`MODIFY COLUMN `rank` varchar(11) NOT NULL DEFAULT '1';