|
|
<?php
# M: C4 g3 \8 E; Ofunction Connect () {
' _7 @, \, h' s* mmssql_connect('Server','UserName','Password') or die('Error: Connection to DB ! W7 J: Y$ b3 R' ~' \
+ _" U0 v9 n1 V
Failed.');
3 K X$ M6 \; s+ W' z- d& l- q}# z# }8 Y. W4 v4 R
Connect();
1 g6 H. b! k1 o0 r% I' b2 u
: Y! C+ F; |, r Ofunction InitForm(){
" A: o; q% C% f//layout for the form
# ^+ a/ }: N3 d& ~& Y% B" I) yecho "<strong>Send Items.</strong>/ B' W% A5 \$ A+ @2 [3 B
<form name='select' method='post'>) R% j. g' k7 v1 I5 T# D
<lable>Character Name</lable><br/>
) ]. y) J7 a& W" @, s<input type='text' name='char'/><br/>
: I/ i6 u. D) B6 I6 u5 p3 c<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
2 k- T& |. r; h" p" @0 j, K<input type='text' name='item_name'/><br/>& A' p; t4 s# p# n# K% O t- T1 c$ V
<lable>Item Amount</lable><br/>
3 D6 i6 _4 C% L3 p' ]% \<input type='text' name='item_amount'/><br/>+ a$ |2 s: n! h& i) |( w
<lable>Item Upgrade Amount</lable><br/>; U( s ?7 Y: e
<input type='text' name='item_upgrade'/><br/>9 N, h$ E4 {; |$ D( x; h! I# j
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)' V4 h0 ?2 b! w% g/ w7 S
. d- y0 h. ^5 R( Z" I% m6 o</lable><br/>
. ]2 H" O- j8 S9 f6 q; C/ r$ @0 L<input type='text' name='item_element'/><br/>& r! X$ \& C" _1 A0 X
<lable>Element Upgrade Amount</lable><br/>
& G3 f* O& u2 A( r4 P: F4 V<input type='text' name='element_upgrade'/><br/>
# E: {0 h8 `5 }/ ]6 ^/ S<lable>Pierced Amount</lable><br/>! S0 [8 i; g: g- V
<input type='text' name='item_pierce'/><br/> p+ G3 }! Q: R7 L! K
<input type='submit'/>! D/ B! ]! N5 u1 P
</form>";/ y9 o D; e. d" @
}
( [. S ]; J& n8 b, D$ l1 I3 x
6 o# ~' z- l6 f$ x. L- ]& hfunction PostListener (){- [* N6 |7 \) e* z0 t$ x
//Add more post variables if needed and add them to initform() function aswell
6 U% J O% b4 r0 T' P8 n: \& |6 h i' i
################################ L- X. w( c( n. ^. y1 x0 A
##### Connection and Post ######
* y7 x9 C, ^0 K+ w################################ P- @" U8 h7 A$ d" F3 T% n( P1 g
$name = @$_POST['char'];
6 Y" z) }! y2 B( f3 J$ItemName = @$_POST['item_name'];
# \/ a8 p3 u5 M& p% j$ItemAmount = @$_POST['item_amount'];0 r) M- C" ?; J* O* k
$ItemId = @$_POST['item_id'];" H0 A4 g V) x3 p* s) N2 V3 i
$ItemUpgrade = @$_POST['item_upgrade'];
+ j6 a+ C: q, C: b& j& @$ItemElement = @$_POST['item_element'];; v4 R( {9 W+ R: J1 h
$ElementUpgrade = @$_POST['element_upgrade'];! ~+ V- e6 a1 L2 J; L' k
$ItemPierce = @$_POST['item_pierce'];+ W' \9 e5 s/ h( N/ g j
################################/ e. R2 T: v- u# X& g \" A7 `$ O
. k/ A0 K! Y# U# e. G/ ^8 ~//Check both variables for empty value% h/ b& D; e$ c( u& J7 y# k
+ \5 I- I' ` Q3 z7 h
if (!empty($_POST['char'])){
& b0 P: z: t9 L4 m- w$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
' r5 {1 B# g" B. _3 M0 }, i# |- w' k" @
m_szName = '{$name}'");
$ d7 ]( M- X2 O# g) nwhile ($row = mssql_fetch_object($find)){
; K9 u! b- m& Cecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";& @2 U5 f$ V4 u! i1 m
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ( A7 ?5 L- S$ t, V' N
3 H$ H% P+ `3 E/ v% @# c1 G[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
+ m* J* |: h" Q0 M: p
6 G$ ]. e: r6 _; @. P[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ' Q* Z, L# [0 ]) N1 w4 i# P5 v+ a
6 Q9 M9 F$ P3 U5 T: mN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
* f% T; Z$ A: E
! v4 c) _& q7 K6 k* l' P& \. f9 t'{$ElementUpgrade}', '{$ItemPierce}');");
+ f& q% i @ o3 j}! R) O/ u" O- K& L
1 N5 e) a* h6 } Q}% B3 Q! N& T) _. {/ A7 T" x
7 W6 {& w8 M6 G/ u- n}
) K2 h. M3 j+ j6 N1 p
+ a' g+ S+ x8 \* u7 L- z+ l: w/ V$InitForm = InitForm();' H) I7 _2 b6 [* X/ ]% O. S( ^
$Listener = PostListener();# U- S" `* n2 U# e
3 Y) {# F' c- [2 u' C; C?>
$ u3 v, X& D* W- l1 e/ t0 U* g& |# @9 g5 e
# Y. Y- S; C" H: }7 W/ |+ q
# W# L% Y* l1 V' ~6 \! h! i9 X$ e
$ @8 Z: x6 q7 D# D: d2 C! P% w/ I
|
|