物品发送脚本

admin

<?php
4 p# p: G" u( s1 |2 b1 {% gfunction Connect () {
: o& W$ [1 G9 C% |/ Kmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
4 e; D# S, g% K6 h' J
$ I5 k1 e) |# a* I9 q% GFailed.');
: B& R4 R) e4 I" C* K9 x}
) [2 ]: @7 f& n" MConnect();

) Z( c* ]" U! W* X9 K! m( g) P/ rfunction InitForm(){
  v1 }# g# p3 O8 K//layout for the form
, U* l6 o0 T  M/ _' G* recho "<strong>Send Items.</strong>
<form name='select' method='post'>
. s' g1 \7 x5 m<lable>Character Name</lable><br/>
" C) l4 H8 l4 E<input type='text' name='char'/><br/>
  o; d! e' S- J+ e  O<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
1 G. o: M: T" U/ e- `! n<input type='text' name='item_name'/><br/>
' {: o4 L" V) ?% h5 i. x7 o<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
6 t: ]* {, k+ d/ Y5 V8 [- w; ?, V! e<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.)
% t$ `- }2 t% [3 v9 h; B
1 G. D7 y2 R9 L+ n</lable><br/>
9 }  X5 }+ ^  ~<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
5 t5 }: [/ I+ C! G; I<lable>Pierced Amount</lable><br/>
, [) g/ H' Z9 H2 P+ Q& a8 ?<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
/ M/ Q" p* T1 A) I</form>";
}
  o$ T  [$ M( t9 \5 }
) ^# s4 x3 g' `4 K4 lfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell
1 d4 A) R. {! K. @" {* y1 H* Y  V
; ^" N( I3 R! \/ D( w################################
$ d. H! T, P% R# |& M+ X0 ~! ]##### Connection and Post ######
################################
5 `% A' M& v* D$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
2 p" ~( b4 W( g% I. d$ItemAmount = @$_POST['item_amount'];
" C1 u* Q7 F9 J1 c2 M6 u$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
4 m% N" N; v& V" _+ B' _4 o################################
  i* O1 J7 w! n" ?1 B5 ^% v2 e- n
//Check both variables for empty value

6 d! t" ~$ [1 ^- h6 ?& eif (!empty($_POST['char'])){
. i) V/ u& \' K( H9 A9 U: ~$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
- {1 Y/ R9 K" e, k' r( m/ K9 D) l
& k8 ]0 t4 J+ S6 u3 [4 a7 S7 Tm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
, J* @" {7 j+ P9 wecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

: ?8 B( z$ T% c8 S[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

2 ?" [! h8 d- B! UN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

" `6 _0 H1 S6 h3 H0 K1 W3 F, E5 W'{$ElementUpgrade}', '{$ItemPierce}');");
}
* c# n. X, h  @2 ^0 g5 F0 T
7 ]; b6 q% S$ D}
6 @* B: D" R* M: a3 ]5 z
# |2 E, V7 a6 G5 b* F0 u7 @4 |1 j}
, ]  e4 o) U; ?. ]' L5 o
$InitForm = InitForm();
$Listener = PostListener();
; x0 C% T  h+ D
?>
# u, K1 r, O  V4 e5 U
! _1 K0 o0 E4 F! n# R( a5 G4 `. r
) i: w7 L1 R8 [, \+ e! @: A, j
. p8 c: q  d2 k' d$ f