物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
! x* f/ W, d3 O! G}
% z2 ]5 J/ s3 a; q, }Connect();

# r* j7 {& o6 \0 b2 \- a4 [function InitForm(){
' }5 F7 L+ X+ n//layout for the form
4 i" s7 L! P# `8 \, E2 I$ V  _$ p' Hecho "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
7 S- h8 i* U+ y- b1 c<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
5 K7 |6 B' f- L7 C- _2 x- [% ?! `<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
0 t. J. _8 T1 y6 a, R<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
/ ~7 A/ A% d3 I0 ^; c<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

+ @0 }% ]; b0 v</lable><br/>
: _8 g! n& ], i  `8 c* ?<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
* ^8 J) x' Y+ E8 Y9 f& O5 q<lable>Pierced Amount</lable><br/>
! e. b- ^3 k; i& F<input type='text' name='item_pierce'/><br/>
# w8 j( I% t* @; i% L0 I5 s<input type='submit'/>
</form>";
}

function PostListener (){
8 L0 G6 C7 w4 C3 V+ @//Add more post variables if needed and add them to initform() function aswell

################################
2 ^0 ?# ?8 E0 k7 R9 Q##### Connection and Post ######
0 Q# M" Z0 i+ h/ A################################
# @1 R! t- ~/ d5 t1 I$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
4 B$ k  b1 I/ B) q9 M( F$ItemPierce = @$_POST['item_pierce'];
. v2 y: Q- o  E8 p( Y5 x. ^################################
: h& G7 [$ J' n- M: R7 J
//Check both variables for empty value

! l' K, g( J3 g: S6 B' B: d. G/ t* uif (!empty($_POST['char'])){
. h5 q+ p. b+ Q! e$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ [0 n: Z4 @+ H& Q
m_szName = '{$name}'");
! Y$ z7 |9 Q2 L' @) swhile ($row = mssql_fetch_object($find)){
, `  ^) X% |: V- Gecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
+ [* Q; O7 o8 ?% F0 S$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
+ r/ e6 M! d( ?" w5 ^
! P0 B; D" u1 S# W& G( d/ H[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

' @. h: |1 I! [+ n- r[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
# k+ v! J( w7 X  k3 W9 B! s
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

* G/ k0 {! G; ?'{$ElementUpgrade}', '{$ItemPierce}');");
}
) M9 A8 Z: N' M9 p& ^# K7 n. \
/ r) \) O+ u7 i/ W" I}
; U1 `, `5 N/ ?% ?0 `3 L0 P1 v# ?
}

$InitForm = InitForm();
$Listener = PostListener();
" U9 f5 y: J/ e0 E7 J
?>
1 t( ?" `7 E! J8 k- V" a



- C) p* V& `9 M