|
|
<?php
6 V: s, `7 u4 V$ J( v% gfunction Connect () {
% M7 \0 B- w4 h: s! X! tmssql_connect('Server','UserName','Password') or die('Error: Connection to DB - \6 E. K, R, T$ h, m
0 ^& V: Z# A' j0 X4 C( f) l) p5 M! \
Failed.');% v# }) v+ M- T" T( z
}" P3 i& ]+ F2 c0 q3 D) w# v
Connect();, e7 |: ?5 b( e0 V1 {. l) i/ f
4 W8 t" h) W# z9 a! x6 \function InitForm(){
. c7 N J* A& [6 h/ ?, e! Z0 J0 |) ?//layout for the form
* t& T' `4 |% I$ o5 ~6 s; R8 q% mecho "<strong>Send Items.</strong>
; `+ H. P2 ~9 |9 f/ ]* n9 Q0 a% w<form name='select' method='post'>
4 i$ E' w/ n, s0 w' H: U" {" ?<lable>Character Name</lable><br/>
7 l# E; ?# T5 ^# K& d5 H: h<input type='text' name='char'/><br/>, t. O+ {' W! ^6 ?# e
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
- n! u0 D$ }% l4 m<input type='text' name='item_name'/><br/>' U; E/ V( M3 w- u
<lable>Item Amount</lable><br/> p) \. V1 Y: n1 s
<input type='text' name='item_amount'/><br/>
6 `/ h6 e- d v% u+ C+ V2 {<lable>Item Upgrade Amount</lable><br/>3 `9 R5 K+ X8 C+ {
<input type='text' name='item_upgrade'/><br/>
- p% q; }: v( B1 U6 s1 l<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.). p2 a& S- ]. s5 u9 X& H2 `0 O% V2 f
0 W: p/ S9 n% ], n
</lable><br/>
: l$ z7 h; W" _- A M<input type='text' name='item_element'/><br/>
) @. y3 g' s5 F9 C<lable>Element Upgrade Amount</lable><br/>: G5 Y) M' [) D F( j' P) A
<input type='text' name='element_upgrade'/><br/>
* j) ]* \4 f/ j2 M9 V<lable>Pierced Amount</lable><br/> T2 ^+ d- z" e4 {
<input type='text' name='item_pierce'/><br/>
) ]8 Y3 q# }5 G6 M0 q/ ~2 E1 M<input type='submit'/>
O q) A+ n o \</form>";
$ C8 M! O l& k4 e& j; u" ^}
. l; W) P* k+ x" v. P8 h1 [& X: q) Q- c
function PostListener (){
1 G9 |6 _+ o1 L( _! Y- W. {1 c. E* [3 g//Add more post variables if needed and add them to initform() function aswell* Y5 Z) F$ h" y1 s8 E& d+ t G' h
; d K8 z! t+ N" K& T" ^( l################################
0 F7 j0 R: n1 q4 v##### Connection and Post ######
& u* D& W8 q- @3 k2 P; Y################################
5 n0 o1 M% [# n$name = @$_POST['char'];% `, a2 h" X# H8 Y/ b
$ItemName = @$_POST['item_name'];
* c( {1 J0 [1 c2 Y' a$ItemAmount = @$_POST['item_amount'];* v4 |* P2 K% C0 e1 _
$ItemId = @$_POST['item_id'];
( ]& h3 v' f+ v; M+ S: Q$ItemUpgrade = @$_POST['item_upgrade'];
0 s0 y# W2 x# e* A& S$ItemElement = @$_POST['item_element'];$ Z' r% C' E3 e+ ?7 ?" `
$ElementUpgrade = @$_POST['element_upgrade'];1 E" m! y! D5 B6 K; A
$ItemPierce = @$_POST['item_pierce'];
8 K) ~- G$ }9 l" ?0 n################################/ ]5 I3 [# p6 Z0 `) f# @8 b
6 o! P+ i% q& z4 O7 S
//Check both variables for empty value$ y9 w* ^- ?' L0 j2 X
7 d. W& b O- ?; D; n
if (!empty($_POST['char'])){
: S- X" X% l5 B4 b! i$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
7 P; t/ [+ \, I+ g& i/ N) P
% s5 |4 p& `! }m_szName = '{$name}'");
% }) ^% j* F" r; {+ `) Uwhile ($row = mssql_fetch_object($find)){9 ?$ I t0 N) O. ?
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
2 y$ r& F# ?0 c1 i( L9 \$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], & {7 u3 R9 a1 ^, B: Q2 T+ @* Q& M
7 R2 D, g: K: d. k[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
0 ?7 j: @; `# G& R7 u7 @
/ t d! y5 O+ f- T6 W" B[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
# k( {- Y, }0 N6 q5 R) ~
; `6 \$ T0 C3 L U7 E- b( J; WN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', $ V0 A2 \5 @0 N+ X9 B. j; U' h
& N7 F) V! E8 L2 K: _: P4 t'{$ElementUpgrade}', '{$ItemPierce}');");
# f# P2 v8 u2 E) R5 x, U# M( J}: r1 b1 `: N- J: Z3 @8 B
6 c7 V+ B$ t2 h, U1 t/ E. \7 q}5 @" }9 M. q) Q# g9 c0 D* N/ t
B! L! ?) ~3 u% u/ N}
( p) n- g0 U" y- z$ X9 j; ~# Q4 n/ k4 c6 e8 |/ A/ V& Z1 O1 b
$InitForm = InitForm();
; `" h* Z& `: `' s l$Listener = PostListener();
" `3 e5 E5 C, \( g; S6 Z
2 i+ H) _2 S R?>+ H# _& j+ `: n- d8 N
9 Y8 j8 B: s0 ^2 U+ H) ^8 ]
4 {/ C& O$ l- c; S% |0 c
6 t' q% D% T% \; Z
, b* f9 A: E+ ]/ f8 `& [% Z& ` |
|