|
|
<?php: @% b/ Q# b2 { n: D
function Connect () {
0 w0 y5 s* R/ g- i( W3 Ymssql_connect('Server','UserName','Password') or die('Error: Connection to DB z+ W' L. I% I- @, C
& _% X& E3 ?: z# gFailed.');6 h# l7 I" E% p8 H O) _! W8 t: }3 |
} Y, v5 ~; d' S, |( j
Connect();5 z `7 C; }# t2 X* d) P$ Z
5 Y* q+ Z; X, f2 A$ Y$ j. }function InitForm(){
: `1 I& b$ N, q1 V/ ^//layout for the form- e8 h# s8 w2 i4 F+ M. R2 v# W/ j/ @4 b
echo "<strong>Send Items.</strong>, Z& r Z4 ^7 ?' |9 X
<form name='select' method='post'>
Q' j) e2 D* i5 v8 u; R( N<lable>Character Name</lable><br/>" l$ x% T5 \; ]; C, I5 T: _8 w
<input type='text' name='char'/><br/>/ ]9 o% n! U$ Q8 K
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
' Q: a' Q7 R- e! m<input type='text' name='item_name'/><br/>8 ?1 c3 t$ U6 q& w
<lable>Item Amount</lable><br/>
. H6 b: {, a5 g8 @1 E<input type='text' name='item_amount'/><br/>
5 Y t. j" Z7 M8 k- b<lable>Item Upgrade Amount</lable><br/>
2 C2 ^+ p+ ]1 T1 T. o- D<input type='text' name='item_upgrade'/><br/>
# A n6 K' J1 c4 ~5 ?<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; e( o' }9 N# ~2 m. r
% ]+ [; c/ t! |, a% u8 Z( e</lable><br/>
- V- ]! V. p6 N3 c<input type='text' name='item_element'/><br/>
9 ~) h4 y2 Z8 h' v9 i<lable>Element Upgrade Amount</lable><br/>$ N4 V% L' b7 m& ` {
<input type='text' name='element_upgrade'/><br/>; E% D+ L2 ], y. j
<lable>Pierced Amount</lable><br/>" l0 E e1 g( F6 g6 p3 O o* M
<input type='text' name='item_pierce'/><br/>8 {) a1 y% h+ Z! y, C5 J' S
<input type='submit'/>
1 ^( o; d: R- V# m8 @- h1 \/ v9 d</form>";
T" s$ M9 H# w) k, K( S}: e: A6 L" v- v1 v6 _6 g
& u- \7 P' U( U' t: k ?
function PostListener (){
, ?; M- a) ?* V9 e4 T//Add more post variables if needed and add them to initform() function aswell
/ l/ A" R& j: I1 w- F( x9 Y9 P' R4 d C
################################
9 w+ R" b- C# Z, o6 e##### Connection and Post ######
5 z, E$ E# K% z: _7 _4 o" ^################################
0 D2 R0 \+ x# s$name = @$_POST['char'];
2 l: [. I- O% ~) ~$ItemName = @$_POST['item_name'];
7 M# M: t% ~* o# f7 B$ItemAmount = @$_POST['item_amount'];
* j; o2 H) B* B" T! S6 s$ItemId = @$_POST['item_id'];, e' C% x' U/ [7 U( v7 e
$ItemUpgrade = @$_POST['item_upgrade'];
4 a# a- j2 n5 C6 k$ R/ H$ItemElement = @$_POST['item_element'];
* @/ f* }) {9 G! [$ElementUpgrade = @$_POST['element_upgrade'];
) T6 H9 G! G5 Y m* z7 m5 C; l$ItemPierce = @$_POST['item_pierce'];; ~- D6 Q+ E N: _* I- I
################################
9 t# m; c0 J5 v: L" v
8 h" W: H% H: t//Check both variables for empty value
8 t% p' ]; {% c9 M) y! S& s, u& R2 o% y" v
if (!empty($_POST['char'])){
4 _4 H& O' B& v% M$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
{2 t3 G" S9 |7 A& z$ t# Z( S/ @8 q7 v w1 o6 z
m_szName = '{$name}'");0 a( N( `2 `, U# D' g* o
while ($row = mssql_fetch_object($find)){+ P7 }4 a0 y* W% {
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
+ I' V& A0 ^# v4 ]# t$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
1 {/ Y8 U5 o0 Z2 a t$ a6 Y; v9 I& S- h/ i
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
6 _2 ^! o' w6 f8 ]4 s4 `( Y- r
1 ^) F7 v$ ^6 U+ s) M1 e9 x. d[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', & h3 C! N1 V6 }1 N/ e. w
8 d, Z) p( Y& S) J6 h
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
" G Z9 _3 M% g8 i$ b& V7 J/ I3 n. f3 X; X I8 Z. y$ f
'{$ElementUpgrade}', '{$ItemPierce}');");
( B( b2 Z: V- w+ h% e: g4 b}2 e- e4 j3 p6 I5 }
: U3 T! r& ]% q( t}7 V( J W1 P4 i
2 Q3 M6 O3 D4 |; _
}
0 J5 k: U* q* ^: i1 F7 _. P5 `$ D" M, V$ I, S2 {( ~
$InitForm = InitForm();
- Q" D4 H% N- R$Listener = PostListener();
) f( D7 C1 z7 C/ O4 `. {' D# y; t2 h
?>7 Q. o+ g- ^, c* Y' w. C
$ w& r) |, w9 \( S& L0 [4 r. [$ [5 r6 x' T
. e7 _, b+ E) b1 ?! [, J7 j/ _3 L$ c5 j
|
|