|
|
<?php6 m" F% d+ g3 {$ b+ c' {/ Q- {/ s; p
function Connect () {
8 d u0 c& X" m( Wmssql_connect('Server','UserName','Password') or die('Error: Connection to DB N9 p( }0 R+ j/ V( I3 |& a5 f: R
, D) N ?& @2 t- zFailed.');4 i: w6 V0 O( f; f* H
}
0 E1 m8 x; T/ bConnect();$ n, h1 `. X: z9 ?9 i% o
; S& v; h+ J2 ?! Y; n& P
function InitForm(){& s) k% X, Z" d4 u5 U6 c
//layout for the form
' M" G: _" Y, i8 f, \echo "<strong>Send Items.</strong>$ q1 ~6 b' J5 P; l( I5 p6 {* f
<form name='select' method='post'>
4 Z* {. ]2 q$ K' t<lable>Character Name</lable><br/>
; M5 K# G- {- Z& J# x! u! m6 X<input type='text' name='char'/><br/>
8 i; H; ^: V, l* _<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
% n. i2 Q% K. ^' G) o7 {! Y7 }0 C<input type='text' name='item_name'/><br/>
& o5 s1 d! ^: x' a+ q<lable>Item Amount</lable><br/>4 `( g7 D8 Q' D! R
<input type='text' name='item_amount'/><br/>2 m' X& Y7 b, r S0 x: |. P
<lable>Item Upgrade Amount</lable><br/>8 ?! f& C) b8 ^0 ]0 `
<input type='text' name='item_upgrade'/><br/>$ u9 w0 }' e: A, M" e5 |
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.) Y; `2 d9 l% ~+ Z( ^( [2 Y Z' q
4 h! l) f% V2 L5 ]: \! c
</lable><br/>
$ Y6 Q0 F/ z5 j7 P1 T3 x; Y$ X<input type='text' name='item_element'/><br/>: t, v, E, ^+ Z, F
<lable>Element Upgrade Amount</lable><br/>6 g/ ?4 g" ^; n' Z" a7 s
<input type='text' name='element_upgrade'/><br/>
2 x! Q3 b/ G( e: Z# \3 d<lable>Pierced Amount</lable><br/>: P8 H: C8 K0 o
<input type='text' name='item_pierce'/><br/>
( u/ j" Z1 \" k, ~8 R; X<input type='submit'/>
3 p" M) t! e+ l x</form>";
. `3 u, M1 v1 N; k}
5 a1 l% |9 M7 e0 p5 c2 ~1 | X( q- E9 s0 O- A8 r- ^6 B& h- Q% {
function PostListener (){$ w* N% [; t0 q: }. P9 }
//Add more post variables if needed and add them to initform() function aswell! g' N+ t( l# ]& \8 J
, G, C$ r1 L6 P# Q+ o, N( t! q' w! u! m################################
" f$ r: e) U8 x8 P+ t! X4 O- t: S##### Connection and Post ######/ N8 \; T2 m. c. }; f+ g
################################
0 `' v E$ ^- N* ~$name = @$_POST['char'];
* K( u1 j/ f9 i6 e" ^1 }7 r$ItemName = @$_POST['item_name'];
+ c5 M, ~8 ?4 B% _) s" d$ItemAmount = @$_POST['item_amount'];! s+ i2 e- S g- w
$ItemId = @$_POST['item_id'];: m ]" _. o$ c" v1 `3 N6 I
$ItemUpgrade = @$_POST['item_upgrade'];
* |0 x; }8 m2 i, h0 k$ItemElement = @$_POST['item_element'];
8 L$ u# `) S+ Y' T4 F; _$ElementUpgrade = @$_POST['element_upgrade'];
5 e: j( a. E- T% ?" D( Z$ItemPierce = @$_POST['item_pierce'];; c6 ?+ ?9 }4 l$ x9 a* p6 x6 k
################################/ C' Y5 O+ S, y* t2 k" V; O
& X+ `: H0 q E7 I) J2 @" b, `//Check both variables for empty value
- s( o. p3 y/ x+ F1 G/ m+ s2 b0 J: e5 W
if (!empty($_POST['char'])){& d Q9 ?+ d" Y7 h6 d
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
9 q4 u6 w& e9 ^- K6 g8 R- {4 |: r! X3 u
m_szName = '{$name}'");' a5 j2 o T3 F. G" ~$ s
while ($row = mssql_fetch_object($find)){# ]7 ?% {3 y x- y5 w( v2 I
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
S2 u+ D% G0 \# Z& A$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ( R4 u! y o1 N4 C: L* ~
/ b8 V* F: n: \* y( v' r, j[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
: c! E K0 @& y8 p* \( o
, u- F. d; n, L& v2 m[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
& Y' t$ y% x& {$ _& y$ e; |+ i, n) h0 o( C4 i
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
5 {" W* |( x- h B
6 [( U3 ~! l& L1 q! s$ Q3 A. c, ^2 s'{$ElementUpgrade}', '{$ItemPierce}');");
6 x1 d3 N. D! F# a}" r; K$ U% r& `7 q( m! _) i% A
9 Q" u) F! }- |7 P' c}
/ W, H8 `- _, ], M3 p6 s1 O" T
8 y5 C0 b7 V6 Q3 K4 m. J: A f8 }& D}
2 {: ?1 l3 A' U
; _; Y3 ~8 C6 P) f& ^7 ~$InitForm = InitForm();
! I1 \4 H2 d% G$Listener = PostListener();
# a' R; z' |. Y; ^1 W4 _0 B( z; B
+ Y' Y( c0 C1 l2 v1 {. D?>) Q f1 o9 x8 [% g9 z0 K
% r! _9 c: b2 N( H6 |
0 h' ^" R: H2 g1 u; {" N; O; Q: e
' f' F0 g6 r$ z
3 d* G. s9 f) z& V
|
|