|
|
<?php
2 q& r0 B# _& {function Connect () {
! W( y2 N$ \3 Wmssql_connect('Server','UserName','Password') or die('Error: Connection to DB : U! x2 V& i# N& Y2 e- c. O/ n
& T" x4 F& l& V% r) N' s2 M
Failed.');% X' L X% v3 J2 N3 z0 y
}- W/ x2 A' v! Y( U9 W
Connect();) `" y) n; x9 w& y5 _: j6 h
! L( T* D% a: C3 l% x; K* [4 h& vfunction InitForm(){
- s: k8 q1 Y& d: F3 _# J//layout for the form, ~* }" \& k# C4 e4 v* _. G% W
echo "<strong>Send Items.</strong>1 q( O/ O) h: N) U3 a
<form name='select' method='post'>
4 |: ~) @, o& X( D2 R5 z9 k<lable>Character Name</lable><br/>
$ W+ J; y* {+ K% ~, I* R2 D- P<input type='text' name='char'/><br/>
+ g+ G! z( {7 d- M<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>1 ^! G: ]/ E2 }: x/ b+ H: K
<input type='text' name='item_name'/><br/>5 B5 K# |( J& Z+ W6 E0 V: B
<lable>Item Amount</lable><br/>' R, }6 m8 g% F: Y5 Q
<input type='text' name='item_amount'/><br/> x( Y2 l; Z. j0 v
<lable>Item Upgrade Amount</lable><br/>4 \/ |6 J7 Z/ u4 }! ]
<input type='text' name='item_upgrade'/><br/>9 a! ^! M7 H# a# `+ ?
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)( p+ r, C+ u& }2 F
; m; z& t5 a6 |& X o# ]
</lable><br/>
7 b& a; W6 Y- [3 H2 T" A1 c( z<input type='text' name='item_element'/><br/>
( x" j- B% X" l: v3 j<lable>Element Upgrade Amount</lable><br/>
* m+ [/ o! [5 K* ^6 i<input type='text' name='element_upgrade'/><br/>$ T' a2 f9 P: N6 r8 R
<lable>Pierced Amount</lable><br/>
# v7 U4 y" m2 M# c; X# Q<input type='text' name='item_pierce'/><br/>
2 r. X* ^* N/ t<input type='submit'/>
5 e* a. o* r7 N0 g0 I( ^) O</form>";% a; T$ K8 ?) X# j0 b
}+ m" R' ]+ A0 s" z
( P$ F! K$ A, Q% B
function PostListener (){
$ P& u& o a9 X5 j& A//Add more post variables if needed and add them to initform() function aswell+ z* u. V- O8 n8 ^0 Q+ d" I9 |# }+ j
- C% s& c% l1 m9 y( z- q& A
################################7 ~4 u, I& B# }) i% m/ L
##### Connection and Post ######+ h3 g" ^. y9 f9 I
################################8 M$ U0 |: K) o# ~) {
$name = @$_POST['char'];
% S6 b; |% L/ M) [$ItemName = @$_POST['item_name'];
* Z! Q0 i% m2 p, X; w1 Z$ItemAmount = @$_POST['item_amount'];
1 W" Z+ G5 P: d( B$ V. y* S! ^7 S7 m$ItemId = @$_POST['item_id'];
9 V( y2 R0 {: ]# _2 ?& X2 w# Z2 |- w$ItemUpgrade = @$_POST['item_upgrade'];! U$ N( J4 X0 x+ m: z5 B
$ItemElement = @$_POST['item_element'];4 ?1 t) D& `5 F' @6 m$ F- |) O
$ElementUpgrade = @$_POST['element_upgrade'];% O/ H, ?- t4 Z" w0 f1 C
$ItemPierce = @$_POST['item_pierce'];# B. \: E& j% e
################################
. E; } \# c7 K2 Z; [- X# T/ O$ n& X2 N& `4 D% O4 s5 z/ ?3 A
//Check both variables for empty value& O/ ]8 F1 M4 V: y& n; N& N9 i
9 y; L; @" L6 ^* R ]) N3 Aif (!empty($_POST['char'])){
3 M! t9 x' j; S w _7 I/ T$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
! e e2 X8 L: ~
( w' Z/ e' x \. F1 H& Lm_szName = '{$name}'");
% `, u- H% B7 |, T, E3 e5 Uwhile ($row = mssql_fetch_object($find)){% d% o) m0 V" B: U6 X
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";! @2 E$ u" P$ F$ z4 j& `
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], * M( P% W* W, j+ i. }% g4 D( h
! A3 a( g% g% Q: v' T% r+ A[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], J. a6 p7 \# i3 l$ L. A1 U' V
9 E% N( T- q7 h! ~
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
! W7 b: v a. |+ w1 F
4 j" N5 |, p( F; T5 v3 ON'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
5 T: ]: Q# I. X& v
" F9 m) A9 l( ]. j3 m'{$ElementUpgrade}', '{$ItemPierce}');");
( v4 t. X1 r1 a8 X; @}& M1 x. F& @, j% m+ _
$ m' g9 O6 w* ?2 y" m( n( y# J}1 m4 F3 q& g) H" c$ V
7 w+ ^" z u5 l" t: `/ m7 ~
} H4 v& H: Z! R7 |
5 y/ c/ R8 C/ g8 Z' c% I# _7 O8 ?$InitForm = InitForm();
& m( N3 C1 B+ W$Listener = PostListener();6 w6 n8 l2 P6 ]4 }, l* p
( C. E2 w6 z! T?>4 G; Q$ Y m* V: \& N U
( k; Q# Z4 [8 S7 v4 ? f2 r5 U1 z% r" n& G& k
; B k$ F" L2 y4 m
1 t/ f ?+ m, g6 q R: y3 T |
|