物品发送脚本

admin

<?php
& ?) R- f( }( w6 S+ @  Jfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
# }9 w# j6 A7 ^7 R- V; a: S5 T5 V+ h
+ |5 P1 U* G- cFailed.');
+ m1 \' i9 v0 O9 A3 Y" B}
! G+ l, k4 U) t$ G: PConnect();
$ {% [6 k6 K8 E- r+ X& N/ t  T
/ C4 x  C$ t/ Tfunction InitForm(){
0 V6 w, D  m& W- f; c+ X4 V2 N, T% S//layout for the form
! B. O' Y7 `  ^  w9 X+ iecho "<strong>Send Items.</strong>
: z" f/ k+ |& ^6 j2 c! A0 j6 H! I<form name='select' method='post'>
<lable>Character Name</lable><br/>
8 Q1 y' a; H( Q0 J<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
& }( k9 h& c( R, S( ]7 f<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
- x8 Q5 ]" u/ W( [<lable>Item Upgrade Amount</lable><br/>
! v* s2 r2 J0 t  x1 p4 [! s3 B4 \<input type='text' name='item_upgrade'/><br/>
9 a0 ^+ ~8 M+ E# z4 F0 V/ V<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
1 O* L* G# ]! d) @; {
</lable><br/>
: c) T; P' U7 ?% t! Z8 X<input type='text' name='item_element'/><br/>
% k3 J( |6 [: q* C. ?, D<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
# x8 H4 M" P! g<input type='submit'/>
</form>";
}

  l0 w+ W! E5 I- m, j) ]- nfunction PostListener (){
  U' [0 ]; l+ C! m* |3 }  T6 M. E//Add more post variables if needed and add them to initform() function aswell

2 ]0 {+ d9 ]) F" t* z################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
3 ]) i, F- g% p! T# Q& K$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
! R+ a0 o7 V# d' ~$ |0 y! k# V7 X) m$ItemUpgrade = @$_POST['item_upgrade'];
3 Q' S  ?  @9 H9 i# Q$ k3 R$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
* }& j0 l0 p% j) p% ~3 ]$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
6 R! i2 p% x% _  a, |( h2 vwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
* E8 W" m4 e' j* q$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
5 ], g; }: v! _8 r0 [
  I" z8 x. ~7 R: G[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

7 @% _' @, [/ p" T6 ^% k'{$ElementUpgrade}', '{$ItemPierce}');");
. s* c6 m" m- {9 P}
+ i  F" g1 z: S. B3 o% Z& T
}
) b4 |! H1 K4 U
  ~$ r$ U& z4 l7 t8 a}

$InitForm = InitForm();
2 ]( a7 Y2 o+ l# w$Listener = PostListener();
1 ]9 B% V# l$ N. T! n1 O
( @: `5 G% P, E) h8 O?>

1 H8 N( K+ X+ Z4 B" a% Y( n4 ^

! b1 N2 D/ e4 `3 F$ }
( Z; n" w# \# h& W( n/ `+ D