|
|
<?php% K, v1 o2 d/ b$ z
function Connect () {' ^4 _- i$ L+ B3 w
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
0 ?+ |$ |0 e' M( O
6 U" p! R* E2 @& u0 q5 u6 }Failed.');- K6 a" L! m. n( r" p5 o
}1 Y1 m& Q$ z- u4 U! ?
Connect();
+ C( l1 f e- I" l6 ~# S* g! c
. G. r5 w) R7 |3 S9 D) F, vfunction InitForm(){* Q7 |8 q! u5 _7 ?! p
//layout for the form. M, [. O9 |( k( i# C% a0 ?' d& U1 X
echo "<strong>Send Items.</strong>' q& k- A/ S! |& s; R' `: I
<form name='select' method='post'>
* V5 H9 g2 O8 K<lable>Character Name</lable><br/>; Z0 M) Z, N1 E: [0 _# q6 o
<input type='text' name='char'/><br/>& o& }% a+ W- I5 G* ~8 E/ o% `
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
; h! _& m- h% r- @% ~6 C<input type='text' name='item_name'/><br/>
" j! @; R6 t9 s' N6 U<lable>Item Amount</lable><br/>3 p1 w- Q& M5 ]2 m' W
<input type='text' name='item_amount'/><br/>. r! ~- ?3 ?. l9 m7 O: b( N
<lable>Item Upgrade Amount</lable><br/>: X- n0 P( B9 f& w+ ^' W# F
<input type='text' name='item_upgrade'/><br/>2 a* u5 T$ {* {9 m3 y
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
7 k6 D/ w" {* z* `" U) s6 i i$ S* F! n, J) B- V& C
</lable><br/>
8 ^, ~! r& s% a2 `) Y+ N<input type='text' name='item_element'/><br/>
4 L+ R8 c- ?5 N<lable>Element Upgrade Amount</lable><br/>
* v' c; T; P2 |. f<input type='text' name='element_upgrade'/><br/>
+ ?% q$ c# G; H" ]% O<lable>Pierced Amount</lable><br/>: f& P4 {2 h0 m } f
<input type='text' name='item_pierce'/><br/>
7 f. V7 B/ ?# S. V0 |( S<input type='submit'/>
3 |1 _ D$ m, b- F1 K# j</form>";( z& a7 j- {% Y3 o% a
}1 ^4 u* o% T! U+ X
1 F8 H4 k8 V0 a# z( w# g/ Y/ _function PostListener (){
0 i! K* N) @' n4 R: u) ?+ ^//Add more post variables if needed and add them to initform() function aswell; N2 J' L4 m7 t4 _% u# P3 `+ q% D
2 ?. | m4 }& n! k" N. F################################
. h$ [- B4 c, V/ ?7 y6 ~9 M" g##### Connection and Post ######
2 v0 i0 Z: K: H* Y################################+ r r. |6 r7 Y# `& X
$name = @$_POST['char'];
: ~: |6 q" i$ F9 ], _/ n, Z* F' b$ItemName = @$_POST['item_name'];: u% u( M7 a! @7 J$ q% C0 l1 S, `0 j) i, w
$ItemAmount = @$_POST['item_amount'];
4 b- L; E$ F" @% m& e( C& J2 v$ItemId = @$_POST['item_id'];
! w. q+ g) t! G, G T& t$ItemUpgrade = @$_POST['item_upgrade'];- f% s3 E- \* ~5 l" [
$ItemElement = @$_POST['item_element'];" K$ u3 B2 T+ T1 m
$ElementUpgrade = @$_POST['element_upgrade'];: m( n2 X0 p( P. J. z9 c$ P
$ItemPierce = @$_POST['item_pierce'];& \2 C6 i8 \5 R2 D/ b" |" H
################################& A, F* [3 j" ]; K G( h
/ C% o$ H7 ?( c* Z
//Check both variables for empty value
+ P% r7 e' @! Y3 e1 |
5 ^! [/ ~1 R0 Z+ [2 xif (!empty($_POST['char'])){. Y: n3 N2 `& S5 S
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
& X% @3 h8 K, g+ K& l
2 x' D! O1 L' s' n. \m_szName = '{$name}'");
2 i: k9 s+ g. L/ f) N1 Owhile ($row = mssql_fetch_object($find)){& N( h' [5 U0 ^$ \" a3 [& {
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";; l# t. v4 r: M k/ o1 V1 |
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
/ u7 U% W/ ] l/ a) {8 ~) v3 j* O8 Q1 N, N4 y% t- L6 s& }
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ! m) b+ A% `/ C6 a" w3 I4 ?
. I- j1 p5 m, P. [
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 7 n: @) Q g1 C- r. F, N
, [2 W( M9 [* q4 y5 L% gN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', % A: L& s O( `& ?: ]* T
5 c- f! r2 [; h8 T% x: I1 t
'{$ElementUpgrade}', '{$ItemPierce}');");
9 `/ e" p; Z% L3 l" H3 r: w}: x: l8 w* s- B' Y. I
# ^9 [* e6 w+ x$ |$ V: w}
, B- z2 D5 G& `0 s4 q1 l& u
$ ^, l6 a/ r2 q: ?* @- S* s, ]}3 `' P" Y% j' d( H1 k& @
$ |1 i7 J: R- G% D7 z$ [$ }& j$InitForm = InitForm();/ X$ x9 C; m1 c: H1 W5 T
$Listener = PostListener();
2 q1 @& ?: ~: _7 [7 Y4 X1 ^0 W( V" J: {
?>, c* T( } @$ F
7 h Y9 c" o; H; j
) V( d3 ~3 r9 o- }6 q$ o
/ ~ J5 D" ^ p; h* ? T% r" Y; j( @8 k' _2 e
|
|