物品发送脚本

admin

<?php
9 C1 d# q; M0 K, u8 r& a9 dfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
( |& A1 N3 S1 o+ r) e8 f- o}
/ S+ q5 Z% S3 P0 e9 b/ r% }+ {( ~Connect();
1 [6 z1 r8 n1 M. O- F
function InitForm(){
! h; {+ D( r7 I//layout for the form
" L9 q" Y, [( _, _0 [+ t) i5 mecho "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
) @& E, v  x8 }' e' U* B<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
0 w  {! `8 @6 o; B* m+ Q; U<input type='text' name='item_name'/><br/>
! a4 L, o9 h+ `0 `<lable>Item Amount</lable><br/>
: H, ?  H- V4 G" L! {<input type='text' name='item_amount'/><br/>
7 P; ~1 l' C0 P( }. o+ p<lable>Item Upgrade Amount</lable><br/>
% [2 c- e! T: @$ G<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
) H2 i! d6 D: a0 R5 r- w
- Q6 F6 m1 H' h</lable><br/>
/ i( a( d( K$ J% H. P2 V% y$ t<input type='text' name='item_element'/><br/>
3 V+ N, Y: ]* I3 \! r& j+ H<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
( V2 ^3 o; v2 x' E* W! B* _<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

5 P* b+ T, h  p( T' H: t( Efunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell
% O: T2 S, z7 |! B
################################
##### Connection and Post ######
################################
2 q6 ]7 q4 R0 o  b! `* v2 d0 j$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
4 R: \& I1 Z; s: X& @$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
; o4 H( y! j2 t2 f8 X6 j/ M  n$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
) q3 o: M+ S& @" M
2 t# o. H0 A6 V4 U+ e. I//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

  I9 f0 k3 j' m5 m: c* j0 ~: im_szName = '{$name}'");
while ($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],

6 j( W, J3 v- K0 v. ]- K' Y0 F$ |8 Y[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
! z5 R1 \; @! X# E& F9 X2 P
, b  B# E; T# O, c% }7 f[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
1 R' b9 t: M( P* F3 O5 R
7 V! x* ?1 Z# n7 @) ^& O" L7 Y# @'{$ElementUpgrade}', '{$ItemPierce}');");
' }- ]1 T1 }  F1 H}
- C2 c% X) h9 p5 `4 |
+ V. S' `( y: z6 O4 Y}

8 g' m$ t. H- ~$ P6 {7 n2 r/ [}
, H, R) H2 G8 F$ O0 r" f9 e- A
$InitForm = InitForm();
$Listener = PostListener();

?>
) o) f3 W! S4 }# S+ U
2 |) g" x( n# M8 D$ }


3 x0 b  p1 V7 M. U2 F' i! _' ?+ a