飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
( s  Y  S) p% \8 k! N$ R5 Vfunction Connect () {
  s! g, U  @) I8 W, Tmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
2 N4 W7 ?, r7 S$ V9 E- G( [- R% H
5 Q( I6 l! U7 I/ Z7 hFailed.');9 T/ w: v1 ~0 b7 z$ u
}
, \4 X0 v) s8 o& RConnect();
* j8 i+ @6 X' ~: |( {- t3 g+ V* @% q
% y) D- `  \( D% |2 Nfunction InitForm(){" C9 W* P# f/ n5 i+ U# s2 Q
//layout for the form+ a3 h  b6 q! M
echo "<strong>Send Items.</strong>
! V1 L7 G- }. S6 q<form name='select' method='post'>
5 P- r+ J5 n/ J0 _% j5 S<lable>Character Name</lable><br/>
% m. h! d5 c5 l1 t4 t" F0 F  U8 E8 G<input type='text' name='char'/><br/>7 `: f9 L6 [7 ]
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>1 T1 v- o- n% \
<input type='text' name='item_name'/><br/>
+ f/ c5 b* }& X. n+ y/ N9 S5 j' U, {<lable>Item Amount</lable><br/>( a2 C9 h2 s0 h/ I$ a! T2 N- Y
<input type='text' name='item_amount'/><br/>' ^  h& E8 f! d: t! A5 }
<lable>Item Upgrade Amount</lable><br/>  E7 Z3 q0 J: ]4 T
<input type='text' name='item_upgrade'/><br/>/ f( c. ]5 ~, n- R) a7 V" S
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)% J. \8 E+ _; D/ E
5 |- c. T" H3 s5 u/ T$ x2 F  U
</lable><br/>) S% r, e$ ^4 r! s& U' ^
<input type='text' name='item_element'/><br/>: ~( M4 e& A4 S9 g, L/ m8 ~
<lable>Element Upgrade Amount</lable><br/>; h! o. [: K) D) Q* n$ [1 A8 N
<input type='text' name='element_upgrade'/><br/>
" R* ~* z6 Q, f4 e<lable>Pierced Amount</lable><br/>
6 L: O% k; r- Q/ t( h<input type='text' name='item_pierce'/><br/>
2 b% A( O# k/ O/ E<input type='submit'/>
9 n9 C& b8 Q8 i/ D+ Z2 f+ Y4 `</form>";
& {. g4 N5 k9 b! t: C) E1 D  l}6 {5 c: a  r  Y' P+ J
  S- x3 G" f& E2 V7 l! v
function PostListener (){
& a* n7 D3 \, @7 |3 U+ b//Add more post variables if needed and add them to initform() function aswell  d. z+ E  O& M
4 i8 _/ D) x5 P1 H% e0 Z
################################2 o( ]+ P7 R( A. p" y" m  Z
##### Connection and Post ######
6 f  B# P9 l; G+ n0 d& F################################
! K# Q" J2 k; G& \$name = @$_POST['char'];6 h. Q6 K( S- Q& E8 d; |* L
$ItemName = @$_POST['item_name'];
% o) r$ h' g. _6 O0 i$ItemAmount = @$_POST['item_amount'];
* P- h( x  h5 O. [9 U$ItemId = @$_POST['item_id'];& S+ u6 x# n6 n6 D: l! h1 j
$ItemUpgrade = @$_POST['item_upgrade'];
  l# C0 p0 b6 L$ItemElement = @$_POST['item_element'];$ |8 |0 d( S+ j  s4 Z1 ^
$ElementUpgrade = @$_POST['element_upgrade'];9 T* A, k' x" l, `* c1 F" b. B
$ItemPierce = @$_POST['item_pierce'];5 ]$ y4 M1 v2 S) R
################################
8 Y' }0 y2 N, [+ Z0 n. e# \2 \1 H8 ?
//Check both variables for empty value: ?% g$ b6 D5 k1 h
$ Y; w- t& |' h6 v
if (!empty($_POST['char'])){* i( g2 E6 K) d$ S: K  D& H
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 2 L6 d( J! _7 `# I4 ?0 E

* N# J" L0 `" \+ M; Om_szName = '{$name}'");
+ c$ e( E5 _: B5 b/ G1 e0 `7 b2 Fwhile ($row = mssql_fetch_object($find)){9 K* Z1 n, {3 l/ X  ]7 I3 X
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
8 f) C. x9 p* T3 r: P: |$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 3 G5 S. g; f) \5 s5 E6 {( i% s
# E( E0 @2 L: s- [  H; S7 {6 s
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
  d  k" ^4 m% A6 m: _3 E4 M& L  g8 [1 u
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
* [- s7 y7 Z$ E$ @; `! p. G% ]$ E& z: {
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
: K. n/ z$ O$ @# z: Y. J* P& J! @* s5 S  e2 Z) d4 S" W3 }
'{$ElementUpgrade}', '{$ItemPierce}');");
2 Z; K. J9 g+ V% R1 ^3 {, C}
( b& j9 l2 h( I8 w
7 U. e* q" ?% p) o5 Z  [. f( t6 k}
) ]# E, k* x. l' v1 K4 c4 O
- Z4 i; d5 Y% E$ A& I5 h}$ T  e, w# Z0 ]7 k
/ @# \$ f. G. o! w" _0 n
$InitForm = InitForm();
( |' Q9 {/ g2 q: Q- p6 \$Listener = PostListener();) x4 |* P. Y* d) w5 ?; B% i

! o' T( a9 \4 A; i) l* U6 x?>
, h4 }0 L. z) X0 b) G2 g/ C9 Y
! p- c3 t8 N! q1 c+ b% ~1 n' w
0 \7 F# T8 d# X5 J6 b! N+ ~/ T
5 M6 ~; B6 Z) q
/ j" g; C2 M9 X9 O+ J: @
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-15 19:31 , Processed in 0.059867 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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