• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

[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.

About Us

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

Online statistics

Members online
153
Guests online
5,694
Total visitors
5,847
Totals may include hidden visitors.

Forum statistics

Threads
429,198
Messages
4,590,913
Members
281,311
Latest member
ismodev
Most visitors online was 12720 , on 2 May 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top