|
|
<?php1 y. r7 ?4 I8 R/ E5 t
function Connect () {4 ^# p' ^+ j& u+ d3 b, F% i
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
7 Y+ ]0 x+ z" g$ f H" X
8 | d7 Y1 W% s. w6 z! h1 LFailed.');0 c l- W+ M' x# J
}7 v- p `" R- ?
Connect();+ |% C/ O! L4 B$ P" [
9 n& H( A2 A* Q2 V3 p! e, N/ Vfunction InitForm(){
& o( N6 j0 v; P) \- {6 b//layout for the form) p( C2 B% a: c6 d3 c1 a
echo "<strong>Send Items.</strong>
: c- I9 b) @- C) ~$ d0 R3 ?& Q- A<form name='select' method='post'>
$ o+ v; I. d& k8 A+ c<lable>Character Name</lable><br/>9 O7 G4 W7 o# m, c; v2 \! [6 ^
<input type='text' name='char'/><br/>
$ G; U- ]3 C. U' x7 u<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>! F, M `- ]$ t& Z* G1 o
<input type='text' name='item_name'/><br/>
2 N2 |, n' f: J5 p<lable>Item Amount</lable><br/>
& E p% k: P* y. d0 m8 O' `<input type='text' name='item_amount'/><br/>
' d6 Y2 n1 D* i, l0 Y; @ o<lable>Item Upgrade Amount</lable><br/>
2 l* q2 B$ U8 P* R5 X, S<input type='text' name='item_upgrade'/><br/>
( }& [4 w' ?7 P C+ h<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)( |8 c, Q. g/ n9 q: n
" l ^* j. V t, B( G- k</lable><br/>
: M" E) z5 I, z; g& y! m1 e<input type='text' name='item_element'/><br/>4 r u5 L( D1 q* R4 l' z, F0 G. D
<lable>Element Upgrade Amount</lable><br/>
/ i$ k/ H4 ^8 B- g<input type='text' name='element_upgrade'/><br/>9 ^: M( K* t0 `! `: ~
<lable>Pierced Amount</lable><br/>
X; n1 j1 l6 i# J/ [<input type='text' name='item_pierce'/><br/>
$ e& n# J) t1 V6 ?. |<input type='submit'/>
: x6 }1 Q0 V) S& `, H. w X5 _</form>";
8 C2 a2 x3 e6 f$ L7 A' j3 z) s7 ]}+ R) z6 Q @# k3 `2 w6 }
" e4 A5 E4 W% k; L6 C+ F. t# z) z% R
function PostListener (){
T5 D ?% y' [0 N//Add more post variables if needed and add them to initform() function aswell
! V, T2 F' A* T! M! o" I$ o/ F3 p _* r
################################4 ]8 M0 l7 T/ ~0 U$ p
##### Connection and Post ####### ~5 ]7 N$ X# b
################################; ? G/ `1 Y+ U! o0 w
$name = @$_POST['char'];5 ^2 I1 L4 I5 b! p4 Z6 g6 x
$ItemName = @$_POST['item_name'];2 s+ N+ s* O, g! N
$ItemAmount = @$_POST['item_amount'];3 o1 N- A- V4 u# r& p
$ItemId = @$_POST['item_id'];. O# V I" J# h3 U
$ItemUpgrade = @$_POST['item_upgrade'];
3 k9 V7 `3 }. E$ItemElement = @$_POST['item_element'];
$ o) R- z+ V. Y# P ^; r$ElementUpgrade = @$_POST['element_upgrade'];
; l* i; d+ x4 C3 L2 Y) }8 o$ItemPierce = @$_POST['item_pierce'];3 |# Y7 |8 u% R# D; [
################################
( [4 M* S% q0 V! J' y4 F- |- K: l: Q1 B) T0 [$ T& c. Z- i4 q Z
//Check both variables for empty value
% |9 [" p* |( h H$ e+ S, p [
' e. P) \& M5 w) K9 R+ a& ?if (!empty($_POST['char'])){
* f/ r' l; a; [1 W) b4 l9 x# a$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
5 H3 V! m) z7 p: O" x1 B: d
; H0 S3 }# m: B8 Im_szName = '{$name}'");% B. |+ B- L- [/ E
while ($row = mssql_fetch_object($find)){. z: V, j, L4 }$ `8 k N
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";$ {+ n/ \8 P3 B
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ! U) j8 Z" E- ]4 W0 k( p
2 y) V5 |; ], [# j, X5 Z" q
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
3 C. w/ b/ o1 q- E* j% x
5 T; P& [, l) I[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% A' h% D4 Q# v4 C/ J, v- h
/ Q" H ]8 o7 \- \N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
" y/ F/ W* r# P+ H, E5 ` R, H% I( d o% M5 ^( D, X# C) u" P* `
'{$ElementUpgrade}', '{$ItemPierce}');");2 }4 g. I! p/ g* u7 y. u% ]/ Q" k: {
}
, U* s: r9 V) I6 M8 t5 }5 n& n" i( s. }4 C; @2 g9 a6 r
}+ G) ]0 s! w" l( m* l
% K' w" V) L- Y0 N- j" K3 u! l
}
& R1 X/ \; h# Q* N
) j ~, k1 R9 j7 I& ? Y$InitForm = InitForm();
$ Y' d" a* E6 a( V8 H/ g- H& p$Listener = PostListener();7 \7 ]- E: j& ~" Q& q
$ r" X/ R2 c! O1 F& q8 }" k: n?>% d* G( ]% r! D7 l3 _7 ~
. S, o* K' b/ d! s4 D, G
, @2 c) ~- _! x D
3 l6 E( M6 ]# B/ Y) N0 G
3 A( m- O8 c9 {4 @7 G
|
|