|
|
<?php
) m) U, ]- X+ r$ @, jfunction Connect () {
6 W& E8 s% P& u! A- C! j2 E ^3 `mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
# `: t8 G: ~ r1 \3 g( e2 W& ], z/ T6 N6 M3 O- E+ X" t1 N
Failed.');
- y, P- H% u4 K' w# d# L- I}
: a" b0 V4 K( p- X, S" F/ MConnect();
1 d5 s* R( h, z! W: J/ k3 Q. d6 x8 x( S" i, B
function InitForm(){
3 l) w6 S" @% K7 s8 \3 b1 G//layout for the form5 F; I( |( N ^! m
echo "<strong>Send Items.</strong>
+ L5 ~9 O. M9 q+ g7 z6 [0 k<form name='select' method='post'>: u# K2 H; M5 W) v' p" C' m Y
<lable>Character Name</lable><br/>( j% f7 R8 c! M
<input type='text' name='char'/><br/>
& S, |. C: L" `! ~+ I) Z9 X<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
/ |0 |$ q8 X+ ]5 Z* h3 Z<input type='text' name='item_name'/><br/>& f3 m$ D2 W5 P2 F. [
<lable>Item Amount</lable><br/>6 A( v9 {6 p4 u7 g
<input type='text' name='item_amount'/><br/>
4 K% F' q$ Y) `- k. v3 u6 Z<lable>Item Upgrade Amount</lable><br/>8 k* I+ W# s' q5 }3 v! ?+ C
<input type='text' name='item_upgrade'/><br/>1 V. ~1 \1 D @' z+ G* s
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)6 U) z" F' N0 }# I& Z
: x& y5 G# f i0 W u; A6 h</lable><br/>
) q5 T% ^7 u" r7 w5 v<input type='text' name='item_element'/><br/>: p$ ~- G$ K4 r% ?6 N
<lable>Element Upgrade Amount</lable><br/>1 ^6 Y( E% }* M' n7 w3 O* N" J. y9 V& G
<input type='text' name='element_upgrade'/><br/>9 \2 ]4 c) I; F! {3 A
<lable>Pierced Amount</lable><br/>8 c; T8 j& q, B
<input type='text' name='item_pierce'/><br/>5 I6 `9 t" a: W& u. e ^* N
<input type='submit'/>
; s' }& ~$ z0 D, D& u</form>";7 c( Y) }( {7 K
}# g* E. M0 M" E, U8 t
7 ~* d2 _' ]2 F* a: B, D% A
function PostListener (){ K" H0 Q5 y# [* J
//Add more post variables if needed and add them to initform() function aswell1 X9 T. B) j1 K2 E
. [& N: v9 d; K9 s2 Q
################################
8 q" u, N# n6 C##### Connection and Post ######
8 p+ e8 V, e# i7 P1 C$ K2 B8 Z################################
0 r. J5 y$ I: N# H8 W3 I$name = @$_POST['char'];" R. `$ S9 X) K3 ^1 G+ H
$ItemName = @$_POST['item_name'];
& K9 O7 _0 ?# R) x$ItemAmount = @$_POST['item_amount'];
. u6 ?1 S/ m$ _& R6 N' q$ItemId = @$_POST['item_id'];
' s1 B$ F3 E% o7 \1 \5 T( r$ItemUpgrade = @$_POST['item_upgrade'];- v4 {* g2 D6 ^, G A
$ItemElement = @$_POST['item_element'];
' _) v0 N; ^# ^1 f$ElementUpgrade = @$_POST['element_upgrade'];) ]! o9 D: w1 N" Y7 X" h1 G J ]+ v
$ItemPierce = @$_POST['item_pierce'];; y$ \( s7 H l" R, e
################################3 l+ K6 {2 m# R9 \& y
7 D+ T& y$ s0 S1 b% v1 `
//Check both variables for empty value
3 Z. m0 V) w0 s4 U7 M( [, q6 z1 N( @
; ^" M& \7 B' Z0 v1 a( Gif (!empty($_POST['char'])){# g& l2 Z& W& B6 L0 i
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ; i* W; d8 p8 s; P: ? E
% L8 l9 P7 q" Z5 d ?0 q) p, um_szName = '{$name}'");7 a* D* h, i! i2 [8 s( a
while ($row = mssql_fetch_object($find)){- n5 O# k* R) }2 W) H) ^/ T
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
" C x- C9 G5 C5 m5 X+ P! |$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
& u/ m; c/ x1 B9 ^2 q
* z4 ~8 ^4 ^6 K4 [4 L/ p$ Z[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
5 w' C Q' e) R W2 o; }& |& n: V3 C1 x z; ^- y% Y% \# q5 i
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
' q1 r5 j6 P" f3 C3 w- j" `/ M' L) w
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', . ` K3 m4 i# w" x! i: L u$ |" F
8 W; N2 a" s9 y* u, s'{$ElementUpgrade}', '{$ItemPierce}');");
7 }" z* s- q: ]} z* Q; Y; {) |% A* S( T6 q* y
) j. P/ i6 v$ [; C
}
h6 l, E* E! t4 U+ G
8 c7 X/ n8 L5 h}
: R6 C/ r6 Y$ p) I( H7 k8 ?) Y1 u
$InitForm = InitForm();% v6 }" Y0 n6 d# x2 P% e
$Listener = PostListener();1 B ~/ l3 E; I$ w
3 x6 G1 i+ h/ Z?>
6 U H$ I9 p3 v$ O1 G' `0 e/ E
. [# Z2 h% T; O2 V4 m, K* i5 h6 M5 z( Q
6 T' a5 N, Y1 y: }
% d% m, y. Q% s1 n
|
|