|
|
<?php
$ h6 i3 b5 }2 @! vfunction Connect () {
$ o8 z; i# F! J9 z& F$ S* `mssql_connect('Server','UserName','Password') or die('Error: Connection to DB ( x9 m8 y8 c' t7 `2 q# u. s
. i8 m) S$ T$ G6 G5 V6 u" Y; z
Failed.');. W4 ?+ i+ V4 N- H: U
}; k$ ^* v% j/ t) r8 O0 x
Connect();
' v# B8 r" ?" l$ z) V. q( h* [9 |+ z7 ]& N" D& u* ^, c, y
function InitForm(){
2 e. ?1 {* G' r2 a0 T% \//layout for the form
5 x8 n9 J( H' ]! K1 necho "<strong>Send Items.</strong>4 O8 q0 ?# p- y' M* v
<form name='select' method='post'>
, T, `# r3 W$ u* Q' ?9 V ?<lable>Character Name</lable><br/>
3 T- Z3 k# i7 h; r<input type='text' name='char'/><br/>
6 Z* _9 B& F9 t1 o) s. M U( O<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>9 x2 n9 |9 I8 Y2 }3 i
<input type='text' name='item_name'/><br/>
# u/ ~& j% Z5 n6 j, I+ x# A<lable>Item Amount</lable><br/>
6 R6 B u7 V9 g# K0 O7 P0 N4 p<input type='text' name='item_amount'/><br/>
2 `+ D0 Z$ Z0 Y% D) ~. N( Y<lable>Item Upgrade Amount</lable><br/>2 |2 u+ F+ r8 r5 B6 x
<input type='text' name='item_upgrade'/><br/>7 K7 |7 m: G4 _/ _8 D7 D2 y
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
0 `+ T. Q3 ~0 M/ ]+ o: ~2 l+ p a6 v9 A3 N' v* }( l( L! J* V
</lable><br/>7 O: v9 G3 b/ j" \ D u) w
<input type='text' name='item_element'/><br/> ]. C' F: z# W- D
<lable>Element Upgrade Amount</lable><br/>
) D1 E& x. E0 O" W1 e<input type='text' name='element_upgrade'/><br/>. s- j* V, l1 A/ ]7 }- u: G- N
<lable>Pierced Amount</lable><br/>
5 B m+ r0 ~6 N<input type='text' name='item_pierce'/><br/>
& x( g4 i5 F! |0 |<input type='submit'/>
: w- D1 ~3 Y Z+ u" Q& m</form>";: r& u6 B* {! i4 o3 E. Q; ^
}
9 J, f' x6 |4 P* t
7 j8 }/ L8 g* p; v- cfunction PostListener (){3 ^* L/ m$ Q' Z; _8 {6 C
//Add more post variables if needed and add them to initform() function aswell
+ D: k" g- v1 e: b8 K* u3 D
3 Y$ h$ Q$ T/ p2 M" T3 i################################ j' B# G0 F l
##### Connection and Post ####### J- u+ l! h0 |7 m3 \6 o1 R; Z" j7 d
################################
7 _+ M+ Y4 B& d, F$name = @$_POST['char'];$ x$ i5 T# L1 J
$ItemName = @$_POST['item_name'];
9 E- D0 I3 A- k0 j$ItemAmount = @$_POST['item_amount'];
. ?: e* n3 o- ?4 f7 k0 g$ItemId = @$_POST['item_id'];( K( ]. U: o# u0 A* k; `
$ItemUpgrade = @$_POST['item_upgrade'];
: E0 R4 P- u8 Q( V( M" v$ItemElement = @$_POST['item_element'];
% y' f! l3 C( m, U; }; `" D8 W$ElementUpgrade = @$_POST['element_upgrade'];% U; s4 x" i9 f1 c1 n0 E$ J/ F
$ItemPierce = @$_POST['item_pierce'];
0 \( o3 @, Y& E5 T################################
# R% S5 R; U* N2 o, a5 ?0 E; |4 I, \5 G! N( W; n/ @- l5 t
//Check both variables for empty value6 X' r( D* T9 D, [ X
% y) P) N8 P9 pif (!empty($_POST['char'])){* n; o8 ^& E* ~' d [) W6 \8 U; D) P
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where $ @; q9 |; \0 \ u
, _+ b5 k- z4 D1 W, m/ y# V# pm_szName = '{$name}'");
/ I% J4 c4 D" R2 {while ($row = mssql_fetch_object($find)){
" u6 O% s* W0 Z0 }# k+ c) `echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";% D2 j) `+ L+ E, Y
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], & x7 C( S# N. c
; N( U6 f4 i' ^# ` T
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ) t9 k7 H( l' g$ W6 k
) h1 l1 {) x0 U6 j( z. p% U# I[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% Q8 P, Z2 b0 n* B' w* O7 Y0 Y5 w9 z( G$ H1 W: W
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 7 p5 s+ v$ f- [# j9 g4 t+ T+ S
( [. t+ Y3 w9 E" g5 k/ C9 ^
'{$ElementUpgrade}', '{$ItemPierce}');");- B! N4 I" c" I% u
}1 R$ W1 c$ j; K9 P. w7 R
; L# P- z8 a, e' p# f. @; n9 v
}! m! O' o! n7 z1 i( s! w
% e5 K s0 _* ]" W}
7 ]6 d7 }$ c! z' `. `8 C: z- B2 E: B. `* [7 s
$InitForm = InitForm();
7 y" Y0 w6 H# W% Q6 f5 o$Listener = PostListener();, D$ A: x/ s' b. @& F7 R( Z
! I- C0 e' z0 Y2 F% |4 q* \
?>
7 [ l& B3 ]! H ?) m& Y/ s$ ~
' X; [& ~" f" n$ P' g1 v" J- X6 X, S* a4 h/ x( j3 n6 Z/ E
) {# @2 z; Y# ~
\- p8 B" X0 h5 u |
|