物品发送脚本

admin

<?php
4 L2 d9 ~0 l  R% nfunction Connect () {
4 M$ o# K* y* m1 Vmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
3 E$ Y! @# s; j9 A$ PConnect();

+ S6 G/ D, P; ^* X! k$ _8 \0 Ffunction InitForm(){
//layout for the form
! y& P( Z. h6 M, ?5 ~echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
8 |! I. I+ o1 C" f<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/>
; K6 e1 L9 h% t; b# o<lable>Item Amount</lable><br/>
. I  T6 C- `# p: h" M<input type='text' name='item_amount'/><br/>
7 x/ B% m' |. S<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
3 {4 ^( P5 K" w: l* P( y- N<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

4 {- {, Y: r% |4 Y( D- z</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
* U' b- h7 B3 X2 S" t$ O* _<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
8 G) U) z0 p+ B& w<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
5 s) l$ m4 |9 O% Y/ w6 v4 n, Z- d}
4 a) [  m( t7 N6 R( r% _
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
, [8 |6 i+ f, K! {
. r2 b5 a* ^; f$ d) S3 [# X( E- j################################
##### Connection and Post ######
* A( ?! Y8 }( v1 x8 `################################
& A8 _& X% A% X; |$name = @$_POST['char'];
' P: f1 q) n. z! L4 e) i$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
1 y- }  m) k+ \  Z+ f. G" j. Q$ItemId = @$_POST['item_id'];
* e' ]: [7 `) X$ T: j) y4 {0 ^3 A$ItemUpgrade = @$_POST['item_upgrade'];
( P/ [. [' Z5 K. g6 ~+ Q2 H+ q$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

0 e5 B- @5 }4 `& o1 s5 o3 J; `//Check both variables for empty value
8 n, L. H  t- k: k) u1 n/ X
' y( M5 K- L9 r3 [1 ~7 Wif (!empty($_POST['char'])){
: @- C& m& t" M( c4 h$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

  o7 h+ m  t, y) }4 C  _m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
& e! ~' N4 U" S" Z8 Recho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: L) D; D' C) m2 m6 A$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
  C" ^3 t( X5 ^  j0 X  Y! G
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

( G; v$ `- c0 R; RN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

3 R8 d0 C9 y. ]) U! u/ T. ~. v3 \'{$ElementUpgrade}', '{$ItemPierce}');");
}
5 Q- c1 m2 p( f6 ~8 N
}
7 H2 O2 ?7 {' D8 J7 R5 g- I2 h' r- }
}

$InitForm = InitForm();
1 @- C% K' t* L7 A; @$Listener = PostListener();

?>
- E# j4 m5 e9 `; ]3 F( ?; K
  H3 P0 m! q1 K1 b7 X( o: c* ]


2 F4 z5 \' t. O8 a8 a/ [+ l  k