物品发送脚本

admin

<?php
; D4 A( {; D0 [/ cfunction Connect () {
  g' H' `. O) L1 C! vmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
4 r% N* q5 f  d% v1 P# }8 I9 S
Failed.');
* v) z) v$ h9 r  ^! D! z6 P: `}
Connect();

function InitForm(){
' p0 K2 L7 I' }# I# E! f  \7 z//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
' l2 K$ E: B1 l: b. ], w<lable>Character Name</lable><br/>
: G5 S" M1 y! p" j" j9 a' y6 h  `<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
4 R2 _. {1 h! r" r  m6 d' G<input type='text' name='item_name'/><br/>
( }' g( Z5 x; v9 ^4 t6 b/ ?: h<lable>Item Amount</lable><br/>
0 C7 w2 Q9 {  M+ u- Z( |( d<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
/ X, ^+ V2 v  x<input type='text' name='item_upgrade'/><br/>
) v) Z; }3 J, _<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
, Z5 a; ], B) [6 [$ [
8 E0 \5 [( p% ^3 j/ b4 r4 v</lable><br/>
<input type='text' name='item_element'/><br/>
8 w8 g* T9 z! d& R5 G<lable>Element Upgrade Amount</lable><br/>
( X1 n8 a: S' Y+ D& e7 T<input type='text' name='element_upgrade'/><br/>
* }7 j3 N; M# T( h2 F! D<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
+ R0 D+ f& h  F- Z( L- s  h7 G, ]}

7 G* S; B$ i8 Rfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
# H3 e% `3 Y, c$ U+ F$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
( C$ N0 \' c/ D
//Check both variables for empty value
- e8 T6 J8 ^0 U' T: k- C
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
9 m4 c7 d! x9 p  g' `while ($row = mssql_fetch_object($find)){
! n1 k' C" u+ A$ K/ ]4 aecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

& [1 |# V9 d% [[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

; g% f  E& [, W[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
; o; A) A) I" \4 X
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

* ~* r. z2 h( k7 \: g'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

}
% j& l; S% \- Z& V% d! O# ~9 Y
: z* Y/ f7 O2 S6 x: r3 v4 X$InitForm = InitForm();
$Listener = PostListener();

+ c: p  L$ C3 R+ a% ?: w; l) w?>

+ J) ^( m  _' s
  g5 [8 q0 q  Q: K

4 b- l- h5 O# r- b) {2 P2 P