|
|
<?php" {& B7 E! l7 X i3 `, M0 W! k
function Connect () {0 `0 n: M0 U8 L* q. J6 c x
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
8 i$ b- ~# f/ @) ~- y4 r) k
) q. z" Y& ]) Q2 u, \Failed.');; }3 s% ~& C- K3 M! V" c1 v
}* A/ c" T- Z4 g+ P7 T
Connect();! G2 U& R3 z4 L! M$ f: N* L. Z
( G, B; S. k1 }8 p& P, |
function InitForm(){
" J; w+ f6 d* o% M3 X//layout for the form+ e7 \ U, v' g: i9 |3 P( T1 |
echo "<strong>Send Items.</strong>
9 p8 i, |1 }" q8 H) p7 e5 D<form name='select' method='post'>
( T3 B. c6 ^7 L' s, u<lable>Character Name</lable><br/>
0 g4 A( A5 _1 l+ m- o- X<input type='text' name='char'/><br/>. L* J: H2 s$ k+ Y* z
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
! ]* s# O% H& ]: r0 Q1 R. r+ C<input type='text' name='item_name'/><br/>% f3 `7 Q& h4 [2 A& Z
<lable>Item Amount</lable><br/>; t2 H5 { q: l0 ^3 l- W" L3 {
<input type='text' name='item_amount'/><br/>
7 U& b; F* E6 ]) |: B# s<lable>Item Upgrade Amount</lable><br/>
8 @& m) W+ {9 o7 {' H4 y<input type='text' name='item_upgrade'/><br/>
* }' b5 `( Q( f% \3 `<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
% l0 P( Q( F# p- i0 ]% R5 i! h% b- ?/ `$ k* Y! M0 I. D# W
</lable><br/>( @, Z( ?' r0 Z; g
<input type='text' name='item_element'/><br/>( `3 Q Q: S0 i) M
<lable>Element Upgrade Amount</lable><br/>: V# d2 h" D1 |$ I4 [7 f
<input type='text' name='element_upgrade'/><br/>
0 Z. t0 A; \. Y$ L7 h<lable>Pierced Amount</lable><br/>) H5 @+ [) I$ f( @% m/ G- E; G, F
<input type='text' name='item_pierce'/><br/>1 S, r H y- N7 Z
<input type='submit'/>
' } P' q$ t3 K% D. b# c</form>";
; X4 a* ?0 n: U; A3 ~+ T1 u l}
9 @- ]" a& M S' t3 ^# l' @$ v) |, l- F5 m+ u
function PostListener (){5 C3 X0 y S2 O, i6 i2 U/ f1 _. O
//Add more post variables if needed and add them to initform() function aswell
& W- W, B+ Y6 w2 V$ [; |" e6 w& M& g( C
################################1 I, f; r0 \4 P
##### Connection and Post ######
1 D: [0 V5 t: h# A' J) s################################
% R6 `1 o, V- ]6 P: d$name = @$_POST['char'];1 c' |* {7 Q6 m; n! D! r
$ItemName = @$_POST['item_name'];1 E% R6 ]3 i/ D/ _
$ItemAmount = @$_POST['item_amount'];4 r2 S) X) r& ]
$ItemId = @$_POST['item_id'];
9 c3 V- I' J' Y7 ~; [" ^- F$ItemUpgrade = @$_POST['item_upgrade'];6 l" Q( }# V! t7 k
$ItemElement = @$_POST['item_element'];. h. }1 \$ {* u9 J, j7 a w
$ElementUpgrade = @$_POST['element_upgrade'];
7 T1 s2 d ^. |$ItemPierce = @$_POST['item_pierce'];' _4 q8 I# B1 ?* m% a4 a7 J+ R
################################( [* g+ E) ] ]5 q
" P) [7 k) a- b; _
//Check both variables for empty value
5 }3 r5 u2 {+ T8 _* Q4 g
1 z# \8 j8 a7 Aif (!empty($_POST['char'])){; H: E9 n7 j1 x: J. Y/ o# x
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
% c! O/ S3 H0 T9 Q0 ]- ~- E* o T# G: i
m_szName = '{$name}'");
9 A3 a% G0 E* m8 F. {2 iwhile ($row = mssql_fetch_object($find)){
7 k& [* N0 f4 e* t7 ~4 aecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
5 B" |. q7 X7 \4 n" ]- F$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], : V: E$ J' u& I0 f1 p W ?
! ]. ` t3 v; w6 ~
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
* N3 w8 ]& {! A- ?' m! u% e! x. |* x8 y. ^' p" _9 h
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', , ?9 M* D# G* G }8 J9 x6 q/ Z
7 Q- P+ ], B9 R# }8 h! p
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 j2 k6 ^1 I9 f8 \% o. p; Z- g: F0 u
9 @$ C2 J8 p& D% p& N'{$ElementUpgrade}', '{$ItemPierce}');");
/ D" {; b3 D* I% m}
% F& [3 f1 O) R- g3 Q
! ^( u$ p. s; u! r4 D/ o! Q- P}
+ t: b2 |+ R9 y. ^$ Y0 \
/ r3 x0 K$ Y$ a0 W}
- W* g' @+ o* d _
! d1 C( ^5 } V" _6 i* H3 J$InitForm = InitForm();
( t" O+ O8 e E" l" c. Z! _2 B8 y$Listener = PostListener();. C, P4 j& i! e% a
- x" Y! v0 [# v" u, F: O?>! R ]' ?! ^. h
3 L$ ?. z" R& k5 X! w3 r; R2 ~' _6 Y# A, A" \ s$ @% \' f: d
, g1 q. r/ T8 ^% ~3 @! ^: _! C/ Y7 c1 |/ @! f7 P8 Y$ G- h. R) j
|
|