|
|
<?php
/ d5 Q' Y! h: E$ Z( E! M$ N' R' Ofunction Connect () {: y+ c. s% k9 D
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 3 k+ a* K, d& @7 r# M; A2 \
7 [: }; d5 }" L5 x! D+ x# h2 ]Failed.');1 h8 V9 i$ B% z! c7 s
}
: ^! I4 v' o/ VConnect();
2 \% o5 Z( k) I4 v) O' j0 N) B; `
function InitForm(){, z9 D& Z8 g" E7 a2 O
//layout for the form5 i; Y* V. X( n( Z' V& f4 a$ E( u
echo "<strong>Send Items.</strong>
( Y- C- w b4 d. r. Q<form name='select' method='post'>
; l5 x$ d9 \! D3 G6 v# X v<lable>Character Name</lable><br/>
2 u' `$ f; i) F# Q1 B1 P<input type='text' name='char'/><br/>
) x0 Y/ U. }# O4 z0 j* @3 Q! G$ y<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
$ e5 }; \) { B4 Q<input type='text' name='item_name'/><br/>/ i; K& M# ~$ C% M! k
<lable>Item Amount</lable><br/>
5 v4 h' l3 [" J( Y9 ?. O; e7 A! ~<input type='text' name='item_amount'/><br/>
% m& G/ b+ d1 i<lable>Item Upgrade Amount</lable><br/>
( s- h4 P" |0 L+ [( I& X. K; j0 M* j<input type='text' name='item_upgrade'/><br/>
. O1 F" ?0 I0 g+ b4 Y<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
5 R. }; ]; ^0 G: @' w! v1 R* `% x' d
</lable><br/>
3 |5 T& @( s! E<input type='text' name='item_element'/><br/>
$ V2 r# C4 b" w<lable>Element Upgrade Amount</lable><br/>' s1 v4 s4 N1 i# T: p) ]
<input type='text' name='element_upgrade'/><br/>, J0 q4 K H* }: K- U
<lable>Pierced Amount</lable><br/>
0 j# q4 o4 H2 j- {8 v( l- T, v<input type='text' name='item_pierce'/><br/>, @6 F( O. H0 O0 m
<input type='submit'/>
2 r- I* R. @. s6 Z- [; ]</form>";8 }8 v5 h! \3 A1 [8 Z2 [
}
) e( N7 @6 W$ C5 v* _. Y* }7 c: L' K
function PostListener (){
* ]1 f$ F% V) g- {8 P7 u, N+ b//Add more post variables if needed and add them to initform() function aswell
/ C+ U9 W5 W: Q) X2 E
" A: \( N3 T* y/ W################################
, C; Z6 p: b; h# |- H D, g7 V##### Connection and Post ######
8 ~4 W1 o) Y; n; o* @5 h################################+ |" i. J: D$ R8 O1 k( m
$name = @$_POST['char'];
. z2 a$ v7 w' n3 ]2 V1 P9 f$ItemName = @$_POST['item_name'];
! ^, D+ o3 a" T! y4 i8 P$ItemAmount = @$_POST['item_amount'];( g2 \* V1 F: ~7 F' V J6 Y
$ItemId = @$_POST['item_id'];
4 I6 Z0 b) H% O, {$ f5 T- @$ItemUpgrade = @$_POST['item_upgrade'];, j( T, y* J: @
$ItemElement = @$_POST['item_element'];! c; k- b; Q+ d$ j8 q' _9 {' z
$ElementUpgrade = @$_POST['element_upgrade'];. l$ x4 L2 K/ g5 i! l9 v6 Q3 X( ^
$ItemPierce = @$_POST['item_pierce'];
- \* F5 x& x- k% x$ E' C2 L################################4 q0 h T5 E# H9 y
. Y9 O; M* g/ C- q" \
//Check both variables for empty value' Z# U# J5 `4 g8 U. w# i
! K0 ?! S% o% g% m+ |2 z7 r: cif (!empty($_POST['char'])){
; }) z2 y. b0 _1 O/ k/ J$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
; @- `* h: n+ X" x6 F" I# t
8 \# n4 D# d- F$ q! D- Sm_szName = '{$name}'");: C: p* y: f- D) s
while ($row = mssql_fetch_object($find)){) G* Q4 }+ H; Q9 x+ x" y
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
! |+ v$ I! `7 o* t7 I0 y4 ]$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 0 \9 | |0 {( Z" F- ~
7 L6 a C5 d# Z p9 u) i[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
5 N* g6 H$ M4 F! h# L/ F% {; G
4 ?- c# j7 ~; w+ b9 j[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
1 D. `6 S' l+ {, n
" @9 W9 v8 w( z# U& r$ B9 }N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 6 \* y7 B5 d! b2 ?! X0 F$ b
% }5 V+ }5 N+ _! n# ]'{$ElementUpgrade}', '{$ItemPierce}');");1 E3 L& k/ k8 b% S$ l
}
6 k" j$ i0 G; F+ t v
# a2 K) ?- ^ {}. X. f* z$ M+ }4 I1 o2 Z! ]
( G |+ E; v! N s}0 w* D5 r _/ O3 ~" b) ~
: G4 c7 K. n3 D! q/ z; m$ p/ @$InitForm = InitForm();
4 Y6 ?# v+ O& D' @3 b! A4 E$Listener = PostListener();
& w2 |) C6 n: f3 K/ i
" M R, m% p3 S?>
' O9 s' [+ a& N! {, h4 R% M! E# _, g# X+ _' m& H7 V h
( `. z; D% w8 J2 R: M6 l) p2 O9 ]) M" z4 M; m
% s/ z; m8 d; y) i7 C |
|