物品发送脚本

admin

<?php
* F; m0 b) j2 Z3 I6 g- Yfunction Connect () {
7 }+ F# O! O+ d" T  O$ @mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
3 e. }' n. J7 [$ s
% E: Y* x  x7 H) |8 f6 F( |" b" BFailed.');
9 G$ |0 D# g& \$ p. a0 c}
Connect();

function InitForm(){
1 g* I3 H6 \; i/ V  o//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<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/>
<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
. f6 W  ^% l# |: y5 K<input type='text' name='item_upgrade'/><br/>
+ `/ c- n5 a' F4 k<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
5 i: w+ {& \5 }# v" ?
</lable><br/>
5 Z8 ^" _: z2 U6 F+ E4 y% l<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
  r, [4 c/ n+ q# ]; C8 G9 ?, J<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
" H  {8 k; Q% I) r6 i" L<input type='submit'/>
1 @$ O: A! t: V! @</form>";
}
* ]/ r+ ^; [- M; R
function PostListener (){
* p4 w) M( a( x$ p! S//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
, \$ ^0 A0 k. l! L$ }, Z3 Q$ t################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
6 V; ^# d) {+ r# S, ?; F3 f0 Z6 Y0 Y$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
; |0 f+ P  s% V# ]+ M' i$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
1 M4 |/ j' ?: Z; j% j0 q6 m9 Z################################
6 O0 e9 X: g7 k3 E3 k
: W3 M  Z3 S5 ]//Check both variables for empty value
' W. E( `( q! A' w- ?0 M
if (!empty($_POST['char'])){
. l$ a! d* v8 y- b9 i& ^# Z$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
- H# Y9 C3 b: l- e, K
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
) x& ]3 U: d! becho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
4 i! C% p$ C# R0 o& c6 D3 Y% E. Q$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
7 {3 R0 x0 E6 ?" z" W' G' G
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
* W0 K) @  ^$ ]' i: ]+ p4 `: D" H
! O+ c) @4 v  U2 c* Z  E; [[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

' k, X/ [- ]4 O( H" @) W2 J! D4 ~N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
( G( S& U, G4 k' ~/ o
'{$ElementUpgrade}', '{$ItemPierce}');");
9 r% ^8 O2 F7 M5 T' Y" h}

}

0 i6 |, `$ t5 J; v}
$ a/ X3 E. G; F: W9 Q) Z6 T$ l+ i7 I0 w
6 w; Z; Z% Q  }) U; H$InitForm = InitForm();
$Listener = PostListener();
7 `' v  U2 F2 F# `; q/ K$ e5 n$ j
?>

% [; e) X6 K$ E+ a
  W3 G" K4 R, O$ E; Q