[RELEASE] Clear Items Page

[fsadario]

Here is my script for clear items. I tested and works. If you wanna add something or if you have a problem post it here.

<style type="text/css">
<!--
.Estilo1 {font-size: 14px}
-->
</style>
<title>Clear Items By DaRIo</title><table width="332" height="110" border="4" align="center" bordercolor="#CCCCCC">
<?php
$mssql_user = "";
$mssql_pass = "";
$mssql_database = "GunZDB";
$mssql_host = "";
$conn = mssql_connect($mssql_host, $mssql_user, $mssql_pass) or die("Cannot connect host.");
mssql_select_db($mssql_database) or die("Cannot connect database.");
?>
  <tr>
    <td height="23"><div align="center" class="Estilo1">Clear Items Form by DaRIo</div></td>
  </tr>
  <tr>
    <td height="23"><FORM METHOD=POST ACTION="<?php echo $_SERVER['PHP_SELF']; ?>?do=lol">
      <table width="321" border="0">
        <tr>
          <td width="71" class="Estilo1">Username</td>
          <td width="240"><label>
            <input name="user" type="text" id="user">
          </label></td>
        </tr>
        <tr>
          <td class="Estilo1">Password</td>
          <td><label>
            <input name="pass" type="password" id="pass">
          </label></td>
        </tr>
        <tr>
          <td class="Estilo1">Character</td>
          <td><input name="char" type="text" id="char"></td>
        </tr>
        <tr>
          <td class="Estilo1">Item Part </td>
          <td><label>
            <select name="part" id="part">
              <option value="head_itemid">Head</option>
              <option value="chest_itemid">Chest</option>
              <option value="hands_itemid">Hands</option>
              <option value="legs_itemid">Legs</option>
              <option value="feet_itemid">Feet</option>
            </select>
          </label></td>
        </tr>
      </table>
	 <tr>
    <td height="23"><div align="center">
      <input type="submit" name="Submit" value="Clear Items">
	</td>
  </tr>
  <tr>
    <td height="23"><div align="center">
      <label></label><?php 
if ($_GET['do'] == 'lol') 
{ 
    $user = anti_injection($_POST['user']); 
    $pass = anti_injection($_POST['pass']); 
    $char = anti_injection($_POST['char']);
	$part = anti_injection($_POST['part']);
    if (valida(Array($user,$pass,$char)) == true) {
		$query = mssql_query("SELECT * FROM Accounts WHERE UserID='$user' AND Password='$pass'");
		$rows = mssql_num_rows($query);
		if ($rows != 1) { echo "User/Pass Incorrect."; } else {
			$query1 = mssql_query("SELECT * FROM Character WHERE Name='$char'");
			$rows1 = mssql_num_rows($query1);
			if ($rows1 != 1) { echo "Char Incorrect."; } else {
					$queryx = mssql_query("SELECT AID FROM Character WHERE Name='$char'");
					while($myrow = mssql_fetch_array($queryx))
					{
					$PJAID = $myrow['AID'];
					}
					$queryxy = mssql_query("SELECT AID FROM Accounts WHERE UserID='$user'");
					while($myrow1 = mssql_fetch_array($queryxy))
					{
					$CUENTAPJ = $myrow1['AID'];
					}
						if ($PJAID != $CUENTAPJ) { echo "That Isnt Your char."; } else {
					$query2 = mssql_query("UPDATE Character SET $part='0' WHERE Name='$char'");
					if (!$query2) { echo "Error, try again later"; } else { echo "Items cleaned!";
					}
				}
			}
		}
	}
}
function anti_injection($sql) 
{ 
$sql = preg_replace(sql_regcase("/(from|select|insert|delete|where|drop table|show tables|#|\*|--|\\\\)/"),"",$sql); 
$sql = trim($sql); 
$sql = strip_tags($sql); 
$sql = addslashes($sql); 
return $sql; 
} 
function valida($campos){ 
  foreach($campos as $c){ 
      if(empty($c)){ 
        echo "All Fields are need."; 
        return false; 
      }else{ 
        return true; 
      } 
  } 
} 
?></form>
    </div></td>
  </tr>
</table>

I maked a new code.
HOW TO CONFIG::
Search Line:

$mssql_user = ""; << MSSQL USER
$mssql_pass = ""; << MSSSQL PASS
$mssql_database = "GunZDB"; << DATABASE
$mssql_host = ""; << MSSQL HOST

Enjoy ^^:robot:

 

[Chaosiukas]

where can i use it?

 

[fsadario]

Copy Code. Paste it on a New WordPad, NotePad, Dreamweaver, etc.. document.
Save as clearitems.php and put it on WWW folder.
Now, go to browser to

You must be registered to see links

 

[Chaosiukas]

thanks

 

[MAXTRAXv3]

thanks, nice work....xD

 

[yaari]

i get a error:

warning: mssql connect () [function mssql-connect]

connet to SERVER...

what i doing?

 

[Centrix]

preview?

 

[yaari]

what to do?

 

[fsadario]

yaari: check if all data is fine.

 

[-Rob3r-]

thx dario works for me

 

[yaari]

the data is fine...

 

[Linear88]

Errors:

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: FAMILY\SQLEXPRESS in C:\Program Files\WAMP\www\clearitems.php on line 12
Cannot connect host.

 

[ThuGie]

meaning you arent running a mssql server or your settings are wrong .

 

[Linear88]

I always get that error. I my host is LOCALMACHINE\SQLEXPRESS

 

[k0ven]

What we miss here is an example on this code:

$mssql_user = ""; << MSSQL USER 
$mssql_pass = ""; << MSSSQL PASS 
$mssql_database = "GunZDB"; << DATABASE 
$mssql_host = ""; << MSSQL HOST