|
|
<?php
0 ~& l$ V h( p! q# w6 e9 q, ufunction Connect () {8 o4 ?, A. `7 W
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
1 m3 l' g$ d B9 W8 [3 F2 e) ~5 t$ z4 P# X9 \
Failed.');& V" H; {9 F5 N
}; e4 w5 P5 I4 D
Connect();
# @) L, O5 W" f7 p4 N- y6 }/ u/ c* h" G; Y6 c* r3 n. f
function InitForm(){
9 W/ E6 l( V/ X% l% W//layout for the form
& A' G" V/ v8 F1 r. X2 N ]echo "<strong>Send Items.</strong> b1 q: r/ h4 q
<form name='select' method='post'>
: U O5 ?1 r( d+ b1 |8 p<lable>Character Name</lable><br/>
- D8 _0 l1 H1 m7 ^' S<input type='text' name='char'/><br/>7 n# b# L& O) N
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>9 k6 n; }7 i: |- y- H
<input type='text' name='item_name'/><br/>
! H( i( f1 d9 T6 ?3 F9 `0 O, A9 X<lable>Item Amount</lable><br/>
4 b- ]) K/ }. t5 b<input type='text' name='item_amount'/><br/>* H7 n' M, M3 T) w9 \
<lable>Item Upgrade Amount</lable><br/>) ~& y9 e/ \' F* l( a. B, |
<input type='text' name='item_upgrade'/><br/>
% s7 S3 d( O2 p' b0 z+ {+ N% n2 m<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)% i) z& K9 Q* Z6 m' g
/ V8 V5 V- p' A3 n8 @</lable><br/>
* a" q0 |% _# w! Z# Y3 O8 l<input type='text' name='item_element'/><br/>
' M( p& ^6 O0 v+ o6 E<lable>Element Upgrade Amount</lable><br/>. ?3 P$ ~) }* u( r* F
<input type='text' name='element_upgrade'/><br/>
# L9 J9 i7 ^$ }1 V<lable>Pierced Amount</lable><br/>
) G) R4 u- h2 |9 U8 J' \+ S% {1 C0 _<input type='text' name='item_pierce'/><br/>$ o6 {6 Q/ M5 U! o# l
<input type='submit'/>
; |, P) C* b: r- U- {. O</form>";
' a/ F5 S+ b) N5 v9 i9 I- P: j, X' C4 n}5 W D$ ?! @! N
% x" d6 q2 y6 i* cfunction PostListener (){
0 a1 A! I% G2 K7 |3 P! g//Add more post variables if needed and add them to initform() function aswell* \- P" |5 |1 h; W" [" G8 J6 _
( Y& |9 w0 K& u) n################################
* p2 T& J# {+ L6 p* g p ^5 n* c##### Connection and Post ######
% j- z( S' d, Q$ f$ V################################
5 Q2 k. E- F. k; _" h4 R$name = @$_POST['char'];& H V$ L. [# m }; Q9 u8 Q
$ItemName = @$_POST['item_name'];
B* j: J5 O, _; ?4 d4 n4 G$ItemAmount = @$_POST['item_amount'];) O v0 H9 f- I
$ItemId = @$_POST['item_id'];+ G3 K7 X1 p, d) I' i
$ItemUpgrade = @$_POST['item_upgrade'];# N, [5 g% ]0 l: A6 c/ q" e
$ItemElement = @$_POST['item_element'];
& C4 ]# a" ^5 C, y$ElementUpgrade = @$_POST['element_upgrade'];( d0 N" t. R7 p7 ~
$ItemPierce = @$_POST['item_pierce'];
0 u2 ?2 _" o: ?2 K: B################################3 O2 k! [% v: ^7 w0 u8 h2 o( a
, v- \* G/ I! R6 l( E
//Check both variables for empty value
) m3 P8 V& r l- J- f! }. T5 s6 \5 y( h3 i" p" ~
if (!empty($_POST['char'])){
% Q( q# g/ P& l/ |$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 9 H5 ?) n7 [% S8 s2 `6 ~9 w! C+ Y9 g
7 B' ]/ O0 x* r S6 u* sm_szName = '{$name}'");; R/ R2 S8 {/ a3 i6 x) {7 @" o
while ($row = mssql_fetch_object($find)){
7 |! [2 l5 p- d/ U% hecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";6 V# t4 \2 G! u2 H
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
* y+ X) j3 @* |& D4 @* m+ t7 \ R" ^7 ]5 P, l" N; ~- z
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
( x( e, e8 F( z+ `
' A8 K6 N/ U5 o5 d3 T' W( P( w" y[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
$ V4 {5 M9 r. L7 u
, j2 A" y' `" N% k, W' ]N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ) l F9 G' r& t6 V4 X" o+ |
. c* a( Q* V/ t2 c! o; F" P- s, b
'{$ElementUpgrade}', '{$ItemPierce}');");' K ~$ V1 J& P3 k
}
' J7 W$ Q1 X' V8 O4 }
. j8 T# B8 B5 [) N2 `" d: c3 A}
$ M/ _" R3 e2 T/ P4 U9 J/ H# J( H' q4 J5 `! }8 l A
}1 l6 Y6 l8 o- B, K7 k; `
. `) \: j1 W9 F( ?1 l* u. w$InitForm = InitForm(); ?7 {% `/ f* v) Y
$Listener = PostListener();2 r- z9 w4 S) N! I# E' Q2 o
& g) `5 ? `- H: |" {
?>% C6 D1 I: r9 R- \! t. L. d) E
, |3 o, H, R5 |" n3 l% ^4 }9 l: \8 e2 u
) G: H' v- k) \ Y" I! `" M( S( [7 l4 l! q
|
|