物品发送脚本

admin

<?php
function Connect () {
5 U' D" L0 z& c8 {, N0 R! }mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
3 |2 m( e5 R! P: DConnect();

function InitForm(){
, o  V* M5 {9 D! G2 y! ~4 f. I* S//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
" j; w4 A' S! p  r5 z* N, ]3 ~<lable>Character Name</lable><br/>
' G6 w) |% F2 q8 u<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
. ~: q1 g, q4 r4 S) O6 @<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
4 }2 c" O. `( e7 }& u% T<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; f+ z% ?7 x3 U; g9 E( U
1 D6 w2 R9 F( o2 p& `; Q% P</lable><br/>
5 J" |+ l. A! z" A3 A7 ]<input type='text' name='item_element'/><br/>
, a( b( P2 A+ d<lable>Element Upgrade Amount</lable><br/>
* |0 ^5 F$ c0 I<input type='text' name='element_upgrade'/><br/>
9 u( _; T. L; V6 N8 L' U: I<lable>Pierced Amount</lable><br/>
7 o4 z$ {" g2 f2 d- \2 L<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
, N' m5 c/ T! U; l7 R}
* K6 X( f" w: i% |5 k
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
4 @. o% D$ p6 N  l  x! M; ^( K. j5 s
! _  y4 `$ p# o- u' u, k################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
# C; ~5 O, w5 ]' m7 y* r8 G7 s$ItemAmount = @$_POST['item_amount'];
4 w) `/ q$ }2 M# s/ F$ \% a  j3 {! j/ h$ItemId = @$_POST['item_id'];
. T6 m3 Z" J! F/ e$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
: }1 b( s3 D0 L$ItemPierce = @$_POST['item_pierce'];
################################
2 V0 J0 V8 N1 r2 D  u
0 {; T3 h' G- m. D* s( k* H//Check both variables for empty value

1 t7 m, W. Z" O" n- ]2 dif (!empty($_POST['char'])){
) w) U. {; c( W! \5 a& s' a( x$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
7 g: V0 H9 Q+ ?7 o" U# F) c4 R; K
  @! s! O1 o+ G! l/ lm_szName = '{$name}'");
: }) o4 {. t6 _& c' Y2 e: T( v  qwhile ($row = mssql_fetch_object($find)){
6 h& D# g" a8 p/ i" y% e7 x2 mecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
- `; K, `6 n' {( u$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
/ p1 B: k  B0 V+ M1 h! i
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

/ G: ^9 k) m+ Y% M. H. U  v: V[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

! s! X. b/ Q" \7 Z+ ^N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
% _5 M# b/ y  ]}
6 x0 q) F2 F  T3 a
}

}

: m6 _% G2 m2 R. q- L2 `$InitForm = InitForm();
( M8 x! l1 k5 ]/ c8 b$Listener = PostListener();

?>

+ o9 ^  R, r$ c
/ C4 n) [- ~& t+ O  S3 w8 X