物品发送脚本

admin

<?php
( n" `4 {, C2 n' I7 E6 R: vfunction Connect () {
- u; d% M4 j7 V3 J. @$ W9 nmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

" i* E7 |: Q8 n  f0 f' eFailed.');
" X" ~/ c5 ]6 o& H9 |}
$ x: o2 u! A& G& n# _" aConnect();
  Q4 j1 s5 e" O1 {* V
* }! G; d1 a6 d. s0 _function InitForm(){
) K& j  Y$ W- h7 Q, P6 ~' j//layout for the form
: R! C3 Y3 `; Y4 Decho "<strong>Send Items.</strong>
; @7 d" y# u6 d! k' \<form name='select' method='post'>
<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/>
& N5 M2 d- V. w% \1 |1 y0 _! c<input type='text' name='item_amount'/><br/>
# j$ m# |9 {) G<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
  w( A5 x( K" V1 U( v; {* S<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

, ~8 l. V. ^/ ?8 ^9 _% _2 N</lable><br/>
& A5 a* L1 e' @# P9 K# S<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
% D' I3 m" p' D8 v0 k% K1 M<input type='text' name='element_upgrade'/><br/>
/ J7 h/ e+ J6 o1 j; m<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
& S0 Z  }- q: T) J- _8 U/ ?! x) J<input type='submit'/>
</form>";
}
2 o' {% |: L0 [. D& f
8 d: l& X7 w. b, gfunction PostListener (){
7 F' d5 y' V4 Q, D  \6 ?//Add more post variables if needed and add them to initform() function aswell
2 R! y" l% H2 a
################################
" U9 `8 U4 k& T" m2 T4 \$ u##### Connection and Post ######
4 {2 H: V( v, O4 c  E################################
$name = @$_POST['char'];
4 `* Q4 d; p  }  {2 H$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
: R9 b% _1 T- P! e, ?$ItemId = @$_POST['item_id'];
% D3 C2 s& L7 K$ItemUpgrade = @$_POST['item_upgrade'];
; ~: I% }9 X, x, V/ U- J$ItemElement = @$_POST['item_element'];
9 C$ w( j: l, n: b' ]$ElementUpgrade = @$_POST['element_upgrade'];
2 C( p) d$ k& |0 K4 F8 l3 N$ItemPierce = @$_POST['item_pierce'];
; |) z6 E+ s) v! N: r: ~################################
# m+ e& r6 ?% h6 {. i
//Check both variables for empty value
5 n- N4 {; U) i- m3 Y5 d
if (!empty($_POST['char'])){
# r2 w3 I: h2 }7 k( |9 H8 p7 ~$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
" ^* O0 r2 y- F% u) }
* s. G1 C5 F: A7 ?; w6 q5 q2 pm_szName = '{$name}'");
7 H: y5 J! e+ U' V# |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],
2 f! g) b% p# b
! ?, |% m0 j9 U[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

, ]* E+ i3 J: R0 G4 M# e* S* E[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
) x* F' ]# L9 z( |7 |$ U
5 o) h6 j. X4 B2 L0 ZN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
+ n' t/ p; k/ W) C" u) K
'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

3 V8 c  G  N7 J" L2 a  e}
4 q/ W  {2 T7 {+ _4 g; H& B$ v
5 ]' l3 }3 h9 H- a& f) b5 @& f$InitForm = InitForm();
$Listener = PostListener();
' O3 j- D( m. |! f7 |0 }
/ H$ v) S2 u, H3 b3 e% I?>
) T; z9 e1 b0 z" ^" k) [
' K4 Y% G9 D+ C

/ |9 u6 _# r5 X4 U7 U
" H+ `/ m' `! E( k9 s; w