|
|
<?php
1 P4 Z7 C7 @/ N3 j4 Kfunction Connect () {" c6 L- m$ m) q
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB ) p9 i+ Y O y( K8 F; d$ Q
# C' X( Q. r7 A" d3 w' T Q
Failed.');
3 n/ l% J2 p) ]) O6 X4 S7 }}
3 {4 c. |. U, b {/ _" T9 f# UConnect();
5 s5 ?- l2 S& T2 Z, G% g
9 S8 [( @7 R5 _) Z7 r, A( H: |function InitForm(){
1 M, \2 r2 Q" A7 H. k! L. |+ g//layout for the form; @# C2 E2 ?5 ~) k$ D) o
echo "<strong>Send Items.</strong>$ [' i R7 t5 E: X* Z( a8 ~+ w
<form name='select' method='post'>
4 Z7 q$ k5 j0 I8 ^, ?) C<lable>Character Name</lable><br/>
& o8 X* C& e+ h1 R7 l4 Q5 p7 E<input type='text' name='char'/><br/>
: s8 P. {/ e0 K1 g* _7 m<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
- y( `5 R5 j* r' }1 U3 X' p; W<input type='text' name='item_name'/><br/>7 w) O/ _1 Z- ^
<lable>Item Amount</lable><br/>. K. D% { d1 K9 c! u
<input type='text' name='item_amount'/><br/>- B! J5 t3 _: S; Z. V! _3 {
<lable>Item Upgrade Amount</lable><br/>% O/ W) X p- _% n
<input type='text' name='item_upgrade'/><br/>
% h) O$ o9 A: e) p<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
. O k( N& r: U9 \7 \/ _6 Z
4 b ~# t8 l) h# F6 p</lable><br/>
) H/ p/ {+ e8 H) K L<input type='text' name='item_element'/><br/>! n7 |2 x# H; V8 Z9 P
<lable>Element Upgrade Amount</lable><br/>
% S1 _& w! N5 i# g' ^0 C: z9 ^<input type='text' name='element_upgrade'/><br/>; r$ J; ~% `6 j) B
<lable>Pierced Amount</lable><br/>; C# X; e1 _: Q" g
<input type='text' name='item_pierce'/><br/># N _+ ]! k' \5 l0 ?& O
<input type='submit'/># L: x: i" v9 ?! E+ W3 W/ V9 \
</form>";
- J4 k! P, }6 G/ b" g L}; i5 ~! @/ l2 \; p) a
8 `; v* S) X b. ?0 Ifunction PostListener (){' P ~% k4 t1 P% X& D
//Add more post variables if needed and add them to initform() function aswell+ ? I6 V: L* j! ?4 O9 N
6 G5 Q+ ?6 q+ P################################
; @0 `/ P2 t/ ]5 ~4 i$ J/ \: e$ W##### Connection and Post ######6 _. j) B. B8 x0 C' ^* V4 O
################################2 b! E ^' X, m9 n* c
$name = @$_POST['char'];
8 t7 `7 r4 t9 h4 {% h$ItemName = @$_POST['item_name'];/ X, v( N, p4 g% j
$ItemAmount = @$_POST['item_amount'];, W9 K+ X: ]9 K! l3 Z( F
$ItemId = @$_POST['item_id'];
: B& d; z/ t7 ?6 R$ItemUpgrade = @$_POST['item_upgrade'];0 D. V% L3 n2 M* q% R# @
$ItemElement = @$_POST['item_element'];$ D* b8 J8 }- [6 @7 T
$ElementUpgrade = @$_POST['element_upgrade'];3 W2 P F* b5 i4 ?0 j i( F9 j
$ItemPierce = @$_POST['item_pierce'];
1 I9 Y% h9 S" C3 b+ N0 |- K8 b################################
4 Y: }( }/ J7 R9 j: x/ d1 D8 j) O ?; ~" g+ n1 ]7 j$ P
//Check both variables for empty value1 H. @) m3 W) n7 b' }% P- Y
- c- ^' N8 P' P9 x% T% f- I+ Qif (!empty($_POST['char'])){8 u8 z8 Z0 J$ E7 f6 F! Z
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
$ w( g, |2 @8 O0 q
2 r; B* K! e" w1 ~- D. J, Gm_szName = '{$name}'");0 d+ W6 B6 [/ B, F
while ($row = mssql_fetch_object($find)){+ w8 ~0 K9 T8 i" i' g* _# V
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";9 K) L' @% C H& N- ?: f7 q
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], $ f) A9 N( v$ L" W6 X( ^
- j/ y" u! j+ B. T6 p[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ( w) [9 `+ e8 j& T; ~! ?
" Y& \9 x* a, S- j: R3 F! L* q" O[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', : O6 H+ g: y% a4 J1 o
6 n0 x. |% o& [N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', v6 F! t/ [% }; ?$ ]! s
0 D5 v7 b/ H6 r$ P* h0 [8 g. S'{$ElementUpgrade}', '{$ItemPierce}');");
; n; o/ Z2 J% e+ l% | q; w+ F5 U) C}, N5 [3 @( @. @
7 i4 N: V# ~( a* x}
5 ^8 H$ h; V% ^+ V
; e1 H; }1 W0 W( A}
5 ~& i Q& J# |: [% H6 F4 l7 r3 F9 r9 Z4 P0 |0 X# s) N& \5 T, }
$InitForm = InitForm();
, J* z( F; S8 T7 z3 N+ T$Listener = PostListener();
/ ]7 d8 ~$ d; E' b) ?! p w. l4 ^% k- n# V8 w# U" K$ `6 j
?>
0 {* `% q' t/ j. L6 o' _8 E0 a v
5 Z8 u R8 Q* L3 J9 R9 y3 C6 F7 s8 N2 T3 {! X9 r
' M* |9 I7 w/ `& C/ k
|
|