飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
7 x' }1 w) [$ t3 X, K3 H0 @% Vfunction Connect () {, ~0 ]$ @8 v! p3 v) v  q
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
0 c7 S, y- B1 D6 l2 ^! g2 j! y
+ g* v3 `  s" Q  JFailed.');7 i/ y+ e, X' v4 l2 _$ \
}( M8 J8 L  q7 v5 K: v( N. ^/ H2 g
Connect();! @1 k" q+ ^! n7 v5 b7 h

1 ?! k0 Q4 X0 U0 I7 o0 Ofunction InitForm(){5 O3 ~4 t' p- T! d
//layout for the form0 f' l- W7 X' w& C( E- N4 e- q* K
echo "<strong>Send Items.</strong>+ J  P0 [; Y; U" T& G% j
<form name='select' method='post'>* {% e" i4 s( [- u! ?+ V
<lable>Character Name</lable><br/>
1 G% ^# K, U1 C  L$ }<input type='text' name='char'/><br/>
3 Q* \2 [3 ]6 U0 ?; d9 V* Z<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>! q2 B- \% X( n3 a( w  r( I9 \
<input type='text' name='item_name'/><br/>! D, j. |1 j$ z- q- d  t
<lable>Item Amount</lable><br/>
5 A8 F/ g6 }4 A- q<input type='text' name='item_amount'/><br/>9 B* P2 p7 k4 K6 ^/ k1 W( K
<lable>Item Upgrade Amount</lable><br/>
' M( K$ E3 h  B8 _: z<input type='text' name='item_upgrade'/><br/>
( H/ A0 @9 }1 Q$ b, r6 G+ i) h<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
5 f" q# S, e, _
9 J% r4 Y6 m& l: N8 T</lable><br/>4 Q3 l0 Y% s& @, I
<input type='text' name='item_element'/><br/>
" I; k% h0 f* z4 @<lable>Element Upgrade Amount</lable><br/>
& _5 a) f$ e' {4 Q. b9 l: U<input type='text' name='element_upgrade'/><br/>
1 N/ t* c9 H8 ?! B7 Z/ F! s! n<lable>Pierced Amount</lable><br/>
' s5 e( Y+ o9 n. m9 o. e# I" d<input type='text' name='item_pierce'/><br/>
2 C/ ^3 X5 T4 G  _) o, x<input type='submit'/>* n" l* |9 h/ J8 E% S* V
</form>";
# b6 t* H4 w9 i, M! L* X7 H}
: y. a' X  k( i; t6 s& B$ d
" r+ b% B* m9 O; i& B. a  _- I$ gfunction PostListener (){
' u5 L4 K5 s. }. [1 s9 k//Add more post variables if needed and add them to initform() function aswell
4 H+ k) o3 W9 b. ^1 ?9 l% {6 t7 I8 n
################################
  ^- `7 v' I' i; A# S##### Connection and Post ######
2 o: V7 W/ ^3 U5 i################################
, v8 @+ r  P0 G6 z$name = @$_POST['char'];
4 L+ _  @# N0 x9 C7 S& e1 @# o  L$ItemName = @$_POST['item_name'];
. ^) |; D2 N- [4 W/ g, _: ^$ItemAmount = @$_POST['item_amount'];
" D' C$ W. o3 N! K5 c7 h5 y5 J; Z$ItemId = @$_POST['item_id'];
" p1 _* {' g, Q* w- |$ S$ItemUpgrade = @$_POST['item_upgrade'];
4 ]+ l0 o& [% i" k9 L  e$ItemElement = @$_POST['item_element'];2 [- W( c" I6 L$ w: [/ b9 o5 B0 y
$ElementUpgrade = @$_POST['element_upgrade'];
, q' b7 I( L% h0 D, p7 v$ItemPierce = @$_POST['item_pierce'];+ Z" Z/ B& Q/ h/ z* @& o
################################/ M2 T7 n0 G# a# {9 {' R! `
! c8 k  y5 m' ]
//Check both variables for empty value
0 K! i  Q( f6 b; s
4 P8 g$ u) |" K0 Eif (!empty($_POST['char'])){
; u3 o: ^& @2 h3 @$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where # {' {) x; t' O2 y
) R" u7 t# f" X, |
m_szName = '{$name}'");
7 |/ V; N0 L0 W4 pwhile ($row = mssql_fetch_object($find)){
7 I! b/ D" |$ ^' K  |' L# w- Secho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";$ {: k+ M% n$ B- l8 l, k
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 0 v. ?0 c) w0 c; B% H% ^6 E* R
' @7 ^4 Z/ j$ L  V0 J  @
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 2 p1 G0 X2 m! b( V- E6 o- E

! p. N0 ^8 h. w& M[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ' O0 e( Y" R' k. {6 C) ~' J

% D8 V( m! d6 i) ]" ?& u* y" b. PN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 2 n- {% o5 }# A, L; Y

2 K* g" X- n3 R, u  {'{$ElementUpgrade}', '{$ItemPierce}');");6 b* @$ P  b% z
}
# x, u" p2 }2 i5 x5 E( h
6 @5 I$ b. F: l4 x; A' s0 K}) }9 k9 h4 Q5 t8 ?' F: V! ^4 B
; i. r0 H1 G6 G) U7 i
}1 R5 _. a* p1 t8 W/ P2 z7 J

- r2 P; m9 _( D# T4 _4 h* D  Q5 _$InitForm = InitForm();( `. j8 o' `) R  _: G+ V- F4 U+ v2 g( l
$Listener = PostListener();  K; X7 M; x* `' T
7 F' j  i, i5 ]) X3 T& M: R
?>% O6 U+ H% ?( z" z# g( ?
; l2 A+ J+ l# C  j2 A

# V' K% [) Q0 k! g, I' o$ g% [0 L* G2 e1 {( d
6 M1 V5 @6 D4 W( J& `" S
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-11-24 02:47 , Processed in 0.060007 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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