物品发送脚本

admin

<?php
) ~& j. g9 P4 ~function Connect () {
: A; p" W) `, g- ~0 \mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
; N* f6 e0 I. J& m) G, l' x9 R
# U% J  b. C! |1 R' Q) Q  MFailed.');
}
Connect();

function InitForm(){
- m+ b" N6 ]' S9 }//layout for the form
echo "<strong>Send Items.</strong>
' r, j" k+ Z1 s% s- N; ~) {<form name='select' method='post'>
8 {4 @' ?* ?7 X/ V7 C8 u<lable>Character Name</lable><br/>
: \/ G5 D0 ?2 V; t9 E- Z' i, @<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
" V4 D' V" I4 \# T/ [<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
, P$ F* J, C( [+ @* `0 t9 R<input type='text' name='item_amount'/><br/>
* ^7 }# Z& S- F5 ]0 c' w  O: n<lable>Item Upgrade Amount</lable><br/>
: D0 e! `# E7 `3 Q<input type='text' name='item_upgrade'/><br/>
" i+ {: ^2 ]4 l% `<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
  O8 J7 R9 c3 A5 ~0 h/ E: E- W, L2 }<lable>Pierced Amount</lable><br/>
. \& l* d( x, z) F- ^/ _<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
1 g9 ~7 h, f3 [8 O9 I3 A</form>";
}
( L' k6 J1 E, t2 x/ f0 H. A
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
6 `8 O5 i: o( a% v6 W9 y
; C- g0 x$ U  A: \, @! G################################
##### Connection and Post ######
1 J( t! {. t' A" F' F; f7 E################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
# W2 @6 Y8 F+ A8 l$ b9 F3 K$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
2 [2 U/ d9 e" d, P9 E6 g$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
! R. L6 V8 d9 b0 w' d; ?( {$ItemPierce = @$_POST['item_pierce'];
################################
  r" C. V3 j0 q: f
//Check both variables for empty value

" w% p$ C3 `/ g. p4 ?4 i8 o1 cif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
9 d, M3 H" n2 U( ^- V8 `0 X7 z
m_szName = '{$name}'");
, L+ b8 |4 B9 x- lwhile ($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],
( S5 e' w3 v3 i# ~7 O% [1 S
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
6 V1 {" W: A! \& z
" d+ i/ s$ U) v7 B5 k- k3 h  p[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
2 K+ ]! j3 o- m
+ t& E% n# H4 ]5 K# j6 Q, cN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
4 H6 Q8 g; r, h3 v, K9 O9 B
'{$ElementUpgrade}', '{$ItemPierce}');");
) X% P" ^, N8 Z}
9 l) i; e' h+ }9 h
. I3 V. M% |% V. N}
! i, n  V% t, I9 ]- g# k& b
}

) B, o7 N! [1 r2 G  O4 S$InitForm = InitForm();
$Listener = PostListener();
+ r# J% _# V2 R" G# c+ i3 ^# y
9 ^& p/ N9 f9 V+ i" ?  v( u  S?>
5 U9 }, Z: h3 C( {
0 r8 g+ I3 H8 `' `- I2 m& O
. R( P5 _: c$ n: h- A: [
! K# ~2 w, R: A7 [. Z
& ^" |$ x' Y# |6 I