|
|
<?php0 l! f4 L6 A4 K8 R. C" n
function Connect () {
+ ~( } w* @6 \3 H* T4 kmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 8 {7 b- R. ^' p* \- @3 Q$ v$ e- V
; `5 U" S$ q, i1 ~
Failed.');# @5 O$ s8 A9 h) u' U- a* U
}
& S0 X& B' u; \, U% O! [Connect();
- V. y3 P- ?4 z4 \) G" N/ P& T
function InitForm(){
; f: [9 O; f2 V5 X5 ~ x" E% p//layout for the form
' w8 Q% c5 r T2 Oecho "<strong>Send Items.</strong>! r4 J4 I5 h" S! S4 F( ?
<form name='select' method='post'>8 L) U; g7 ]1 O
<lable>Character Name</lable><br/>
8 E9 ?: h" A. g k' K<input type='text' name='char'/><br/>
; s2 [4 @+ ]7 P! h' A<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
& [0 y5 ~( {6 m0 H<input type='text' name='item_name'/><br/>7 Y: o8 C, }$ h$ O: T, A
<lable>Item Amount</lable><br/>. P9 ]+ L+ W: B) e2 n- X. ^ v
<input type='text' name='item_amount'/><br/>6 Z) J$ }+ k- b h
<lable>Item Upgrade Amount</lable><br/>$ w2 t8 w3 D- w# _; e1 U+ B; B$ H
<input type='text' name='item_upgrade'/><br/>: c% N. _8 x( }: {
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
" U( S: P" E. @; i
$ L1 R3 P; p% f) W1 t/ u4 Z. T</lable><br/>& Z) j! P( p+ p
<input type='text' name='item_element'/><br/>8 z) `+ ~: }# o
<lable>Element Upgrade Amount</lable><br/>7 ~5 a& Y0 i/ x8 T G
<input type='text' name='element_upgrade'/><br/>
0 s' [9 `7 a6 D( O7 K3 g8 T<lable>Pierced Amount</lable><br/>
9 q8 {. O- n2 y3 F5 L& ~+ E<input type='text' name='item_pierce'/><br/>
; Z- F1 L- c! c0 ~2 f) I3 i+ w<input type='submit'/>% {6 f; ]' H, y `1 W& m, U
</form>";+ c/ F7 C' R0 B& [
}
3 k/ W/ a/ l( i0 ^: T6 Z M2 L- b. X/ K) Q
function PostListener (){% @# l- l1 _4 Q9 L4 f/ Z
//Add more post variables if needed and add them to initform() function aswell
( ^3 Q" n( s) ]8 N8 j. T0 N. f! z
9 v! G7 e5 K8 p$ W################################5 Q5 E: o2 o5 R
##### Connection and Post ######
2 j( v# d$ u9 a# Q################################
; j3 {% a. a$ E8 L$name = @$_POST['char'];
0 o5 q; s8 y& S2 v/ t" \$ItemName = @$_POST['item_name'];5 S8 v4 a7 e3 a$ X+ O
$ItemAmount = @$_POST['item_amount'];
* n8 `8 Y |7 z; @2 u. `2 T$ItemId = @$_POST['item_id'];
Z$ D- |- k( a) X0 ~- W$ItemUpgrade = @$_POST['item_upgrade'];5 ?7 \. W- R& P' f: \, d5 N: W
$ItemElement = @$_POST['item_element'];/ E6 j, v }: ~( A T
$ElementUpgrade = @$_POST['element_upgrade'];
9 m- U# w7 c% \$ItemPierce = @$_POST['item_pierce'];5 O. O/ q8 ^# C8 `6 C
################################
; c( D( z4 t$ {5 [" C" b4 v$ [2 |( k" q1 Z/ @
//Check both variables for empty value* t0 W& ^$ q0 @: y4 a& j
2 M# ]# _! C- z3 r7 \1 u# V, }
if (!empty($_POST['char'])){
$ r& H2 X+ E; l9 M5 U$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
5 X+ a8 C3 x! \0 t% t. n- O2 N- e
m_szName = '{$name}'");! D! B3 R# J9 |& o% |
while ($row = mssql_fetch_object($find)){
7 D8 ?+ y. k& j0 Techo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";0 t6 c) | W5 F/ ^
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], : A" J5 U3 t( [* D: w0 C
X5 v+ a1 T/ t# a/ h" `9 a[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 3 E5 F! \# f; y
8 p) ^+ w% K% N. o- r# \
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 0 z0 j Z, l; j+ U% T6 _
- h1 X- x) h% N+ B; F2 V, FN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
/ g: Y; A* c+ |9 Q
" V9 l; ]' t4 B% R: n9 M'{$ElementUpgrade}', '{$ItemPierce}');");
: r3 v/ I# h9 g3 M/ Q}% P) t' h; A+ }0 d) h+ n6 J) l
5 h" l9 z5 F$ u, f5 C* b- [
}0 o+ Q _2 V/ N* H ^: F4 f. o! L
% `. W e* l; w}
0 } v# H( m1 _ T2 H1 F. d+ c% I( @2 k9 m: Z u& s
$InitForm = InitForm();
( ~* c; T0 C$ G2 I) A: b$Listener = PostListener();7 P& U' [+ _# K0 p' d L
2 e9 @# ?& ~9 a/ H. y?>0 b( H6 c4 f- l' W* ~0 z& V' M
# f! Q* E6 L I- o; O
# x- i4 J: H8 R+ z- R0 d3 D) l8 j' L! G! k1 W& C1 L
1 q! W0 ]. B& a6 F
|
|