物品发送脚本

admin

<?php
: k" [7 S) C7 V- Q! L6 A8 ~function Connect () {
) _2 q$ L% c( G0 j, Jmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
% S  o* m2 e+ p: O) w' M- F! f8 {" o
3 r; o4 h0 H& H# F7 BFailed.');
5 d4 V0 G0 Y+ x& a/ c) [}
# E' `9 g  g+ ~: |$ CConnect();

8 r/ }7 p8 T% g3 b+ F  c& W8 }% Tfunction InitForm(){
//layout for the form
3 g$ N" q2 s! W9 X' |& M  o. oecho "<strong>Send Items.</strong>
8 V+ `8 Y) P7 w7 M6 ?<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
# l: s, {# `: P/ l<input type='text' name='item_name'/><br/>
" s6 {8 X% g+ ^% u2 I) [<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.)

</lable><br/>
1 E7 w  [% r7 ~3 Z<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
% d: w7 Z* U" F) g* z<input type='text' name='element_upgrade'/><br/>
0 P1 N  L; c. J0 s<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
0 m; e/ p/ F+ @/ N$ t- ?! Q</form>";
}

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

# C& Q# L/ n7 U8 ~9 @. Z################################
##### Connection and Post ######
################################
* _- ^) g+ K0 U, a$name = @$_POST['char'];
7 K. _1 k0 n2 I" {3 j$ItemName = @$_POST['item_name'];
" S+ Y/ y  l4 s4 k" Z) @0 V& g$ItemAmount = @$_POST['item_amount'];
$ R& B: r/ _+ [% N9 ?8 ]/ ~5 J$ B$ItemId = @$_POST['item_id'];
* I' a! N, O9 {- C$ItemUpgrade = @$_POST['item_upgrade'];
' W" O" F: z9 x1 U$ItemElement = @$_POST['item_element'];
; a" S) y4 N  ^, j$ElementUpgrade = @$_POST['element_upgrade'];
7 W- o4 s! Y% q' M$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value
$ |& J9 K/ r' H  l, h
" |; K# {( B8 {( U( T( v4 h% Jif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ g4 [# b; F: k. D; y$ I- N
1 G. x  \$ k' p" D2 I  B  g" tm_szName = '{$name}'");
while ($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],

( a+ c2 D% \' n! q[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
4 l5 Z1 j6 p+ ^0 m% e
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
  z1 F$ a& R  r
) V4 T& x. h- K+ W'{$ElementUpgrade}', '{$ItemPierce}');");
5 G( U0 s' t1 M6 k( q}

. R7 s0 O4 e: `}

, V# p) b' t: `# t  z}

$InitForm = InitForm();
$Listener = PostListener();
) E0 [0 E: L# d, e$ ~
6 b+ b. q1 j  v3 t, a?>




% E0 M2 s: e( E; J