飞飞世界论坛

 找回密码
 立即注册
搜索
热搜: 活动 交友 discuz
查看: 13898|回复: 0
打印 上一主题 下一主题

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
; N$ R& D) C  _$ |9 jfunction Connect () {+ k$ o  g7 d9 p7 |7 U/ C
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB ' R4 s9 Y" J- x- O
7 V' s) c6 X/ f, j/ o
Failed.');; M1 }+ I) U8 P* X: m* W
}1 @( }% f& C9 v) ]
Connect();. S: M1 g# a& K

3 `, a# l* A% Cfunction InitForm(){
9 ~3 ?- M8 z, Z$ N* R//layout for the form
& G" `' M1 d' C& decho "<strong>Send Items.</strong>8 ?* s- |/ X7 l; d  b  c: Z
<form name='select' method='post'>" Q, Z4 d' X" }2 |- r4 Z
<lable>Character Name</lable><br/>
' H4 W4 g/ ^3 ]( K<input type='text' name='char'/><br/>
; y& l: v2 u8 e0 `  K2 P<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
7 i( m' c0 ^! L9 ^. N: u<input type='text' name='item_name'/><br/>) ~& x0 d7 E: J0 f: W! X3 E6 x( k
<lable>Item Amount</lable><br/>
& g8 k- [: l) u7 h<input type='text' name='item_amount'/><br/>
$ G# c+ g+ i8 @: G" ~<lable>Item Upgrade Amount</lable><br/>* Y' s& B; x3 e8 G3 A; O
<input type='text' name='item_upgrade'/><br/>5 b# N+ t  q! @# @2 [
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
* i! }# D0 C0 D/ r) T2 T5 F* [/ u4 ?+ q+ p3 j, G) V/ `; b( N9 @, A
</lable><br/>
7 I8 N8 d; R  `' \  l2 O<input type='text' name='item_element'/><br/>
/ V" v0 d7 V  p<lable>Element Upgrade Amount</lable><br/>  m7 w4 `& l! R7 R2 f
<input type='text' name='element_upgrade'/><br/>
' Q6 T+ \" ?+ X<lable>Pierced Amount</lable><br/>) Z" @; k( v' V; ^2 d$ v
<input type='text' name='item_pierce'/><br/>
& w: r) v" A4 l" ~9 F& f; P! R2 q, h<input type='submit'/>$ t/ z* n5 j; g; d4 r
</form>";
; d" N3 y4 d3 U* l/ r: A3 u}
) N( F/ c+ g6 q/ X+ t5 s$ Y0 _6 c6 Z+ t7 q7 P$ |9 b
function PostListener (){
  J$ w( N: ?0 @, L8 I' T//Add more post variables if needed and add them to initform() function aswell
6 R- j5 W7 [; `" |0 C' \0 K
) s0 Z0 w( A4 c* c( z8 O* t################################
$ L8 q' O- M8 E* c, h5 {/ V/ g# ~##### Connection and Post ######
2 L( S$ h! L7 ]################################. Z0 q" o$ R( R. P  O3 l
$name = @$_POST['char'];
0 f+ }+ @+ e" R$ItemName = @$_POST['item_name'];8 |( X2 E4 v  I2 L
$ItemAmount = @$_POST['item_amount'];
# F/ A0 x. p4 t% f& w/ l& l$ItemId = @$_POST['item_id'];. m. {9 _; G7 o! ]
$ItemUpgrade = @$_POST['item_upgrade'];
! [) b2 v7 }0 |, Y! v  W$ItemElement = @$_POST['item_element'];
% U' i' R; |% y# Q+ O" e$ElementUpgrade = @$_POST['element_upgrade'];# @$ l: v7 Q: q& a; j  P
$ItemPierce = @$_POST['item_pierce'];
- h1 l- z! d) \- W% p################################
0 O9 Z: y- S  @+ X: ^# O  e& N6 G7 M$ }% Z; z3 u
//Check both variables for empty value
7 x- m; o' y. U( w, p& p9 q2 W
" {/ `4 @8 D' Y2 f4 x% S; q0 @' t: Qif (!empty($_POST['char'])){
& \9 R% R4 {: n" i$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where . d) u$ E: g6 w9 e. R4 t4 j* r, Y

: r4 u. k8 j9 I. U9 dm_szName = '{$name}'");8 d# ?$ s, x0 s  V
while ($row = mssql_fetch_object($find)){7 ?  e: ~: v/ d: m* M: x7 F
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";7 f7 _% a. Q( G3 F" j
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
2 F/ x8 t# m1 f$ R  ~- z8 \5 y4 U: R0 r7 k9 Q
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
( C' q9 H3 K) n) }$ u1 B  l: v5 L  e5 I7 v
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
$ W" b* I) g9 @# U1 I4 ^; Z1 l, o- `6 F; Z. f: p
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& O: R" d4 {8 V- j
  F% }. I* n% ]'{$ElementUpgrade}', '{$ItemPierce}');");6 [# L: w' f* b1 Q  @+ @8 K% t/ m6 B3 I' F0 i
}  V4 `3 {% m4 ^$ ~1 U/ S' \
* Y9 u- L  S+ o" s
}4 K# r+ m( t4 N' T! u

; k8 y. m  h$ U  w% X; u}. x  B! p0 }4 J, P0 p
( C# G3 r+ h6 {$ |/ t# q
$InitForm = InitForm();: W' a$ W& d+ Y' z6 w0 m5 C! f
$Listener = PostListener();* B* R. R- i7 H+ g7 ^% t
) T* B$ ?- G4 P4 L; m
?>0 v1 Y( I& w! H
, t9 \" {5 S) ~8 t7 ^/ [+ S

- X4 |9 B" \/ Q6 x6 k
6 K' a9 |: {! o) w3 R5 i/ t
, n  E* u) r1 d' k# u: v
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|飞飞世界技术论坛  

GMT+8, 2025-12-1 17:37 , Processed in 0.063393 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表