物品发送脚本

admin

<?php
function Connect () {
$ n' m' Z+ X/ }4 H  P7 @, |mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

/ l; S! T1 d+ h! O: JFailed.');
}
Connect();
' ?, F2 u3 W6 N4 Z3 c- r9 Y; c" N8 M
function InitForm(){
/ r- O! k+ C  n# U//layout for the form
) E6 W$ k. S/ G9 Vecho "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
. T4 r* g- \2 L9 v+ X" p. V<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
1 ~% g1 @( k  [8 G' {<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
0 _  O1 ?5 Q/ s! D+ h. N1 M<input type='text' name='item_upgrade'/><br/>
- R3 N, O6 x( i8 `+ N<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

( O% m. @  i" S</lable><br/>
) |2 D" f* {& h- C<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
/ U8 b$ B# q) T! q" Z5 t  J<input type='text' name='element_upgrade'/><br/>
4 O' u, |% a: o<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
5 d+ z/ A9 I; h4 U</form>";
( @4 d3 _$ e6 D9 E}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
, T$ m9 `- R! ^& \7 F. v! G$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
3 B6 }0 q5 U' P! S; h5 C$ItemUpgrade = @$_POST['item_upgrade'];
. m% ?- S1 v$ V! ?; e$ItemElement = @$_POST['item_element'];
! P6 p8 [- A* `, `8 s  |$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
- x7 ~2 o) e, E9 Z9 F################################

" z1 _* U4 i' j- a5 ~* @! u' R; r//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
/ u( b( t, q, l+ E  dwhile ($row = mssql_fetch_object($find)){
7 N, L7 K& Y+ x6 b4 m0 {2 o- A  A$ yecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
6 @5 [' T; {2 z! q8 f( y) T9 F2 q
  B( P1 Q6 \$ G: ]# c6 b* u[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
! o/ c$ C# ~, c/ o+ _
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
7 g; o4 ^4 i. U0 {
3 s) F1 n/ C! [' e$ _N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
/ ]9 F- ^, R7 S8 S" R. a. r7 Y
'{$ElementUpgrade}', '{$ItemPierce}');");
  p) K7 @5 P3 t# K) l' N}
& M6 C" \) ]8 X: o0 r
}
/ x! l5 c  O! ^' u
- R( B2 k8 }! E$ |* W1 }" n  x}

+ e$ d8 S8 U8 ~, H" R) L$InitForm = InitForm();
$Listener = PostListener();

?>
$ f( x3 @4 S, k3 |



2 z4 F4 m) Z# ^) }+ o7 e1 G