|
|
<?php
6 L' E5 {( y/ r% O1 K) N. [9 T% a% kfunction Connect () {. }, \* G$ b9 v9 S e
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB ) V& B' S% M& e; v+ d" t
: f, |- l6 Y. t# ]3 v9 ]5 U" mFailed.');
7 w- u) D$ n/ J/ I _6 r' [, V}, M% F- \: W+ F' F
Connect();
+ Z: F" v# t1 P
4 D$ J+ ]8 o" B2 E9 qfunction InitForm(){
- Q: z& Z1 W8 {( ?7 S, v5 e//layout for the form
: ]3 H+ K8 l) y) |! {$ Oecho "<strong>Send Items.</strong>
# |5 z* Y- D$ u; j" w5 |* Q<form name='select' method='post'>* o5 u: G! v Y' S
<lable>Character Name</lable><br/>
2 t' G ~- O J |# Y, w3 z<input type='text' name='char'/><br/>
1 }$ q5 M( I% u; V; P8 R<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
& j/ M: G4 z/ }. v, E<input type='text' name='item_name'/><br/>$ z- e9 ^5 q% J( b
<lable>Item Amount</lable><br/>1 o: h( Y. ]1 J# W! D- O' g$ A' H
<input type='text' name='item_amount'/><br/>
% P- s! e9 b) b7 v3 O$ L+ Q<lable>Item Upgrade Amount</lable><br/>
7 H1 p; Y3 E. i( V% G! Y<input type='text' name='item_upgrade'/><br/>! Q% r/ N7 Q+ `* n( L" {! C) v) w
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)& _ y' F* p. @$ d5 m' C: M) d
4 k# e3 w6 D4 r- A- S$ C</lable><br/>
* L- B; u% p8 s, R8 K# u<input type='text' name='item_element'/><br/>
3 L" J& M7 G* F0 o/ q<lable>Element Upgrade Amount</lable><br/>6 o0 l6 u( U" N! {9 O: c' P K
<input type='text' name='element_upgrade'/><br/>+ m5 J( L0 |9 g" \1 s1 W5 t
<lable>Pierced Amount</lable><br/>
8 D! q: C7 h {+ w. Y<input type='text' name='item_pierce'/><br/>7 l8 n3 S3 v- B
<input type='submit'/>
# i5 \; P- n, q</form>";
# L/ o) [" V, g& {/ E0 q}! L/ X( b g% ~/ O" D
$ d4 ?. B4 k1 [function PostListener (){' _: t# O) V. ?8 S
//Add more post variables if needed and add them to initform() function aswell
0 J3 G1 a% W1 Y8 u: g
0 s$ f2 C' ]8 G" Z5 P################################
% @6 c5 @( H3 `' o##### Connection and Post ######
) t7 j6 G" r- t6 e. O' G################################
* r6 F) O0 U" G' o& a* t$name = @$_POST['char'];
7 Q9 `( K6 L' j+ ^8 E* l; z$ItemName = @$_POST['item_name'];
: @; L& f5 z0 A/ k* V# W# |: `7 t$ItemAmount = @$_POST['item_amount'];
) Q0 B5 Y' A7 h! q8 ~$ItemId = @$_POST['item_id'];
; @) V/ ~3 C2 t$ N$ItemUpgrade = @$_POST['item_upgrade'];
" f, R, d- o- d$ItemElement = @$_POST['item_element'];1 Y e4 q1 d% h% T
$ElementUpgrade = @$_POST['element_upgrade'];
( ]$ T" V8 y* U1 I! i" C! o1 Z$ItemPierce = @$_POST['item_pierce'];
- a4 x2 V* B' D, I' y################################
' i; H6 n$ x7 U" ]. D. h6 h& m( I
) }) `/ U4 N: L1 C3 `//Check both variables for empty value
8 X! w6 n" ~/ W0 \8 t0 N0 Q8 k; b( l7 {( ]: r# A
if (!empty($_POST['char'])){
+ x y& r+ q6 a! l) l5 P$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 9 b4 |7 p, c- O' _ c
! K, X6 u2 ^" [* a
m_szName = '{$name}'");9 E: }4 d0 o5 O8 `4 d# W+ D/ o
while ($row = mssql_fetch_object($find)){* q" W% V# y" m z: ~
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";2 O1 V3 ~. P6 `" ?0 q! K& _: C l
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
/ B. i. Y# {& E/ K
; C* b. u0 E2 P6 G! \[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], / F3 F2 p9 Q+ w9 Y4 W% G0 A3 d; U
2 |8 u" r9 G K/ U. v[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 9 \- {9 j& U/ H
2 P/ f s0 H# A
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
8 k# f; |; R3 _5 M5 a1 @. U( T
& y8 S* s6 X2 T9 @' D'{$ElementUpgrade}', '{$ItemPierce}');");
& o1 M* l% f5 X}0 w! s& u& e' e2 e
9 o) B% G' J& @9 w- u
}
+ q9 v1 W! D8 r0 T9 y$ l9 x$ B' m( ` J8 u {; p0 R
}- r% E+ n4 F4 ^( Y. C
3 s: x' |, x. F: J ^: x" c$InitForm = InitForm();( m( e6 I; J4 r1 I
$Listener = PostListener();$ B9 }: u7 S2 u" e! Z, S2 h
8 O2 A' ?( w" E! `- E! v* d% L?># o5 }) n) z: T# Q6 P
+ y: K* U# [! b+ U$ w
' z+ P s$ q# {6 W1 z
6 o' Z/ F2 K, c: N- \ R# d; B0 X
* G/ _4 g! a9 l4 t( P3 z0 p4 T+ o. C) s |
|