|
|
<?php
$ k- m, q, J! k0 qfunction Connect () { F1 S2 ?6 V0 m. H4 H
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 3 u: u" J' ?5 g/ `9 c
( T: _- |" i+ Y6 L+ z/ [( i+ `Failed.');9 M% |5 d" E5 i# z2 J
}9 G! e! [/ @" j* Z
Connect();. N3 H9 `$ x- ?
9 _2 e i$ l0 S! V. r, b o
function InitForm(){% h0 `7 P3 q6 D. a0 b. j
//layout for the form
1 |6 z3 b$ I( ]9 P( i8 U/ iecho "<strong>Send Items.</strong>
4 T! m' w1 f6 w! q8 J2 t5 q<form name='select' method='post'>
- ^1 M: i/ [5 M+ C0 h4 @) y4 I7 b) a<lable>Character Name</lable><br/>5 G+ b3 P% \% g* S) Q# T
<input type='text' name='char'/><br/>" l, x$ i1 R* r- x
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>8 P4 u: _2 h0 R+ b
<input type='text' name='item_name'/><br/>
7 M6 Q- A; t {4 m0 R<lable>Item Amount</lable><br/>. g5 Y! V6 X# \% _% S5 C
<input type='text' name='item_amount'/><br/>
7 p3 I* O9 g3 Y' G/ a* G/ ^7 b- O<lable>Item Upgrade Amount</lable><br/>
) P; ]0 f* E# [& R: D# _$ x, u<input type='text' name='item_upgrade'/><br/>
0 e) _# p6 O+ P6 |) E<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
$ \" }# g- l% _4 M, z3 F/ j
8 _+ l- ?. |' D! B</lable><br/>
+ W$ K. b5 [+ r: X<input type='text' name='item_element'/><br/>
3 x6 u& _6 h3 |<lable>Element Upgrade Amount</lable><br/>
0 |* Y2 ]1 K: {5 c, X& }8 g<input type='text' name='element_upgrade'/><br/>
/ g5 f, j* g/ r* Y+ h: p<lable>Pierced Amount</lable><br/>
5 c8 p$ g( f/ n<input type='text' name='item_pierce'/><br/>
& Y( m. ~6 Y: n& a<input type='submit'/>; M& j7 n( |- v- d7 Y9 R
</form>";, v" q# O2 g+ s- e1 n0 R
}. I2 T: t9 E0 O; L0 n3 D; Q
" ]# \/ d3 M2 o2 n J/ Q
function PostListener (){
. P) g0 _- E$ Z7 I! D0 T/ {9 ?//Add more post variables if needed and add them to initform() function aswell
/ g5 E& [$ X% l5 [8 X) ^
2 D5 M$ C3 w* @4 o" }################################
7 V0 s# [) y, z) A##### Connection and Post ######
5 W/ y8 X# }$ I/ A################################: _6 P# p; P$ x( `" ?
$name = @$_POST['char'];( H8 c* v# c U8 R- ?2 ?3 X
$ItemName = @$_POST['item_name'];
8 P! U, E- R) c4 n" o) m* r$ItemAmount = @$_POST['item_amount'];
' c% [" L! F5 L' z) w$ItemId = @$_POST['item_id'];
7 H3 ~; ^1 W# k b2 _$ItemUpgrade = @$_POST['item_upgrade'];
, D& P U7 b6 P5 a5 R) U+ s) G$ItemElement = @$_POST['item_element'];
T3 k1 D; I; b8 B0 [$ElementUpgrade = @$_POST['element_upgrade'];
7 ` M" T5 j+ O% O4 j$ItemPierce = @$_POST['item_pierce'];) {2 D) e3 M8 k" t9 |5 b/ O
################################4 i+ k( G7 S' @4 u( M
7 q3 @! v3 J4 y! l( h//Check both variables for empty value
0 C* [# r4 Z7 o q ?, y) a6 P
( f9 ]# \" E4 _8 Vif (!empty($_POST['char'])){
* N5 V: d, A, z$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 2 z8 J; \ n4 u o! |6 e( J
/ y; [% w% j; L8 b3 k% Bm_szName = '{$name}'");) f2 G5 {1 n2 w+ q9 K5 F
while ($row = mssql_fetch_object($find)){
* n8 y! f4 R+ @- [2 {echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";7 E+ B8 Q% w" }& ^
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 9 F) d2 E9 M/ g( q p
9 |' J' y7 d3 A, H& Q r[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], * i5 [# T+ c7 e. ~+ r
~9 Z, z( S: Q. w[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 0 S0 L" J3 e; k6 t
" |8 X m5 ~% k# f" AN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', & N/ M: [& o# k
6 q9 k9 c7 s- _: C4 o
'{$ElementUpgrade}', '{$ItemPierce}');");
3 N/ R: B; q5 @& N1 `}
+ e+ T. `% I n# S2 E6 G0 X" k h* t+ Z1 r. {; Y. W7 ]7 ]
}
5 z- y* R0 S" @& C8 m1 }+ X% P
0 J# W3 s) W4 H) z9 O}+ y& m, B2 t K: ?
b# ~4 @) e+ g9 i% F$InitForm = InitForm();( T! o! c' }5 ]9 U% ^- ?
$Listener = PostListener();6 v6 y* o( j9 Q1 o
; d. o! K% t3 ]# r2 x8 J
?>
3 }: {! p6 J- e3 Q2 x( K, U
0 V* f3 g9 y! X/ T
5 I2 x( {7 i$ b( _/ T1 f/ h1 ?: [9 e( C1 T! r4 n
; `. b& f* K, H: U
|
|