飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
0 B, ]7 N* t2 Y/ Q0 p
function Connect () {
1 E& b ~% q3 F5 P$ p/ h$ W
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
' E8 ]6 l+ N3 b5 a4 Y
- e/ i1 y7 m" ]6 B9 E
Failed.');
9 v" t! J3 _% g& f, Q9 n
}
' F, X v; } C4 v
Connect();
8 N1 \8 V' x. `$ _* P
; v9 @# R, q. v6 x( I% s) z
function InitForm(){
6 r7 J9 n; G& U3 Y; l
//layout for the form
+ Q& u" R9 f/ C; \' C+ {
echo "<strong>Send Items.</strong>
; L& L( l2 M2 A2 q2 b3 e
<form name='select' method='post'>
- \# f/ s& Y0 Y8 U. Y% S* }
<lable>Character Name</lable><br/>
0 d# h/ Y6 C9 y! a: w) B
<input type='text' name='char'/><br/>
# K- E( D. I& d( T7 j
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
8 O- o k) o7 h; c
<input type='text' name='item_name'/><br/>
/ P" p& v0 w# R% k6 p/ G5 |& X% ^
<lable>Item Amount</lable><br/>
! J" V2 X7 c6 M0 Q* n! Y4 K8 d
<input type='text' name='item_amount'/><br/>
% Z+ }$ D5 j/ n) M1 Z
<lable>Item Upgrade Amount</lable><br/>
$ D# b& Z% w4 O6 v- W
<input type='text' name='item_upgrade'/><br/>
" U" `4 |7 I6 e' j' A8 X. z' u. ^
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
9 h" y' _5 a0 n4 }& }
" S7 |6 |! o- D) q
</lable><br/>
7 s- K( A4 \" E6 v
<input type='text' name='item_element'/><br/>
: X/ w6 }! @2 Q, M; y" d
<lable>Element Upgrade Amount</lable><br/>
/ Q" D+ |+ W# q7 f+ a6 {5 z9 D8 p
<input type='text' name='element_upgrade'/><br/>
* h5 l6 F- @3 p: E: a7 q
<lable>Pierced Amount</lable><br/>
$ v" O. A4 e3 L; Z. v" s
<input type='text' name='item_pierce'/><br/>
% a5 `0 A: u- I& j
<input type='submit'/>
* A5 ~, L2 o- J L: Q
</form>";
, y' y v* R3 ~/ |% ~ }
}
l5 P; k1 Z5 n$ j% ^
' \/ K6 i5 E7 y. {$ b8 U
function PostListener (){
7 ]% d- ]6 A6 r. h0 L2 M$ l. r
//Add more post variables if needed and add them to initform() function aswell
* E( V2 t! x3 C1 R9 Y
) _) n2 j+ K+ X! |3 F8 F
################################
( w$ r& s; ^: O7 P* \
##### Connection and Post ######
2 ^! g6 R& P% E- ?7 g4 V
################################
3 Z3 Z+ n: H! o& S/ r+ ^) M
$name = @$_POST['char'];
) Y( H6 z# u, ~4 @: q
$ItemName = @$_POST['item_name'];
) e2 C2 Q6 ]! h, _& P
$ItemAmount = @$_POST['item_amount'];
3 r6 @3 X7 L; \: {
$ItemId = @$_POST['item_id'];
% H6 f0 R" a! f i( n6 ]
$ItemUpgrade = @$_POST['item_upgrade'];
6 t l$ ^, p0 b0 @" u: W
$ItemElement = @$_POST['item_element'];
8 x* l3 ?2 ]. j- t/ i7 A
$ElementUpgrade = @$_POST['element_upgrade'];
# v( |! q/ ^# r2 @: I
$ItemPierce = @$_POST['item_pierce'];
( V! A# d0 I: f4 B. [
################################
7 ?' t2 a8 C3 ?8 f$ `0 I S
2 Q9 y/ V7 K3 i
//Check both variables for empty value
1 H# @* H) v- r/ R( \% }/ \
$ ?; Q7 h. t' n: }4 p+ \1 M0 p6 E
if (!empty($_POST['char'])){
+ |( n/ H- M, V+ C6 { U
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
* |* d1 e0 u' R: y
. p; T3 E I A1 n9 Z3 X% Y
m_szName = '{$name}'");
. S( y! }# ^4 w2 t) @ M6 f
while ($row = mssql_fetch_object($find)){
6 }! w8 x: \5 w/ S( o
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
' u9 ]- t' b+ r. d' l; X* i* H+ y9 u$ H
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
) U# b: k O: ^
" Z) {* R. P" M9 ]* p
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
/ D; m# s e) x7 ^9 l; P
5 ^ n9 N: e( ~7 c
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
# Z, Y: Z/ D, I9 m1 y1 h7 H
) ]: ~1 D: H; G8 t
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
5 S5 j& p$ [1 n2 l
9 h/ P& p& b3 ~7 v) A. c
'{$ElementUpgrade}', '{$ItemPierce}');");
# Q `' {1 ]$ \; r- G( V, T0 l
}
* A1 b) {* q' x* Q. U
, A+ n: Y+ W, W5 r& K* F
}
! d1 _ m/ p' D/ K' @' W
( I6 K5 n! `, c5 b& u; n
}
* w& u i( Y% P s, \/ k& X
! J3 l: `1 ~! F5 d
$InitForm = InitForm();
' C; t: }7 p% s% c- x5 ?
$Listener = PostListener();
% E6 n& p8 ]" a! \
' D. C5 C8 U8 I0 }2 ~, f
?>
9 r, G! u% m# o: p; r
3 e0 S p- F/ f
' u- s1 x: V1 I" v a9 R
2 q, N! S% h; k n2 U& T) `
* P1 G5 f% D1 m) U5 ?/ r
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2