|
|
<?php
7 F# u5 \& a1 g# T& L! s1 U% ]2 \( d: Jfunction Connect () {: ^, }1 G8 S! Z) ]3 r7 ~9 q) O
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 8 x7 E8 n: b/ x& O9 q/ C
8 ?" _% ?0 t& v6 l
Failed.');
5 w6 O; x6 q) S6 p, i}
. Z. c: K% Y# i' S- z* h4 |' cConnect();5 a6 J7 I' q% Y% p. h. b
8 z: w: y+ {* z8 hfunction InitForm(){! ~' G% [. N G0 J
//layout for the form
! v" Z; m9 N, lecho "<strong>Send Items.</strong>
8 I7 i$ W8 L* j8 u- W: a" q, [<form name='select' method='post'>8 C3 _2 R# J' M# f8 }, H2 |
<lable>Character Name</lable><br/>, p1 W$ B2 Y, J, B; o# L ~
<input type='text' name='char'/><br/>
+ V4 z2 a* W: r<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>/ S! E; X! d" `: Z/ u C
<input type='text' name='item_name'/><br/>& u! \, P# E) p( L! N: }* T
<lable>Item Amount</lable><br/>
( R8 [) i9 G3 i; P& M) x<input type='text' name='item_amount'/><br/>; i. x @3 g" t a& q
<lable>Item Upgrade Amount</lable><br/>
0 s, v* ?& Q7 @# u" {<input type='text' name='item_upgrade'/><br/># U5 R# N4 v" G
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)2 A% U, f, k9 t) y# J/ B( A# o
7 g& E/ a8 ]; F3 o* u" V; b
</lable><br/>! S7 ?' A" }1 j9 ~1 F8 @
<input type='text' name='item_element'/><br/>8 g5 c, \1 X. u/ q# D$ W
<lable>Element Upgrade Amount</lable><br/>1 |. ]' u1 ]* i- f
<input type='text' name='element_upgrade'/><br/>2 z8 x+ k5 i1 @3 L6 i9 F. A# q9 U
<lable>Pierced Amount</lable><br/> }+ n$ X/ o- D; W
<input type='text' name='item_pierce'/><br/>0 m0 C0 I- F+ M, e
<input type='submit'/>8 S+ w; F. H+ g9 u! F5 N" \
</form>";
* A2 f+ O& ^) D, E}
, ?3 U+ B& o8 k" J# c, K& M y. p& J* N
function PostListener (){
3 l Q$ l2 i) e' R4 H) ?% Y//Add more post variables if needed and add them to initform() function aswell
, |* ~: w d) q S9 ~- b! `4 B
- B3 @. u% i3 l+ j4 v! B* f################################
, q4 {- ?8 j- L& e5 K5 M% m9 W% W: C##### Connection and Post ######! F# u3 d5 `& E
################################
, d$ c( \% H7 y ]( S3 `$name = @$_POST['char'];
" c( V8 _9 f3 D. n F' Z" C1 G$ItemName = @$_POST['item_name'];
( T( f, s' h8 q5 N" m+ Q# I+ R1 S. ^$ItemAmount = @$_POST['item_amount'];
) p8 s! r3 O1 E5 B- r$ItemId = @$_POST['item_id'];/ Q- l* k5 j. @3 O' q
$ItemUpgrade = @$_POST['item_upgrade'];8 I" Z9 Q: z$ p6 a
$ItemElement = @$_POST['item_element'];* H& g& M4 n2 I( B
$ElementUpgrade = @$_POST['element_upgrade'];
" T A. i6 }6 l: J% P$ItemPierce = @$_POST['item_pierce'];
) d1 r0 K7 S' |/ i) g# q/ c; p################################
& j4 s4 ~. h) m& X
( J3 u4 k! _3 n" X2 z//Check both variables for empty value1 ^3 Z$ Y p* C( ]" f c
" O* n# d) F/ i% nif (!empty($_POST['char'])){! k' F& f j, H/ n0 }; `! v
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
5 R2 j4 E- g- U1 p, @. Z8 S, ?5 a
m_szName = '{$name}'");
2 `% O# L; b" B. K, p( C- f4 X$ {# V3 {7 M; lwhile ($row = mssql_fetch_object($find)){
* z2 a2 I: l" A$ I. E3 Wecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
7 y, S8 o2 C* M$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
`% G" d; g' V3 q
3 N4 a7 q/ |- I8 ^[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
' a0 v7 n9 z1 x- j! p7 K+ B8 F6 J M" W; m% }4 B; h9 v
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
+ r0 W- d, y$ h$ k q
* C1 a1 c! ^2 \ f& l! f4 L/ BN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
# o& y9 U [1 o( E' i# |+ D. q- T6 K Z0 R* K# l1 Y1 A' c
'{$ElementUpgrade}', '{$ItemPierce}');");
o$ Y( d4 j) h}9 Q+ b' ^* o. o3 k" k& A
, f5 Z4 X" p) g6 F4 G}
/ t1 O8 ~- L2 u2 a& @- V1 w: }- E# v7 g2 k, @6 U( O
}
: V* |) ]# Z. \" _) G5 U0 r: w. D3 B/ p5 |+ o" o
$InitForm = InitForm();
! V+ [% l# Q5 P0 y+ J$Listener = PostListener();( k* g8 A. W1 D
# R' c0 V3 h, l' b. G: G
?>2 m- s& b3 J" C/ D! _8 o
6 `" I; z; k- A" \: O3 B
; Y) X# y% i; U `& s! \
6 g; h& V; @( @2 C, ^
' a+ K2 T5 ?. {' n c1 G
|
|