|
|
<?php
2 a; `- J6 b& W2 nfunction Connect () {$ t# c z) o0 l9 Y l4 p: Q* i
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB " z) [# P5 Q7 g5 H7 g" `3 g
3 o+ ^3 t4 s: ]# s6 `/ IFailed.');% t& q. t/ [. c( {
}
: x( j9 ^2 P* H% q0 \Connect();
1 N3 J4 c, l1 A# N( O
3 _( m% k+ p9 w' sfunction InitForm(){( h$ S' `) V* a) U/ _2 {
//layout for the form
E5 \: ]1 {5 K1 C$ W# v" secho "<strong>Send Items.</strong>0 ?3 @/ o: Y. P
<form name='select' method='post'>
) ~+ N# G0 t/ Z* Y# N<lable>Character Name</lable><br/>1 y% w I7 r7 X/ { N
<input type='text' name='char'/><br/>; \: x; \/ R0 ?0 r
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>, m0 t: T! |# D) A; R
<input type='text' name='item_name'/><br/>
- ~8 i8 t, B+ n- B( c& O0 z1 y& M+ Q<lable>Item Amount</lable><br/>0 m: q! v% L6 h4 x
<input type='text' name='item_amount'/><br/>
7 K4 d2 @7 x' f<lable>Item Upgrade Amount</lable><br/>4 d4 w* Z6 r7 }7 f
<input type='text' name='item_upgrade'/><br/>
% K H! z2 n' b( V3 B<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.), H; k: S5 m4 b- g4 K
! h: J' ~% S7 P# g5 c</lable><br/>( l C( s6 A/ V" n$ [% U3 q
<input type='text' name='item_element'/><br/>6 P0 \+ G9 U8 `4 l- h7 u, a
<lable>Element Upgrade Amount</lable><br/>0 d1 d; |( Y6 D4 N
<input type='text' name='element_upgrade'/><br/>+ \6 k+ ^* j2 m
<lable>Pierced Amount</lable><br/>
7 S' j3 [9 z6 J* a; X<input type='text' name='item_pierce'/><br/>) P$ t( W5 K0 n+ H' S
<input type='submit'/>" F1 A; x2 H8 D! p/ t5 M
</form>";# M* \) n! D0 @( ~5 t* f. p- ^
}' ^+ m/ A8 d, W% X* X, H
& i" y( }' @! T8 q& @: l9 {
function PostListener (){3 a4 [& c6 W1 y5 {6 N
//Add more post variables if needed and add them to initform() function aswell- F# \5 `6 k) Q5 Y+ Z0 P
( Q/ g0 `1 X( W. K( H& ?################################
8 i1 [6 x4 |/ p( H6 }0 @6 s##### Connection and Post ######
. q( ~) {. G* D9 x################################
! B3 g: |7 m' J6 T9 G$name = @$_POST['char'];. f9 c% s+ @- C/ ^
$ItemName = @$_POST['item_name'];) G' A |1 g1 o ~
$ItemAmount = @$_POST['item_amount'];
; l3 D7 L8 p ~3 N2 R' O5 E$ItemId = @$_POST['item_id'];
. K8 i- L9 `" _: A4 S) N$ }$ItemUpgrade = @$_POST['item_upgrade'];
. E L& f( A6 ?& o P. |$ItemElement = @$_POST['item_element'];
; V! [& o, \) b$ElementUpgrade = @$_POST['element_upgrade'];9 G2 B5 [4 ~* X
$ItemPierce = @$_POST['item_pierce'];
. M6 t: S+ `4 P3 r, d################################: a. [- K1 A% t4 E; L: H% a
' Q2 Z2 t2 s @- q+ N2 o$ R
//Check both variables for empty value0 \, X( S: y) X# q+ x
) M+ v* e7 t6 x) b" U
if (!empty($_POST['char'])){
6 r* {! \) z; Y8 b$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
+ M7 i$ [$ Z7 e! I4 u
" m2 q1 {/ [ ^- vm_szName = '{$name}'");" D p( \5 E1 W M0 C: M
while ($row = mssql_fetch_object($find)){3 Q- }4 a: C/ G* Y. e
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";3 v: r) _9 a# `$ Q
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ' S/ X3 e4 j# e1 z
1 n1 d+ q8 G/ c# }3 Q3 e9 U. w[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], , v6 ^: ?) e6 t9 J
8 g* h$ z" Q5 B0 M' P
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 6 e% ^% d4 K Z5 l/ z0 k
6 O. P9 P- Z% y- N* M; V
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', # o/ e' \8 h) ?4 u( h4 q8 q0 V5 J
# C t' Y' K! I'{$ElementUpgrade}', '{$ItemPierce}');");
8 s5 x$ n# @0 h" v" O7 r}
0 V9 }3 V- L# a9 ?# o2 h1 s* T2 h$ ]5 c" l/ Q; q: W/ N
}2 N6 C. _8 R5 a3 D6 b% @2 J: N
: O; c* I) o, g
}) w; t- z6 r6 W* G
l Z F8 n6 i$ E$InitForm = InitForm();
1 t0 G, M, Z* \$Listener = PostListener();; ^) d5 u3 r/ o& p' y
' P* E/ s$ A% H$ L' C. f" N$ X: ^6 f?>0 t; o$ l5 h& _1 w7 Y) }7 d0 q' b. X
; G" `3 I' n' m1 o
$ A. o' s; m( I( ^) L
3 ` N0 @2 j9 w: N
3 P# o1 C. S/ q2 B# n9 D |
|