物品发送脚本

admin

<?php
3 D. Q/ K1 z; I$ \  Lfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
* M; [  d8 ?$ c3 D}
Connect();
: [9 \: o8 U+ z) {
function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
: i  j; c5 Z, S. ?1 x<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/>
' }) d" h0 X& M<input type='text' name='item_name'/><br/>
. e- p1 m5 p( Q0 U, v<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
! M5 j% }' n  R0 w2 Q  I<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
$ g- C" W( q/ k! m8 y' M<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
- R2 ^9 W4 G1 U. @. o
</lable><br/>
6 t2 d0 {; P; Q3 I* `<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
, K4 ?! J( i& k$ h$ F- h- T<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
* R% E& U  Z% T% t- Z<input type='text' name='item_pierce'/><br/>
; V/ y( p+ N. g) B7 H3 O<input type='submit'/>
</form>";
}
3 w# q! X0 r: Z5 R% |1 O0 z/ a
* k) H+ O5 R; P! }% @. X) P) f8 Efunction PostListener (){
3 f$ F4 N' w' d' p# V# L+ \& l  R//Add more post variables if needed and add them to initform() function aswell
! h2 i- I9 K* ~
################################
##### Connection and Post ######
. H* n/ t. n* U& o. c################################
$name = @$_POST['char'];
7 X1 v7 ~! V2 B) Y* y3 F! m$ItemName = @$_POST['item_name'];
" h" c' _* A" j: z- |0 O/ M$ItemAmount = @$_POST['item_amount'];
* k! l1 u1 u% S& X4 {$ a$ItemId = @$_POST['item_id'];
8 k. M$ U$ W. C% ^/ }# w( H$ItemUpgrade = @$_POST['item_upgrade'];
' H: w- z; B1 l) @( X0 c* `$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
: p4 n  F) D$ |+ g$ItemPierce = @$_POST['item_pierce'];
2 m$ U. g; j( P- g/ w) |################################
- Z% H% _# I  [" ?- S& v
: ~# K  X. O4 ~7 [//Check both variables for empty value
  [; V, ?' A$ ?+ n3 ?
if (!empty($_POST['char'])){
* j5 k/ W; D! H! \% }$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 Q/ T( P/ Y5 B7 _# K
m_szName = '{$name}'");
2 J7 X3 E  N2 O6 J/ M4 \7 j9 hwhile ($row = mssql_fetch_object($find)){
) H& A( H- }9 W, Necho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
* F  X: F6 p0 i' e8 V% [4 v! n$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
& ]2 Q3 a  [" v7 u7 q9 z2 F" P9 K
  ~" N, |5 A! ]- I- P[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
7 s) u8 }7 O" x: ^$ f/ D, a' L6 O& g
& L" n; v! T4 u- @9 `'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

/ i' I; r- [6 r}

( B- B7 e  l: V2 O$InitForm = InitForm();
$Listener = PostListener();

?>

. Y$ n( L) Z- X) M6 h

& F9 ]# C+ W/ y