|
|
<?php- h9 r% N+ `1 y' }) m/ Y0 S' q" o
function Connect () {1 ~/ ~$ k& X4 w# s' ]/ Y- n8 f+ N
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
/ i+ I& r* g% g' W/ I1 N M& u
Failed.');
* k! X x( p5 S4 p' w. Z; m9 s}) i) N: s; }, ]8 f$ z' {1 x
Connect();
6 a, S" Q4 j9 A& a2 e0 \$ |) ^+ T7 I7 T' a
function InitForm(){
4 ~1 s( {9 E/ @% j: |* F* |8 ]$ M//layout for the form/ U% q# A# |! w E
echo "<strong>Send Items.</strong>. B; f4 H( o& g: Q( S
<form name='select' method='post'>& M+ M$ W; T: m8 t
<lable>Character Name</lable><br/>) @7 u+ x2 I" j
<input type='text' name='char'/><br/>! v/ T$ z: e! r! f# p0 ?
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>2 B& r2 v4 A( M9 W' i
<input type='text' name='item_name'/><br/>
( b6 z6 V4 V% u' b$ W# _<lable>Item Amount</lable><br/>: ~* H% J6 N# }% g( y
<input type='text' name='item_amount'/><br/>4 E5 t: a: \' d3 X# s
<lable>Item Upgrade Amount</lable><br/>
6 d4 B2 S& I; u+ P {" F<input type='text' name='item_upgrade'/><br/>* T# p' q' N& b# p8 E ?
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
' r7 z' H5 H& c
1 H7 Y2 H! d1 J* ?</lable><br/>
$ o# X' Q$ z) S& O<input type='text' name='item_element'/><br/>
1 \; v( w: e0 s( X2 ~' w; s1 B<lable>Element Upgrade Amount</lable><br/>
3 ~' O# Y9 U1 C w4 j) V<input type='text' name='element_upgrade'/><br/>/ ?, o8 h% l! W, q4 H7 m
<lable>Pierced Amount</lable><br/>
* N4 U* w3 {) }* Q<input type='text' name='item_pierce'/><br/>) a1 F1 Q4 d7 x- E
<input type='submit'/>
# T8 _( P" S' k3 D1 [2 y! m</form>";' ^9 a8 \: w/ P' a: K9 Z
}
5 X9 V5 I3 i# o" B1 |, |' l8 M! ~$ G: \8 k: ]& \7 Q7 }9 P
function PostListener (){
. L3 i1 _; v3 E//Add more post variables if needed and add them to initform() function aswell! y6 D# z3 Y* e7 m
: t. N! a' M7 j# c: N################################' k# H1 k/ m* _5 a/ S+ U6 }% F
##### Connection and Post ######% I! y- V9 u% V5 M5 Z+ L9 Z- ~6 j. `
################################
+ n" K# k( [0 S( w3 F" e7 I7 P4 g# x$name = @$_POST['char'];/ g0 S4 i3 w ^/ z5 e, m
$ItemName = @$_POST['item_name'];8 t8 k3 P( e- s R
$ItemAmount = @$_POST['item_amount'];
/ D$ i E( {4 F6 x O0 O2 N$ItemId = @$_POST['item_id'];
* f& ~1 W1 d: m8 m9 u: O7 x, w, H( d% q$ItemUpgrade = @$_POST['item_upgrade'];" p1 Q/ k: a( D/ N7 r4 B
$ItemElement = @$_POST['item_element'];
+ } R/ j! A, F$ElementUpgrade = @$_POST['element_upgrade'];
* v$ s" ]3 y" r) Q! I: c$ItemPierce = @$_POST['item_pierce'];
) L$ A' I/ }/ r. N: Z+ {; M& i1 ?4 f################################
3 D2 L% y. @- I9 K& P8 Z% g4 f+ o ]3 x# d- L- a
//Check both variables for empty value
4 A/ S1 y2 X) P/ B. C+ K( S7 T1 _( `
if (!empty($_POST['char'])){$ W' V. W1 k5 N' c [$ [# x
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 1 x, ?1 M3 w m
. c1 s9 P9 p5 {9 d$ Mm_szName = '{$name}'");, \- n" E4 ]; O2 {- ^; k
while ($row = mssql_fetch_object($find)){. q$ R9 t* V" L) l& x, D
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";5 ^3 _. _3 N# P& }- c7 s% d
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], % I5 |0 `) g3 d/ o
* \6 j$ ~2 ]! W' O9 U
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], : ~ D W$ R y3 Y7 H4 w
# |# S8 S7 e% x, T
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
6 ~' e0 j( w0 k; S9 w1 p8 E- ]& |$ e/ U/ ?- k4 P
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ! e/ S) G: t, t0 M, v$ P* g
- ^( L7 S1 g) J2 E% e
'{$ElementUpgrade}', '{$ItemPierce}');");! e6 U X) x, r
}1 b7 R: k" i1 k; m, J& Z
+ d7 M& p% @% {! }3 A9 w5 q" ?0 y}2 L5 W1 `0 g: m+ ^: N! C3 W9 r
6 n6 z) ?$ f6 Q" w}
1 ~9 _) }3 @2 G7 `+ X5 I+ K% ~- t$ P4 M) A9 n
$InitForm = InitForm();4 ?6 [4 e6 R4 t* }2 v9 E- g
$Listener = PostListener();0 u. e, p! }% T. U. `8 I M
6 l& s7 V; |& J9 }) u4 i H6 d, x4 P
?>
5 y5 E' z, | A$ S: c5 j i
$ E2 J7 `4 ~8 f! w$ o% J# v
" v8 G2 t% a0 `- c8 Y& i. L: l) Z+ _8 N; O& H
: x9 U; Q0 d2 M) `0 |
|
|