物品发送脚本

admin

<?php
0 O3 j( U, a. t! m# Ufunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

1 h' L' i/ A6 u  r+ g4 e6 z7 r) x/ wFailed.');
}
" P7 q  ^+ V0 o  NConnect();
- P; [* D$ F1 H/ f( S* C7 \
5 ^  O; M- B( H! ]function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
; y" v# d7 N* H5 D+ k7 s# n$ t& c<form name='select' method='post'>
4 c* y1 I; {0 U<lable>Character Name</lable><br/>
: z+ Z4 |1 |) z<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/>
' h* h1 L* }7 ^& }8 A; w3 p<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/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

5 k: g+ x: G3 o& A4 d</lable><br/>
3 ^. d# k% ?, {. }<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
+ ^9 {5 G! I, Z& w) g  U<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
/ z1 @- p' ^3 y' ]</form>";
}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
! U5 I8 P: ]6 x) _5 M
- x3 z9 i! u3 c. c- S/ y7 L3 R& t; ^################################
##### Connection and Post ######
################################
. [8 t. u2 a$ q$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
3 p9 t* E2 G; I7 A$ItemAmount = @$_POST['item_amount'];
) g6 J% Y$ a  t5 k$ ?$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
1 |% ^) A( W/ T+ x7 u; U1 k8 ?$ItemElement = @$_POST['item_element'];
4 j1 y8 S5 N1 E6 v: i4 U' H$ElementUpgrade = @$_POST['element_upgrade'];
, a7 q2 D/ |0 p3 {: A7 H; i4 w& b$ItemPierce = @$_POST['item_pierce'];
################################

7 n$ v6 P9 }# v1 |. d//Check both variables for empty value
! \& R' V) J, O" G6 q. r- o
& M- m0 y# C% A% x$ o- \3 Wif (!empty($_POST['char'])){
1 a) P, |3 ]  ?8 s' x. r$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 y7 w# c4 b4 D( U8 Q$ A$ P* |
* e( C7 y& L3 ^m_szName = '{$name}'");
& ?6 W  R  ]1 v8 V, U6 k6 Y$ O* lwhile ($row = mssql_fetch_object($find)){
" g: u3 A4 a/ L" o7 X. b; ~echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
" u$ N6 e" o- P& v7 n. |& G: ]$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

+ ^% V5 z% T2 d! h0 A& b[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
1 M# f- i1 w0 [0 g% [+ O" T) e
* Y( |. K' U! }2 A8 U' U[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
0 a1 w2 Y. \) y7 Q# u7 C
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}
3 Y0 [5 \7 Q0 p
& ^' s( A! f5 F( n# i. t' m}

+ F9 Z4 v4 s% e1 [& g}

$ d( s7 X# W) q/ H" l$InitForm = InitForm();
4 V$ e1 d9 l! l7 r- {$ P  ~, Q6 M$Listener = PostListener();

?>
0 P( m0 x' q( o3 D- n
! ^  s# |7 C6 j1 d, A' P
2 z' s( s/ z) p" r+ L- _5 M! ^* d% `
0 K' [: L) V+ u6 t% j
* }+ g" K2 G& `3 U5 Z7 D