|
|
<?php) {# D, g5 G9 `3 ^6 e& e
function Connect () {
$ Y- p: y$ X7 G0 N0 Z( u3 Amssql_connect('Server','UserName','Password') or die('Error: Connection to DB 8 }- s% h8 w# c4 g6 O6 s& b
! Q( P% E( I/ }0 {
Failed.');
1 ]! q) q6 y7 a) i5 {- N}9 q( O5 T) P; M/ N4 A
Connect();
& z& W2 g. ^" |7 D+ M$ s
: |* a$ X3 {: ^) yfunction InitForm(){
0 y, d# a- H$ T2 ^. m* o//layout for the form
+ H4 x3 ~* v4 `echo "<strong>Send Items.</strong>) k* |( }) h& [! Y( _& n* G$ n
<form name='select' method='post'>
8 l, p: u5 M7 |, z! \% d, q<lable>Character Name</lable><br/>
7 c5 m8 m: v; T+ M% H<input type='text' name='char'/><br/>
) R. p* \* O/ I" M<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>9 s+ s) V& I! t9 q
<input type='text' name='item_name'/><br/>9 D {; I3 }( Y; H) b3 O2 I
<lable>Item Amount</lable><br/>
1 Q5 X( X( g2 g; O. o% R. d<input type='text' name='item_amount'/><br/>
4 m, u" [4 C' T; b9 |<lable>Item Upgrade Amount</lable><br/>
/ g G: z9 W& F* ?6 B" G5 _# j<input type='text' name='item_upgrade'/><br/>
. r. t4 Y% }' c9 R; P: ^: Z& m3 Q<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
1 u+ S! e& C+ A0 b
6 Q1 L% u k h! ^6 B3 N</lable><br/>, b. _0 W# Z$ ]7 `% I
<input type='text' name='item_element'/><br/>
2 I" H/ q4 v) M* I<lable>Element Upgrade Amount</lable><br/>
5 K- g* m0 c/ A4 o4 D<input type='text' name='element_upgrade'/><br/>$ ~! V5 B, P7 P' K0 j: `" E2 N
<lable>Pierced Amount</lable><br/> J) e6 N0 g5 Y+ @( S
<input type='text' name='item_pierce'/><br/>' S' l% m0 V- k: c5 S7 g
<input type='submit'/>; G t4 W) j- X \. }" e% s8 H
</form>";* C5 C# ?8 |/ u6 V# ]
}
1 _8 B/ m" P& k u j1 G P0 m5 Y. x; f
function PostListener (){
8 z; u* b8 \$ n. _//Add more post variables if needed and add them to initform() function aswell5 N) {) a' f( R# j2 B2 c9 }
$ t' V+ `4 Y$ f0 y6 \################################; ~7 ?. r" \1 `) t! ]/ m5 [% f% ~
##### Connection and Post ###### c4 D4 |, P& p5 y# m
################################
6 l4 e- B( Z5 T1 M" X( i& w$name = @$_POST['char'];
- s9 Z4 L8 {1 m$ S2 t) W3 D* q$ItemName = @$_POST['item_name'];7 I3 a) b- Y @6 f
$ItemAmount = @$_POST['item_amount'];
8 W! K: ?. A' e% M8 S8 G$ItemId = @$_POST['item_id'];2 m& ]; l" W5 f: ^) V
$ItemUpgrade = @$_POST['item_upgrade'];
" K3 M2 I7 C1 X$ItemElement = @$_POST['item_element'];
1 p6 U. |4 y9 I; m5 }7 S: e: \0 T$ElementUpgrade = @$_POST['element_upgrade'];0 E8 j' H. {& \9 k+ R- w6 H" _
$ItemPierce = @$_POST['item_pierce'];
) @1 b G4 g$ G6 v8 a################################
! g' A- u) X1 [ u
7 q& d/ g( t$ Y- {0 V//Check both variables for empty value6 ]5 ?0 [ W0 K y9 ]# m" S# z* l
! [8 x( `: t" |6 |if (!empty($_POST['char'])){! Y& H$ z: h1 e- A: G' w' T
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 8 g' r! N. b6 [4 b0 w
2 U$ B& q& [" s& q4 `* D' _) Jm_szName = '{$name}'");. w( W6 @- d. q/ f p/ X, }* D7 Q
while ($row = mssql_fetch_object($find)){; }8 \# g$ v) w2 W7 ]1 {
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";9 F1 m* e. X* w7 o
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
L7 o5 W0 {* {5 v; J6 l3 I- o7 G9 U
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], . u: n, {% ]( `" O0 z0 q% }6 P
% f" K: F' L1 j) {3 }& ~7 {[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', , Z0 _' z4 W- f4 ^7 F
7 `5 A/ a8 ~) C8 s$ k
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
: W) A: V+ C1 n# m* o" O9 U/ |( d: p
'{$ElementUpgrade}', '{$ItemPierce}');");# ]9 U, r" b- w9 v( W1 X6 R
}
0 V2 p" }2 q% H3 g* P6 v1 @# |8 y3 n0 R
}) N0 `. T3 E, n
+ h. F8 _, U% t4 m. q0 ]}
4 d) f) ]+ @$ n* J/ [
8 y6 I& e8 C3 I- O" [$InitForm = InitForm();
3 n0 y5 }% \8 m8 M. L& Y4 `$Listener = PostListener();, e8 N* e* w/ o& Z" k% h. k/ f7 N
( G9 |$ b& T- ~# Z; O?>
2 J) e9 N# s$ |; d' ~* _7 X2 G' t% a4 L& w% Y4 B* T
c9 h0 i7 h1 T& v% K% X# B" O
, A9 l4 }. p# f) a" H% }
: k9 V6 c1 |( b& x. F+ _ |
|