|
|
<?php: S8 v( c. u a" @9 ^% e' w, i+ ^
function Connect () {9 t% N7 i1 e3 e8 s: y7 ]8 H" R
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
! C# m3 r% h0 \3 h: ]
7 N5 z7 F7 g! B4 @# l5 S- yFailed.');" g, I# z/ z' v
}
& K a; U0 G2 e) bConnect();
0 {( u; X c: }% d* f' e
, c. I: X" O3 q# o9 A+ l5 m4 S* Dfunction InitForm(){
- D' l" p/ m$ a" {, u* X" `//layout for the form
7 g( D/ g) i) gecho "<strong>Send Items.</strong>& p. i; q% C j, g0 G! {9 Q
<form name='select' method='post'>, G8 _8 [( b2 X( d
<lable>Character Name</lable><br/>2 V: z w( d9 b! h: [! O
<input type='text' name='char'/><br/>
1 z; K; [$ s$ l, k: M% l. j<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
' n* M! x# F) `! V# g5 f<input type='text' name='item_name'/><br/>% U5 c# [! b" N" U2 z2 h% t
<lable>Item Amount</lable><br/>
* i- |+ ?. y7 F' L<input type='text' name='item_amount'/><br/>
4 Y% P9 u; R6 }' P- S T<lable>Item Upgrade Amount</lable><br/>* I; G- P; g; e5 `, N
<input type='text' name='item_upgrade'/><br/>
( B* Q% F6 f3 J9 ~+ S0 g<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)8 d# Q0 q/ S, f1 ~
' ~4 @* T* A+ K5 v$ ?/ s g</lable><br/>
" `' S% S" [4 ?" \<input type='text' name='item_element'/><br/>
% r) I5 ?+ k$ `6 O<lable>Element Upgrade Amount</lable><br/>% v: Z9 l- N( P' W
<input type='text' name='element_upgrade'/><br/>
/ N' I6 s. `8 F7 v7 w<lable>Pierced Amount</lable><br/>
3 }& ^2 [" A1 F2 u<input type='text' name='item_pierce'/><br/>4 _) V+ R. n- c/ P( X
<input type='submit'/>/ B# c; |* z) ?( Y' o, H
</form>";
6 O1 M# R# \* c! t6 U% D' c {1 f}
- A' `1 Y# P8 j" |, E! G. Q- \* P: `, Q2 K( m! k6 g5 T6 W
function PostListener (){
4 O2 Q4 ~; M. w5 k8 t2 ^8 k//Add more post variables if needed and add them to initform() function aswell
8 Q' o% h3 ]- K" T
/ D" k# c k/ [7 U5 ]: C7 Z################################% |& j( [' P. B0 a9 B$ M
##### Connection and Post ######; I& i d) B+ i7 E; y
################################
& R) m8 y+ T/ A+ s2 R$ v$name = @$_POST['char'];
/ i. `$ D; F$ r1 r& q# G$ItemName = @$_POST['item_name'];
$ _5 N; O- w8 E8 T$ItemAmount = @$_POST['item_amount'];5 v' s4 }& r- @$ Y
$ItemId = @$_POST['item_id'];
8 c# R h; N4 y+ X& Q% g/ G; y) q$ItemUpgrade = @$_POST['item_upgrade'];
6 n5 I) Q' N( s: m$ItemElement = @$_POST['item_element'];
8 E1 `" C6 S4 g% i6 e, T$ElementUpgrade = @$_POST['element_upgrade'];
4 O: m; V+ T4 C9 v; n7 u+ i$ItemPierce = @$_POST['item_pierce'];; X2 c& N, ], k7 [7 K7 [4 B4 L6 \6 i9 {
################################
6 z; a9 h) H [! ]7 `8 a
4 B0 F. M# _0 o/ k% j+ x' }4 q//Check both variables for empty value$ F6 @7 }6 | l: X- m
) ~* ^0 L- U+ d4 d! r. ]
if (!empty($_POST['char'])){
) R$ k7 f( q0 E& [+ k* W$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
4 j. C( \, q: g. D/ e' p$ ?( j* w" e! c6 \! v
m_szName = '{$name}'");" s; z! U! E! f; b2 _& E
while ($row = mssql_fetch_object($find)){
- Y( e5 {" r! }- v% D$ {6 mecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
8 I; b$ G. T7 Z, m3 M% X; A$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
! |. \) x( h( Y! J5 o) Q8 [0 y; ^- T( @4 P* a3 v
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
3 t( D% @5 z& X% ^% j% j) V% Z% F1 u K# q; h, x3 m
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 9 H+ X9 j# z) }( K( J, a7 o6 @. R
( C- R" _; ?0 Y7 W' D" Z: N
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ! l8 x7 `. v7 z k5 o# F1 _0 ]
* l* ]: j3 S/ ~5 X9 Q" K' X0 R3 L'{$ElementUpgrade}', '{$ItemPierce}');");
8 {& d6 g; E, ~}
' R+ Y1 B9 y# m4 T
- v- U/ |( x- z4 i" ]' T}; z6 W* p0 l$ h& V
3 k @& N3 V9 O! O( r2 C}
' k" @: G5 P. S. O: B$ I0 R7 `/ b" P, q& u1 x! c5 g
$InitForm = InitForm();
1 r) [' ]( |# }% I- W9 y U$Listener = PostListener();7 t9 k0 P* O+ ~! p" x8 e
6 |( S( }( {7 i% `
?>! d7 d; X" @8 Z4 n1 M# d
5 H0 i* M6 C( {1 W' _- `
) g5 q, G Y0 u
$ N7 T/ V' s( L4 O2 n$ K2 N/ V6 M$ E/ J- y
|
|