飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
6 p1 I8 G4 \) ~4 Y
function Connect () {
" Z5 C! m9 |3 d1 L( c S: T0 T
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
( C! |! b4 F* F0 s. D
+ c0 `, y% w2 o1 }
Failed.');
, r: u0 L6 M: y5 E; D/ e' A
}
4 s# J7 X9 n% d# Z
Connect();
& ^3 y. `$ e) ~7 s/ g" E
3 r( T: R$ _8 j" ?/ [1 ~
function InitForm(){
# O G# D3 D! @. X! n( a! C
//layout for the form
, U# q6 u9 B/ `( \8 u$ Y
echo "<strong>Send Items.</strong>
. U7 A' {: S9 u6 q
<form name='select' method='post'>
! |" m3 d2 X5 f4 y
<lable>Character Name</lable><br/>
i" c. g4 C- c/ |. h4 \
<input type='text' name='char'/><br/>
5 f3 P+ \1 o( \, I& V
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
! I; w/ ]9 G2 S& k# P
<input type='text' name='item_name'/><br/>
4 O/ H9 n) L( ?' p) Y3 B
<lable>Item Amount</lable><br/>
- l, ]8 T8 c9 C" X8 s0 p; c
<input type='text' name='item_amount'/><br/>
+ H& {$ Q* r. e% P+ g" o
<lable>Item Upgrade Amount</lable><br/>
( ?8 y* v: c+ A/ f# i% v m8 o4 A
<input type='text' name='item_upgrade'/><br/>
0 j- s2 O+ @# h* i2 f: a
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
8 k/ N/ @+ B/ R6 r$ L( H4 h
) P$ D1 U5 v9 k$ n; s: `
</lable><br/>
p0 ?1 S& F3 d* O: h, r* o) Q
<input type='text' name='item_element'/><br/>
1 Y4 u8 I) g3 F5 x# U& \# S/ I
<lable>Element Upgrade Amount</lable><br/>
# |5 A5 k% a7 V
<input type='text' name='element_upgrade'/><br/>
8 _: E/ a- c! g1 x& k5 T% W
<lable>Pierced Amount</lable><br/>
" I# p: t2 l u) ]3 ~% \1 r3 e
<input type='text' name='item_pierce'/><br/>
* ~! l% R0 m6 c8 }' y( s: J% b
<input type='submit'/>
" F: e8 k8 L# C; Z k
</form>";
7 G. C! i! S; I ~* e9 z* Y: S! E4 ]
}
V0 h. t8 X- v; d
# U& @ a: K2 ^) X5 G
function PostListener (){
- m2 ]0 m5 c% X# q- w3 Z
//Add more post variables if needed and add them to initform() function aswell
6 x6 t U+ y" \2 d0 _. E4 D
2 r+ P" u2 \' k( W
################################
7 g+ p6 ~# J. A$ ?$ y! r0 V3 q5 L
##### Connection and Post ######
8 X" Q! C: ] m
################################
3 u( Q8 l4 d, R6 l+ ]
$name = @$_POST['char'];
3 c3 A. M7 F) {3 V3 k
$ItemName = @$_POST['item_name'];
- d0 Z' p) v& l+ v6 i f# t) Z( [
$ItemAmount = @$_POST['item_amount'];
$ Q* a; W X2 c1 D
$ItemId = @$_POST['item_id'];
& |$ |# Q; ]$ z! f
$ItemUpgrade = @$_POST['item_upgrade'];
8 {3 B% ^, ^9 D9 c
$ItemElement = @$_POST['item_element'];
/ `: d, C0 L# C! S) y B
$ElementUpgrade = @$_POST['element_upgrade'];
7 a! C2 y$ S/ Q- `
$ItemPierce = @$_POST['item_pierce'];
6 v7 f% O" L z! ]" V
################################
5 X( I0 C' S9 d; k- ]- W
& {% R2 q6 m7 t7 \, @; E) k
//Check both variables for empty value
% V2 A, q5 w/ }6 i5 `7 Z' z
% V! r! s2 G: i& W
if (!empty($_POST['char'])){
; O! @+ O: @! ]
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
u% G$ Q# R9 [- w0 S+ y, n3 A8 x
3 B; @- l5 `0 U
m_szName = '{$name}'");
( o2 S5 `- O8 A
while ($row = mssql_fetch_object($find)){
; c% d# C5 H. `; x# {
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ j7 X1 R7 q* d5 N4 i
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
+ `( e5 J% }; i
% O: Y& V& G5 x
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
3 q$ U! a* D. E6 H
) X/ D, M3 n+ C6 I1 ~( K9 x
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% D9 D+ f7 Q3 ]2 O( W0 ^
$ Q s" B i0 k9 \ p( Z
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
s8 C3 p; O e* e9 i% b
; t1 S( y {5 h. t) p
'{$ElementUpgrade}', '{$ItemPierce}');");
' ], s5 S; e8 G6 d5 ^6 d
}
) v4 Z t/ N, C& h% `9 A" C8 Q
, W- h1 k# k8 p, A, D
}
( _& P' p/ n3 M4 x% H
. `; E6 \2 c- @1 t" j1 n
}
: ]9 |" _: i5 `. o$ G7 j) I1 x
6 f: q" L. a7 m! G( Y
$InitForm = InitForm();
. q" Z1 V2 @ |6 s6 w7 ]
$Listener = PostListener();
4 k) Y5 h3 p" H
& |. E: a/ Y9 O1 l# R, h' A0 l
?>
1 P! R1 D) ^& o' T i8 {
( b9 k! j8 j- t! [
/ G" _9 C9 z( J7 G+ T
, R* E$ `% S0 }& z( A; a* J9 e
9 t: C& @" b6 g
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2