|
|
<?php
' e9 f9 R/ g8 r- P2 `function Connect () {
- S/ S& y& w ]4 B. { mmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
5 M: b" E! `5 `$ f# [. Q! e8 s8 G4 g2 {2 N b/ {" G* Q! p1 r
Failed.');8 c7 \% B! X8 Z" E* u1 K2 V" Y; ]
}
' J5 W9 n6 P! P" P4 i `9 i) O( TConnect();
$ K* k% ?" b2 X* W! B" d& U+ } x5 g' v9 U
function InitForm(){
% _* q3 t% F. f9 B- |0 v4 @//layout for the form
2 t0 U! l2 m5 W1 @2 U2 E0 wecho "<strong>Send Items.</strong>1 \# U% u/ M& b# N5 ~3 E
<form name='select' method='post'>
5 F" @( \ m7 s<lable>Character Name</lable><br/>
) }! O5 y0 ?/ ^, [<input type='text' name='char'/><br/>
" t" ?! g. y! P) o" ~<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>* k! A2 x2 N: t. v: Q. B5 _
<input type='text' name='item_name'/><br/>, B3 R! J R7 [. G9 L
<lable>Item Amount</lable><br/>0 f' j( f) M4 K& b- R! t
<input type='text' name='item_amount'/><br/>- V6 ^/ L w, b7 e b
<lable>Item Upgrade Amount</lable><br/>2 p( Z$ s- P& y' `/ w
<input type='text' name='item_upgrade'/><br/>/ ~" Z* ?( b% I. V
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
8 X8 p2 A' w% E( ^; `* a, \ F
* V% T. N, z& q7 h/ W3 o' m</lable><br/>
/ Q$ F9 m8 c5 k5 W2 D<input type='text' name='item_element'/><br/>
) p* ]" o6 v1 K$ V' t<lable>Element Upgrade Amount</lable><br/>) a/ `" Q1 o% s/ [; x
<input type='text' name='element_upgrade'/><br/>
4 N+ k1 S; ~& _! v8 R0 V<lable>Pierced Amount</lable><br/>: ^: i% T) q" L+ i( q6 S7 E- b3 | s
<input type='text' name='item_pierce'/><br/>
6 S5 j6 e! i8 v* z<input type='submit'/>1 B! n5 q4 ]: C3 o |0 Q5 F8 p( v' l& ?
</form>";/ X# i! I7 L6 ~6 a; m) y0 W |- F' D
}
" I" F0 p; c N0 i' H/ w& g/ O3 ^, p9 W, J
function PostListener (){
& s- S. K, y$ c; f& ~3 q3 K L//Add more post variables if needed and add them to initform() function aswell6 m% P% a/ Z8 h7 H& c
8 Q: g- n+ I- M################################, Z9 G- J+ C4 N. Y& g7 ?- S# t+ w
##### Connection and Post ######
8 v: Q2 f8 v9 M7 p' _7 k################################, j0 j# e& o% }/ n
$name = @$_POST['char'];# _& {$ A) v: i5 E% t1 I1 v9 }
$ItemName = @$_POST['item_name'];
6 ~# B* I) [: n$ItemAmount = @$_POST['item_amount'];
8 o$ E) R& |7 q, ^5 ]$ItemId = @$_POST['item_id'];5 f8 m! p7 _+ B' \# S m
$ItemUpgrade = @$_POST['item_upgrade'];
; J& ~/ U6 ^, b% m" J9 p. ?$ K! c$ItemElement = @$_POST['item_element'];5 n7 j& M6 h) g
$ElementUpgrade = @$_POST['element_upgrade'];2 s3 X4 N7 P8 Q
$ItemPierce = @$_POST['item_pierce']; D' K: }/ ~- k9 G7 ?1 D' _% r+ y+ x: b
################################ s" V7 R7 \4 |# H d1 N
. M1 g% u3 u- I' D/ ?* ~5 L
//Check both variables for empty value
9 Q3 K2 e& T7 ~; W. v
5 |: c/ i. `% W- G, Aif (!empty($_POST['char'])){$ a# i4 z( A# A5 S: s# U0 ?
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
3 Q6 V: h% C) c9 L6 c
2 t q- b/ z0 T: Q! G; J" ym_szName = '{$name}'");
, n3 c* P/ A/ g1 Q, y9 L8 pwhile ($row = mssql_fetch_object($find)){; G0 i# x4 v" W. G5 m" t0 P% ]
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
! H) k7 ^; f) _5 k0 D7 m5 h$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], $ ~# h: k* W" [3 _
+ m( q9 h2 P, U[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 8 D, K8 e! |& V; }
9 s D6 _! \+ b: X2 [[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', * @+ i+ t# g4 K3 o6 H: G. [
# e. T* j7 @# Z/ j6 zN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', * T9 F; i5 _+ B+ P/ H7 ]
) y4 u4 M# C( Z/ X; x8 R; R6 X
'{$ElementUpgrade}', '{$ItemPierce}');");& Z. V- n# D2 X5 C8 S6 Y
}* t9 u ^6 Y) i1 ^/ }0 C. X' _
5 n: C" }7 W \; K
}
/ A* G( v0 r' A+ I& @: ^
2 V, B; A& ]; t}
0 l/ d: ^" `* q' K7 O( \8 v8 u
* M7 K2 P( U5 [2 Z$ g6 D; C; Q$InitForm = InitForm();
) z& P6 G) A; p0 K2 L$Listener = PostListener();
8 x- ]3 c) d, z+ w/ E; b. X
) t3 k ^$ v9 ], Q# O; c?>5 b0 o1 h/ X4 J8 m+ r( t/ ?
' N: M! ?) L, v) `) J, V
5 C. \: M0 o! X
O2 @. g9 f* U& z; d
/ ]7 V) m4 |" u: P7 E( N |
|