|
|
<?php
% o X+ A7 y! y2 k0 O4 K/ ~function Connect () {
( \ S) k+ R2 h* ^7 cmssql_connect('Server','UserName','Password') or die('Error: Connection to DB + X6 B. v! `, ?$ C3 [
! g ?$ V+ C L1 }
Failed.');
& p8 \1 O) f) i7 N$ |* O* H}
& b9 j5 O% x2 t) [" Q4 CConnect();: z) A. ^* ~: F' L
' u9 g6 G. y; e. Tfunction InitForm(){9 O" B; _" p) ]
//layout for the form, z% w1 x m% j9 c {3 ~
echo "<strong>Send Items.</strong>9 y8 C. i2 F+ a/ s
<form name='select' method='post'>
* H0 h" f# X& {. r2 l<lable>Character Name</lable><br/>4 H, R! s$ ^/ D: l3 u5 \6 ]
<input type='text' name='char'/><br/>
( Q7 o1 B2 e! A2 y+ l+ z; E6 n# F) s<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>5 t g- O) p( L( Y I$ d
<input type='text' name='item_name'/><br/>7 p# `4 P3 a; ?/ t4 i
<lable>Item Amount</lable><br/>
; H6 t5 Q9 p4 g6 l8 R<input type='text' name='item_amount'/><br/>
7 l4 o- v/ O: L. `. w- \' \7 l% l T: d<lable>Item Upgrade Amount</lable><br/>, x: w3 H3 {! S2 Q0 {: v
<input type='text' name='item_upgrade'/><br/>
( D( T: S3 ~2 a) R b' g1 y+ ?<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
% d3 m8 S* u2 d- ?
" B6 q' h$ M' E3 o</lable><br/>
5 ^6 o9 K& k( _- A- P8 B<input type='text' name='item_element'/><br/># S2 b4 B& @& ]! w0 ^( [
<lable>Element Upgrade Amount</lable><br/>" d# n+ d# V7 W6 z
<input type='text' name='element_upgrade'/><br/>/ q5 `% u9 u: ?
<lable>Pierced Amount</lable><br/>
3 z$ T: l5 Y$ r1 ~<input type='text' name='item_pierce'/><br/>
3 Y1 h8 O. v, `" ]! I<input type='submit'/>
. N2 g/ f6 C. L/ l' r1 E</form>";' G) ^4 k7 N6 ]3 H9 `( P
}
9 @$ t3 P" P& d6 w) ?& @& F% C" w3 D8 S$ K
function PostListener (){
6 A1 Q7 J7 ?6 S8 Q- a//Add more post variables if needed and add them to initform() function aswell! h5 f B* c8 n
! ?" E5 u) y0 b; w
################################
: j& t1 n' w7 H3 t! I- A##### Connection and Post ######' r9 y% e, f* O( V
################################6 Y X* P$ m6 r4 k- t
$name = @$_POST['char'];
8 \4 y5 p0 k. Q6 a, q$ItemName = @$_POST['item_name'];+ ~) Y Q* H) l% ?7 ~" D; }
$ItemAmount = @$_POST['item_amount'];
6 w5 v, a2 G! h. n7 g4 c$ItemId = @$_POST['item_id'];
# O5 p( `! x" q. Q$ItemUpgrade = @$_POST['item_upgrade'];
% g% V! U! l" N( P( ~$ItemElement = @$_POST['item_element'];& g& Z" g+ F( N: Q" \* o4 m+ d# ^' i3 L
$ElementUpgrade = @$_POST['element_upgrade'];
0 Q, u4 K1 ]/ B( b5 b$ a$ h$ItemPierce = @$_POST['item_pierce'];% o* p$ P( h9 o' ^! d2 H0 a* ~
################################5 d# O* T* s- q6 S
! Y5 j% o5 l4 R6 Q2 v7 {1 f
//Check both variables for empty value( A# u {& Z1 m" l) v7 }
: i$ x/ |2 Y& U& uif (!empty($_POST['char'])){
# S0 X5 k# l+ P' n- f3 k$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where , W$ f+ \9 K9 D2 T( q, I+ d
. M/ N6 q) F4 m( t
m_szName = '{$name}'");
2 Y6 P8 u. |5 ^: ?. wwhile ($row = mssql_fetch_object($find)){ B1 U9 l- H5 J+ Y
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";. f4 W# {/ Y; y3 B
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
: `- k- q3 r* D* P! e% k% C1 D( B2 t! G4 q- I4 r
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], - O' m) S9 r, o0 Q7 [
, }# Z3 J, u$ n+ U3 V" z" h5 C% D[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
* T* t6 {6 b( z% U, Q$ a( {$ ?) @( w' h8 a
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
' a% Y8 t3 Q$ r+ {; n( J1 p0 o* D" v3 w3 z; y; u/ c" g
'{$ElementUpgrade}', '{$ItemPierce}');");
1 j& L: k* | D1 G}: S" T. {9 G+ H4 Y
) E* \* b" q8 q1 O6 w) n+ p( M% V# y}
; t: J7 ~# y. u; h% y) y& x# [7 E* e
}/ t% o0 ?: U) R) m& x) G, q1 d
: P$ O1 D$ H; \
$InitForm = InitForm();0 K0 ]2 A) ?& n6 d5 o+ v( u
$Listener = PostListener();
1 B3 s& S9 U! C& z' \. e: D
1 U1 r& c9 p* L?>
7 ^6 i1 }4 Y% e% |
5 y, @3 f, r5 n
( U0 o6 W9 `. \& h! X. j
% l) Y/ ~( W( Z, r7 j- Q T: z# D5 C: {+ X$ T6 h& ^
|
|