|
|
<?php
9 D7 ~. d9 c0 Wfunction Connect () {& G! J6 T5 I& n9 J* V9 m
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB * C. K' W8 n6 D3 T0 ~- a, Y
x, J9 F2 D' n$ s' X5 b3 MFailed.');# ]8 b; @6 Y- A$ a* ?7 M$ }' o6 @" h
}" A# r" @" c- `
Connect();1 ]6 m Q/ n& p4 g, `, J- u2 m
8 \' P( G/ h# l0 L" {& y
function InitForm(){2 t. Q8 }" k8 D4 i1 c6 {/ N
//layout for the form$ Q! l& s+ S9 R
echo "<strong>Send Items.</strong>% g" ^9 E/ {( V& h
<form name='select' method='post'>
4 I( R1 W2 c9 K. M) }' q- s" H4 S9 C M<lable>Character Name</lable><br/>8 W+ O9 Y! H2 J$ u7 @. I
<input type='text' name='char'/><br/>
9 x- W+ ^+ s$ @; O C<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>1 U* C) D2 F+ _- T1 \
<input type='text' name='item_name'/><br/>! E0 m0 [! s- d4 A5 m* {7 X5 M
<lable>Item Amount</lable><br/>1 }0 M2 l% g7 V% {" j5 ?
<input type='text' name='item_amount'/><br/>
* t8 G* P: f4 a2 Q<lable>Item Upgrade Amount</lable><br/>
' w, X! T& h9 v' z<input type='text' name='item_upgrade'/><br/>' h `. n4 E; t H/ E) g
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)' X- D' m) K& O) d
% N- q$ ~1 O$ R3 r/ }</lable><br/>5 g0 `, W/ l. k" p1 c3 Z
<input type='text' name='item_element'/><br/> }6 `( A8 O2 @+ ?5 G$ M
<lable>Element Upgrade Amount</lable><br/>
+ `. y" X Q" b, @# H<input type='text' name='element_upgrade'/><br/>
$ Y" T- D# o% U; Y; ]; v<lable>Pierced Amount</lable><br/>
2 ?+ G) r% w+ u* D- Y<input type='text' name='item_pierce'/><br/>
4 a7 B- A5 X5 W! S7 J1 g- u<input type='submit'/>7 g( q2 x2 L$ t) O
</form>";( B) i" R; f+ X5 l+ ~- k9 K
}) z. I) Q/ r: `- |, N4 h9 I
( ^9 l% j7 n. b8 ~
function PostListener (){9 V) W; W8 q# l
//Add more post variables if needed and add them to initform() function aswell
, b, W, T2 x& X, a: }$ g0 [7 k
9 n3 X* L; h4 m" A6 x( O! i4 e################################
& H+ d9 t; W' x1 }, r. W/ j4 W##### Connection and Post ######3 d: Q& s0 v$ m& G! G" H
################################
' P; Q o' q: ]( ?, d0 ]+ s$name = @$_POST['char'];
% }3 m1 E' U; c* d$ItemName = @$_POST['item_name'];
( z) C, f1 O; i! a$ C, Q' {$ItemAmount = @$_POST['item_amount'];
# ]. c; g0 q- b2 B8 b$ItemId = @$_POST['item_id'];
0 l* _/ j; M: x! S- o# z8 q$ItemUpgrade = @$_POST['item_upgrade'];# f$ I3 z. Y x
$ItemElement = @$_POST['item_element'];
8 v8 M5 r! w0 ?$ElementUpgrade = @$_POST['element_upgrade'];8 s1 ?$ O$ O4 o5 S
$ItemPierce = @$_POST['item_pierce'];
7 y3 W& l' X% S. J9 X4 k" P$ j################################ O: P P; ?3 {, a; k! W# C) @
0 h+ j; p; e8 {0 K( t
//Check both variables for empty value
. l# I4 t1 N+ J* W6 y7 N, y) j* L6 {: Z
if (!empty($_POST['char'])){# X0 f# ]+ }) S2 L1 ]$ l8 [) S: M
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where . K" v3 L, S4 H. S. y& j7 R# y2 a- e' O
, b3 j% J7 ]$ {m_szName = '{$name}'");
2 T" q* j/ F0 [+ G5 }$ c b. \; vwhile ($row = mssql_fetch_object($find)){
1 k! J* {/ A) A9 Decho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
- ?6 M) m( o4 p- G$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
; P! V9 v: p, u# F0 @ X6 P- ~$ Q3 \$ F8 G0 [
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
6 g2 Y8 P2 R' [$ ]* b; E
. `" k& f! @- z, }* C* ][m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', . j& E, ~% @& T% D
% L! d" I: ~ `) {
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ; D+ f4 i% v1 u2 Z, s5 M
. f& r$ Q, F% ]) @( G0 u2 S, R0 H. w& R'{$ElementUpgrade}', '{$ItemPierce}');");
3 ]$ s7 m8 g* f+ p}
3 d2 }) |# t H' h8 K% r- A. l& S S- n% \! l' m5 A: m
}
+ U) o: D k# X5 p1 P
i1 t4 _0 [' C, z! F& F2 s. ^}% Y; y; D, e1 x
6 `5 X; @( E/ p$InitForm = InitForm();
" ]) K8 P, u0 h( K& ]0 _ |$Listener = PostListener();
# X3 J$ P5 ]2 j( F
& e: @9 j( \, H4 I3 _; D% Z6 K! D?>1 C4 w- x, N1 Y5 }" M+ T
# `! D+ ~2 T$ R5 ?
5 e" S0 w, S" p6 I1 \9 W1 x. J# v6 X3 a' |% G: c- \8 {3 s# P
. h" a. r% H% z5 n/ s |
|