|
|
<?php) {. c8 z1 G4 y
function Connect () {
0 m, Y4 s% [ K0 y0 _0 cmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
/ U; U/ \2 N& j1 R7 h# t7 X1 h; B3 ~* d! }3 ^
Failed.');
% R8 U- K& y4 R3 Y6 D# @}& U4 q* L- [* T- M! u' e7 _6 X. ^% T
Connect();$ |3 }2 B2 A6 n( @% X- ^
6 }- o* `0 X) \. }3 v
function InitForm(){
; ]$ L) l% y. H6 j k; j//layout for the form1 ?- F3 e' X6 l% s* T5 z
echo "<strong>Send Items.</strong>
1 E7 ]& {, I+ J1 X7 I# n$ {<form name='select' method='post'>
/ Q# M. V" l8 v' o5 B7 e( @<lable>Character Name</lable><br/>
! l% B- p8 r, ~) [& t1 }) |4 u<input type='text' name='char'/><br/>
) M* u1 {) N9 M$ v6 Z<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>4 O; e9 }# j* l% u3 F( K: X% L
<input type='text' name='item_name'/><br/>) {! U( J; U4 W! u0 d9 b
<lable>Item Amount</lable><br/>
9 b5 t, J, n$ Z<input type='text' name='item_amount'/><br/>
& I/ J" a+ |# b& I" ^+ e4 Q+ ~<lable>Item Upgrade Amount</lable><br/>) c: D! a E9 P! R
<input type='text' name='item_upgrade'/><br/>3 Z( c, v) i8 h/ z' f- d
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.): k! b" ~8 O/ y( x L' C
" T! [9 g3 G) L$ p# X3 B/ l2 a
</lable><br/>
& o: @& R0 D9 R! b$ u<input type='text' name='item_element'/><br/>
4 Q4 Q5 `6 V% U- {* ~$ Q<lable>Element Upgrade Amount</lable><br/>* h. H- w/ Z, Z: e1 R3 p! q
<input type='text' name='element_upgrade'/><br/>
! h1 F3 @! R& B$ s<lable>Pierced Amount</lable><br/>$ m" P0 n- w6 s; [
<input type='text' name='item_pierce'/><br/>
h: T5 t- F) m1 k! G2 `; ~% W<input type='submit'/>
: ]% e `9 e0 r" r3 v- I9 H</form>";5 Q! z% ] x7 @4 k+ [
}
! ]/ i* B0 R- @8 Q) O3 C5 e' T
6 ^% D$ T- _ G- v t+ t% qfunction PostListener (){" v, s( x5 Z4 }
//Add more post variables if needed and add them to initform() function aswell, @+ R# Q6 A7 Q" {; Q1 t
5 [) A% S" ?7 _$ M' m3 {" e
################################9 p# i, w/ j p, x, Q/ u0 Q4 h! s
##### Connection and Post ######
: [& Z$ `% N) U1 ~################################' Q1 ~0 l3 H! I0 L
$name = @$_POST['char'];
; \# [* b3 r5 D$ItemName = @$_POST['item_name'];
" X, k% `7 c0 O, [) ?8 _$ItemAmount = @$_POST['item_amount'];# K9 N+ X8 O( Y* I6 l, S
$ItemId = @$_POST['item_id'];3 \6 p; [: J$ d# a
$ItemUpgrade = @$_POST['item_upgrade'];/ ]& l2 Q( }) v
$ItemElement = @$_POST['item_element'];
; }7 E! r/ Z0 E$ElementUpgrade = @$_POST['element_upgrade'];6 }; t: K$ t8 {; w- p' B5 r2 Q
$ItemPierce = @$_POST['item_pierce'];) N t/ j5 ]" O/ L# a0 N
################################
- e5 j3 X! T# e9 v5 }* T2 E9 n; n) h+ }8 d4 V
//Check both variables for empty value: w1 }4 f0 I* n/ n' M) b
5 |) i2 s! _5 ~& g
if (!empty($_POST['char'])){
" Y# E: w# w0 k6 V( ]' D+ q$ v$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 D' ^0 R$ m3 R, a* _
! w& y) h) d2 zm_szName = '{$name}'");
! O0 ^" [7 F+ J2 n2 l# ?4 v! F2 \while ($row = mssql_fetch_object($find)){
0 ]5 ?# G: ], c0 G* |+ Pecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";6 c" A0 B) W, [7 I" o
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
/ I/ c! i# y# u" H" d6 x
0 O+ M, T* h' w% x: Y5 j[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], $ @' S; U1 c$ W* _
# n/ b2 j* r2 s( o6 [( A
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
) C( B: d" [; \3 {! k# c9 q. U% Y/ O* W' I% J, @# B+ h
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 4 L, H6 [$ b3 g2 W) _
) a2 ]1 j2 ?( l# W/ f! s7 p7 k6 t'{$ElementUpgrade}', '{$ItemPierce}');");
3 `" B4 f. V& _! H; t}1 f$ \7 C9 W$ L
4 X% p5 d$ P( }* h9 t
}( `) [. j+ i" T7 N9 h
5 D: Q1 U+ b" \6 g' l}; P2 d# a9 o, m! O
; z+ ^- _% ^1 h6 e$ k3 y1 i) y3 E$InitForm = InitForm();( v5 }8 ]/ B; v9 z9 r
$Listener = PostListener();9 I4 I6 a! D+ g" \
: Q' |- V) G' ?; k% v
?>: x' }7 g: k1 \) E' i; v4 J
' q2 s( H( R R6 z0 P
) w/ o$ d' |2 t8 H# L8 N
6 G7 e, I0 A, P; E# c
% N; P2 m' t: _) _: e `! L) ` |
|