|
|
<?php
% R( H2 L. _+ f5 \function Connect () {
; O0 l! e: J7 |6 }! R& w! ]mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
# A F1 A( \( n+ j$ i# j$ W; ?6 X, j# @' }4 {4 X' D: k
Failed.');
' k: h# N/ y0 Q( n% H. R: \ |}- j& C5 U9 K$ q( G0 k$ b
Connect();
! R) d: I2 }+ m/ s9 N: ~" ?0 s' Z' y2 N, Z7 X& K
function InitForm(){- o4 K1 _, s- F- `7 H( p8 c
//layout for the form
j) R3 D* R( eecho "<strong>Send Items.</strong>& r7 y9 T- p# R+ j5 D$ C
<form name='select' method='post'>
8 m4 A; n3 l& a) ?" f: `<lable>Character Name</lable><br/>% U5 c/ q/ V; i& V4 I* o h8 t7 A
<input type='text' name='char'/><br/>4 d: ~2 c+ \: ]! l0 w
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>: U4 t! m, e3 h3 ^0 p6 o( w
<input type='text' name='item_name'/><br/>
6 `% U' Y# w: [2 `6 }& m" s<lable>Item Amount</lable><br/>
3 c5 R7 z! I" @, U& V4 G<input type='text' name='item_amount'/><br/>; Y3 _, W _% R
<lable>Item Upgrade Amount</lable><br/>
; I, k" B4 `$ k4 {$ ~<input type='text' name='item_upgrade'/><br/>5 O# C6 Q* b; m2 c# `# u
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
0 K. n: z' R7 b! }" V- P4 v* Z
3 F& h" S* [. h3 G3 r</lable><br/>
; A# {% `" C0 S; N3 U<input type='text' name='item_element'/><br/>& E* B6 u/ n9 \4 @+ ^
<lable>Element Upgrade Amount</lable><br/>
3 @9 C( k- C, b+ H# h4 E* { g<input type='text' name='element_upgrade'/><br/>7 _8 j3 s0 D7 p6 h
<lable>Pierced Amount</lable><br/>0 k# I3 \! G- A; v4 j, j3 |
<input type='text' name='item_pierce'/><br/>
* A% Q7 [' J" J9 m4 g: v. A1 ?' L4 h( r. a<input type='submit'/>9 i' e" i( R# w! s% w
</form>";
% S0 }4 [0 d9 U. A}
2 _9 N9 R B/ w" ~; Z. K. l U3 N; M3 ~% e! v2 u/ N
function PostListener (){6 D9 L. ~' r* J" r% W% D
//Add more post variables if needed and add them to initform() function aswell( ]$ n1 a) _, g2 x& b2 @/ L9 G
+ x3 E9 _! S5 {) D5 u# o################################% e: R4 {6 V: C; M0 [
##### Connection and Post ######
* _( p. ?: s( e# }# |/ W9 K) _( a+ v################################
8 Y9 _% p3 V' e9 t$name = @$_POST['char'];
/ S) m) [6 v) l2 j$ItemName = @$_POST['item_name'];. n6 u: B8 f# E O" G5 ^3 J9 v
$ItemAmount = @$_POST['item_amount'];0 f8 I4 B3 B2 V, [
$ItemId = @$_POST['item_id'];
) m5 C5 o* V! Z0 w. y) F- W$ItemUpgrade = @$_POST['item_upgrade'];
6 r; E+ ?0 `+ t' D% J' Q8 D& l$ItemElement = @$_POST['item_element'];0 t: d4 C: F( U# F# D' P% `0 |/ W
$ElementUpgrade = @$_POST['element_upgrade'];
! x: C5 L+ p3 r! F: T7 F) F7 e5 X$ItemPierce = @$_POST['item_pierce'];
! i, @/ s- K8 [' y _( i$ e################################
- g/ w9 x5 `# `5 ^. p: A! m1 b: j" \) O; f2 c5 e
//Check both variables for empty value! G- J4 h x( i6 I0 ]
. h% P; d M4 ]; z1 [$ pif (!empty($_POST['char'])){
/ e" U: R* t- p* p$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
* p; X7 V# B) w. R' ?6 J; `# |& o
( V% M9 J2 d) u# vm_szName = '{$name}'");
8 O. z- M, M P! i4 ^while ($row = mssql_fetch_object($find)){8 ~1 E& `/ S( @; Y. D
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
+ g0 a, L9 \6 f9 Q. u! P6 |$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 3 V* I/ J0 \6 e% n3 _) T8 e9 l
. t8 c. k) J, e8 b7 o
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], / z7 ^) \/ v1 K! t( g
/ @+ w" f8 w3 N' W/ E[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ I" A0 Q+ ~6 @8 I2 w5 v# D
6 `# ?5 s" I7 A( U0 LN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
" `% w/ }6 U1 P Z# b" k6 G" E/ c( D; w% B5 F% v5 A
'{$ElementUpgrade}', '{$ItemPierce}');"); V0 A4 Z* z' p U: B& c; y7 f
}+ F" m' c3 a: x! `( {
, f, g- a1 k2 b& m5 E}) X; k0 a- u) P1 B$ }% v
& i9 m5 f4 t: V% b! F U; g4 G8 {
}, k5 t) p1 [, S6 ~$ V, N
# D' `7 t. N4 v( r$InitForm = InitForm();
5 Y1 f( U/ r e0 w$ k: o: H4 @$Listener = PostListener();
2 Y3 P) N$ w6 J. u) i+ R
% Z' n* O+ @+ o& H?>* }( s+ Y8 s" O5 N3 z8 W$ Q# J6 j- S& u
! V) e6 O+ A, p$ r, q4 _9 ^7 u* n
) M' e3 z) T; c3 R& d$ V# T" p, V1 T
( _* O) b0 q! j- g4 d
/ _; e! }* ^% l |
|