物品发送脚本

admin

<?php
$ L, a! [9 h7 [& V8 C$ m9 Ufunction Connect () {
; m; v7 K, Z  J1 R; h1 ^1 s) hmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
" L( Y: D6 `% [4 ~' k}
Connect();

function InitForm(){
3 [; `' X1 X& _- w5 S4 a//layout for the form
, E  @+ \0 g  u6 U5 B! C4 H) \+ xecho "<strong>Send Items.</strong>
- a4 L, R* m& y- A! _# T<form name='select' method='post'>
<lable>Character Name</lable><br/>
* _2 a7 [& [8 ?* s( R1 E; C$ M7 u<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/>
+ v% w( `- {, e% C<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
& M; _( |8 q2 C; J) P$ ]1 ]<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
2 b& f# ^( k& Y0 b- h. x+ x8 M
</lable><br/>
<input type='text' name='item_element'/><br/>
; P' p/ q5 f3 j, A& e% [2 K<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
: @7 d& |: a/ U! L<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
- @) j0 K8 e% z  }<input type='submit'/>
5 [4 G& r/ j" Y% W1 z' U</form>";
}
% ]' a* Z4 a: |: H8 N, n- ?
- w9 y; M& k! Z/ {function PostListener (){
1 \# y- `. w3 L9 v4 L//Add more post variables if needed and add them to initform() function aswell
$ U8 V9 h* ?/ `: L3 k$ Q
2 \# K  B: n8 y1 a################################
##### Connection and Post ######
; t0 x8 }/ o8 z3 n- ~4 b################################
( z2 h& @$ O% O. q; X1 }8 Z$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
: b1 w% P# V+ V) j: K9 l! I; O$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
' I) z3 ~- I7 `8 W7 }4 G! ?$ElementUpgrade = @$_POST['element_upgrade'];
! Z. X6 m% Y7 ]% B% q7 t8 R; }$ItemPierce = @$_POST['item_pierce'];
/ [/ l9 F* J/ o9 O) U  c2 u" J; A################################
4 Y5 W/ t% h9 G+ z+ ]' d" Y
//Check both variables for empty value
' Q3 [, Z! ]/ W
% N' z* Q$ H4 `- J* iif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
- Y( Y" n% y" o& mwhile ($row = mssql_fetch_object($find)){
$ b. i- |3 ?; i4 o/ Mecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
) L  @; p7 r( u. Z! c  Y" ]  \8 Y1 q$ |$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

- j' s# q9 H' y[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

" g0 s& p$ i2 G3 _[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
$ s" K+ L: w. [" H4 G+ P  l: R: t/ g
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
6 \$ }. J. E3 U
9 z- p! o# g  u, }'{$ElementUpgrade}', '{$ItemPierce}');");
" B/ f0 Q4 d  K; U6 h}
& m2 L$ e; ~& g3 s( |5 K
}

}
+ ~7 J, k! e+ B! ]) V  U
$InitForm = InitForm();
3 v4 d% N$ v% ?& }7 ?5 Y6 W$Listener = PostListener();
/ j- S8 r8 s) C; B  l3 i, N
! Q# s4 x" S: T4 A  g/ Z# w?>
7 G! g0 l. O* T1 \# _8 l! I9 m9 g
1 o8 @3 n; L" O, N% U7 v6 D
5 G' I$ f0 g% A
/ f5 @0 o7 N3 t7 E3 {2 ]
9 R( U) N3 `% G9 ]% S