物品发送脚本

admin

<?php
1 Q9 B* {2 b5 r/ p; \# I! m/ Xfunction Connect () {
. ^+ [6 v7 D0 r, l- t1 k! fmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
) P) e' ?! Z. B; g
. w, n6 A9 m/ e+ r4 P2 ~( \Failed.');
}
Connect();
4 B5 J$ M$ |" s
* `. L+ r9 |; Kfunction InitForm(){
//layout for the form
+ {% j; |' q+ b$ _  X- ~: cecho "<strong>Send Items.</strong>
% h* R& @  n6 T0 J4 I2 b. d/ E<form name='select' method='post'>
* |: q+ L1 B: t6 I1 \5 x# Q: d<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/>
8 Q; t8 z. I5 `. z<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
  {0 x) q3 Q1 e) g<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
+ d6 e2 R) e0 I<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
<input type='text' name='item_element'/><br/>
3 p. M1 F1 t8 I! c- l: q: a0 h<lable>Element Upgrade Amount</lable><br/>
1 @" T5 }9 A( z1 \4 H" B8 T<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
0 g7 ~6 F! h- ]5 t) h" x6 V2 \<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
+ }  m0 V9 `0 H# F1 J2 A6 G}
* [( q$ v+ E) z" }
/ F7 z6 W  ?' o, w4 `+ `function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
. m8 K/ F  M% w% Z##### Connection and Post ######
################################
6 H% m3 }! O% r$name = @$_POST['char'];
5 A  ?* T1 g+ x4 K8 {$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
+ Q0 H1 i0 z# M2 l& M5 p9 V$ItemUpgrade = @$_POST['item_upgrade'];
* x( y6 G, m3 _8 F) h( ~$ E  [$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
* D. Z- Q' |, z0 z4 ]8 @' a$ItemPierce = @$_POST['item_pierce'];
  o; s4 O+ {6 m" Y: Q9 F" p: q################################

4 C; E1 l! J3 N5 z! y2 C% Z//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
# v+ u6 |- n7 f7 [" h
, V3 \; Q' o' h% d1 Um_szName = '{$name}'");
$ B# a. [( ?8 a2 e, }  Cwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
7 \7 @' b' N0 z6 h, B, B. l  P$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
  f7 W; Z) O" L9 N
/ D9 n5 A3 J4 a[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
8 y1 t! P1 h7 N6 D  W
. _1 O9 ?. c) F) R' ], j[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
8 k* i7 q+ _; S% }
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

}

1 ^4 B1 ]5 X6 q$InitForm = InitForm();
$Listener = PostListener();

?>
; k9 l* w9 w0 K# C
+ m) |, l  |2 ^2 V" D9 c5 Y" x
) _' W# w( `; A* z4 o) Q7 ~

; r4 r- f! d! z- l; @  F* k