Help Incorrect integer value: '' for column 'rank' at row 1

Status
Not open for further replies.

Chaotic

Skype: Brenner.jones1
Apr 23, 2012
80
7
Incorrect integer value: '' for column 'rank' at row 1. How do I fix?
 

Chaotic

Skype: Brenner.jones1
Apr 23, 2012
80
7
Column code on row 1 on your file?
PHP:
<!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>


Thats My Register Page
 

Chaotic

Skype: Brenner.jones1
Apr 23, 2012
80
7
Can you upload your register.PHP rather than the TPL for register?
Straight from Register.php
PHP:
<!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>
 
Status
Not open for further replies.

Users who are viewing this thread

Top