|
|
<?php
0 i! b' u3 c: r ]+ H. [function Connect () {& } Y; O7 A1 E- j, w) a( [4 O: k
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 4 e* a( C9 O/ `0 D; _ H
1 Q$ Q/ Q B9 \3 B) ?. G
Failed.');
. P+ G) V# d( ]4 C3 x" q! X}
7 `* z+ `. S- s oConnect();
G1 l1 ^, @. M8 z. G# }2 o
8 c6 C. `( }+ O$ L" m8 A8 A6 @function InitForm(){. Z+ m0 v0 l2 L0 [$ j7 I
//layout for the form
+ `% C8 ^2 E% g: @+ I, zecho "<strong>Send Items.</strong>
1 U( l: Z- g3 q4 F% Q9 b<form name='select' method='post'> d$ g9 l k u) Z" R3 g% S1 L
<lable>Character Name</lable><br/>
" x$ K* P S/ K' p. S<input type='text' name='char'/><br/>
2 |+ e1 g5 j( N: p5 U5 \<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>0 o0 x2 x. C8 t
<input type='text' name='item_name'/><br/>
# [: Q8 X0 `: A1 O& y: ]9 D<lable>Item Amount</lable><br/>
+ M# ]6 t7 C$ a" b3 C% b<input type='text' name='item_amount'/><br/>
; z# S6 X' {" V<lable>Item Upgrade Amount</lable><br/>, M5 U+ W3 M2 Q+ \# T# C' g: G, d
<input type='text' name='item_upgrade'/><br/>9 F4 F! k2 O5 h2 R* t
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.): `. A8 D; Y" H& g, N$ n' z% ~4 }
1 `6 L, _4 y+ f2 R% G</lable><br/>
6 y! z0 u4 [/ N; l5 l7 |<input type='text' name='item_element'/><br/>
' U% B# ^: i W1 v$ s<lable>Element Upgrade Amount</lable><br/>
+ i; O# c; V# P<input type='text' name='element_upgrade'/><br/>& x' S$ D' o: `" R3 \7 {) v. M
<lable>Pierced Amount</lable><br/>8 G1 y3 L w7 G1 _% l( ]8 B
<input type='text' name='item_pierce'/><br/>
' I2 j: E4 T+ k% ^<input type='submit'/>3 P& Q( g; p. C- k( S
</form>";
' w6 V% i6 _4 H- H1 Q5 J! }8 c}' C+ c+ c! Z. |
4 k) L5 {. |' f7 O: z7 r4 M
function PostListener (){
$ @6 D+ r, c+ Y" l0 S//Add more post variables if needed and add them to initform() function aswell
; A& @0 k& b: Q* k: J. }8 m
E; H3 \* H. |; t4 w2 Y! s5 D################################
# N h, ^2 `( S6 W* C##### Connection and Post ######
) h( i1 R% e+ A# i% P################################
2 {5 Y/ H3 k+ n# b9 s0 N" T+ @$name = @$_POST['char'];
; s2 X2 W8 h/ d0 N& h9 ]$ItemName = @$_POST['item_name'];
. a; b$ a3 n0 O. t4 ]( ` R4 h$ItemAmount = @$_POST['item_amount'];
# j+ K3 z0 V7 e$ItemId = @$_POST['item_id'];
% Y5 I; f, T3 H4 m2 m$ItemUpgrade = @$_POST['item_upgrade'];
: x" S: _+ @' l9 i$ItemElement = @$_POST['item_element'];8 a/ v! {! S- _4 P: \7 h8 T+ ^1 ]
$ElementUpgrade = @$_POST['element_upgrade'];+ b0 F4 a5 x7 R+ X! K
$ItemPierce = @$_POST['item_pierce'];/ g+ W f6 e2 G6 c' K6 ~1 Z& M
################################
) S8 ~' ]% ]4 \2 Y$ f7 c' m; q( b7 ]
//Check both variables for empty value0 q) ?; n$ n/ J: {& w, R
9 J9 q W0 \) C* }6 g0 R0 n0 ^3 L- qif (!empty($_POST['char'])){' I& G' b" h4 f4 y& s$ O
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
- o C; ~9 g7 O- w. i5 }/ F- n7 k( w7 \2 ?. q
m_szName = '{$name}'");
: ]* ]7 k2 X& [; Mwhile ($row = mssql_fetch_object($find)){
$ X- Y+ s1 U0 W9 V9 n9 hecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";' d3 E/ p" f* Z. f$ A C9 o
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 9 M4 Q- i$ q, j, Y
, B& v( e9 V( v
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
3 @% i) M+ x5 V6 t& i
) G, U5 x) d' C* Q# R$ S- d[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
1 a& M* U, u0 v4 K
7 L0 I. ^. r- ^* SN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
7 U/ F/ d U% }) `) K6 I/ S O5 x
/ Y6 j3 W; D5 B7 A u3 i% F'{$ElementUpgrade}', '{$ItemPierce}');");3 K9 a* i; g/ z) M) k( f, _
}
F2 r. V# ^3 p! Y, x+ F8 U
& a! D& t7 ?9 B8 D7 ]' R}
( R8 h1 m( C# G% X' s2 s( j; @ [
}
/ m- F& a: h" c5 M6 G' C" y5 H* g; b7 R7 q
$InitForm = InitForm();
1 s0 o, c5 [7 B7 }$Listener = PostListener();
% }0 t R c& j. _7 j) ]7 ]: X& q$ V% y$ V
?>
e; N# S, |: x" ~% }! F
7 h0 x+ \# K, J* I1 V/ {, L9 M1 }2 I/ q7 ^7 u
[* ?$ H2 l( R5 H
# L6 E7 Y. p7 g3 Q; z |
|