飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php8 C0 T, `# r- u# W9 o/ Y
function Connect () {6 J- B1 v5 C' u5 `6 h
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB " s% U, \$ r. ?+ s; J( U

7 k( a# z! P6 O, w% G1 R, JFailed.');6 A. [9 `0 {8 T; P1 I  r& Z
}5 q9 @6 @/ e# w( [2 o* k/ i3 u
Connect();
9 h+ \3 t' [# K+ ~0 c
1 z/ r! P/ f& P  @function InitForm(){) d. ]& g7 q+ n9 v) X- C: q
//layout for the form0 v3 x8 p% Q6 e  P# V
echo "<strong>Send Items.</strong>
1 }4 u! }1 X+ W<form name='select' method='post'>
/ s) [. j3 j( o9 l- V; p<lable>Character Name</lable><br/>3 }% Q1 _+ D0 h1 z# c
<input type='text' name='char'/><br/>( Z% j1 z9 v, m: Z3 `
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>5 j7 O. O  j/ U- o$ y' m4 W2 h
<input type='text' name='item_name'/><br/>' V, k( t5 ^' F: k$ o
<lable>Item Amount</lable><br/>
0 R' v1 a/ F% S/ X5 \<input type='text' name='item_amount'/><br/>" b) Y6 ?* {! b, x, j2 Z
<lable>Item Upgrade Amount</lable><br/>- b( X; s( ~8 i8 O. i) N& R
<input type='text' name='item_upgrade'/><br/>
0 P" R! _; l% G0 g) K5 j9 P% U<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
1 b+ k1 W. H- D( o" x" i) e$ u1 g, b# z) \1 t9 V7 z
</lable><br/>% i2 i  b2 ~; O6 N, v
<input type='text' name='item_element'/><br/>* E1 v5 X* W! N( G4 X
<lable>Element Upgrade Amount</lable><br/>
6 V% D+ ?' U8 c+ A3 E<input type='text' name='element_upgrade'/><br/>$ i/ ?% h, h* K6 n, h
<lable>Pierced Amount</lable><br/>% N! D1 c9 ?, x8 J5 C% o+ D
<input type='text' name='item_pierce'/><br/>
1 C. e' O: `. s8 l9 z; m/ v' |" |. K<input type='submit'/>/ Y0 |0 X8 |1 K
</form>";
6 a; J4 G3 M6 J1 E; t}
2 c0 v* w9 s" T; I; L* r( n$ H% @$ e
function PostListener (){
) q9 j0 c, S+ V; e8 T' [: [% k  }# p9 O//Add more post variables if needed and add them to initform() function aswell, m+ M9 g: ]2 V1 N
3 L( d5 A& u; i" h; r
################################" k5 \7 F4 L6 |& C8 O, O
##### Connection and Post ######7 K# v, d+ w2 u0 O- ^
################################8 d: g+ H8 L. N3 a+ U
$name = @$_POST['char'];
* p% D; H7 l2 B+ Y4 }$ItemName = @$_POST['item_name'];# i  l' m' s9 h, w0 A
$ItemAmount = @$_POST['item_amount'];
$ I! f3 c7 i( r8 C9 U$ H$ItemId = @$_POST['item_id'];' G$ N+ f7 j2 M2 I( i, }8 }' @2 }' g5 {
$ItemUpgrade = @$_POST['item_upgrade'];
8 r; b1 p. {8 }$ItemElement = @$_POST['item_element'];/ ~& W- S" d* W
$ElementUpgrade = @$_POST['element_upgrade'];
6 P% ]6 O1 i8 {  P. R$ItemPierce = @$_POST['item_pierce'];
7 _4 u9 L, |3 D% f4 E################################
% t; n9 _% O8 g% y, L0 |8 A$ p
//Check both variables for empty value! w8 F; v1 S" b9 ^3 b. Z1 f+ q
3 W# t0 _' F- E( _+ L# Z) H
if (!empty($_POST['char'])){
  D( X  B6 ~! J; ]/ s- B$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where & i; \8 Q& h8 }+ j/ c, A

1 e" C: ]* D" O' r: J; Fm_szName = '{$name}'");
4 E1 z/ a* x1 u5 Vwhile ($row = mssql_fetch_object($find)){
6 g! J& O# t/ ?9 E2 Eecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
7 N+ M0 M6 z* ?% Y( |# k! S8 G$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
- ?2 k' ?$ S7 _+ M  {+ z6 ?1 Z* G+ c% P# e' @
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], . g0 R4 q0 U( f. f: Y, M

; R) L: k4 f& ?  T) \8 s% r0 @" Z[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
  o6 h0 V1 S/ @- d4 R; k6 u5 q" x! i  q1 `2 ~
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
2 J) `( @( S- A9 Q3 U
" R" h5 ?9 `% q' o7 o5 H'{$ElementUpgrade}', '{$ItemPierce}');");# G9 x  n$ A7 c! p+ m3 l
}% @' V$ t( w3 d% X" ^3 Z

! K# Q/ G5 j( y( r+ _}
3 N5 N) N3 a2 u2 N3 N
" F8 ~  _: V- [1 x' m* O}+ g- S; g+ t. n3 E' R  H  O# ~8 `

6 W7 Z& U' |6 f/ O. ~! z% J- Y. v$ S8 E$InitForm = InitForm();
1 g' u  X' A6 C/ E$Listener = PostListener();" D8 V9 }$ r& x" s+ A0 }$ @

: c2 t/ p8 t6 W/ q4 |. B; S5 L7 t?>9 b: r$ }2 f1 n8 X- I

, N5 O$ F( L; ]; u- H. O' S3 t/ J9 q: E8 ^7 ~% w* `9 l& j: u& l0 f
: R: c+ M, @, ]

3 J2 c+ _, K* d; c! Y
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-28 05:10 , Processed in 0.062433 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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