物品发送脚本

admin

<?php
* s2 M* O* q# @! X3 H4 ofunction Connect () {
+ X, z" s5 s$ z- T' X) nmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
6 b2 p; \$ d. C* r5 O. `1 c
- y/ J, f0 x4 v7 z/ G1 v0 |1 CFailed.');
}
4 \$ a, B, U5 f6 Z. e, HConnect();
/ ^: t6 R9 D# u  }4 n
function InitForm(){
% g7 S5 k- o5 x: n& w7 ^5 H5 T//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
# @/ {6 ^* J4 S  q* o4 E' @- z& @<lable>Character Name</lable><br/>
  m' ?" G5 I0 F) Y9 O" J6 h<input type='text' name='char'/><br/>
3 B; {2 \) M7 M6 a* ]( X& A<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
2 P4 \5 S; W. D/ z# u, a" r<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
- [2 m- J& M' D  w  g/ d+ w<lable>Item Upgrade Amount</lable><br/>
/ T- C8 ]5 b  F* `<input type='text' name='item_upgrade'/><br/>
( h* H0 a' ^  U' H4 B<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
: w2 b& c$ y* m( N& w
</lable><br/>
<input type='text' name='item_element'/><br/>
8 u- E: O% X  n' l* ?0 w$ x<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
, D8 D. h- T7 j$ w- [1 i<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

function PostListener (){
! z7 s. _+ }3 i# l; \5 ]/ i; o//Add more post variables if needed and add them to initform() function aswell

################################
, h; x" [- U/ H# q: l% D7 N# ^##### Connection and Post ######
################################
$ M) J8 Y' {5 E* h3 Y$name = @$_POST['char'];
& ], x5 E! d0 t$ r: o" R! a5 \' D$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
5 I% x' V5 V5 V) D' }$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
; W- f! ?) r( j2 X* M0 W9 l$ElementUpgrade = @$_POST['element_upgrade'];
/ M2 I$ t, M& x9 Q- g$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value

if (!empty($_POST['char'])){
! \# d* Y9 z' `$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 d- C/ z: n! V
% q' [5 N0 b* Mm_szName = '{$name}'");
+ W' d. Q" o4 V9 u2 s6 V: }" Gwhile ($row = mssql_fetch_object($find)){
; Z0 Z- M6 d; M, _+ X% decho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
6 Q& a1 `% W4 O. j+ z: b# V
' B/ a5 M, U5 G[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
( G! s/ f/ S! O8 A
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
2 r7 e5 j2 j. u
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
2 Z7 H$ j# ~0 N2 p) k, G
'{$ElementUpgrade}', '{$ItemPierce}');");
0 C9 x& m8 h9 }& d9 O}

}
% }. }0 F7 `3 l& d( y
}

$InitForm = InitForm();
$Listener = PostListener();

?>
! z3 D( f$ L7 l, z5 e" K  j


+ u3 A6 S+ Y  Y) @: r