物品发送脚本

admin

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

. {1 g0 d% n4 @" dFailed.');
- u6 u( |5 O, m$ s}
7 j9 K% q% G, O/ D* d+ Z! UConnect();
4 W. w! j; T6 a3 B9 f
function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
# R7 L9 B) _* M<form name='select' method='post'>
<lable>Character Name</lable><br/>
' k' W! F9 l2 k4 z  X<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/>
0 {) a6 F2 o6 X8 _. I/ s; |<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
* {8 c- D4 D7 r: ^6 d& |; V<input type='text' name='item_upgrade'/><br/>
9 _  r; q) i2 ?$ K7 f# ^<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

; Q4 M: J" Z4 ^2 `* b8 Z, Z</lable><br/>
<input type='text' name='item_element'/><br/>
- }) \2 J" D* O$ M; t& d<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
; k1 l2 W2 U) [/ O<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}
2 ]8 i+ B5 ^- ~' u. s5 h4 w& |
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
0 f) z; G7 \! v$ v; s  e
################################
+ b  B$ J  s9 k  N8 d6 L" Q! u##### Connection and Post ######
* D) C% y3 s* x################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
* c/ v- U' V$ q9 p! v4 e" V$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
; L& a; X& f4 q7 X6 Z7 [$ItemElement = @$_POST['item_element'];
, b4 ~. Z) D  c$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
2 }$ |8 k6 k% i# F. q) }
9 p+ A- v, R+ q2 d. A8 d$ c//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
( x8 u* m7 r4 X7 D  p
& }) {0 P3 \, i: O3 ?m_szName = '{$name}'");
' Z# S9 H3 L2 |: _while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
4 J. |: S5 V. e( _% D3 _. A$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
* m4 l4 {2 A( d' x7 I
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
8 Y6 m+ C8 Y: R" H- A" i1 a- _
& ^5 K+ c" _0 V. z7 MN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
7 C' }9 J) o/ S7 V- z" e1 r
'{$ElementUpgrade}', '{$ItemPierce}');");
& k) I( }% B+ L$ l- F}
! q# a( j# }9 P1 c( H/ A8 i! j
}

9 _9 L/ O) y% I9 y4 T2 x}
8 E7 Y+ Q; q: \/ p2 u6 Z- g  S! r
' t" ]$ X) Z% ]1 [, W$InitForm = InitForm();
$Listener = PostListener();
' ?4 H$ {6 {, l9 c' w
?>

( v! T: j) y( S! o- A" e

( _$ T9 D+ y8 \