|
|
<?php
+ d# ~9 E6 z' {9 C+ Lfunction Connect () {9 P3 @' m% r" ~- V! J1 A$ B3 v+ ?/ J
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 5 O" h! `) ]6 ^- C. H _) Q
8 S: K X5 f5 r5 K' dFailed.');: x; c# ?* f, B7 f: V
}" m7 D6 G; j6 U
Connect();: P+ A( U1 @- x( }5 P3 x$ L+ P
$ J+ h) M* q+ \, gfunction InitForm(){3 O6 T4 o$ P: {9 y m1 m& c0 Q! K7 j
//layout for the form3 \+ M$ j9 d B) h9 Y
echo "<strong>Send Items.</strong>
. Z6 o- y/ D. K3 X9 q<form name='select' method='post'>
/ m' k# A: v }, l4 w<lable>Character Name</lable><br/>% F9 N% p5 G. u( c( {1 c
<input type='text' name='char'/><br/>
, l) ]1 ^* E, l- _) _, H" P<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
+ u. u! ^' X, k" N9 u<input type='text' name='item_name'/><br/>
: t9 Q i2 l$ {. S8 \' G* ?<lable>Item Amount</lable><br/>
7 |. m2 o) [5 s0 |2 Z i7 y$ x<input type='text' name='item_amount'/><br/>. i+ N& A# X9 v. e# l% W( G' V
<lable>Item Upgrade Amount</lable><br/>
8 ?) q3 T+ e0 ~8 h: U% w<input type='text' name='item_upgrade'/><br/>
9 g' M" }0 z& F0 r5 E$ p4 T<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
) k1 }7 c, l8 }7 n# W1 \- _7 ^
7 x) {( k0 u, O4 Y3 o</lable><br/>
3 m# ^; \. T, N- R<input type='text' name='item_element'/><br/>! U2 u5 B; `' R* K8 N
<lable>Element Upgrade Amount</lable><br/>
( i' @. R% O" s4 F<input type='text' name='element_upgrade'/><br/>
/ X2 k! u) d3 r$ u1 B<lable>Pierced Amount</lable><br/>- f0 y3 O9 o1 {9 P( `
<input type='text' name='item_pierce'/><br/>
# O: c3 m4 X, r! z<input type='submit'/>
* h* [, H: p6 o# ?</form>";: E4 ]! a. z9 A2 p, I: t* Z& c6 ~
}
: f9 N7 P- `& f' n7 p% Q
# n9 D# F4 L$ F. ^, N- r/ nfunction PostListener (){7 e: Z* [! _2 u% z" d f, b% T- b
//Add more post variables if needed and add them to initform() function aswell
' E6 @" A* a1 F# j9 a
# d$ l& U! U. m( `6 c################################! O) _4 M, \4 g
##### Connection and Post ######
; `. I2 }3 L( n4 L6 u9 f################################
6 J7 _& A; J! W. I) {9 g; Q$name = @$_POST['char'];
( {) p/ O# M% ~3 H4 u, _$ItemName = @$_POST['item_name'];
1 f7 C4 a' K7 r+ b% y/ Y2 V$ItemAmount = @$_POST['item_amount'];! e3 S* b, I9 [
$ItemId = @$_POST['item_id'];
$ H' ]9 t' h m* C; x m# h& {- T$ItemUpgrade = @$_POST['item_upgrade'];, Z0 Z9 K; U/ [' b) r3 Y
$ItemElement = @$_POST['item_element'];: x( Y/ S; X3 c: M8 U
$ElementUpgrade = @$_POST['element_upgrade'];7 f- y, T: g' r$ I% ]! q& `
$ItemPierce = @$_POST['item_pierce']; y. v$ d+ `6 ~ T
################################
4 _# o& x; ?; c0 p/ I/ z
0 x5 @, N. y' y) y//Check both variables for empty value- i- h0 l+ n8 R5 T
0 @9 ~' k5 V% ^% r, D u' U" n Bif (!empty($_POST['char'])){* y, \; g7 U+ J7 B; V
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
" u _) x2 [) p8 {9 E, x$ n! p9 B8 C: P
m_szName = '{$name}'"); n" F: {9 g# f' b7 q5 l5 D
while ($row = mssql_fetch_object($find)){. C- y s' R( O" b4 e
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";( G# F9 ^" k+ H9 f5 L0 n) L8 p# |
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], * c& B2 p. V6 I2 _0 q' Z7 y
4 T7 V: M5 |/ s% P, k) f/ Y[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
; X1 U- H# \& ~
; n8 V0 w6 y9 @[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
. G0 ?1 l2 ~8 Z6 t: J
* @! j5 q& N) x' H* P7 U. x5 VN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
$ ]3 j) F7 j4 }, o8 d7 M- p }! ]2 | X, ?0 u# [+ ~: Y% V7 W/ V
'{$ElementUpgrade}', '{$ItemPierce}');");1 B% H1 l; C. V6 u' Y; q/ S5 j Y
}" ?1 z4 E+ W8 G% p; B8 b
1 a! `6 r% m1 G3 ?7 K, W2 ~
}1 [3 Y# w: J" B9 z9 Z2 f& N
) u0 v( Z. U4 O. v$ h
}
9 D2 C# H3 e3 a5 ?
. L6 K4 S3 y) i% s" ~6 O$InitForm = InitForm();
: p4 B8 ]3 I/ L, r3 A# j$Listener = PostListener();, p0 `; U: b# c* s# A( f" ~ W
6 O4 }/ Q3 L+ x
?>6 u# q% @& _, K0 J0 [; O
- j8 r) q+ P- M: V" }3 v$ n2 y* ~5 C+ v. R3 K
" E* J- s! p7 Y# ]8 h9 n0 Q0 ]3 ^4 _6 v( e2 y& X
|
|