飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
5 T: D7 H2 q+ t) O6 v9 O4 M
function Connect () {
9 ?" n& Z( P$ ~0 H* v
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
& }( |. L( r5 {' d3 Q5 N
6 Q5 j+ U( J5 |" l2 r P8 q
Failed.');
1 I9 A* G6 O7 h; P* |0 [
}
/ [$ o! i- S% [# p1 g, h
Connect();
5 J h m- k. q2 @+ X
2 q: a! E& v3 f$ O
function InitForm(){
' S5 ^. A! y5 k! V2 ?1 e
//layout for the form
3 Z4 c3 d0 h' L. {8 l
echo "<strong>Send Items.</strong>
- j& E, `0 Q# C( U
<form name='select' method='post'>
% W1 v( |" K u6 `) r! \
<lable>Character Name</lable><br/>
8 [" G" R; N4 @" M5 _, N/ ]: u
<input type='text' name='char'/><br/>
$ C- v; U2 N* X& f1 o
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
! P7 i( C' b7 I
<input type='text' name='item_name'/><br/>
% O* i H& e/ B2 j( F6 j0 y* \$ L
<lable>Item Amount</lable><br/>
; j9 x; C) Z: i' Z2 _) P
<input type='text' name='item_amount'/><br/>
) H) U: `: @* Z; q# j% n2 i) F
<lable>Item Upgrade Amount</lable><br/>
8 W' l; j" x; m. U
<input type='text' name='item_upgrade'/><br/>
3 u' T* Z1 L* U- j0 N, y. ?
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
3 g, F( A# R) r. q6 v1 T, d+ b
! ^8 _. E R( {1 f
</lable><br/>
7 Q& z" R' \. e' C
<input type='text' name='item_element'/><br/>
$ ]3 n( z( c, E! M1 m0 l) u
<lable>Element Upgrade Amount</lable><br/>
/ a7 a5 b( W* H
<input type='text' name='element_upgrade'/><br/>
* q# T# i; `9 Q& [+ y# _( Z x
<lable>Pierced Amount</lable><br/>
. i3 A2 c) x) e9 u) }
<input type='text' name='item_pierce'/><br/>
, F. B+ `+ Y' R( I9 t% t- w5 ~
<input type='submit'/>
4 _5 t0 s) [ N- V! s
</form>";
) g& R+ u g8 U8 @) e
}
0 ?4 S. p0 g3 Z9 m1 j' f8 K
2 k$ p! t2 F. K' L7 e+ ]7 [
function PostListener (){
( l2 j1 o% j$ Y. w/ u" @' Y" ~$ @
//Add more post variables if needed and add them to initform() function aswell
3 O- S R# x. y$ c" z9 Z6 j
' a- _' n0 q: i) A8 n$ a
################################
) }4 d, q0 j, E4 B( N5 c I+ E
##### Connection and Post ######
. X- ~ [6 V* R& i4 Y
################################
) }* @6 E4 S- l/ n& Z E# i
$name = @$_POST['char'];
+ _" R. E. D6 m& H
$ItemName = @$_POST['item_name'];
9 g8 Z+ K% h' @+ \3 v
$ItemAmount = @$_POST['item_amount'];
# J7 h% C% ^2 H
$ItemId = @$_POST['item_id'];
% I2 J4 f+ C9 B0 S+ u& A
$ItemUpgrade = @$_POST['item_upgrade'];
. M+ e0 |$ R. F, A' r. K; C! f9 h
$ItemElement = @$_POST['item_element'];
+ e3 r- c7 t9 |
$ElementUpgrade = @$_POST['element_upgrade'];
5 e+ G. T6 ~% { b3 c
$ItemPierce = @$_POST['item_pierce'];
+ n# a0 y7 V9 R$ v1 b
################################
9 u- Z0 z, n4 M, I! |4 @* c' O; Q
5 D4 z- B: U" Q
//Check both variables for empty value
9 h% n, U" ~% Z; \) W, w
% v3 j; Y/ i! ]& a& i
if (!empty($_POST['char'])){
0 `; e& Z8 f# w- x: j
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 g/ g1 h) u: @
1 Y' @3 \, A8 u$ r$ U2 l
m_szName = '{$name}'");
4 Z% p. E; O- \4 o1 H
while ($row = mssql_fetch_object($find)){
7 e4 [$ m5 c; @$ I
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
; P" b9 y* L ^! ^ W% D0 h: s" ?
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
! L: l# H7 _" p6 M' s1 v
1 g, f: F+ ~; A/ J! \* Z
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
, o, v6 r. T0 I# o: f+ L
+ m" b0 \: n3 C; n
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
' X5 z' B3 ^5 M& [/ ~/ `) Q2 o8 _
2 N% N# Y% |1 W* o# ?
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
. q Q+ o' }! C+ g8 D) p, Y
, I' F& t7 S- o6 X3 F
'{$ElementUpgrade}', '{$ItemPierce}');");
3 h8 a$ Y3 a3 ]+ I% D( c7 w
}
/ v* i5 K, m2 c2 c
j6 d, K. M, U
}
" k5 T& P7 Z6 Q1 ~" O u3 B
9 y' m" e4 c/ m$ P! j$ T
}
]& n+ q0 S# {/ h1 H
# }% v }. H" W' [
$InitForm = InitForm();
- j3 s R$ e( q7 U4 o
$Listener = PostListener();
d+ t- [/ o/ g( }5 K( k2 P4 q3 n6 {
( w3 ?3 ^3 y7 e0 P O6 b
?>
: d/ v2 a) L. Y9 I
7 V: I# P) E; g7 [0 P* i
6 `+ d. e4 w0 {) x
0 d9 `) |% ^' ?2 X3 t2 a$ H, o( `& F
9 d+ g( {( W D5 w
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2