飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
5 Y/ A* R9 T/ ~4 M1 C: H9 ~; F
function Connect () {
2 p* V1 a6 K+ {# P1 I6 I
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
- A9 W* ?. C& E
- R5 W2 z# A* W) f' o4 S
Failed.');
2 t; \; p% Y0 T3 @9 h7 z; R5 y3 \1 q
}
# t! i% t5 a) f9 g
Connect();
" y/ ~+ R4 ?6 T8 q! g# F
9 E% p/ L8 C' E7 Q4 X9 p
function InitForm(){
$ k h" `4 b5 Z3 x
//layout for the form
' h$ e5 N! ~8 E% ]% H
echo "<strong>Send Items.</strong>
9 v/ T$ u- m @4 ?6 G2 N [7 {+ O
<form name='select' method='post'>
% p6 C! O2 z6 U8 |
<lable>Character Name</lable><br/>
4 ]/ S9 F% x$ p3 m% r4 j8 S
<input type='text' name='char'/><br/>
$ ^$ `; U; j& u* m9 q
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
9 }/ S- |3 y1 w
<input type='text' name='item_name'/><br/>
3 N _1 i* N4 m- }$ O* k
<lable>Item Amount</lable><br/>
0 h% g# O6 ^- \ I/ G; c" x
<input type='text' name='item_amount'/><br/>
+ i/ k+ h# T* h1 w1 y
<lable>Item Upgrade Amount</lable><br/>
- C8 h3 q/ v6 u
<input type='text' name='item_upgrade'/><br/>
# g/ a) p/ I# {1 N2 ]2 A
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
* n9 R4 c" [3 p+ v- h
* w+ z# O+ O6 Q, {
</lable><br/>
, F" x% A! }5 w$ Q
<input type='text' name='item_element'/><br/>
# }2 m1 _4 t& f3 s- y( I, B* I/ m
<lable>Element Upgrade Amount</lable><br/>
9 d; s0 M; f3 ?5 l5 k& Y1 `
<input type='text' name='element_upgrade'/><br/>
3 [) ~& b" P( P" ` r/ W7 Y
<lable>Pierced Amount</lable><br/>
- ]2 A* Y! v4 Q4 X4 ^! E
<input type='text' name='item_pierce'/><br/>
) B, ~1 a; m4 H
<input type='submit'/>
2 T* n2 w6 N) y/ E. z3 ?
</form>";
1 r- C, o; Q$ C1 D
}
$ l' T& ?1 f. C! ?; p
0 w7 D$ y1 N7 C* d9 O% w
function PostListener (){
" l L+ |( z, J- \4 M+ b
//Add more post variables if needed and add them to initform() function aswell
0 t8 V% `" _: f, x- [( M& T4 \5 Z) z
- [4 u; r% W$ N' f
################################
8 I& H" j9 Z/ T! Q- b
##### Connection and Post ######
6 c& x8 b/ N7 ]* e# g
################################
! Z0 T/ J$ n8 a! R- `6 D/ W5 J, R: W
$name = @$_POST['char'];
* r3 U1 b8 S e: Y, |4 p
$ItemName = @$_POST['item_name'];
d, V! q5 t, k1 g/ ~: H0 o" B
$ItemAmount = @$_POST['item_amount'];
: `: O: ?# ?$ f3 S+ s
$ItemId = @$_POST['item_id'];
+ G/ `9 I' g8 h7 }( r
$ItemUpgrade = @$_POST['item_upgrade'];
8 R9 P+ i+ ^, e. i5 a& ] r
$ItemElement = @$_POST['item_element'];
: w! {$ a) R6 \6 u
$ElementUpgrade = @$_POST['element_upgrade'];
% ~ ]8 V1 g6 D) v" _7 R/ N: E
$ItemPierce = @$_POST['item_pierce'];
O. m& p F7 m! l, m3 u$ U
################################
4 A" e8 T4 ~ s( m2 D
/ _) B% G8 N: J+ y
//Check both variables for empty value
, u+ v/ U( D- r' C0 N% K; _
: g t+ a0 D0 j
if (!empty($_POST['char'])){
! X, Q+ s* O1 N& J1 K- n9 w
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ F$ Y& J9 g6 t
8 q) E6 P1 F' K* L7 U' N5 H: S
m_szName = '{$name}'");
8 ?# P' G/ Z+ \' A& M- g% S* I
while ($row = mssql_fetch_object($find)){
5 u7 y* q% |# B8 E3 O* B
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
3 G7 n* f% m8 ^9 }9 h
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
3 G7 [( @& p9 Y+ Q
: a. f+ J* u$ |0 c- r& ~( ?
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
0 p: {5 t/ m B/ u2 [+ k, m. j8 b
7 ^) e% ^/ A/ K0 |. y/ {6 U' _
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
& X2 I5 Z. V) O7 P+ z
+ }" ?. D8 Q5 y- g0 Z- V* Y ~
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
6 K- f# b. `- e9 U2 d
+ b* g" | l9 @" Z' \+ ^
'{$ElementUpgrade}', '{$ItemPierce}');");
7 q3 r1 y' I" H% n& {
}
) h$ ]! D# ~& B) S4 f' M
7 G0 T8 T; L+ ?: ~0 q7 y9 D
}
- ~3 ]# V9 n7 p& ^
1 D6 F0 {& G0 m* t8 }) L
}
8 Z$ J, i9 r* z9 y4 x. N
% ^3 k% u8 R% I# ]# E
$InitForm = InitForm();
1 }4 s. {# C' {) j
$Listener = PostListener();
1 P1 F1 S: q' B0 c. b; J3 C
; _1 V9 c& B0 b) i2 E
?>
: u" ^5 T v$ {& m
- I6 k, ?, ?) n2 F( u
4 V+ e: p o. m! @
; ?7 D& d3 B9 M: x
' @% N% Y9 t% M
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2