|
|
<?php
8 T4 F6 E. i6 f6 z t2 a3 Sfunction Connect () {$ M, W/ _* x* V0 U
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB ) p' }3 y0 |5 g
. q8 h# o( u* ^8 C( \$ Y \: }. b# @Failed.');
% g2 g9 N$ K& L}
" A3 I& V V3 l- `: JConnect();, x4 K: N" i1 V6 n5 H: x
$ m0 `7 G5 H% G0 [4 Efunction InitForm(){
0 l9 X: Q+ y [0 N" ]) I//layout for the form# K3 ]1 N% O' y
echo "<strong>Send Items.</strong>9 w, `$ ?; s7 Y3 p) k. ~. `3 N
<form name='select' method='post'>" K( n! N- U( O- X+ Q; [
<lable>Character Name</lable><br/># a& S% I# u% c/ a6 l2 c
<input type='text' name='char'/><br/>' ~( @' C& Y7 f* D: `" M. f9 A* s) q
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
) h; u& R3 k( ~$ G% E; O6 W<input type='text' name='item_name'/><br/>
1 m4 Y4 C8 [' `, }% s+ h<lable>Item Amount</lable><br/>
8 |3 s5 g! L- _ m<input type='text' name='item_amount'/><br/>
6 x4 z5 p; c0 q% W5 k6 v" H& P( B<lable>Item Upgrade Amount</lable><br/>6 r! {, b% z- k7 e% M' B
<input type='text' name='item_upgrade'/><br/>; Q! d# V! W3 E% o! p
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
. {5 @4 R3 V2 L. ]( ]* r7 B
0 M: A- T/ _# I' S</lable><br/>
: V( z1 C% p3 ], i+ \<input type='text' name='item_element'/><br/>4 s" W! r5 f3 d" ~9 y* [9 [
<lable>Element Upgrade Amount</lable><br/>
: P4 P. B" M; v: X2 x, ~* d+ F<input type='text' name='element_upgrade'/><br/>
+ ^, V. T2 U+ D- C% ^( M8 P<lable>Pierced Amount</lable><br/>
2 P2 O+ e; D2 t" Q! t! _<input type='text' name='item_pierce'/><br/>' W0 A/ A7 J) E
<input type='submit'/>
# k% a5 U" h9 x: ?2 l</form>";1 s8 s3 @+ g2 ^& f
}$ f9 U7 i! a5 n$ u d* b7 L* h
+ b3 G; X3 s1 E) ^1 v' c4 [function PostListener (){ l, J3 U3 F: G: |" H
//Add more post variables if needed and add them to initform() function aswell8 h2 {4 z* Q+ w2 l/ c% C9 T
$ v6 x U" N, f
################################1 L% X# X3 A8 U [! U
##### Connection and Post ######
2 U# T" U4 V6 \! K8 p; @. R################################
& @5 L! X" H+ o5 {7 Q! I; n$name = @$_POST['char'];
6 R. L: [0 {" |8 |, y9 W% J$ItemName = @$_POST['item_name'];/ g' h1 w3 x# q
$ItemAmount = @$_POST['item_amount'];
4 H8 |1 M, Q5 S o2 @% l- F; m2 G$ItemId = @$_POST['item_id'];/ a3 \- S$ p8 N5 f, A! N! J
$ItemUpgrade = @$_POST['item_upgrade'];
& e2 e0 A1 G; h) a$ F7 P7 K$ItemElement = @$_POST['item_element'];
, ]- L( k" {* }# \% f$ElementUpgrade = @$_POST['element_upgrade'];/ n) k- i" [! ~7 o, g0 N9 \) a
$ItemPierce = @$_POST['item_pierce'];
/ X: K; `, u2 X' I) ` X################################
7 a' V3 j0 p) e6 b x7 ]
* L H6 A/ y( L; s0 A- E. d//Check both variables for empty value
4 k5 E9 ^$ ]' N$ z2 ~ V9 o& A O; [- X
if (!empty($_POST['char'])){
6 A5 f" V3 _: c r g/ Q, f7 I* p& [$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where + h7 D; Z2 w0 k6 T O
+ B% j3 ~- [" b. @: u; X* vm_szName = '{$name}'");
) R; n/ Y7 A n: c" @while ($row = mssql_fetch_object($find)){$ W- t2 I9 c& S2 [# E# k' f* B6 f
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
% V5 z r1 ?, f& f) A$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 5 Z9 W8 R4 {# Y3 H1 Z1 B3 L0 `
5 [9 R! c* U0 [5 o# d+ n) C$ I
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
+ i* `2 t. {7 W5 i/ J
1 F. J' u# I$ Z; u3 [$ @[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', + t) V- ?0 D2 r; t: S/ K3 b
( @( \: w+ h4 z4 `3 zN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 2 d/ }- E$ l2 m, b0 y9 }' w
, T& y/ {9 K3 D* l' o! l' G! R'{$ElementUpgrade}', '{$ItemPierce}');");
7 j2 R# _/ v' F6 r& \6 S} r; H/ ?; n( K! Y$ p
5 A9 S( R1 |/ }0 ~4 \5 G}
3 i6 N& f* ~* [* k0 v, f% ^7 h
$ z& K- r2 o0 F}3 }$ N( u5 D* V
2 s# G$ [4 {2 Z6 ?* |$InitForm = InitForm();
' m$ c. i3 w5 P( |: ]$Listener = PostListener();' ]# v5 b0 T2 v0 g
3 i3 b- z# r' V; z4 S$ u& F5 ^9 P
?>
: }' c2 C' O3 m: m- |: _1 [+ N- A# d, h4 R8 A9 _; ]$ k" \
: y; J5 E0 a+ a: v6 X
! p. J( V4 S1 ?% f F
/ v& X& r0 h) f1 ]. h/ d' G1 e* y |
|