物品发送脚本

admin

<?php
function Connect () {
8 ^( l! n0 w, ~# f( Z2 l- fmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
Connect();
2 W0 ?  M  H- n5 F# M
function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
: N( m+ Z8 `/ I" \- c/ S) |' V2 v' }<form name='select' method='post'>
9 _' l1 B" ]- J  }" [- Z/ D4 O<lable>Character Name</lable><br/>
<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/>
; Y& X. x1 @7 o: H, _1 B1 n<lable>Item Amount</lable><br/>
5 S6 F6 E: X. `! O! ?6 F! \5 o<input type='text' name='item_amount'/><br/>
- A$ S5 m3 i+ G% h2 t1 l7 W<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
5 l; X4 k! O. S' t) t: F9 K$ Z<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
, U# n, b( M& c& s2 p  c
2 J0 `* Q7 C' G" W" o</lable><br/>
5 z5 ^% T& k' \( w8 ^  ]0 c1 ~; ?+ l<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
8 }0 U+ e# v( g5 L/ r. b</form>";
! [4 N' y. T) L9 Q}

8 K5 u' W6 F2 B4 Pfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
$ t6 {! |  }& x1 Q# U##### Connection and Post ######
################################
+ i, |. B; P1 D4 R) K1 X$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
3 d" v0 P& m9 X# v4 a+ ^* b$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ `; V5 B8 ]; d$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
4 k; {3 g2 e+ Y0 z" W  h8 r$ItemPierce = @$_POST['item_pierce'];
+ z6 T- `! X6 \################################

6 O0 i6 b" `8 T//Check both variables for empty value

3 @6 f  Y7 i8 m" W5 aif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
& S0 t% C. U2 v' Y3 ^
8 w2 k0 y8 R' e" P' x* Sm_szName = '{$name}'");
  W" F9 ^! X/ Kwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

/ t3 }/ s5 I$ |6 |6 O: }[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
6 _5 c& N: K8 \# T
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
2 \3 i0 e" I8 w
+ B& w( i9 V0 v' J' Y+ eN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

8 n' d$ x0 J2 l1 m& x'{$ElementUpgrade}', '{$ItemPierce}');");
}
/ t' `1 S) H( B5 C- T7 t
5 W- N% k: P( s- ^' z3 A}
3 h% s7 |+ x! N7 \
- D0 }# M3 g7 T: R$ f}

4 W$ |( u$ p4 b* `' `$InitForm = InitForm();
" Z" d: a/ F; T  Q! D$Listener = PostListener();

+ }! c( Q+ ^! u5 r/ P?>


+ ?6 e- E( r  m2 o" Q& ]