物品发送脚本

admin

<?php
; E$ \; K& m0 V. T8 t. a3 _2 Jfunction Connect () {
0 u" o8 T- q; R. O! }- imssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
Connect();
1 L7 H8 W: w" X( v6 G
function InitForm(){
% n6 x. o% g0 |8 e8 h; b+ G//layout for the form
5 j$ N2 k, N4 d  F: W6 u, yecho "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
! K- G0 a) Y3 `$ E( M<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
2 d6 i5 `) T9 Q9 g6 W<lable>Item Amount</lable><br/>
4 f+ G/ T8 S6 r0 h. k, U) s<input type='text' name='item_amount'/><br/>
<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.)
+ N, D$ N+ S% K5 C
</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/>
* O5 ^2 ]; L$ \5 f$ }<input type='text' name='item_pierce'/><br/>
5 ^0 ^8 C" f1 p<input type='submit'/>
9 k8 M: X# Q1 P! C9 z6 L</form>";
}

function PostListener (){
$ [* C9 N- s' F8 T2 x2 R//Add more post variables if needed and add them to initform() function aswell
: ?* ~. P5 T& U
( I6 h/ I* P9 V$ y& Q# O################################
##### Connection and Post ######
( z. m# N) O) T) @################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
6 ?) z+ m9 [( L$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
" N  Z- k6 O* |6 n; c5 I. Q+ }################################

9 p, A. {6 s. X/ G1 ~. U//Check both variables for empty value

/ ~/ ?  F! o5 g1 a6 X' X: ?# w$ pif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

- G0 p6 `5 g- \/ d- r2 V: z* U* I1 qm_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],
* O; I! X; \: t* h
+ R; W5 O! `5 i- V; [  Z- o6 ?( Q, T[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
( J2 h; v5 @; `4 h: ~- z3 m& c
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

# e) ^* [+ ?! _) f$ Q: I/ C- C, iN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
* G2 f* S- L0 k
8 U( b% g' U7 ?'{$ElementUpgrade}', '{$ItemPierce}');");
) N9 [  {1 B( B1 e7 Y}

9 |0 B0 ?/ i, u0 D8 l% H+ J' q}
8 {- [# O. S% q$ ?4 U& w
2 x) x4 r7 W" J. L}

$InitForm = InitForm();
" s" H/ B( `+ S+ Q0 ^$Listener = PostListener();
9 [: b& n4 f1 \' t  y
?>
. W- I" ]3 ?# }, r, e1 X

! P: u$ V2 f6 k8 Y1 H
8 L$ \+ A5 G: p1 {" _