物品发送脚本

admin

<?php
; v% F$ U. u! R. m4 pfunction Connect () {
  i1 E# t/ ]$ F9 Umssql_connect('Server','UserName','Password') or die('Error: Connection to DB

' x& w  N  ~% u9 m5 X* w7 NFailed.');
}
Connect();
4 X3 R# Y, L1 _0 G0 G+ k
function InitForm(){
//layout for the form
- N* j( g$ |( p$ r5 }  oecho "<strong>Send Items.</strong>
<form name='select' method='post'>
1 P* @9 f: I* f1 h" y, N% l% ?<lable>Character Name</lable><br/>
; ?, N# q% q9 K$ Q; K. F<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/>
+ `0 S+ a/ S; [! j) _( c<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.)
. K* U' |; ~+ M
</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
1 u( L4 Q- ]# J) z) z' S<input type='text' name='element_upgrade'/><br/>
& Q1 }0 @) r1 L- r9 j: z<lable>Pierced Amount</lable><br/>
* \) {" F' N6 i. J6 ], R# U<input type='text' name='item_pierce'/><br/>
7 x7 Z9 G7 o; w7 r<input type='submit'/>
' K+ F' J/ H8 ?2 m6 t* c$ C& e4 H</form>";
3 g* p0 F* q+ ^6 B" @- D}

3 ]2 p/ D3 T  j0 D" Yfunction PostListener (){
" h6 M. `* ?9 H9 }//Add more post variables if needed and add them to initform() function aswell

8 t. P, Z8 w( E& e################################
0 j5 N2 k2 O3 B' z) l##### Connection and Post ######
################################
% M& Y: e% Q; N" H) }3 U5 P$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
" c! L0 G0 \) s$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
( P5 B! ]0 X5 e$ U$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
( ~9 L+ x8 G8 q& v################################
" Y, S# C! `2 ^- {
, ?# q# Y5 w7 ?5 G( v1 v5 U//Check both variables for empty value

& {! D: Z, G+ lif (!empty($_POST['char'])){
9 z, G+ j' P! l4 c0 F3 f& Q! ~$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, F0 b% R8 u/ B* C3 \* R/ T
m_szName = '{$name}'");
( A" h7 T3 z; y- hwhile ($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],

; P3 e( z) g; o+ L- G[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% O0 s) L7 \  @& D
) q% s4 t7 I! U4 {/ M: |N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
  \: O' L( q  Y, U
. X- [( U: d  ~'{$ElementUpgrade}', '{$ItemPierce}');");
/ g0 `3 E+ }% `}
- F7 A, F2 v+ d1 b8 p
}

}

9 M) e( x" t/ I- ^4 o6 |$InitForm = InitForm();
& j" g/ W6 r9 y/ |$Listener = PostListener();
6 T  {/ X7 ]1 P' r; u5 e' T
$ V3 v+ X5 e, p7 v" N$ _) Y?>

. M( w. P8 L  r; g0 _+ q  p
3 b8 n7 B9 T4 v
* t4 d6 P, S% F3 M( C2 D, a' f& R
7 h# Q8 K* u' S