|
|
<?php$ q# x1 A8 g+ W0 t- S1 O$ R
function Connect () {. d w2 `" [0 p+ p `
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
& F, |: _( c' h' H2 ~; [1 z3 ? \" q
Failed.');
4 N4 d: D+ |6 D4 r& |}
+ f! l9 X) _3 F* s5 [. O D4 iConnect();
+ g0 N, h' k5 _9 g. j& a0 m- L# _& Y* D; L
function InitForm(){
4 |& C ~5 m0 L/ ^0 M//layout for the form
& Y6 L9 _5 @4 d# i7 Q2 H( Qecho "<strong>Send Items.</strong> v1 h% Z, M- k! M
<form name='select' method='post'>
; I6 B4 d+ z7 Z% }& k<lable>Character Name</lable><br/>
7 C; M8 P) i2 d" B<input type='text' name='char'/><br/>
$ V& |1 k2 [* }( ?& R, z# h ?1 z<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>, k6 H# |- [- n5 c8 W, ]
<input type='text' name='item_name'/><br/>9 h! B' {9 ~, O) w2 Z
<lable>Item Amount</lable><br/> K9 s; n. ^1 u, M. k4 P3 p6 f
<input type='text' name='item_amount'/><br/>
9 R8 D [- u$ c- A/ e<lable>Item Upgrade Amount</lable><br/>9 w3 C7 q3 k, `1 i' E* |2 K9 z9 @3 }
<input type='text' name='item_upgrade'/><br/>
6 x9 _% U3 h# M) h9 T% @<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.); i3 K4 e4 `: w: |8 o" O( n
+ A. H7 _! Z, u( q B
</lable><br/>
0 u0 ?2 _/ o8 k! z, W<input type='text' name='item_element'/><br/>
1 k1 @+ W# j( z6 @<lable>Element Upgrade Amount</lable><br/>4 e* b/ e* f! j- t# G* f% @
<input type='text' name='element_upgrade'/><br/>% I) \4 l. J% O5 @9 u
<lable>Pierced Amount</lable><br/>7 D7 s7 K/ @& F% r- ?' {
<input type='text' name='item_pierce'/><br/>6 g0 j' Q' z* k
<input type='submit'/>
6 C# w# I% e A0 r; ?9 f0 d/ i</form>";; V8 l. K' {+ @/ ~
}
) e+ U2 [& Y$ o2 r" n
. K7 N/ p+ p# ^6 g! g' Rfunction PostListener (){
+ `- l$ k4 P D/ T1 n0 q& w V6 I; b//Add more post variables if needed and add them to initform() function aswell8 ^3 ]* ~3 R [. j- l* `. ]
- I' r. P6 a- G& `* \
################################
8 `' O1 ~. U1 K+ p+ A: ~- R+ C##### Connection and Post ####### S( S( N; X: E9 \4 v! B, |
################################6 O: r4 X1 h- n- k4 T! [+ d# [, q
$name = @$_POST['char'];
: l: g8 h- z) j( M' Y: i$ItemName = @$_POST['item_name'];
' _9 n9 m8 V. H$ItemAmount = @$_POST['item_amount'];
' m( ?' q7 t4 F$ItemId = @$_POST['item_id'];
, _0 R( C7 Y; o$ p2 i$ p$ N! L$ItemUpgrade = @$_POST['item_upgrade'];) q1 T1 W' b" p0 H( {& R
$ItemElement = @$_POST['item_element'];
- W- z9 Z ` Q/ c) F$ElementUpgrade = @$_POST['element_upgrade'];4 O4 d0 C: {% u
$ItemPierce = @$_POST['item_pierce'];
$ q; m: {# {& R7 ?/ s. J################################# C0 k, W/ } @, Q
. \9 E( [+ J+ s' i( ^1 w
//Check both variables for empty value) h. ^' V3 Z" F
u$ ?$ ]5 O1 x" L( @
if (!empty($_POST['char'])){
9 _9 F% v' c2 F+ T! R% e$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where . L$ O( X5 M9 ]0 M. y. w
) A9 e! [9 P2 t$ f% B, e% V
m_szName = '{$name}'");: J! [& e2 q0 N7 m+ S
while ($row = mssql_fetch_object($find)){8 {2 P9 ?$ a+ U, r" L$ J; b
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";6 {- v0 \" G3 R5 y
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], # @8 U/ c' u2 [
2 t: u* b& w3 \9 f3 `8 r4 k[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
3 k% }/ N% \) a" L- K6 B2 K9 c H/ H& u
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ v0 Z% ` O8 W$ X* ?) {
* h5 k7 ?+ \& W9 q4 R8 `& [* [N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
8 q9 Z @3 C, g+ T, a* B# b. M' s$ h Y5 _4 y0 x$ r9 Z. p# _; [& W
'{$ElementUpgrade}', '{$ItemPierce}');");
4 h7 |% @! d7 T+ i. q}
" U$ g) b, o, X& t8 K
# S+ x1 c: Z; h: V3 H+ {+ W% s}' t5 ^' G' d% H8 C3 W6 i
( |( |% g, X0 ]3 x1 w2 O
}0 ~) H; L; ~0 O2 b$ Y6 B6 Y# A
, ?. t( J9 |8 i0 k+ G. k. c) v, {$InitForm = InitForm();5 b6 W' p1 T5 v$ J
$Listener = PostListener();9 M1 Q& h" {" O1 h( }0 {
- \$ I- x$ _3 o4 l" `?>7 a# j# B& u: k1 t& v X
( j3 x6 m; D$ Q7 x
3 i8 T4 C$ _, d* g5 n$ {- l% |
# S* |0 f# U+ q, h9 Y. ~# K ^% Y# Y% C; i- W1 D% J
|
|