|
<?php
) V9 B0 u2 W* y! j3 U1 nfunction Connect () {6 f7 S" [) a& [
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB % g* Z4 D3 c* K1 S8 y9 Y; K) O
7 h+ { ?% @$ m2 b/ e% C# W) [Failed.');+ M; ?! N3 i$ I) |( u2 R4 _6 Y
}
3 b Y4 C! q$ m A6 S, O- I/ }Connect();
- y8 O; p. R1 K/ J$ s0 g( B. `/ S4 x
function InitForm(){
( N d1 ^& k$ v//layout for the form, S' L/ v$ ?" C) M
echo "<strong>Send Items.</strong>+ j, m8 K/ ~9 v+ Z: f: Z% m9 y
<form name='select' method='post'>3 F4 P2 `7 s) P) ?+ b% |' [
<lable>Character Name</lable><br/>
# t; ]- L# i! x D4 N<input type='text' name='char'/><br/>! ]( m- w z& _
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
% {: O8 a" |$ g! ?$ L+ D<input type='text' name='item_name'/><br/>* F- a) [8 J; Z# l4 Z
<lable>Item Amount</lable><br/>' \6 B. J8 y* [3 C) j( r5 z! ?7 x
<input type='text' name='item_amount'/><br/>
- k/ x0 `4 o/ \" W<lable>Item Upgrade Amount</lable><br/>" _+ f; s# K6 o9 T% l6 b/ @/ Y. R
<input type='text' name='item_upgrade'/><br/>' k( ~4 B, r/ S0 {/ h) x% b
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.) O G; t3 y3 a: \1 b7 x2 }
2 V+ s2 ~" _' J" i</lable><br/>
) m4 h: u H' ]4 q9 I. ?<input type='text' name='item_element'/><br/>- t$ e% r5 B- H; n; ?0 m5 s
<lable>Element Upgrade Amount</lable><br/>6 ^9 S1 c' q8 x6 C' `) T `
<input type='text' name='element_upgrade'/><br/>
9 {6 e9 }& N( F+ K, [<lable>Pierced Amount</lable><br/>
% b3 R1 O2 c& w0 z<input type='text' name='item_pierce'/><br/># P/ k: V4 e! ?, W& E9 V$ x
<input type='submit'/>
0 U3 n: s* G- ~" G9 m9 F</form>";. p8 T/ @* v H4 k0 d! X
}! H6 e1 j* ?, [. T0 M
% T- H& }" [! u9 Y
function PostListener (){ n2 z& H1 L t, {
//Add more post variables if needed and add them to initform() function aswell/ {- I8 E8 [' i+ u0 s8 R+ g: ~ b& n
- d$ o+ n: o; p' f
################################
7 q1 ~. s3 d( {* ^3 \##### Connection and Post ######. n+ R1 ^( ~4 R3 Y n, T
################################# f7 B/ a9 n7 \$ j$ F
$name = @$_POST['char'];
7 I; k! L& U! k' G$ItemName = @$_POST['item_name'];
8 {9 L6 {4 V' L9 m$ M$ Z$ItemAmount = @$_POST['item_amount'];4 _+ g1 v" h+ Z6 F) \6 F: N' U
$ItemId = @$_POST['item_id'];7 M& e2 z5 F& w9 M8 n7 O
$ItemUpgrade = @$_POST['item_upgrade'];
0 Z& l8 p4 K. d0 C7 B$ItemElement = @$_POST['item_element'];
; T, {. M: [+ I7 Y0 Y8 }$ElementUpgrade = @$_POST['element_upgrade'];+ _) a& s3 ^4 H7 z3 G" `) i y
$ItemPierce = @$_POST['item_pierce'];; O) G: I8 C3 }% G( f" _* n
################################7 D; w3 p* K& `2 t( W# }/ X* T
6 F* H" O! X$ e+ J* ^1 a* I
//Check both variables for empty value
; i/ K7 U+ [; K" @5 s0 [0 {) v0 v0 S. i
if (!empty($_POST['char'])){
& D2 a/ `0 V% f& X# l$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ' M t* N+ X! ^ M8 ]' t. v, n3 H
$ T8 E3 R+ Q: Q. k6 C0 y/ a/ |
m_szName = '{$name}'");
( r4 M) C" F* R, u- Y) w+ Iwhile ($row = mssql_fetch_object($find)){0 [! ]9 n4 Y" T! D
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
( v0 r* ~) [ g5 t- e+ x; L$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], $ B6 T. }* U, }/ k$ P' H( q/ G, h
* ~+ v g- y$ ]1 d D( i6 ][serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], " `! r# q$ ^& A; \0 _7 E- a5 h
) Y" |" \7 d) |$ u4 o+ k6 s0 t[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', % K% M, r! ?% b5 z7 Q! u
* ~- E" n! t) y* I4 HN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
5 L4 \3 r% z, M- U
5 m& a, a$ B/ J0 C/ n2 ]'{$ElementUpgrade}', '{$ItemPierce}');");- C1 ^0 a% B- z' ~4 i
}
; m, |; @2 A& O4 }, T0 a0 V& v6 t9 ~. A8 ?
}
?$ ~) _ R+ i- K) q4 o2 E
. w# s% ^9 Q, h. l: w |; Z}% \0 H$ V3 \6 q9 h
( ]* M: k' C$ [1 M
$InitForm = InitForm();% r) D4 g. O3 a3 k8 I0 ?, y# f B! p
$Listener = PostListener();, w' w# f w! H3 f" @
. Y; U. y+ P b0 h$ r4 d' V& h
?>
8 e& R' \ J, {- Q. }2 S
/ D# H" X9 D$ l5 J4 }0 ^% e1 Q, J8 E; _; m K7 ~$ W
2 z' s$ {5 v3 i' _) A7 h+ {8 ^
4 V. h! m' u( `/ C& J) V |
|