飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
* @( H- ]2 n: E# K- ~% t
function Connect () {
! i7 i5 T6 U7 p ?: q! D
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
* x* r$ d: E% o& ]) n% n/ F. { U
3 r5 D# H) C! B7 W& a
Failed.');
0 w4 h+ I$ y) t, a" C( M; ?
}
& V0 R( T& V8 B* N U
Connect();
0 D0 c1 Z: u3 e3 b$ n& w
% B* v, N1 p6 \, l! l! ~
function InitForm(){
4 o* m7 m4 C, `7 e
//layout for the form
4 [2 c6 F3 S' s
echo "<strong>Send Items.</strong>
. O" Z& E" q# ^
<form name='select' method='post'>
, a; M6 N. Q) D M
<lable>Character Name</lable><br/>
$ p% }" x$ h$ }" c) C4 X) | \
<input type='text' name='char'/><br/>
0 W/ ^9 ?) k" j O
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
* s. {( n/ D: ?" Y4 g9 F
<input type='text' name='item_name'/><br/>
" k5 h% w# p& U9 m) b
<lable>Item Amount</lable><br/>
4 c% E! m# s5 |9 P8 @6 v
<input type='text' name='item_amount'/><br/>
1 H. E/ {+ t: q; g
<lable>Item Upgrade Amount</lable><br/>
1 t& T E0 O& ]8 y* k6 i. ?7 C0 o
<input type='text' name='item_upgrade'/><br/>
o: @0 g2 l4 v/ N O) k+ p. }
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
( |5 E H L# H4 {* s
" G& q/ s/ V4 l) r; A2 d. B" K
</lable><br/>
2 ?+ W1 Q' U# I# P" ? H
<input type='text' name='item_element'/><br/>
- V% ?- s" I* P- g( S
<lable>Element Upgrade Amount</lable><br/>
9 ^; z. X1 ~$ R/ W- O8 a+ @: g
<input type='text' name='element_upgrade'/><br/>
1 N2 X% i' F8 M- |' G, c
<lable>Pierced Amount</lable><br/>
- Q) A, q, ^7 Z- X
<input type='text' name='item_pierce'/><br/>
9 j+ m1 M1 A* Y$ A
<input type='submit'/>
2 y6 A5 j0 b; K9 J* B
</form>";
! m8 h/ u( j+ R; `, h' T
}
% V2 a$ N2 B3 t3 w6 a" ~
& A% m: o6 ~$ L# ]# x- Z4 ]# B
function PostListener (){
2 C# e: L6 A' o5 g
//Add more post variables if needed and add them to initform() function aswell
# G2 Q* d# ^" n7 Z
: @, P; s: ~9 m! _# c7 z
################################
# D# n& ^5 U, {1 x3 b
##### Connection and Post ######
: |% h3 v; l2 J* R, {6 o
################################
S) T: n" Y5 e7 s/ m1 l
$name = @$_POST['char'];
4 b7 t# |- T6 G7 J+ g; A" U
$ItemName = @$_POST['item_name'];
5 l8 P0 Y" n9 F: w7 ]
$ItemAmount = @$_POST['item_amount'];
/ e0 z1 m' x+ A- {
$ItemId = @$_POST['item_id'];
$ V9 P2 ^0 J4 _/ v
$ItemUpgrade = @$_POST['item_upgrade'];
8 ?6 m1 j2 \9 a& u; o, P
$ItemElement = @$_POST['item_element'];
3 G' w. W$ u! \( U$ x d
$ElementUpgrade = @$_POST['element_upgrade'];
$ @$ e2 Y; O0 {% N# }0 a$ i6 ?3 j
$ItemPierce = @$_POST['item_pierce'];
9 e8 I4 Z6 q8 L; N; t
################################
- s) C6 _5 D! i% D! t+ }& f) l
& ] Q9 `$ q" b+ m! m2 P
//Check both variables for empty value
7 B4 @6 L- w: D( [; D9 X
0 a+ G$ p. `) ^3 b: } C& l1 }+ v
if (!empty($_POST['char'])){
+ k2 y0 ~* h w1 g
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
- K; D1 ~' }0 I3 ^2 N3 M% \
, l- h+ a2 p' ]
m_szName = '{$name}'");
0 j2 `4 B. D3 m# m2 |; q
while ($row = mssql_fetch_object($find)){
- s$ |" R( j/ H# c* R
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
8 k6 M$ g! t8 a
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
) ` j8 p9 M# K8 Z" H
# k7 D1 h2 q; ` N; O# n9 }* X- b
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
$ ]5 |. m; v. C p* v
; @! l4 S. G+ A2 B6 Z
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
! B1 z( n9 I2 u& O
; x" |1 l2 U: W6 n( H
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 C9 n5 O+ b% `
- H& s. \! O- p7 v* d0 v7 o2 N
'{$ElementUpgrade}', '{$ItemPierce}');");
5 B* F1 z- i) R9 i$ C4 M/ C
}
3 m* C! p b5 X
- _; |8 |/ S# J; u2 v- G6 Z9 d4 Z
}
% j5 T M4 F c, q1 [ q1 |2 C
% t4 @1 x9 t, h# e: [* O
}
' e k% L2 O5 c
, _0 E8 {# M2 A7 h7 }7 I
$InitForm = InitForm();
' q/ m5 s F2 Z" l( _
$Listener = PostListener();
N! u% R- g) O6 R4 d# k" y
J+ V3 k6 D8 {& w+ u0 n/ h
?>
; Z: U3 q# s$ ]4 @3 m0 J- v, z
) w* A! G0 B! P; |8 q+ r
0 x I$ D) L7 f6 [4 T% R
5 X3 ~4 |/ ?0 L, q' c' V' J, ?" W
. y5 ?0 G8 [( `# o- D) G
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2