飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
% j% N; z/ L- c: ]: T, [- R7 p
function Connect () {
2 a: d" i/ `9 N4 w1 G9 c
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
1 t( b5 a; m6 Z: c
2 L3 y0 G, t3 {( P0 a
Failed.');
' C: p- m' K0 b5 E& A& Q* T+ q
}
: V& p: {+ C& x0 a
Connect();
, `. \6 ?' l2 I
) ], B3 M, ]9 `
function InitForm(){
6 I8 P: f0 s$ o: u8 U$ t
//layout for the form
# o+ \9 S6 S) z8 b+ k8 g6 u% P3 I
echo "<strong>Send Items.</strong>
( {# @4 m! @+ Y. a8 M* a
<form name='select' method='post'>
9 Z1 j$ Q/ U, k9 ]* R6 f: Q9 m
<lable>Character Name</lable><br/>
$ t! a8 C, A. }2 E3 P6 O
<input type='text' name='char'/><br/>
9 g& Z4 Y: ~, {, E) j
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
$ c. s7 ~* w' c# x6 L* G/ r
<input type='text' name='item_name'/><br/>
/ v) G( q/ I8 T; e0 G1 E
<lable>Item Amount</lable><br/>
* X( D5 { D5 J! [- v; ^* A6 O
<input type='text' name='item_amount'/><br/>
- ]0 w8 O R" K* l
<lable>Item Upgrade Amount</lable><br/>
9 D) Q6 A7 ~* | ^" Y# O$ B
<input type='text' name='item_upgrade'/><br/>
% W& P, S$ T( `7 N7 X
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
) a3 L: L4 ?- i: O6 ]
) @8 ?, g5 x9 ^: F. X
</lable><br/>
* \* @/ D% x3 x& c* u
<input type='text' name='item_element'/><br/>
! d& F8 L* f: U! ?1 w8 u
<lable>Element Upgrade Amount</lable><br/>
/ `/ X3 ?5 Z' F4 ^. a6 z7 P
<input type='text' name='element_upgrade'/><br/>
# J8 u% P9 g- \1 G- {# d
<lable>Pierced Amount</lable><br/>
4 O |2 b. \; L' I3 ^
<input type='text' name='item_pierce'/><br/>
# ~$ k7 ?& ^( r- f
<input type='submit'/>
: N6 d# c% @( Y* Z
</form>";
1 a2 I% X1 D; G8 {, z
}
" O* S$ x% H: W' t4 u
" |6 h7 O& _7 Q
function PostListener (){
) a8 Q& S+ |& ~0 p% ]# P8 {
//Add more post variables if needed and add them to initform() function aswell
% N: ^* o3 q S
$ D* e% R0 V( i/ V9 F) w! W
################################
0 C! Z) X' F4 \, p. w3 v" }
##### Connection and Post ######
, V) d- @+ C% t& ~+ ?# k/ C- B2 D
################################
/ P+ O/ e/ ~# W7 L% Z4 ~
$name = @$_POST['char'];
- w3 T, e. |9 {# ~% q& a
$ItemName = @$_POST['item_name'];
/ Z% ~, k- r: m) R
$ItemAmount = @$_POST['item_amount'];
, _1 E4 U* E' I: V
$ItemId = @$_POST['item_id'];
4 J5 l" d* C2 h
$ItemUpgrade = @$_POST['item_upgrade'];
* e0 ~1 {9 ]3 S& ~
$ItemElement = @$_POST['item_element'];
2 x2 B$ w& t. k3 e* e
$ElementUpgrade = @$_POST['element_upgrade'];
' ^7 ]9 _6 N* X* i$ Y: E7 d
$ItemPierce = @$_POST['item_pierce'];
% K! L/ z y! W, X
################################
# S$ o: b6 C- \( s8 X$ I
$ H0 N8 v! V$ p# r; H+ z
//Check both variables for empty value
8 _: d0 V* F1 o+ D# n' g0 q# l
! N& e8 `1 s# J; g6 E5 w
if (!empty($_POST['char'])){
" [0 A* @9 V ~! F; h
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
7 M' ]1 V$ L! ^+ I" p7 g7 D, N% `
" {' c9 L7 \+ p5 C* D
m_szName = '{$name}'");
0 |; C( f3 P8 |- }, D7 u
while ($row = mssql_fetch_object($find)){
# b/ T2 C- y& b) `8 J( d
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ G+ u4 t* r1 X! y+ m y9 m9 u
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
# W. F& |( ^# }* r& K; u
' x& q& w: ^9 {+ X2 ~
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
% R1 k o5 H- R( l0 ]& l( ?
/ p! h1 x0 X$ w( o8 m
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
$ o( }7 }# {0 c& G, N. H
" x1 _& T8 o$ m$ w7 x
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
# t1 P8 a6 v7 e( ^
1 A) q! Q7 s8 V" M, A/ g3 m
'{$ElementUpgrade}', '{$ItemPierce}');");
; G9 i/ O9 F9 b! N5 Q9 a9 U
}
4 Y5 h, f3 Z' Y2 w0 P" N6 l8 D
) ^/ [+ D+ S+ W$ F" U7 d$ @3 F" X0 ~
}
$ X' U- f; i, p
; U4 T; g6 y* X5 O0 ~
}
0 l% `) V, R- ~( s: t
: h( t$ }+ @2 l
$InitForm = InitForm();
9 r6 T+ S$ T" e. U/ y# s$ {8 Q' ^1 r
$Listener = PostListener();
) o5 D) M# ]" r5 p
2 E1 H4 p: C4 F* G. t$ z* Z
?>
% o1 n: A6 z. \
4 i5 W1 ?) N6 J4 n4 X# g% Q; e
$ r# W: d1 J o
0 e) b' z, l6 p# ?8 ?; {0 K
: a( e/ q' |6 }# \$ V) S) o
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2