物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
$ X: ^/ V, G5 V: p9 f9 B$ |
Failed.');
2 h: Y  Y* l5 |* @}
4 B/ l" E7 \0 G) i* L2 a6 _Connect();

function InitForm(){
' L/ z. C0 c& h. Z) ~. N3 E" M5 I! t. g//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
  a. y# [4 s; L<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
8 F6 S. d* y9 O0 j+ ~<input type='text' name='item_amount'/><br/>
# Q, J! ~4 y2 ]<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
* b; r, L/ ^5 \8 K<input type='text' name='item_element'/><br/>
4 g9 e- g3 P! G, w6 }( L  C<lable>Element Upgrade Amount</lable><br/>
) M/ S, P/ Z1 z* N  K  B  I* ~7 R  x<input type='text' name='element_upgrade'/><br/>
4 [7 x1 H; M4 e( f: j% c<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
( a( {$ u1 X1 w$ g; ~0 i) A% O<input type='submit'/>
</form>";
- B2 Z+ _1 q& ^}

function PostListener (){
& s  q# j5 f' L1 J% F5 l8 G4 e//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
$ V3 {, g1 B9 E1 j################################
) d. D6 Q# R) o) s$name = @$_POST['char'];
2 ]) F$ c& ]5 x$ItemName = @$_POST['item_name'];
+ {' b" p2 G3 E" j  Z/ C$ItemAmount = @$_POST['item_amount'];
& K: K  B1 x( f  S4 e0 j; l% B$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
! p5 K' q# `8 W2 r) F" u% r, G$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
- P2 |7 h9 U7 H; ?$ m" b################################

6 U: q* U1 [7 y% P# H  Z, u! k//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
* h5 d+ \4 Z6 |' z$ z
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
+ p' ~$ @2 g% s* ~( w) `
( d2 H' x' }8 j7 x, A5 [[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

, z- l0 f- ^2 i( pN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
5 R) q7 }$ h3 r- B$ T& }  ^}

7 Y' |7 O" r0 w9 C  \. n% F$ @}

}
1 t0 d- \2 ^( Z
$InitForm = InitForm();
. W. G% \2 O5 v- W0 B, u$Listener = PostListener();

?>

4 ?4 L2 J7 x, l! u. l

$ I/ x- [5 {4 Y; x% Z1 w" F