物品发送脚本

admin

<?php
function Connect () {
, m1 ^0 o! l( j% f- k$ V# q) ]mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

+ p/ R; H; j) QFailed.');
}
Connect();

$ a% ?4 n* k3 `7 Jfunction InitForm(){
//layout for the form
& O$ C) `; w: |: n  Jecho "<strong>Send Items.</strong>
<form name='select' method='post'>
% y: g; i2 O  \7 X* y5 L; d<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
1 v  G( [4 E! c5 n% Y2 Y. {: R: R<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
# a7 Y, J7 L0 O* h! F6 w2 b7 C<input type='text' name='item_name'/><br/>
: A6 t2 ~" z7 E<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
* Q5 F6 |; I9 u( k0 p<lable>Item Upgrade Amount</lable><br/>
, \& s3 H0 K' x<input type='text' name='item_upgrade'/><br/>
% N: |: c; ?% Y* m+ W0 J<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
8 Q2 ?* P, t1 a( W! D3 x
# L' P7 O; H1 D</lable><br/>
3 L3 z, K, T2 F$ G. J7 x<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/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
* v2 v! D! M9 ]! u( o+ h
6 \6 c, O- d" a5 F################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
4 b2 R" O! U7 N+ c% v# _6 G, S6 X$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
" X& F: p3 d' L& d$ F$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
3 F+ o9 y/ [. w. }- w0 [$ElementUpgrade = @$_POST['element_upgrade'];
, F0 x/ n. _1 J7 ]- u* p( H$ItemPierce = @$_POST['item_pierce'];
################################
7 g9 V3 {+ f* T! S, l
//Check both variables for empty value
- ]/ p5 F- F4 L7 _
- u; T9 ~6 d' }. A. ]+ N; _if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
5 p' Q/ O4 g$ B. T5 I
m_szName = '{$name}'");
$ `( ?5 u7 J4 X* Lwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
( U- R* s( j" B; m7 _. m$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

, s/ W& e( s8 }0 O/ L5 S7 [" `4 `[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
% i5 P& h/ w' _. h0 B7 s- i0 ]0 {. x
7 |8 x6 K: l# W1 J[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

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

'{$ElementUpgrade}', '{$ItemPierce}');");
8 t% |, d/ E& y5 T* j* e" \}
$ K* E' b1 |5 c* I; T. }
}

- a9 a1 x2 [; E}
8 \5 M4 s3 i7 ~
: b" y, q* M" m% W$InitForm = InitForm();
$Listener = PostListener();

?>

1 l  i  y: b7 t- Y; L6 \
9 ^  }% f4 s1 Q: ^8 I  {
) R* y/ `% Y. c2 }( Y