|
|
<?php+ @+ O4 i- Y! ?$ T
function Connect () {
6 [: p3 V1 Q; X, O$ w0 ?1 c' Dmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
# U3 i3 t: T4 ^0 P
# {' e4 e! _2 S8 R5 j1 Q) gFailed.');
$ V8 e- \+ K! S- @/ |9 W) i}* t! c5 s. s0 i( R, u5 R
Connect();
6 V5 r% O0 [- `+ }% g; Z- r- t# ~( k' L) f5 R$ |) I
function InitForm(){6 f9 d! }# y8 `- f8 M) Q$ t2 Z0 x
//layout for the form
( a+ E, `4 L: _9 x: H4 m0 f; ~echo "<strong>Send Items.</strong> w! @% h' n0 m! q6 a" A# p
<form name='select' method='post'>9 z1 L6 `2 T; i8 q- N* z' }
<lable>Character Name</lable><br/>
/ R1 X( [) D# N- f' ?<input type='text' name='char'/><br/>
6 w! i# S; x+ o9 f! t6 ?3 Q<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>1 f% W# Z) ^1 L
<input type='text' name='item_name'/><br/>2 D6 C% f4 @9 z* t" e% Z
<lable>Item Amount</lable><br/>: ]8 s& G: Y% ]0 T1 N
<input type='text' name='item_amount'/><br/>& x! ~6 V5 X3 N" M
<lable>Item Upgrade Amount</lable><br/>
$ r+ C0 s0 P, F) [; z7 J1 i" b<input type='text' name='item_upgrade'/><br/>; h2 w) \% c! X3 V
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
6 T7 G7 F& u {- t. L4 K
7 T$ U, w, Y; q; o! q) k& p</lable><br/>6 i1 R$ p6 T, N7 t9 E# d7 M
<input type='text' name='item_element'/><br/>
3 W$ v% N$ q6 a$ U0 M7 n! n<lable>Element Upgrade Amount</lable><br/>7 [/ P8 A5 p* D1 Q$ u. r, f
<input type='text' name='element_upgrade'/><br/>1 d# V3 H" h5 ?
<lable>Pierced Amount</lable><br/>
) M t8 B1 h, N6 c3 K# Z8 C$ |& _<input type='text' name='item_pierce'/><br/>
4 K" M8 H0 s7 Q" |<input type='submit'/>; i0 Y+ a' i. U2 A) T
</form>";
) q* K/ s& E1 r}
$ z7 ]" r' m) {& p) g1 p+ E2 J3 f2 h0 A3 b& b
function PostListener (){
& F. P# J3 D2 X//Add more post variables if needed and add them to initform() function aswell5 a2 `4 w' M* W: O: U+ `% O! p
8 a N+ u5 Q$ t5 s7 j
################################
* @0 K% K3 [6 F) \& M+ p##### Connection and Post ######- [$ c/ Z+ q# H; B' q* M$ c
################################/ S3 G' ~2 d. n% r+ L5 K$ q) m( p
$name = @$_POST['char'];2 ~$ i* U, Q7 e. R6 V& O! Z+ @9 h9 ^& b
$ItemName = @$_POST['item_name'];) h( i0 h( a1 F2 I3 ?
$ItemAmount = @$_POST['item_amount'];
) j" |9 O! M( R5 i$ItemId = @$_POST['item_id'];: p$ z" T6 a# f% ~; W# k: |% \
$ItemUpgrade = @$_POST['item_upgrade'];
6 t! Z$ ]9 i- s* _8 Z' P3 W$ItemElement = @$_POST['item_element'];
/ z1 M4 e: B7 ^) I+ |2 ?$ElementUpgrade = @$_POST['element_upgrade'];
- x0 T: n3 v0 D3 p0 J% ]; u$ItemPierce = @$_POST['item_pierce'];
% H3 N6 o! q9 O7 p! n################################
0 Z% q1 p8 k! g9 a: ^1 [9 a
. d" L7 ~6 V( q//Check both variables for empty value
) e, N7 Q' y. {( M" k$ h7 H+ ]* v" k
if (!empty($_POST['char'])){% F" Q, k# v$ y( e2 Y
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 n5 X- N8 n& ]8 N7 K7 k$ P6 b0 s9 O& ]( Q" x: m$ o
m_szName = '{$name}'");
& b+ d7 y& g. G# F' y6 S. }) vwhile ($row = mssql_fetch_object($find)){
P9 q1 y, B9 G! L+ Jecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
3 y7 d3 N S1 L+ c5 G+ \& f$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ' u- c' ] n2 H2 ]
3 u, U# Y4 u' P# Y( W7 w+ G! e
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], . c. y2 p! I5 C' S- y0 e1 S
4 U: J6 n& d* r3 y9 N; D5 |
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 8 B. o% D& z3 |; [0 q! o$ h
. G0 x7 ]0 ?6 d) _2 \' ]3 t; [N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
" ?4 n/ v7 N7 M+ w% q! i$ n9 y) m% D4 E& p; |, W2 Y% {& S
'{$ElementUpgrade}', '{$ItemPierce}');");" q0 X2 Z W0 X. g2 i3 h
}
; x" t1 q! s- p! A! f3 g8 \
! b; ?# k' c2 p" ?}
$ e, r" `! c- E1 g8 {0 n4 u
2 P% X8 h5 _8 E3 g- z% Q4 u- z}
" U" X8 S5 j) o6 F6 e" p9 l% p3 y
# M' A3 y+ z2 m& ], t1 w- n* d$InitForm = InitForm();
8 A, s, L2 N, d( `- N( D" b+ B$Listener = PostListener();
4 D2 S# E6 \7 s i
3 Z6 ?$ p" v: I1 N( c3 b* B" }9 W?>
# _" r3 u9 b. q. q$ R7 c3 k% Y6 U X4 V% k6 v+ P
7 P4 L, h: f9 x" Q/ a# J. B( M/ M" T+ p4 ]8 U
/ n2 q3 K: q3 c4 F |
|