物品发送脚本

admin

<?php
. K0 r- r& U0 Kfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
7 |0 b0 `" D8 a5 u  OConnect();

$ W& q+ \$ e9 A/ n/ F" N* Efunction InitForm(){
//layout for the form
# P5 w* O9 c' [( gecho "<strong>Send Items.</strong>
0 F0 X( v: ?1 i! ^1 u) g. o" I' `4 V+ _<form name='select' method='post'>
; Z+ P2 D. B3 P0 }( N4 R& `<lable>Character Name</lable><br/>
6 j/ E# f8 b( s" S8 H<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
" y& s0 G4 w3 w<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/>
0 E3 ?+ w0 A* N0 m  v7 C. m/ z<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
3 ?+ e( o# w+ @& b& M1 L6 t4 F2 f
</lable><br/>
: c# E; ~( N- E8 |<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
% b- e3 N) B2 I  ]5 [<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
# U4 s' n1 V$ n</form>";
}

+ ]) F! q  h* m$ Ofunction PostListener (){
! g& _2 K0 [5 Z: F//Add more post variables if needed and add them to initform() function aswell
: j* J7 f: K. b# {: m: E$ b
################################
9 p5 f5 H% @4 z4 N% i; }##### Connection and Post ######
################################
$name = @$_POST['char'];
$ y* g! |- d0 c4 K8 ?* t$ItemName = @$_POST['item_name'];
3 `4 S) p, _. j# j7 ~7 f" S" ^$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
0 ?6 t6 R0 J- _! b1 C$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
% m0 `  c+ p. L! S1 f. y################################

& j! y! @8 w. _; [//Check both variables for empty value
/ K% O, Q4 Z; d/ v# j
0 ?3 p* p1 ]* I& t& A0 y7 nif (!empty($_POST['char'])){
, W8 E, I& H( i8 ?: F" D$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, _3 L/ @3 H2 ~! K
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
0 V5 d3 F. |/ e* `+ h* Kecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
& l3 f$ V- l- Z% e' v- B9 c$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

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

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
9 Z1 K9 S0 N: \) V( r% `" Q6 A/ J/ J
'{$ElementUpgrade}', '{$ItemPierce}');");
}
- k0 V- f! U+ W; ~% |& ?
$ ?/ ?7 c" [. d}
: D  w& Y6 P1 G; l$ T- e: |, o, P
& B# F3 v' P, V+ I' W/ Q# F}
" p' v( d: n  f4 B6 {
. y# @( y; ~* H% q2 Y/ k1 H$InitForm = InitForm();
$Listener = PostListener();

( R, {! t* w5 W% k0 o& V?>