物品发送脚本

admin

<?php
function Connect () {
2 f) F" R# ^% u$ H8 e; s. _mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
7 x) ~4 v. I* n4 D1 K, |  j}
Connect();

function InitForm(){
//layout for the form
1 J8 D1 n) p% H  O( |/ Vecho "<strong>Send Items.</strong>
4 g% k3 Z! [) |7 B<form name='select' method='post'>
, }* l) d2 B0 W- J6 e<lable>Character Name</lable><br/>
9 [8 |% v7 ^/ D! _8 N<input type='text' name='char'/><br/>
( t4 I4 v" F6 X/ [5 _! L% k7 n2 A$ |6 }<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/>
<input type='text' name='item_amount'/><br/>
& G# F8 X6 d3 @: F  m4 o8 I<lable>Item Upgrade Amount</lable><br/>
* r6 g8 H+ j, o3 t( w. ^4 ^- e<input type='text' name='item_upgrade'/><br/>
1 x# n" v1 T! C. S( b1 a: n<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
* F( M  W7 u2 c/ D9 ]( \( z
$ I8 S* c) n0 k5 T) t( D& {</lable><br/>
" J8 G4 s/ l+ b- ?<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
: U$ c* b7 G4 R: \! `<lable>Pierced Amount</lable><br/>
$ J, C+ m. ]  h% x! S! W<input type='text' name='item_pierce'/><br/>
$ |2 p* a# J6 f' ]2 W7 @<input type='submit'/>
( Z+ }3 O/ K% h0 ]4 `% P3 V( k! r" v</form>";
% X. |0 ~. T4 }8 Q& X}
* S1 {# E+ ^3 o$ g
0 c" R( H! ]" ^function PostListener (){
6 j; n; B. F4 t* `+ n//Add more post variables if needed and add them to initform() function aswell
/ I; `: N* J  Q1 r) N5 m* P
. S! f6 G  p2 M" g( z################################
##### Connection and Post ######
% K9 U5 w! r/ w! B################################
* E8 H; H9 h# s4 J6 ^1 u* Z0 y$name = @$_POST['char'];
, ~1 U% z  L2 u; Q. ^- b4 a$ItemName = @$_POST['item_name'];
/ j% I) Z3 ?- Z6 C$ItemAmount = @$_POST['item_amount'];
4 M) f( M; l: M4 o8 _' \- [$ItemId = @$_POST['item_id'];
7 Z; l5 R: K  h) u6 `9 L) r$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
& n0 F+ k1 p' z& a4 A% s$ItemPierce = @$_POST['item_pierce'];
0 {7 Z8 R' K) A: J7 r. Q1 W################################
/ W3 k* a. d* p: p8 A& {
) U! Y$ Q6 O! V. g% V& P  \) Z3 k//Check both variables for empty value

! D4 }% D; S) x# J7 Sif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

  l* j8 C7 b9 cm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
0 a: c% H5 J) K6 H1 y% }$ xecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
- {) E3 _" l& ]) [" i
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

4 m8 Q1 P& S; Y* u[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
' R+ u* G% j+ c3 s8 u" Q
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

* n: e  M+ {6 f. A. Q'{$ElementUpgrade}', '{$ItemPierce}');");
}
) ~  X( b! @& y& D0 c& ]
}
# r+ K  @2 w/ [" `( J
+ R! Z' a' P: D6 P/ c1 W/ m( |}

' U  r& m+ J" x$ u/ R) \$InitForm = InitForm();
/ B4 l  G8 _# o; @$Listener = PostListener();
  q' s$ q  w$ X1 K5 U
2 W$ J# v5 o$ S& {6 `: N& U! O?>



3 ~* O7 z: _* M& A: f# l8 ^