物品发送脚本

admin

<?php
, _! R0 J$ V" u! Y( ^function Connect () {
4 u2 m0 v  r' |& @& }mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
: k1 ?" W0 [& t
* |1 ?. |! x* x4 u1 L0 w' r' w' OFailed.');
! a% s0 Y' i9 `/ |9 ^}
Connect();

function InitForm(){
//layout for the form
; n  T5 b! e4 u1 Q# m$ {) fecho "<strong>Send Items.</strong>
<form name='select' method='post'>
9 z; m4 j8 i2 u& b; w: ^3 s+ `<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/>
6 u: ^$ w! B. U( F6 E7 U6 z<input type='text' name='item_name'/><br/>
3 L' S8 c$ j; D5 y1 M<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
' e2 s# ^2 W8 W4 U5 o$ F  Z<lable>Item Upgrade Amount</lable><br/>
8 {7 Y8 \1 j' r  D( i; f<input type='text' name='item_upgrade'/><br/>
( c& J7 w  x; v; a& }, i6 d<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
$ h0 i1 E6 k# [& J
</lable><br/>
<input type='text' name='item_element'/><br/>
4 ^3 T# R% m2 Y, b- R' k<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
0 `+ X+ S/ L5 R0 R4 b( u# j( g<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
) U9 }& v6 }! m, W# @. L<input type='submit'/>
8 d$ T) R4 T& {+ f" B2 _* u</form>";
}

function PostListener (){
4 s" W# ?. |, w/ W5 F//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
; s- b4 `: J$ f* X9 B################################
$name = @$_POST['char'];
, F& r% O+ v" X! y) s7 G$ItemName = @$_POST['item_name'];
4 O" p; d  ?2 g5 l. O. G/ p4 \$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
- d/ X. a8 v5 y$ B. s2 R$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
3 T. W& a: [# G; C9 B  c. w- ]$ElementUpgrade = @$_POST['element_upgrade'];
; `+ d: y" X, ?3 A6 a$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value

7 @' q1 M' q8 I* f; f4 Pif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
7 i$ q5 T& O; uecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
9 ?  Z) p1 v# Z5 A4 D8 p# Z$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

3 R% T# Z( E* l% j0 M, M# ~' G[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
# S+ ]1 X; d9 C( I$ [
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
# G5 N' o2 i5 u
'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

}
# O( J3 e( ~& h. x
1 n6 x: @1 {2 f9 L0 f$InitForm = InitForm();
$Listener = PostListener();
* d$ ?" z! X7 R4 R# Q( q
4 S1 k" H' s: x3 X4 s2 @" P?>

1 k/ K- c- ]( s1 ?) I