|
|
<?php
3 m# [# `* E$ Z& V' xfunction Connect () {
/ S" r. }* ~) x D3 I4 ^& L9 Q% cmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 2 R# T c6 ]$ R8 ?; w
& e5 U+ f, y% W; Y9 {+ j
Failed.');
; W" s& |$ ^; K2 @3 [2 U}
1 I; r% }8 f; z$ u2 k BConnect();9 `& d3 ^0 c# k! T# u
$ F+ }! a- k( t& J4 c8 }! w
function InitForm(){
- @9 t) Z% p% y2 Q* t4 Z//layout for the form
8 F* a5 l3 L8 X& Yecho "<strong>Send Items.</strong>
- a# j( [. _* W% A; [! q0 x<form name='select' method='post'>7 W+ z3 n5 p' g! p" K
<lable>Character Name</lable><br/>
8 P8 K5 F6 l' U; w: C6 t<input type='text' name='char'/><br/>+ U6 j' k: D( l$ U2 `! b% f6 R2 ?
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>* G( D( V, Z2 M! l: H" b
<input type='text' name='item_name'/><br/>
0 i3 a9 Z. P" G: B& i5 P<lable>Item Amount</lable><br/> K% {- z7 Z* I t1 M! h3 v
<input type='text' name='item_amount'/><br/>/ d) y$ R1 m* ~5 o1 ]# c
<lable>Item Upgrade Amount</lable><br/>
, F: U1 ]# F1 y<input type='text' name='item_upgrade'/><br/>
0 l& T! W+ h& Z<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)% p- g, @" j' }7 Y( H7 a
0 z% O5 f/ R, s
</lable><br/>
8 k4 o( z7 i/ o& W1 D<input type='text' name='item_element'/><br/>+ J; x. H) t( p- Y: l% b, ?; u! J
<lable>Element Upgrade Amount</lable><br/>
2 H! O7 g( x! |2 C$ K, s ^2 u8 A<input type='text' name='element_upgrade'/><br/>/ s& k: I& v7 _. \" }9 X7 r
<lable>Pierced Amount</lable><br/>
& _6 u6 ?9 N9 o& q( C, }<input type='text' name='item_pierce'/><br/>: r9 _3 L7 V* p
<input type='submit'/>; X' G$ v. H [5 V
</form>";1 \$ _/ n/ e: i6 a' x
}
0 k( w1 x6 q# k0 \# m. H
, H0 K, Z3 r! ~- @5 e6 x d! Dfunction PostListener (){' h$ B$ P0 X, [4 @3 m8 A
//Add more post variables if needed and add them to initform() function aswell8 A( o2 H2 d- @$ M0 D) \
' M5 u' [9 J2 S
################################% i/ |( V3 Y; o# c8 |9 i, Q* D4 u4 {
##### Connection and Post ####### E) v* e( F5 c
################################( V, x/ L: c: C# |+ G" ]% Y
$name = @$_POST['char'];* y# o! W/ a# K4 l% V% |! m+ q& Z
$ItemName = @$_POST['item_name'];
! a# u+ T" S' s& h) N0 W i P' \$ItemAmount = @$_POST['item_amount'];$ D5 p/ B' x0 T7 k' j1 k1 B
$ItemId = @$_POST['item_id'];
3 j1 D5 ?2 R0 `; _4 \0 Z# w2 ~$ItemUpgrade = @$_POST['item_upgrade'];
' q0 p5 }8 M/ X$ItemElement = @$_POST['item_element'];
6 [! F4 T" i6 P( A; [- Z0 R3 d: i4 O$ElementUpgrade = @$_POST['element_upgrade'];8 K: V$ J& }; E% C% d) J
$ItemPierce = @$_POST['item_pierce'];
, K; X8 N+ K2 _' g6 \0 D C& L################################3 L3 x( P( n/ H' I
' P( M4 W, [1 P3 O
//Check both variables for empty value( m- M X# ~' X" p6 L- q: a' C
) [ J3 g' c9 @. \% q( n. k7 u
if (!empty($_POST['char'])){
0 }" C2 L1 N1 [0 A+ }. Z: H$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
! T J! Q; Z6 G, ~+ z3 V* s% t5 _- l! {6 m7 |- a
m_szName = '{$name}'");
( M) m# J* M' dwhile ($row = mssql_fetch_object($find)){* \: Y5 b, X$ k: C* N9 ~$ w; }8 m
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
' U$ M1 t2 ^" f+ D. p) G$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
! \5 f; i. t! }' g: p' x* N4 e+ C) ]' T
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
9 T) X7 O5 N" x9 W1 h
7 h @" `. Q5 B6 B a: q. F7 n W[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
" w* x4 q0 _7 M! M+ i- Z* p& M" F! u3 F, P' Z
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', " ~8 \% t2 r0 {3 E- h) ^3 ~% \
6 t6 ^4 w; }$ d) I1 a'{$ElementUpgrade}', '{$ItemPierce}');");
/ e6 h1 O" C$ j' k8 D% @+ P}9 \* z. h" z! a: u
I# r! g. B6 h5 |/ ?- D}& a5 K- W( C' Y, \
[0 w) n7 g9 S/ c5 R! ?8 _0 K}
% ^/ w- c/ N# m* T
6 u0 Y3 a L. T% D8 ?( |$InitForm = InitForm();6 d# ~8 ~ G r8 M
$Listener = PostListener();) G1 n# L: m1 Y4 @
- N: l# f2 ~/ j" j; g4 B5 A?>
! n1 R) D' }. [( j( j/ i+ o* x# `+ v7 t" ?
$ Q2 B/ |1 o& t( l, c( I
+ W; l5 d/ H+ c- K' \3 g3 \4 i
& f$ f" G* b, i1 _8 g9 `
|
|