|
|
<?php7 D) R# Y. ]+ Q/ B" Z
function Connect () {
9 d; b6 r# U6 ?3 ^9 B% ^mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 9 z; [. V7 v! V& ]% Z* e, j
6 r9 v9 k6 S- j7 D3 \8 Q3 R
Failed.');
2 z4 l M S) J4 D}3 c/ _6 k D; f& A3 q$ L" q
Connect();- f+ W. L1 T) m9 C! y
. C) }5 }4 N: L/ o- zfunction InitForm(){: Y6 B0 ?; x$ R0 C
//layout for the form$ d9 A" E7 ?1 i0 R3 ?' C. E
echo "<strong>Send Items.</strong>
" ^) a; K x. c* E# `<form name='select' method='post'>0 `8 B) `6 M+ u# |1 C
<lable>Character Name</lable><br/>
' V. r) c9 o; }8 T) |<input type='text' name='char'/><br/>% d/ M4 x8 I; O& t5 r9 ?
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>. E1 M4 w2 h, j' m% C; a) m
<input type='text' name='item_name'/><br/>
; ]6 O5 S" W0 A: S6 @<lable>Item Amount</lable><br/>
4 ]4 ]& `0 C0 |5 q9 l7 R<input type='text' name='item_amount'/><br/>
, Z/ m& b+ b0 o: L* f& c<lable>Item Upgrade Amount</lable><br/>) T) I3 k: k M2 ~" V
<input type='text' name='item_upgrade'/><br/>
( p* G# y3 N6 E( [; _) W- R<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)( A3 w. P) R. ~+ v: ]
0 |9 {. x/ k; b, }4 F9 J- t
</lable><br/>) r* C7 L$ G6 D% W' B: {
<input type='text' name='item_element'/><br/>" |. M7 }* V. |7 n
<lable>Element Upgrade Amount</lable><br/>* o3 u3 O9 z* ^1 n4 @7 D0 M' j
<input type='text' name='element_upgrade'/><br/>2 y8 U. K& Y. ?# T0 |! w1 J
<lable>Pierced Amount</lable><br/>
4 z3 F; M7 O1 ^' @' a$ ?<input type='text' name='item_pierce'/><br/>
2 w$ O) u( f K2 [$ e4 [<input type='submit'/>
4 ~( i) N& A/ [% w4 O2 Z- ?</form>";
. i$ u7 ~' |! M( |' p1 I5 \3 f}5 S# I6 u- E8 u8 g
' d4 i% Y5 Z+ ]: T6 Pfunction PostListener (){# g+ p! T$ U/ ]( N6 r
//Add more post variables if needed and add them to initform() function aswell ?3 o+ F m/ n: Z
) P/ c1 ?" j; K' m# f################################0 L7 p6 l5 L' {7 }. i0 B
##### Connection and Post ######
+ @, B# S8 C4 u################################
$ u" m/ q; ?' f" P5 x1 x$name = @$_POST['char'];
; a+ r+ _7 u6 Q5 s' O `6 Q$ItemName = @$_POST['item_name'];
0 _* n" h# p! A) c) S$ItemAmount = @$_POST['item_amount'];5 @ v* Q0 x0 D3 W5 d, V! C F: G) x+ G
$ItemId = @$_POST['item_id'];- `$ N3 a& p' _* f, k/ e& s
$ItemUpgrade = @$_POST['item_upgrade'];
6 l' X9 K6 ~8 A4 X6 L' v7 H5 D$ItemElement = @$_POST['item_element'];
3 R9 `/ I" y5 d4 `. p4 H$ElementUpgrade = @$_POST['element_upgrade'];
0 L, E0 d2 j2 J5 e5 q: N$ItemPierce = @$_POST['item_pierce'];
b% N9 r, U/ e- R* V ~# ?################################" R. k! a1 ^$ ?. S- c& S- E; X
Q; M( F6 T5 J6 I1 R4 W4 r//Check both variables for empty value) m3 F7 R- g2 i) i
) ~$ \) _& @, x6 Z, Qif (!empty($_POST['char'])){! Z* B2 G+ s9 g3 U
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
' S7 Y( s/ I$ n0 g6 Z. K, H
6 \( d2 | W6 K/ X2 R, |m_szName = '{$name}'");
' A- L& ~ e" P3 s' f; Mwhile ($row = mssql_fetch_object($find)){
$ E. O0 \ d+ Z. x" {9 s1 P$ wecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";% b; \6 F9 l9 M; e0 g# H+ K1 z
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], , a2 Q" d; x' V4 e/ Q8 V
5 ?6 ^- S8 C3 T4 f3 c* G2 n[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
. b+ f" C# ]2 ]2 U' A3 j0 b' R& j& z6 C' \
" u0 A: y6 O0 Z0 s[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
, p- H- k$ p& t6 S/ ^$ o2 L7 Y0 H: T A( x- E) b
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', : N1 |" c/ o1 F2 s) a2 m7 [
% \- B! n; L; e* Z$ L
'{$ElementUpgrade}', '{$ItemPierce}');");+ x$ z# r. ^1 Y" o# Q
}4 H) A( a, ^! M) L5 }5 X
1 W) _8 G1 x, f# U' Y' C
}
9 u- p+ B7 H |( C3 t! G3 z8 X1 f" Y4 n( Y" L( y
}
; P" w# @0 T; D1 l" E* E4 s8 n0 R' `) n8 |* S
$InitForm = InitForm();
# h. m; Z" y- @3 z# ~6 A; d) Y$Listener = PostListener();5 b V2 i2 y, w! x
; O$ H! q- u% ~, a+ |5 |
?>& y+ |4 N" o; e) }6 ^- W
& ^. k. }9 q& h" g- q
3 W$ C& Y9 e8 C" {( C3 M! w- W5 a
1 ?$ q! d4 @4 W G3 R
" w; N1 Y, L: Z# v9 o" T |
|