物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
2 \/ R" @1 R* _! L; |' B
Failed.');
1 J8 L( D, S1 ^- B2 x}
# R, `% Z) ~1 S1 X) g1 TConnect();
* t, {9 Y6 [* S, `* y
function InitForm(){
//layout for the form
) F+ [" U+ @; U; Qecho "<strong>Send Items.</strong>
% ]' I5 ~; y  P7 l<form name='select' method='post'>
2 b% L; w( K! F1 \1 J* I0 N+ ~<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/>
- h  x  K0 h# {2 L8 B: r<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
; p, n9 I; j+ r  |; x<lable>Item Upgrade Amount</lable><br/>
- ^" S# k% |; g& K6 c* B' I1 e' T<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
/ Z3 ^- i+ M7 H, A* }' s# x0 J
9 r1 y. Z% Q  v4 C</lable><br/>
<input type='text' name='item_element'/><br/>
, ^$ U/ X! S% v$ k: }8 P" q<lable>Element Upgrade Amount</lable><br/>
; F# p9 P. O% Q" f; F<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
/ |# _: u) P& {* D<input type='text' name='item_pierce'/><br/>
/ ]& m& A5 E# e8 K( B/ ~7 o8 ^<input type='submit'/>
- o5 c& K# D# r" g2 y</form>";
}
# V; b  ]4 g6 M2 q& ]5 Y# T- O5 l
function PostListener (){
3 b7 f6 @: D# g$ }1 @9 [. U9 Z2 L//Add more post variables if needed and add them to initform() function aswell

5 ~1 u( a( U3 N9 k################################
9 o  [% |7 S! G5 H- Y" z##### Connection and Post ######
# r7 A' q6 }( t' s1 U################################
9 t& A$ {4 V9 }4 g7 L$ I8 g$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
& k, Q- G) d3 R$ItemId = @$_POST['item_id'];
  m; m8 `' [' k$ c& u$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
' R: T7 \4 ~; J. f  i8 N6 R3 ]$ElementUpgrade = @$_POST['element_upgrade'];
1 V. D+ F+ E7 r1 D) }2 g$ItemPierce = @$_POST['item_pierce'];
################################
% H& A9 _+ a6 A) [9 ]# ?
//Check both variables for empty value
6 I, h$ x2 i! e
: w% u1 U/ p& y8 z3 s( n) Lif (!empty($_POST['char'])){
4 W. Y/ A1 j' |1 m  R$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ i; A+ A+ o& s$ M9 Z& }* v
+ [  [! |' n* l9 _  ?! Bm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
8 l# D. m  S, W$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

' d1 C8 R* p; T: |: z" {. ^/ e[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

( q& f3 G; C: F3 J7 |7 F$ yN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}
7 o( O2 f" B+ W; c, \
}

5 w" P# \. Q( ~6 k}
& m2 T. l; ^7 N4 l: A; b
# @/ }0 `0 {- J* F$InitForm = InitForm();
$Listener = PostListener();
4 _: ~- @- n( K# `( |. m
?>