物品发送脚本

admin

<?php
function Connect () {
$ ^: J1 V/ W6 V3 {" Tmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

/ b0 k8 J7 T" N' r8 q" ZFailed.');
( I" J: v$ C' o. v6 Y}
  ]  z  Q* b+ ^2 q' J+ ]. C' AConnect();

function InitForm(){
  y& L- e6 B$ C: ^//layout for the form
echo "<strong>Send Items.</strong>
' o$ [! I1 m4 Z2 d0 Z<form name='select' method='post'>
( g2 O3 `" A2 g- u+ h# b<lable>Character Name</lable><br/>
- ~1 R) t& a) f<input type='text' name='char'/><br/>
& }9 g, C# e/ H% X1 P6 Y<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
5 z$ l0 X8 Z0 _2 Q- z<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
# s4 `% I5 z! ]<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
9 k5 q- \( t+ i<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; O! L0 T3 Y# s9 }
/ ?9 s# q8 y  I+ X  q  _</lable><br/>
& [! K, L6 ], q9 J0 g<input type='text' name='item_element'/><br/>
0 r2 [8 w" v7 f  x4 o<lable>Element Upgrade Amount</lable><br/>
+ t+ T, |# E6 \9 _1 D<input type='text' name='element_upgrade'/><br/>
; [9 n  N- l# d* A+ g' c4 `<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}
# B+ U  A7 S' F3 L, `& I8 V
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
/ v7 K. m$ f- b6 ^
5 |9 t7 O! T6 a################################
##### Connection and Post ######
################################
& {/ @: U: h! J$name = @$_POST['char'];
6 H- }7 ^  _0 c( x* W" L& @$ItemName = @$_POST['item_name'];
" k" `1 Q' }7 H' b( V% H$ItemAmount = @$_POST['item_amount'];
! D+ f1 d, X" j  x) x2 P! ^$ItemId = @$_POST['item_id'];
* j6 }! w# V0 w+ Z: ?# K0 R* ^9 Y' i$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
3 F) E) O! L( e7 i################################

6 L, i7 X# F9 L: I( g) v//Check both variables for empty value
2 ~0 F4 z( G/ S
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
! e) X. b1 Z9 v: o
m_szName = '{$name}'");
& B6 l  Q# Z4 ?5 P/ {while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
' ^. C& T2 X; c, k: P$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
, S1 G. }$ N' P/ f& g
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
# {/ Q  j5 G7 x( ^% \  f0 D# M
6 n+ A' b' J, t7 {, @[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
$ r$ p* _% z$ b" v1 o
$ ^2 ~# Z3 `, P  H) z! pN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

4 g7 a  Q" X8 \3 B, V/ n; ['{$ElementUpgrade}', '{$ItemPierce}');");
( b; v# O* F* {  h& K}
: H0 e2 {" }! y2 F6 m* c
0 O) b! L+ q7 d8 B, Z5 S  n, ^+ p}
) L/ P6 z& R+ |) L3 h# N
}

$InitForm = InitForm();
' w( T5 k" H) k0 l* F$Listener = PostListener();

?>

# h+ B1 e% R, ~9 H8 W( x5 k$ F; A