物品发送脚本

admin

<?php
; Z  {6 R) Q; g0 K0 K6 K8 ofunction Connect () {
  ?5 V  R7 J2 V6 X$ C1 O5 s. amssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
5 j7 s/ C3 b# U2 d- f, B}
Connect();
& Q9 L+ ?+ n- M0 r
( _( `& I; Z4 Dfunction InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
) D3 ]/ x9 D& t% v4 |<lable>Character Name</lable><br/>
0 c! c. Z3 S' Y3 T; K7 V  G<input type='text' name='char'/><br/>
% C8 c* B, B  L<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
1 D/ K1 H7 [0 a# |/ E) D, _5 Q& d3 `<input type='text' name='item_name'/><br/>
- ~$ B: f. a" o<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
8 m) G; m7 l. G& g<lable>Item Upgrade Amount</lable><br/>
$ A2 c% S6 J" M) f2 f$ i' X- L<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
0 m! O0 i" Q4 }
</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
3 t. o& U: N: |! W- c( [<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
8 U# s7 }/ p$ F! {" u+ x* L<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
7 M/ ?! s9 ~2 A6 }</form>";
}
! @0 I  e: D6 |$ U, B
function PostListener (){
, L: g: W- j% [9 z/ f& C4 j//Add more post variables if needed and add them to initform() function aswell

+ k; E! y1 M0 M$ A; H0 F################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
  t$ \+ Q1 Q8 ?$ c$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
% [& Q2 @* _9 Y# D$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
) s) D" e8 }8 ~- e6 [$ItemPierce = @$_POST['item_pierce'];
) c7 a3 Y$ h7 C4 B################################

4 R7 P% ]$ C1 V. n% s, B//Check both variables for empty value

1 X- S8 p2 g" }  Q! Tif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
) }( f: n  Y( M/ m/ s
m_szName = '{$name}'");
( L2 k3 ^' }2 P- t! w+ k( D; O& e( iwhile ($row = mssql_fetch_object($find)){
$ g$ u1 G' J$ G( g/ E" Mecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
. P, r& y' o) t% E1 Z, m0 P4 f$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
8 t) U; }7 O9 F& b. k. E9 l
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
2 {0 U& z& I: D7 H+ y. V
! c5 Z' X+ M/ Y, uN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
; z) |; U: F, a}

}
' A# n4 E4 b4 v# x. \
, l0 o1 m! `2 ?" n2 q  H% k}
. G1 w( v4 |# l0 K! O: S1 Q
  x5 s3 C$ c! C( \" E8 X$InitForm = InitForm();
$Listener = PostListener();

?>
5 ~$ }/ k" N4 X. ~8 o% F
* g: y* x5 N3 o/ W! ~0 F5 p