|
|
<?php
, j0 w% E* R8 g0 H% G* V! u/ Y$ {function Connect () {' J6 q- s6 n1 D. v6 E# `8 X
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
9 g+ T" M/ d% h
$ d9 }5 Y0 F: R, J. `0 C, z, TFailed.');0 k' F9 ~! |% n. Y7 P5 h0 {
}/ f& d2 |2 V, O! e+ _7 ^
Connect();6 U" [( f0 B+ D9 ]% e+ X: I# h
- F( q# H8 L: N8 N7 T
function InitForm(){+ q4 [* b0 p' n" s7 [3 Z# g
//layout for the form
6 y5 _& p, r! c, `$ n* U4 n5 t4 qecho "<strong>Send Items.</strong>
; _1 ~+ [: ^4 O% O& b' t" ^<form name='select' method='post'>
4 X9 [, O2 L+ G<lable>Character Name</lable><br/>
9 Y; d' c& O0 Y! ]<input type='text' name='char'/><br/>
6 z: r) F# b; r9 l" {9 t# O<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>" a2 r; C7 [- F5 ^
<input type='text' name='item_name'/><br/>
5 d; \: C! n; n- v$ E<lable>Item Amount</lable><br/>, f `8 ?- W4 @* z8 Z
<input type='text' name='item_amount'/><br/>4 ]& r9 h) @- x& _1 T* _
<lable>Item Upgrade Amount</lable><br/>
( f0 A% F& Q- ]$ m7 m<input type='text' name='item_upgrade'/><br/>5 j; S2 L8 o" L; E" @
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)# y6 Z6 x1 u; i8 V
* Z: X d A2 \4 Y3 L</lable><br/>
. W! ?* e N4 E7 w<input type='text' name='item_element'/><br/>
9 N- a8 W" J" i) [' E+ D<lable>Element Upgrade Amount</lable><br/>
, v7 X& t0 x# f<input type='text' name='element_upgrade'/><br/> f2 Q8 l1 ~$ s) Y
<lable>Pierced Amount</lable><br/>
1 K$ `" R( }1 B5 r9 B<input type='text' name='item_pierce'/><br/>, G3 G2 M" ~/ F0 x8 @
<input type='submit'/>/ T* F- v7 F; T' l. G8 P( ]
</form>";; ^7 T& v L. ]. q: e& i( ?7 p
}4 V9 s, C8 G" ?
% M6 u: A8 |9 H& b d% Hfunction PostListener (){
/ n+ X" M `) E2 e: J- t8 a8 U//Add more post variables if needed and add them to initform() function aswell
- |/ o+ G0 j0 f# w R/ B) ^6 K$ {7 c/ H+ Q
################################( P# h, F4 E# g, z3 ^& z: ~
##### Connection and Post ######
* H- C" G/ B3 ]5 c. D9 w& ]+ Z################################( p1 }$ \/ K' \- X
$name = @$_POST['char'];
# ]/ y5 i* X4 r5 O$ x. `4 Z8 w$ItemName = @$_POST['item_name'];
; o% r' y2 l8 Z8 k3 v$ItemAmount = @$_POST['item_amount'];2 O- H M2 E; W3 p
$ItemId = @$_POST['item_id'];; l0 {! w0 d2 M
$ItemUpgrade = @$_POST['item_upgrade'];
5 w7 j8 R7 Z" T0 t# u$ItemElement = @$_POST['item_element'];
+ S+ i: G* w) @) u. f3 J9 o$ElementUpgrade = @$_POST['element_upgrade'];
a0 S, A! K: h+ P3 e' A$ItemPierce = @$_POST['item_pierce'];
. C7 Z- @" C+ X( a! V J' R, E################################6 k# c- B6 |1 |! o, [: ]" |9 R% u
- `6 L8 m& A, V7 {
//Check both variables for empty value( P V+ V6 u1 y d7 S
# t, o, `7 t; ]/ z) r Q. Kif (!empty($_POST['char'])){$ }2 G: o3 P }2 ?& C
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where & [( I' v9 L/ n# I" G2 y$ e: ]$ P
8 ?& {9 \/ n/ q* J8 i; ?
m_szName = '{$name}'");
' l$ l. }$ ^2 B5 iwhile ($row = mssql_fetch_object($find)){0 t" T& Q* y0 E& u, _- S
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
' P9 h8 V2 ^6 A* w( y) ~$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
" p, r0 N6 F- u
8 C# M+ A: S: `) f2 P, g+ q[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
( e2 s8 h) k* z* R. e" {% L* ~- ]( S6 X& M) ~( w" I
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
! m. ~, B+ r3 W* n$ J/ U1 E
$ F9 n' L I& j/ D) p' ^5 s1 u0 u3 wN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 3 e) z P! h8 B9 ?, K: v" O
C) Q: ?, D. |) h( ]1 p* e" L'{$ElementUpgrade}', '{$ItemPierce}');");
0 n6 p( v* z& s3 ^ h}$ |7 z5 A+ }2 p" i
( h+ r4 k- K) u5 z
}
6 J, n# U+ ^; r/ i/ v5 y5 }6 U/ K' M& f' O% c5 T3 _
}" i" a! F. @3 H b, N
3 c& ?0 F' v: u$ i2 o. g
$InitForm = InitForm();
' K4 W. r8 X; F$Listener = PostListener();
+ B4 d* s, N' v; r# g- b4 V1 f- `" u4 E- z
?>
( t0 l u3 j- x8 x; O/ e$ c5 f+ j' N' G z- h# v
9 s; j. o- j% W9 v' d" z' r+ E
; V, H# x; z, b% N
/ d9 |5 v8 o3 n |
|