|
|
<?php" s9 H/ y" S$ f* ]
function Connect () {
' ^( {3 ^( S* s! e9 _) Z5 Gmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
( t2 \( Q7 s( Y& H6 y3 K2 q+ H/ H
9 M) ~0 r' a: Z8 hFailed.');
8 ~" ~3 m1 j3 t& ]} J7 P" i* a" f3 `% R- i7 c! c
Connect();% M' ^6 d# |2 Y
+ O6 B: C& e2 g1 K9 C5 Y% k, D8 r
function InitForm(){( `0 d( W) q6 w! p+ \2 D; Q
//layout for the form
9 U+ X# l/ D. A- t& r+ R% recho "<strong>Send Items.</strong>) w! s( a4 D6 } `7 a7 l
<form name='select' method='post'>; J: p# @) S. t% O5 r# R' O. ^
<lable>Character Name</lable><br/>
8 K# P0 i. [- k4 V5 t<input type='text' name='char'/><br/>" ]/ }# _6 u/ U( N9 x, S
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>" w1 T7 d! W8 _
<input type='text' name='item_name'/><br/>* q8 \( ?; z7 y/ `3 {! R7 V/ m' B
<lable>Item Amount</lable><br/>
1 s$ r0 u- }4 _( q<input type='text' name='item_amount'/><br/>2 z1 R0 W5 d& T7 [/ `! ] Y, K
<lable>Item Upgrade Amount</lable><br/>) |! s) A; c: P$ H; E1 c+ b) _$ R$ g
<input type='text' name='item_upgrade'/><br/>
; Q" B' p% a& f2 | c1 x<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)5 p' D0 V7 ]) T6 u
3 n- E5 N9 |0 @
</lable><br/>
0 ?( R! L T& M<input type='text' name='item_element'/><br/>
4 {/ d$ |- ]. e' s, K' T( G<lable>Element Upgrade Amount</lable><br/>
7 N& h- B3 Z6 q' @8 _1 H<input type='text' name='element_upgrade'/><br/>
. f( K2 L7 f5 C6 k1 @4 f$ o<lable>Pierced Amount</lable><br/>
& ]: Y' C' e& B& }& S1 o<input type='text' name='item_pierce'/><br/>
2 f) g! d( W' G4 p) h<input type='submit'/>
3 ]0 j# s o. k6 P! x8 d</form>";/ ]* J; A& l/ N7 [5 t) ?
}
- W$ w- o% K( s
5 R q" q' K5 I1 M1 E# L b$ yfunction PostListener (){% c% R$ k8 S' ^, M1 @
//Add more post variables if needed and add them to initform() function aswell9 e4 g# E$ c: U7 v* i
- B, H( w; p9 H F
################################
) p C# L) r8 L( }2 x" @##### Connection and Post ######! j. u: h, U/ L k& U" _
################################+ m. U+ e1 A% g
$name = @$_POST['char'];0 p. \9 K3 f6 C4 F1 W2 w
$ItemName = @$_POST['item_name'];8 `6 t" J. \% O8 A( B F. O
$ItemAmount = @$_POST['item_amount'];
) B' ]3 M5 @' l$ItemId = @$_POST['item_id'];' [" s( g# H% O1 b& c0 D: V
$ItemUpgrade = @$_POST['item_upgrade'];% N4 L8 y: Z& i, m C
$ItemElement = @$_POST['item_element'];
' y- w, V6 |# I* v$ElementUpgrade = @$_POST['element_upgrade'];
& F( @8 d0 Q6 t$ItemPierce = @$_POST['item_pierce'];
9 V. S' N& @9 c1 i' p* L( m9 A7 b################################
# J4 n% i+ {. W$ Q! {8 ~
/ A6 U. u; |8 u; p* Q, |6 i//Check both variables for empty value
( u) g3 ^9 {2 h5 g8 k9 X: j: R0 c
% q Q% _7 O3 d% y1 t3 q- u$ Bif (!empty($_POST['char'])){
9 ?& _9 w! }7 o0 g3 w* n. @$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 8 x" i; ?$ ]; z
5 D, o x) O; u, T* r. r( Ym_szName = '{$name}'");$ h2 M0 V( j% X( u0 X
while ($row = mssql_fetch_object($find)){9 ^$ d& K5 f8 j. ^
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
8 d$ `# U0 ~$ }* m$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
4 K& G6 T7 n' @- p* L6 Q3 U
& \- c% p: \8 k; W8 B[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
2 r7 _9 {; P* I4 E+ |
4 F1 q3 N0 j- A9 T3 T" ], t[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
0 h# r# f$ a4 c# w- B1 M
5 f2 r3 S4 _# l( { q7 LN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
: }4 y! v! e* P& _9 ~( Z2 E5 S D+ l: T1 h, [
'{$ElementUpgrade}', '{$ItemPierce}');");! y6 m. n4 r; }0 ?" m
}( K3 T; S- S1 A1 J% O5 a4 K: y" V
' ~% r, E+ G0 W5 w; U}6 h5 V) @" S) g1 z: a0 Y! v( p
8 {$ ~9 s$ m Y' c8 a3 T" Q}
% Y. _% B% e5 K
2 ^( f5 L/ j; v# P. v- a$InitForm = InitForm();
" {( f- M2 h: X. A D$Listener = PostListener();
3 R. J9 W! n% \2 ?! t
& ~% P# w" n# X. q1 ??># U9 h5 h5 z& ~ ~3 J4 N5 [
1 ~0 W4 @6 g6 N5 m4 {! n# K
' }" e3 ~7 B ^0 Y: N! ? ?* s6 X: l9 h. M
% D2 I% p' @( m y6 ^ |
|