|
|
<?php
$ Y( Q( X9 d0 ffunction Connect () {
, A, ]* s V1 Ymssql_connect('Server','UserName','Password') or die('Error: Connection to DB * ` N# n- w d( V0 _0 B# a9 q
* G9 ^! \+ T. E! f+ w. f, q8 R
Failed.');
- k# i$ c6 j4 V}2 F! b8 l" [( O! Q+ s/ \
Connect();; m4 x& {" S+ _
; }& H- m2 ^* Lfunction InitForm(){" T2 ~- t, C: _" Z' X5 W
//layout for the form7 Q/ `* o# P: I! C5 J
echo "<strong>Send Items.</strong>
0 H& t7 X- q7 ?5 j<form name='select' method='post'>0 L+ m+ Q7 o, G1 _7 `
<lable>Character Name</lable><br/>
7 @9 g" `( f: e X- g' J<input type='text' name='char'/><br/>/ r f6 r( O% h# c
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
7 t9 P: ~# [, W# U3 K<input type='text' name='item_name'/><br/>
# X6 E( o8 o, j<lable>Item Amount</lable><br/>
6 P& q" V9 F2 M<input type='text' name='item_amount'/><br/>
# u1 j% M8 u! Y, `; k0 v+ v<lable>Item Upgrade Amount</lable><br/>
9 u s; Y- y! b. G<input type='text' name='item_upgrade'/><br/>
, u: E9 B1 k5 k! b9 N<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)& p3 | H2 j( s0 Z, ~
, k) J; k7 U; N4 `1 Z8 H
</lable><br/>4 `4 Z9 e: j! _7 x& j
<input type='text' name='item_element'/><br/>$ h; v! [( ~% o" Q# V: m) d7 t
<lable>Element Upgrade Amount</lable><br/>
9 x$ }# t6 F A<input type='text' name='element_upgrade'/><br/>
; h5 T* l( R# L9 E' \<lable>Pierced Amount</lable><br/>
3 h# P5 t- j, v( J* Y$ k1 H8 j" H<input type='text' name='item_pierce'/><br/>
* }& F' B3 T4 Z4 U3 B v<input type='submit'/>: [5 h/ @: V3 t8 m0 C6 V+ o
</form>";
0 y6 t: N3 R& d8 p}
- u, l! b9 [) F l7 A
6 J7 D' p5 F$ ?+ D4 z; W8 Ifunction PostListener (){1 i$ C- b, L, a6 k4 r" E
//Add more post variables if needed and add them to initform() function aswell
& v t$ ]' T2 m5 i4 ^
' n2 u' _* I( g w f. C$ ^) ?################################6 J, s4 z1 b1 o$ d" M, v
##### Connection and Post ######
# \( ^0 M3 G' k" E################################
# D: V/ e+ v2 \$ K( ?! u7 V* ^$name = @$_POST['char'];, O( h1 b/ v: M; B$ U; L' _
$ItemName = @$_POST['item_name'];6 f' a0 `0 Q2 ]$ @$ b! o
$ItemAmount = @$_POST['item_amount'];/ r! W& }& R& |' A, M; X. m) z5 x
$ItemId = @$_POST['item_id'];
( s5 k$ ~4 D% T+ l$ItemUpgrade = @$_POST['item_upgrade'];
! ~( z$ O- ^( q$ItemElement = @$_POST['item_element'];
+ C' U2 e, a9 k$ElementUpgrade = @$_POST['element_upgrade'];
! a! I t9 A9 V. w3 ^5 u$ItemPierce = @$_POST['item_pierce'];6 N/ O$ I- t& l1 l4 u _
################################
2 l- q( o1 p: N6 d9 w1 L& _) F! J7 h% m3 | ^5 |3 h5 D$ G7 N, d
//Check both variables for empty value
- n5 d3 u& M) b
7 v3 A1 ^: J& ?2 a/ U% x0 \if (!empty($_POST['char'])){
% ~9 v+ b! z& F- j$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
) E& ^( v: m8 l$ Q) ?3 p# s' Q( Q* S0 G+ P8 P3 C1 h" V l) x( u
m_szName = '{$name}'");) x7 H3 p4 F [. m
while ($row = mssql_fetch_object($find)){, a4 Y/ h0 J7 L7 Q. \2 e
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
' Y, r; u3 v- h& j$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
( ~% }$ B* F7 x: o- S4 u; i c- I* j; A& L$ t
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ( x) I5 S3 y5 A
. u, [* Q3 l# t: a: d( E" T" S$ z; W[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ; ?( e3 t$ n( S) U% H4 f7 [( s
* B8 |0 T$ n- e: S, p' fN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 8 b6 p, v" L0 d C0 f
5 t4 f; X6 Z6 X% |# i1 `' L( r'{$ElementUpgrade}', '{$ItemPierce}');");! e y1 r3 {6 r a! v0 F' Q
}
2 P6 G- D8 v) q4 r+ G8 ?
: G* T4 @6 e' U, V' q% H* v8 P# x} V9 Q- L" V5 v2 z
( W5 d+ a1 p! s7 t' |
}1 }7 T0 }3 q4 Y- a" V8 b: i* L
. ]0 j) D. ?- l i/ G4 W$InitForm = InitForm();$ T/ W4 g, o. G& ]/ \$ w* ]
$Listener = PostListener();
% K3 `( R* ^ W1 ]- H
; d, M4 ~' a3 I$ h?>% H: y$ a( | N p1 P- h! X
9 O5 J @, K. p* I! u+ F5 C9 V; e! {9 V
5 K$ D K( E% w. j% t; G
0 I% E9 b( P" O$ Q5 y8 f
0 U0 W2 W/ ^/ u ~5 s+ }% t7 @ |
|