|
|
<?php
1 r. s; F z- i! o8 q" y7 Efunction Connect () {
5 i% j/ K& f: j; O2 A. Mmssql_connect('Server','UserName','Password') or die('Error: Connection to DB ! `: ^1 }1 @9 }/ h8 o
; h q/ z$ Z3 p+ E7 E _6 tFailed.');( e+ w- S& X: [' `3 k
}, V0 C+ k& \( A9 H- \: m
Connect();
4 j. @: E& ?% w( d/ J/ x" B" Y$ K, `; R% t
function InitForm(){
$ w; p S& c2 z( P; _0 w3 L0 z* I6 k//layout for the form8 n, Q, h8 @/ ~% M( X
echo "<strong>Send Items.</strong>
/ \; `6 X/ \/ x! p- E) m; c2 p<form name='select' method='post'>3 o/ T8 t1 R( h
<lable>Character Name</lable><br/>
; s$ d4 Q: p% V; u, Y<input type='text' name='char'/><br/>4 e& t* H/ w! u. U, m
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
$ A/ o9 [0 q/ s" f% o+ s3 S3 ^<input type='text' name='item_name'/><br/>
/ W& P# V9 V5 Y1 P3 Q) c6 _8 @<lable>Item Amount</lable><br/>
- ^1 B* _+ N1 ?<input type='text' name='item_amount'/><br/>7 {- g( y. [5 {, e! K1 N1 D
<lable>Item Upgrade Amount</lable><br/>; Z8 h* Y3 Q% C! f; r- W6 A+ J
<input type='text' name='item_upgrade'/><br/>
/ B. h5 e) |$ w) f7 x0 b<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
1 G8 s1 F3 ?! l/ Q2 p9 \
& \1 M( \( K6 W$ i( U</lable><br/>
+ l: G5 p* t" @3 O<input type='text' name='item_element'/><br/>8 [- @! q% ]2 h+ I5 G
<lable>Element Upgrade Amount</lable><br/> J7 X8 r' U8 A. x0 ]/ ^ l
<input type='text' name='element_upgrade'/><br/>0 g1 }8 d, v: J/ j# G8 d
<lable>Pierced Amount</lable><br/>. l# x% J# ^; D% R
<input type='text' name='item_pierce'/><br/>
# V# Q2 V B1 L o* l7 d o<input type='submit'/>
! Y$ d" n8 u% S, L3 ~" X1 P</form>";
) ]5 [6 m* a9 C1 S* Z}
- [ u+ j8 b2 v( j* N/ c* l. f Y: O7 A
function PostListener (){
/ z, [4 f' @. I5 I# j//Add more post variables if needed and add them to initform() function aswell
9 H) R$ e* J) ~, P1 F5 A. \1 p4 K$ [" @" O
################################% z# u9 _- m O- l
##### Connection and Post ######, o; k+ }! Z! ~4 ~
################################* v5 ^7 c1 I6 U/ K" r0 c- w
$name = @$_POST['char'];3 S( |1 b3 [! D# Y- H6 o% f
$ItemName = @$_POST['item_name'];! F, _" t5 |3 s+ Y
$ItemAmount = @$_POST['item_amount'];
' }! s G# S# Q$ItemId = @$_POST['item_id'];) \7 K4 F# t9 k3 o- u
$ItemUpgrade = @$_POST['item_upgrade'];6 ?7 i4 e& B. h
$ItemElement = @$_POST['item_element'];
4 l* n' V# P5 @$ElementUpgrade = @$_POST['element_upgrade'];% Q8 w0 u' v# ~8 G( j# c- P
$ItemPierce = @$_POST['item_pierce'];/ A( T2 p) g/ F5 u6 p/ p& F
################################. j4 x, W" i. R- o O& Z
8 S; G# N8 B$ }7 n5 L
//Check both variables for empty value
4 I9 l- v' g5 T- [7 @+ [" Z1 i8 d2 q
if (!empty($_POST['char'])){
5 T. ~ J9 B5 S, o& D3 f$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
9 p5 s+ d3 l9 @3 h0 S1 A# R( N
, l7 t9 J4 i5 l5 Wm_szName = '{$name}'");
1 d; V# L$ W! d) M5 ]6 Vwhile ($row = mssql_fetch_object($find)){+ F% V/ m' u/ i _
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";* o0 ?) X- Q" T7 o" [$ Y0 p
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ( r% l% [2 J2 d
) l) ]/ \4 S- K1 ?. I[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
0 K! Y* b; j* \; m( V! U& J, y
$ d7 C! P3 |) u+ }' `: c[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
+ S) V* l" _$ U! m% D
0 ]; W1 |2 ]+ [# q; g ^- aN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 9 `% _ G# v+ [0 z( o& c
) ~; c1 n4 ~. M5 ]6 m'{$ElementUpgrade}', '{$ItemPierce}');");
- k; T2 V; }/ D4 H* u( }( _}
5 w4 S1 o% y% g n! Y/ I: }% |) O! P& n; o
}$ M! H2 M' E0 b0 X" }
- g2 Y7 z2 x ^: @& r# _; O}( F: l$ P, |, Q1 B+ d
: t# z; v N7 t3 v4 Z' {8 G6 @& c$InitForm = InitForm();9 P4 n5 p, ~5 `
$Listener = PostListener();
; K9 {9 L5 j4 X3 T; c
8 r8 p: H7 [0 @?>5 I$ I- i/ B7 K( V
' T. h/ z1 n& Q2 g, l/ b; l. ~
: f5 S# |) |3 ?2 v' H5 Z: V) ]9 F
# ^/ I# b9 ? a9 R- M
+ J1 n" K% E* Q1 d6 D
|
|