物品发送脚本

admin

<?php
$ k" V0 ?# S, a/ P, q0 Ofunction Connect () {
9 r4 g! }$ S2 H( {, @mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
' C4 Q$ v- p6 N& k% w2 V
Failed.');
2 C& S# S7 i7 r( G' o6 p! E" s}
  p; e* C2 e. W6 n4 EConnect();
# }- C* d: I4 b8 Z. i& Z* |
+ `( p* r5 b, A& u# _4 rfunction InitForm(){
//layout for the form
; w8 w: S: P6 n3 Yecho "<strong>Send Items.</strong>
! J3 }. h+ N( \1 |2 V5 u<form name='select' method='post'>
<lable>Character Name</lable><br/>
5 Q1 E. o! A* Y. L<input type='text' name='char'/><br/>
" x0 O! k3 V# ]0 X/ T8 H: Q+ f<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
3 B) h8 l1 t3 S: a$ _% J<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
$ r2 J+ G7 [! V2 ~; \2 Q<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
# A+ W2 u8 ~; N5 N* }" h
</lable><br/>
<input type='text' name='item_element'/><br/>
( {- B. W: V+ @; S5 b: Q8 R<lable>Element Upgrade Amount</lable><br/>
8 d5 L& A* @$ ]- {) Y<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
: D- M6 @6 G: _8 }- _& j, y& X</form>";
}
) w, W: j0 b; A1 a( J9 A- M
function PostListener (){
/ r$ W! ]' Z) f: {% w1 O//Add more post variables if needed and add them to initform() function aswell
4 h6 T& Q& d- O6 J4 `1 Z
################################
3 T( U9 e  L9 N# U& C; [- v##### Connection and Post ######
4 |& c, y& Q. U################################
, i  Y/ x5 r' \& x$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
0 }2 g: h3 p9 S3 k$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
; Y! B5 t7 `- k; M! Y' h( X* z) K. {$ItemUpgrade = @$_POST['item_upgrade'];
2 O' F7 Q2 A9 q4 c8 j: a2 P$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
3 b9 B5 q$ X, u9 D) G6 ?0 e6 v$ItemPierce = @$_POST['item_pierce'];
################################

6 y! E$ F0 _$ c0 T//Check both variables for empty value
: M3 _. o/ F8 R9 N9 C% N* t
8 D, F3 c2 u' z# }3 y  mif (!empty($_POST['char'])){
: P) l, m- O' {% m$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
- c1 u+ M( [( H2 Lwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
- ^2 v7 X5 A( r0 @) D$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
" ]8 i/ C3 w1 g. W# x' _; N
8 k, o) b  ]: w: h. p* i5 H[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
: H" e) }  L/ a
" `4 Z6 R0 W$ F" D$ k* [6 D[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
9 O: c- _7 X% O( X. D+ O1 K. {. ]}
  K: x; q. d, g) j1 L
}

2 T$ s1 E  {4 ?2 ~* Q9 I8 B}

- P9 @$ }  q' S* V4 Y$InitForm = InitForm();
$Listener = PostListener();

?>



1 T. S0 R- H8 {8 m