物品发送脚本

admin

<?php
$ i- E( S& u' Y9 j+ Yfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
0 O  g5 J. E5 c
Failed.');
}
Connect();

0 ?) b0 F6 F; h6 afunction InitForm(){
//layout for the form
, @( q  [5 X; f$ a  t4 x/ jecho "<strong>Send Items.</strong>
: `" j4 E  w# v# z<form name='select' method='post'>
<lable>Character Name</lable><br/>
; N: z2 n$ P8 i! ^/ O8 C<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
* d9 \/ u& ]5 C8 g<input type='text' name='item_name'/><br/>
( \# g5 g$ N2 }# W- c<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
( T# M! y5 z5 Y<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
8 i' V/ F, ^+ V- {! Z5 O! h2 p) |" j: X<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

3 x- C- s+ B/ Y. a4 ]5 L</lable><br/>
9 t' r( g% F( R* c& w<input type='text' name='item_element'/><br/>
' J, J, R& \% X+ g# P0 v& }2 K<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
7 |# S0 {) J2 k# g<input type='text' name='item_pierce'/><br/>
% ~# u# p, c1 d, ?<input type='submit'/>
* ?1 M7 X6 n9 m</form>";
9 y* U# I3 A$ d: R- N  ~( q4 i, m6 }}

' d; a0 m4 G) i; Lfunction PostListener (){
5 i/ F1 r7 s' K3 K6 h0 Z! D//Add more post variables if needed and add them to initform() function aswell

. [7 j1 M- s; {3 z" ~1 X################################
##### Connection and Post ######
################################
! o* f$ ^6 X; A; ]/ t& [6 y2 y* ]$name = @$_POST['char'];
4 s9 E2 j# p6 p0 k$ItemName = @$_POST['item_name'];
& t8 e1 ~. ~9 v2 T4 S& K$ItemAmount = @$_POST['item_amount'];
7 A5 v/ i: }  q" I. i. V# h$ItemId = @$_POST['item_id'];
! w7 H  j  P4 ^% C. ?9 r2 }! Q& v$ItemUpgrade = @$_POST['item_upgrade'];
8 j, |! K. W4 u! s- _, M$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
9 M% Y. r! c9 C: W! |' b1 ]$ItemPierce = @$_POST['item_pierce'];
################################

+ K% P$ \- m/ o" I% ^8 Q, h) ^. m//Check both variables for empty value

+ g9 c  p9 [) j. Aif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "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],
$ V* K) a& A- _! U- |
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ x7 o/ d1 e! y- u" p  k
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
% ]& R7 }  _* B: a& M! ~
" I' n/ Z9 ?5 p0 I7 d5 E* m'{$ElementUpgrade}', '{$ItemPierce}');");
}
9 b$ I& {5 |& Q+ `! d
}

6 F" v7 w7 ~7 \! }: u( V}

$InitForm = InitForm();
$Listener = PostListener();
  H) n$ M- F/ c; ^- L
) H, }% v( n8 S; M?>

2 R9 U& `" \1 M
# s  p6 U( g% q' T7 D- Z5 r- {