|
|
<?php
E; M X& L3 z2 _6 b2 nfunction Connect () {
) R8 v( C/ X, a( M6 W( k# T* |mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
4 r7 s1 e" w0 s2 I% O& B3 k K, t& R3 q* s& |1 t" m; x% t
Failed.');0 h! c5 m8 f7 ]5 Z* h
}
3 M/ z J7 m2 c' Z8 c2 z9 nConnect();6 |1 M; {! W. s, f1 n
9 q5 V- l1 g& V4 G6 k( sfunction InitForm(){, G: d) g! e2 B: T# ], X7 _2 u, d% V- K
//layout for the form- ]; M: T2 ~. a* S0 I+ C
echo "<strong>Send Items.</strong>
6 ~3 T( {, [* L# r9 v<form name='select' method='post'>
5 S4 {5 y5 P" n) s |<lable>Character Name</lable><br/>
% ^- v/ g6 c1 G" w; f<input type='text' name='char'/><br/>
" _6 d) c4 E; M- b) i<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>( j! h3 T+ M8 t8 I6 o" X& a$ y' s
<input type='text' name='item_name'/><br/>( i0 O$ ? @% B$ a2 e! ~$ r
<lable>Item Amount</lable><br/>
/ y6 N# I/ C' v; o$ Q" v- ]6 S<input type='text' name='item_amount'/><br/>
3 \7 R6 f; j) ^7 E% f<lable>Item Upgrade Amount</lable><br/>) Z5 r1 a$ W$ o) `4 i& U0 C* y
<input type='text' name='item_upgrade'/><br/>4 N% ^1 Z9 Y" a9 o" _8 O0 a: J
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
6 Z/ h, M1 z* B: P4 I% n; y1 r" i# `9 G( c4 \ M& R6 q
</lable><br/>
9 L0 D; N) U3 h- n1 `; H<input type='text' name='item_element'/><br/>
$ e- h9 M" P" {# ?$ i) d, D* j8 J<lable>Element Upgrade Amount</lable><br/>
1 p* b B5 O8 N0 z0 g<input type='text' name='element_upgrade'/><br/>
1 }$ a- i, ~/ T0 @: A<lable>Pierced Amount</lable><br/>9 [& W% }, A7 H6 J9 e. [6 b1 @. A
<input type='text' name='item_pierce'/><br/>9 K6 m. V! I# S1 i
<input type='submit'/>
8 h7 ]: U, i0 v: Q</form>";
9 s! A: C/ j; D' o( ?& L}
3 a$ V* w6 X- X4 D& R0 T1 v, h* I: {% c4 }$ L8 X, r! F2 U
function PostListener (){
% S" F( G* g( _! ~: u8 _//Add more post variables if needed and add them to initform() function aswell
( E5 V1 Z% J- ]0 Y; @5 E3 P% S# @& y/ I5 J; {3 l) r
################################
. R. l) u/ Z U% @& ?7 m##### Connection and Post ######
9 l( m D a- ^2 V! R" S- u################################7 ?1 N. _( A# n9 k
$name = @$_POST['char'];
' V0 M' H# ^( w7 }$ItemName = @$_POST['item_name'];8 r& ?2 |) a! c$ P4 q9 W# a9 m" `5 Y
$ItemAmount = @$_POST['item_amount'];
% c2 w( v% s# y' S3 X0 \2 R$ItemId = @$_POST['item_id'];
3 B8 ~0 q; _4 C" C6 U/ C$ItemUpgrade = @$_POST['item_upgrade'];0 Y: P0 l2 q' B- e6 }. r% c
$ItemElement = @$_POST['item_element'];
& H" ]6 Z# Z- z0 m: Q8 h5 w/ ~; A$ElementUpgrade = @$_POST['element_upgrade'];
: x2 J1 M1 D& ?( T0 p. W1 S$ItemPierce = @$_POST['item_pierce'];. e8 ~9 E. a. m& V/ L+ ^
################################, g' h$ q4 X& a
# `9 p& A$ e7 E0 D5 B3 Q//Check both variables for empty value' {7 s1 T7 A% w6 r* K* ~
2 x7 a, M# T; b
if (!empty($_POST['char'])){
1 z4 }3 C1 J9 ~2 [7 \" v+ m$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 3 S3 `+ N! g% P' s8 D* c6 @
3 Q v5 D J* q# o; F2 \m_szName = '{$name}'");0 Q$ i" C X' G4 a
while ($row = mssql_fetch_object($find)){$ b# a" P1 q# w. W- r3 O- l/ {9 [
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
9 X, K- S5 x1 h% X( V& A$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], : e2 c0 c' z" O3 U7 S
[/ m" N4 C. S[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
# j' j4 p: ^( W+ Q" L. R" g* j! v, r" y9 R2 J
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 5 m$ o4 C/ m4 R0 S
* ^; f* p5 I" |7 F; gN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
. g- p+ `& b$ p+ Y2 n
5 f, G7 }* @6 \9 y0 ?'{$ElementUpgrade}', '{$ItemPierce}');");
" w- m, r- M2 V. ]+ @}$ M- D9 r6 j# C1 Y6 K
; y4 k- v* Y+ K
}5 a4 m/ E- d- e( X3 p& i. I: X, v
, _" \0 H- ` a8 g}7 b7 e4 r' k2 D/ w7 r: ~. P* ^: \
5 p7 @' ~% `3 ~! r+ j* d' F$InitForm = InitForm();$ m% Y, R: E* w3 `* z
$Listener = PostListener();# N2 q2 L) C& Z. B
B7 Q; K# O( d
?>. A( A ^. i5 ^1 O& f- T
, W# k; z3 R7 ]) y" M$ _4 m' Y
; Y& B, }0 N4 g4 I0 t2 l% ` Y* u/ A2 P9 a
7 E+ ]7 B9 k. k m |
|