|
|
<?php
2 m( f% X5 q9 M/ J$ z/ Sfunction Connect () {
7 n- A8 I) e5 m& u# g! vmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
8 L" e+ F+ \7 u) q& l: u/ c9 O$ C7 x5 J. w5 a3 }" L
Failed.');" V5 t; v" s% i, k6 z0 ]# e: \
}
# K8 N2 x5 t8 v) l2 C* qConnect();
: D4 d! ]1 h+ Z4 Q( {& I/ P7 Q/ _
+ R; g! _5 c" S7 X- i7 h+ B' Bfunction InitForm(){
1 d2 ]0 Q+ v5 j; ]. |; t' N) d/ k( s//layout for the form
; ~2 q* E7 m: decho "<strong>Send Items.</strong>
( f& Q! b1 _: |3 w<form name='select' method='post'>+ b! Q& @0 S$ b& b3 q
<lable>Character Name</lable><br/>
- n' W( g6 }+ a- U: j" g6 I* f<input type='text' name='char'/><br/>8 o+ r, `% c. g. r0 V
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>5 c1 {4 ~( @. W8 j
<input type='text' name='item_name'/><br/>
: N$ d8 z( R. p<lable>Item Amount</lable><br/>
* u1 a, T: n% {8 T<input type='text' name='item_amount'/><br/>
6 w8 c1 M( X; v. V8 E: J<lable>Item Upgrade Amount</lable><br/>
) Z# m( f% p9 ^# v9 ~<input type='text' name='item_upgrade'/><br/>" \# r: n, R% ?3 w* J
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.) g7 Z* K; O2 Y9 I' k9 u2 j( l
" K' g# y- R, `; k
</lable><br/>
( d0 ~' [; F M& }+ @; e<input type='text' name='item_element'/><br/>
- T- t+ L& Q! v5 C! W! ~; ^<lable>Element Upgrade Amount</lable><br/>
. x, j' y) W, A" R& N<input type='text' name='element_upgrade'/><br/>: k% x- N; j0 ~% w- c6 P: @$ O
<lable>Pierced Amount</lable><br/>
! U4 Z% l" V8 B& z: |" ]<input type='text' name='item_pierce'/><br/>! |! F8 D3 C( q1 X5 o' }1 X$ B2 Z7 y( M
<input type='submit'/>
' _- v/ Z7 q* E</form>";
3 B( q) \* \( S/ x}
b) D1 ~3 g7 [; f) O& j o# i* A) j- I/ Q% q8 s$ Y$ ?
function PostListener (){; ~4 R) \1 n$ \3 H
//Add more post variables if needed and add them to initform() function aswell
$ S7 s6 K% Y: Z k8 F# C, Z0 V
; H/ D9 z# N' y1 V' z################################8 w& e3 _0 x7 P* Z$ U/ A
##### Connection and Post ######
0 B$ |% r( H( p, B1 T$ A, Q################################0 Q C: A6 s- i* }
$name = @$_POST['char'];
3 `# ~ ?1 R1 X4 L$ItemName = @$_POST['item_name'];3 A) n! u0 B1 G% _) Q2 L% L3 Q
$ItemAmount = @$_POST['item_amount'];
& Q9 u5 }4 a2 N% i& V& Y9 V$ItemId = @$_POST['item_id'];
* y; P- a& P* X$ItemUpgrade = @$_POST['item_upgrade'];* ]8 K* e8 f" w; B# {/ Q$ q" k
$ItemElement = @$_POST['item_element'];
8 V6 `/ J/ y+ I4 B5 ?" ?& v$ElementUpgrade = @$_POST['element_upgrade'];4 H+ b& s) Q5 p. y: ~
$ItemPierce = @$_POST['item_pierce'];" _$ z4 s2 ~, X, i# t* ~" v( [
################################4 |& R- X! a0 ~4 p( N
! n! O: N( ~0 h7 W. ?//Check both variables for empty value& F( ?, g$ `* |8 T
" f9 }: Q# P4 J& g5 z: ]/ D( Q8 F# K
if (!empty($_POST['char'])){
2 A7 d6 A4 |" _0 \$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 `, G9 q" a# f" o( v
6 E. u) c* q# p7 Hm_szName = '{$name}'");1 o/ W9 ]9 t& f$ D! s2 G% Z, c/ r
while ($row = mssql_fetch_object($find)){4 h0 Z$ i8 g( f# y
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";. [+ V6 ~6 `' K! Z
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
. ]7 D2 ?) g. l* U, w' }# m& |! N% j3 x9 i9 I
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
( j$ a- d/ R6 w2 F2 ~
6 [% x7 _8 |' C ^ C[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 3 c- |' ?( W9 z v; W' L
9 m0 z" }5 P9 o% ^
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', : ^2 D- s, b3 x1 b) w
3 @# B( h& l( u
'{$ElementUpgrade}', '{$ItemPierce}');");
O* D' V& ~( `& y. M1 @( \- {6 h}) Q9 D3 u4 U( l' |1 d8 j
: k9 ^- G$ \& i% i2 G% g}. X3 T6 P- a! P; r8 {" h! B$ r
' `9 |; Z W' B
}) ^) a, ^2 [9 M% m& `
5 |& C) I7 i p: H$InitForm = InitForm();
- B+ F# @( v* [7 A$Listener = PostListener();: A" r4 G) b' [) L. `
! p) }0 p2 H" ]8 Q2 c! K- Q+ W; x?>
, P f# \+ f+ ~7 x# L& O# i- d# q
' F* f& n% p7 ~
+ a; Q5 o6 y& x5 Q2 B) w! [/ Q9 _
: n! ~- |6 f( d
|
|