物品发送脚本

admin

<?php
2 a$ H4 C# Q, a% f- a8 b( Wfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

' N$ o5 W: _  ~8 l4 m; UFailed.');
: ?, f! F$ g$ C, |0 L( [; _}
Connect();

  ~, L0 G1 b7 U% G, A  ifunction InitForm(){
( O/ Q* v$ W( t$ d/ \0 [8 z/ T3 @//layout for the form
. z3 w* S+ Z0 c  c) xecho "<strong>Send Items.</strong>
2 d  A4 `- C+ U. i2 L3 q5 n6 P<form name='select' method='post'>
: ~( H$ `1 F( v. h3 d<lable>Character Name</lable><br/>
1 \# n3 j$ q0 u5 T+ u# ~<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/>
) j0 G8 B- _" `+ D3 l+ [<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
( J: E" Y0 ]- ]6 d1 I<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
0 L' J0 t9 r7 B$ ~<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
: C, L7 R$ C4 O% s
</lable><br/>
<input type='text' name='item_element'/><br/>
0 l( ~7 E- w0 E; r2 u8 Q+ g<lable>Element Upgrade Amount</lable><br/>
0 n# ?" J- E+ ~; D2 A( I7 d<input type='text' name='element_upgrade'/><br/>
" b# s# @, J8 s7 F- L6 M7 m, |4 |<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
: `8 z1 H; h1 b5 _" Z  @<input type='submit'/>
</form>";
}
. w( w! p7 p8 K; X
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
" J5 A8 _" c8 k. ?) G##### Connection and Post ######
################################
$name = @$_POST['char'];
& D9 e1 O( F) j) l( Z$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
0 h" G4 G* o- z7 U0 g  y" G$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
+ _5 j! v) n+ b/ N: N' T$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
1 n  I3 \( j2 Q2 m, |7 I7 |################################
5 J" [' g) Q( T
  A- o3 _$ R  ~1 n//Check both variables for empty value

; D0 ?- x6 N& d- U- Nif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 F+ x3 Y( z# k' {2 I2 Q
" [* A7 \/ E- W- nm_szName = '{$name}'");
0 P/ v  J' c8 U! Z9 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],
: n4 F% z- P# H
5 S" e9 b& D  c6 M[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
  ^- x+ J( e1 j6 `) O: J
/ N3 F: m5 ~& s[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
1 T5 C$ ?/ ?  o7 {' ?0 ^- H4 }$ l
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
8 y5 V+ x( q% k  H% B, G
'{$ElementUpgrade}', '{$ItemPierce}');");
}

9 ~  W+ ]% M# d}

* e' z$ T6 }" J8 p3 E( c}
# N/ u1 S5 v8 ], S9 \% s
- Z' y) U6 L. P$InitForm = InitForm();
$Listener = PostListener();
) g: s, @2 k! u
9 z+ b( F/ _2 h1 ?' D5 f4 F1 ??>

! [. b: @9 n! q6 {

# |! d; X: I! Z( X: ?+ ~! }