物品发送脚本

admin

<?php
function Connect () {
, v  t8 F5 k7 w: a( G1 imssql_connect('Server','UserName','Password') or die('Error: Connection to DB
9 g. \" C  m# s
9 V. s/ L* ^4 c% mFailed.');
}
* q7 ^# ^' K9 M- R" W5 \" N. aConnect();
" D4 q2 h+ x, M1 H. P9 L9 r' y0 M& `
" g$ h+ g9 d* g2 i% Afunction InitForm(){
//layout for the form
5 o1 [% o& F7 k5 N( k" ?echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
# F$ T* n) x# B+ n- S' G6 a% P9 T# q<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
3 K; J: [1 Z# S) \$ x8 U. V/ Q<input type='text' name='item_name'/><br/>
2 n6 J8 u$ q9 @5 d0 h<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
- M) B9 n# K, ]<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
7 Y* t2 P4 M0 V  y+ r% D8 J8 L, d/ r<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
. a$ \! t" D" c. O- ^6 d" S" t
</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
( z* m/ Q2 x; p& [: R5 c9 W<input type='text' name='element_upgrade'/><br/>
& Y9 g- v' O6 M$ P0 u) I<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
5 H0 ~1 R- G) C# N<input type='submit'/>
& v8 T" }  t$ ~! t$ x% S; U3 U</form>";
}
- o0 ~, ~* E* C, b2 X! _# r2 X7 O0 B
. P# p1 O$ Y" q! \9 d: o, S8 ^function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
7 |6 S5 r8 D" k' K& A6 }
################################
##### Connection and Post ######
4 I  D3 `% J" ^. R; K* d  A/ Z. j################################
& T- J9 c" Y- J4 E$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
, L# P3 z* h4 _# a& A' D$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
. i. Z3 `( d0 {* n4 v$ItemPierce = @$_POST['item_pierce'];
' k( d$ m& M: B$ k# \0 T: T################################

//Check both variables for empty value

if (!empty($_POST['char'])){
0 G1 s' e( _8 w+ ^% B5 e$ s( y$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
  }( o# F" h9 `+ ]2 i, l
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
# E, t$ r& }, \- R/ F% P* c1 Pecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

. ^- _* T% `1 z+ Z; z4 U) @[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
5 b! \! O0 W  g) p
* O8 r$ i' r7 ]  L" j[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ g; ^( E7 ^: T  H6 {5 V6 l
, e: I9 H% E/ ]1 f% H% K7 rN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
! Y/ J; T( x- p% [- m
0 x- z9 I3 L: ?4 Z' e0 }'{$ElementUpgrade}', '{$ItemPierce}');");
  [/ q1 T9 c' K: B+ J}
$ S$ [+ H! @( P) N* H
4 p% }3 t+ z; F5 ]7 L}
1 P- h: x  b' J" c; H0 f
}
# S! @% B! |: C
$InitForm = InitForm();
$Listener = PostListener();
7 d$ U8 F2 b* d+ ^
?>
: C0 `% E' V6 m, V1 l. j
" f" t8 }: L  t0 d9 K7 _

5 z$ g# v9 q3 q7 R! _0 y. n, U, c
3 Q. F9 n0 P! E0 s