|
|
<?php
/ D; i. W9 }* V2 q! l1 [. Ufunction Connect () {
# a$ Y' X) i6 Q& }: [mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 6 s& M+ ^& J; t4 e8 c# }1 v
+ {0 ~; \' _, O2 O* ?0 O' P
Failed.');4 [0 P3 M- K! `6 ]/ U
}
' Y6 d1 c. a3 h4 Z$ {! J. @Connect();# `9 Y# T. w- N5 Z. P
: N; k3 U* T2 u
function InitForm(){; s# U! z* j _3 A; q8 Z% }
//layout for the form
8 v) a$ T; O, E1 ]0 I; F+ O/ B- Oecho "<strong>Send Items.</strong>
6 u% o4 [. V2 c( n( g" [7 X* C X<form name='select' method='post'>
+ z$ m( G/ D/ L- Z<lable>Character Name</lable><br/>
' z; v3 {/ G' s" F. c* h3 \<input type='text' name='char'/><br/>
/ G+ r4 L) d( o& }/ d0 d8 @<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
4 t2 D$ _+ q+ N; N2 N<input type='text' name='item_name'/><br/>
L3 j9 [- g' w( E% I& j6 d- K<lable>Item Amount</lable><br/>/ u2 b- n( F' T @. D [
<input type='text' name='item_amount'/><br/>
+ v K& a' {6 _4 Y9 y8 `2 G A" p& H<lable>Item Upgrade Amount</lable><br/>- l# F$ V$ l6 J, ?$ U% J
<input type='text' name='item_upgrade'/><br/>5 H, d) i# V. N+ F% b: z
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
d1 b! g' \2 K! {% ^3 o+ q+ ~# J+ z# ~2 N
</lable><br/>
9 r/ m" L& \9 L<input type='text' name='item_element'/><br/>5 V+ y" n* I8 w, s2 n
<lable>Element Upgrade Amount</lable><br/>
3 z) C* T+ D& {5 U% Z# i, K<input type='text' name='element_upgrade'/><br/>
0 @6 h; [1 n" t+ R<lable>Pierced Amount</lable><br/>
! G9 @ s, B4 |+ D<input type='text' name='item_pierce'/><br/>
9 X& {( ^* z1 a; y/ C<input type='submit'/>2 R* e2 h- v0 Z
</form>";
+ [5 L; G* y& X T: O% j1 x}7 N: j9 C1 @6 F; e
) \2 d8 g A" k* a$ z; L4 J
function PostListener (){/ Y8 m8 J# w0 V
//Add more post variables if needed and add them to initform() function aswell
& l. h8 L; o( l. L7 k3 S* {- i: v$ d$ ^4 L
################################
$ j9 E" X1 j3 l5 @0 o: D##### Connection and Post ######4 N8 _ n+ v' W# ]
################################
" `! L9 P- d& |$name = @$_POST['char'];: v B2 U$ Z/ Z2 o3 i0 q& v
$ItemName = @$_POST['item_name']; ~5 ~0 F# a# k [" B3 K$ o9 x
$ItemAmount = @$_POST['item_amount'];$ r1 Z6 r. K7 g! E
$ItemId = @$_POST['item_id'];
9 A! D& x6 E: s- L$ItemUpgrade = @$_POST['item_upgrade'];: w3 J; H1 X+ ^" E4 y- @: j j
$ItemElement = @$_POST['item_element'];
3 H! Y2 Z! c& i$ElementUpgrade = @$_POST['element_upgrade'];
, |! g' p9 a0 k1 f _4 M$ItemPierce = @$_POST['item_pierce'];' H, i/ }# G4 Q' Q4 H8 v2 u1 k
################################8 T" J6 ^( L5 X p( Q( f' q
+ f7 A9 o- [" |! t0 J/ B
//Check both variables for empty value
, ]: U8 n$ X- ?0 H0 U5 V
) M& O4 V: F) J1 n5 t4 {- Kif (!empty($_POST['char'])){
0 `3 p: _: l% A" p9 F8 m3 D6 k' q$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
2 `: t9 H5 a5 S0 i$ J# s7 }( K7 ~6 ], g
m_szName = '{$name}'");
5 j/ `; p1 P8 T! hwhile ($row = mssql_fetch_object($find)){ Q; i$ F6 i; ~+ [
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";! `( s2 ]2 e9 _% Q6 o- [
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 6 z6 T# r& l, Q# r0 e8 K: s
2 {! v6 l" E3 i& Z1 f: T4 _- g[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
3 x i* z4 K, t3 }6 @& {1 N2 u) R5 x+ W
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', * E8 J' [5 @$ I' t/ W ]8 A
$ N; a! Y/ D6 JN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
+ |' B4 m1 W1 X0 L" Y1 z- F' F- i- r* g& y2 E( ?1 _
'{$ElementUpgrade}', '{$ItemPierce}');");
2 E3 x2 K6 S; y' V' x4 `}1 m9 m2 \# Z8 f% G
9 e/ E# K; [+ y}) m& J, z; d! y) b' z
, F, n8 s @9 M0 v0 X( M1 X9 ]
}
: S8 T. y9 _& q3 I. m; d) v# F0 m: p- s2 ^4 y1 n6 c7 D
$InitForm = InitForm();9 r- k! d; e7 H9 T# T
$Listener = PostListener();; u; ^/ [9 W% x q8 C+ u' w
$ J7 G' J u! E3 _/ a8 ?$ k
?>
; ~3 J# M, ]3 n a8 O
% H" o0 M% j$ @0 V+ F1 u& V" r2 j$ e; G
* P- Y0 s1 P* g' C# R% E6 g. e% D# }! O# E5 X6 q
|
|