物品发送脚本

admin

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

Failed.');
( Q* a/ p3 s" j. ]5 {& H}
Connect();

function InitForm(){
, o) e" J0 P& H& x' ~# ]//layout for the form
( U$ u) ~1 S$ `* x& _echo "<strong>Send Items.</strong>
<form name='select' method='post'>
5 F0 n4 X' n% R/ c2 P2 A' Q) n9 {2 W<lable>Character Name</lable><br/>
: {1 `, o. u9 x; S" G2 q7 ~! s<input type='text' name='char'/><br/>
$ R/ b. s8 ?' G0 v; c$ Y<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
2 y: }" J9 i2 G$ I<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
- R" a8 d7 p. A( \/ u<lable>Item Upgrade Amount</lable><br/>
( X- J6 d1 }2 t' `4 E3 `3 ?& _<input type='text' name='item_upgrade'/><br/>
8 o$ O* s4 U9 W) B7 {1 z<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
, @. W: W; @2 T; o5 N<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
) V; M+ m5 @# g! W: j<lable>Pierced Amount</lable><br/>
  n, J/ D7 g+ d# N0 R& R- I) p<input type='text' name='item_pierce'/><br/>
- ]" ~% [1 D* }<input type='submit'/>
  b1 h2 H/ B$ E) J9 W( a</form>";
}
6 {; e% P" n2 `; ]0 x  ^8 w) w0 P
- z) g4 ^6 p( Tfunction PostListener (){
  t" [- K9 v6 ?; y//Add more post variables if needed and add them to initform() function aswell

) k- r, \7 r0 ~( s' K/ w) u################################
: p- x5 w" T! _- ~) L; E0 S+ t/ N##### Connection and Post ######
  \9 I3 c( Z1 H2 b  t################################
1 u& A- p% J$ E; }9 X9 ?$ P$name = @$_POST['char'];
$ y" V( a1 `& A& G9 w$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
  Y, a) L+ C$ W5 [$ _: T$ItemUpgrade = @$_POST['item_upgrade'];
7 j! A! g' x0 C$ItemElement = @$_POST['item_element'];
0 A: I$ e  X0 C3 H2 F+ Y$ElementUpgrade = @$_POST['element_upgrade'];
& I2 R' Y. X+ x" D+ c1 h; M$ItemPierce = @$_POST['item_pierce'];
################################
3 G& P( C+ D: h; w
//Check both variables for empty value
! i" q0 Q* {5 I( i. j+ w
( D% O( Y( `* A# b% {if (!empty($_POST['char'])){
6 b5 \0 w! K, c1 j* g$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
: @8 v. }9 U, |! F9 k3 |echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

( L/ x  i; b" S[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

$ f1 k2 z$ Z* uN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}
0 O  t: v; r  }# h1 g
* p0 S" I# f& P3 C6 X4 H}
- Z( K: W: r4 b1 P$ q
}

+ l9 Q4 u+ b! U6 Y) Y' [, U0 M$InitForm = InitForm();
/ @7 W, J8 `. C/ c0 y$Listener = PostListener();
9 x/ m  s' C$ R+ L
/ y2 T  B9 b0 V' e( {2 [$ s9 i?>
2 F3 \# h3 Q6 I2 _& X2 D  R