物品发送脚本

admin

<?php
function Connect () {
. h6 C6 G- Q9 omssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
! s+ Q5 {% R9 x0 P0 B6 Q* G0 d- Q}
1 w/ q0 Q2 w+ B8 N6 W4 K% TConnect();
& B' I. I! y" f2 U1 o* d2 E7 s
# e: D: b  l+ Z  }  R: ?5 lfunction InitForm(){
! k! L4 [: D% o- p0 a//layout for the form
: v7 @5 G2 @/ |; X( t# ]echo "<strong>Send Items.</strong>
9 v" Z( L8 s3 e' }5 ~# N: a<form name='select' method='post'>
; z) g# \$ V' m4 i4 R<lable>Character Name</lable><br/>
! u; h% f/ @$ j0 k<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/>
<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
3 m8 q( w8 Q2 G, M+ [& m7 O' K
* ^. Y7 m' n& u& W</lable><br/>
<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/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
* X; _8 B3 \0 d}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

1 O2 V3 Q$ X* c* a3 B. O, z. D################################
( |: `0 R* V  V; s. |* m' E7 }1 V9 A##### Connection and Post ######
' P' y! e9 s3 V################################
* g/ ^& g8 ?. f+ A- z$name = @$_POST['char'];
3 U5 a, x6 |6 @, p$ C& M5 V$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
1 \0 L: x! W; j4 g& r$ItemUpgrade = @$_POST['item_upgrade'];
% z/ }* r  o7 V5 p, ]$ C% p$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
" {5 S+ h3 K7 b9 L* x$ B0 ]$ItemPierce = @$_POST['item_pierce'];
################################
* ~8 M. n3 B/ N2 D  e8 |4 J
9 K' f' V; Y: P0 _//Check both variables for empty value

if (!empty($_POST['char'])){
5 [, r6 I* P/ F; C9 e$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
" \: R9 i, A1 f1 M8 V, |8 r
' k6 Q' V% w) C" rm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
8 z1 ~& d( \- C' y* yecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
' a5 N7 k/ I* |2 F# \8 b
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
- I  C) p$ X1 E5 X
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

) e" Y, D: R) ?  I6 l3 YN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
. [5 s4 N% C5 E! Y}

* e! p4 I3 V2 h}

}

$InitForm = InitForm();
$Listener = PostListener();

?>


! ^- {( B/ k6 k$ o+ k3 }

( ~% V0 _0 f% p  r' H( v