|
|
<?php
y6 U7 ?; a" H* ~9 {$ A' wfunction Connect () {4 w- J& ^) f( \. }5 R2 n$ a& k! f6 g
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB + l0 R5 `$ [, N4 |& X
$ A. D. j4 M7 `7 C! xFailed.');
9 q3 k* V' e/ _- R( A}
+ p' \ A f3 q3 AConnect();
; v' j( d5 J! R& k" h, \$ O1 X" V8 C8 N4 P: j4 X' ]6 k
function InitForm(){% M& t4 e) P% a! M
//layout for the form2 E1 i6 o9 l- s; h% d
echo "<strong>Send Items.</strong>
' l8 I0 O* w9 |9 q1 k8 G" D8 v8 |<form name='select' method='post'>5 a: q4 r2 T0 \
<lable>Character Name</lable><br/>5 j! t' D; j* `! k' L) c w
<input type='text' name='char'/><br/>: ^, a2 V# k: E! U% a0 m( c3 }
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>' B! ~4 i) b9 |: d- w$ t2 P
<input type='text' name='item_name'/><br/>
# }' Y6 R1 U: I& Y- }; O<lable>Item Amount</lable><br/>4 s) u% q: L6 b1 z: `# E3 x3 r
<input type='text' name='item_amount'/><br/>9 O2 [2 e$ f' K8 N
<lable>Item Upgrade Amount</lable><br/>
* m& I1 ]5 L N<input type='text' name='item_upgrade'/><br/>4 u- D( J9 P) ^
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)1 R1 q) z# w- Z
) a3 ^5 i8 t6 T</lable><br/>
8 e) h! j0 t7 u6 F5 [<input type='text' name='item_element'/><br/>
3 x3 B' J# j# p* F9 @<lable>Element Upgrade Amount</lable><br/>
+ x9 v$ z/ P6 y1 J8 E$ D<input type='text' name='element_upgrade'/><br/> w, l0 {4 a C( C8 M6 h/ R
<lable>Pierced Amount</lable><br/>; K# j& `8 N0 }' x4 Y! p+ ^0 \# C+ g
<input type='text' name='item_pierce'/><br/>9 i8 N) H& v- s9 W3 h& b
<input type='submit'/>; n* F4 ^$ j' S3 L- V1 A8 l! P* Y
</form>";5 M+ [& E& h* K6 ?# d0 I
}
4 X2 A. ~" G* x1 j+ ^
4 u) O! d r. F' u/ Z9 v& S8 Sfunction PostListener (){
" i3 H) d0 i1 }6 b, x//Add more post variables if needed and add them to initform() function aswell
. |3 m; ~- F) G& d2 S1 O
9 n1 C0 o4 O0 p! m, D; H################################
0 y" A9 ~1 k- ]- ]/ D* a- d##### Connection and Post ######
: {5 y/ r4 R; e2 C B _################################5 o2 t3 D1 n% ]3 X$ x* i
$name = @$_POST['char'];
6 w5 ?9 R1 V* F- I: x$ItemName = @$_POST['item_name'];" X' u7 F8 a. f" A& Z4 ]
$ItemAmount = @$_POST['item_amount'];
* K2 {3 m6 O1 ?! k$ItemId = @$_POST['item_id'];
# p2 J: |" X# V- I; g$ItemUpgrade = @$_POST['item_upgrade'];7 S, M; C' |2 ?
$ItemElement = @$_POST['item_element'];
' J: c) ?/ t8 h: E$ElementUpgrade = @$_POST['element_upgrade'];( x* [5 s5 [8 e0 x. z$ O
$ItemPierce = @$_POST['item_pierce'];+ R; B% x8 \9 T; r' H
################################, U; T, Q- K4 p. q3 ^" O3 g
6 t9 \; Q3 _/ S. Y7 U6 O7 Z//Check both variables for empty value& @0 ~* q m K d5 w r" k
. q& t) c2 f9 z- V1 F: }) v7 mif (!empty($_POST['char'])){( K4 f/ s6 S! u% O+ y9 }2 Y
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
' d- Y1 g* b# S3 p5 y: ]
/ |9 `6 U. G0 F2 L9 m! {m_szName = '{$name}'");. F( W8 q5 |$ c- r N* o
while ($row = mssql_fetch_object($find)){
/ p9 h% Z$ v- d* F# Decho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";' ^. n* e6 s" L% G/ s3 K! n
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ( o. f, T1 d; B, a. i$ v/ m
$ y+ k" }/ i% \( K' X! C7 Q% L
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 0 I2 q# P8 F/ x' Z; u1 B. R
; [2 r/ Q7 \6 [! |8 C
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
, |6 ^. u! ?/ ~
4 D2 r' S8 Y8 q4 h: E" NN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', % H" |, H* e7 m
9 ?( G$ h' ?) L8 a" r' B4 y& @'{$ElementUpgrade}', '{$ItemPierce}');");
8 w. G3 Q! k( m6 x}
( l# A) Z4 b# x: g) r3 X" m5 r8 l E2 j- O8 q& X8 c& ~3 z. o1 m: H
}
* J( Y# w! w2 J3 F* a/ I6 c8 z6 |0 F2 t$ B# p
}
+ q; n( T. ~* [- C
. _6 B9 E- x% Q, z$InitForm = InitForm();
* C" A& x1 E- q1 X" I$Listener = PostListener();3 r, h# `* i0 [3 P
; _" n6 _! ^' N- D- h
?>& L' p% o2 O/ l9 r+ d
2 ^' E5 P( w6 Y8 ^) [. N9 G8 h6 ^& {3 R) N& F
, q/ ^# ?3 V; B& {5 _! k! g
; s0 g2 c( ?2 E6 g6 {" n7 Q
|
|