飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
& l3 F8 g4 p" o, _; q
function Connect () {
. p% _3 T2 g4 O
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
! d8 ^9 a7 r5 E1 ?4 l3 [( y
9 n7 R8 {+ i: M8 i$ x. K
Failed.');
' v$ J! ]: r" S8 }) a$ T
}
: c6 v+ q4 ~+ _$ A+ {; h6 p$ [! @
Connect();
$ j' S* o5 W- [$ p. Y( H
& o% ]6 K. J& U% s: P3 L$ \: M
function InitForm(){
" W6 X0 `9 k4 a
//layout for the form
- S* h% y7 b2 j+ A' f
echo "<strong>Send Items.</strong>
" B: s7 B5 T/ U/ ]' W, |: Y
<form name='select' method='post'>
9 q) _7 d. u- n2 `; f
<lable>Character Name</lable><br/>
/ j: q" J( j4 P/ b4 _
<input type='text' name='char'/><br/>
4 ~/ v" o. N+ h6 E4 c: d1 H& ]
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
# W' c* c; Q& y" K$ }) q
<input type='text' name='item_name'/><br/>
0 a# x, ^# D! B9 d+ y( m
<lable>Item Amount</lable><br/>
8 b% h5 \. y- K' G( `( d
<input type='text' name='item_amount'/><br/>
K/ \, L! k2 R: {( N, X% x
<lable>Item Upgrade Amount</lable><br/>
! C' V3 U$ R8 W( b0 y/ [4 Q
<input type='text' name='item_upgrade'/><br/>
0 X. C5 ?) l# l' v4 Z8 m) T) k
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
8 }% F3 }( O: Q; L' p' a, Z t3 \
8 w% S9 [ ?2 Q: l4 V( s4 S
</lable><br/>
% X" M# o, i, g4 D
<input type='text' name='item_element'/><br/>
) i4 l7 {& `9 h
<lable>Element Upgrade Amount</lable><br/>
( q. B1 s7 l7 W9 W+ r. `' J
<input type='text' name='element_upgrade'/><br/>
( @: m3 E( ?" k% T5 c2 E8 w9 u
<lable>Pierced Amount</lable><br/>
! @7 B) j4 ?3 Y6 G" r
<input type='text' name='item_pierce'/><br/>
# B! O" e9 H1 R& C% g3 C) M# x9 c
<input type='submit'/>
) J$ f2 B v* s3 X( m' Z
</form>";
2 E4 j. `4 r7 w" \ `" g' G
}
0 l' E/ z; G! L( r( g/ g
; H2 p9 Z5 P8 j: Y" L2 q
function PostListener (){
# z L- ^2 r1 Y4 w. [( N: I; e4 _- ~. G
//Add more post variables if needed and add them to initform() function aswell
4 Z4 d$ V. U, r4 M
$ i- D1 W3 s# H$ E
################################
) ?( G* l$ ^5 E3 X1 b1 Z' m2 n1 L7 e
##### Connection and Post ######
) S3 n, O- m+ t. G' Y: N/ R
################################
7 G" b1 l4 x4 b' v
$name = @$_POST['char'];
% X* t. F9 g* ^3 s6 @
$ItemName = @$_POST['item_name'];
+ I4 [! M4 }' `( [2 h
$ItemAmount = @$_POST['item_amount'];
+ I- f4 X6 A, ^$ K7 h; p# ~
$ItemId = @$_POST['item_id'];
9 Q. Z' W3 @+ u3 M0 c- w5 ~% J
$ItemUpgrade = @$_POST['item_upgrade'];
! h, C0 E3 i3 r" K" u7 S$ J
$ItemElement = @$_POST['item_element'];
2 t/ y/ \; d, E n
$ElementUpgrade = @$_POST['element_upgrade'];
& X7 G9 {, Q8 h$ \, R
$ItemPierce = @$_POST['item_pierce'];
6 h" [5 o" c% I' Q2 |, u! o( w7 m
################################
' y! h6 ]. S; m- T) p
; U4 w: U4 s' j" r
//Check both variables for empty value
2 N8 ^! N8 X+ X, b9 }7 N9 |: c
' d4 l6 ?" }4 N5 _* O$ S4 o
if (!empty($_POST['char'])){
: G5 V8 r$ b5 N0 N
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
- ?) u" h8 I! o6 o' G3 P
. y, r4 [# A1 |, h$ x; n
m_szName = '{$name}'");
( t; |. Y, ?+ [# U
while ($row = mssql_fetch_object($find)){
' W) q4 H6 o9 i: _
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
. ~. P0 s2 Y% J2 o8 _# j0 X
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
& l1 o. W8 ?" f# w- u
6 G/ @4 U G9 K
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
5 A% X+ B' |5 O
6 t$ ]+ ^) ?/ |* d$ g+ D7 _
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
: E5 b7 K0 ~' u
( Z. E; @8 d4 g
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
" ]1 o) i ^, _( [3 \( `
; o- u, r/ Q+ n0 q
'{$ElementUpgrade}', '{$ItemPierce}');");
" b+ a( k, U+ X5 v# F
}
/ e2 ~0 f, C; i
! j- W4 J4 q$ |8 P9 V- }& Q6 ^
}
( \# g6 b# k, J$ d9 }
' F0 c$ {* d: C
}
?" {1 S7 `) m% E- E# ^+ W
1 m1 T9 G, H5 ^8 r5 O
$InitForm = InitForm();
3 Y4 }# H4 D/ H& i `7 _* r) I+ z9 U
$Listener = PostListener();
+ \6 O2 M1 w% D4 Z
- q- ]8 P; Z7 U/ ?
?>
, Q6 t* |; _, j, ^
: V1 S1 _' z' s j
# O/ ]' | y$ K
% J/ d( \# j9 y" `) p( Y
# p" O+ T# {7 U9 {/ o/ a& F# j3 |
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2