飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
; W$ ]! t( U0 U) g& K3 r
function Connect () {
2 r1 T: i1 j$ w+ c! X8 {3 y$ Z
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
- J) Z* S& G6 }
& q8 _0 ?6 ?; `! u* {8 ?+ m
Failed.');
# H) W9 b% s/ H6 N6 n7 D: z
}
: K+ B/ ?( g2 W. v3 P) W
Connect();
' V% N' P- n7 V7 ] L2 G
# @! p7 D2 D# F/ s/ t* T& S p: n# ~
function InitForm(){
0 @2 p# E, R" q, s5 }( |
//layout for the form
4 e& M2 \6 D( m
echo "<strong>Send Items.</strong>
- p9 ?) Q/ v" L2 y) S
<form name='select' method='post'>
( H+ x) M8 Q# w# _1 X; l, a" `( P$ G
<lable>Character Name</lable><br/>
) k z$ l# ^; r( z
<input type='text' name='char'/><br/>
7 Y$ @3 ?3 r* Q
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
; a+ _* t4 M$ ~, {
<input type='text' name='item_name'/><br/>
" a+ m1 e5 a% @8 H
<lable>Item Amount</lable><br/>
, N2 C! [$ X! C8 j9 _
<input type='text' name='item_amount'/><br/>
. I7 ^5 J2 `' W( Z) Z
<lable>Item Upgrade Amount</lable><br/>
& l& }* C* G3 L
<input type='text' name='item_upgrade'/><br/>
7 J; {- D4 a6 B: [) ^ i
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
) E% e2 B4 Y6 l: t
3 ?$ S) q# {1 l1 V: R
</lable><br/>
7 }9 ^5 ]" n8 Q2 k* a) w# {
<input type='text' name='item_element'/><br/>
. m8 y$ D2 W! ]# b( W( q3 ]$ t! H
<lable>Element Upgrade Amount</lable><br/>
+ L N4 ~$ e; N
<input type='text' name='element_upgrade'/><br/>
" [% o$ B8 P1 v3 \) r2 i0 \
<lable>Pierced Amount</lable><br/>
$ T2 K8 s* U1 ^$ U4 w
<input type='text' name='item_pierce'/><br/>
3 i/ S, M ~, v% r
<input type='submit'/>
8 r! p: x) t5 ?; g
</form>";
5 b$ y1 N# e2 i5 ^! ^7 E3 [) b
}
$ P X* H$ ?! e1 m: P
' m+ A6 o5 k: n$ Y- N3 P5 x1 c
function PostListener (){
3 g: I5 L3 Y# a1 l5 ?4 C* m8 [+ L; J
//Add more post variables if needed and add them to initform() function aswell
: S$ C# v" }' x a7 b9 X4 K' j& Z1 }
6 k& U1 o* |! h5 X: c3 u2 F) y
################################
% n$ w7 W6 V' K1 ~4 M# N% _
##### Connection and Post ######
5 w# w# \5 @. o- U3 N3 Y( g
################################
2 ?1 V( O: z( u# T0 T2 B* J3 V
$name = @$_POST['char'];
+ e( G5 U% v* u: Y' Y! s
$ItemName = @$_POST['item_name'];
( A' c9 Q# }, d* u0 X* [3 l( C
$ItemAmount = @$_POST['item_amount'];
}; ~9 T) i4 \. `; c
$ItemId = @$_POST['item_id'];
* n D7 [$ o0 V( l t
$ItemUpgrade = @$_POST['item_upgrade'];
9 P. X `0 n$ N3 L# R) X8 }8 T
$ItemElement = @$_POST['item_element'];
# V( K x# R6 H9 F- D
$ElementUpgrade = @$_POST['element_upgrade'];
/ f3 A. m! R3 J9 x S \
$ItemPierce = @$_POST['item_pierce'];
" l4 A& v( R* y4 E
################################
3 Z' l) k) l: x
( h- Y2 b" D: y% A3 m
//Check both variables for empty value
/ Z* h3 y' M# v- I6 Q# H& L6 I
9 U2 _3 j- D5 @- [ X
if (!empty($_POST['char'])){
% O! b2 N/ A8 I% y9 H q! H
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
5 ^2 f* b. `" z0 o+ h8 ^" j; R- B
2 {4 G2 o6 [7 Q w* t$ t
m_szName = '{$name}'");
3 P! K- \$ V7 A: P+ U+ W+ [9 a: b9 B
while ($row = mssql_fetch_object($find)){
9 g* E% A3 X* O$ Z2 B
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
- J! H( V6 V$ G. I0 J
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
1 Z9 Z& f7 d) l9 [$ H( G7 W, Q
7 E6 `# f, \+ p: ]$ q. X- u+ H$ _
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
! s6 t! N4 I0 A
, w' A2 x! m3 p4 |" E
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ f8 Y- ~' u5 r1 F$ ~& D4 w
. A- z) h* i+ B( ?: \9 q
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
# M8 \( | v1 c7 z R" \' Y
]4 K p& C" W" Q! E
'{$ElementUpgrade}', '{$ItemPierce}');");
& ?) p% c4 {" j) k' m
}
9 `- B3 ]8 B- K( n, R4 d5 i @
7 y4 ~5 C+ R0 O9 \+ z$ Y) D
}
6 C" A, f) N! s7 G3 ~8 E2 a% z
" i1 i; L& e n1 v
}
# B# R5 x& X! F3 R
" ]1 t2 ~" T7 I
$InitForm = InitForm();
% h- e. d' }* c4 C
$Listener = PostListener();
6 B& {5 a& [& A4 u. u
% U# _. a4 W4 V. Q+ |
?>
! X; T9 c5 }7 H! l5 u# ]5 G
1 H( L. f# B! [" g3 C# k
, v6 H3 l$ w. z& n) X0 P) u' d- K6 X1 i
$ w4 p$ I; ?# ]! G% Y
) x/ S! x1 n: Q; q9 W/ S
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2