物品发送脚本

admin

<?php
  E; M  X& L3 z2 _6 b2 nfunction Connect () {
) R8 v( C/ X, a( M6 W( k# T* |mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
4 r7 s1 e" w0 s2 I% O& B3 k  K
Failed.');
}
3 M/ z  J7 m2 c' Z8 c2 z9 nConnect();

9 q5 V- l1 g& V4 G6 k( sfunction InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
6 ~3 T( {, [* L# r9 v<form name='select' method='post'>
5 S4 {5 y5 P" n) s  |<lable>Character Name</lable><br/>
% ^- v/ g6 c1 G" w; f<input type='text' name='char'/><br/>
" _6 d) c4 E; M- b) i<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/>
/ y6 N# I/ C' v; o$ Q" v- ]6 S<input type='text' name='item_amount'/><br/>
3 \7 R6 f; j) ^7 E% f<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.)
6 Z/ h, M1 z* B: P4 I% n; y1 r" i
</lable><br/>
9 L0 D; N) U3 h- n1 `; H<input type='text' name='item_element'/><br/>
$ e- h9 M" P" {# ?$ i) d, D* j8 J<lable>Element Upgrade Amount</lable><br/>
1 p* b  B5 O8 N0 z0 g<input type='text' name='element_upgrade'/><br/>
1 }$ a- i, ~/ T0 @: A<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
8 h7 ]: U, i0 v: Q</form>";
9 s! A: C/ j; D' o( ?& L}
3 a$ V* w6 X- X4 D& R0 T1 v, h
function PostListener (){
% S" F( G* g( _! ~: u8 _//Add more post variables if needed and add them to initform() function aswell
( E5 V1 Z% J- ]0 Y
################################
. R. l) u/ Z  U% @& ?7 m##### Connection and Post ######
9 l( m  D  a- ^2 V! R" S- u################################
$name = @$_POST['char'];
' V0 M' H# ^( w7 }$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
% c2 w( v% s# y' S3 X0 \2 R$ItemId = @$_POST['item_id'];
3 B8 ~0 q; _4 C" C6 U/ C$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
& H" ]6 Z# Z- z0 m: Q8 h5 w/ ~; A$ElementUpgrade = @$_POST['element_upgrade'];
: x2 J1 M1 D& ?( T0 p. W1 S$ItemPierce = @$_POST['item_pierce'];
################################

# `9 p& A$ e7 E0 D5 B3 Q//Check both variables for empty value

if (!empty($_POST['char'])){
1 z4 }3 C1 J9 ~2 [7 \" v+ m$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

3 Q  v5 D  J* q# o; F2 \m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
9 X, K- S5 x1 h% X( V& A$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

  [/ m" N4 C. S[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
# j' j4 p: ^( W+ Q" L. R" g
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

* ^; f* p5 I" |7 F; gN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
. g- p+ `& b$ p+ Y2 n
5 f, G7 }* @6 \9 y0 ?'{$ElementUpgrade}', '{$ItemPierce}');");
" w- m, r- M2 V. ]+ @}

}

, _" \0 H- `  a8 g}

5 p7 @' ~% `3 ~! r+ j* d' F$InitForm = InitForm();
$Listener = PostListener();

?>


; Y& B, }0 N4 g4 I0 t

7 E+ ]7 B9 k. k  m