|
|
<?php
, x' B% N" h- S! Mfunction Connect () {. x* G- m: L# X! _* r
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 5 S5 V3 }3 m' y1 F, G/ s
+ B3 n1 P6 y! Y; w6 Y+ `
Failed.');4 S" h6 V7 I$ s) s6 i K
}( Q7 g/ x( ~; _
Connect();
5 f1 z* p5 D& h3 {( T& Z$ L
, v# `0 @0 \" G8 v2 r7 Z+ Afunction InitForm(){& H, Q/ p: M! @( D
//layout for the form! {4 f# D+ {5 S& Z; j1 P
echo "<strong>Send Items.</strong>. s2 E2 Q/ [4 T% P9 n9 c
<form name='select' method='post'>" r; S* m$ ], }) l: T" h/ H6 E
<lable>Character Name</lable><br/>
. O- B, l: @" g% }9 t<input type='text' name='char'/><br/> w0 |4 D& ~8 B1 f
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>6 z. t5 \* D0 f, K
<input type='text' name='item_name'/><br/>
6 v5 U. ]# H) i% t, v6 ~: u<lable>Item Amount</lable><br/>
5 n' [9 [0 o3 C7 s9 H<input type='text' name='item_amount'/><br/>
. c3 K$ c9 ]0 i+ [6 B<lable>Item Upgrade Amount</lable><br/>
+ ^8 F4 i" {- }; v' |<input type='text' name='item_upgrade'/><br/>6 m$ j: Q, T( w) K
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.); w5 j9 _+ c* p1 h7 n# {
+ I' g' v# u* J3 C0 U</lable><br/>/ u9 Y U7 B6 o
<input type='text' name='item_element'/><br/>
8 E: s2 W/ l2 M% {<lable>Element Upgrade Amount</lable><br/>
0 C$ i6 `6 E% H" |<input type='text' name='element_upgrade'/><br/>2 N4 p6 |' @7 x2 G+ C7 `7 z& \ v
<lable>Pierced Amount</lable><br/>
, l8 a0 N0 T1 T% |; q<input type='text' name='item_pierce'/><br/>6 G( ^0 W/ B9 Y4 k! T
<input type='submit'/>( l5 p- X# W7 [( P$ V* w! N1 `
</form>";
" l( c& f/ _$ t2 p E d% |9 v}
- f" D. A- p1 W3 Q+ H
! T( |* F E4 E) K T$ @function PostListener (){
5 Y# j2 w% I- F//Add more post variables if needed and add them to initform() function aswell
+ v2 E+ A- O- M' Z8 S2 U
v4 i+ x L- b" g) D" |% R0 A7 {7 t################################$ z: j4 S7 T! B9 B, S1 N$ d
##### Connection and Post ######
$ r3 N2 b2 H6 G################################, k# S* I' d1 x7 v
$name = @$_POST['char'];9 |3 V7 v" Q9 R8 u
$ItemName = @$_POST['item_name'];) l7 M; h/ Q$ p R6 p2 t6 R1 M8 X
$ItemAmount = @$_POST['item_amount'];
; M8 h5 V2 ` C# K* D& D, ]9 `( O$ItemId = @$_POST['item_id'];
- L2 l# ~! B$ R2 F1 U g4 c$ItemUpgrade = @$_POST['item_upgrade'];3 T \) B5 N& W) M; x
$ItemElement = @$_POST['item_element'];
7 T' @3 o$ ~/ f8 X6 @$ElementUpgrade = @$_POST['element_upgrade'];
1 c$ a4 t5 F/ |4 d$ItemPierce = @$_POST['item_pierce'];
: X& |5 T/ y0 G4 D) W################################
9 M* d. i% U O9 z. X2 r# ?0 L
: `2 Q+ r+ y% F9 {, l9 q//Check both variables for empty value9 o8 D2 }( Z- H5 b: F$ i; R
3 X& {& I( c- q, B Yif (!empty($_POST['char'])){7 q( K0 y' Z' A9 T
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ) V g- O! H9 E; E) }
: C9 h) @/ q6 c4 h; {+ r
m_szName = '{$name}'");
. t. d) Z' o" C9 I$ S7 @while ($row = mssql_fetch_object($find)){
( b+ `% i# O1 secho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";) V3 q) r( ^* Q! |4 @- M, n
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
) E: h9 P$ ?8 H1 a" J3 c2 S6 _' g- O2 d' B9 J; t
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], # z6 U2 h$ p, s* q% P# z
1 Y3 O- d% y, [9 l" q4 H. `& U
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
1 }+ A9 f3 D E! p" b; H6 u! j) N T1 p7 @9 ]% r6 u
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 1 }; s- V" a3 p
; p0 a, z$ T% ]8 P'{$ElementUpgrade}', '{$ItemPierce}');");
3 _# |/ E2 G* \2 K- `9 p; b9 m/ y}
- ]4 g3 t0 B( ]( X- q9 K# e
; D: z/ D, J. L" H" `7 f6 ]0 e: @}
7 h+ d1 I8 p6 W0 Q3 q+ z9 G, n- I6 d2 K/ ^
}! F( j! X) C4 C. e- o% h; v
3 c, b8 g1 i2 R. e, l( @
$InitForm = InitForm();% ~9 F2 s( y+ q8 h$ }8 C0 A
$Listener = PostListener();7 P2 {6 b3 f) N& B. y$ ^1 t
, p: \8 L$ q; n& a7 V
?>
~/ V- U3 J; c- W; U x9 @' a; r. {3 D j" z
4 D0 ]' c) M9 \- G- x
& M& a& Q( F5 M: z4 s5 L5 }: K* p3 o. L# C2 T/ F) D! N* _' H( l8 B2 d* m5 j. D
|
|