|
|
<?php
' Y. v3 |; G4 Hfunction Connect () {
- P. ~+ N+ l* W8 Gmssql_connect('Server','UserName','Password') or die('Error: Connection to DB ! \: n. p! V w8 ]5 t p A- P' D+ a
; O" \% I+ T. B' q
Failed.');/ ?" U" B6 c, n/ v
}
. ~. l* Z' Q. iConnect();
6 a+ ^5 Q7 L5 t8 s) H' [1 ~+ n! e, I
function InitForm(){
* H1 x2 ^' U4 i//layout for the form
) U- ?" j2 l4 w5 Becho "<strong>Send Items.</strong>. _6 Q& L: W0 X6 T
<form name='select' method='post'>
( Y; k! {- | ?2 Z M' K- K<lable>Character Name</lable><br/>" q/ t2 O1 N5 |# \, D+ c5 `% H+ Q
<input type='text' name='char'/><br/>4 K) r- @2 c( `: o) u
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
% h9 @- I+ c7 x9 L( q<input type='text' name='item_name'/><br/>: {1 ]5 u: |- k" M6 p; c$ L
<lable>Item Amount</lable><br/>
: z5 c4 X# T/ Z3 p, g<input type='text' name='item_amount'/><br/>1 r+ z: X" |" P1 v1 H: p8 P
<lable>Item Upgrade Amount</lable><br/>. t2 c6 {9 Y! d4 a" U
<input type='text' name='item_upgrade'/><br/>2 o( H3 `4 p, M) B O2 e1 }
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; _! [5 D" `! m0 n9 W$ {* W) [' h
9 a' Q, _ S: Y! M o. I</lable><br/>3 c0 ~# b; J2 |6 Q6 [5 O$ y
<input type='text' name='item_element'/><br/>$ Z+ F/ _8 f* J4 l0 Z. U" K x* V. K
<lable>Element Upgrade Amount</lable><br/>2 {& [" u# e. R$ f/ R/ d v v2 I
<input type='text' name='element_upgrade'/><br/>
0 |( v4 x& J ^; {, E. C' N1 `; H" V<lable>Pierced Amount</lable><br/>4 N J' t- \+ d7 @( ]: j
<input type='text' name='item_pierce'/><br/>
, K- l5 {! P n. {<input type='submit'/>+ f' q% ^8 g. A) F
</form>";' L, y4 Q4 ]) D/ d1 J/ R
}2 _4 O* ?( @+ a& ~4 P
3 U0 Y+ Q/ @7 I' Z; h' C: O( `) ]$ Vfunction PostListener (){
" O/ v U$ n- n# _; I: Z i( H//Add more post variables if needed and add them to initform() function aswell- c/ k8 P: Z$ U+ z9 O3 r9 [
! h, s! E& O! I
################################
) f$ |% ~. g4 W4 t. X+ b6 I##### Connection and Post ######. e; [3 S2 h; R5 e( q9 J
################################4 N0 F# |& r9 F7 y7 e# N8 R8 U
$name = @$_POST['char'];
- h! T! Q4 `3 v H8 J4 f5 P$ItemName = @$_POST['item_name'];
) Z1 i/ D: U! R$ D* c$ItemAmount = @$_POST['item_amount'];! y! P6 B {3 C, d
$ItemId = @$_POST['item_id'];' p# _: B- ~, @. W" e
$ItemUpgrade = @$_POST['item_upgrade'];
) b, [% _' L6 E4 k$ItemElement = @$_POST['item_element'];) J* N$ J3 d4 }" _4 g' ~
$ElementUpgrade = @$_POST['element_upgrade'];
6 U/ i9 j& N2 E, |) ^' M2 }* j H$ItemPierce = @$_POST['item_pierce'];1 D3 S4 }4 r9 w! |' m4 I' w. n4 N
################################
& c# V. l) H1 U& E+ c% l% _0 l1 [; D0 a
//Check both variables for empty value' L5 P" @ i# ?( s1 [* E2 h1 h
( G2 s2 L/ c5 W/ Uif (!empty($_POST['char'])){' b' h i: m7 Q3 c6 |+ A
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
" A1 {2 A( A: F3 C1 S5 z! R' g& ]2 _' T4 l' s9 F/ W7 b
m_szName = '{$name}'");0 c- j9 b$ ?: Q! X3 w- z: G. d7 [
while ($row = mssql_fetch_object($find)){& o% {4 K& v% g( V& P
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
% B8 J$ y% M6 J0 W8 }+ ~$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ' l# K- z; K! U( P4 k; s% j$ S
% I3 m* ?: i* I
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], : s4 V: l+ h3 L. i: e" k- ?( m
$ W& `2 ?8 G% i[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', # J+ s. X0 u- v) {3 y B6 @; M
- y8 ~: C! d0 b5 ?! eN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
, Q& c1 r1 N# P( O7 A2 I, ^; M$ m" D6 B3 {' k$ Q( C* J; i8 p8 F
'{$ElementUpgrade}', '{$ItemPierce}');");* X" e% A# `9 N4 _) d8 d
}
* p( F$ H) i7 i2 o T
2 F. D3 S# ]9 |- H4 P}
( b6 S# w1 y. h4 i* c+ ^0 @2 Z+ G E2 Y5 U
}
' t a0 G( t8 [5 x! b/ |, O) z
/ G2 C* p6 X! h7 @$InitForm = InitForm();
* ~: Z8 u1 V! g$ t$Listener = PostListener();7 \: G- l5 w& Q2 K$ x# ^9 E
1 e m6 y# p; z# I; x1 L- S3 u% C?>0 B. s$ f6 J1 ?; ?& G, P
6 a* H* }4 }9 r
% Q9 ?# X) V# d4 a6 K& S- g G3 c% j- P$ w, E6 e2 u
+ ]: R+ _: R& s |
|