物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
: o3 o6 X+ ^: X) w: ?/ j
Failed.');
* q- l7 w  o' ~) e2 T! Z+ m& [}
Connect();
" T4 v: i; W& |* F! w
- `4 G' C' J9 I1 W# h' p0 B* Hfunction InitForm(){
8 I1 P8 Q! w% a( `//layout for the form
echo "<strong>Send Items.</strong>
( A. Y4 z* i8 Y9 b' D, l<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
$ Y: t# ^& F* H7 O8 U9 r<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
8 a  ^4 c8 u/ j% s& X$ i# {5 H<input type='text' name='item_name'/><br/>
9 Y6 e  l% ?. r8 w<lable>Item Amount</lable><br/>
- ^3 ^% Q5 k$ s<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
( u: l' H/ c- x. V5 S<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
" f; n$ n4 t% z6 h$ f
6 b5 D& s' A2 n3 Q9 ?$ y( r' C</lable><br/>
( ~* f8 s- m$ H; R0 S<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'/>
</form>";
}

function PostListener (){
5 R0 L0 o) Q' C0 c//Add more post variables if needed and add them to initform() function aswell
5 P. d3 k" b! k
( ^) M) I9 `% E8 J% n% b/ I, E################################
##### Connection and Post ######
( N* s4 R; {- K9 f- i$ _8 B################################
2 @) S5 V$ L8 y. S, \/ M$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
3 j2 P8 m; x* ~$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
+ G% ^; ?7 B0 s8 J6 S- q0 p* H" Y$ItemElement = @$_POST['item_element'];
( l2 Y: f" p' r# h. x2 G$ElementUpgrade = @$_POST['element_upgrade'];
. K6 P1 R9 {7 X4 u3 b5 j4 L$ItemPierce = @$_POST['item_pierce'];
+ \; @+ z# ~" Y+ A; `8 K################################
4 ~& x; m; e- B* n
% i0 ]7 o/ r' n//Check both variables for empty value

+ d( r& K' D- Y% o5 H4 C: Eif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
. E. z8 v" V( v0 O, zwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
2 b. H. I6 B+ [/ X$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

) T2 K# r, ~8 ?% W7 n[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

- S+ q) s' i4 y* _. n[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

4 C: C/ l9 X# E+ bN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
* g3 k- T; A) z  n
7 R0 w5 X% p+ C/ I5 k: {'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

}

& e# c8 [9 R/ K. B6 ~$InitForm = InitForm();
( T+ r) E) e; m! b$Listener = PostListener();
6 O' J! r! w7 I$ [# Y! b" \
0 I/ l8 x. x) |) X?>
, [* D( Y$ M6 b, n$ T3 L" \
, E$ P2 v0 d0 O% ?3 ^" i+ H
8 W5 V; M* k) l8 h; K* V0 }
$ W/ p1 b# N4 D0 t# x; g- t5 i