|
|
<?php' P' e2 ^) r$ N0 P
function Connect () {4 M! X3 |+ g3 ^# g, K
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
. n1 V3 G% E( e; w5 Y1 b6 y& E; U- y( F& T; g( C
Failed.');
+ D V S: u2 a9 T5 f1 ?}
, k/ E& z7 I, W8 o" ^/ G& s) P, D, w" [Connect();
0 \+ s a' F6 L, S7 h) t9 Y. R9 b. K! z
function InitForm(){
0 z# s* L N" ^ ]7 x6 k//layout for the form# p$ e$ W }6 e8 m
echo "<strong>Send Items.</strong>" k5 ]$ Q; a/ l# W* g Y
<form name='select' method='post'>7 D/ K& Y2 X' K. y1 T8 }
<lable>Character Name</lable><br/>- q `7 z4 `) k. _8 j
<input type='text' name='char'/><br/>2 \! L+ P# U0 `4 t
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>; ]& f4 N) _/ F6 P1 g
<input type='text' name='item_name'/><br/>1 a' \2 C( A# k- g, f+ C) o2 Y c
<lable>Item Amount</lable><br/>. V, a$ T7 l& a y3 u
<input type='text' name='item_amount'/><br/>
: M& ?% K/ w' `/ Y" u$ {8 d" }1 T<lable>Item Upgrade Amount</lable><br/>7 C1 m+ D4 ^5 f) A' [
<input type='text' name='item_upgrade'/><br/>
5 `+ v9 r1 D+ c! F" A! N<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
) m: Q, l- ?' L n( C; o4 r3 d/ T; t- D5 n$ e- a- S- k) k
</lable><br/>
- P- z7 x+ V h) B' X! H' B. ^<input type='text' name='item_element'/><br/>( ^) g- s9 Z+ B# G
<lable>Element Upgrade Amount</lable><br/>
/ i R! z% { z; h9 o<input type='text' name='element_upgrade'/><br/>/ L; S/ ]2 o. n/ O# O" K
<lable>Pierced Amount</lable><br/>/ W( V! H$ t) s6 Q D' v& N) b
<input type='text' name='item_pierce'/><br/>
5 ~" L7 F6 |& Z1 p<input type='submit'/>8 ~! ~5 f3 s: {& H( H" z6 i6 E6 Z
</form>";
. B$ Z1 O$ [" d, u! Z}
- `% R4 A4 C* D2 g/ T5 C
+ H4 j `/ y0 d6 a2 Bfunction PostListener (){
/ l; i P, M6 I" |//Add more post variables if needed and add them to initform() function aswell
& f Z+ }6 b' X2 a0 q% c9 `9 D" A/ a1 O" ^/ y! h( y9 E0 k8 K
################################8 K& O; X: Q! I I2 v* q# [: H
##### Connection and Post ######
: a. n' d1 H1 K, U# e9 R' G8 ^################################
& [! L, m' }& e6 R6 _$ L& [$name = @$_POST['char'];
: N B5 P( U# J3 D$ C& Z# u; @9 h& i$ItemName = @$_POST['item_name'];
+ w+ ], w$ ^/ g4 _$ItemAmount = @$_POST['item_amount'];
# j& K3 ]" L, t- E, T$ Z. s$ItemId = @$_POST['item_id'];
' y/ ^. h; \) [; a; F$ItemUpgrade = @$_POST['item_upgrade'];& N1 R2 t7 ^( I+ \' N' X2 y8 }
$ItemElement = @$_POST['item_element'];
2 h. U( `, P# w; m/ H8 [4 I* A0 ]$ElementUpgrade = @$_POST['element_upgrade'];/ S- @5 l1 ^' A Z) j
$ItemPierce = @$_POST['item_pierce'];
3 M$ s) b. V B################################
# E: L" P" @# P: F& o4 a! Y- C
+ }+ A1 n' b# x- N+ Y6 O8 E7 h//Check both variables for empty value- @* a# c/ ]& x- E" `! c3 \
0 @6 F. `$ B# K4 T7 }
if (!empty($_POST['char'])){$ }2 S0 I7 s- ^$ W8 Q* U) Q
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
9 z* X; T; N) h3 s) w$ ]8 J: \- H
# _/ j: U2 w H+ h8 v6 gm_szName = '{$name}'");+ Z) x& B3 y$ D1 l& E6 G- v) H6 v, d
while ($row = mssql_fetch_object($find)){
' S4 Q( D% z7 A* W ^4 u8 Mecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";* ?, }# u/ z& e6 A+ N t1 v
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], / w9 I( O' ~- S
4 a: y% _" F/ {+ M" A, M[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
7 F. h, L W7 I- ?6 L$ ~7 J; c5 q- d6 l- U2 G1 k, O
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ @$ M7 K) q4 P$ j4 U0 I" A, d& h# \
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ! u* l* P: L. m, s! j
9 f# e# G( j: x2 A9 V% Y& A/ R8 P
'{$ElementUpgrade}', '{$ItemPierce}');");5 `- }% a3 Z2 }7 `2 }
}
?7 r: p6 @5 g/ E
# u3 Q1 K" q% V4 v. M# M+ N}5 U: M' w* q( Y; ^4 {( T8 s
" f3 E! p6 I# ~) g8 u
} N5 t' S8 v) |0 F
* e0 p! Z6 R& o$ y+ y9 V
$InitForm = InitForm();
- E; R( [% @% p8 d4 E) H$Listener = PostListener();
& ~# f# O& |$ Y/ G! r# o) \: ]8 \
?>$ x' m7 g9 _+ v
: ]0 _0 `; ~( N0 Z) S- l7 a
; O. E# i, u/ l/ [0 ~! a/ e6 ~) K. O9 q
! Y- G8 \8 [9 g6 z$ [9 C7 j
: {. T0 `6 e6 `# t' ` |
|