物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

) Y# {3 t& ]' g2 T9 w7 {' ZFailed.');
}
7 U2 F& |4 ?+ x: d; a0 rConnect();
0 h8 i8 m* [# J3 ^! r; u
$ X% r5 K" Z7 Ofunction InitForm(){
: K! ]' ], N6 @! @/ _//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
0 `" Y& Y" {" T6 q+ Z( m/ p<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
& w  m) _4 U3 ]* n- O6 L  o' {<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/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; k& i$ }0 A* n! [5 N# u! u" m! j$ Z
</lable><br/>
+ z( d; Y2 G5 {8 a# z' K: F<input type='text' name='item_element'/><br/>
8 A2 u& Y; _7 z9 c  a<lable>Element Upgrade Amount</lable><br/>
# j7 S1 Y5 K% F/ Q: x<input type='text' name='element_upgrade'/><br/>
. a9 h8 N) x" t( ~% ]; [<lable>Pierced Amount</lable><br/>
4 u/ P; U$ E7 [2 c4 U<input type='text' name='item_pierce'/><br/>
8 K4 U, |! h9 w4 M2 d- x3 J<input type='submit'/>
</form>";
* `* e! c: }# h9 P) e; ]2 f}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
  F) g+ Y+ E- o! X) x/ {; v2 Y; X
  Y& N( i5 b2 v$ `* E) m0 A( [# k################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
" @: i# i3 l5 X- b$ItemAmount = @$_POST['item_amount'];
" C) F) a7 J# ~$ _$ItemId = @$_POST['item_id'];
/ v: K% h! {5 T8 _! g' s. O4 |$ItemUpgrade = @$_POST['item_upgrade'];
' Q7 y  ]  c1 E: y; y5 p$ItemElement = @$_POST['item_element'];
/ l  W* c6 U& W0 M5 y! |1 C$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
, d; ^7 \1 i  K0 x" i% ~################################
5 R/ q. Y2 }: G8 b2 T
8 r, x, ?# S2 J8 F: Q9 @2 L//Check both variables for empty value
! i( G) o7 i4 c; v# a4 Z3 t
if (!empty($_POST['char'])){
2 m$ I8 F. M3 q+ ~$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
4 H/ d4 ]$ f5 T+ Z7 [% {
" `! S6 B0 A- N' S* Um_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],
8 y$ W5 f7 `; c4 ~
, o' K( F( M+ g3 y& P0 Q8 V[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
+ _" R* N' W) O+ B
% s# @0 M; @. V( M9 f8 e' O. f[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
, u% r% N7 j6 B7 H& g
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}
; A7 K2 f- |) m
}
; }% E8 ?' A$ U- t$ |
}
' c" b) ?# o3 w
$InitForm = InitForm();
0 e' m; o1 R; y6 o! l6 S8 A  c$Listener = PostListener();
4 p; m( @% [" I4 x4 t
; X+ ]; x6 l: Z5 P% _?>
3 `, M9 j5 L% d$ b6 I7 I
+ D6 L# W8 ]) \* z0 |+ `! m7 a* E