物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
+ u/ j  _8 e1 l0 x+ g
Failed.');
}
+ i6 ~6 ]  k+ C% V  JConnect();
0 o. C7 K: s0 w$ E
function InitForm(){
4 j0 n* v" m; t- H2 s//layout for the form
6 E2 e# p& _) q) B- ^echo "<strong>Send Items.</strong>
5 g% U: ]3 q; i9 c7 m6 Y<form name='select' method='post'>
<lable>Character Name</lable><br/>
* q7 m  Q' U- o0 s$ `$ j9 Y5 y( @/ G<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
: k. o+ n0 v, g4 H  U. i8 P5 I<input type='text' name='item_name'/><br/>
<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.)
& D  b# q" c& Z  o& W" y: D+ f
</lable><br/>
<input type='text' name='item_element'/><br/>
5 Z& G* Y: f( E" b9 g) c<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
# |+ W7 N3 `8 ^<input type='text' name='item_pierce'/><br/>
: k, m2 I; t/ v4 L0 T<input type='submit'/>
</form>";
/ y4 }7 J9 _6 O' i}
( C% }. u% l! U( A* ~9 M& m
* u" U$ _2 l5 c3 {$ u, rfunction PostListener (){
7 H7 H; c" `# f- @, h4 ?//Add more post variables if needed and add them to initform() function aswell
  _2 a" O! C: L
/ ~- w# T' c" g; a################################
##### Connection and Post ######
################################
4 l4 N7 H& p+ f+ s( D3 n) s0 J( T$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
% [; s) S! v3 W7 d7 J" E% L$ t$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
; ?- \2 D/ K# h" c. O$ItemElement = @$_POST['item_element'];
* L: J0 S; M4 C  O" U4 m, S$ElementUpgrade = @$_POST['element_upgrade'];
6 }3 y4 b* z. f+ S0 h& V' ~7 u$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value
/ t2 J7 t+ ]0 e
) r: m- m" i, A% qif (!empty($_POST['char'])){
, u. E1 c* s% d& p* s9 y$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 m- N! z! C1 h5 D4 U
m_szName = '{$name}'");
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],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
0 J+ S5 {( x- u9 q9 p
: B* G7 w0 \$ j' T[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
6 o! g5 O  @/ p
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}
& F" \2 I8 n( h: b- a
}
: w. T3 m" J* j1 }6 X1 S
, \) J1 Q3 Y5 K0 T  F0 r}
5 j1 o* H1 K! S+ u+ o
- h  Q( n- {: P0 q$InitForm = InitForm();
6 E- F8 t7 B( W3 C3 {% V. Q$Listener = PostListener();

9 u% ~# E1 @- e6 T# I) f?>
) I/ _. C) X3 I/ V
) b, ]& c5 V1 A) i* J6 I
8 ^0 x/ j- |) N" G
1 [! G! W; a' l3 n8 _; ~
" c) t! c5 X. f. f  P# x0 _3 a