飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php  f( b2 C* \% K4 U# s
function Connect () {
1 |8 J  _' }1 U. J& l/ vmssql_connect('Server','UserName','Password') or die('Error: Connection to DB : l6 J" T6 y- j6 P7 k# a
# c  Y, b2 D" V; N' j
Failed.');
% Y9 x, V) T0 Y: ?2 G$ F}" w' R1 n2 m- J% u" N
Connect();% z- ^6 j4 ]/ [2 V! v- i

  o  D2 k! U7 P7 E  Efunction InitForm(){
: s/ o  ~+ J( n5 P" {  l! A' `//layout for the form1 I+ m: w9 L, y  T
echo "<strong>Send Items.</strong>% N' p' X9 @' ^$ X# W; }% q
<form name='select' method='post'>
, Z8 B: |% p4 ]! H- k<lable>Character Name</lable><br/>
: P2 a* U( r) G/ d<input type='text' name='char'/><br/>& q9 D& C# y/ N* Q
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
0 m8 y: M7 {* q  D  h<input type='text' name='item_name'/><br/>
$ s) F! J/ t: ~1 {. V7 X/ o<lable>Item Amount</lable><br/>& \/ W' O$ X2 K' p, V
<input type='text' name='item_amount'/><br/>, e& e  o( t+ B  h
<lable>Item Upgrade Amount</lable><br/>
" j9 I! T( V8 F" V' y<input type='text' name='item_upgrade'/><br/>
8 Z2 \  ~6 J" B: J" \<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
8 S  c- i" l; Y: r0 [5 ?
  S' b0 {3 C5 L</lable><br/>
* e! c+ h. W/ ]5 z. Q! n6 Y1 g- s' e! a<input type='text' name='item_element'/><br/>  O8 `/ @- d) u9 Q
<lable>Element Upgrade Amount</lable><br/>
5 O% h. l: @8 s  [<input type='text' name='element_upgrade'/><br/>
2 I% K! I$ X, I2 O* y6 ^* ^4 c<lable>Pierced Amount</lable><br/>0 u7 g( v8 @9 c+ C- w! g
<input type='text' name='item_pierce'/><br/>
& {3 A' j* s9 i4 K6 _# v<input type='submit'/>3 ], R0 v% N) \4 B) O0 A9 z% x
</form>";* B5 j0 M" U9 f( `
}1 m7 x9 v% C& B1 D
2 T7 a8 F* N5 B" V0 {' M3 z9 j
function PostListener (){
9 f# H% P( _( x# F//Add more post variables if needed and add them to initform() function aswell5 I7 t6 L- w" ^$ f  G- J3 K

+ e; a) q" ]$ w; f+ q5 M################################
( k# x; h# ^* `6 v3 v5 n##### Connection and Post ######
* F8 W5 P2 D4 B7 y. X, x( |################################
: D( m$ r4 t% I+ e3 O5 @& ?$ k$name = @$_POST['char'];
7 h! @2 D3 ?8 `  d$ItemName = @$_POST['item_name'];
2 V& D' R/ H& T( v. s; Q5 K$ItemAmount = @$_POST['item_amount'];! M! G+ F7 w; F& h
$ItemId = @$_POST['item_id'];
" L( D2 f8 Y( M" m: f$ItemUpgrade = @$_POST['item_upgrade'];9 T% u" D  S. j% I1 A) X2 Y
$ItemElement = @$_POST['item_element'];+ `! j/ @0 O% K
$ElementUpgrade = @$_POST['element_upgrade'];
& V3 G5 k- D0 F9 \$ItemPierce = @$_POST['item_pierce'];
/ ^  w% M' j3 K5 A* Q################################5 S9 w5 I' d) V! J* h8 [% y

: O% m4 y" h8 m# F  Q$ z; ^+ Q//Check both variables for empty value
. ?4 y. m* C2 N6 S, x$ E2 ?( s9 y
7 ]- R. }% Y! W8 W& xif (!empty($_POST['char'])){% B& b$ u; p1 E) g) s5 r
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ X  Z; ^( x  x9 M4 R5 a! E9 G$ R, a+ y  V3 Y
m_szName = '{$name}'");
6 p) J# t+ I6 b0 ?, mwhile ($row = mssql_fetch_object($find)){
! Q4 w. i; Z2 K* b9 g! ~echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
, Y' ~' [$ B: D3 \) B$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
, i) }* j* w' }  X: e" w/ R; q8 i" f
* j' x5 M  H, U[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],   Q$ z$ X5 N* i$ n
, z1 \! ^  @6 R4 A/ J* i- M
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 6 h9 h. S+ C/ ?

$ L% @: `3 f: z' L0 W4 {3 d- sN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 7 P8 w% u; K: U2 W, m
8 ^* ^! |. p. q
'{$ElementUpgrade}', '{$ItemPierce}');");
) V6 k# c" h' o. V7 g, I}
' D5 T: o, p3 Z0 q6 |, w6 o) q5 @3 w2 e+ e+ E" p1 T6 A& t
}
( ]# X+ j+ [9 _  f% _8 `4 l: k# O+ _+ z) J( O& ?- C
}7 j5 c$ A) T, t* |6 ?

; w0 ~: ], e$ z$InitForm = InitForm();, _) E6 p8 s$ L, I
$Listener = PostListener();! S: a- }1 Z% s: @. w( i9 Y

6 D; a* R) X- R; J5 q3 T?>  t9 F  _0 a6 Q: `1 x. C- `! e+ r$ f1 q

# P, A% K+ o, x$ Y& r4 G# w" Y4 o) ?& G& y& Z5 u$ s

* ?% V7 Q+ l8 p( Z; p3 A  K# l
" g/ o: W  c1 p4 }5 B
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-18 12:46 , Processed in 0.070316 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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