|
|
<?php
( V0 b5 o; w$ o$ V efunction Connect () {
2 c( L4 j5 Q6 B3 y: Smssql_connect('Server','UserName','Password') or die('Error: Connection to DB 0 B3 Y( U' O' K4 e
, J, M6 A9 U# [- GFailed.');9 s! j# }8 N% T* I& y
}5 {- q7 c! W! ^4 W- U8 E' b
Connect();% ~ u* K% a2 N& x! |4 W
% W7 E; v. m& K6 Q% j. m
function InitForm(){
+ L( Y/ Z5 H9 O7 u J( v//layout for the form
, z+ a: F5 O; z* F* a4 p uecho "<strong>Send Items.</strong>3 p0 F0 L3 g' v* H
<form name='select' method='post'>5 M! e- T- h P) D# m. ?4 W# s
<lable>Character Name</lable><br/>$ S. i! _( g% Z! h8 L4 W
<input type='text' name='char'/><br/>
6 d9 V! k9 w2 M1 a" f' I# |<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
) ~% }- d p& {$ e+ N W- C$ N<input type='text' name='item_name'/><br/>
' A) F7 `& R* |4 q% J3 S3 }<lable>Item Amount</lable><br/>
" j1 w l' T3 ^% H3 a<input type='text' name='item_amount'/><br/>
( C) J" o; p; z7 g1 C- f<lable>Item Upgrade Amount</lable><br/>2 {% w( P k, H. I, w( |/ m5 `5 B
<input type='text' name='item_upgrade'/><br/>7 u/ H' q1 Y& H6 o
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
1 h+ M& E, j+ x: M+ a; R
+ [& R4 t8 H$ E* x6 _- O/ D</lable><br/>
# \/ m7 A% ^" J M2 u9 D ] q0 ?<input type='text' name='item_element'/><br/>* H% t; R" J3 P! j
<lable>Element Upgrade Amount</lable><br/>5 H: w9 n' C! x! v9 z. h
<input type='text' name='element_upgrade'/><br/>
7 r' P% V9 [; Q* A( y<lable>Pierced Amount</lable><br/> w$ p. ?. R0 [4 }: v( u4 {& m
<input type='text' name='item_pierce'/><br/>; x3 q6 a. b3 N: E! q4 O- \
<input type='submit'/>
, L; {9 Q) o; d5 j, x, Y' a</form>";
( U4 ^, `/ F) c: D2 v7 w$ `& a; W}" m- c) p' ~/ F: `5 t
+ Q3 O' T% x: }# r5 y9 R6 s
function PostListener (){
$ P% y( {3 i" d9 D% ~//Add more post variables if needed and add them to initform() function aswell
7 @8 k+ P, \$ L1 r9 Q' k$ W% o
################################
; a1 l: |- ?, [# v: p##### Connection and Post ######
! I8 [' z4 k6 k; d! e################################
( O) i6 Y$ `3 ^! E$name = @$_POST['char'];% S0 k+ a( B# k- E6 h
$ItemName = @$_POST['item_name'];" W% }' L3 O" w0 v/ W
$ItemAmount = @$_POST['item_amount'];
/ b( p9 m4 ~; D0 \0 @$ e- q$ItemId = @$_POST['item_id'];6 w& d$ ^) D$ ~' ?6 J6 q
$ItemUpgrade = @$_POST['item_upgrade'];
2 O7 f% E% G" u9 V$ItemElement = @$_POST['item_element'];
+ A9 v0 {* j6 ^) L) t$ElementUpgrade = @$_POST['element_upgrade'];
& a& _2 |. \0 |6 V8 u0 W$ItemPierce = @$_POST['item_pierce']; s8 Z: T1 D$ W; C) e" V% C% [
################################ B ~( W2 P8 o' E( ?
5 ~( }1 \# ]2 R4 `; Q, t3 X
//Check both variables for empty value
- F e4 J5 J) p) N& e" U5 u- h
; x8 d' j: h8 j/ a! C+ M3 c# `' {if (!empty($_POST['char'])){! U* B1 M2 o) Z
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 ?7 @$ T N; _
' v- f: b! {, l3 ^1 W @m_szName = '{$name}'");
$ f5 {& ~; Q3 O4 Swhile ($row = mssql_fetch_object($find)){- `; A. g# Y% P6 Y# V, b) q0 ~
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
3 O" _& z4 W* _; H7 y& W# h d$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 3 b# @/ a o( j: N
4 O) l, _; I0 X8 i3 u
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ; c6 K- @' ~" r6 J
. o. W L4 `2 [: d
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
- j% i4 F, u" c6 }2 L
: A, {! ?4 H! l$ C; lN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
* A+ e' G5 l) N+ b) k! l3 \+ V1 q$ ]; r# a4 j; H
'{$ElementUpgrade}', '{$ItemPierce}');");
7 ^/ g: H) b# N/ _% |}
7 K/ c V# y: S. @9 c0 N
9 m: q/ W" C1 J5 l& z! r}( c; x8 d7 r* p0 O) l! |( \! p
, t6 _' n' {2 D5 L+ E m) P
}
# }& u: Y" p6 f* Q, J# S. q1 R% w' d3 l* W- \
$InitForm = InitForm();# h2 i' S6 T, c4 g9 ?+ }
$Listener = PostListener();! H$ ?- e3 O& V& A: Y
0 K D6 \9 C$ ^+ b. R?>8 K" n# A& U: ?8 q; e( o+ @9 ~
. O0 x# m' O) q
: U5 }; G, H Q% h6 Z& l6 E
0 Q$ j" B3 O6 T. q- Z( O' G Z3 _6 N
|
|