|
<?php
- e& C: T6 d Z( ~+ P6 q/ ~7 Bfunction Connect () {
* I1 \+ P3 w# [, P3 X; O9 Kmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
" H/ Y, C1 [! d" ^6 b6 E9 n
" [- u/ O3 D2 @4 m3 u% A$ a8 @Failed.');% ]; t$ ]6 V! J' W- g# X
} R ]2 |/ m! h4 [2 g
Connect();
# D; f! h2 y9 I) n* e6 g( ^. O1 j6 V, _' I6 X- F
function InitForm(){
2 M( v P" g& ]; k, R! y* E//layout for the form2 z2 ?; ]; k, ~. l+ }6 Y
echo "<strong>Send Items.</strong>2 e# a, M: _6 s# R/ ?6 _8 N0 b
<form name='select' method='post'>0 V- n% J+ s& E' B! P1 O
<lable>Character Name</lable><br/>
7 ~1 i- }9 H% g( p( u<input type='text' name='char'/><br/>/ |) ~3 q1 e7 B _
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>7 c+ V" L3 r! O, Q% F
<input type='text' name='item_name'/><br/>
$ M( a" C0 B+ T8 s3 V0 m<lable>Item Amount</lable><br/>6 q% F) j( w5 o2 K4 d8 r* L
<input type='text' name='item_amount'/><br/> P6 T m/ u. W, X# q: q. [
<lable>Item Upgrade Amount</lable><br/>, T4 x" H b5 ]- R0 s" ^
<input type='text' name='item_upgrade'/><br/>
3 \- I. g' Z- R0 B' E- h<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
/ t; A: ^9 K* \" I4 a7 i
1 {" m& \( K/ M6 x; {3 C</lable><br/>
6 f0 j9 R/ H3 y, r: y" H9 E<input type='text' name='item_element'/><br/>& \% `7 U$ F- O) T9 n* o) A/ B
<lable>Element Upgrade Amount</lable><br/>
, |7 }) c( f0 X! i0 @( E<input type='text' name='element_upgrade'/><br/>
H& T B$ \; A0 t6 B2 C H! D<lable>Pierced Amount</lable><br/>
$ h# q! q& G! g<input type='text' name='item_pierce'/><br/>
9 v$ D7 }% [; _5 [" y<input type='submit'/>
% O! p3 |; ]8 y# q, s% }</form>";
; w' ~; R! ?9 Y) e. k6 N8 |}; `- x1 E( p! Y& p& R
$ O% M7 `0 t9 o e
function PostListener (){
" L# N. z1 P+ }9 o( W" c# n* M//Add more post variables if needed and add them to initform() function aswell- k/ f$ t v2 y
! h% X2 V0 B. o8 @################################7 v, ?! E3 A0 v4 u! g
##### Connection and Post ######% _8 _ E' [1 b% k. ]
################################
! D4 N5 R/ Y/ M2 G$name = @$_POST['char'];, ^* b. v \4 L/ o1 w6 ?
$ItemName = @$_POST['item_name'];, N, U! K# U, C. }- ^
$ItemAmount = @$_POST['item_amount'];
* G% c" w# a4 Z0 u, m$ItemId = @$_POST['item_id'];
9 S; }* m& d3 c3 s& i$ L$ItemUpgrade = @$_POST['item_upgrade'];
6 C8 t: i. D- b$ItemElement = @$_POST['item_element'];
: }' g+ N6 ?" o% E' L, ^$ElementUpgrade = @$_POST['element_upgrade'];
; }+ b$ H- m9 \5 O* y, M" Z$ItemPierce = @$_POST['item_pierce'];* d3 z; x$ S: o/ {& ` L
################################- i$ c( G3 \: [7 Z
7 A0 q r: y L9 x1 S//Check both variables for empty value7 N m# e( E' k
n; D# ~* K. hif (!empty($_POST['char'])){9 G, Z2 t3 t1 g7 T* w' O
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ' c8 a8 k% u9 G7 {
/ f. a6 I% v3 ^
m_szName = '{$name}'");5 T/ o1 ?1 L9 v {1 |: l
while ($row = mssql_fetch_object($find)){: c: \, B5 s) k& ]% w7 q3 {& F
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";4 k3 a' W4 l0 o2 w" p' X! Z, L
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 9 z- I: T4 `& \3 D
% _- `. [2 i5 K( M- h+ M[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], I$ S5 ~4 ]; B
+ @% u1 z/ j6 G2 L" e) O& {5 S* k[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 0 M- O! i; e4 `9 W7 }
2 G0 E$ F& V, }! i: |4 o$ ?N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 0 a8 ~1 g- F" `* L6 A5 f8 P7 R. D
4 N7 H9 W! p& E0 k* {
'{$ElementUpgrade}', '{$ItemPierce}');");! K/ @- J; C7 N
}" `3 e9 f+ L/ E: V
5 Q {% a, d# A, H- F}
4 f1 S8 x- w. d3 o5 `3 T, n) Z- Z
Q- j7 Q$ n1 {/ t* D& C) ]6 o}- W0 a3 m# H5 b, N" p
' b6 }# s* R7 ^5 X" l9 Q
$InitForm = InitForm();8 s; g1 W& R4 c, g) Q* K% o
$Listener = PostListener();
8 ]7 S% j3 I: k0 R! e5 j
; N0 d" l- c3 v2 n?>% O1 E" q% z* Y( z& {* c- l" i4 i
8 X+ r4 Q$ u4 V* y; z2 l: G# K
V4 y" `5 e; S6 v
) x" r% o1 t# h- X& _% K j
$ k* L( D+ y8 y0 K: r' n" x# D1 ? |
|