物品发送脚本

admin

<?php
: |! V# g# D# F4 s2 n& {9 q' m- Zfunction Connect () {
# X) `8 R0 a" E. h  ~" [mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
' C! i" a( B  S7 b! l4 p: [
) Q) z$ M. [6 i# P- s, B2 j  |Failed.');
  l/ q6 h0 D9 j}
7 k& I3 Z' L# ]* ^Connect();

' P* }$ t' m! g$ w& hfunction InitForm(){
6 E- D9 A/ P8 q+ ?4 s7 @//layout for the form
echo "<strong>Send Items.</strong>
+ D2 Q3 Z* p* K  Z! b4 P  _2 @, E<form name='select' method='post'>
) J$ r6 R4 R9 R  P3 H0 Q/ d<lable>Character Name</lable><br/>
5 \3 i! X) p6 V0 ]3 j<input type='text' name='char'/><br/>
% F4 m3 E  C7 W/ \3 I<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
9 u$ y1 e$ c# k; N<lable>Item Amount</lable><br/>
( M" l) k* P* s6 p7 \, J3 y$ v<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
$ C% a2 B. B  ?* D0 i. ^* \+ T<input type='text' name='item_upgrade'/><br/>
' e% D* d/ {' M- B+ i<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
& u' i+ }+ r9 l2 p
' K3 \( \2 Y& d4 s( p/ {* T</lable><br/>
' a5 P$ [$ c; I0 n0 Z8 t" @<input type='text' name='item_element'/><br/>
" O) y$ r9 t5 D" U- B8 D<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/>
7 ~# s# Z6 n- D& S  X<input type='submit'/>
</form>";
}

: b( b0 D' Q/ C2 M' ufunction PostListener (){
( R/ b- ]' @: ^0 O) {2 z& p//Add more post variables if needed and add them to initform() function aswell
2 F2 K4 V5 X# h4 M: D0 G
0 W1 O( v1 m# E6 T' |1 N8 X) V$ ^################################
9 @# L7 f0 A9 ~- Q- u  F  ]+ b##### Connection and Post ######
8 X% B. x2 x, c################################
$name = @$_POST['char'];
) |2 M8 x& C: a# q& ~$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
6 m( V3 ~1 N, N/ C% _$ElementUpgrade = @$_POST['element_upgrade'];
$ d2 n) g. l) a$ K) C  G' I$ItemPierce = @$_POST['item_pierce'];
. Q# Z4 }. ~$ Z5 ^( B9 f+ B. r, Z" ~################################
$ T0 l+ ]! t8 Z( z1 e2 r2 O$ r
//Check both variables for empty value
% F0 X# N% ~" j$ l! h7 K2 R
" q! ?1 w  J! v6 I. \. V6 s% z3 Qif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
/ E$ ?( y7 e) M4 ~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],
& K2 I# \  B) c+ n* l8 X* @8 n
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 R, H  W# R' s- I2 ?" L/ n
'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

% K+ X) Z; H2 e}

$InitForm = InitForm();
$Listener = PostListener();

1 e' z+ Z$ n* D& y, Z: G, C- S- C?>
" c# _% p+ R" G/ t4 o& |8 f
) Z' [; m3 Y3 C$ l
) L3 ^3 p9 J0 Z8 i1 H
# f9 J7 N/ i. Y% f1 v9 d