物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
& E6 o7 X( \9 C  u
Failed.');
  \! ~* p* j9 ?3 i7 r}
Connect();

function InitForm(){
6 l& Q* T- \* z: U  K9 I//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
+ m' v1 R& l1 @<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/>
<lable>Item Amount</lable><br/>
! n- L- w; ?. E' W, A& W5 X6 _<input type='text' name='item_amount'/><br/>
: R; l3 o# `8 _' ~& }6 V, i<lable>Item Upgrade Amount</lable><br/>
/ B6 c9 v. `0 R1 g9 P: i<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
& h* N" M( D& _( b0 f! M* f
</lable><br/>
<input type='text' name='item_element'/><br/>
1 S) b2 O7 o& t& p, ~  n<lable>Element Upgrade Amount</lable><br/>
" B6 o. P; g! e% Q2 j1 I( S- G<input type='text' name='element_upgrade'/><br/>
- `7 {0 x9 |0 b2 W<lable>Pierced Amount</lable><br/>
8 Y6 @3 v  q. [<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
6 g% R0 E# s2 k' d- `2 c}
( t$ a$ d5 ~, W/ i8 Q7 L3 v: B  X
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
2 p1 m0 `1 p8 O! c
################################
##### Connection and Post ######
: U3 n# i* O4 W################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
. ?( t) M- U0 O3 I7 P6 p6 b$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
. `# B9 [# _  t2 Q$ItemPierce = @$_POST['item_pierce'];
# `6 U* V$ x; N  N7 @################################
& v0 X- M% z( n$ @1 l1 _; N% T
//Check both variables for empty value

5 W- s" H) W% m, o7 A* n! Vif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
% ^- P7 K6 x4 w8 gecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: T: z1 @% J, o  k$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
. n) z# s+ R9 t$ F& }
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
/ v+ _& C* |$ N
! v% u+ L' y1 }, G. G: R[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
0 o6 A2 V3 ~9 _5 |1 P0 f2 }7 [" C% m
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

2 P% ?) G9 z# ?'{$ElementUpgrade}', '{$ItemPierce}');");
5 w. J' Y6 A! w0 h' W! ^}

! V4 h7 P# d: J, I  a" ]3 a# D}

}
% S; Z  J" r1 a8 T$ F& e  e
$InitForm = InitForm();
) d, t* B5 x, j+ @' @$Listener = PostListener();
+ |  Z7 y0 N6 V2 q- s
' b, |* ]" y. Y  `( Q6 i; p?>