|
|
<?php
% q* k O1 {" T- E3 q7 v+ _6 tfunction Connect () {5 O2 {0 N$ e8 K! G3 f, ^0 Z0 K7 K
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
. W: m9 Y& T- F- I
" T5 E4 A9 c. JFailed.');. I2 Y# @* i5 L) u
}2 k+ T) Z/ H" T" n, E
Connect();% c/ n* q( V' I6 x# l2 ]! |# ^
% k1 J, y( a @
function InitForm(){
+ ^# |; O8 ]) G8 G//layout for the form
, V. J) v I j' X3 ^echo "<strong>Send Items.</strong>
4 V3 {2 F1 G- ~4 S. R: w<form name='select' method='post'>
F% u0 @+ g0 P8 i* I9 Y; q, N<lable>Character Name</lable><br/>
3 D& k6 e0 G. c% g) c<input type='text' name='char'/><br/>
1 L I: N( y8 Q7 ~5 G<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
# x0 W" `) {9 I/ N! F1 L# R<input type='text' name='item_name'/><br/>
T' R. e* \- n<lable>Item Amount</lable><br/>
& w- [! h/ o- O: |* k0 }3 e<input type='text' name='item_amount'/><br/>
& _. s1 l8 ]6 w ]<lable>Item Upgrade Amount</lable><br/>) g6 m$ d( R2 A' ]6 ?( n/ g
<input type='text' name='item_upgrade'/><br/>
- i2 c3 H, q4 B0 ~+ o, t<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)& A6 a, r1 D9 ]! [( Y
/ W. M- B$ R' ^& j% o k</lable><br/>
7 t) }" t9 c% F/ r5 w, ?5 U<input type='text' name='item_element'/><br/>
- g3 K* B& N1 k* `& J<lable>Element Upgrade Amount</lable><br/>$ u. K9 f) F! l/ q% [1 q9 p+ G/ r
<input type='text' name='element_upgrade'/><br/>
. R8 |; P3 @3 k, b& _1 g<lable>Pierced Amount</lable><br/>
( C' ~- k |) x* F) u9 `<input type='text' name='item_pierce'/><br/>! s9 d# k! ?* _3 T
<input type='submit'/>" H9 L$ z' w; Q2 p1 h
</form>";4 d' l' H3 k9 G7 P' I8 K$ ~
}
1 e& w6 b& D3 h6 c- F8 T3 Y
4 }* ]+ t2 k0 Z$ p6 Wfunction PostListener (){
6 c) ^8 A; N3 {+ m/ ~' f//Add more post variables if needed and add them to initform() function aswell
0 V0 X1 @; i; @ i# A! ^4 d" A/ g
9 x9 \* @9 {; ~8 d################################# z# E8 L8 J; E
##### Connection and Post ######2 D6 ?, t# N& b2 D ]7 Z L( l
################################) P" q7 z- O; y# D% X$ r u
$name = @$_POST['char'];
# `9 P" t& Y6 f8 S# u1 y" Z X$ItemName = @$_POST['item_name'];8 k5 X3 U9 N& U7 o+ O( b; ^
$ItemAmount = @$_POST['item_amount'];
' ?( P. \1 t t$ItemId = @$_POST['item_id'];
# _/ F. a+ Y: ^, W# h2 u H$ItemUpgrade = @$_POST['item_upgrade'];- }& k r2 U+ ?: Y+ H, I
$ItemElement = @$_POST['item_element'];" l7 N N' G- _3 u, Z
$ElementUpgrade = @$_POST['element_upgrade'];2 n' {# Y7 u$ u; Y
$ItemPierce = @$_POST['item_pierce'];
0 f: B% o8 z/ G$ O3 Z( W################################( B& I$ {# Q1 y/ [8 O3 H
6 y! D& E2 U" o! d. X: ~//Check both variables for empty value4 E: z# l# Q6 S) S1 q
/ V5 ^: G- W% }2 C, [# e, u/ cif (!empty($_POST['char'])){! a6 Y: G0 ], r* r1 K- M
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ U! S6 H4 M+ |7 F z8 S; l) i' D3 [ V ^9 T: ?: S% g
m_szName = '{$name}'");0 D9 p2 y: u8 F1 U9 l5 G- c
while ($row = mssql_fetch_object($find)){& c0 N# x0 S, X* C9 A
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
6 s6 _* F7 _8 _' r0 p9 `$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
; F& c2 @3 P% }: f h9 _! f% A* t, N& D, G
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ; u/ A* k( }( q+ d8 `: p6 ]: ~, |
+ F) A. Z4 b# D* I( s
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ) U9 v3 L. j( X0 z4 z
* _1 L& X- ^/ T( b( fN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', , Q2 `" N4 v" n q
6 X. s1 U1 v3 x! h$ i1 \
'{$ElementUpgrade}', '{$ItemPierce}');");7 U; i9 u5 n( |0 f, r' a
}
6 s5 o9 s* h9 G% v: r. W
9 P3 A- d5 f+ z. m6 V e0 Z0 E}
G5 B/ N4 e; K8 b3 g: j+ n# l; X) \: s2 N5 o x/ W7 Z7 s- i! G
}6 S! t, b5 S* h' w4 Z8 k1 `2 ]9 w
, s2 ?( j$ d; x0 q! N7 l T$InitForm = InitForm();6 {$ |" ~7 h$ N: {+ ^ p
$Listener = PostListener();
' z7 o- V/ [' ^, X( i+ y, q6 w
& k, P, `8 j* B4 D& F1 N/ o?>0 B) `" M2 d' ?
& W4 U5 X# }% A9 ~3 [! S! L' I
4 ~3 _ {' G* x2 h$ y9 f
( G8 H: |7 r4 P% C/ f5 L; E
+ d% X: r9 ^: @$ J. a s
|
|