|
|
<?php
0 I* \' I5 q6 \/ Y0 `3 h, Efunction Connect () {
6 t' W! ?1 J/ cmssql_connect('Server','UserName','Password') or die('Error: Connection to DB % r$ I- o: |- V6 p
e( ]) j a6 i9 b; gFailed.');
' j" W$ V! l( w. y, g! T A}
! n' V4 `8 @5 M# ^Connect(); y( j F1 ^# k' E
3 L+ Q& R& a$ J4 D$ j$ ]
function InitForm(){
% ]) t: [; X, Q5 z0 m/ |$ [//layout for the form+ ^" ^5 d f) Y5 o( S( y
echo "<strong>Send Items.</strong>& V; T8 t- v$ ]& `. H3 l% h% O
<form name='select' method='post'>
$ L2 G8 I( z$ b7 q& X: W<lable>Character Name</lable><br/>* F( F3 J' n6 F- f/ R
<input type='text' name='char'/><br/>& S! u2 B. O# _4 O ~0 F* U8 V6 }
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>; m0 u8 s% p/ `5 ~- W* Y
<input type='text' name='item_name'/><br/>' E$ z5 r9 r" t0 a& T2 v4 A
<lable>Item Amount</lable><br/>
+ ~ H0 y) c) U' X- A# _<input type='text' name='item_amount'/><br/>) t; d, F# q' K( z7 x
<lable>Item Upgrade Amount</lable><br/>3 n0 x! q' K; x. z* A0 _' L8 ^
<input type='text' name='item_upgrade'/><br/>7 h/ Z8 e( n6 y7 f
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
+ D/ r$ Y* ]6 t' q3 e9 \0 x. i* x
2 F6 C- {3 P+ H7 G/ V' W- d" u( E</lable><br/>
& v3 O* H# A G4 |( [& Y9 Q9 P<input type='text' name='item_element'/><br/>2 Z, Z* R1 a; C: ]% Z
<lable>Element Upgrade Amount</lable><br/>
, I# M+ A% M' ?3 k<input type='text' name='element_upgrade'/><br/>% k/ U- W/ R6 ^' c( t
<lable>Pierced Amount</lable><br/>
4 D: e! o4 Y2 P1 e. }. h; x<input type='text' name='item_pierce'/><br/>
# ]: t- h I6 `# B" E<input type='submit'/>
* C ?8 v! @- G! L" A: [1 b</form>";
6 ?, H0 m1 S" V/ v: K$ @}
5 b) ~% I) S% x; N* y& ], u
0 {; h- @, {) Y( z$ i. d4 xfunction PostListener (){
; L' _' m7 i8 S$ u, W# Z+ B//Add more post variables if needed and add them to initform() function aswell+ D2 `; W: H" x( E; ^
* m; d* b/ }( X% a1 F4 z################################0 C# V0 K" O3 s4 ?1 F1 D
##### Connection and Post ######( _1 p: g, i/ {& F& r
################################
' {: g2 q6 _9 w0 I+ C, Z$name = @$_POST['char'];4 W8 L# f9 A* z8 E0 a" C- E
$ItemName = @$_POST['item_name'];1 k8 { z8 O6 U) V+ W
$ItemAmount = @$_POST['item_amount'];5 ^( R5 X) T* ^, u; N9 `) ^. {" l8 T
$ItemId = @$_POST['item_id'];8 a2 i, T9 W. J ^8 x! ]3 r
$ItemUpgrade = @$_POST['item_upgrade'];
: Q5 f% U n& t$ItemElement = @$_POST['item_element'];
( S7 u ^1 Y: ]) v$ N$ElementUpgrade = @$_POST['element_upgrade'];
1 v7 [) _' d7 }- G: d& H4 G, M& t$ItemPierce = @$_POST['item_pierce'];( o5 i) H; q! U+ V
################################
4 k. p6 i. @. I4 x* @8 I2 X& F' z$ I- I, N I/ s( i
//Check both variables for empty value
- F; w, ~& Q& Z2 Q& j9 n) q1 m: @: A- c- ^
if (!empty($_POST['char'])){
! T& M3 _# M& Z& l" f$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
" k5 p3 a& e! u4 J1 [9 q) P
1 j; R! H- V5 Am_szName = '{$name}'");
& q3 Y" _( S+ E8 I9 e! twhile ($row = mssql_fetch_object($find)){. p' E u6 ?/ Z; I
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
3 J3 G6 L9 {0 y4 f6 E9 ?$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], . q/ u, n: x ?( Z1 m! i2 @, M }! A
, S" W* L# L$ ?[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 8 {: ? W/ [; L# D% Z; r
X5 u: N P" F) Q Q9 l
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
. [) b @2 S, @ z& k) B2 Q7 c3 r' D2 C* W2 _' J
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', n% E4 D3 o" T3 f
. N# V% V4 v1 N0 j5 i1 I'{$ElementUpgrade}', '{$ItemPierce}');");8 c( i; k: A G; L) q I
}
8 Z% ^6 g: f3 | C1 Z& |5 x; F$ o5 G- B; z3 v
}
2 b, T7 `, F" B! o9 `5 \7 N A% y9 t6 ]9 [/ G: Q
}
9 L. _2 Y/ @+ q* b6 g+ P; ?
( a, u1 G+ n7 V- r6 `% K( H9 J$InitForm = InitForm();" f7 t3 k# i6 p5 A& L1 r
$Listener = PostListener();5 W2 o3 [) h( {" X5 W
]9 k# h5 ?7 q7 A2 j! C4 m7 t, g
?>
, m* a# G) B6 V7 m3 `9 a) o/ K/ i
* J- ?$ x5 z7 W5 ?
3 R3 G" l/ W w; ~! T/ }6 T5 r0 n, t/ h
7 Z8 p' @7 f: k+ u ^; y
|
|