飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
# O3 k! P4 T! S1 Y. f
function Connect () {
6 @/ t+ V; n4 ?6 V+ {( o5 C. F; f3 v
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
7 l0 S. c* p* H. S% e* M
# m4 o8 g+ B8 O$ e8 c
Failed.');
; k1 M4 R& I; ^, f6 g, K2 e
}
& d6 j! `" B5 J" @. d# t7 b$ ]
Connect();
5 r9 u, u5 m' Q1 H6 c/ q
, m3 b. a. v3 ?) }+ _% ~' m
function InitForm(){
[+ A& g9 O8 ` v9 V$ G
//layout for the form
3 ~8 I, j6 b% ?) N0 p/ ]8 E) t
echo "<strong>Send Items.</strong>
1 _7 H" b8 l; B! k' ? }
<form name='select' method='post'>
2 l' m4 A2 S% C, n1 N
<lable>Character Name</lable><br/>
# J4 {$ L) ]$ p
<input type='text' name='char'/><br/>
~, `2 C( {8 K* k: l
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
# L5 w; X% u% g: z/ F( M6 I
<input type='text' name='item_name'/><br/>
; w0 n' e! f2 {2 Y; L2 o9 V2 ~$ f
<lable>Item Amount</lable><br/>
% {: g2 m# h& P- \; q' b- {
<input type='text' name='item_amount'/><br/>
- s# @! x9 {; Q' C( H& K. u
<lable>Item Upgrade Amount</lable><br/>
$ s; w! G* b/ U+ f, B
<input type='text' name='item_upgrade'/><br/>
% ?- [6 t6 i+ \; M
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
% z! A6 }; s! }3 Y' M9 q
# D2 y2 Y, w2 }* h' B
</lable><br/>
' E# L9 i( X4 u. Y, |& M
<input type='text' name='item_element'/><br/>
6 b( |0 ^0 d5 P$ B# Q5 d* z' A# F
<lable>Element Upgrade Amount</lable><br/>
, E, W1 k1 y, G, j: V8 y! k
<input type='text' name='element_upgrade'/><br/>
2 L5 N1 V) `; G; T) X" z
<lable>Pierced Amount</lable><br/>
2 C2 e; X, b6 }4 o
<input type='text' name='item_pierce'/><br/>
) S% a3 Y0 n% B' ~+ R+ U' V
<input type='submit'/>
% e6 ?7 L& Y0 {) W$ z7 h
</form>";
; H n" h( U5 c
}
- B5 W- ?/ @$ ]& `5 w" W
$ X: W+ I2 E0 e! n: e/ ~& o
function PostListener (){
) ^: P8 o, W; `' Z3 Y- \
//Add more post variables if needed and add them to initform() function aswell
+ S3 z8 T( G% ?
- f7 F& L4 ]2 a- X6 ?& A" r
################################
/ ?- B2 i; R6 ~" C* W6 Y- \8 e# u
##### Connection and Post ######
2 T4 b% i& Y% ] ~8 e! h( R8 ^
################################
5 K% F5 o* P' W6 {' ]
$name = @$_POST['char'];
$ I; w- \$ a& r# b
$ItemName = @$_POST['item_name'];
* m( W* n# x+ r/ y4 c' Z& V, p
$ItemAmount = @$_POST['item_amount'];
9 Q0 l# l! t- k) p0 m
$ItemId = @$_POST['item_id'];
' a% U0 [9 m T% E
$ItemUpgrade = @$_POST['item_upgrade'];
1 r6 q4 V5 p1 y( t9 v4 U5 `
$ItemElement = @$_POST['item_element'];
6 |4 Y3 j- p& F0 ^. v) O5 }
$ElementUpgrade = @$_POST['element_upgrade'];
8 U9 j8 `7 W& g9 X! {
$ItemPierce = @$_POST['item_pierce'];
3 `4 z( K M2 R8 i; _
################################
: R* O9 M9 Q) B& `7 Y
5 x+ W8 w8 y/ _
//Check both variables for empty value
2 i2 ?3 W3 M9 ]; U2 Y
0 \6 h* f7 x1 _) }' P
if (!empty($_POST['char'])){
! g, k, k8 T# v( {& k
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
: q5 S/ W: N7 b- E- Q
5 U) f# `% x9 Y: q8 o. M
m_szName = '{$name}'");
& B& @( \8 I9 w4 `; j% w- b
while ($row = mssql_fetch_object($find)){
( @' y+ v+ J% y& p& ~) U" z3 s
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
2 f5 {, K9 S/ Z
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
4 i, h# F! o: ]# l8 t! H
2 ]- S6 f1 e. _* c( }' H# ]
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
- n# b4 G+ v- P
% Z: r0 Y: m# d# O; x
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
) T: i( I' i+ t3 H2 H% t3 @
8 O, X @/ D: d ~6 l
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
5 G- Z) [0 Z3 a; Y! _
# j+ J( u; R2 z
'{$ElementUpgrade}', '{$ItemPierce}');");
* J) g* Q, D; v3 n; e3 D2 W; p* ]& p
}
P, g3 L0 U9 i( t, u$ \: X7 K [, m0 P
b9 j1 M+ }: E) C7 I! a9 H4 r
}
$ W0 I3 r& i" F. I5 T
- g0 @& O; ]0 H" w* G+ U; t
}
5 ^0 _" H; `7 I1 X3 v) g/ S3 l
8 f8 e! L6 K9 d% A
$InitForm = InitForm();
! B( P/ Y" W1 q, e
$Listener = PostListener();
4 y& y9 k# T h0 ^
" {7 u0 G# i0 u, P
?>
" H9 E9 m$ O# b) B7 X! w% D( J& C
2 @/ }" H+ @5 \; ^ s: H
1 ]" D/ b. q$ e% d0 j
, e. q+ ?5 Q- D& s' L' H
6 ?; a- ?3 q" E! U0 b; P
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2