|
|
<?php
: k0 ?4 }1 K/ I* N( w1 yfunction Connect () {
A" h# M+ k9 ]: Pmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
! `! E' n$ ^6 A+ e8 e' v+ K3 y* \7 m2 h4 i2 K0 i3 a, ~% l
Failed.');2 i; Z1 ~. {- E" n
}
6 E1 K' l; f, p. r$ r$ }( @ \Connect();* g+ y3 b: U- J' B' e2 V" @9 J
1 v" X( K& z6 x j6 M$ b
function InitForm(){
) l( u% l4 ]0 X& h$ c//layout for the form! O! O5 x! o2 } _; v9 l2 B
echo "<strong>Send Items.</strong>
) G$ [+ Y; X k7 M$ [1 K. `<form name='select' method='post'>
' \( o6 T% u2 ?: G' C! @8 P<lable>Character Name</lable><br/>* f1 v, r/ U$ }5 @8 m
<input type='text' name='char'/><br/>
. L3 E1 r7 d5 [- Y3 `, {! Q<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>( N' C4 o( f' ^' v
<input type='text' name='item_name'/><br/>
% Q: p; Z- j! a0 p<lable>Item Amount</lable><br/>8 C6 s4 e9 k- w0 s/ [ W$ A" j
<input type='text' name='item_amount'/><br/>" d$ }2 g2 b. ?
<lable>Item Upgrade Amount</lable><br/>% L8 M! B0 J/ g+ O) ^( J
<input type='text' name='item_upgrade'/><br/>( {. ^7 k/ k( u O
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; [9 F6 ~9 j' S$ ]
) ?* t+ ^- {: E% U</lable><br/>4 |+ [: Z: v" ^0 w9 w' c a; j
<input type='text' name='item_element'/><br/>. I) L4 L8 x1 ^& d
<lable>Element Upgrade Amount</lable><br/>$ x, L j8 b- {: V: |$ k
<input type='text' name='element_upgrade'/><br/>* ?6 h2 y, y, Y8 L ]
<lable>Pierced Amount</lable><br/>
& h6 t m; h- p2 }6 a; {& Y N8 E" }<input type='text' name='item_pierce'/><br/>5 B4 P3 A( L8 I- l0 `( {6 V, a4 a
<input type='submit'/>& L! I6 O' ?4 ^" d
</form>";
3 }' k! P7 @ A}
6 Q" {/ M' T+ ?, p: O* W
+ t! B5 Z% |7 `# d% G3 T$ |. s- Z! ]function PostListener (){8 o$ y, r) c) _# g
//Add more post variables if needed and add them to initform() function aswell9 e2 q u$ ?* H) J
$ ?- k# W8 v0 ^' K4 W6 ]################################
, a6 J' d7 X7 ^" H+ @% i e##### Connection and Post ######+ E; q# R& m! F% j" H( d
################################6 f/ x+ P* ~. C! q; J5 \/ F" u
$name = @$_POST['char'];. y& U5 }' I4 g6 i1 m
$ItemName = @$_POST['item_name'];" }7 l4 @; z' h- F9 _$ A
$ItemAmount = @$_POST['item_amount'];; p: N# ^+ l2 w D$ k
$ItemId = @$_POST['item_id']; c0 w: R+ q C3 ^" N0 `, S
$ItemUpgrade = @$_POST['item_upgrade'];& I7 g) @% Y# _* c g
$ItemElement = @$_POST['item_element'];
! w" K4 l: `3 n* u$ElementUpgrade = @$_POST['element_upgrade'];' S2 C/ }3 v6 ~- P# B O
$ItemPierce = @$_POST['item_pierce'];
9 _/ t& o1 W; u- {* ^4 i) [3 b K################################
' I* s9 N7 F6 P0 A1 X5 s3 E- M( K
% \2 P8 r4 J+ o6 e2 }& P6 M$ }//Check both variables for empty value
& P$ H9 o9 U& F: [: g7 w# U& i' ? S: _4 O/ |" P: s
if (!empty($_POST['char'])){
( x6 U; g5 Q# m$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 1 L: N5 s1 n5 M& K
, V& V, M$ `( b/ R/ m: {m_szName = '{$name}'");7 E4 G3 q! K' K- ]8 u, t4 k
while ($row = mssql_fetch_object($find)){
8 _% L% D6 M+ g7 {: pecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
7 H5 d" H- L- Q1 a, v6 j& e2 i3 y$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], - ~: }% \" v( Y1 t: m
5 C& F% y1 K0 n: Y[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
7 T. r5 B/ D' U6 h1 o8 `9 ?) C9 y7 {1 d' L1 Z8 u
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
$ u2 U P% R0 ]; f1 \- q. A( G9 `& W: P0 O; J
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
+ F C6 t9 K7 D, g4 d" W4 w7 O" R$ g0 n! [8 J c8 K
'{$ElementUpgrade}', '{$ItemPierce}');");5 q8 u, v* {9 e6 @
}
# [. N8 `+ J7 l3 T
$ h% ~* ~1 v9 H# U! N9 J4 i( f$ i}+ ?" k9 `( y+ b& _1 t+ N
; w* d7 [4 L; ~6 @, N& T) ?}
7 P7 H: L, }% `! v5 x1 p/ `2 @7 ^9 P. ~
$InitForm = InitForm();
7 O; |% J/ D7 [/ Y7 T1 n9 J$Listener = PostListener();
# ^& f/ B6 f! `& i: |0 U" w, t
2 G2 E; z. G c0 n$ S% M9 F1 \1 F?>
8 d# K6 n+ q/ f r/ i; D7 H {+ Z* ]' m8 l6 t
5 r& X& H8 C, p8 T) c6 X$ F( T. t$ W
9 X0 Q9 j* V. R
|
|