物品发送脚本

admin

<?php
) H! K; {. Z8 o7 A' D4 gfunction Connect () {
, C3 D9 v) R+ H# ~/ y& Kmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
# C6 S% ?$ U/ u- {' i2 W  O, h5 |. k}
! q4 s8 z( ]% sConnect();
5 b0 O  H" x$ S+ n4 o" e
function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
# H) J8 y" \4 L9 F6 h6 {<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
9 }  x$ p) Q- ^# H<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
3 Y* _; Y* a) J1 ~+ V  i# |<input type='text' name='item_amount'/><br/>
6 m5 |  H. h% Q<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
9 y7 b0 S( l$ ?% n* D. a
</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
4 S* x+ p/ Y' c9 a2 Y" {<input type='text' name='element_upgrade'/><br/>
! o% F+ \1 r9 g8 A1 c1 Y<lable>Pierced Amount</lable><br/>
" d$ D. \# Z4 I+ ?% `% n) m<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
4 x( Y; i$ ^5 S</form>";
" T5 n5 e5 A1 C8 @7 u* B: A" S}
3 T. X. M1 S( {0 ~5 T* q% u" [
5 `8 Q$ A/ [: j6 d2 A- Q4 P5 Xfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

9 @+ R$ x/ ?; j( ~; s2 H4 @################################
& P1 E  Z1 T$ G# A4 }4 ?* S##### Connection and Post ######
################################
$name = @$_POST['char'];
( _# F, Q/ ]/ c* K( h$ z5 h$ItemName = @$_POST['item_name'];
2 T* k* C4 [5 c$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
/ t2 f5 \; I* M! ~3 M$ItemElement = @$_POST['item_element'];
6 K6 |6 D, J2 k' ^2 R$ N$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
0 I3 v9 U0 |$ Z0 D( ^8 V################################

# T" D/ {$ |6 j- Z7 g//Check both variables for empty value
, g& w% E/ t0 F# @# p9 F
; U. }. b0 y# Aif (!empty($_POST['char'])){
& D4 \0 Q" ]) G/ J. C& e8 H$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
& b' L8 q/ ]+ z# L  O3 ~5 z' V
m_szName = '{$name}'");
8 H' M; n2 ?3 ^) ]( G/ Zwhile ($row = mssql_fetch_object($find)){
: h$ e$ j+ W7 w$ c/ \echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
: e) @  L/ I/ C0 r) O
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

# R4 }6 ~! A; i7 d9 _; I8 L[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

' ^) ~9 \( ^" G! C( Q' @N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
9 m2 @2 J# X' k2 Q, X( j$ ^
'{$ElementUpgrade}', '{$ItemPierce}');");
' u- Z, W. R$ O  @}
1 n" x8 h$ I+ a6 O: ]1 H
}
0 y% \& O1 V* @! y, w" h6 Y
}
* |4 T* n3 e5 }7 S
1 \' `# D3 V, N  U& h$InitForm = InitForm();
0 r3 G% ]8 e5 Z/ a7 G* R6 F4 l$Listener = PostListener();

?>

8 Q5 u/ g2 R) ?; Q4 X# r- K$ w  a$ ~" G
; C0 g+ D( s) D4 w