|
|
<?php
5 c. g: L, m2 \6 v2 Z, w h, qfunction Connect () {
; D" s: _) W8 u# {mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
2 h4 {. B2 F$ \; N0 q- t& h" V7 t! q; m. v Q( |8 S. I3 ^" J- p
Failed.');* D! ^3 r1 {) \3 D- l3 E8 I6 Y p% w
}- X9 T; M$ K9 |0 t3 X; z, Q
Connect();
( l- ]' m; X8 }' N" `
) z; u0 g/ U; M5 C0 mfunction InitForm(){! N$ ^1 q/ _: u2 O- t* u9 r3 _
//layout for the form
3 @1 \" M3 M# @0 n3 w: q! U3 Pecho "<strong>Send Items.</strong>
6 ~# W4 `7 g) I: e1 H o$ C5 X<form name='select' method='post'>$ _/ e$ ^& o3 q3 C. u% Y) q
<lable>Character Name</lable><br/>( q, ]1 q/ V ?" h# {
<input type='text' name='char'/><br/>
+ h& [3 V- {, [( l6 W4 \7 ]# E4 H<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>5 r' ]; @2 T, |; c$ w/ \+ i
<input type='text' name='item_name'/><br/>
. M0 N' s; Q' S<lable>Item Amount</lable><br/>1 P. @- \% }) m% ]9 x2 q
<input type='text' name='item_amount'/><br/>
) K. `4 T- \6 \. a2 \# u" j. w<lable>Item Upgrade Amount</lable><br/>
. e" B" `' h) G9 x7 h3 n<input type='text' name='item_upgrade'/><br/>0 g4 Q% ]! g) f1 w1 E( k# ]( m: A
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
& f0 g0 B- y( h' F% }+ ?- b1 y
% ^+ }2 N4 O a6 v</lable><br/>
' f: X( h0 ?7 w<input type='text' name='item_element'/><br/>
& D O9 C( G! \6 m2 k/ Q<lable>Element Upgrade Amount</lable><br/>
, B1 V/ x6 K% Z<input type='text' name='element_upgrade'/><br/>
8 |8 M5 b) g2 v- v, [( f# ?6 G( s<lable>Pierced Amount</lable><br/>
6 P( Q' K8 a6 l- o0 i' e% h* f<input type='text' name='item_pierce'/><br/>8 {) D5 m% H% q( {* x+ B+ T
<input type='submit'/>
$ Q% k: s& d/ t4 ?$ N- `) p1 u</form>";
# y/ d! ?5 r# {' \) q" d3 {}
1 p, \: T/ P% U) N [" O7 U( H7 _- v( L8 d
7 i5 K$ z+ L7 q7 O) Zfunction PostListener (){% R7 E3 R. M; i5 r0 T+ F
//Add more post variables if needed and add them to initform() function aswell0 r5 m$ X9 z# }) C; }6 P6 d4 y
* m0 K( W/ a2 \- h. x) o
################################
1 J8 B+ \5 ~" e' z; E##### Connection and Post ######
Y. j5 T) c6 B( l, h' A& j. [################################
7 P! E, F4 C0 a+ C4 m$name = @$_POST['char'];" ]3 S$ Y( t: i! [ O. X& v
$ItemName = @$_POST['item_name'];
! c( q2 b3 ~/ l5 ?" Y1 ]$ItemAmount = @$_POST['item_amount'];
, B ?! ?5 t/ T$ItemId = @$_POST['item_id'];
5 v3 n s6 y; x2 U$ItemUpgrade = @$_POST['item_upgrade'];9 i! H" S% E! L9 I$ U) z
$ItemElement = @$_POST['item_element'];
5 ]7 S) L9 \. c i$ElementUpgrade = @$_POST['element_upgrade'];
V* X& x5 U* V$ItemPierce = @$_POST['item_pierce'];
* _2 n/ o1 g) g7 L9 t################################( I+ G) _& [( u0 n
6 i% p4 X' r% O- z- j% k+ N8 d//Check both variables for empty value
: V4 K3 ~: k- z5 a9 o5 Y( C6 i: z; }: x# {# K/ P+ V
if (!empty($_POST['char'])){
# O) v- c, y9 X5 x8 } e( d$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 5 ], S/ X8 Z9 p6 Z# a2 l- ~ Z, I# k
3 r" r# z& G& @. v' k9 q+ x) Jm_szName = '{$name}'");( s7 W, }* c1 s3 z" J
while ($row = mssql_fetch_object($find)){- }& n; m o4 k$ ?% r8 @- D
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";! v" x% O0 c" d% v4 q6 q: W9 k
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 0 ]" b [1 F. V; p" }# K
2 H- ^. t/ H o; o0 f0 X
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], * ?! |6 \8 X* m+ I5 P
% _ ^8 U+ b* W[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
! O- R- ^9 {. m3 e2 n$ r
! e( K( G( Q1 ~ y. `N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 1 _- G- P. `1 |/ k8 d( ]
) g& Z4 P5 }1 H
'{$ElementUpgrade}', '{$ItemPierce}');");0 E/ Z3 l8 x, _: Z( U& G, H* D
}" N! n1 q3 W+ y! I
* G5 l- b0 z) h: x
}
/ u4 n' [+ |$ q- l. w# W9 K+ E+ z% }: B
}% g; b9 r) f& A1 _; H; c
1 ]% f, M9 J3 [* b$InitForm = InitForm();
% L- ~8 E1 z7 B$ \; L: f8 H$Listener = PostListener();
! Q/ n& v. V& m8 ?: t! e, Y2 k. V# j9 j
?>
3 a1 P4 T. f. n& K, ?) d& W4 X }4 r$ g
' k, k' ]- r2 O/ l, ]. D& y
) X! W; H) r6 g) x2 c! J8 U$ b& o
5 C& G. S7 {6 C, {& t& c- C& O |
|