物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
  ~$ A" }& c3 U" I! _- M
* Y: p6 P( K! Y9 b0 o! _Failed.');
9 k' @$ a! G4 q' j- `  N}
% s/ I; [! I( L. b' W1 b/ U3 UConnect();
7 O7 j; r  m4 J0 N
2 M) A5 z) w! s9 A+ Ifunction InitForm(){
1 Y) E2 x8 e! ^/ U8 v4 D* p' ?//layout for the form
echo "<strong>Send Items.</strong>
, b# y# X0 ^# g5 p$ R1 y<form name='select' method='post'>
" v3 ^: S3 P( G. t4 q4 f7 U<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
# i1 K, r+ ~" Z, h<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
- k; h; j# e" C( A( L' e: Q) V<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
- Q3 x1 X3 t* B, v! u/ v  o<input type='text' name='item_amount'/><br/>
) F, S0 Q, e* F2 e<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
. X0 S2 j; r6 i  o7 m$ y$ ]) z<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
! W! A' y# U" W# S) p! O<lable>Pierced Amount</lable><br/>
- I8 J5 C4 z% c- g, k<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

* j; O! |+ r# }function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

! q6 ^$ Q9 Y: ]. E  `' u3 \################################
, m' b4 d$ L6 ?! c7 }1 K##### Connection and Post ######
################################
$ U3 H/ |% g! B& O2 ]; y/ e  f$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
( h  @1 i  p* m8 ^9 j" A$ItemId = @$_POST['item_id'];
' A% u  O/ K( m& A3 D& F$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
3 W8 u5 l: Z+ s4 O. X  P+ p$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
* s* N' F4 N0 N4 k################################
7 V& N7 P5 s( @
//Check both variables for empty value
& C+ O4 t2 ^8 n8 y5 t
if (!empty($_POST['char'])){
5 z$ l$ [  n3 o) \+ s: B4 U$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
, Z, U3 p# t: d# \% y6 Uwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
8 U& n2 Y& l9 U5 U9 j: N- E% u$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

$ s* M9 X+ u7 [5 w! O/ `[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

* G' }; x2 R" t, B7 O  J( ~% a  E) nN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}
3 s( k0 X5 q7 g' j& X
}
" B# T2 I4 u2 ~4 _; h; m
}

. [" o7 R% ~! Z) J4 m4 }$InitForm = InitForm();
0 b/ _! w# }$ O/ g4 @7 v# a; S! O1 a$Listener = PostListener();
7 ?: s: E4 \3 @9 H* V' Q9 Q
: d: W% `. V( h3 }- S?>
9 n6 j) V3 Y' X3 J- y( J! P


4 ^4 \7 |3 s; Z4 K  r0 S' y