物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
# O) H& C6 }' C: j1 H1 y}
7 L/ r; Y' e& B/ c8 E+ [* l# `Connect();
6 P! s" z! Q" \0 s
1 g# G7 U2 O# S( i/ s" s- Hfunction InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<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/>
+ J# I+ |; r$ H/ E* @<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
' X4 }1 i$ c2 h/ t8 l$ ^9 R: V<lable>Item Upgrade Amount</lable><br/>
$ l7 V8 V. R/ A) ~7 j<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
3 N) j- T! X  z% N
</lable><br/>
<input type='text' name='item_element'/><br/>
( ~/ t1 l6 |* A$ g<lable>Element Upgrade Amount</lable><br/>
  t( h; K# N( A( Z<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
( i# J; N0 B' s3 _<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
7 g" ?9 L0 R! `* }5 @& @0 ~4 S</form>";
}
3 \1 D7 g  @% b; k8 `& L) X
) |& A8 w" h/ X. [, pfunction PostListener (){
: Z( x, }$ Z# Q9 [. f//Add more post variables if needed and add them to initform() function aswell

3 ?+ b% X0 ?5 P################################
2 ]& i& |- U" @1 S, ]1 p/ J##### Connection and Post ######
3 V3 n3 P( X- k' ~& ^, c################################
$name = @$_POST['char'];
* M' y# z& a. C5 Y$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
# D& `4 {% ~, ^$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
+ Q! H- S0 \. T: E1 [$ItemPierce = @$_POST['item_pierce'];
% e7 R0 B- o% \. ]################################

7 g- g' Z$ _& ~//Check both variables for empty value
: X: K  N+ S  t) ~
/ w3 b; m6 H$ L6 Vif (!empty($_POST['char'])){
3 Y, C. G- h  q" o3 _$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

# ~% @6 w9 d" L* bm_szName = '{$name}'");
2 P- g7 R, r) Q7 V- R+ w1 h, p2 owhile ($row = mssql_fetch_object($find)){
; r0 Z5 K; G! P" m7 }# |echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

" N" t, C7 e! \: u8 F) P[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

- y; l% q; j9 P: G+ I2 q. j- P[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

0 t5 \- j: E3 _0 E0 _8 w5 z- \N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
4 x1 b  G& O; l2 L( f
9 ?5 S* H0 f3 ]: j: E7 q, K'{$ElementUpgrade}', '{$ItemPierce}');");
}

}
" H/ P" n/ e- E6 m# K  p! R
; c5 y/ g: y8 ]% O- ]# x}

$InitForm = InitForm();
$Listener = PostListener();

2 A- f; V5 S2 P2 p0 J* I?>
) s% d% N7 W9 I

- Y3 m4 p. {0 C1 {  V+ V/ v2 y
9 c0 i( l) x- }' d