|
|
<?php$ q( H# X" e( M1 B$ i8 o
function Connect () {
# ~7 Z9 s5 d" A6 r' b/ _$ dmssql_connect('Server','UserName','Password') or die('Error: Connection to DB : V* E! w) Y; F
1 H" O8 s2 e+ V6 P7 T( M+ ]) x) \
Failed.');1 B, o2 b& I! W; h3 ?: C
}
: B; Z6 `: T* J8 S @% j- oConnect();
1 l2 M( P8 s& b. B" w" j; D* S! `; P3 p$ U
function InitForm(){
y; e( a) C1 n, F# {//layout for the form
; G( ?5 T8 D( L+ `$ C3 O- \echo "<strong>Send Items.</strong>
: D; t8 c% k' _2 [<form name='select' method='post'>
& |* B" ?9 f0 O9 ]! k7 B0 T<lable>Character Name</lable><br/>
0 P; F. G, I5 h, c; ~' _<input type='text' name='char'/><br/>
# l0 H6 L3 ?6 S) F<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>8 D" q5 Q7 v! u K
<input type='text' name='item_name'/><br/>3 o/ k& d Z4 l2 ?
<lable>Item Amount</lable><br/>
, U- X. X$ [8 _" M# L& J+ r# J5 D<input type='text' name='item_amount'/><br/>! x' e$ a8 T9 |# A+ |& J
<lable>Item Upgrade Amount</lable><br/>8 @" @( A; }' ^3 S( U$ \ b
<input type='text' name='item_upgrade'/><br/>) b6 b2 l& G, E. {* P
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
2 ]+ H# M' @- @5 s
2 v, E" Q' ^" `5 N</lable><br/>, L! a2 S; f% Y! x( e+ w
<input type='text' name='item_element'/><br/>
5 {& y/ I7 R! t+ u0 x' `2 T5 b% ]<lable>Element Upgrade Amount</lable><br/>( s; n i/ t" v$ }$ P
<input type='text' name='element_upgrade'/><br/>
" S6 Y! o: D7 b3 m# V<lable>Pierced Amount</lable><br/>
`5 t2 H4 Y8 e% C3 V8 _* r+ g<input type='text' name='item_pierce'/><br/>9 A4 T! C8 J0 A. ? |8 ]/ X
<input type='submit'/>
) P0 M' y2 T0 {( H, i @% D</form>";
6 u3 p) x% p/ {" d: A+ z, c8 c}
) [% h& r" p- P! _7 j2 k: {. X4 h
function PostListener (){
$ h+ p( K M- A; D: K$ E//Add more post variables if needed and add them to initform() function aswell
; x1 B7 P3 {2 L/ c" d( n f% e
* @% ~' F5 [6 n# i: n# F3 G1 j################################6 M& c; S% \1 g( a
##### Connection and Post ######: p: j4 D2 p1 u# a) I) ^) I. a% B
################################
$ |( q! Z+ z/ ~8 W, F5 \5 b3 u$name = @$_POST['char'];9 |6 w0 n! A8 E! y
$ItemName = @$_POST['item_name'];
& T: M8 N. Q' R3 v6 D4 ^$ItemAmount = @$_POST['item_amount'];
. H9 o1 \, h# L* O. O- {$ItemId = @$_POST['item_id'];. U. r, B! P* T8 a* H
$ItemUpgrade = @$_POST['item_upgrade'];
4 n. i; i9 l) U0 w+ e$ItemElement = @$_POST['item_element'];/ R0 O/ z( P) `/ C5 _3 s) e9 h
$ElementUpgrade = @$_POST['element_upgrade'];
" z) l7 s* @9 Q |! R V* Q$ a( q$ e$ItemPierce = @$_POST['item_pierce'];9 S0 A* w1 V" q1 z4 T0 `2 h2 [
################################2 V' `( C4 s1 u( e- X
3 G+ {4 W, v6 Q. K
//Check both variables for empty value
' E* x- `; I* ]& @4 v% w) `. D# A+ J* t- }7 @
if (!empty($_POST['char'])){/ r9 e' p5 s6 ]* p! V8 |! ?
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 6 q i7 d, c! Y7 c* _
, M, B1 z$ E% X0 Hm_szName = '{$name}'"); M+ d4 V* V5 l* o! _3 Q1 @4 U* t
while ($row = mssql_fetch_object($find)){
1 J8 g& c& Q4 }echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
! S$ ~% I& q1 k8 o$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 1 @' o. w* o5 d' b. \$ Q" W
/ s8 S+ S% Z! _- D1 m[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], " | a. m7 g" v
1 I v# Z, z0 Q7 X[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
* x4 m2 ^7 p9 I7 [, ~# g% C0 b# |, ^2 w$ t7 a/ Y% X1 H
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', $ \, B$ S1 V1 r7 D. t- d
, b7 L( d* |# I4 G6 I'{$ElementUpgrade}', '{$ItemPierce}');");& Z, c! z. b6 H3 S
}8 ?1 J5 e7 E& m4 {: i- C+ [- t
4 x) f9 Q6 j" c" U$ J
}
0 V, E. n. e0 J) S: [ Z- K5 }4 @4 h# j; Q+ V8 }% d
}8 o( t5 K9 d9 _- |
' \0 s3 s* U+ _3 \ @! G
$InitForm = InitForm();
/ o W L- I" X, H' M7 ~$Listener = PostListener();- \8 ~/ s/ U, z
' |( }3 o: B/ H" R?>; v) E% o# j" \% p& T
; }4 c4 Z/ \4 D8 N
% O% G; Y1 A* V9 z: W% F0 x- j% b# I0 ^3 |' L
/ t Z5 K. o, m4 n, f |
|