|
|
<?php; |) Y9 E |2 [9 B0 j. W. q
function Connect () {) d/ u5 R; `% T- e0 y3 W* W* ]: G
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB & N) @( s. X& h( Y. Q% t
# C( J' N2 z* |; k
Failed.');% p; m9 K' P5 `
}
( F; J+ ^0 m9 q. ^) a3 PConnect();
; |2 ~/ {3 D" a- t
( k8 u1 \; X1 j: n: I ~# y, [4 vfunction InitForm(){; j G2 C' n9 n0 w
//layout for the form1 A3 h* m. j* W& F, Y4 F$ t
echo "<strong>Send Items.</strong>
" \, y) l+ p/ l! [5 q<form name='select' method='post'>
9 ^" c. `( Z0 M) p G, d* l<lable>Character Name</lable><br/>
$ s2 D4 ?% o2 k/ e* R<input type='text' name='char'/><br/># T* n- w3 |0 W
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>. H- ]5 R5 c+ o& Z( {- C
<input type='text' name='item_name'/><br/>: s, R7 `' S/ a7 y
<lable>Item Amount</lable><br/>
2 P p' @% ]* t; Q<input type='text' name='item_amount'/><br/>
p6 i) w& _9 K# I0 `, C: c% t3 y<lable>Item Upgrade Amount</lable><br/>
( q1 c- e" [8 Z% [' ^: L) L u<input type='text' name='item_upgrade'/><br/>
# ?1 D- k% j" j1 {# E5 _- u. U<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
8 U/ f4 N6 B9 n
0 U. K% b6 o1 f, ^</lable><br/>. {5 I% u5 P6 S8 f; p4 c& {
<input type='text' name='item_element'/><br/>
: x! Q. ~6 l" ?4 @( G+ l. I+ P<lable>Element Upgrade Amount</lable><br/>6 K: D* E6 Q% y* S, B" f& j
<input type='text' name='element_upgrade'/><br/>
% x; X- p3 I- ~# ?; c( E2 u) a<lable>Pierced Amount</lable><br/>
/ X$ }0 D/ K8 P9 W6 \ H6 {<input type='text' name='item_pierce'/><br/>9 W, T. r E. U" A& m. s
<input type='submit'/>$ H9 g5 t, O1 Q' |7 \) P
</form>";# u: _1 S" Z1 D
}
# `3 q: i! Y2 _9 q9 X( F1 u- G8 c7 H9 s* M* |$ T- a8 F
function PostListener (){ C/ \7 `2 f. M2 d
//Add more post variables if needed and add them to initform() function aswell
$ n" c4 a0 ?: E( ~ P1 S; B* B- K3 a/ j
################################
* C8 t5 E' U- ~3 k( v: o7 a0 q##### Connection and Post ######
5 p% A0 b* t$ J1 \8 u; |################################
' A; x: G5 m# S9 [+ u; J/ i$name = @$_POST['char'];
, a! c$ z& Q8 Y! J/ N% X$ItemName = @$_POST['item_name'];; _2 J3 r3 g4 j* E2 s1 f S
$ItemAmount = @$_POST['item_amount'];
8 ~* t6 f3 ~& E" X2 Z( h8 E- T$ItemId = @$_POST['item_id'];
* I9 A2 \7 p$ F$ItemUpgrade = @$_POST['item_upgrade'];, q/ E9 ^2 ?6 s( N% i
$ItemElement = @$_POST['item_element'];3 ], z. _% P# g# W E, ~
$ElementUpgrade = @$_POST['element_upgrade'];& C5 e2 `* _: l3 d
$ItemPierce = @$_POST['item_pierce'];
% i7 ^( p, K e \- ]9 T5 C2 R" d################################
W ?! N. K" V% u( C1 w/ u$ G- X% o! H" q
//Check both variables for empty value2 P! ?6 n& W- P# k
$ h- {0 _- o+ } G, h2 Jif (!empty($_POST['char'])){( Y& J' t: i1 d+ ?8 k3 A. L+ T0 @
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ; c* W, v2 c' U7 V( M, Q
* v$ e7 [# s7 d8 W3 T( c
m_szName = '{$name}'");
& j T# p6 `) n: C& L0 U) j$ x8 nwhile ($row = mssql_fetch_object($find)){
2 F6 r4 f z7 j- Q6 Q7 ~echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
( ]4 U3 }9 u% m% ?* _$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], # Q$ P5 v* v# J$ o
. m0 i# g' G& l: ]- L& L( a5 G3 y[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 6 ]8 @% h- g; H5 q- Z0 F9 O. S
4 g2 C- n) H" T5 Q$ K) `
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
8 P0 s3 Q/ P; M9 J3 Z
% p: z8 h% D2 }! E8 b$ n4 yN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
) U& c: A8 H) H; j' P. M9 k8 w, a- z9 _ l# x( G7 c
'{$ElementUpgrade}', '{$ItemPierce}');");
% J c f; J( C7 C6 O5 y4 D( u}
3 u6 v: E3 b; ?0 P$ h) q. {8 v& n) I+ h8 I" ]' j8 l
}7 F4 s2 \( q: L1 B
1 R4 ^7 U7 ~4 A. B2 m
}! W) S5 f' D& J0 Y) m0 c8 U
: R" _8 }! m+ B- G5 V4 I% d
$InitForm = InitForm();% j% F0 _2 n; p5 ?
$Listener = PostListener();
* p2 j5 @, O& D. s9 B5 d8 u& @
c7 L9 e7 k: z: c2 Y* W?>
1 M! G9 G- M( I0 I! k
P7 Y4 p6 W ]& E- \$ Z& u# ^
, u, O& d' H, Z/ I! U4 V4 T
1 I, H) i, f+ D. P7 @3 F' ]3 T" c* ^! Y X
|
|