|
|
<?php# X- A: S) k( l+ }
function Connect () {
5 H1 y+ h1 B7 A1 t- G/ F5 Zmssql_connect('Server','UserName','Password') or die('Error: Connection to DB ( K! r& l1 n- k- N. M- I
) `; ?1 S) T! A4 `9 pFailed.');
& h9 ?7 T. `* u}
7 }+ g6 q$ @! V8 T( b+ gConnect();
7 F6 U0 T" Z( z, t* d3 m8 E2 G- \4 D; g L
function InitForm(){0 x, e+ Q+ r( v2 E6 `9 Q
//layout for the form
9 `! Z& U3 i: ^. z& Aecho "<strong>Send Items.</strong>! |0 l) g q. B8 s
<form name='select' method='post'>0 w+ {. `% v. f# k3 S) [
<lable>Character Name</lable><br/>: T6 S- T% y; k2 l- z4 B
<input type='text' name='char'/><br/>
+ k! F' l, x! x* H! {2 E, H9 O<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
5 e4 S3 k3 R: m<input type='text' name='item_name'/><br/>
" m# X5 {# G" {+ ]9 w<lable>Item Amount</lable><br/>
: |7 Q& F# c0 `+ n$ G<input type='text' name='item_amount'/><br/>- x4 C7 b6 e# p% J, ~* {7 h
<lable>Item Upgrade Amount</lable><br/>3 K$ K- J4 L x( Z( n0 ^
<input type='text' name='item_upgrade'/><br/>
( b; x- A: `2 e4 p+ @' b; h<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)+ d) w1 J+ F, k: R5 J0 B
) `6 i4 b, d& v n</lable><br/>
9 z7 B% e! z8 P J: _, \<input type='text' name='item_element'/><br/>
" ?, A, z6 ~7 H. ^4 }/ L<lable>Element Upgrade Amount</lable><br/>
8 E& i& F" E6 F( H6 a<input type='text' name='element_upgrade'/><br/>
$ I2 T5 \6 u5 e$ o, V$ y$ z0 m6 x<lable>Pierced Amount</lable><br/>* h8 G2 E' ^6 v! Z# p5 L
<input type='text' name='item_pierce'/><br/>
6 w( A* p; X0 R<input type='submit'/>8 M5 v+ p/ f- F; a; P7 i
</form>";$ j" I! s _% A
}+ Z4 L5 P- _. M* b# U% _
, w- q9 x' j' m5 \1 r% E3 [function PostListener (){
3 A5 N0 W& u x1 M7 ]+ N/ {//Add more post variables if needed and add them to initform() function aswell
$ \& X* B7 i n4 R7 j( |% G( j- o. _2 b/ R
################################
5 T4 R1 E8 c% d0 W! p##### Connection and Post ######* S* f* e" z2 T; \: f' B q
################################
0 c4 W6 j1 l- T, r* i1 p$name = @$_POST['char'];
/ j4 O: ?; I" r( j; K$ItemName = @$_POST['item_name'];
& {" G, e3 ~, W7 ^$ R- P9 i$ItemAmount = @$_POST['item_amount'];
* m& u# ^6 A! u$ItemId = @$_POST['item_id'];
0 r8 z9 }; p& C$ItemUpgrade = @$_POST['item_upgrade'];/ U3 Z5 B; w! d$ b
$ItemElement = @$_POST['item_element'];- K0 b G. ^' Y& i
$ElementUpgrade = @$_POST['element_upgrade'];, q7 t, ?# d" c0 N
$ItemPierce = @$_POST['item_pierce'];
8 @% E# b5 |8 c0 W( ]################################6 E) C. \/ y- o4 U$ J
% E1 Z/ M3 `$ g* a//Check both variables for empty value1 {+ h* x9 q0 f9 @/ _6 W
) e3 _( T# I4 I" r+ Pif (!empty($_POST['char'])){- r5 B( `" K' d+ J
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 ~/ c- T) p8 v: C
3 _( h* i$ }1 k9 T1 K8 y1 @m_szName = '{$name}'");
4 C- B; ]6 S! H: Wwhile ($row = mssql_fetch_object($find)){0 q! z _# [7 ^+ m
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";: C5 d- d+ A" W
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], P* f2 t' ?+ A1 w
, [! U" l7 m/ y0 ]- V! q[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
. u# b) u& | s+ _- W9 R( i ?; p8 \
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
2 K1 p5 @! a) H
# a& D" |, F5 q2 [" m) GN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
/ W5 h- U1 T1 a9 {7 k9 t: @- q+ Z' ?4 k; S3 |2 Y( D
'{$ElementUpgrade}', '{$ItemPierce}');");! N7 {: D$ [ f. d2 S& }7 G
}
: v1 v. a# O/ E- o
5 Q# O: Q) O- j: {9 j g* m}
3 m( ?3 n# j. {8 w( X* b3 \8 p- y2 F: {( n
}: l8 S3 w+ `/ f( v7 G% {( c" E
; }; W5 L; J8 Y: M' Z' x$ t/ b$InitForm = InitForm();
+ t9 Q6 s8 w, I& j$ N- F$Listener = PostListener();
) V! n; A. S) }. P' p# G
3 j; W/ a# h' w. W: k; D?>3 a) D7 a2 E6 k2 x! J/ }
: u2 C) s* m6 c9 W
) R( m9 n" G% S* ~) X
( J, v8 d/ J8 f
# Y- q5 q, n& G3 X- W' d
|
|