|
|
<?php
' ^! }5 |7 _: B( e6 S! ^0 P) f& zfunction Connect () {" g. q" A3 _9 N+ N3 a
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
4 _9 Y% ?+ B( ]# Q% n' }$ M- G' m3 ?: X
Failed.');$ [' c8 U: C3 j0 G8 h
}
1 Q& |% x S5 i- W$ U" i" X* FConnect();
k2 t4 E, ]+ H+ I6 y
; d( J7 G5 `1 f U' `. ?5 q+ wfunction InitForm(){. _2 H, G, r2 v- ] W: A* S* l
//layout for the form
' x. `/ Y: [: P G- x5 Y$ \! C; F7 Becho "<strong>Send Items.</strong>+ x* O+ z! D4 y* H1 F, O& y+ b
<form name='select' method='post'>
3 L/ W* n" d& B' C3 B: t- y) Z<lable>Character Name</lable><br/>+ T1 |# B4 Z- t; n1 ^" d/ n
<input type='text' name='char'/><br/>
: V% N' m. h9 D<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
' t# t$ @6 M: c( R6 c: w<input type='text' name='item_name'/><br/>
1 h, E, I' d* z# z1 [<lable>Item Amount</lable><br/>0 U- V' z6 i( a2 Y4 \
<input type='text' name='item_amount'/><br/>5 Z9 X. N' c) ~) g) f F! _
<lable>Item Upgrade Amount</lable><br/>
! w" U# U9 F1 ]2 Y0 P3 ^) j<input type='text' name='item_upgrade'/><br/>% t% \( y8 C0 q& N
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.); D$ O6 n9 z! M3 a& w. I9 j
1 E, @! f2 n& |2 d0 H
</lable><br/>
: R+ b4 v& f) t<input type='text' name='item_element'/><br/>6 A% V( X2 g7 B: E
<lable>Element Upgrade Amount</lable><br/>
1 g6 L( h3 e3 x! \2 N" I<input type='text' name='element_upgrade'/><br/>) x4 d. i2 q# z! d3 u
<lable>Pierced Amount</lable><br/>0 _% }- [" p" d E, V
<input type='text' name='item_pierce'/><br/>
# o8 ^+ ?7 }2 c+ c4 y8 a6 d<input type='submit'/>3 p& H, ~, u# e, c* I$ A
</form>";
# Q1 R: N% l7 o7 B" M, w+ u* z+ e& H}
: W- z5 b( ]: @% e) ]. X3 q5 Y' ~: P& p$ {* n
function PostListener (){
& A- j# m( i/ ^! Y4 a/ B3 |, n//Add more post variables if needed and add them to initform() function aswell+ X; D1 u5 D* k* Y+ j5 u+ q2 s4 A0 C
( E0 C# }% p3 S7 q, ]' s################################
! E& z5 O/ t y- A4 M9 S9 D( d5 E##### Connection and Post ######
8 H8 r# |" b# O8 j [################################: l5 V1 N$ ]1 B, n
$name = @$_POST['char'];) m$ k* f5 `# N5 z" y$ A0 q
$ItemName = @$_POST['item_name'];
' T% r& l" t9 ^9 e, V$ItemAmount = @$_POST['item_amount'];% }$ d$ K m- j% |
$ItemId = @$_POST['item_id'];% q- I3 S* p* m/ D
$ItemUpgrade = @$_POST['item_upgrade'];$ i) \* }, }. V" z0 E3 z9 f7 [' g
$ItemElement = @$_POST['item_element'];! `" a. _+ S( j1 H
$ElementUpgrade = @$_POST['element_upgrade'];
! j5 e# ^' C2 U9 Y6 w$ItemPierce = @$_POST['item_pierce'];4 u) z; r- f+ E' X0 K1 I. B
################################
% v+ g; g7 b( H6 D6 I7 N* q; G5 x2 T; C+ G
//Check both variables for empty value
$ e& e/ @- h1 o8 K% U& F6 ~. R6 V, p% h: N* X" c4 ?
if (!empty($_POST['char'])){
% J& t$ L5 E3 }. e, i( X8 i! u* g$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
5 K4 | B& u$ ^% k$ M2 V) G( O% U5 V! c4 }- ` O
m_szName = '{$name}'");
3 Z: ?# @8 G6 owhile ($row = mssql_fetch_object($find)){
) J+ P9 Z0 D8 f6 d5 Zecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
0 ~/ A4 p$ k$ |1 p2 V; W4 B, A$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], : _8 Y# v' P5 [% ?( A4 h' C/ P
( W" q+ l" x+ J3 q; N( T( b
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], : X z/ v( I, L: U p
; |: r; L4 L0 N a A) C x
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', R; |4 {. E, n9 z
0 p" B2 w! @9 e
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
1 v/ \. x6 x# j- S1 c, _! }* ]: E# d. a& U
'{$ElementUpgrade}', '{$ItemPierce}');");4 z: X* _3 ~; J7 |
}
4 o! x+ O Y8 ?1 K% K& [
2 R. @' P" t' `}
" P6 v- L2 h! Y$ m* u# x* o4 E( u9 X6 ~7 J) z% z$ ]% o! N
}
" C1 q, n' M3 c$ \; X5 [% G* ]/ x+ Y& H3 g. i
$InitForm = InitForm();; h7 @# ]* t; u* k i' a
$Listener = PostListener();
3 D$ G" A# ^$ H! Q% w3 t, |# y- o! c, `, P; j
?>7 ?: C! G6 `9 Y, |
2 \3 n5 v, t" k: x: }' B& Z' a/ v
p1 ~' Y, c: e$ I
2 Q- t9 B* y+ v9 k
7 i# H6 F4 D, k( B) | |
|