|
|
<?php
5 q7 c t* F5 @$ n8 |$ ^8 _function Connect () {
& h* P% ^' d7 [5 v% G D+ V/ Z: {8 lmssql_connect('Server','UserName','Password') or die('Error: Connection to DB ; n# r/ _1 K- h3 N' {
/ y) r9 V( e6 bFailed.');8 b. B# I5 p% I; G( y6 x9 r
}
' `& v' } Z$ a/ sConnect();" G. @% K% ~; ?& L
3 q6 r, w% Q3 q& H q
function InitForm(){; i, w$ X: x) H0 B; k. |4 W
//layout for the form4 W' J' n$ n/ r0 P
echo "<strong>Send Items.</strong>
0 [1 T# N$ ^# { X9 O<form name='select' method='post'>
7 ]* k8 {! P {) f<lable>Character Name</lable><br/>
- f5 h1 ]1 k: s6 h<input type='text' name='char'/><br/>. k, E$ j l2 o x6 h: f K# F2 X6 [
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
0 m' g# P8 C$ f' o: G4 c<input type='text' name='item_name'/><br/>
: I2 A$ J' i3 ]4 |2 z! {<lable>Item Amount</lable><br/>* G; H3 u1 n' C1 N( `& g! a
<input type='text' name='item_amount'/><br/>
: Z0 k; {* t+ ?: F4 l<lable>Item Upgrade Amount</lable><br/>
& T/ p5 m+ Z6 h6 l2 z! g! Z<input type='text' name='item_upgrade'/><br/>6 Q& D( l8 J' ~
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.), r) @) Q! T+ W; U" u3 W
- o) D2 p1 s* F# P! R; t3 q& M
</lable><br/>
% P5 F- ~; @; _* y B<input type='text' name='item_element'/><br/>7 p" m* U; v$ g
<lable>Element Upgrade Amount</lable><br/>( g+ Q/ e0 |1 `& q/ d* { V* u$ l
<input type='text' name='element_upgrade'/><br/>. q4 ~: d9 A3 z6 D3 q4 i
<lable>Pierced Amount</lable><br/>. ~/ b2 P k) D# ~5 M* @$ h
<input type='text' name='item_pierce'/><br/>
* W# q5 A( i; m0 e<input type='submit'/>+ i" Y/ r0 \# j* O. H! r) d
</form>";; x; ~& K( Y% {" m; U
}
& k O& R/ G4 ^* a0 r/ U; K* Y* k% L$ `
function PostListener (){5 \' ?/ u7 L9 ~$ ~/ f J9 Z2 o+ Y
//Add more post variables if needed and add them to initform() function aswell
0 D7 U0 B* W$ n. ~! b
% |, p1 m9 A& J9 Q2 `' G3 @& V# G################################' k1 X1 T2 f+ Z9 O6 `
##### Connection and Post ######
( p) X' \1 V' @( f+ `6 V" F7 Y################################
; W4 X: S; s n0 F- c$name = @$_POST['char'];- o0 K4 N' ]5 Y3 I+ m: L8 ?9 K' r5 E: K
$ItemName = @$_POST['item_name'];$ K) _6 N5 }3 c' j
$ItemAmount = @$_POST['item_amount'];
; J* |2 }' r2 c$ {$ItemId = @$_POST['item_id'];
9 u# W- d) J1 b8 D. k" b$ItemUpgrade = @$_POST['item_upgrade'];
- b. U- W V' h5 f9 O$ItemElement = @$_POST['item_element'];
: u$ m& ?& {1 ?6 \4 K$ElementUpgrade = @$_POST['element_upgrade'];( I- y5 N+ ^6 s7 k
$ItemPierce = @$_POST['item_pierce'];
/ [ [; P4 E) N6 O3 Q2 G4 }. ?7 K################################8 ?$ H& |7 v$ a8 F
* t% C |; i/ T3 q- O1 b% _
//Check both variables for empty value
/ t- v" s+ z6 ^5 c; F. n B( ~) ^2 d- R
9 v% ]+ }' K3 wif (!empty($_POST['char'])){( q( i3 a; P3 M* l( y
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where # e& g! t% r ~) j4 D1 G3 D x* }* i
9 x+ W5 m4 p( v0 a0 p; I; {
m_szName = '{$name}'");6 Q1 C0 Y, u, \+ b
while ($row = mssql_fetch_object($find)){1 r( y8 d4 B& x6 U8 N7 J
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
3 |" f/ y. Y4 z/ m& T, ~) K$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
, U/ v. ^$ y6 X1 l# j* W2 f. S) U, B! ^$ y
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
W" o* ~* z, s( y) J( t# b; M6 m3 t9 Y L) n
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 3 Z1 Y, p0 `$ _+ s$ A" \. K
0 Q+ ?- }1 j0 Q. W, M& t
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 8 w. u1 H7 {. ?' U: r$ t/ K2 a4 ]
( f# j- J% C. z9 M5 Y1 ^! A
'{$ElementUpgrade}', '{$ItemPierce}');");
. t' [0 `: A4 }: ~* F. C1 f' ~# y$ e4 ]}
$ A' i7 t8 s; |8 ~
* ?+ L' Y4 B4 U1 J}) \) _7 t; w0 z3 N
$ l, {/ y/ A$ A% _" S7 @
}: z! F2 {; V M( E! l
/ z% a* Q8 v. T& H( N( T$InitForm = InitForm();- p3 D2 H8 S: W6 j& z m6 Q: d/ n
$Listener = PostListener();
( w; g+ Z) h) f; p! q8 X- m5 a q) _5 J$ F9 M, T+ `* C
?>1 O4 T3 q4 K2 E0 y0 p! t
) K( [3 m, w& A
& E% |5 V: G1 g" g3 K1 z( q% `: t- n) k( Z
1 r( _6 n* r t, d) z |
|