|
<?php& v$ P8 P9 j4 x
function Connect () {7 F( A' Z8 c$ ]8 t
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
! R* ]8 `) F8 A/ s) x# {2 n9 g, z; C6 p6 l
Failed.');" H% W* y- [* x$ l* i4 A
}
& _( Q5 }% ^/ ^1 S4 QConnect();
$ h" I& A6 i5 i3 A4 z' u
4 E3 ?2 i% U* f' P4 C; i6 Nfunction InitForm(){
- b$ c4 W4 K5 O! t. U//layout for the form
4 Q* a. v) c" i# E* U7 l- Iecho "<strong>Send Items.</strong>
" h$ |/ J8 n9 f2 d# o<form name='select' method='post'>* ?7 I" r% `& Q. x! q7 o9 x+ r
<lable>Character Name</lable><br/>, t8 B. P) g. @" S' A; ~% L: @5 n$ Y
<input type='text' name='char'/><br/>
1 \0 }* {8 i2 R2 \' p. r<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>5 @& @$ X! r G
<input type='text' name='item_name'/><br/>6 M; ^" _5 P( r) b2 Z
<lable>Item Amount</lable><br/>
- ]7 Z" M. `. O) a) a/ i+ D+ W0 o2 H<input type='text' name='item_amount'/><br/>
# Y, @% n! v) B: r; {& p' v<lable>Item Upgrade Amount</lable><br/>+ T. O9 s: x p7 S, N5 K2 S
<input type='text' name='item_upgrade'/><br/>
. t9 E; H! g- @+ t3 [2 x<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)/ N* N' I- }1 h& b' m4 p
" J. S% s# i. Q/ H
</lable><br/>
" ]+ E& T+ Y9 P0 W! {# ?<input type='text' name='item_element'/><br/>
* t4 M' c! B1 L e% B8 l. H9 W<lable>Element Upgrade Amount</lable><br/>/ Q- @ z4 E, c. e" X1 V
<input type='text' name='element_upgrade'/><br/>2 r3 Z" X2 O5 s# ]: W
<lable>Pierced Amount</lable><br/>
I4 ?6 x# E% K5 H. Y2 I<input type='text' name='item_pierce'/><br/>' _& @( s& @0 s4 P/ a. u
<input type='submit'/>2 o9 r( Y# G+ d# x \. L( L
</form>";
0 j$ l8 N; M+ F2 K}3 ^! _* f; W" Q& M7 t0 D% D( {9 i
7 {2 S/ [9 ^; p' N+ j7 c
function PostListener (){
* v( Y; G3 ]; q3 J5 w9 a3 p//Add more post variables if needed and add them to initform() function aswell5 `# E( f5 M/ f
/ u5 _ G- Q( z. @; R! q2 t) b
################################
8 T. p% u. ] a/ M$ U& Q" @##### Connection and Post ######/ F- e& Y( P5 ]9 j0 r: M1 w( i
################################
( J' o3 x+ I- ?2 i7 G' |$name = @$_POST['char'];. V, M0 l0 p8 h: x* z
$ItemName = @$_POST['item_name'];9 K, X: U$ f- ]4 M4 u, }+ F' G
$ItemAmount = @$_POST['item_amount'];
2 I1 R: b/ P* x. F& B2 A. c# c$ItemId = @$_POST['item_id'];
! R9 i2 S; F. c$ItemUpgrade = @$_POST['item_upgrade'];2 g4 ?- Z- }& T+ Y) ~' ^4 `. q
$ItemElement = @$_POST['item_element'];( P' v+ W% W; N# p
$ElementUpgrade = @$_POST['element_upgrade'];
) H9 w; S" b% Y% E/ Y- D% b- @$ItemPierce = @$_POST['item_pierce'];
2 ]/ y: j5 f5 T! z) d################################, [3 y' j8 g$ {! B+ S( L
! O' t( f' z+ \; V. J, j//Check both variables for empty value m# e! q: S5 z% H' y
, `" O5 I7 P9 a* I- s8 e* ^if (!empty($_POST['char'])){
. B% z% d+ S( \2 R2 V5 Q$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
e6 }$ p0 f4 Q0 O
4 }* t8 y: f: X! ~6 }' `+ c7 {m_szName = '{$name}'");9 q# K+ q, u7 a2 Y" r
while ($row = mssql_fetch_object($find)){
+ D8 o& G! f" ^# @1 o( [7 Kecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: w6 f/ m) b( E% p( s" [0 l$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], + k8 ], u' w( @ Q5 j3 F1 N5 ~9 K
+ n7 \/ c* `$ S# T! r& [3 i
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
6 C) F! q* V4 O" a+ ?6 z) D
7 U8 q( h* ?9 a- m[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 9 h6 C- a7 a" g0 X/ e8 b
: s& ?2 _" M& B0 @1 d6 m+ ?# I& T
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
7 K) Z% ^ N$ N: E* X9 J8 I2 y3 M9 t
'{$ElementUpgrade}', '{$ItemPierce}');");
8 G" i8 b' S2 M" m! W4 i) c3 ~. O}8 ?3 D) b# |9 `% P- b2 ]
* t# Q" c3 V7 Q! r}
6 {( w; v* k& p* p& _4 x
" C9 X0 d6 R; u- l0 _. [& g `- J}
, @" d' ~# D* _( A4 |5 \3 k
; g0 p3 @7 w1 {, [7 T$InitForm = InitForm();, l D$ k0 j0 C9 D0 b! E, p
$Listener = PostListener();
8 r# c B& _; R: Y% ~& A. O2 ~! \- G) d- n0 s
?>7 O! Q. H$ n& ~9 h
" e* O/ Z; `- f2 @
7 n3 ?# Q4 f& X) p ?! `
* F" b1 ?3 k; H# F' ?
' e; i8 a; N3 a8 M) N3 Q |
|