物品发送脚本

admin

<?php
function Connect () {
! f' t9 b& R" J, p8 ymssql_connect('Server','UserName','Password') or die('Error: Connection to DB
: y& _. X" ~/ T( ~7 Y. C
2 a9 ?, a1 P0 D3 ^Failed.');
}
) R1 j6 J! ?) {& LConnect();

4 T  F/ h& _9 Q: @4 P- h! X4 a5 Yfunction InitForm(){
4 {6 {) d' e! o' Z& L, J- |6 @//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
  f8 y3 ^! o0 b0 l<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/>
0 m) G# W/ E! B7 C; I6 w6 T<input type='text' name='item_name'/><br/>
) }( T( X& v% f6 ~<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
2 u% O/ b# d) J9 O4 F6 L1 I+ O' _$ D/ e<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.)

# p# V% v& E% Y# `' M2 u' Q" f9 Q</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
$ ^9 C  R1 w% a}
  c0 n, ?* j1 E: D: v
  \- P" _' C0 ]8 K* n3 v0 pfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

" d( r; ?$ w0 T1 i) O& @" @* }: e! G3 R################################
% z2 C9 k0 I6 U$ i##### Connection and Post ######
################################
. O, F3 {$ y( S6 k9 N3 t$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
# z2 t6 v3 [4 I, K3 ~1 }3 [$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
" F. z) c( `, S$ElementUpgrade = @$_POST['element_upgrade'];
, @) w4 e6 o/ z: F! M6 G$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value

- P7 o% E7 v9 O+ K' n- dif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
0 s! K7 t, S  e; |7 p! n8 |& j- e& H
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
! g, d3 l# \+ G8 V# Qecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
' j2 Q+ C. D9 t' A* r; l0 z
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

4 H: M* D' |/ e0 r0 q/ H5 J'{$ElementUpgrade}', '{$ItemPierce}');");
6 V  N$ M6 Z% C/ O' D2 p; V+ h}
" u& ^: f7 d5 k( d% g! F# o
}
" L7 x9 e2 g; n4 x8 A8 u- `9 @$ U4 W
% J5 E! C6 z5 g; `. H, Q- ^- J}
# U: K2 {5 f* q* O% x
2 F/ U# E' v7 I$InitForm = InitForm();
  ?0 C4 w9 ?9 C0 g: z$Listener = PostListener();
$ p; p, \( p/ C; @4 q0 C
?>
& c4 h5 F) M% J  K- d5 W5 d3 M
6 r1 e- I/ u  V' \3 j% {
- ^7 F7 \4 S: Z+ W6 s% ?