飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
. _7 e* @5 `# p$ h+ T
function Connect () {
; x+ p9 g9 J7 S) s4 z0 Q
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
0 _( L% S7 Z x
& B! ^! O7 ~. ]1 J8 `9 B: |( r
Failed.');
3 D1 z; y' c9 J( m3 S
}
! L$ C5 q# ?, b0 h/ h4 ]
Connect();
8 T' ^& }8 c5 f( ~2 x
5 i$ S! L* m" k" j. s' u. q
function InitForm(){
6 O- _6 }" X4 ]% {8 O3 U% A
//layout for the form
4 H! }0 G4 Y, f. W
echo "<strong>Send Items.</strong>
9 S* h% c- Q# a; b6 ?2 F- r
<form name='select' method='post'>
' x" }4 V( b/ s, X* m! g. Z
<lable>Character Name</lable><br/>
) Y8 H5 S4 |( ~" G0 g) y6 f6 l
<input type='text' name='char'/><br/>
; w8 r" z$ |' r% h' p( Y
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
- E* K1 d2 A7 z' p. h
<input type='text' name='item_name'/><br/>
. {9 Z; m+ C8 T1 q5 x/ ?/ {& s9 p
<lable>Item Amount</lable><br/>
$ R1 D2 j# U4 ~& A+ _, _6 k( {4 p+ l0 C
<input type='text' name='item_amount'/><br/>
1 c+ }* j$ i3 v2 f3 p
<lable>Item Upgrade Amount</lable><br/>
# j, N9 n" P" L' A$ m0 q7 |8 ?# K( j
<input type='text' name='item_upgrade'/><br/>
. ~* ~4 p( `8 p$ H4 W$ i9 z6 N
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
7 q% q H8 K! [. s( B6 q% F
" [ ]) d. Y2 I5 L( W# x2 c
</lable><br/>
V5 h6 Y5 r1 P7 K- r6 G
<input type='text' name='item_element'/><br/>
/ S# t9 Q+ i5 {5 ^( j
<lable>Element Upgrade Amount</lable><br/>
: H2 b6 d$ y. @" h+ I# T2 S/ V% {
<input type='text' name='element_upgrade'/><br/>
: }$ D; O7 x% ~+ h3 c7 @ {
<lable>Pierced Amount</lable><br/>
4 u8 \, \: I; e2 f4 |+ a- d5 V/ d, Y
<input type='text' name='item_pierce'/><br/>
# r3 K, N- e0 R( ~1 q2 _8 H
<input type='submit'/>
7 y; O, M! m1 g7 C% s" _& R% K# I
</form>";
' `& z" O( ?7 L6 T1 t
}
: @5 x$ _: E M% f: Y
" e! g W p8 c$ ^2 V$ o3 m
function PostListener (){
2 d# r3 z" s+ ?0 _' H
//Add more post variables if needed and add them to initform() function aswell
; P' C# }( t) \# u. J6 Z, V
$ V, y8 b# I9 R
################################
4 q' _) _- `5 z2 Q* m; Y& M
##### Connection and Post ######
; X* h! p: d: B, t1 I) G
################################
& t+ V+ |8 t i) _- V) }. G
$name = @$_POST['char'];
o5 p% L! U3 m7 G: i& L
$ItemName = @$_POST['item_name'];
} R7 S3 \ [. U' a
$ItemAmount = @$_POST['item_amount'];
) J `- N3 B }; L) D- G- W
$ItemId = @$_POST['item_id'];
' T7 B; A8 N3 d% a+ z/ |
$ItemUpgrade = @$_POST['item_upgrade'];
+ y0 [+ d$ r7 g
$ItemElement = @$_POST['item_element'];
5 R7 U3 o1 {/ Y+ ~
$ElementUpgrade = @$_POST['element_upgrade'];
) v% t4 O1 [, }4 U+ {/ R* t
$ItemPierce = @$_POST['item_pierce'];
, \! Y/ p* K8 l- q8 B( B* T0 m; h
################################
& O. L- f7 U& T
5 `0 n2 I! G! f, `, A% h$ s
//Check both variables for empty value
# f. K, {, ~( B+ g' [/ N" ]/ b
0 ]1 n9 ?1 f2 i6 H, \' f
if (!empty($_POST['char'])){
6 {6 Q5 H5 q( F0 K$ P: K$ `8 L
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
2 _8 D/ v& k& i& E e
1 K$ M; \ }2 F# a5 K9 ?" X2 Z
m_szName = '{$name}'");
. X$ D; I0 F Z7 ^* s; P# F
while ($row = mssql_fetch_object($find)){
: }0 W2 s. y7 E. ]) F( d& M" x" P
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
# b0 E5 x: G; X2 }) w
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
( C# `! h* j) d& D5 i% ^% k
/ r9 d" a ]0 S& ?# r' g4 u
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
7 `' e* ^! V6 W6 X, {
1 Z; h8 X* P! N) Z4 M) I! o
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% j* [1 S" K, y+ A
; z* ?( x- V# R# [* a% {6 X: |% U. p
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
# Z: f" X8 v& Y0 [- y/ s
7 |# k+ `# N+ N+ t
'{$ElementUpgrade}', '{$ItemPierce}');");
7 Z- I( c; x: ^: d V* p @; k1 b
}
: e) S5 I+ l( [& k" v
( x# B' _$ ~3 U
}
/ f2 T2 ?3 Y6 f" Q& a1 J0 z
- K5 T# C" M C l {9 K' b
}
! a$ P' H7 [3 r% E% S: { E
3 l; z; {2 K; I# t
$InitForm = InitForm();
5 Y8 t% B# t" X1 \: \1 B$ m+ D
$Listener = PostListener();
( d+ q# s3 Y4 _* K" v7 e8 z
: c; z6 r, z" @3 f+ g& \
?>
, U/ j& ~ C* e, X3 }! D* e
' i6 y* X, d' T6 p% t- C
' z% D2 Q$ O2 d' R# N, W- e
3 v* O: v9 o& B; u1 h
9 x$ \6 h7 I; X9 r
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2