|
|
<?php
, u' z2 ]3 O0 i \! i; Efunction Connect () {
3 ~" [4 ^5 ?8 n: j. qmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
$ W) Y8 G2 K# F+ _( W, I2 k ~+ a$ W3 J9 X
Failed.');
/ }! |, a! u! v `}
7 k- Z) L$ X2 ?8 I* i- e4 R8 hConnect();, i M- s4 m' y, a# @+ V, n
, `% o7 w! o/ z+ Hfunction InitForm(){1 b# D- M' W- ?) R1 N9 w( B
//layout for the form
6 z+ ]2 h) t# `( J0 ?7 G8 \echo "<strong>Send Items.</strong># q. S7 S6 L6 l9 `! d" i
<form name='select' method='post'>7 M4 r8 B9 _, ?# o3 n
<lable>Character Name</lable><br/>
" b+ f) K- E# L$ X2 e/ _<input type='text' name='char'/><br/>- j1 M9 p6 }% V O
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
8 W% u a! r* A9 M% i: t<input type='text' name='item_name'/><br/>7 o: W, z$ Q% q* _6 u
<lable>Item Amount</lable><br/>
1 ~$ V7 [/ j6 j7 w<input type='text' name='item_amount'/><br/>
" {4 o/ V/ r$ A" o6 B) }9 q<lable>Item Upgrade Amount</lable><br/>6 t! D' C- Y( m
<input type='text' name='item_upgrade'/><br/>/ u! S. [6 x8 ^& S* a& |
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
- m' _% E; @2 Q0 F8 P; v* J r' w9 r0 K$ _! \* I# C
</lable><br/>
9 B1 [0 d' ` g3 ^) m" t<input type='text' name='item_element'/><br/>3 L8 ~/ V* R2 t) P8 }
<lable>Element Upgrade Amount</lable><br/># y% _1 T# o* g. C7 \( Q
<input type='text' name='element_upgrade'/><br/>* J) e. Q: Y) I. o0 r
<lable>Pierced Amount</lable><br/>
5 H9 j+ b: ^4 w/ u7 w- d<input type='text' name='item_pierce'/><br/>
5 k8 f+ Q8 u S% B3 G8 t: @<input type='submit'/>8 R8 K) k+ X! D: P
</form>";
0 [$ r8 ?# ?6 ~( i% U% C0 j}$ s1 {/ c% e) Z) ^6 h8 w9 z
: `: I. M$ \( I/ o/ G' |function PostListener (){
3 p* K% r" i4 I' r' L# \5 u* R//Add more post variables if needed and add them to initform() function aswell
1 D: S N( ~9 y( y" Y! u1 a) n U4 x ^
################################
! s) p; v# H) R g##### Connection and Post ######/ B8 x3 c. x3 Z9 S# y- Q" V$ R0 Q
################################
( m( m: t3 v6 Q" x1 P$ s$name = @$_POST['char'];
1 ~8 m$ s" w% P8 `. `! O* m$ItemName = @$_POST['item_name'];& O) n. S# e+ N! |5 s- y, j
$ItemAmount = @$_POST['item_amount'];3 f$ t) F9 J- N; M: ^3 y
$ItemId = @$_POST['item_id'];3 u1 j; A6 A }. v& f( v* w
$ItemUpgrade = @$_POST['item_upgrade'];
7 `2 g: \9 \6 W! l. O+ t$ItemElement = @$_POST['item_element'];# ^( i3 ?* O9 H
$ElementUpgrade = @$_POST['element_upgrade'];
% e8 y) u+ g% E% W' N3 C. m$ItemPierce = @$_POST['item_pierce'];
\- y8 s' j% {% E: Z################################
. S/ F2 i# r5 @7 T5 Q
& ~2 S$ x2 A+ @+ N# u4 A( N//Check both variables for empty value; w# M" l" |8 M% K8 p, K
3 Z S* Y* L$ o6 ]) C7 z; @
if (!empty($_POST['char'])){
( |6 o5 T# L$ w$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ! \& _6 i/ J2 U$ R5 R* b
( J; A2 D% l, W
m_szName = '{$name}'");( F$ C. [7 b! z' t8 d; X+ L- L
while ($row = mssql_fetch_object($find)){$ [! J7 T4 P2 l1 J8 A2 [! `
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
2 K& Z0 f7 C8 B8 i Q. f$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
% q4 `3 F4 ?- N4 {' t
) t: P1 ]% w) i4 k. z[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
! E- F$ |7 W4 q9 Z
3 {/ _1 N- i$ A, S; |2 q% L6 h [[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
; Z) c* J d: \( W' O$ Q. y, m
: C) l2 K4 `% P$ d* s9 r* eN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 4 c, B) p, c+ J( P5 w: B w
# @/ {% v" G0 N5 J'{$ElementUpgrade}', '{$ItemPierce}');");- k4 \! `. T8 f1 t
}% F. c2 W- s0 h! h$ H q6 i% ^
# V5 f! x( |* V6 Y! |
}
, O- g3 S2 K4 P; _4 D7 a/ a7 s$ s6 L+ D, ^
}
T. D: \% U. S3 D# S4 I1 g+ V: v0 b2 r& C
$InitForm = InitForm();! \0 d0 I( ?2 v' M# \/ k4 j" Q
$Listener = PostListener();) L7 ~6 H: a; Y0 K/ D, a3 m
2 ~! \! f7 ]) c/ j
?>& e( i" w$ I# N4 T& K( {
9 z. g- S: C6 B9 ~6 K2 n% O) Q; E5 h9 u# i
4 m4 ^* J9 X N' O4 S, I1 s3 N
/ O. E) e( ^! V
|
|