物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
( f& C  K. B/ \& P0 s/ Z$ N
Failed.');
}
- T. s3 b# y+ V6 B/ z# w, kConnect();
; D0 y8 ]- @$ \, X$ [. s
* P  r6 D; Y  c0 vfunction InitForm(){
# O* l# S$ u% X+ w+ T" s) a4 L//layout for the form
6 m: ~& D, j, y/ V" Yecho "<strong>Send Items.</strong>
) Y, \! M. z. P) ]7 _<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
% }0 S/ f1 k) n3 T$ c  ?% Y<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
' s5 r* N4 K' Q: A$ I" |4 L% z, {<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
0 s+ ~% G2 P& ]0 d9 q$ {$ h, P/ o<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
, a0 w1 z4 t3 i& b0 @; M! d2 _9 H
3 y1 a5 u, P5 [) y, J, E</lable><br/>
<input type='text' name='item_element'/><br/>
. l4 L! G+ r& B; q; [/ u( e<lable>Element Upgrade Amount</lable><br/>
+ f6 u9 T" Y1 I) T+ p3 P$ a<input type='text' name='element_upgrade'/><br/>
! W( s7 i0 e2 j( Q$ }<lable>Pierced Amount</lable><br/>
) L' j3 d/ B) ]' q) u<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
, u# m5 q4 n: U1 I1 l9 ^+ i4 {# m</form>";
}

function PostListener (){
2 Q4 O; g" R2 `' Q4 U3 g//Add more post variables if needed and add them to initform() function aswell
1 X+ K3 K  X0 n8 \  U1 {# F
################################
: a- J% L0 P3 U* U' P. O##### Connection and Post ######
$ i$ U4 v1 _. n9 i6 |7 {4 \################################
% b7 |9 m* |/ x4 w2 {  U) B$name = @$_POST['char'];
% f* d/ f* [/ o) {; H$ItemName = @$_POST['item_name'];
8 L$ `2 \0 {7 k1 C  O) o$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ H( w' X4 E! Q  ~; B5 x$ItemElement = @$_POST['item_element'];
. G' ?# k, O5 i" P: Z4 U5 b  P$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
0 |$ q6 u8 h  N; i. t7 n
+ c3 Q5 a* e' B) k) B//Check both variables for empty value
1 P7 X& o" `$ X) @: a2 A8 h
if (!empty($_POST['char'])){
7 h- }5 h+ ?( a" h$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

  [6 `4 R/ f# y! @6 Pm_szName = '{$name}'");
$ E9 w- y0 j; U; \/ i7 iwhile ($row = mssql_fetch_object($find)){
' x, |! j, R2 Kecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ W8 e; j; X5 C" w0 X- x$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
, B" m7 O8 S; p! ]
9 }: o" f6 s4 ][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}',
! L* B7 s' n" M
'{$ElementUpgrade}', '{$ItemPierce}');");
: l1 ]& ]- K" K8 J/ e}
! ~& C9 o9 p3 A! B
% E' Y7 {) Q6 w1 T}
( b5 ?9 t1 s; Y0 p+ z1 s/ Z  T
}

0 ?- g& @2 U( E8 h$InitForm = InitForm();
$Listener = PostListener();
( }8 `7 X/ B1 k& Q- S* ^
?>