|
|
<?php
* r+ j! h; D. y' h, Efunction Connect () {
- F9 F9 h" l' O6 Y5 ]9 b6 Jmssql_connect('Server','UserName','Password') or die('Error: Connection to DB . v# t' D3 z& |9 o* {3 B# M/ o- |
& @4 T9 E3 G; I- A
Failed.');! i* f+ e" {- t
}
- \ p3 [1 i$ S! {5 k# OConnect();" l1 [% n% ^" @) g0 s
7 K& J$ y* q* u* x$ f* B* B* zfunction InitForm(){
* [5 a5 |; d a$ Q//layout for the form
3 m! U% M6 e Q- _echo "<strong>Send Items.</strong>
" r" G# x: A a2 J$ \$ V& j) q3 R<form name='select' method='post'>& Z8 R% R& W! b, Q
<lable>Character Name</lable><br/>
7 c A0 K5 U# x5 F1 j# q6 [<input type='text' name='char'/><br/>
* x! k5 {$ A8 N* X7 J. w3 g<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>+ ?7 `5 T F$ o0 N
<input type='text' name='item_name'/><br/> j/ W" u9 F* f d4 t
<lable>Item Amount</lable><br/>. ^8 |* G; c% S' k- U5 G
<input type='text' name='item_amount'/><br/>
! \) V4 h7 d ~& l( i1 @<lable>Item Upgrade Amount</lable><br/>
F+ a/ P) F% B$ i# i9 q' |7 g<input type='text' name='item_upgrade'/><br/>
" N& O2 L6 m! ~9 h<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
9 y* n) c6 S; T
+ g, X4 `" J) {$ @. ^3 t. U</lable><br/>4 @$ F6 C' b5 P( [) l/ Y% Z- d
<input type='text' name='item_element'/><br/>1 K- s( S/ W- n. E0 s7 x! P0 f
<lable>Element Upgrade Amount</lable><br/>
6 S) [) |3 a) L' d" Z1 [$ D<input type='text' name='element_upgrade'/><br/>
( b0 G* t, F% r<lable>Pierced Amount</lable><br/>
% Q& y; Y8 f! |; W- P, V8 F( \# b<input type='text' name='item_pierce'/><br/>5 c) X. Y7 c) @% v
<input type='submit'/>
( W3 m: z4 s7 Y3 N. ~ b( _3 B</form>";4 S; n" Z# H' r2 `, |
}
) j/ A0 R# J+ w o; y% d5 S2 K* N2 Y6 C4 ~& [8 ], y
function PostListener (){& q" B& i! y9 I" _2 s8 }4 B
//Add more post variables if needed and add them to initform() function aswell
# R& |' Q2 R$ P0 w( `. Z2 b* g$ i2 |
################################ i% @0 @0 c1 S4 x; C2 i$ ~5 u
##### Connection and Post ######
6 [& Y o# U0 @################################ A) n/ G& Y$ j* Z1 Z6 @) }
$name = @$_POST['char'];! z! t& W6 ]) d. u2 H t3 z
$ItemName = @$_POST['item_name'];
- M& o# S& }, ]! c- M$ I/ L$ItemAmount = @$_POST['item_amount'];. [& m5 ~3 F5 T
$ItemId = @$_POST['item_id'];$ Z8 P% O+ N/ h2 f
$ItemUpgrade = @$_POST['item_upgrade'];' T1 S' z+ ~- O1 @- O0 a4 b
$ItemElement = @$_POST['item_element'];. @# v. a8 K6 W3 S" L2 O' ?
$ElementUpgrade = @$_POST['element_upgrade'];
% ?- X; f+ c2 W! Z' z: y. B$ItemPierce = @$_POST['item_pierce'];
l1 Z0 f# ?- T w! Q0 c* v################################7 V. d J5 a) V7 e) T/ F
# P% n/ e& U" [5 t' f. u" p
//Check both variables for empty value
# q& u! o* a9 m; U% d$ ?+ U2 l+ G9 O
if (!empty($_POST['char'])){
) f ~! P ~% b2 U7 z- h2 q$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 8 I/ W7 B& P; A% K4 B; l [
% d: ?% }- @ g% u" Y! I
m_szName = '{$name}'");
9 X# H: \$ [$ @" B: I) g& lwhile ($row = mssql_fetch_object($find)){
Y Z& _3 Y2 q) f b9 }5 _echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";# |$ P7 m# S& b" q6 ]' z
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], # c0 `# C1 S; E6 n1 X1 D# B
1 o6 _+ M' ] B7 i l: R[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
) m7 m' n K0 `9 k! g$ t- k9 s* C
) L2 w, T; y' ?[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
S1 X. ?" w) b+ e+ O% \9 T- U
5 `9 d U0 [& ^' |0 a( zN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
8 t: \3 @ P8 w/ d0 d7 X% [
* Q! U c5 w$ K! Q, G'{$ElementUpgrade}', '{$ItemPierce}');");
' ?& m+ X% X# v3 ?/ S' G}; R% z" q1 S' Y8 K9 G. ^* [3 k0 U7 u: ]
: g3 `/ Y5 i. l5 ?8 |! _ s}
% Z8 S2 K; h i9 U4 T# s
" E3 c' F! w& v$ F}
1 f7 E- H# O8 c% A2 m/ C& n# A* `, |
$InitForm = InitForm();
& B9 W$ h( H: T# m$Listener = PostListener();
s3 l0 L0 V! y9 k+ \5 }4 K+ L. P; @
?>+ t2 Z% L# |8 O' ]( f5 V
! h0 G, J( x: b2 p% D, E
! |5 I+ i; i8 [( p% \5 i1 T2 f
9 r9 @9 T2 |7 n3 D$ G
: s: L6 n k- I6 b- X# h5 m |
|