|
|
<?php' l: U8 H4 Y. m2 R) o3 I' G) c, e7 R
function Connect () {' z5 i4 r, T4 H4 n+ x2 @+ t4 u
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
' _2 z* t: N( v$ f" ]% j2 H6 x9 L$ S8 G7 r
Failed.');
3 ], U, \: H: ] j}: |& Z( a+ a6 W! G
Connect();1 L4 I V! a2 H V6 e5 A6 x
0 V( s( m% @6 k8 h4 @
function InitForm(){
/ P7 I/ q. F0 A+ q- Z+ ]) f//layout for the form
/ k3 }* W- f8 u( P* l3 secho "<strong>Send Items.</strong>
( F3 c, o/ ?% d& ]) ]<form name='select' method='post'>
; l3 v' H* [# J. c" A6 ~" ?<lable>Character Name</lable><br/>
# C3 x7 X) Q$ S W<input type='text' name='char'/><br/># n/ q( T. s; V0 n
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>1 Q2 B% s7 _! \0 ^
<input type='text' name='item_name'/><br/>8 B. @4 a+ N% i- K0 O! p1 n$ p
<lable>Item Amount</lable><br/>: ~6 |, Q7 y) L! \
<input type='text' name='item_amount'/><br/>; u5 u' D3 b$ u
<lable>Item Upgrade Amount</lable><br/>, g G9 B2 l. z# i
<input type='text' name='item_upgrade'/><br/>% M* g: R! T h, `- R9 ]5 ^
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
" }7 `: h" L# a1 D G
: `2 _0 [. ~4 X' V0 ?</lable><br/>
! o3 y! O% u- A- j- K<input type='text' name='item_element'/><br/>3 K9 Z- |8 e8 J# D3 [( v T
<lable>Element Upgrade Amount</lable><br/>
- x/ \+ ^; b* r. j7 l5 ~<input type='text' name='element_upgrade'/><br/>( R2 b& V2 g8 D' S% q
<lable>Pierced Amount</lable><br/>9 I$ V4 j! v, L) p1 w' q: W2 d
<input type='text' name='item_pierce'/><br/>
6 f, U& _ A: P; l& c2 x<input type='submit'/>1 X$ B* B7 ]/ a$ l
</form>";8 ?" E/ m' l* b6 m m
}
# T1 k- v& K9 u1 Y/ Y) B# k5 {$ ~* I2 b9 V4 a& n
function PostListener (){$ s, `2 O: T1 L5 \+ G, i+ \
//Add more post variables if needed and add them to initform() function aswell
2 J* P3 t- u: d, x# N+ s+ R/ g6 l4 ?2 s
# S+ {! `! {/ B) w" S3 [9 G$ s################################
# o/ g$ s* [1 O+ r: J##### Connection and Post ######6 @( @ \$ U% }* D* V: k% t2 o
################################
$ `! Z: M) P& u0 k$name = @$_POST['char'];
8 x- ^3 `8 N- q, @) i4 ~4 Z$ItemName = @$_POST['item_name'];7 b; Z9 [5 ]0 ^+ y! c. v& A) E+ r
$ItemAmount = @$_POST['item_amount'];
2 v0 _! e: L$ R$ItemId = @$_POST['item_id'];
, E/ m5 b5 G/ b, R" t1 |$ItemUpgrade = @$_POST['item_upgrade'];
8 Z% p( y9 r) G' K9 n1 Q( {$ItemElement = @$_POST['item_element'];+ P$ j, H4 [: M% t4 e! a! B
$ElementUpgrade = @$_POST['element_upgrade'];# Z0 R) v! I% R6 B3 R3 M% |; f$ N
$ItemPierce = @$_POST['item_pierce'];
# a- w2 c$ S$ u################################
5 T0 r" ?7 C O& f
& ~0 [& G( L3 R1 z Q, I, J* Q1 l//Check both variables for empty value0 s9 a8 S: y1 }# S6 \
' _+ q8 B# M6 V: Qif (!empty($_POST['char'])){
% r' W% z* n, J0 c/ d$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where + I1 A y* I' r3 X- o s* d. ~0 O7 `
5 q2 C/ e. c# em_szName = '{$name}'");
7 R7 f( @. n0 @ R% r$ `6 Gwhile ($row = mssql_fetch_object($find)){9 Z4 c% G+ j$ K/ E8 w' r
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
4 H' C3 D0 c) B w& O; \$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], " _/ }; m& c& Z3 C5 e8 F# a
+ ~8 P) e- M2 k# c8 |% P4 {. ^9 I[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 4 q. d. c T5 ]9 z V( j
% {) A6 u/ | [3 |+ }7 p, c/ T9 a, p
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
1 V% x$ z1 F O& o" R( ?2 C/ y" D5 N- F
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
, Q( y0 R5 b5 i) t7 f" d- f7 V' L1 a6 \ d* K& O( \* P0 n
'{$ElementUpgrade}', '{$ItemPierce}');");
a# K3 X! ~2 G3 G}
* \9 J. H# ~- |: Z7 ?+ S) p2 L! \8 N6 x; |% z
}
9 k9 O5 K R' s8 V9 [* |% q t( [& X3 u V- e' o
}1 T Q# ~) c) r: ]0 V, E
3 N" V6 m+ \1 k) w
$InitForm = InitForm();% K' m/ `+ @$ Q
$Listener = PostListener();
) B6 J* Z& S# B
& m: ]$ |5 t. H. R: w3 V$ N?>
6 p" X' A% u$ H1 L# [. H: {
5 N8 X9 o: O7 ]$ y* O8 m% v
! W& _, ?# v6 x6 D0 ?
% C/ T/ c7 v, {& J
0 t- v) ~5 T2 _, W6 n4 M$ ] |
|