|
|
<?php
6 z9 x$ V5 |5 g% \: xfunction Connect () {
5 O" b& `# R; t# ^0 ymssql_connect('Server','UserName','Password') or die('Error: Connection to DB & V9 I% J( ], k1 J3 w
# K- d9 X1 B" Q% K* bFailed.');. t, x6 d: f9 p7 J, t2 f* g
}* ?0 C: E+ Y% u5 ^
Connect();: R u- @, I# f/ h
4 C6 T( L4 [0 P% f) _6 ?function InitForm(){! I K9 v5 j# R) P8 t$ n* }' [! d$ y
//layout for the form$ B4 p* `" L7 i- B0 T0 r$ W5 `
echo "<strong>Send Items.</strong>
4 w2 O6 k7 w- _! o# e<form name='select' method='post'>
. K: N+ r+ A+ j# }% h+ N* q<lable>Character Name</lable><br/>
3 N+ A: S! K1 E, A1 d0 q<input type='text' name='char'/><br/>
6 f7 ]; |3 j& [9 C, y+ X. `<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>* ]/ R! W' @. S! V& C# d
<input type='text' name='item_name'/><br/>
. G- C& n" {" n<lable>Item Amount</lable><br/>
" ^( p3 l. \8 U* K) ?<input type='text' name='item_amount'/><br/>
4 m1 j+ l+ m7 |<lable>Item Upgrade Amount</lable><br/>
; Y# Z& O5 |2 q8 G<input type='text' name='item_upgrade'/><br/>
9 w! J6 f3 u- s& ^& p9 }3 J<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
9 i" h; ]5 S9 Q
* |5 a9 y s1 U</lable><br/>
4 t0 Z; F, y) D& l! h( a<input type='text' name='item_element'/><br/>4 B* E5 g: i5 Q2 w8 s
<lable>Element Upgrade Amount</lable><br/>8 ~1 c5 m+ K9 v: i" _0 x
<input type='text' name='element_upgrade'/><br/>
! K E/ }: k4 ]7 U6 q<lable>Pierced Amount</lable><br/>/ B; @' }2 A3 H: _: q# _: n
<input type='text' name='item_pierce'/><br/>& U8 W$ U6 a" U! I0 G8 w
<input type='submit'/>
! m2 `9 R* s( J" S6 C, n</form>";( z7 s5 G& A2 Y6 K
}: ] y3 _, D, @
) g! T* y+ p( A3 Lfunction PostListener (){* a Q. j! G3 X- X+ |
//Add more post variables if needed and add them to initform() function aswell- [# R4 ~$ K) K+ z
4 |! R4 J1 @* S! ]( z0 ?4 ~
################################
/ n9 m, [6 w8 F& l6 T) [" G##### Connection and Post ######
# g0 b: U: e5 b5 C################################" n1 O9 l% d" ]' ?! r
$name = @$_POST['char'];
( Y) S2 W! `' @# F) {! V& V$ItemName = @$_POST['item_name'];9 v' k$ E; C# b. {* H1 ?
$ItemAmount = @$_POST['item_amount'];
) N# S1 T( ~; [2 P$ItemId = @$_POST['item_id'];
2 \' F0 z7 f' |% E7 {, D" ?$ItemUpgrade = @$_POST['item_upgrade'];# U( y$ e0 C: @4 s( B+ F
$ItemElement = @$_POST['item_element'];( S ?/ h, N; }) t9 M8 V
$ElementUpgrade = @$_POST['element_upgrade'];
" N6 \8 `2 h9 s1 ?$ItemPierce = @$_POST['item_pierce'];
# Y' u$ v' E( x8 }" S- s################################
2 Q; k T6 e; b: g# Q0 c9 S9 [( N: R+ F$ Z3 F7 Z$ q
//Check both variables for empty value
$ I% x9 l; F6 y1 T2 a- ?- Y. w$ o: |
if (!empty($_POST['char'])){
0 q1 n( j- ~; ^! T3 o3 {6 I$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
) b3 i4 _& Y5 m8 Q$ r3 p, X
1 V. Y: y5 F8 S! K/ fm_szName = '{$name}'");! ?% s: _+ h3 D$ d( W. C9 O4 u
while ($row = mssql_fetch_object($find)){
/ X: v9 Z r3 Z2 D2 Mecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";3 E2 i- H( x/ `, Y* ~' a# ?
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 3 h. w1 `: `6 Z6 Q
; Y _+ a2 F- B! K8 D, S
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
9 R! d8 _/ ^' G/ k- K- r8 [5 F! H1 C, I q/ X( T M
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ; |' Q( t+ W3 `5 ]
5 T+ n& p/ D( P5 K* qN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 9 e4 d8 P. F4 m! K2 S1 W9 y; n
, ] e' X! ?3 x1 {2 b& L+ G'{$ElementUpgrade}', '{$ItemPierce}');");, S' a8 J1 O) J! H$ C. i
}
5 h9 _# s5 B# c. x% O4 X4 X' R( C! R+ c& a% y7 H
}$ g1 `' {( V9 C- z' C! a
1 J; S+ K6 E! ]* O* u4 f& S' b}
8 o7 ~ ` m+ ^7 r; ~$ R/ T8 d: e% r3 k
$InitForm = InitForm();- J8 B8 l( R9 e% p1 x0 I
$Listener = PostListener();
y ~* U5 s9 K* W" v! o
# a; C* i. l; ?- z( ^/ [# I9 _$ Z?>1 z: [* p! h' U+ I \3 f
2 ^0 u( ?* ^: w! t, l* i) h4 {+ Q$ I* O0 r# C- O+ O9 [4 o
7 q }; D6 c2 A" \8 N
: F6 {3 Q; ^2 j- ~$ Q) w# ^ |
|