物品发送脚本

admin

<?php
& l) ~; x( {& f& h# gfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
0 l( f/ O: ^: F: Q1 D. t- i' E5 Z3 e
Failed.');
+ W$ ^0 w2 p5 }" _}
Connect();
8 v0 Y5 F" `9 F+ `
function InitForm(){
//layout for the form
% B4 ^) [/ v7 fecho "<strong>Send Items.</strong>
<form name='select' method='post'>
4 ^+ [( S) M  H2 b7 G<lable>Character Name</lable><br/>
2 @+ i% i8 b, n3 A; K<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/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
- _2 [2 l( _5 d, {$ M: ^<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.)
# _5 K& M& L6 r2 d
</lable><br/>
<input type='text' name='item_element'/><br/>
0 r9 v2 ~5 a/ C; ~7 e5 P) y<lable>Element Upgrade Amount</lable><br/>
! \* K5 h/ X+ i: L6 G/ ^<input type='text' name='element_upgrade'/><br/>
! q3 R# |' X* |7 E<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
' U' G1 e  q7 l5 n# Y9 A<input type='submit'/>
4 c* ^3 M. b; T6 G& N5 M</form>";
}

$ m9 @# g: A+ Z$ f9 b% R# Dfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell
& g$ h$ ?: p' w" i3 l8 \$ Y, v
3 [: ~& c8 x9 t3 b################################
+ z9 g) ~) ~, z+ a* [# [##### Connection and Post ######
################################
$name = @$_POST['char'];
) |8 _, W2 [; l" Z% \$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
/ i9 J+ ?  _- K$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
7 C9 q' Y. k5 n$ItemPierce = @$_POST['item_pierce'];
2 \; M" H; g* B################################
, q! @7 w4 R3 D- @& g6 l( A) h
//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
  U. _' O- A+ s
; y; e: J) S6 Zm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
" c% c' f6 I9 T9 hecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
7 |& M- A& y/ n$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

" c5 `3 }' r8 f4 D[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
4 T6 n; l' E; \9 g! a
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
" d+ }4 x" O. I7 Z9 M+ w
( m8 U( s' J, }7 U'{$ElementUpgrade}', '{$ItemPierce}');");
4 R' e) ]8 o! w9 P}
* ~: t6 l! O# Y/ X; o1 r
) j/ ]8 J3 ^3 T; A  C" [}

}
- e% c7 k% X- {  E6 G0 ~
$InitForm = InitForm();
( i: k; n. X# n2 d- m% j; o* [$ u  [$Listener = PostListener();
& ?* a6 W4 I) R  t  _, Q
  ^7 Z" Z5 \9 r; t: J# y' N?>

  M( V* Z) U) n5 I2 _' _! @! j
. q+ q' K8 c3 Z" f: p

& Z/ a0 J; `% `& \! o$ l