飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
% ^0 l0 ?* y# s+ |* l# W+ V! U
function Connect () {
0 Z( e3 K0 l5 I* a' t, E
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
^7 E. C" Q: F. q0 V- J& z
( Y) e- a0 n- g$ {
Failed.');
( {% c: C+ H- ?- b: E
}
( f5 z/ r$ t% u0 T) u7 L- y6 I# W
Connect();
_" l( y* Y8 ]( S1 S F1 I
( d- d; j: Q/ V
function InitForm(){
4 z) x, Q2 }( V, o
//layout for the form
. i; U( x4 w: J# |5 `: q# ?
echo "<strong>Send Items.</strong>
2 i& v3 K/ ]# I/ x! ~
<form name='select' method='post'>
, i& w" Y3 e2 j- f' U
<lable>Character Name</lable><br/>
& A9 y3 ^: A) ^* ]
<input type='text' name='char'/><br/>
/ L7 Q, v# M/ d* Q
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
( M7 y3 f6 g: d
<input type='text' name='item_name'/><br/>
8 j# f# y$ Z3 H
<lable>Item Amount</lable><br/>
1 P4 b0 T- J4 R) k9 Q
<input type='text' name='item_amount'/><br/>
: f& H- r3 L8 ]9 t5 `4 [$ M3 _
<lable>Item Upgrade Amount</lable><br/>
5 H+ K0 @0 H4 j( b5 D
<input type='text' name='item_upgrade'/><br/>
* k- D% O6 r8 M$ p+ V% ^$ A! J7 \
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
. ^& D8 E2 I7 D0 [0 B7 P" r
, p* @ W0 ^) T$ O% O4 }
</lable><br/>
- [' z; K; M% ?$ B* U4 u
<input type='text' name='item_element'/><br/>
; J7 }( y3 X+ y. m
<lable>Element Upgrade Amount</lable><br/>
1 O! B* D( N5 C: S; |* H9 S$ E
<input type='text' name='element_upgrade'/><br/>
0 L. [7 P: R% v
<lable>Pierced Amount</lable><br/>
( w4 T; `0 s1 a
<input type='text' name='item_pierce'/><br/>
6 W: i& j; g: |, M
<input type='submit'/>
9 W% h% {* P3 ?8 t- j
</form>";
+ R2 A6 b9 r3 L6 l0 t4 g5 m
}
" D* ]0 `9 o8 j7 u# `
5 h9 z, h& E* K; Q/ W- V$ \' K
function PostListener (){
4 h" c3 P r- y3 j3 q
//Add more post variables if needed and add them to initform() function aswell
8 ^& ~% D2 i/ S- k9 q
( ]1 `, V. V; x* G8 W, C; b
################################
4 w# {, m. s9 N
##### Connection and Post ######
2 e* I! m# [3 M; V
################################
! r) d: l$ G' D, N
$name = @$_POST['char'];
" v3 G( k( ]! {$ T6 U) |$ s! q$ @
$ItemName = @$_POST['item_name'];
; z6 T& |1 W: l8 R4 q
$ItemAmount = @$_POST['item_amount'];
8 } b K" `2 E% ?
$ItemId = @$_POST['item_id'];
5 W( u7 k: J, r' w5 g
$ItemUpgrade = @$_POST['item_upgrade'];
6 \& [0 o- x( [% v5 I8 }4 l) r8 s+ e
$ItemElement = @$_POST['item_element'];
$ ?5 J/ Y' q* E) e. q8 U: l/ \
$ElementUpgrade = @$_POST['element_upgrade'];
/ T9 ^7 u) T6 d' J
$ItemPierce = @$_POST['item_pierce'];
, N/ z2 N6 s# H4 W2 ~$ A. Y
################################
1 q! H, E9 ?8 ~' A: D u: J
/ R" T0 j9 X8 r. J% r
//Check both variables for empty value
R5 I; g6 Y! E$ d
# {# o" {* A7 {! H) Z4 H+ Y; A+ f; K
if (!empty($_POST['char'])){
: b$ _2 w4 W9 C" C. B
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, |7 a n, w. z2 C% a
Y" a: p$ I1 T8 k4 ^) W
m_szName = '{$name}'");
) D. o, c3 F/ r( e. v8 `
while ($row = mssql_fetch_object($find)){
6 p7 ]" o! T6 B v9 e
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
+ V! x: R- W7 d, }! ^4 B1 D9 Y
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
; E5 v+ |% C3 s9 i8 x" z% T* v9 S
5 s& U1 V2 ~, s- _" ?7 u% O( ~
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
" A3 E% @2 o( u) a ~8 \& \
6 L& C' f- K1 j. V+ C
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
, Y. }6 y. z4 V' Z. {4 j
2 y7 B8 t0 b+ b! Q) C8 u4 a# [
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 g0 ]5 f; {+ n3 I+ ~5 a) @* ~
3 Y$ _4 x+ V* R& Y$ U
'{$ElementUpgrade}', '{$ItemPierce}');");
6 s! ^/ s* N5 h" {2 }
}
$ z8 D5 X* F- y% c, E3 g
1 e+ ~/ I# y: V7 [$ L2 i$ }
}
7 V" s" @: h2 c9 R. _9 T0 C1 H$ L. p
4 R% r$ o, k# R' u- P
}
+ g# U% b$ {& P7 V* e1 c% w1 m/ V$ D$ c
" D0 G5 r& e! n0 `" }
$InitForm = InitForm();
i6 T5 H3 U) G, q- P
$Listener = PostListener();
+ S- Q. c2 e! p% W; k% z2 ^
- R+ l& o/ v, D1 _1 f
?>
3 T* |' O# v, r, M, |
2 u) [. j9 A* H0 R8 Y$ f0 H- _1 p2 K
* a: r& L9 o5 c3 V% M- w
' C1 `; @! q h8 H! c. D
9 O! Z' _0 M$ c C2 G
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2