飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
. r* `) h. X4 ^& g+ `
function Connect () {
! L$ i- H" Z# N
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
: {% t, D; G; E' p3 I6 S; ]+ ?
7 o. K! y2 \$ P: E) Y
Failed.');
" @* p1 D& f4 J j9 ^: C# g
}
5 b6 K7 k4 o1 z2 Z* A
Connect();
1 @, z" c1 A Y: o1 w
# M9 b) f* i, y) M% w
function InitForm(){
1 B! Y9 R& Z4 I# J5 a
//layout for the form
$ U4 W2 Q/ A% M3 q9 x2 E# M
echo "<strong>Send Items.</strong>
$ W1 u+ @( u( ^1 f- H
<form name='select' method='post'>
: u* q. b ?3 y: z4 G
<lable>Character Name</lable><br/>
: W7 l3 H1 V% R& A2 i
<input type='text' name='char'/><br/>
! [) I8 }6 j6 r
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
& G; G. t* z/ j( T
<input type='text' name='item_name'/><br/>
! A/ f4 A& f; u! ~
<lable>Item Amount</lable><br/>
" s, D( e* a3 X- l" J6 X' f
<input type='text' name='item_amount'/><br/>
7 z, }/ }) k" r
<lable>Item Upgrade Amount</lable><br/>
1 q$ N/ R/ L3 H6 i v
<input type='text' name='item_upgrade'/><br/>
4 l# G( x2 Y& y% o) d4 B5 s
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
0 [' P5 k$ u; J5 n
" t: A9 q7 x' U
</lable><br/>
: e7 K8 y0 ]) y. E
<input type='text' name='item_element'/><br/>
; _) G# T. \" I5 E4 q
<lable>Element Upgrade Amount</lable><br/>
; X5 Q8 @; R9 U6 S" e! {# B$ M4 w! {
<input type='text' name='element_upgrade'/><br/>
: P. e- V6 x' W) q
<lable>Pierced Amount</lable><br/>
. Q; u2 o- l. _7 ?3 b6 Q% l
<input type='text' name='item_pierce'/><br/>
/ |" z$ n9 W. X5 x8 P- a6 z# [
<input type='submit'/>
5 x7 h7 `1 |+ m5 n' e+ x
</form>";
- S( [) Z: Z- p& |) ~9 h' W
}
/ y/ ]5 C( M0 E
, k# D( ]; Q2 E
function PostListener (){
. W% ?. ^# S& p" R9 F
//Add more post variables if needed and add them to initform() function aswell
5 S3 v; h! s G) Q: l
# w" B2 z" J$ U9 T9 ?
################################
1 x' y, a, A( L6 o
##### Connection and Post ######
# l6 B& B T8 y6 m S4 F7 ]/ }
################################
$ X/ }" D2 G* I' _/ e
$name = @$_POST['char'];
2 P4 ^. \" E. _
$ItemName = @$_POST['item_name'];
% o' f9 { v" [/ B
$ItemAmount = @$_POST['item_amount'];
- K5 p! X% l" @: F; q- z
$ItemId = @$_POST['item_id'];
9 b3 _8 \" \' b9 o+ ]- u, j' r6 j% u
$ItemUpgrade = @$_POST['item_upgrade'];
1 b8 g+ E$ @. y+ A0 S
$ItemElement = @$_POST['item_element'];
% z* Y* g) j2 P, i
$ElementUpgrade = @$_POST['element_upgrade'];
% C1 m' i+ c% K/ d0 a7 O) C6 K- E) u
$ItemPierce = @$_POST['item_pierce'];
9 \; E% c- F7 R/ [ L
################################
3 H3 B$ D" e# ^5 _/ O
* ~: A. [3 b6 V: N u2 U8 _4 _% ~
//Check both variables for empty value
" W! c! m9 ]( z1 I* J
2 i1 E, f4 t$ j3 f' k: l
if (!empty($_POST['char'])){
6 ]+ t# S& S" v, @% Y
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ K' H. O5 d/ g2 J, t# l
; Z' B6 N. i5 b3 [. E$ P l
m_szName = '{$name}'");
9 s& [* q) i" `# i
while ($row = mssql_fetch_object($find)){
' c! _# J6 d5 w0 o, b! k
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
. S* ?3 }2 g M' O9 G# k
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
8 X. @. v! v- I& {
' X5 v! a. o6 ]' V3 q* a( f4 K
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
1 @3 U" x3 _0 z
# o. p/ v" v, F9 j
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
, v0 A+ ]7 w1 B+ j0 D5 g
7 h& T2 n# C+ K2 W' M
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
" t9 @2 G J3 v& d7 f) {" U
; O2 ?! S, ~# T. u2 R) i
'{$ElementUpgrade}', '{$ItemPierce}');");
9 U4 N" m+ T- Z6 V+ I |
}
. K+ \# j& L$ o9 F/ D
* Y# J% K6 @: q0 w, E: \# x# l
}
' z. D/ `# Y3 v. n# j
: v1 B3 i( N' z* f$ v8 M0 ]' r# X
}
; X# j$ s& L7 a1 x( E
/ H5 P! J7 Z# I/ t: Z7 ?% e0 j
$InitForm = InitForm();
6 L* ?1 q4 i# U2 h6 h8 a9 M: _
$Listener = PostListener();
+ V$ T; ^2 g: {- w
8 N F8 J- ]2 M+ E$ ?' n
?>
' x; x+ w, E) A6 r, r0 l3 z( k
* w b1 a* |* |& Z( e
0 m+ M/ U+ }1 P, K
( o! f/ o. v p4 F8 L% }
1 N# ` `/ q- D( V4 `
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2