web help

Results 1 to 11 of 11
  1. 20-05-13 #1
    suhil1
    Account Upgraded | Title Enabled! suhil1 is offline
    MemberRank
    Apr 2010 Join Date
    310Posts

    web help

    Hello Guys after Register in my web i am getting this error


    Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near '\'. (severity 15) in C:\AppServ\www\modules\mod_register.php on line 185

    Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\modules\mod_register.php on line 185

    Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near ')'. (severity 15) in C:\AppServ\www\modules\mod_register.php on line 189

    Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\modules\mod_register.php on line 189
    Reply With Quote Reply With Quote
  2. Check out our sponsor
    web help
  3. 20-05-13 #2
    Anju
    In Progress... FFXIV... Anju is offline
    MemberRank
    Oct 2010 Join Date
    Mist Ward 7 #38Location
    1,946Posts

    Re: web help

    Can't really help if you don't provide us the mod_register.php files codes on those lines.
    Reply With Quote Reply With Quote
  4. 20-05-13 #3
    suhil1
    Account Upgraded | Title Enabled! suhil1 is offline
    MemberRank
    Apr 2010 Join Date
    310Posts

    Re: web help

    <?php
    session_start();
    ?>
    <script language="javascript">
    $(document).ready(function()
    {
    $("#username").blur(function()
    {
    //remove all the class add the messagebox classes and start fading
    $("#msgbox").removeClass().addClass('messagebox').text('Checking...').fadeIn("slow");
    //check the username exists or not from ajax
    $.post("user_availability.php",{ user_name:$(this).val() } ,function(data)
    {
    if(data=='no') //if username not avaiable
    {
    $("#msgbox").fadeTo(200,0.1,function() //start fading the messagebox
    {
    //add message and change the class of the box and start fading
    $(this).html('Username is Invalid or in Use.').addClass('messageboxerror').fadeTo(900,1);
    });
    }
    else
    {
    $("#msgbox").fadeTo(200,0.1,function() //start fading the messagebox
    {
    //add message and change the class of the box and start fading
    $(this).html('Username Available').addClass('messageboxok').fadeTo(900,1);
    });
    }

    });

    });
    //Validate E-Mail
    $("#email").blur(function()
    {
    //remove all the class add the messagebox classes and start fading
    $("#msgbox2").removeClass().addClass('messagebox').text('Checking...').fadeIn("slow");
    //check the email exists or not from ajax
    $.post("email_availability.php",{ email:$(this).val() } ,function(data)
    {
    if(data=='no') //if email not avaiable
    {
    $("#msgbox2").fadeTo(200,0.1,function() //start fading the messagebox
    {
    //add message and change the class of the box and start fading
    $(this).html('E-mail ID is Invalid or in Use.').addClass('messageboxerror').fadeTo(900,1);
    });
    }
    else
    {
    $("#msgbox2").fadeTo(200,0.1,function() //start fading the messagebox
    {
    //add message and change the class of the box and start fading
    $(this).html('E-mail entered is valid.').addClass('messageboxok').fadeTo(900,1);
    });
    }

    });

    });
    });
    </script>
    <style type="text/css">
    body {
    font-family:Verdana, Arial, Helvetica, sans-serif;
    font-size:11px;
    }
    .top {
    margin-bottom: 15px;
    }
    .messagebox{
    position:absolute;
    width:100px;
    border:1px solid #4C787E;
    background:#4C4646;
    padding:3px;
    }
    .messageboxok{
    position:absolute;
    width:auto;
    border:1px solid #349534;
    background:#C9FFCA;
    padding:3px;
    font-weight:bold;
    color:#008000;

    }
    .messageboxerror{
    position:absolute;
    width:auto;
    border:1px solid #CC0000;
    background:#F7CBCA;
    padding:3px;
    font-weight:bold;
    color:#CC0000;
    }

    </style>
    <?
    if(!$_SESSION['AID'] == ""){
    msgbox("You already have an account.","index.php");
    }

    $errorcode = "";
    $er = 0;
    $registered = 0;
    if (isset($_POST['submit'])){
    $user = antisql($_POST['userid']);
    $email = antisql($_POST['email']);
    $pw1 = antisql($_POST['pw1']);
    $pw2 = antisql($_POST['pw2']);
    $country = antisql($_POST['country']);
    $sq = antisql($_POST['sq']);
    $sa = antisql($_POST['sa']);
    $captcha_code = antisql($_POST['captcha_code']);
    $name = antisql($_POST['name']);
    $zip = antisql($_POST['zip']);
    $age = antisql($_POST['age']);
    $sex = antisql($_POST['sex']);
    $address = antisql($_POST['address']);
    $validate = validateEmail($email);
    $validateun = validate_username($user);
    if($user == "" || $validateun<0){
    msgbox ("Enter a Valid Username.","index.php?do=register","index.php?do=register");
    $er = 1;
    }

    if($email == "" || $validate<0){
    msgbox ("Enter a Valid E-Mail ID.","index.php?do=register","index.php?do=register");
    $er = 1;
    }

    if($pw1 == "" Or $pw2 == ""){
    msgbox ("Please fill both password fields.","index.php?do=register");
    $er = 1;
    }

    if(strlen($pw1) < 6){
    msgbox ("Choose a password with al least 6 characters.","index.php?do=register");
    $er =1;
    }

    if($sq == ""){
    msgbox ("Enter a secret question.","index.php?do=register");
    $er =1;
    }

    if($sa == ""){
    msgbox ("Enter a secret answer.","index.php?do=register");
    $er = 1;
    }

    $res = mssql_query("SELECT * FROM Account WHERE email = '".$email."'");
    if (mssql_num_rows($res) >= 1){
    msgbox ("Email in use.","index.php?do=register");
    $er = 1;
    }

    $res = mssql_query("SELECT * FROM Login WHERE UserID = '".$user."'");
    if (mssql_num_rows($res) >= 1){
    msgbox ("UserID in use.","index.php?do=register");
    $er = 1;
    }

    if($pw1 == $pw2){
    $lol = "xDDD";
    }else{
    msgbox ("Passwords Missmatch","index.php?do=register");
    $er = 1;
    }


    $securimage = new Securimage();

    if ($securimage->check($_POST['captcha_code']) == false) {
    // the code was incorrect
    // handle the error accordingly with your other error checking

    // or you can do something really basic like this
    die('The code you entered was incorrect. Go back and try again.');
    }
    if($er == 0){
    $registered = 1;
    mssql_query("INSERT INTO Account (UserID, Cert, Name, Email, Age, Sex, UGradeID, PGradeID, RegDate, Country, sa, sq , captcha_code)Values ('$user', NULL, '$name','$email','$age', '$sex', 0, 0, GETDATE(),'$country', '$sa', '$sq', '$captcha_code')");
    $res = mssql_query("SELECT * FROM Account WHERE UserID = '$user'");
    $usr = mssql_fetch_assoc($res);
    $aid = $usr['AID'];
    mssql_query("INSERT INTO Login ([UserID],[AID],[Password],[euCoins])VALUES('$user','$aid','$pw1',)");
    }else{
    $errorbox = ErrorBox($errorcode);
    }
    }



    if ($registered == 0){
    ?>

    <form name="reg" method="POST" action="index.php?do=register"><body bgcolor="#323232">

    <div align="center">
    <table border="0" width="456" style="border-collapse: collapse">
    <tr>
    <td background="images/cont_up.jpg">&nbsp;</td>
    </tr>
    <tr>
    <td background="images/cont_bg.jpg">

    <div align="center">
    <table border="0" style="border-collapse: collapse" width="454" height="100%">
    <tr>
    <td width="4" rowspan="36">&nbsp;</td>
    <td width="436" colspan="2">
    <img border="0" src="images/inf/createaccount.jpg" width="413" height="18"></td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>

    <td width="145">&nbsp;
    </td>
    <td width="289">&nbsp;
    </td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">&nbsp;
    </td>

    <td width="289">
    <font size="1" color="#4D4D4D">The fields marked with an * are required</font></td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">&nbsp;
    </td>
    <td width="289">&nbsp;

    </td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145" valign="middle">
    ·<span lang="es">
    User ID<font color="#FF9933">*</font></span></td>

    <td width="289">
    <input type="text" name="userid" id="username" size="20"></td>
    <td width="8">&nbsp;</td>

    </tr>
    <tr>
    <td width="145">&nbsp;</td>
    <td width="289"><span id="msgbox" style="display:none"></span>&nbsp;</td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">&nbsp;</td>
    <td width="289">&nbsp;</td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">
    ·<span lang="es">
    E-Mail<font color="#FF9933">*</font></span></td>
    <td width="289">
    <input type="text" name="email" id="email" size="20"></td>
    <td width="8">&nbsp;</td>

    </tr>
    <tr>
    <td width="145">&nbsp;</td>
    <td width="289"><span id="msgbox2" style="display:none"></span>&nbsp;</td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">&nbsp;</td>
    <td width="289">&nbsp;</td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">
    ·<span lang="es">

    Password<font color="#FF9933">*</font></span></td>
    <td width="289">
    <input type="password" name="pw1" size="20"></td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">&nbsp;</td>
    <td width="289">

    <font color="#4D4D4D">
    <span style="font-size: 7pt">Minimum 6 characters in length</span></font></td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">
    ·<span lang="es">
    Repeat password<font color="#FF9933">*</font></span></td>

    <td width="289">
    <input type="password" name="pw2" size="20"></td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">&nbsp;</td>
    <td width="289">&nbsp;</td>
    <td width="8">&nbsp;</td>
    </tr>

    <tr>
    <td width="145" valign="middle">
    ·<span lang="es">
    Country<font color="#FF9933">*</font></span></td>
    <td width="289">
    <select id="dropDownCountrySelector" name="country" class onChange="refreshCountry(this, false);">
    <option value="IN" selected="selected">

    India</option>
    <option value="AL">Albania</option>
    <option value="DZ">Algeria</option>
    <option value="AD">Andorra</option>
    <option value="AO">Angola</option>
    <option value="AI">Anguilla</option>

    <option value="AG">Antigua and
    Barbuda</option>
    <option value="AR">Argentina
    </option>
    <option value="AM">Armenia</option>
    <option value="AW">Aruba</option>
    <option value="AU">Australia
    </option>
    <option value="AT">Austria</option>

    <option value="AZ">Azerbaijan
    Republic</option>
    <option value="BS">Bahamas</option>
    <option value="BH">Bahrain</option>
    <option value="BB">Barbados</option>
    <option value="BE">Belgium</option>
    <option value="BZ">Belize</option>

    <option value="BJ">Benin</option>
    <option value="BM">Bermuda</option>
    <option value="BT">Bhutan</option>
    <option value="BO">Bolivia</option>
    <option value="BA">Bosnia and
    Herzegovina</option>
    <option value="BW">Botswana</option>

    <option value="BR">Brazil</option>
    <option value="VG">British Virgin
    Islands</option>
    <option value="BN">Brunei</option>
    <option value="BG">Bulgaria</option>
    <option value="BF">Burkina Faso
    </option>
    <option value="BI">Burundi</option>

    <option value="KH">Cambodia</option>
    <option value="CA">Canada</option>
    <option value="CV">Cape Verde
    </option>
    <option value="KY">Cayman Islands
    </option>
    <option value="TD">Chad</option>
    <option value="CL">Chile</option>

    <option value="C2">China Worldwide
    </option>
    <option value="CO">Colombia</option>
    <option value="KM">Comoros</option>
    <option value="CK">Cook Islands
    </option>
    <option value="CR">Costa Rica
    </option>
    <option value="HR">Croatia</option>

    <option value="CY">Cyprus</option>
    <option value="CZ">Czech Republic
    </option>
    <option value="CD">Democratic
    Republic of the Congo</option>
    <option value="DK">Denmark</option>
    <option value="DJ">Djibouti</option>
    <option value="DM">Dominica</option>

    <option value="DO">Dominican
    Republic</option>
    <option value="EC">Ecuador</option>
    <option value="SV">El Salvador
    </option>
    <option value="ER">Eritrea</option>
    <option value="EE">Estonia</option>
    <option value="ET">Ethiopia</option>

    <option value="FK">Falkland Islands
    </option>
    <option value="FO">Faroe Islands
    </option>
    <option value="FM">Federated States
    of Micronesia</option>
    <option value="FJ">Fiji</option>
    <option value="FI">Finland</option>
    <option value="FR">France</option>

    <option value="GF">French Guiana
    </option>
    <option value="PF">French Polynesia
    </option>
    <option value="GA">Gabon Republic
    </option>
    <option value="GM">Gambia</option>
    <option value="DE">Germany</option>
    <option value="GI">Gibraltar
    </option>

    <option value="GR">Greece</option>
    <option value="GL">Greenland
    </option>
    <option value="GD">Grenada</option>
    <option value="GP">Guadeloupe
    </option>
    <option value="GT">Guatemala
    </option>
    <option value="GN">Guinea</option>

    <option value="GW">Guinea Bissau
    </option>
    <option value="GY">Guyana</option>
    <option value="HN">Honduras</option>
    <option value="HK">Hong Kong
    </option>
    <option value="HU">Hungary</option>
    <option value="IS">Iceland</option>

    <option value="IN">India</option>
    <option value="ID">Indonesia
    </option>
    <option value="IE">Ireland</option>
    <option value="IL">Israel</option>
    <option value="IT">Italy</option>
    <option value="JM">Jamaica</option>

    <option value="JP">Japan</option>
    <option value="JO">Jordan</option>
    <option value="KZ">Kazakhstan
    </option>
    <option value="KE">Kenya</option>
    <option value="KI">Kiribati</option>
    <option value="KW">Kuwait</option>

    <option value="KG">Kyrgyzstan
    </option>
    <option value="LA">Laos</option>
    <option value="LV">Latvia</option>
    <option value="LS">Lesotho</option>
    <option value="LI">Liechtenstein
    </option>
    <option value="LT">Lithuania
    </option>

    <option value="LU">Luxembourg
    </option>
    <option value="MG">Madagascar
    </option>
    <option value="MW">Malawi</option>
    <option value="MY">Malaysia</option>
    <option value="MV">Maldives</option>
    <option value="ML">Mali</option>

    <option value="MT">Malta</option>
    <option value="MH">Marshall Islands
    </option>
    <option value="MQ">Martinique
    </option>
    <option value="MR">Mauritania
    </option>
    <option value="MU">Mauritius
    </option>
    <option value="YT">Mayotte</option>

    <option value="MX">Mexico</option>
    <option value="MN">Mongolia</option>
    <option value="MS">Montserrat
    </option>
    <option value="MA">Morocco</option>
    <option value="MZ">Mozambique
    </option>
    <option value="NA">Namibia</option>

    <option value="NR">Nauru</option>
    <option value="NP">Nepal</option>
    <option value="NL">Netherlands
    </option>
    <option value="AN">Netherlands
    Antilles</option>
    <option value="NC">New Caledonia
    </option>
    <option value="NZ">New Zealand
    </option>

    <option value="NI">Nicaragua
    </option>
    <option value="NE">Niger</option>
    <option value="NU">Niue</option>
    <option value="NF">Norfolk Island
    </option>
    <option value="NO">Norway</option>
    <option value="OM">Oman</option>

    <option value="PW">Palau</option>
    <option value="PA">Panama</option>
    <option value="PG">Papua New Guinea
    </option>
    <option value="PE">Peru</option>
    <option value="PH">Philippines
    </option>
    <option value="PN">Pitcairn Islands
    </option>

    <option value="PL">Poland</option>
    <option value="PT">Portugal</option>
    <option value="QA">Qatar</option>
    <option value="CG">Republic of the
    Congo</option>
    <option value="RE">Reunion</option>
    <option value="RO">Romania</option>

    <option value="RU">Russia</option>
    <option value="RW">Rwanda</option>
    <option value="VC">Saint Vincent and
    the Grenadines</option>
    <option value="WS">Samoa</option>
    <option value="SM">San Marino
    </option>
    <option value="ST">São Tomé and
    Príncipe</option>

    <option value="SA">Saudi Arabia
    </option>
    <option value="SN">Senegal</option>
    <option value="SC">Seychelles
    </option>
    <option value="SL">Sierra Leone
    </option>
    <option value="SG">Singapore
    </option>
    <option value="SK">Slovakia</option>

    <option value="SI">Slovenia</option>
    <option value="SB">Solomon Islands
    </option>
    <option value="SO">Somalia</option>
    <option value="ZA">South Africa
    </option>
    <option value="KR">South Korea
    </option>
    <option value="ES">Spain</option>

    <option value="LK">Sri Lanka
    </option>
    <option value="SH">St. Helena
    </option>
    <option value="KN">St. Kitts and
    Nevis</option>
    <option value="LC">St. Lucia
    </option>
    <option value="PM">St. Pierre and
    Miquelon</option>
    <option value="SR">Suriname</option>

    <option value="SJ">Svalbard and Jan
    Mayen Islands</option>
    <option value="SZ">Swaziland
    </option>
    <option value="SE">Sweden</option>
    <option value="CH">Switzerland
    </option>
    <option value="TW">Taiwan</option>
    <option value="TJ">Tajikistan
    </option>

    <option value="TZ">Tanzania</option>
    <option value="TH">Thailand</option>
    <option value="TG">Togo</option>
    <option value="TO">Tonga</option>
    <option value="TT">Trinidad and
    Tobago</option>
    <option value="TN">Tunisia</option>

    <option value="TR">Turkey</option>
    <option value="TM">Turkmenistan
    </option>
    <option value="TC">Turks and Caicos
    Islands</option>
    <option value="TV">Tuvalu</option>
    <option value="UG">Uganda</option>
    <option value="UA">Ukraine</option>

    <option value="AE">United Arab
    Emirates</option>
    <option value="GB">United Kingdom
    </option>
    <option value="UY">Uruguay</option>
    <option value="US">United States</option>
    <option value="VU">Vanuatu</option>
    <option value="VA">Vatican City
    State</option>
    <option value="VE">Venezuela
    </option>

    <option value="VN">Vietnam</option>
    <option value="WF">Wallis and Futuna
    Islands</option>
    <option value="YE">Yemen</option>
    <option value="ZM">Zambia</option>
    </select></td>
    <td width="8">&nbsp;</td>
    </tr>

    <tr>
    <td width="145">&nbsp;</td>
    <td width="289">&nbsp;</td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="434" colspan="2">
    <hr color="#323232" width="96%"></td>
    <td width="8">&nbsp;</td>

    </tr>
    <tr>
    <td width="145">·<span lang="es">
    Name</span></td>
    <td width="289">
    <input type="text" name="name" size="20"></td>
    <td width="8">&nbsp;</td>
    </tr>

    <tr>
    <td width="145">&nbsp;</td>
    <td width="289">&nbsp;</td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">·<span lang="es">
    Age</span></td>

    <td width="289">
    <select size="1" name="age">
    <option value='1'>1</option>
    <option value='2'>2</option>
    <option value='3'>3</option>
    <option value='4'>4</option>
    <option value='5'>5</option>
    <option value='6'>6</option>

    <option value='7'>7</option>
    <option value='8'>8</option>
    <option value='9'>9</option>

    <option value='10'>10</option>
    <option value='11'>11</option>
    <option value='12'>12</option>
    <option value='13'>13</option>
    <option value='14'>14</option>

    <option value='15'>15</option>
    <option value='16'>16</option>
    <option value='17'>17</option>
    <option value='18'>18</option>

    <option value='19'>19</option>
    <option value='20'>20</option>
    <option value='21'>21</option>
    <option value='22'>22</option>

    <option value='23'>23</option>
    <option value='24'>24</option>
    <option value='25'>25</option>
    <option value='26'>26</option>
    <option value='27'>27</option>

    <option value='28'>28</option>
    <option value='29'>29</option>
    <option value='30'>30</option>

    <option value='31'>31</option>
    <option value='32'>32</option>
    <option value='33'>33</option>
    <option value='34'>34</option>
    <option value='35'>35</option>
    <option value='36'>36</option>

    <option value='37'>37</option>
    <option value='38'>38</option>

    <option value='39'>39</option>
    <option value='40'>40</option>
    <option value='41'>41</option>
    <option value='42'>42</option>
    <option value='43'>43</option>
    <option value='44'>44</option>
    <option value='45'>45</option>

    <option value='46'>46</option>

    <option value='47'>47</option>
    <option value='48'>48</option>
    <option value='49'>49</option>
    <option value='50'>50</option>
    <option value='51'>51</option>
    <option value='52'>52</option>
    <option value='53'>53</option>
    <option value='54'>54</option>

    <option value='55'>55</option>
    <option value='56'>56</option>
    <option value='57'>57</option>
    <option value='58'>58</option>
    <option value='59'>59</option>
    <option value='60'>60</option>
    <option value='61'>61</option>
    <option value='62'>62</option>
    <option value='63'>63</option>

    <option value='64'>64</option>
    <option value='65'>65</option>
    <option value='66'>66</option>
    <option value='67'>67</option>
    <option value='68'>68</option>
    <option value='69'>69</option>
    <option value='70'>70</option>
    <option value='71'>71</option>

    <option value='72'>72</option>

    <option value='73'>73</option>
    <option value='74'>74</option>
    <option value='75'>75</option>
    <option value='76'>76</option>
    <option value='77'>77</option>
    <option value='78'>78</option>
    <option value='79'>79</option>

    <option value='80'>80</option>
    <option value='81'>81</option>

    <option value='82'>82</option>
    <option value='83'>83</option>
    <option value='84'>84</option>
    <option value='85'>85</option>
    <option value='86'>86</option>
    <option value='87'>87</option>

    <option value='88'>88</option>
    <option value='89'>89</option>
    <option value='90'>90</option>

    <option value='91'>91</option>
    <option value='92'>92</option>
    <option value='93'>93</option>
    <option value='94'>94</option>
    <option value='95'>95</option>

    <option value='96'>96</option>
    <option value='97'>97</option>
    <option value='98'>98</option>
    <option value='99'>99</option>

    <option value='100'>100</option>
    </select></td>
    <td width="8">&nbsp;</td>
    </tr>

    <tr>
    <td width="145">&nbsp;</td>
    <td width="289">&nbsp;</td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">·<span lang="es">
    Sex</span></td>

    <td width="289">
    <select size="1" name="sex">
    <option selected value="Male">Male
    </option>
    <option value="Female">Female
    </option>
    </select></td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>

    <td width="145">&nbsp;</td>
    <td width="289">&nbsp;</td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">·<span lang="es">
    </span>ZIP Code / CP</td>
    <td width="289">

    <input type="text" name="zip" size="20"></td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">&nbsp;</td>
    <td width="289">&nbsp;</td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>

    <td width="145">·<span lang="es">
    Address</span></td>
    <td width="289">
    <input type="text" name="address" size="20"></td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">&nbsp;</td>

    <td width="289">&nbsp;</td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="436" colspan="2">
    <hr color="#323232" width="96%"></td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>

    <td width="145">&nbsp;</td>
    <td width="289">&nbsp;</td>
    <td width="8">&nbsp;</td>
    </tr>

    <tr>
    <td width="145">&nbsp;</td>
    <td width="289">
    <font color="#FF0000">
    <span style="font-size: 7pt">This Details are IMPORTANT to Change Your Password <br /><br />WARNING..!!<br />DO NOT let others know this details</span></font></td>
    <td width="8">&nbsp;</td>

    </tr>
    <tr>
    <td width="145">· Secret Question<font color="#FF9933">*</font></td>
    <td width="289">
    <input type="text" name="sq" size="34"></td>

    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">&nbsp;</td>
    <td width="289">&nbsp;</td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">· Security Answer<font color="#FF9933">*</font></td>

    <td width="289">
    <input type="text" name="sa" size="34"></td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">&nbsp;</td>
    <td width="289">&nbsp;</td>
    <td width="8">&nbsp;</td>
    </tr>

    <tr>
    <td width="145">· Secret Code<font color="#FF9933">*</font></td>
    <td width="289">
    <input type="text" name="captcha_code" size="10" maxlength="6" /></td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="145">&nbsp;</td>
    <td width="289">
    <img id="captcha" src="includes/captcha/securimage_show.php" alt="CAPTCHA Image" /></td>
    <td width="8">&nbsp;</td>

    </tr>
    <tr>
    <td width="145">&nbsp;</td>
    <td width="289">&nbsp;</td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="434" colspan="2">
    <hr color="#323232" width="96%"></td>
    <td width="8">&nbsp;</td>
    </tr>

    <tr>
    <td width="434" colspan="2">
    <center>
    <td><input type="submit" value="Register" name="submit"></center></td>

    <td width="8">&nbsp;</td>
    </tr>
    </table>
    </div>
    </td>
    </tr>
    <tr>
    <td background="images/cont_top.jpg" height="27">&nbsp;</td>
    </tr>

    </table>
    </div></form>

    <?
    }else{
    ?>
    <head>
    <meta http-equiv="Content-Language" content="es">
    </head>

    <form name="reg" method="POST" action="index.php?do=register"><body bgcolor="#323232">

    <div align="center">
    <table border="0" width="456" style="border-collapse: collapse">
    <tr>
    <td background="images/cont_up.jpg">&nbsp;</td>
    </tr>
    <tr>
    <td background="images/cont_bg.jpg">
    <div align="center">
    <table border="0" style="border-collapse: collapse" width="454" height="100%">
    <tr>
    <td width="4" rowspan="8">&nbsp;</td>
    <td width="436" colspan="2">
    <img border="0" src="images/inf/createaccount.jpg" width="413" height="18"></td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="434" colspan="2">
    &nbsp;</td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="25" valign="middle">
    &nbsp;</td>
    <td width="409" valign="middle">
    The Account '<b><?=$user?></b>' has been created successfully.</td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="25">&nbsp;</td>
    <td width="409">To edit your profile, login and click Profile
    &quot;Edit my account&quot;</td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="434" colspan="2">
    &nbsp;</td>
    <td width="8">&nbsp;</td>
    </tr>
    <tr>
    <td width="434" height="24" colspan="2">
    <center>
    &nbsp;</center></td>
    <td width="8" height="24">&nbsp;</td>
    </tr>
    </table>
    </div>
    </td>
    </tr>
    <tr>
    <td background="images/cont_top.jpg" height="27">&nbsp;</td>
    </tr>
    </table>
    </div></form>
    <?
    }
    ?>
    <td width="206" valign="top">
    <p><? include "modules/mod_iLogin.php" ?></p>
    <p>&nbsp;</p>
    <p>&nbsp;</td>
    <td width="12">&nbsp;</td>
    Reply With Quote Reply With Quote
  5. 20-05-13 #4
    CryZ
    Apprentice CryZ is offline
    MemberRank
    May 2013 Join Date
    12Posts

    Re: web help

    mssql_query("INSERT INTO Login ([UserID],[AID],[Password],[euCoins])VALUES('$user','$aid','$pw1',)");

    or
    mssql_query("INSERT INTO Login ([UserID],[AID],[Password])VALUES('$user','$aid','$pw1')");

    without or with coins?
    Reply With Quote Reply With Quote
  6. 20-05-13 #5
    suhil1
    Account Upgraded | Title Enabled! suhil1 is offline
    MemberRank
    Apr 2010 Join Date
    310Posts

    Re: web help

    without coins
    Reply With Quote Reply With Quote
  7. 20-05-13 #6
    CryZ
    Apprentice CryZ is offline
    MemberRank
    May 2013 Join Date
    12Posts

    Re: web help

    modifies
    mssql_query("INSERT INTO Account (UserID, Cert, Name, Email, Age, Sex, UGradeID, PGradeID, RegDate, Country, sa, sq , captcha_code)Values ('$user', NULL, '$name','$email','$age', '$sex', '0', '0', GETDATE(),'$country', '$sa', '$sq', '$captcha_code')");
    with coins
    mssql_query("INSERT INTO Login ([UserID],[AID],[Password],[euCoins])VALUES('$user','$aid','$pw1','0')");
    Reply With Quote Reply With Quote
  8. 20-05-13 #7
    CryZ
    Apprentice CryZ is offline
    MemberRank
    May 2013 Join Date
    12Posts

    Re: web help

    modifies
    mssql_query("INSERT INTO Account (UserID, Cert, Name, Email, Age, Sex, UGradeID, PGradeID, RegDate, Country, sa, sq , captcha_code)Values ('$user', NULL, '$name','$email','$age', '$sex', '0', '0', GETDATE(),'$country', '$sa', '$sq', '$captcha_code')");
    with coins
    mssql_query("INSERT INTO Login ([UserID],[AID],[Password],[euCoins])VALUES('$user','$aid','$pw1','0')");
    Reply With Quote Reply With Quote
  9. 20-05-13 #8
    CryZ
    Apprentice CryZ is offline
    MemberRank
    May 2013 Join Date
    12Posts

    Re: web help

    Quote Originally Posted by suhil1 View Post
    without coins
    modifies
    mssql_query("INSERT INTO Account (UserID, Cert, Name, Email, Age, Sex, UGradeID, PGradeID, RegDate, Country, sa, sq , captcha_code)Values ('$user', NULL, '$name','$email','$age', '$sex', '0', '0', GETDATE(),'$country', '$sa', '$sq', '$captcha_code')");
    with coins
    mssql_query("INSERT INTO Login ([UserID],[AID],[Password],[euCoins])VALUES('$user','$aid','$pw1','0')");
    Reply With Quote Reply With Quote
  10. 20-05-13 #9
    suhil1
    Account Upgraded | Title Enabled! suhil1 is offline
    MemberRank
    Apr 2010 Join Date
    310Posts

    Re: web help

    modified but still same error
    Reply With Quote Reply With Quote
  11. 21-05-13 #10
    wesman2232
    DRGunZ 2 Creator wesman2232 is offline
    MemberRank
    Jan 2007 Join Date
    Erie, PALocation
    4,872Posts

    Re: web help

    Is everyone retarded around here nowadays?
    First off, use some code tags [code] [ /code]
    Second, I'm not seeing any backslashes in the whole register.php
    line 189: enter the missing value for euCoins. mssql_query("INSERT INTO Login ([UserID],[AID],[Password],[euCoins])VALUES('$user','$aid','$pw1',0)");
    Last edited by wesman2232; 21-05-13 at 01:56 PM.
    Reply With Quote Reply With Quote
  12. 21-05-13 #11
    suhil1
    Account Upgraded | Title Enabled! suhil1 is offline
    MemberRank
    Apr 2010 Join Date
    310Posts

    Re: web help

    wesman2232 thx bro fixed :)
    Reply With Quote Reply With Quote


« Previous Thread | Next Thread »

Advertisement