|
|
<?php
( [6 [0 }' R+ Y5 Bfunction Connect () {
9 T$ L( [/ O: K5 dmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
: u$ |# f8 W g3 Z+ p6 @1 ^0 _$ \! s/ C7 K; W" r
Failed.');
4 A) y% v7 l# X& {) S}4 G/ k; a5 a5 p6 h
Connect();
Y6 J* C# h Y x4 C% N8 [+ h8 r, W2 r! o0 ?5 @
function InitForm(){0 ^2 @4 } i6 T' E( ^6 q
//layout for the form
* X7 k3 t3 H- L! M1 ?* _5 gecho "<strong>Send Items.</strong># l: N( D- n2 w8 r" T* d
<form name='select' method='post'>; M7 Z* f8 m/ c) H/ Y4 i1 j$ \
<lable>Character Name</lable><br/>
6 u. i! v( u) d- @& G<input type='text' name='char'/><br/>- x5 ^7 n; e( e9 s
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
. b0 M7 x, M5 U# C! n) H<input type='text' name='item_name'/><br/>, x# ~' l2 ^1 Y
<lable>Item Amount</lable><br/>
+ r( U: b8 N0 ~/ i<input type='text' name='item_amount'/><br/>; O- r9 v4 }" q8 Q# |/ `
<lable>Item Upgrade Amount</lable><br/>5 o$ a1 |) X% s' q. {
<input type='text' name='item_upgrade'/><br/>
1 W0 b& z" G7 Q<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)8 t: }9 f$ h/ O$ F4 ]* d) |* n" z
7 p* W; }$ b5 ?7 L- D, X
</lable><br/>
( A, j0 q" u; O/ ?) [9 H<input type='text' name='item_element'/><br/>( |2 o; T9 t8 J3 m S* y0 t& e
<lable>Element Upgrade Amount</lable><br/> ?. K5 Z) T/ z0 ~1 Y3 x
<input type='text' name='element_upgrade'/><br/>( U) E, `* X9 T8 \0 }0 |
<lable>Pierced Amount</lable><br/>
. f/ _7 `2 O# z- f5 d* a<input type='text' name='item_pierce'/><br/>
* B* J) \8 _& M. W( m<input type='submit'/>* V: t0 j1 o1 L6 I$ f
</form>";
_/ G. D- j& k! X4 o8 @9 W}
: z2 Z* e8 g, k3 a3 Z) m1 }( P: i6 S& `& T, B- V; @7 b4 D
function PostListener (){' F0 ]5 X& [& h d8 @; }) @0 g5 t
//Add more post variables if needed and add them to initform() function aswell+ X2 B( \. x& d+ ~" V% W7 p
; o" b5 d& C5 O. z2 b, b
################################
( H4 R, |. O" C6 d0 N$ C9 O##### Connection and Post ######$ c. t" k! \; K: }4 e% ^
################################" H6 E$ O3 {: N/ f, X, v3 p
$name = @$_POST['char'];
8 B( P6 A+ b( h- M$ItemName = @$_POST['item_name'];
2 n/ I& q) @( ^; w& g$ItemAmount = @$_POST['item_amount'];+ j+ y6 S1 m" R+ K9 r
$ItemId = @$_POST['item_id'];
F+ H% b, p. @ l$ItemUpgrade = @$_POST['item_upgrade'];2 u) y* H* C" F* s# W
$ItemElement = @$_POST['item_element'];2 B# T9 w) B# D; `* A! z9 ?
$ElementUpgrade = @$_POST['element_upgrade'];
/ H( ^- k8 o( m" f8 A3 R$ItemPierce = @$_POST['item_pierce']; Q1 Q. Y" w/ }# U7 z0 l5 u/ n
################################
7 ]2 U% o8 w' C* O4 [. p2 |3 {& u- [2 x' Y6 [& v4 Q
//Check both variables for empty value: z L; @" C2 I1 B
" C- B% `" p5 N; |$ d, G7 d
if (!empty($_POST['char'])){
( \; \0 G3 g8 g0 }7 Z$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ) _( b6 {$ g+ }
* M3 i8 ~6 W' L. m( s! A
m_szName = '{$name}'");. f/ W( g- ?! V
while ($row = mssql_fetch_object($find)){
2 R V; B! ~5 L |. |9 ?echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
& W" ^- [/ V* M9 v4 ?$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], % e0 ]3 b1 M# r, J! U' Y8 D
! m/ M z) c9 W+ A: c5 W& E- s[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], / v/ C' F* D# |5 `
, b. F& j6 o4 J0 I" [- `[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 5 n7 }# }7 X; l: T
" X* R% b8 Q3 x* I1 l. bN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ; M A1 s) o% y
( i$ X+ A; v4 |) N( K. `
'{$ElementUpgrade}', '{$ItemPierce}');");, g8 I* V# |& c U, }; `4 }
}7 [* Z8 c" A# |
* n0 q. {( c; ^$ ?0 s; p8 ~
}! A3 U" y& E( N
2 a# E. w1 e9 y8 z}
: y0 C+ e- R7 h+ y* Q4 ~) Y7 d, k, t# E$ D0 s9 n6 {4 j
$InitForm = InitForm();0 G- B0 q9 J2 I u8 Y; p
$Listener = PostListener();
7 Q; [" B! y; z5 ^8 X/ a" ]
& V0 }) }0 U# T% |- o?>
3 r" G7 ]5 l+ l& i
" t( o3 ]! j1 ?2 ]3 V% u7 y
- C9 v' r$ s* n3 S$ k& p# _% G) ?
; r1 h% D' t, S" V R
|
|