|
|
<?php
" T' S8 k0 b. |6 w' V; _! p# L9 dfunction Connect () {1 \* ?$ w0 _7 n
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB ' a: z8 N" V) [6 u9 R+ ~) |4 A' o
, r9 J& l! C' X6 ?( D9 ~5 LFailed.');
4 }/ F/ y3 p3 ?}
2 h9 d) B1 ^, Z( k6 OConnect();, L* y# F9 J9 C8 [2 _' S/ t
3 j! M- y9 G. n( y3 c6 ?! V- z
function InitForm(){1 [- d0 J: Y4 W/ d9 E# i( s1 M
//layout for the form
1 U7 K! j4 |3 Mecho "<strong>Send Items.</strong>
: Z2 l% a' Q/ ]. m( D0 P4 ^" G<form name='select' method='post'>0 a) I+ v# Z" L$ |; M9 K# j
<lable>Character Name</lable><br/>
# e; V- V) i+ @. m<input type='text' name='char'/><br/>
) L- B' G, t( x) _<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>: \2 {0 h. S, `
<input type='text' name='item_name'/><br/>
5 |" X, W& O" X& C<lable>Item Amount</lable><br/>! s2 d9 r' w. K5 y9 V
<input type='text' name='item_amount'/><br/>& f" i! g# P/ i! z
<lable>Item Upgrade Amount</lable><br/>- l! ]$ C8 {7 h- e: }# I k' g
<input type='text' name='item_upgrade'/><br/>
# t" E. S! x# ?' w# ]' c6 ?<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
! e3 E: s) |5 g% Q/ B8 A& S( m, N, i/ G n8 H. x
</lable><br/>
8 L, q8 V5 z+ e<input type='text' name='item_element'/><br/>8 G, c, V& R; g$ i4 m' P- A! H
<lable>Element Upgrade Amount</lable><br/>4 j8 B& G9 x/ O7 n; {
<input type='text' name='element_upgrade'/><br/>
; r4 ?# A% t- Z- t2 |<lable>Pierced Amount</lable><br/>% |+ D r" V% P: {% w: e+ {
<input type='text' name='item_pierce'/><br/>
6 a. x0 F. Y# _% t' ^2 A<input type='submit'/>: Q. h5 H. Q e9 i9 P5 w6 c3 z, l. Y
</form>";
7 ~- A* q6 R' R; h- f9 I( q}
& P0 \% F- E. k# v! D" y& ~% j/ |9 I+ Y" J- ]. j" h
function PostListener (){
: _8 Y, W* {+ N//Add more post variables if needed and add them to initform() function aswell
L$ `9 f1 z% W2 Q: B1 x( B+ d% Z
) L7 z# k) r; H+ G2 E! m################################9 @. n7 V% K. i5 V4 h2 P p
##### Connection and Post ######
% m! y* h1 S6 D' v8 o: q5 F################################" f# P5 f% i; a# Z6 C5 H% L$ q
$name = @$_POST['char'];9 v* Q$ B7 c) n3 \
$ItemName = @$_POST['item_name'];
4 g6 n+ E8 U' ]/ j$ItemAmount = @$_POST['item_amount'];
5 g; O$ C$ P1 z$ItemId = @$_POST['item_id'];) F" ~$ M4 y$ I& f; x4 P8 F* ^
$ItemUpgrade = @$_POST['item_upgrade'];
" j+ e5 x% r& O0 t7 i! S$ItemElement = @$_POST['item_element'];* \3 v5 Q5 r& d+ S7 L: C
$ElementUpgrade = @$_POST['element_upgrade'];
2 n( c9 _6 i- W* f! u( u' h$ z& n" d$ItemPierce = @$_POST['item_pierce'];
# p) ]3 h3 P" J1 Q; x################################
' h+ v; f; x; d9 e4 Z
8 }% _# J7 K+ f//Check both variables for empty value
4 P# y1 Q B9 m& U4 |; @
5 n9 g# O# _5 M+ a7 sif (!empty($_POST['char'])){
6 v- S* K H6 x# [2 \6 O$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
3 e% g( x4 J. ~- m# g* q$ p3 v! q6 v! d7 s
m_szName = '{$name}'");
" k/ @) v" S1 T3 Owhile ($row = mssql_fetch_object($find)){1 r1 N6 J7 _6 R5 _( `
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";' O& L/ l) u$ O) y
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
4 c4 E& q) ?6 r }% `4 H6 A+ d4 y* G3 C/ X( b* y a" M
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
& h1 f' ?/ n8 m/ }: j+ C# z
9 c4 t+ B# P& S2 {; o( W[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
$ d0 D0 Z) p$ b, R' B
; ?% a$ f& Q$ O. SN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
% V! z9 s% ^/ {" C
5 P' P" b( R- D, K V% b9 b: `3 T'{$ElementUpgrade}', '{$ItemPierce}');");
, [& [$ e1 w9 n4 ^3 g}7 o: {. Q% S8 P
: ]/ h* l) x& {! k/ ~" m5 }}
. T: n9 b0 ]8 r$ ^
3 q k0 X1 p! _4 O}
, Z2 l& _( \2 {6 K; k
5 |, z2 K6 N. _$InitForm = InitForm();
1 }5 ~" S# L% y0 h4 j. W$Listener = PostListener();+ N7 y) t7 G& M( V6 p! n
3 W/ ~1 c, V5 G7 |: L1 \# m2 f?>) o2 y/ T% ~' v1 X
/ p5 j# ]. d1 L# F
7 p, S6 a$ s: O
* M+ }9 n- }+ f$ B5 `6 i2 O
6 t2 Y$ ]- h* B( p4 ^ |
|