|
|
<?php
6 f7 I7 q% Z' c; g( ^$ a1 Sfunction Connect () {0 @# n" n. K' d4 \
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 7 P: D$ I ?: q+ P
- v3 G" y1 s4 ]6 }
Failed.');
4 `% {- k. @! \2 c9 c$ T}5 f q8 P2 f3 r* I! T# Q
Connect();' f' J9 Y; \+ c* I6 |
6 A* ~, A, V Y8 G$ ~
function InitForm(){
( e. l, Y- |6 |! \/ _$ e- A//layout for the form
5 I# Q; ~, A5 ?' |% secho "<strong>Send Items.</strong>
5 Y$ s+ ^1 f! j/ C) q/ Z$ B, X4 p<form name='select' method='post'>
" m: R7 M) ~; T% i2 F2 b6 q$ h<lable>Character Name</lable><br/>3 Z. P: J' G% ~# K P
<input type='text' name='char'/><br/>. {5 n: p& C7 g' G
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
9 g. E* v9 I9 q& s+ H( @: \0 U<input type='text' name='item_name'/><br/>7 Y# p/ }2 ?5 Q6 e" s0 g1 V
<lable>Item Amount</lable><br/>4 }7 c7 y9 S+ Z# i2 R r
<input type='text' name='item_amount'/><br/>- S! c6 X. n4 z
<lable>Item Upgrade Amount</lable><br/>
) S: h% Q, }3 C3 o% n<input type='text' name='item_upgrade'/><br/>& e$ a3 A% ?& _4 ]7 \) T
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
2 j* B- G# X W1 ^4 N$ y9 ~) ?$ n# n3 I! ^ _, u
</lable><br/>
3 z8 B3 p0 e% n- o, V<input type='text' name='item_element'/><br/>
! `7 g4 Q6 w9 H5 Y- t: E<lable>Element Upgrade Amount</lable><br/>
+ y3 y- [6 W% X* ^8 _8 w0 N<input type='text' name='element_upgrade'/><br/>
0 k; H* f2 H8 d) t' P- q<lable>Pierced Amount</lable><br/>
5 j5 q$ z% [/ L" O" J$ r<input type='text' name='item_pierce'/><br/>7 f0 {$ @% j# p) S9 F0 y3 ]9 u
<input type='submit'/>
- Q' W& D) e1 d" Z6 y</form>";
: y; [* ]( [1 o: w# y5 a& O P3 t}
/ W! J3 b+ p R3 a- ]. F( @
) o& h2 d# O. d' I' u" Mfunction PostListener (){6 M ]' h$ A8 A1 I+ R# Y* ^
//Add more post variables if needed and add them to initform() function aswell) L' o* q" g% y5 ^: X! N* ^ A
3 Y& }. Z0 ~' w################################
' j; B5 R" ?% A: y7 @9 e4 e9 \* F##### Connection and Post ######3 z) u0 l* @, B( S1 N# i8 Y- n
################################
& r B( ]0 [' n1 R1 `% W7 Q$name = @$_POST['char'];
! b+ P" u2 H: O: y$ItemName = @$_POST['item_name'];+ ?1 z* m2 l! A9 p! K
$ItemAmount = @$_POST['item_amount'];( M8 Q: Y+ E( y( [# o
$ItemId = @$_POST['item_id'];
2 C6 }1 [ e$ H# L G2 H, [* M$ItemUpgrade = @$_POST['item_upgrade'];8 `/ y% v3 M" B0 H" [& x& d. B9 e
$ItemElement = @$_POST['item_element'];7 u" I% j1 ^$ m5 T
$ElementUpgrade = @$_POST['element_upgrade'];$ O3 s) N# N% S7 `; R) ^; ^/ X; C
$ItemPierce = @$_POST['item_pierce'];- D. Q+ i, G2 x* I/ m6 f
################################" H5 z. W" A E/ R" E
0 W; E- @" _; t, c" a//Check both variables for empty value
`- m9 V, Q, T1 g
$ _) ?. z7 E6 t+ K4 @. t1 j$ dif (!empty($_POST['char'])){, u" p* I6 i2 k7 u$ b1 C! C5 Z
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where , y. m3 a- q$ ?0 X7 z
' N5 a, J7 Q0 g, b
m_szName = '{$name}'");# N- U# B: M5 v
while ($row = mssql_fetch_object($find)){4 E! e5 k+ A' m0 D; _
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
5 d- g9 F: ~$ ~, W9 g/ ~5 a% j$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
: d( S( |( f$ _5 j: G& G4 X: d$ Y! j% N
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 2 I6 J+ D& ?. Y
2 Q& e" Z- A" _4 T: `" [2 t' P[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
8 _& W3 Q3 u% y: V" L4 d. n4 |) o; N- Y
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
0 {& `. Q1 t( J, l9 _% `
* |6 _: H- u: m/ Y* u0 v N$ h'{$ElementUpgrade}', '{$ItemPierce}');");" Z6 X3 G4 S+ ]. b7 Z
} \7 v1 G+ L# j
& ^3 I1 k6 i) ?3 r9 v! C}
- H( e! a0 B6 ]5 ^, i! D8 S
; s) p7 r n! }8 [9 \! A}
2 n. U& o, H( W- f8 I) E7 y( o* B; ^3 _4 h% O- W
$InitForm = InitForm();3 j) y9 Y+ x% ]/ C" j4 v0 X$ d
$Listener = PostListener();" _1 M W+ ^# }# U
7 `. K9 M' ^5 [6 S0 v- k% P?>7 n9 M1 B' @4 A. z- R- L( R
0 q* R* g& l, V5 f4 f7 I+ s {5 x$ I; s
* U6 V } K2 c* {6 l& g1 u) ^ g
* l0 J# Z- w! V* f* ? |
|