飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
1 C9 k# N4 [) v4 L$ r
function Connect () {
' L/ o- h5 X. J7 H
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
4 ?1 H9 s4 D3 R y. j
7 K5 E9 k3 A; ~- Q4 d
Failed.');
6 `; a, D1 a5 M! S* V, r2 [( l
}
N/ Z8 V% L4 k
Connect();
7 X3 n& o/ F' j' \' w8 v! a
+ q# h! T5 L% L+ Q. N
function InitForm(){
* _6 c# E5 r) p2 v8 R* |5 B' L B. o
//layout for the form
& D$ b, e4 H. ]( c7 q7 B
echo "<strong>Send Items.</strong>
6 j: o# N( Z- Q' F( ?
<form name='select' method='post'>
* U9 b! C( x8 |4 G3 d9 O2 v! q; U4 Q
<lable>Character Name</lable><br/>
0 B4 F3 g, X k) ?; {8 f) I
<input type='text' name='char'/><br/>
" ^' _% P2 }/ O% b& {
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
/ a3 p# h7 P8 Y" R4 R* z/ U9 R
<input type='text' name='item_name'/><br/>
& j$ ]% X7 G7 f, }" ?
<lable>Item Amount</lable><br/>
# }" F8 C) b' `4 c9 ~
<input type='text' name='item_amount'/><br/>
4 G8 a/ ]+ d. [% f
<lable>Item Upgrade Amount</lable><br/>
& a# ]: F; c1 J- i q
<input type='text' name='item_upgrade'/><br/>
4 L: R$ \& N a6 A3 m6 d
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
+ a5 D; W& D7 c4 o" L5 w2 `
4 ?$ \* f1 l* k& O1 a% e4 t
</lable><br/>
& H0 n0 G; O4 h9 d+ l
<input type='text' name='item_element'/><br/>
1 `9 B' o' O, A6 e' s' c
<lable>Element Upgrade Amount</lable><br/>
2 I% @5 j3 k- Z6 y; r' k, o2 C
<input type='text' name='element_upgrade'/><br/>
1 O2 ?: x6 v E6 O
<lable>Pierced Amount</lable><br/>
* g8 {. b& k" G- i
<input type='text' name='item_pierce'/><br/>
2 u9 z& k: X! F7 w9 W8 |
<input type='submit'/>
0 o- m+ b" k3 {
</form>";
* |% q0 R) |" K$ i1 Q+ `3 j0 Z
}
# u9 v3 B" s/ i3 ^2 N* C3 @
0 q" \2 S7 c4 R* q K V& I' O
function PostListener (){
- J* `' C* [ `/ w7 x+ E
//Add more post variables if needed and add them to initform() function aswell
8 R4 {# v7 i2 p( @( x
6 q; V4 G8 Z9 C. x- Q I! E! ]
################################
, |: q5 W8 ?8 S" Q- { C
##### Connection and Post ######
6 m% s5 j9 a: H
################################
& i) i' v* l( e9 {. j8 i4 a' I
$name = @$_POST['char'];
% t$ M) _5 ]. ^, i
$ItemName = @$_POST['item_name'];
- _) R' u E, p. F& g" V- }1 b0 Z4 K
$ItemAmount = @$_POST['item_amount'];
- l+ n/ \7 z! Q7 ?
$ItemId = @$_POST['item_id'];
' @: \2 S& h4 m2 g+ Z9 J* o' M
$ItemUpgrade = @$_POST['item_upgrade'];
1 I. A% i7 Z5 Z" B7 a
$ItemElement = @$_POST['item_element'];
4 U/ h1 j& s* N+ K) I' H4 I N
$ElementUpgrade = @$_POST['element_upgrade'];
5 e. p' Q+ l# p6 ]: C
$ItemPierce = @$_POST['item_pierce'];
2 y) D9 [* K0 S. [9 a
################################
; U6 V' V9 U) C. O3 j2 n
0 O% h; Q( `, N8 a# O0 B- ~
//Check both variables for empty value
/ Y. K" K) X2 ]! s! n+ v+ c5 C0 b
. b' n P* h; \6 B
if (!empty($_POST['char'])){
/ Y# z! t7 w x( O6 c# A
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
- Y a$ b9 c4 G t4 f2 z0 {9 A
6 J. l4 z3 M: ]" j2 A# l
m_szName = '{$name}'");
z* A7 U4 u7 s& a7 `
while ($row = mssql_fetch_object($find)){
* Y2 w# p6 \3 N5 N
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
* D/ v" o; v( ]% L$ J
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
9 k% o- `; j+ w- i6 ]* c
7 Y4 N1 F* F2 M, i# E( F, E7 k1 S
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
8 n. [# D1 C2 }' |% Q" c
% @% t6 W% r9 w+ ^: @* p$ B
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
- q! X! J @! }2 A" r8 Q& ]9 a$ j
C5 l ^+ [9 c# ~% z/ }) A* }: V
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
5 j3 a; E4 _, W- U0 T1 Q4 \! V
3 F* E- g6 m o5 |
'{$ElementUpgrade}', '{$ItemPierce}');");
5 L# ?! ?, A, X9 D
}
) Y: R7 {6 i |
2 M7 z. k# Z8 |2 b
}
: f0 `& }" U8 W
, }0 `4 j3 {0 E z) i4 E
}
! Z" @& A. N2 t* a0 r! z8 a9 u
; i' a# ^( U* l
$InitForm = InitForm();
+ h* }3 T9 C$ m! M# D% d. |
$Listener = PostListener();
0 A, K8 U- [& O8 u6 @3 a* B" [
* n3 t1 I9 s; [) ^2 h' n% E
?>
& k0 Q: m3 C0 n
9 p3 `8 L3 |+ W- {
7 R) j) t+ r5 p0 ~' t, d8 f$ ]0 [4 A5 I
* p" X5 @( d5 W( n* @
4 t9 t3 g7 w- j ?
欢迎光临 飞飞世界论坛 (http://ffwold.com/)
Powered by Discuz! X3.2