|
|
<?php' u% T, @+ Z3 }3 H; D
function Connect () {2 M5 X& Z* ?1 w1 w2 ]; V" S
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
% @1 ]" U% a2 Z2 r; V& g
0 o- u* `- Q; [3 ^0 g2 { E+ IFailed.');
, C6 u3 R+ F# n* ^7 ?}
1 Y7 G2 U3 d/ h4 yConnect();
, N5 o( T$ z5 F0 i5 U' l+ J
' R" P1 s+ h8 c6 E% l3 Mfunction InitForm(){- M7 f% {6 m0 R" D- d' p" c* u
//layout for the form3 p% H# V3 o3 R( K$ _3 E) Y
echo "<strong>Send Items.</strong>
( T8 \8 `8 f3 S. L. j<form name='select' method='post'>4 Y5 e/ G3 H# q, }- }6 }1 ]9 ]
<lable>Character Name</lable><br/>. | G& m, x7 S; y5 X. \% i
<input type='text' name='char'/><br/>
; x* d# j; V) {( b& ~+ d% U8 k" F<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>5 Q! u5 R+ m2 i$ f3 k
<input type='text' name='item_name'/><br/>
8 B7 ~' K% C% T+ f5 B<lable>Item Amount</lable><br/>
, h* y3 T c [+ R<input type='text' name='item_amount'/><br/>4 [" Z3 E7 \( n4 h& g
<lable>Item Upgrade Amount</lable><br/>
9 ^, m7 n6 f. ]+ i<input type='text' name='item_upgrade'/><br/>
% u* m, w8 l% T5 H1 y<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)7 {% o% G8 }4 x" O7 k; \% I* q3 F
' S! n) n9 N. p* P8 z- E
</lable><br/>1 D: Y0 i' Q" N/ V) U
<input type='text' name='item_element'/><br/>( b) Q; |% Q- F4 Q# X3 [
<lable>Element Upgrade Amount</lable><br/>
2 h6 H- Y& c$ {<input type='text' name='element_upgrade'/><br/>
6 w, x; r4 i4 h2 |) t' g- Y" F* m<lable>Pierced Amount</lable><br/>
! K1 a, u7 E1 y% u<input type='text' name='item_pierce'/><br/>& f- A' r% Z2 Y6 W2 V* Y
<input type='submit'/>
# r+ ?, R; w% m `</form>";/ N2 o& ?# k! n+ d9 x! q$ L0 P
}
7 W2 B4 E! a+ I4 j( C$ x7 r7 P
5 J) u( j0 L6 d- h c2 efunction PostListener (){" o0 F. a4 b. _6 k6 z8 a
//Add more post variables if needed and add them to initform() function aswell% f- P: t% I0 M" B0 H4 V% \
F% y1 y# Z1 y3 }5 ^8 Y; C3 D% b################################# k5 @' o0 f- m
##### Connection and Post ######/ ?2 G- z7 o9 T- D
################################
4 Q; h+ x H2 [+ P$ V$name = @$_POST['char'];- s' u+ T) D- |
$ItemName = @$_POST['item_name'];
- Y" _% R& K( f4 l' r$ItemAmount = @$_POST['item_amount'];2 F9 T8 q* ?* P2 r" F
$ItemId = @$_POST['item_id'];( }; \0 T3 i/ u3 R" h: l/ ]
$ItemUpgrade = @$_POST['item_upgrade'];
6 S% b1 Z6 y4 L. T" ?- V* F% Q$ItemElement = @$_POST['item_element'];
V2 J- o% t! s* C/ z4 J$ElementUpgrade = @$_POST['element_upgrade'];
$ _1 V/ B+ Q0 u" b( H, O6 D$ItemPierce = @$_POST['item_pierce'];
7 a5 `# ^" }" I: g0 D+ w% G9 O################################3 r, q4 G( L4 C, S; v
, k3 @- p. y' Q* C2 w
//Check both variables for empty value/ G3 s) J8 L: i ]1 t% S
& O3 R' V2 {2 [7 S- G5 V+ l( Pif (!empty($_POST['char'])){
# p# P k( W1 u) H0 y' k6 ?4 j; k$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 6 j: z! Y1 a( s0 \% |
, U5 ]' c8 @( M3 f0 K+ H2 \: ?m_szName = '{$name}'");9 O4 b" u0 j4 H, a8 B( G+ D
while ($row = mssql_fetch_object($find)){
" K" S/ f G" O4 c* K+ h: q9 Lecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
1 ~& E# N9 F* T) ^$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
" K" j* H7 N0 _
0 N m4 [ [6 Q$ J$ Y& _[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], # s& w) j2 u" R, @6 q
$ d1 y8 r' C) Z% }+ Q. G/ C3 T S
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 5 P0 c5 r' i5 k; f- X) x
! R+ P6 E, J o) \* T: @N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
% O# e% @, I! z; g# v$ k5 {0 N4 V6 Z7 v( \9 Y' ~0 J" ]
'{$ElementUpgrade}', '{$ItemPierce}');");6 t0 _+ B: K0 Z, ^
}( q! R9 U5 w6 K
% n% q6 }9 q1 z8 i}
7 K' Z I! F1 m# X& ?" o% p. q8 b; N, r9 [0 o- E0 u
}8 t% z. m/ E' t/ Y
' X# x7 m- c1 [% h& F
$InitForm = InitForm();% A- E. d w9 ]7 l, r
$Listener = PostListener();: e, J- o/ c& Q( V$ p
$ t6 ^9 u( x" }& K' ~- m/ h: W?>
) n: E' _" U3 p; H* L5 b: p9 b3 a$ C! A, m6 r. T0 _
" X. ^6 Y1 H" s8 q8 n* g( J7 [
1 a3 R3 i9 W B1 L
! T7 v0 a4 o+ f4 N+ r |
|