物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
' U6 }; o1 \; K% S2 a9 H8 i1 t+ R
Failed.');
3 y/ w) \4 f, [4 |& w0 o8 z. O  v}
Connect();

function InitForm(){
! i6 `: k" I' r! T' M$ [//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
' v' G2 E1 q5 m9 _5 m$ _6 e<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
; K. e  C5 O- M1 m& n<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
# ]! T3 v( R" X) _0 T8 m( J<lable>Item Amount</lable><br/>
( j& k* z# R/ y<input type='text' name='item_amount'/><br/>
' g' l" [' |3 c<lable>Item Upgrade Amount</lable><br/>
( W  E2 v$ r  j2 t$ b0 r<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
5 K  E' @* \' K) |* v, h7 l
! I4 N; ^8 }+ C  I4 s</lable><br/>
- m0 j' l( W! `- K<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
1 c# E' B: e4 }5 a<input type='submit'/>
</form>";
}

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

/ K* G! O" o& m8 b) B################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
9 R6 W1 y! B9 S$ c  ^. p7 r) c$ItemName = @$_POST['item_name'];
3 g2 J4 c1 p" s- i) j$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
; a% Q5 j5 Z9 D0 v9 H0 B, ]$ M$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
: M8 @1 f- v' h% S/ S* L( h. Z- m$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
; D& X/ S: _" L# H7 A' [5 o7 B################################

6 Y6 v9 v8 H  `3 k* f5 V//Check both variables for empty value
) u* @  m* j/ m. M$ e, v2 p5 I
/ L* B  ]0 ?2 P0 x1 S/ Q0 E9 L8 O  cif (!empty($_POST['char'])){
* q% d1 F/ {/ R# B5 T" d$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
% ~( L$ b" E8 j- S( m# g& Iwhile ($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],
: y% _/ q+ }( s2 F* P0 t# i. O
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
4 b6 k5 Y& a4 h* i, `
/ l1 W5 P8 u4 k3 A[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
0 I* z9 G4 c$ b0 V* P5 t
$ U1 q5 e' u2 NN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& E3 y4 s/ }& |) I  D
( b# \6 G  y' e" G3 k& A, C8 r4 z'{$ElementUpgrade}', '{$ItemPierce}');");
( \5 g3 k# j7 E7 Y}

}

: F  o* [7 z& n/ Z  I}
; K8 z: f: I" y, E6 ]; Y* O! G( v3 m
9 ]4 J7 f1 f. K' E! d4 t$InitForm = InitForm();
" |7 M/ |+ w( \" i; C! S( y9 q$Listener = PostListener();

?>




& e6 z+ M) I' w