|
|
<?php
) b; p: j& w* Z" ?9 \, o3 _/ ?function Connect () {
! T- M0 Y7 T4 O" C6 Hmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 6 K/ p# H% j, d: m
& h3 A$ n% y$ c5 L' R% h" ?) B3 I
Failed.');
: L9 r8 m6 t! q) J, p, |" }}) K5 ^( {* E: G5 l, {0 |4 Y2 X
Connect();
2 _, O+ Z- k" j F( [9 i* U$ b2 B, N) c0 {+ c
function InitForm(){
3 L7 Q' H/ |# S6 _- s//layout for the form9 o' p. ~( z8 S1 ?& e1 }
echo "<strong>Send Items.</strong>; `4 u% \% p8 c) [8 M
<form name='select' method='post'>/ M+ ^4 S; T, O" t. A" E& { ]. Q
<lable>Character Name</lable><br/>
# x8 I% i* ^* U<input type='text' name='char'/><br/>
3 O* j4 l, Y" B9 A- a! M: ^' d<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>6 P1 m( I: |/ B1 z0 p8 }# [
<input type='text' name='item_name'/><br/>
& H5 N2 g0 P3 ^. P# x9 j L2 ^$ ~* _/ x<lable>Item Amount</lable><br/>4 x$ T; ~, ~* f8 Z7 ]& \
<input type='text' name='item_amount'/><br/>- t0 H/ L4 E& Z4 n* e
<lable>Item Upgrade Amount</lable><br/>
2 R" u Z* C) ^9 D<input type='text' name='item_upgrade'/><br/>
# N# s U5 p: w, C, I7 F! g<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
0 F/ n2 A6 h$ z& v# J
0 U) ]% M0 J, W% b+ P</lable><br/>
W6 A# A& }9 r3 i- M4 @; S<input type='text' name='item_element'/><br/>9 c- Z% f1 T" K$ ^5 E1 _
<lable>Element Upgrade Amount</lable><br/>
6 M# i/ a+ a" w8 \7 r4 N/ V& R) w<input type='text' name='element_upgrade'/><br/>
' Q' @6 P7 |4 C+ d# E! l<lable>Pierced Amount</lable><br/>" _* v1 V( T; x0 k& h
<input type='text' name='item_pierce'/><br/>
1 G2 Z; \: {7 A+ _4 j3 d9 R* \" v- j<input type='submit'/>) O t8 H; N2 @* p7 U9 N/ G
</form>";1 Z) u. k, e0 J" p
}* ?* {& f7 ]& n" f& |$ u
) X* A. E& T( Q" w: Q5 Lfunction PostListener (){3 M2 F5 F6 ^3 z1 r; l, r% d
//Add more post variables if needed and add them to initform() function aswell
4 M( I A. v. t8 E2 _5 Y8 H- Z+ j, l; x3 K0 k
################################6 p) s' ^1 o) y) u. P/ \
##### Connection and Post ######0 x% J( H& F- [' _& @2 d
################################, T0 S8 i: b8 v
$name = @$_POST['char'];3 d: M3 J. x0 g8 k* A; x
$ItemName = @$_POST['item_name'];
3 Y2 c# ~& a) G! Y; o7 L$ItemAmount = @$_POST['item_amount'];1 q* d+ a, q& z0 K; d {
$ItemId = @$_POST['item_id'];, w/ j [9 X2 \9 }1 t
$ItemUpgrade = @$_POST['item_upgrade'];, ^# `1 n9 x- N: ?
$ItemElement = @$_POST['item_element'];
* q" L: @ ?* v7 \* E$ElementUpgrade = @$_POST['element_upgrade'];# f9 l( M/ V/ X
$ItemPierce = @$_POST['item_pierce'];
, f& S3 u& r' ]0 h################################
2 g( O4 W& l& f! p) A6 Y
2 m& r9 ~/ w0 p2 [ `+ G//Check both variables for empty value0 {$ y6 W6 m* m% W+ q# W
8 D: {" Q6 M9 B! ?; e$ Cif (!empty($_POST['char'])){# e& S( A' L" X' {
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where & h7 I$ \9 X! Z
! j! W0 Y# _$ h+ w" E# l; X- rm_szName = '{$name}'");8 `# @( I# m& I) W
while ($row = mssql_fetch_object($find)){
- f; g2 U7 z6 U' P2 \' ?7 Aecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ j6 x6 C( u9 Z4 _- s: \* C$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
2 {5 Y- a+ `9 q; Z( ~4 W, D" Z3 m' f4 t
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
! G) a$ o$ x2 p+ C
7 V {% o5 y, E; \8 e3 _+ W% P1 Z[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
- r0 J' m! d Q" } |3 d
1 v' h( F6 m/ S- EN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
( I/ A2 r, H& ?! V" y1 K2 b$ P
5 O" s. j+ d$ J+ m9 G( \! g* _0 M$ k7 o'{$ElementUpgrade}', '{$ItemPierce}');");* F8 z* n3 n) g6 k) y* b; k- q
}
' D; b Z) m3 u* x
: ]6 y1 e6 F& g+ @8 {/ m}
# H5 V8 G; h% M% s7 ]2 h" U9 N v/ ] p; m4 l3 A
}
+ P& ^6 k! m6 o: q6 c- _( X* N
/ h3 i: B( x2 d1 ~/ h$InitForm = InitForm();
( k( F2 F. w: u0 T: p" L# p+ z+ E$Listener = PostListener();$ J* J( Y- `' Y
# H6 R) g5 E# w( r: y k& C?>/ F d' ]3 L6 `
0 { k! }8 M; }) q9 s; L
+ \% D4 N `/ ~6 B8 K, x! w8 I
3 V% U& I4 ?, h- X9 E
( c$ [( k/ f- L0 q* P
|
|