|
|
<?php: w) Y, o# ~ p
function Connect () {! h! S3 l9 g$ D( B7 O
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 0 v/ V( d' Y5 Z- H' P+ k8 a1 z
1 ?: \' J$ n6 d+ g/ v& d
Failed.');
" b# N5 x8 e$ N}
; K9 |) X) ^+ l- X! c( x% J# PConnect();
4 q6 g T6 u) a& o% u$ n6 e0 u D V3 ?/ E$ y# m4 n* ~* H4 ~
function InitForm(){
/ q1 T4 E% a% t//layout for the form* f0 P7 E$ N( S: u
echo "<strong>Send Items.</strong>4 F. ]$ J% [9 K! _% E- D
<form name='select' method='post'>
5 ~5 G: C' o) Z<lable>Character Name</lable><br/>
7 | E' Q% K1 J+ v<input type='text' name='char'/><br/>
( W" {( F! B8 ^% x<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
4 N5 s4 M8 v/ B* u$ O<input type='text' name='item_name'/><br/>0 b, y: H) w! J2 r' P: s: r! b
<lable>Item Amount</lable><br/>! ]) ^8 Z" t; L( O
<input type='text' name='item_amount'/><br/>
$ o- _1 l( |/ V4 Z4 C<lable>Item Upgrade Amount</lable><br/>: z) h' R* w0 B
<input type='text' name='item_upgrade'/><br/>
Q4 s' A4 k( o5 _* o! A7 i1 I<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
6 n5 J. x" d6 Z9 u) x
4 x7 ]- ~6 ~' L o</lable><br/>
7 q2 m1 Y5 l! ?0 _5 u2 |8 f<input type='text' name='item_element'/><br/>
* l6 y( [! G$ n7 Y5 X<lable>Element Upgrade Amount</lable><br/>
b" h; I8 I5 W4 v5 {) Q" c! c<input type='text' name='element_upgrade'/><br/>- b8 \5 i7 w5 r) l" l
<lable>Pierced Amount</lable><br/>( ?$ s+ Q7 r* u7 ?
<input type='text' name='item_pierce'/><br/>
( U2 T0 R% u9 J+ i5 K6 ` e<input type='submit'/>
& B& p3 d4 z% U( N$ ~, `</form>";
) T7 G# Q6 G; w4 N}9 K1 [4 S8 q9 X/ k7 x6 }, X
1 j F7 [9 f5 t; Pfunction PostListener (){8 m3 l0 Q3 G7 x! }; c
//Add more post variables if needed and add them to initform() function aswell( v+ \/ W: e& _6 ?
4 d7 N) H4 }8 I9 ]" ~
################################: L4 L! ?. Q8 N$ O0 n+ O
##### Connection and Post ######
0 C2 s3 ^* z8 b# G$ X7 |################################. f" | ~) Y' H" l
$name = @$_POST['char'];' J- M/ u3 G- c+ u% c
$ItemName = @$_POST['item_name'];* u* H1 [. K0 e* n3 Y/ x
$ItemAmount = @$_POST['item_amount'];
( x0 b- D! z2 P2 k* `9 B x* x; M$ItemId = @$_POST['item_id'];& ~# s3 `2 @) e2 T
$ItemUpgrade = @$_POST['item_upgrade'];! w4 O" s6 o. u2 l2 G2 Z" r
$ItemElement = @$_POST['item_element'];; J6 t8 `- V% F1 y' A
$ElementUpgrade = @$_POST['element_upgrade'];
$ H. N0 f. h' I! T3 X) [1 z" v2 Z$ItemPierce = @$_POST['item_pierce'];
1 P. s/ u4 z2 c& O: A################################* c5 K( Y. s) s/ O8 I6 T
- n$ x0 L% e" B5 Z1 N
//Check both variables for empty value: X A$ j' E: J" t% U( G8 _' a5 F0 r$ Y
% n7 b. q$ ?( H0 R4 l( E$ Q
if (!empty($_POST['char'])){. _/ k9 a4 L8 d" M0 g/ K; Y
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 T6 r# q- ~% B
5 \* ]& o$ T+ }m_szName = '{$name}'");
; z, c* Z4 k! D! R9 T/ `while ($row = mssql_fetch_object($find)){0 k, b8 f/ v4 O& Q' C$ R# B
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
7 j) r' B+ |8 l$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
1 s+ b, l, g! n. n# _3 ]2 R, i9 j2 j/ ~; L1 x2 ?2 W1 {- n/ n
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], , A1 E8 }* [0 q
& A/ B! J k& S; n[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
) v1 O8 p9 r2 L8 t8 J1 h! X0 ~) Y
1 j8 G1 |$ b+ N1 H, h3 x) dN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', $ I: j/ w& z; s7 T# C5 Y+ u
& Y6 I7 P" ^, z4 b# D) i'{$ElementUpgrade}', '{$ItemPierce}');");
8 a) e/ _5 q% E% Z* l4 u}
5 s: S7 ^5 N! Z& L$ V( X+ p7 V* {; `- s
}$ d5 r1 e) M: x0 i
$ M) a k7 q, W& h8 A* `. Y) o( Q
}
4 o& i7 `) ^* q) O; N: B! c6 a, A: Q9 X# [& L+ H
$InitForm = InitForm();
' r! j6 K" m+ c! G* P$Listener = PostListener();
* j+ x/ v7 q f) L% g7 @& O1 t! a/ p4 N
?>5 V3 c- K" f7 z2 x( E; O
6 u0 M2 t$ o" \# U
$ } d* Y3 u. _( B* Z* D- k" O' }2 c% H# j7 P- R4 i3 S- h# K8 m
9 _3 N5 d0 u7 I% M2 q |
|