|
|
<?php! _* i2 R, R* n' Z. M3 P6 {9 w; t
function Connect () {
% D5 y1 M# S2 Nmssql_connect('Server','UserName','Password') or die('Error: Connection to DB , g* O& l3 i( b* l
5 l" Q1 ], k3 W- Y* a
Failed.');5 W5 E" ?0 H( m) {( a0 \) [5 c
}) t" u* f0 g) t* I$ t+ y9 V" y( F
Connect();* h/ l1 Y- J1 Z. L
& W. u) d. F/ y: X) U( I
function InitForm(){
% f3 u2 | @2 k9 P$ w# _//layout for the form
5 `. ?9 d9 q1 }' q0 L0 c; [6 kecho "<strong>Send Items.</strong>
# S! U4 _, [2 I9 L6 E<form name='select' method='post'>
8 f |$ w5 C m: @<lable>Character Name</lable><br/>
/ H# R" B! o" t3 ]<input type='text' name='char'/><br/>
. j* r4 a/ A9 y+ b% B1 M7 W* [& l<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>* Z% c" F9 D* u7 c3 K
<input type='text' name='item_name'/><br/>
. Z4 j2 }' g" i3 H0 u B% q5 m7 w<lable>Item Amount</lable><br/>
$ t- z' M3 n4 u: k0 U<input type='text' name='item_amount'/><br/>' `+ v" O3 R0 \' L
<lable>Item Upgrade Amount</lable><br/>
- ^- D$ ^3 e# c) d<input type='text' name='item_upgrade'/><br/>8 Q$ c3 K* \2 G: |! W
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
L0 l$ O; }# T: ?: [( T- Z1 s, F8 f/ L. ?8 q
</lable><br/>
f3 i0 @ T, g: o<input type='text' name='item_element'/><br/>
2 E; \8 N8 `9 A+ g2 `<lable>Element Upgrade Amount</lable><br/>- W, ]* [- M/ @1 V! f& F8 H! c
<input type='text' name='element_upgrade'/><br/>
B7 t/ y0 M; M- R( `% R2 j<lable>Pierced Amount</lable><br/>) N: ^5 \* B2 w5 i9 V, o, m$ z: p+ _
<input type='text' name='item_pierce'/><br/>
1 @9 {: c! z- b" B2 R<input type='submit'/>' \5 d6 Y1 W3 Z" N
</form>";
% G$ R9 m0 q! h$ m3 Z& C0 }7 g, p}
) j8 l) m( \! ^! }2 g. m( l6 Q4 W/ o/ X+ ?4 J* F
function PostListener (){( `8 v6 ~$ k1 Z
//Add more post variables if needed and add them to initform() function aswell7 `0 W% B9 V0 O
4 i& `1 G4 |! |) r/ H
################################
* j) A) p) g) }1 P4 f##### Connection and Post ######0 r3 s& c4 T$ k* T% G
################################
8 h1 n7 D* i1 J7 [- d, n3 B$name = @$_POST['char'];
# A" H7 p- D3 z$ b! h8 S; |$ItemName = @$_POST['item_name'];1 w9 a7 O. W+ E
$ItemAmount = @$_POST['item_amount']; l; P+ {% C, b
$ItemId = @$_POST['item_id'];/ i" ]. V, J- r" c" _2 o9 Q
$ItemUpgrade = @$_POST['item_upgrade'];
`$ E; O" v$ a/ e: w; ]4 n' w$ItemElement = @$_POST['item_element'];
) a3 v" V& \, k3 y$ElementUpgrade = @$_POST['element_upgrade'];
5 a3 T& I! G0 _* v7 z; T% L6 u$ItemPierce = @$_POST['item_pierce'];
2 v# u% Y6 c: P8 l$ Z( `) b################################
1 R: K" ]$ j0 ~2 k5 d
- K! z" A% t8 @; U//Check both variables for empty value1 f a7 d% H3 R0 n9 C" d" v
, _' W" R! i7 v7 V" J, |4 Q# u
if (!empty($_POST['char'])){. m, W& k/ V5 h, d
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ; h+ V1 n w8 G- u/ Q. R V; z8 v
, h* ?6 k) s, Z- u+ ~
m_szName = '{$name}'");$ \4 |" A* s: O; S
while ($row = mssql_fetch_object($find)){
3 p5 v4 { e. Y9 {6 t! V1 aecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";+ |, o* |8 _7 ]( A
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], : c' v Y* F2 g+ p
# x$ n4 H8 n* J/ I# _
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], # g8 l- ~4 _1 @' z. ^
y2 T. g: F2 k6 X. q[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
( c: D- |) F# a" h
& j; [% a9 d% O% n' fN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
" K5 W, o' k! S. _/ k
) |! G% l" p' U2 \: V/ `; z'{$ElementUpgrade}', '{$ItemPierce}');");+ t3 b1 N: y Z h
}
/ H5 S! ]5 e5 _1 L% K5 i& ]2 `" D1 ?' }9 o
}
1 C' m7 d3 d2 l. {1 r$ @6 q; V5 }1 V6 U9 Y
}
- c0 C8 _* U% @+ a
% v7 d/ F2 l/ Y! P$InitForm = InitForm();$ S1 i+ W, T* m! E- X! h
$Listener = PostListener();( @: u) r) a0 _
. b5 z% ~ Z/ c( j$ S2 I8 e5 q
?>
' G6 W% T0 L0 ^7 X' {1 Y8 \% \; O) K [: a; t& @ E& N
- ] ]) K5 v, i9 d
# s4 G4 t- |+ }; D
* X: }* s$ R8 d* ?6 e% D6 U |
|