|
|
<?php
- i1 I3 @4 x3 Pfunction Connect () {- z$ v6 I- n8 s# R# i' B
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
+ E+ o/ D& u' x3 h6 v9 \5 @, R# t w# J4 G, Z3 Q% E
Failed.'); s ^: f2 ?/ g% T( e# F8 V$ I- W
}4 O0 h1 h. |( F. U
Connect();
2 H* Q/ |0 a x5 F
5 d' y+ c% C# h; Q5 T7 ufunction InitForm(){
# O! J! R9 e; c+ L: t//layout for the form
) ^1 Q! B9 V' Necho "<strong>Send Items.</strong>; n- V# r3 u; M% k* K5 _3 }
<form name='select' method='post'>- y+ N* W# B; k! Z- _, V
<lable>Character Name</lable><br/>
4 e, _8 x0 ?' \% n$ F7 I" n1 k<input type='text' name='char'/><br/>
+ F+ B& k8 X0 ^/ z<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
+ ]0 q1 A# }# h" i2 t) ~<input type='text' name='item_name'/><br/>
) X0 w' f% M$ _( A9 T<lable>Item Amount</lable><br/>
7 E, z9 O _3 c9 z* ]<input type='text' name='item_amount'/><br/>
2 Z" R# R: P; i* P5 s<lable>Item Upgrade Amount</lable><br/>
0 n' b# h" E. q5 U! O+ d<input type='text' name='item_upgrade'/><br/>
) \% n5 r8 @# v! e<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
, B& N# o8 L8 v, q$ x$ U) u
& h) E# O4 K; E5 l/ R</lable><br/>1 p1 Q" B- |2 j6 e8 o- ?8 A4 Z
<input type='text' name='item_element'/><br/>
# f d6 `2 H" \/ u: O<lable>Element Upgrade Amount</lable><br/>& x# Z }2 x$ j8 G8 W2 U
<input type='text' name='element_upgrade'/><br/>
$ K$ W9 A- `3 v& I' B6 Z9 f<lable>Pierced Amount</lable><br/>0 j: `: [9 k+ {+ I& f, T- }
<input type='text' name='item_pierce'/><br/>5 M9 ?! R1 u* q2 E
<input type='submit'/>% `4 H, j- p3 V1 S' r, M0 }
</form>";3 y4 P$ R) ~1 X7 k
}
3 w/ o" O5 f% u: w
' [0 e' G+ n, X6 Afunction PostListener (){* P1 j$ S$ X/ d7 q0 T
//Add more post variables if needed and add them to initform() function aswell
2 M7 u* _4 {) r% g6 c$ e: b, b# @1 E
################################
2 R0 o) @3 a- v8 j7 P##### Connection and Post ######
3 K" b* N, R. Z2 b, N################################
& B, f7 L7 K& |) Y0 T! f$name = @$_POST['char'];
n; R. d1 j* H2 l5 j% g3 Z$ItemName = @$_POST['item_name'];; J/ D2 q& L9 w5 ]4 x1 J
$ItemAmount = @$_POST['item_amount'];
/ O6 s6 q( m3 c$ItemId = @$_POST['item_id'];9 I: d" R( r1 l
$ItemUpgrade = @$_POST['item_upgrade'];) G" ]0 |( J6 @0 i( u( s& P8 v
$ItemElement = @$_POST['item_element'];+ o1 u* n7 S5 o& Q5 R. d- i& o; Y
$ElementUpgrade = @$_POST['element_upgrade'];, V# ]* E5 x+ |8 l0 m! c2 q( A
$ItemPierce = @$_POST['item_pierce'];6 k6 c! H3 p1 p9 ?
################################) I) K# ]- L/ b% ~. S }; U% D
/ K; r$ P9 ?9 D$ r2 k//Check both variables for empty value
" y: a3 R* h8 t+ b1 c2 Z1 M
/ m9 ] Z R& K- U" X5 @/ s5 C8 @if (!empty($_POST['char'])){' O& n- ?& x2 h( [" y! r! K
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
* I6 E) S8 `- y. F3 w% a' w
, }( o' b2 W L- \& {$ H' bm_szName = '{$name}'");
2 E+ W6 O' T& F) N. q) Y) Rwhile ($row = mssql_fetch_object($find)){
( f1 Z+ f; w' L Y- O% d. Becho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";% [3 y, `& K. j! K ~0 ~
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], . [8 }5 { v8 n7 `1 @! b8 F2 i/ T- k
, ], @. R( c( k) K3 u[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 4 }0 u' V, [1 X3 {8 @3 Q
# d& `6 L/ G( K( Y: _$ b
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
0 j" [3 h/ K& S) r/ x# P9 O' g- I7 t; @/ A
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
1 j, `5 r# c) O9 |
& V* s8 Y3 g, J- q2 `, _2 b# \0 S8 M( F'{$ElementUpgrade}', '{$ItemPierce}');");
% ]2 G) i* T; C7 Z. R( I}9 l0 R- \8 \& m/ R9 n
0 G! E8 o8 f8 O/ o. T0 P8 l
}
! P: T6 @5 m% W# [2 B$ p6 X* M* T% m1 d6 p
}9 e( E3 {6 w' h/ C" r6 ^5 c
; N# p& c/ R p7 v- `1 ^$InitForm = InitForm();
, @4 J o% d# z- N. v$Listener = PostListener();
2 \; O% N- j" @! A: y& e4 X
g# Z5 x y0 c?>
% x, u- j) g% e9 w
5 Z" w1 l2 {' V& S2 b' \ F- G/ ]8 p: E$ u& u% L: |
) _1 b# s4 U7 f2 P6 n* C; D& M8 c7 m! b* g5 J
|
|