物品发送脚本

admin

<?php
function Connect () {
3 `3 l! b. S+ [1 A4 Q8 S% y2 |8 Xmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

% Z/ x& k) b" I  b0 d, ]$ PFailed.');
}
2 `: W6 Y0 f5 x1 yConnect();

5 p: V" B2 N8 z& vfunction InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
: i0 b& |; u) \1 v<form name='select' method='post'>
: J# Q  x8 |3 F) m<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
+ F* \; w! y/ K! b) y9 J<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
$ _% U$ \) W7 L8 A8 s, L9 `% n# \+ Y<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
' ^+ J  c, Q; B0 z9 L' k<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
/ n7 @$ U# l! s5 r1 O% j<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
; B/ t; S( b* e4 j1 M4 c<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
! Y0 \# C$ q/ a/ _" z' ?* J<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
5 K4 w0 r& U- i4 x, q, L  Z8 I}

function PostListener (){
, q4 f. n: f0 z, i//Add more post variables if needed and add them to initform() function aswell
8 f. F$ L$ d2 t( u: O% r$ _
################################
8 E* P; F& V& l* M##### Connection and Post ######
+ ]% ]% X! w1 t$ I) s9 k) H################################
" g& ], D# u# M2 k1 F6 {( z$name = @$_POST['char'];
) K& D1 Y4 X8 ]& G$ItemName = @$_POST['item_name'];
+ S8 {- u) x' K1 L! ~7 i" s1 c' b$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ F0 E# `6 s# ^9 ^+ W- [$ItemUpgrade = @$_POST['item_upgrade'];
3 k0 h" C' \* N3 H  O$ @$ItemElement = @$_POST['item_element'];
) T& y0 z7 U" p* n7 Q, Y$ElementUpgrade = @$_POST['element_upgrade'];
% `' Z2 S. C: S2 k) ?* V$ItemPierce = @$_POST['item_pierce'];
- A+ w" _, K! _################################
/ G: H& d7 I( q& g
//Check both variables for empty value

# d7 b, o6 |' x8 G9 f4 lif (!empty($_POST['char'])){
* a& j& z6 a& a- ^- C; p5 ]& q$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
: N- ]6 T% S/ N  x9 decho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
7 ?3 j$ h/ `# H
  E& r+ ?$ W7 t, R9 r4 z" H! A[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
/ E8 v; n8 W8 I$ Y; v
2 W5 k/ t/ j8 a* H+ x* d8 E[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

! d/ ~4 b% h7 z8 O, G* j& _- i! ^N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

# R5 S7 b1 y) Z4 c$ \1 X, v& \- P; o'{$ElementUpgrade}', '{$ItemPierce}');");
, o& Q; ~$ ~  h. D/ T  k}

( F' o9 z7 Y# ^9 t4 _" Q% G}
. Y& B8 P, [: v" Z$ |8 T
}
! c% t. b4 z% _* [
$InitForm = InitForm();
$Listener = PostListener();

# X- B) }; Z- M5 `7 p. Y?>
+ q  r6 K# |' a; x/ \
9 n$ p; I1 K; P5 F8 _0 u

) n# D1 u# c2 [* |  ?
, d& B$ S+ |& z( \