飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
5 Y! _, Y# p( S0 }2 G6 ?/ O9 Ffunction Connect () {
  K% X  d) O3 K3 nmssql_connect('Server','UserName','Password') or die('Error: Connection to DB % L% d. k6 @, h5 u6 ~5 U
8 J8 f% Z; y) [( W7 p# E
Failed.');
. J0 N5 W- D% w! m! |3 Y}' O2 y; W. ]# Q4 q- p" x
Connect();
; X+ i+ f! R6 n3 Y5 b* ~2 ^& N3 O  t& w- }- }) @5 S
function InitForm(){
  J9 {1 U- l1 @6 \//layout for the form
' S& n% N  d  C# R( B" ^0 f( Necho "<strong>Send Items.</strong>- B; f) j2 Y7 l1 S' r. u
<form name='select' method='post'>
8 g" p3 }2 {4 e  o$ M+ Y! R/ I<lable>Character Name</lable><br/>; D& N  Q. P2 N5 R: D/ S, N$ W% h2 Q
<input type='text' name='char'/><br/>
- g6 C9 W! Q) G) s<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
; u6 i- i9 o; ]: }+ S<input type='text' name='item_name'/><br/>
' P3 c0 g1 q8 k- J, q" a1 [' a<lable>Item Amount</lable><br/>
( n4 H& H8 U/ P5 N3 ^<input type='text' name='item_amount'/><br/>. d2 k7 o! W: Y- T! V
<lable>Item Upgrade Amount</lable><br/>
( W- O8 s* s9 Y& O<input type='text' name='item_upgrade'/><br/>
, {* Q* M* i8 u/ l& M- a<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
! H6 L  v( U% t& {7 t) U4 L# I) v% L0 R% X- \% W4 C  B
</lable><br/>: ~  t3 O% \' Z, u2 }) z4 [
<input type='text' name='item_element'/><br/>$ I3 U( |/ y) {; x/ R+ \
<lable>Element Upgrade Amount</lable><br/>: c* k( {/ Z1 }" t% ]* a
<input type='text' name='element_upgrade'/><br/>0 w, L5 D3 o7 q, L: k
<lable>Pierced Amount</lable><br/>" g' ]* K/ i" M/ B, R5 I3 C: L  G
<input type='text' name='item_pierce'/><br/>* J/ i9 v1 {$ h% g8 v! V& o8 Q% [
<input type='submit'/>
3 N; v& h' A! N5 W</form>";4 m8 C. ]6 [1 M3 Q
}
  d# L5 }7 D$ h3 B
3 f4 j" q  W$ K7 ~8 @6 tfunction PostListener (){
" O6 q& B# V6 R: m+ H5 ?//Add more post variables if needed and add them to initform() function aswell; K3 [( E3 D( n0 H

4 S7 E9 ^" e% L# n################################
" Y! X, @6 K& u! ~& X2 K- g##### Connection and Post ######  `1 T5 h8 l7 M
################################
- o" E* w  l8 F( Y: U' |% ]; M( ~$name = @$_POST['char'];
/ v$ A( g% \& B" T$ Y8 T$ItemName = @$_POST['item_name'];
" v: }! l4 n" r$ItemAmount = @$_POST['item_amount'];9 {; `6 i! e1 o4 j8 v
$ItemId = @$_POST['item_id'];5 Q! |+ z4 I; c( Z# X
$ItemUpgrade = @$_POST['item_upgrade'];7 h% M( [' l7 v  m
$ItemElement = @$_POST['item_element'];. j1 \+ I) L" `# w
$ElementUpgrade = @$_POST['element_upgrade'];
+ k/ U- r+ J& |0 a% H  D$ItemPierce = @$_POST['item_pierce'];
* @& j" s& u& U- j1 x  z9 X################################
: P  C8 J  b2 _$ Z2 f6 l0 O# F" P
: U+ v* v' V% |/ \6 U5 f3 i//Check both variables for empty value* }" {: f5 H. N9 [+ N
" `! B' n3 Y; g8 h1 a* }
if (!empty($_POST['char'])){
1 B) t  g8 |6 H& V% _$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where , r6 K  ^: R/ J' W
- [, U% S+ O# M8 L4 R) C9 q+ f+ q
m_szName = '{$name}'");
1 F4 M4 S6 u/ P' R+ p. I7 k; w7 Vwhile ($row = mssql_fetch_object($find)){" c9 L1 R- Q4 B$ `+ c* t  @
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
/ r. v3 q# D  y: X& M$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
1 X  F% \; h; Z! q. W
$ Z! S$ u6 A1 [, s  Z[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
6 Z* L1 ^, }' |
( C, H* {4 _; p7 b( ][m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
' b. s; `+ y3 L3 w# a! t/ |1 L! n2 ]  l, q; A7 D
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
  j1 |9 Q: \7 y; D7 l: O2 b% g3 Y& U2 v$ H" b0 d# Z
'{$ElementUpgrade}', '{$ItemPierce}');");: N/ D  v5 H* H" ?
}
1 {8 T6 ^2 j/ X* o5 y/ \
: q4 R$ y% Z& |0 ~! D- U}
- ]# W4 f4 {' k# D2 W2 b+ y$ r& I- c9 ?/ H% T/ Z
}& t5 w  P( T" l
- h2 p& f. h7 p5 ]  v
$InitForm = InitForm();  ?7 s0 M- k! U& k
$Listener = PostListener();
6 y) p' g/ g; s4 N* U
$ g, j  G; L2 p* M  C, z5 }?>  ~8 G4 c* o9 Q0 D/ }% s

. I  ]7 h# O" z  \/ m! S6 A5 _! v9 h* J) t! T9 {7 q

3 t6 j6 R; H3 O. E' r
; C/ z* a( y1 ]4 \5 Q& s: t
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-12 19:43 , Processed in 0.062969 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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