物品发送脚本

admin

<?php
) G! Z4 h) \0 K1 Z' l4 Ufunction Connect () {
% X7 s$ F+ Q& V( h) u2 nmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
1 O# F* p# R- u8 {
9 v% N9 _+ {7 z" \Failed.');
}
+ V* w% b. g+ U( M& uConnect();

function InitForm(){
//layout for the form
  q" p) Y9 p. u( f5 secho "<strong>Send Items.</strong>
0 g/ R' b$ x) J  Y1 n1 o<form name='select' method='post'>
1 ^2 ]% Z* ^+ }$ f<lable>Character Name</lable><br/>
0 @  p1 x0 r8 c! P* H! h+ Z<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
; {) x* O6 d0 j# l1 C' s<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
8 _' W7 \. E, B9 ]/ {- T, Y( f7 b1 r<input type='text' name='item_amount'/><br/>
7 `3 B5 i& r6 n7 R, Z1 S+ U<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
, E) F7 b) D* g$ b, {. \<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
: ?3 s# t" a1 I( M3 P
</lable><br/>
  \8 Z6 `- ]2 n$ U; g* C$ M<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
. Y9 z2 q( S9 L<input type='text' name='element_upgrade'/><br/>
5 j6 o0 O, q3 G' A! B( `, n<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
$ K. D9 @( y( q5 `2 z2 w( [; }4 h4 C<input type='submit'/>
2 ?- \6 t2 W# M0 R9 @# V" [) J% W' |</form>";
}

  C* L6 ~7 r$ Mfunction PostListener (){
3 Y" G1 N% ~! _//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
################################
9 n% X+ ~  M) v  [2 x; Q0 K8 b4 h1 M# ]$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
8 a: ~2 h3 m6 D" y$ItemAmount = @$_POST['item_amount'];
  c5 \. U/ ~$ x% _( F7 d) N; _8 X$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
4 e. h% ]1 f3 L$ElementUpgrade = @$_POST['element_upgrade'];
% [* ]5 q: S3 _2 b8 t, c9 V5 M$ItemPierce = @$_POST['item_pierce'];
################################
% }' `5 k+ O7 Q) P6 c8 {$ K: `0 w( k
//Check both variables for empty value
: b. a) S( n, C) d3 v4 f
if (!empty($_POST['char'])){
3 b6 }0 ~: r9 ~8 O$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
0 N* X9 L6 S8 \" ^1 ?
$ p4 G" Z4 v" L2 M' ^m_szName = '{$name}'");
! r/ W0 w4 _) Pwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
  r) @; ^3 s+ M; W" F, k6 E
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

4 V4 B5 N) }  r: f[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
& r. }& H- X) K
: O% }% @$ n6 Z& M1 N2 UN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}
6 X( ]' h+ z& J- S/ C
/ ~- o& l& @" R) ]2 d/ }- o}
5 h) B2 m" o9 E: O) S) P6 B
% e: D2 ?' W; f' ~- c% `2 U$ O}
2 F& W  z' |+ L5 n% ]% ]3 s  ]
; n4 W9 `5 N/ l# T: X$InitForm = InitForm();
$Listener = PostListener();

?>



; b( J! R7 g+ O4 k% n) u' ]