|
|
<?php3 X8 T8 X9 f" f# m, [5 @+ V: a2 x' k
function Connect () {
: }& w5 @1 A/ x( a3 Cmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 3 ^0 ^6 f# p W5 m) w, w( X
. a2 a6 k+ g1 _* L" G: N( y- E1 }Failed.');( V/ }/ `) }$ m
}/ s0 z W( J$ @, z
Connect();
% S: G7 ^. i4 {! q I3 Q6 ~
' z% o5 J" w/ _8 ^% N8 G8 ^: O7 T( Gfunction InitForm(){; C3 x F1 r: f3 g& l8 p. X# x: S5 y' u
//layout for the form+ f. d, |' s& d/ @% t7 g
echo "<strong>Send Items.</strong>
+ k" E8 O( |. _2 [* c<form name='select' method='post'>
# v b) b: p2 ^( h7 W<lable>Character Name</lable><br/>6 W4 a( |9 L/ c
<input type='text' name='char'/><br/>
' A8 Y- z, \% d0 t9 e0 K2 u<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
7 I* d) _+ @. c6 Q& t5 J<input type='text' name='item_name'/><br/>
) H' A/ I% `! M7 O0 j V<lable>Item Amount</lable><br/>+ h3 N/ }, f$ S' d- V6 d
<input type='text' name='item_amount'/><br/>: j' J! _" c& `) z P2 m7 p' t
<lable>Item Upgrade Amount</lable><br/>2 f( G x% c3 ?
<input type='text' name='item_upgrade'/><br/>
$ |- T/ r4 i* o2 Y/ `! O' A& y* e<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)0 p7 R$ d& i3 Y+ q% ~7 D/ q
. z& F+ t$ j. F) @1 I/ v
</lable><br/>
2 O. y* x) H) f r/ B<input type='text' name='item_element'/><br/>
. e& Q% q, N' R# X# K<lable>Element Upgrade Amount</lable><br/>
% v% O" s+ T: @( n<input type='text' name='element_upgrade'/><br/>
- Q9 p r: j( X0 f. K% a' x1 |<lable>Pierced Amount</lable><br/>( n. M8 ~- \0 U' H1 {
<input type='text' name='item_pierce'/><br/># J6 `5 l, c3 o
<input type='submit'/>0 @* B7 ?6 v8 }. d& _7 j( k% R5 \
</form>";# c. l9 |$ V3 [
}/ q. U _0 _8 u8 w% @
: u9 N7 `! J* y2 K! j6 Z8 tfunction PostListener (){; t" n5 O. b3 b+ G
//Add more post variables if needed and add them to initform() function aswell; V2 C) Z/ H; Q% m Y6 H# H
3 O2 t ^1 I* F, X2 A- n' m
################################( ?2 v& F; J6 v4 ?7 k
##### Connection and Post ######
: L4 N1 F" w: A7 m. r' ]################################# D( j' \3 p9 q' Q
$name = @$_POST['char'];7 ?4 n# X9 B" s) c4 x& N
$ItemName = @$_POST['item_name'];
& d3 E+ O; C+ }; ^# E* j8 h2 O$ Y$ItemAmount = @$_POST['item_amount'];8 y j) q4 u, ]! I' J
$ItemId = @$_POST['item_id'];9 K) f& z& Y* p
$ItemUpgrade = @$_POST['item_upgrade'];
9 j3 i- k7 t% z6 D$ItemElement = @$_POST['item_element'];8 `' D8 y7 [8 P" W9 A) x
$ElementUpgrade = @$_POST['element_upgrade'];( u- w) E# A2 ?$ S5 v
$ItemPierce = @$_POST['item_pierce'];
3 ~. z( d2 q1 K, \################################8 e- f7 `4 _" ]7 _
% s9 z4 V0 \1 X. U2 z9 b0 U//Check both variables for empty value9 s3 Z: {- I y9 ?0 V
8 M! P v5 \; k; J/ S$ jif (!empty($_POST['char'])){9 s5 ~8 s% A* @3 X2 G# s4 G
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 Y; M7 j6 i0 A7 {5 D/ z* _9 R) g
) o/ E7 g: W5 zm_szName = '{$name}'");
7 U0 D0 p) ~$ ~9 e! e0 Gwhile ($row = mssql_fetch_object($find)){* W+ d3 [. b( }! b! [; a7 n3 e1 d
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
+ e4 r* u% \ q0 d7 K$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
* u0 b/ D- y0 l- P4 u2 N- b8 U) t7 R
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
( J! o- ]6 s- m- @# p4 V
$ N8 n- ^6 h s[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', : s7 d* C" J& c8 K o! {
* H. c0 s6 T d% K' j
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 9 E; I H5 \/ r. Q* C x
8 y/ M3 r; F9 p! `" }; _& g
'{$ElementUpgrade}', '{$ItemPierce}');");
9 V( J5 u; p/ ?: S8 u}
+ ^) m) c2 f8 l1 M/ Z3 b- v8 O
}7 C7 c% g/ ]9 p ~! z: \* Y
4 g% ^8 U Q, x) {}
6 F) O) j6 w6 D9 X, W+ ]8 `0 [4 k6 H. i* h7 d2 l
$InitForm = InitForm();
4 I5 V- e# @1 i- @5 ?) t+ S$Listener = PostListener();
1 V9 w7 u4 w) F% Q# I6 j/ Z, v2 ^& O, g" y
?>" k; v x% g7 T( L* R
2 n. R( G6 m, j! V$ F* q# W
* {8 o4 w* g' _" p" C+ n# x5 l) ^: ~0 y
5 m6 e/ y" e9 i5 Q( C! h |
|