物品发送脚本

admin

<?php
* [9 Z6 z; Z) u( Tfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
3 [4 x+ q( h) e( w2 x
Failed.');
5 V& y! M& K$ ^! C" k' E}
Connect();
' u: r$ r6 `+ ]! p+ {
function InitForm(){
/ z- \8 t, {) b$ N( n//layout for the form
$ j( o5 k0 E# L, q9 }echo "<strong>Send Items.</strong>
<form name='select' method='post'>
: E0 A: ^  }/ j<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
- o" L1 W: \! F% z" e<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/>
<input type='text' name='item_upgrade'/><br/>
+ y% ~5 C- c5 e- ~. Y: u+ u<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

! j$ c* ~) M4 h</lable><br/>
<input type='text' name='item_element'/><br/>
( h! X9 E& I! u<lable>Element Upgrade Amount</lable><br/>
' I) M% @0 m0 D5 X: @+ c  ]<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
' _( W, B  a+ R) z5 y% _# K</form>";
}

& [. k# ^2 O/ `. |4 pfunction PostListener (){
# v9 V( m# }3 D//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
' ?% [7 g) }6 g0 p6 \+ Z################################
1 R! S( N+ M9 V3 f% T3 r* V$ n$name = @$_POST['char'];
) H* N+ |  H% Z+ y. L! W3 t$ItemName = @$_POST['item_name'];
" M, a; d$ D- v, q7 T- P$ItemAmount = @$_POST['item_amount'];
, s# A- ?% D! w; T% T( T. Q; [$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
0 I* W6 K! K4 O$ a" _3 i
+ M& Q7 h- c) o8 }4 @4 N) y. Wm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
' d4 T3 p4 x" g1 ^7 V8 Oecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

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

) P. p7 Z( {1 u% d' w& [" J[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
( x; q& g2 _* v, V" ?& |3 C
4 [: g% j0 E7 P& \'{$ElementUpgrade}', '{$ItemPierce}');");
5 S' P/ L0 E( u# i}
; B9 m  E# A7 ]' A1 j
+ ?/ x/ |- d( O( }3 v) l2 \7 E}

) R( B" i7 j" g/ ^) P}
0 @9 E; u- H% |) p& l
+ ]. `8 ^" `2 _1 _+ T& ^$InitForm = InitForm();
$Listener = PostListener();

?>
4 r/ w1 O7 @" g. l' d; l2 j


+ T5 X9 e, A8 q( Q9 k