飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
$ N% r. y3 C: S" @" a
function Connect () {
6 V. n4 I7 s4 _+ I8 @! ?
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
+ S4 B) d i' F. y0 H2 l$ K
" i4 B9 g7 C. |; Z
Failed.');
4 q( {8 r% G: |4 s
}
7 N0 e% L: L9 C, \; V4 n+ x
Connect();
2 u) Z" X9 M3 a
# r5 L! ]3 \, u1 d
function InitForm(){
& V& }0 ~* ~" X" C6 c
//layout for the form
`9 }+ x% X+ ]7 c1 E
echo "<strong>Send Items.</strong>
, `* U/ Q7 C+ t6 s9 Z6 A7 u
<form name='select' method='post'>
# P! o" C( F! F9 `4 Z
<lable>Character Name</lable><br/>
5 G- Y# \) ?2 H* _) S) F0 o# e( O5 V* D
<input type='text' name='char'/><br/>
1 e- s! E4 {6 f, D' Q- L! ]) c$ B
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
* T/ A2 o: |: o7 M
<input type='text' name='item_name'/><br/>
8 ?" D7 v0 [* D z# w6 Q9 I; C- ^4 b
<lable>Item Amount</lable><br/>
, R) C6 g& @) r1 K/ [8 v
<input type='text' name='item_amount'/><br/>
2 O% F# `7 I1 f4 E( I
<lable>Item Upgrade Amount</lable><br/>
- P3 ~0 I4 z* n. r' F( m" v. P4 s
<input type='text' name='item_upgrade'/><br/>
/ Z6 `6 ?& M- {% H6 z' f& ]& G, e9 C
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
1 {& h# K+ S0 K/ X, B
7 V$ B1 @1 U, i+ @% Y! \
</lable><br/>
5 F9 |/ b) |; H
<input type='text' name='item_element'/><br/>
, b: d% D" Z, p. f; b2 ?9 r
<lable>Element Upgrade Amount</lable><br/>
- `/ M& ?/ `; b( E( U
<input type='text' name='element_upgrade'/><br/>
( _; q- p( h4 c
<lable>Pierced Amount</lable><br/>
3 j" g$ N, u8 l
<input type='text' name='item_pierce'/><br/>
! R& f* {6 `9 _
<input type='submit'/>
- I* t9 V2 E+ w/ ]
</form>";
" w; E& k) A) G' e8 n y& c$ d7 ]
}
3 A+ M2 q! t0 ?, e% ]9 s/ J" Y
1 ~( Z- m8 u+ [8 S
function PostListener (){
5 S8 U# ~& [5 [( _7 ]! T# }
//Add more post variables if needed and add them to initform() function aswell
' s' L1 e. C3 O& t: l; W3 b
* b3 l& O# ^; G0 J
################################
: ~( }: Z1 e# P: y8 h" Q
##### Connection and Post ######
4 C! V4 T- g0 n! H& V
################################
: }2 T) L7 Q3 A- \8 s9 w5 b) o! f6 P
$name = @$_POST['char'];
! }1 O( ^/ Z9 ~% r$ i* u
$ItemName = @$_POST['item_name'];
9 [4 A9 K3 a5 {3 W' K
$ItemAmount = @$_POST['item_amount'];
. s1 _0 U& n8 y" ~, |
$ItemId = @$_POST['item_id'];
& E/ |, B" N, E/ v1 j9 Z1 O$ u# m' g+ ^
$ItemUpgrade = @$_POST['item_upgrade'];
A/ s: E {+ F! o( Q: q
$ItemElement = @$_POST['item_element'];
; }- g' i! x/ [
$ElementUpgrade = @$_POST['element_upgrade'];
% ^7 T$ P# p6 I5 n# y
$ItemPierce = @$_POST['item_pierce'];
/ @& N# h$ _! V) K
################################
. S. i; B0 Q8 n5 g1 f7 h8 Q# w
0 O5 a6 @) {& V# A' P/ I& u5 ?
//Check both variables for empty value
- D8 ]6 h- ] g2 m, b
3 _7 \, X* l. H' K! v( Q- p2 K
if (!empty($_POST['char'])){
9 g' V3 y0 r: h
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
! z2 W6 A7 W# f5 E( h
2 Y2 v& \! R, @! u8 [4 W/ @
m_szName = '{$name}'");
" W! ^& k% F' p# A
while ($row = mssql_fetch_object($find)){
1 _$ X2 o: o# o: k% v5 a8 y6 Z; b
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
6 E* x0 E8 ~! T4 Q
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
; g. [$ o" D5 G! a+ D
8 g, ~9 J/ n- {0 M6 C% ? @, S, ^4 h
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
; k5 Z ^# d5 R# e, A! I4 o# L8 T
$ z4 M! K$ R T. S- [! G
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
: J% V* B) f- S3 ]% N6 C6 w8 q
" x5 M4 ]2 ?/ z/ e
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
9 H o7 @ F% l0 [- m
1 o( c$ ?5 }! v6 |8 i1 `( ~7 v
'{$ElementUpgrade}', '{$ItemPierce}');");
# n9 H: r6 R4 Z
}
, L! H& y! T4 k- t9 S
0 Y! G5 f; m% `3 b+ k8 F5 {
}
1 p2 z- [9 j8 S' \" ] P
- M' s+ [+ x0 F i% Z- |" _0 l
}
4 y, k1 F, B/ x9 b0 ?( u+ V
. Q: \' W8 d; u g( k7 W( ?
$InitForm = InitForm();
: Q0 i7 F" h- r6 P; r9 d
$Listener = PostListener();
1 ~+ ?/ Z. i* \. F
0 Y: L/ ^- k1 Z7 B8 q
?>
3 h" v# U2 s& x$ K
) a9 ~. G. z1 F! e( d2 X
7 ^. R6 j8 G, {0 Z# t& ^3 _/ n: w
K8 v$ E- s0 A. B
. T$ ]/ ?' I% j3 I0 G) F6 t
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2