物品发送脚本

admin

<?php
$ G' c, J7 l0 I1 V# Zfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

/ C/ c& Z3 o1 s) ?6 n& JFailed.');
! \) }; c4 t; `* Y}
. w& z/ O& T3 ?- `Connect();

function InitForm(){
//layout for the form
, `2 F5 F, ~/ q( M6 p, \echo "<strong>Send Items.</strong>
<form name='select' method='post'>
2 p3 Z7 f, w2 t6 B: N0 M1 |+ `8 n<lable>Character Name</lable><br/>
  W% s+ |, `3 R5 V# l+ h) v<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
9 ~. p6 p! z# a1 Y* @  r9 a<input type='text' name='item_name'/><br/>
  V7 ^7 e/ f5 ]<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.)

3 d' o% q$ r, J9 c7 S</lable><br/>
4 X) Q& ^' u7 J( R* p% H( D# a# U<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/>
2 d  {7 \2 E/ t) f9 v0 m9 S1 i<input type='submit'/>
</form>";
7 O7 n6 c1 u8 H" }9 x: f8 b}
! s& j2 e! E# t0 x# Y7 O
! c3 j) T0 t9 y& _function PostListener (){
+ l. ^5 W! I9 D% j//Add more post variables if needed and add them to initform() function aswell

################################
3 h" z- \2 ~. a# k& A# e$ U##### Connection and Post ######
2 J/ o. V2 i; |################################
9 Q" O/ _0 i& \$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
: A% J( |3 x& {# A2 c/ H- u$ItemId = @$_POST['item_id'];
$ ?( a* G! U$ B$ e" s$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
9 P# {$ ]0 e1 I+ A9 N
//Check both variables for empty value
3 N+ S' S) T. ~
if (!empty($_POST['char'])){
. U1 S: [6 j; \5 K* Q$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

: k8 Z8 a9 t- Y& z' Sm_szName = '{$name}'");
9 h% n+ m, O1 Dwhile ($row = mssql_fetch_object($find)){
; p' v$ t9 W+ yecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

$ t# V; _5 l" F& r2 Z3 Y9 ][serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
) `. D, h. b! s: J. S
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% ?# _8 ]/ H' o) p' V" v" y
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
+ I. K, U* \" E0 Y( t
3 ^; _" M, r$ i9 Z9 J' R! u'{$ElementUpgrade}', '{$ItemPierce}');");
}

/ j7 E8 _9 f) J6 A, s  N  r}

}

* J  D9 I- I) s& E& Z$InitForm = InitForm();
+ O- K* u' A9 y0 o+ {4 h* b$Listener = PostListener();
0 a& k. ?' @6 r, X' W- T. _. w5 v
, w2 Y8 O3 C8 G) E# m?>

! e6 L1 E$ L+ B1 H+ A

* B1 ?# W; {( P+ H3 n4 W3 n. s9 ~# X
) h  k( E8 E( N