|
|
<?php3 G0 E. I) d5 j- x& n) ^5 \
function Connect () {- }6 Z. _8 R& M" X, h) E& q
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB ( U' R. r _1 m. I! x) _3 ?
3 o0 `7 X4 e9 F# P+ zFailed.');2 E/ x- o+ A/ y4 ^( p
}! Q/ C/ ]% \1 x
Connect();
$ ?; O+ N3 m# z, B
$ C% H A$ [5 ofunction InitForm(){, p5 d8 D% w/ F0 ~; \ I
//layout for the form
7 z' N2 c) c% O) w( E* Z$ N$ Pecho "<strong>Send Items.</strong>
& `, o7 f0 |1 K4 M<form name='select' method='post'>5 L. `: W% j: ~* w3 J
<lable>Character Name</lable><br/>
4 @( T6 W' r7 O" K8 T+ {<input type='text' name='char'/><br/># q) t& X7 K s
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
( x5 n4 c ~ S7 ^% P<input type='text' name='item_name'/><br/>
7 t" g& F7 l0 t: A$ e<lable>Item Amount</lable><br/>( P9 Z/ y9 I- p. A/ E
<input type='text' name='item_amount'/><br/>
1 [# o' `7 ?- s4 `<lable>Item Upgrade Amount</lable><br/>5 b$ Y) q( E7 J8 o, w( |5 {
<input type='text' name='item_upgrade'/><br/>" ~" z9 K$ i/ t+ R0 ^0 Y# u
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.); T& p {" F; M" l
~7 q& T/ L5 n+ [
</lable><br/>' F/ P* w# b* K0 W: \( c, t
<input type='text' name='item_element'/><br/>
/ p6 {0 x0 H% T7 X) e3 |/ Y) t+ O<lable>Element Upgrade Amount</lable><br/> Z9 }7 W) k- | n. i# ~0 H4 O; h- R; E2 W
<input type='text' name='element_upgrade'/><br/>! L/ m0 ?( ]* c' T" `- G! @ C
<lable>Pierced Amount</lable><br/>
3 T: f! _( v0 q9 z6 h) M" g8 B<input type='text' name='item_pierce'/><br/>
d) g0 D) X7 _! u3 l5 \' u<input type='submit'/>$ }4 P0 t% ^$ f
</form>";' x5 w2 ]7 l4 p" h" Y6 g
}
5 b2 k: Y! p! V+ d& v' P# x$ _% R" y
function PostListener (){" {+ { l; R" C/ I5 i) A# k/ ]
//Add more post variables if needed and add them to initform() function aswell3 R8 p1 K2 I6 l0 c! y
- _! j6 j7 W- m, G################################
, ?1 g8 B* h$ k' z4 M##### Connection and Post ####### b8 i, W. v" h
################################
! e9 S# |) F, s' R% g8 j3 d/ R$name = @$_POST['char'];
* [( P& {' }# ]4 P; N, ~7 W$ItemName = @$_POST['item_name'];3 P* F* {' s: V
$ItemAmount = @$_POST['item_amount'];3 a' ]5 _, M6 I
$ItemId = @$_POST['item_id'];
2 O; T6 B) u! c9 W/ h) T1 x4 E. b$ItemUpgrade = @$_POST['item_upgrade'];
( N7 l6 C5 @5 d# i+ j, T$ItemElement = @$_POST['item_element'];
, R! o9 f* V3 |7 k1 e* x* C$ElementUpgrade = @$_POST['element_upgrade'];% Z/ X4 ~7 a& U: }# F% v
$ItemPierce = @$_POST['item_pierce'];0 ^3 f) E% r) [
################################6 ] G8 m" ?- F% x
2 B( \$ S& S: P4 L( u
//Check both variables for empty value
# d6 S% `' L- |$ ?( R |3 |5 o& U6 X
if (!empty($_POST['char'])){
; l7 | D0 D7 J$ z. N$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ( `; ?* P" }4 n ^8 x
: T. Z3 h) A/ z5 Um_szName = '{$name}'");" j& B' I; y% l& e
while ($row = mssql_fetch_object($find)){
/ k9 g: S$ c7 U$ M6 F1 Uecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ a: A* J* s* v8 e3 V$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ; z, L! u' Z1 d3 V" A( H
6 v6 @& S; r& e* {. d9 I
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ; S9 o/ ^9 l2 T6 b9 y" w
5 a# q* C/ Q' s5 @$ o; o1 S[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 1 p0 U% x5 T, k9 P% Z
* H9 k, X$ T6 v+ c' ~
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
; n6 F: e* }2 g9 w+ s3 m1 U* Q. {; L+ {5 Z
'{$ElementUpgrade}', '{$ItemPierce}');");: T8 ]0 i: | t# D3 W9 B# O. \4 Z
}
% N: S% z4 l' f6 E4 N
0 b) D$ F+ c* V7 K5 z, }}" t1 b5 m) f0 G' ?
6 X% k+ |0 N+ Y1 \$ S" d1 Y5 B; r
}5 ~. i5 r6 u) d2 u% l
, g) {. z; y6 H/ b0 q# q
$InitForm = InitForm();
% \9 r, B; I- X& b. H, C$Listener = PostListener();) I, p: R7 [; p; W- w6 }4 u
4 C7 z6 j- n$ [& A8 x
?>2 I$ P9 q, b4 K: i* v$ o2 J* \9 O
% H$ ]6 g& [) D: v! W. C, V9 I# ] `
; }8 T$ D, b2 H4 ^' L: \4 Z
0 b7 m2 @: W- v6 C; |
|
|