物品发送脚本

admin

<?php
% Q! _) [7 b0 k0 n+ Q; u. xfunction Connect () {
- f4 \7 T* \2 A5 f( K1 E9 `& Z; Dmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
, q8 \* n, Z" P' U3 Y- ^2 y3 z
Failed.');
}
Connect();

function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
- ?0 H: j2 m+ W* R; a<form name='select' method='post'>
  ]5 |$ P+ A1 I3 N( B4 {<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
, @4 y) p; E, {7 r6 ~( m, U<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
) M! S# S5 G" x% O<lable>Item Amount</lable><br/>
5 W% `% x) f5 [+ X, M2 U<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
. q6 A  k& x; o' m<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

  j6 q+ f; o, A) f9 e2 I</lable><br/>
. K; @: ^3 O, N( r* `% r1 Y<input type='text' name='item_element'/><br/>
6 W* z, _7 H* s4 K# i<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
( g' E9 G* r7 i# P7 f5 E7 s( ~( T<input type='text' name='item_pierce'/><br/>
, A6 T& \3 T8 u<input type='submit'/>
</form>";
2 P; @  _- j' i! A  U}

+ X1 l2 ?8 B# r5 rfunction PostListener (){
6 r6 i8 A$ Y8 W  M7 a//Add more post variables if needed and add them to initform() function aswell

################################
9 V8 o+ q" M2 F& |" F##### Connection and Post ######
################################
$name = @$_POST['char'];
2 m3 l0 O/ f, ~0 `$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
8 e! A- f" H& D( C" e6 Y5 l) Z" m# I$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
5 @; \( b+ [) |0 y5 f1 [################################

//Check both variables for empty value
+ O' p+ `' e. }. ^( U0 X
# t5 O& |9 R$ d0 G& j. lif (!empty($_POST['char'])){
% J- z) C- s# W& Z( k" I$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

0 k2 ^' d4 y4 b8 g; Ym_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
; ]  }2 u8 A2 z- O5 B2 v$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
) \/ {; x5 x. O8 d$ O/ Q! M$ j5 D9 N
/ Y' ?8 T5 P+ K6 C[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

5 L, s& f7 G+ o, d[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
  c1 d* @5 L! ?5 R" Z9 X: d
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
6 R  d: ~- P- E" T3 n
'{$ElementUpgrade}', '{$ItemPierce}');");
}
& u" D' x1 o  g( ~
}
  ^$ P% ?, R4 Y# K
}

9 r/ n4 V. `' T- N  E/ ~$InitForm = InitForm();
' w. T, M- D/ ?2 }3 P$Listener = PostListener();

?>
/ e% |. m: F7 B, u0 q9 d
7 L# {  j9 f0 c: ~, Y4 _3 a


9 j) e! |: O6 P& }