Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[RELEASE] PHP Scripts for your websites.

shaikat11

shaikat11

Newbie Spellweaver
Joined
Jun 17, 2007
Messages
52
Reaction score
1
Meh i'll share too ._.;
Don't mock my crappy syntax pl0x.
I made this when I was new to php.
I have more.. Reply with what you need and i'll help out.

Drop these files in xxamp or whatever web server your using.

Register Script(save as register.php):
Code: 
<?php
$host = "localhost";
$user = "GTFO";
$pw   = "GTFO";

?>
<table border=0>
<form action="register.php" method="post">
<tr><td>User ID:</td><td><input type="text" name="hofid" /></td></tr><br>
<tr><td>Password:</td><td><input type="text" name="hofpw" /></td></tr> <br>
<tr><td>E-Mail:</td><td><input type="text" name="hofemail" /></td></tr><br>
<tr><td>Full Name:</td><td><input type="text" name="thename" /></td></tr><br>
<tr><td>Gender:</td><td><select name="gender" ><option value="1">Male</option><option value="2">Female</option></select></td></tr>
<tr><td><input type="Submit" value="Register!"/></form></td></tr>
</tabLe>

<?php
function clean($x)
 {
    $a = mysql_real_escape_string(htmlspecialchars($x));
    return $a;
  }
if(isset($_POST['hofid']))
  {

$teh_id = clean($_POST['hofid']) ;
$teh_password = clean($_POST['hofpw']);
$teh_card = clean($_POST['hofemail']);
$teh_sex = clean($_POST['gender']);
$teh_name = clean($_POST['thename']);
$myDB = "rxjhaccount"; 
$con = mssql_connect($host, $user, $pw)
  or die("PLEASE GTFO"); 

mssql_select_db($myDB, $con);

$sql=" INSERT INTO tbl_account (FLD_ID, FLD_PASSWORD, FLD_CARD, FLD_SEX, FLD_NAME) 
VALUES ('$teh_id', '$teh_password', '$teh_card', '$teh_sex', '$teh_name') ";

if (!mssql_query($sql))
  {
  die('Error: ' . mssql_error());
  }
  
echo "You have been registered!";

mssql_close($con);
  }
?>

Top 30 Players(AKA Ranking):
<center><h1> Top 30 Players<br /> </h1>
<?php

$host = "localhost";
$user = "GTFO";
$pw = "GTFO";
$myDB = "rxjhgame";
$link = mssql_connect($host, $user, $pw)
or die("PLZ GTFO");

mssql_select_db($myDB, $link);

$query = "SELECT TOP 30
FLD_LEVEL AS FLD_LEVEL,
FLD_NAME AS FLD_NAME,
FLD_JOB AS FLD_JOB FROM tbl_xwwl_char where FLD_J9 = 0
ORDER BY FLD_LEVEL DESC
";
$result = mssql_query($query);


echo "<table border='0'>";
echo "<tr><th width=1>Level </th> <th width=40%>Character</th> <th width=20%>Job</th> </tr>";

while($row = mssql_fetch_array($result)) {
echo "<tr><td bgcolor=''><center>";
echo $row['FLD_LEVEL'];
echo "</center></td><td bgcolor=''><center>";
echo $row['FLD_NAME'];
echo "</center></td><td bgcolor=''><center>";
if ($row['FLD_JOB']=="1")
echo "Blader";
if ($row['FLD_JOB']=="2")
echo "Sword";
if ($row['FLD_JOB']=="3")
echo "Spear";
if ($row['FLD_JOB']=="4")
echo "Archer";
if ($row['FLD_JOB']=="5")
echo "Healer";
if ($row['FLD_JOB']=="6")
echo "Ninja";

echo "</center></td></tr>";
}
echo "</table>";

?>

</center>
[/CODE]

Translate Database(NOT CLIENT)
This is for references, I used this for quick refrences:
Code: 
<?php
$host = 'gtfo';
$user = 'gtfo';
$pw   = 'gtfo';
$database = "publicdb"; 
$con = mssql_connect($host, $user, $pw) or die("...");
   mssql_select_db($database, $con);
   
   
$sql = "SELECT * FROM TBL_XWWL_ITEM WHERE FLD_LEVEL < 121 and FLD_DF > 1 and FLD_AT1 = 0 and FLD_ZX > 0"; 

$result = mssql_query($sql);
$i = 0;

while ($row = mssql_fetch_array($result))
  {
    $v = "";
	$i++; 
	$v .= $row['FLD_LEVEL']; 
	If ($row['FLD_ZX'] == 1) 
	  {
	    $v .= "Order";
	  }
	  else
	  {
	    $v .= "Chaos"; 
	  }
	If ($row['FLD_SEX'] == 1)
	   {
	    $v .= "[M]"; 
	   }
	   
	   If ($row['FLD_SEX'] == 2)
	   {
	    $v .= "[F]"; 
	   }
	   
	If($row['FLD_RESIDE2'] == 1 && $row['FLD_RESIDE1'] == 1)
	  {
	     $v .= "Blade";
	  }	
	If($row['FLD_RESIDE2'] == 1 && $row['FLD_RESIDE1'] == 2)
	  {
	     $v .= "Sword";
	  }
	  	If($row['FLD_RESIDE2'] == 1 && $row['FLD_RESIDE1'] == 3)
	  {
	     $v .= "Spear";
	  }
	  	If($row['FLD_RESIDE2'] == 1 && $row['FLD_RESIDE1'] == 4)
	  {
	     $v .= "Bow";
	  }
	  	If($row['FLD_RESIDE2'] == 1 && $row['FLD_RESIDE1'] == 5)
	  {
	     $v .= "Healer";
	  }
	  	  	If($row['FLD_RESIDE2'] == 1 && $row['FLD_RESIDE1'] == 6)
	  {
	     $v .= "Ninja";
	  }
	  If ($row['FLD_RESIDE2'] == 2)
	  {
	    $v .= "Bracer";
	  }
	  If ($row['FLD_RESIDE2'] == 5)
	  {
	    $v .= "Boots";
	  }
	  
	  $name = $row['FLD_NAME']; 
	  $k    = $row['FLD_RESIDE2']; 
	  $is    = $row['FLD_PID']; 
	  
	  $sql2 = "UPDATE TBL_XWWL_ITEM set FLD_NAME = '$v' where FLD_NAME = '$name' 
	           and FLD_RESIDE2 = '$k' and FLD_PID = '$is' "; 
			   
	   mssql_query($sql2); 
	   
  }
echo "$i"; 
echo " updated"; 
?>
<?php
$host = 'gtfo';
$user = 'gtfo';
$pw   = 'gtfo';
$database = "publicdb"; 
$con = mssql_connect($host, $user, $pw) or die("...");
   mssql_select_db($database, $con);
   
   
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C15Dagger' WHERE FLD_PID = 700202040   "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C14Dagger' WHERE FLD_PID = 700202038  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C13Dagger' WHERE FLD_PID = 700202036  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C12Dagger' WHERE FLD_PID = 700202034  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C11Dagger' WHERE FLD_PID = 700202032  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C10Dagger' WHERE FLD_PID = 700202030  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C9Dagger' WHERE FLD_PID = 700202028  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C8Dagger' WHERE FLD_PID = 700202026  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'c7Dagger' WHERE FLD_PID = 700202024  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C6Dagger' WHERE FLD_PID = 700202022  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C5Dagger' WHERE FLD_PID = 700202020  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C4Dagger' WHERE FLD_PID = 700202018  "; mssql_query($sql); 

$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O15Dagger' WHERE FLD_PID = 700201039 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O14Dagger' WHERE FLD_PID = 700201037 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O13Dagger' WHERE FLD_PID = 700201035 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O12Dagger' WHERE FLD_PID = 700201033 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O11Dagger' WHERE FLD_PID = 700201031 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O10Dagger' WHERE FLD_PID = 700201029 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O9Dagger' WHERE FLD_PID = 700201027 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'o8Dagger' WHERE FLD_PID = 700201025 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O7Dagger' WHERE FLD_PID = 700201023 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O6Dagger' WHERE FLD_PID = 700201021 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O5Dagger' WHERE FLD_PID = 700201019 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O4Dagger' WHERE FLD_PID = 700201017 "; mssql_query($sql); 

$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C15Staff' WHERE FLD_PID = 500202040   "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C14Staff' WHERE FLD_PID = 500202038  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C13Staff' WHERE FLD_PID = 500202036  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C12Staff' WHERE FLD_PID = 500202034  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C11Staff' WHERE FLD_PID = 500202032  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C10Staff' WHERE FLD_PID = 500202030  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C9Staff' WHERE FLD_PID = 500202028  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C8Staff' WHERE FLD_PID = 500202026  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'c7Staff' WHERE FLD_PID = 500202024  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C6Staff' WHERE FLD_PID = 500202022  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C5Staff' WHERE FLD_PID = 500202020  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C4Staff' WHERE FLD_PID = 500202018  "; mssql_query($sql); 

$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O15Staff' WHERE FLD_PID = 500201039 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O14Staff' WHERE FLD_PID = 500201037 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O13Staff' WHERE FLD_PID = 500201035 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O12Staff' WHERE FLD_PID = 500201033 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O11Staff' WHERE FLD_PID = 500201031 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O10Staff' WHERE FLD_PID = 500201029 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O9Staff' WHERE FLD_PID = 500201027 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'o8Staff' WHERE FLD_PID = 500201025 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O7Staff' WHERE FLD_PID = 500201023 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O6Staff' WHERE FLD_PID = 500201021 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O5Staff' WHERE FLD_PID = 500201019 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O4Staff' WHERE FLD_PID = 500201017 "; mssql_query($sql); 

$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C15Bow' WHERE FLD_PID = 400202040   "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C14Bow' WHERE FLD_PID = 400202038  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C13Bow' WHERE FLD_PID = 400202036  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C12Bow' WHERE FLD_PID = 400202034  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C11Bow' WHERE FLD_PID = 400202032  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C10Bow' WHERE FLD_PID = 400202030  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C9Bow' WHERE FLD_PID = 400202028  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C8Bow' WHERE FLD_PID = 400202026  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'c7Bow' WHERE FLD_PID = 400202024  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C6Bow' WHERE FLD_PID = 400202022  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C5Bow' WHERE FLD_PID = 400202020  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C4Bow' WHERE FLD_PID = 400202018  "; mssql_query($sql); 

$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O15Bow' WHERE FLD_PID = 400201039 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O14Bow' WHERE FLD_PID = 400201037 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O13Bow' WHERE FLD_PID = 400201035 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O12Bow' WHERE FLD_PID = 400201033 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O11Bow' WHERE FLD_PID = 400201031 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O10Bow' WHERE FLD_PID = 400201029 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O9Bow' WHERE FLD_PID = 400201027 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'o8Bow' WHERE FLD_PID = 400201025 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O7Bow' WHERE FLD_PID = 400201023 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O6Bow' WHERE FLD_PID = 400201021 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O5Bow' WHERE FLD_PID = 400201019 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O4Bow' WHERE FLD_PID = 400201017 "; mssql_query($sql); 


$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C15Spear' WHERE FLD_PID = 300202040   "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C14Spear' WHERE FLD_PID = 300202038  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C13Spear' WHERE FLD_PID = 300202036  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C12Spear' WHERE FLD_PID = 300202034  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C11Spear' WHERE FLD_PID = 300202032  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C10Spear' WHERE FLD_PID = 300202030  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C9Spear' WHERE FLD_PID = 300202028  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C8Spear' WHERE FLD_PID = 300202026  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'c7Spear' WHERE FLD_PID = 300202024  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C6Spear' WHERE FLD_PID = 300202022  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C5Spear' WHERE FLD_PID = 300202020  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C4Spear' WHERE FLD_PID = 300202018  "; mssql_query($sql); 

$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O15Spear' WHERE FLD_PID = 300201039 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O14Spear' WHERE FLD_PID = 300201037 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O13Spear' WHERE FLD_PID = 300201035 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O12Spear' WHERE FLD_PID = 300201033 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O11Spear' WHERE FLD_PID = 300201031 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O10Spear' WHERE FLD_PID = 300201029 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O9Spear' WHERE FLD_PID = 300201027 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'o8Spear' WHERE FLD_PID = 300201025 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O7Spear' WHERE FLD_PID = 300201023 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O6Spear' WHERE FLD_PID = 300201021 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O5Spear' WHERE FLD_PID = 300201019 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O4Spear' WHERE FLD_PID = 300201017 "; mssql_query($sql); 


$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C15Sword' WHERE FLD_PID = 200202040   "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C14Sword' WHERE FLD_PID = 200202038  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C13Sword' WHERE FLD_PID = 200202036  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C12Sword' WHERE FLD_PID = 200202034  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C11Sword' WHERE FLD_PID = 200202032  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C10Sword' WHERE FLD_PID = 200202030  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C9Sword' WHERE FLD_PID = 200202028  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C8Sword' WHERE FLD_PID = 200202026  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'c7Sword' WHERE FLD_PID = 200202024  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C6Sword' WHERE FLD_PID = 200202022  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C5Sword' WHERE FLD_PID = 200202020  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C4Sword' WHERE FLD_PID = 200202018  "; mssql_query($sql); 

$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O15Sword' WHERE FLD_PID = 200201039 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O14Sword' WHERE FLD_PID = 200201037 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O13Sword' WHERE FLD_PID = 200201035 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O12Sword' WHERE FLD_PID = 200201033 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O11Sword' WHERE FLD_PID = 200201031 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O10Sword' WHERE FLD_PID = 200201029 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O9Sword' WHERE FLD_PID = 200201027 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'o8Sword' WHERE FLD_PID = 200201025 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O7Sword' WHERE FLD_PID = 200201023 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O6Sword' WHERE FLD_PID = 200201021 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O5Sword' WHERE FLD_PID = 200201019 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O4Sword' WHERE FLD_PID = 200201017 "; mssql_query($sql); 


$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C15Blade' WHERE FLD_PID = 100202040   "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C14Blade' WHERE FLD_PID = 100202038  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C13Blade' WHERE FLD_PID = 100202036  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C12Blade' WHERE FLD_PID = 100202034  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C11Blade' WHERE FLD_PID = 100202032  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C10Blade' WHERE FLD_PID = 100202030  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C9Blade' WHERE FLD_PID = 100202028  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C8Blade' WHERE FLD_PID = 100202026  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'c7Blade' WHERE FLD_PID = 100202024  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C6Blade' WHERE FLD_PID = 100202022  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C5Blade' WHERE FLD_PID = 100202020  "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'C4Blade' WHERE FLD_PID = 100202018  "; mssql_query($sql); 

$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O15Blade' WHERE FLD_PID = 100201039 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O14Blade' WHERE FLD_PID = 100201037 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O13Blade' WHERE FLD_PID = 100201035 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O12Blade' WHERE FLD_PID = 100201033 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O11Blade' WHERE FLD_PID = 100201031 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O10Blade' WHERE FLD_PID = 100201029 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O9Blade' WHERE FLD_PID = 100201027 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'o8Blade' WHERE FLD_PID = 100201025 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O7Blade' WHERE FLD_PID = 100201023 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O6Blade' WHERE FLD_PID = 100201021 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O5Blade' WHERE FLD_PID = 100201019 "; mssql_query($sql); 
$sql = "UPDATE TBL_XWWL_ITEM SET FLD_NAME = 'O4Blade' WHERE FLD_PID = 100201017 "; mssql_query($sql); 



   echo "Done";
   
   ?>
 
Last edited:
The Best DDoS Protected Servers
shaikat11

shaikat11

Newbie Spellweaver
Joined
Jun 17, 2007
Messages
52
Reaction score
1
Re: PHP Scripts for your websites.

Phant0m said:
Thanks, this will be useful for the newbies :)
Click to expand...
Hopefully they understand to edit the $host,$user,$pw ..
Bet you 90% of them will just copy+paste and complain it won't work..
 
You must log in or register to reply here.

RaGEZONE Sponsor

    HyperFilter

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Forum statistics

Threads
429,975
Messages
4,595,538
Members
285,436
Latest member
potihp
Most visitors online was 17251 , on 24 May 2024

Partners

    nongamstopbets.com Non-GamStop CasinoGap Casino Deps NZ
Back
Top