|
|
<?php
/ ]3 D! Z5 c# Z2 R9 h* @8 Lfunction Connect () {
. A, G& W2 Y- H) Dmssql_connect('Server','UserName','Password') or die('Error: Connection to DB , }" c/ n. B( {1 e5 @$ {: V" w
3 k0 c& Z \. ~7 [8 }, u# U
Failed.');( |% W1 X0 j r s/ c
}
/ z# s, M) x9 E! {Connect();& S/ f( I! f& s1 p8 j3 o
- Z1 K |! g6 z5 n- y/ J0 ~function InitForm(){, }1 O4 L! K' [* {, g& }. d8 j; f$ k
//layout for the form, K% U& W2 @7 d3 _- `3 N
echo "<strong>Send Items.</strong>
$ X' ]3 d8 r7 \- U, g<form name='select' method='post'>7 z, q9 V& I4 r$ C! ~
<lable>Character Name</lable><br/>3 o, U7 K, M# ~. \+ I3 J5 G0 T
<input type='text' name='char'/><br/># q% R/ p5 H8 @" f
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>* X1 f% { D1 p1 I
<input type='text' name='item_name'/><br/>- v( ~6 l/ Z* j
<lable>Item Amount</lable><br/>$ z+ _. \9 K2 e; C
<input type='text' name='item_amount'/><br/>+ U- ~7 }& O$ s% d
<lable>Item Upgrade Amount</lable><br/>
) n# a j' ~) O<input type='text' name='item_upgrade'/><br/># {) f# S+ n' a; a8 ?0 d1 h( _
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.); G( d; j& u$ t3 |& V
3 J! Y$ U- q$ u3 @) x
</lable><br/>
' W3 E, `8 Z( g<input type='text' name='item_element'/><br/>
: }5 H5 a7 g% C9 Z" Z<lable>Element Upgrade Amount</lable><br/>* u, n" C! f# t) F3 N7 T) u: |
<input type='text' name='element_upgrade'/><br/>+ M: G4 M9 F: T
<lable>Pierced Amount</lable><br/>2 c3 o! P" n/ `1 P6 @
<input type='text' name='item_pierce'/><br/>/ x% V# c/ t8 F- \4 y
<input type='submit'/>$ O: c4 E5 o& C0 D! G
</form>";3 i/ T2 o; \" T& L& p* \
}
! A( u5 S% n- n- p& T
: b g5 a. I/ Q% b6 Nfunction PostListener (){
1 N, Y) {, j0 W2 |//Add more post variables if needed and add them to initform() function aswell
" U' d% r" Y N4 D
# V' }% u3 v2 ~1 p( s################################6 L9 \4 r7 U. |% O6 f0 h
##### Connection and Post ######
3 p8 n8 z* b% }& A5 d3 k################################
( b2 n% H+ Q$ G$ V$ n* n+ Q1 s; U0 e$name = @$_POST['char'];
) @4 w/ x( H: m$ItemName = @$_POST['item_name']; g9 E2 m5 c6 z1 Q4 _
$ItemAmount = @$_POST['item_amount'];
1 i/ V4 A& i$ E8 g; u% T9 W$ItemId = @$_POST['item_id'];1 V% m! v' M7 `: k, h j
$ItemUpgrade = @$_POST['item_upgrade'];
- x+ f. p% a: l7 H$ ^& f8 ~$ItemElement = @$_POST['item_element'];5 h) q- r+ C) C$ y
$ElementUpgrade = @$_POST['element_upgrade'];7 z9 i/ k4 L" P7 b
$ItemPierce = @$_POST['item_pierce'];
) O+ h3 @+ w3 G################################6 N1 j; k& L' E8 D
" e( B* Z, b9 p
//Check both variables for empty value
8 o# ?, ~1 f" D: A2 J; Q5 u0 P! f, x* [1 _ S3 o
if (!empty($_POST['char'])){
& X6 l2 k8 E* [! z0 |% R6 B$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where * b6 C% p- e" v9 M; I
+ `8 y. J% Z) E8 V; \" H. um_szName = '{$name}'");8 [$ i/ \. v* ?/ i: F
while ($row = mssql_fetch_object($find)){
r- _. @9 D# k4 wecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";. n- z8 f( g$ k1 M5 t
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], " x+ y( u$ m" k" S% ~5 n& }
" q1 J% y" s' K; k5 p[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
; q' n2 Z3 g8 x% o) c# A/ z3 V% b8 v: g
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
( M2 r) B f9 A Z5 a
0 X+ ?- `: u3 hN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
! H+ F, \- h' f6 O$ J, b5 }8 e) {" l
'{$ElementUpgrade}', '{$ItemPierce}');");7 m/ ?; m4 r# x. y1 m0 p
}
4 d/ ?+ U# B: V7 A$ Z2 p `& i3 y* V
}0 q, q( f, a1 [( u0 c
! X% d) M4 q7 p2 f9 ?/ e* ?( B}
- P: r. N4 J r/ Z8 V# W1 f% {" c1 s1 t4 z! w1 p$ j- L( v; a- e" ?
$InitForm = InitForm();3 N: @1 X5 F) L1 z! O4 K
$Listener = PostListener();
5 i+ H2 F' |( D$ I4 t! I! u" C: f1 E% e3 s4 ^' f
?>
5 t# n/ E" {. T
F3 l1 O4 R7 _: v' y N' a4 m
" ~+ L1 F1 f5 m3 q$ w# j. d; ]+ \' ^, m# g
- }) }( {0 @7 Z. k |
|