飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
4 s/ d, i% d' R4 P5 c9 |: W* Ufunction Connect () {
$ {6 l- e( m/ z) zmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
7 m1 S6 J# A# h4 d  P3 I" e! u" k- m( c2 c  R- R! R
Failed.');
9 j: v7 f% E2 y/ J" I: V: L- |}
4 D0 o: Q7 S5 p/ [- V3 z; PConnect();) R% p9 e3 D6 \! M: W

3 [( s* v* C( afunction InitForm(){
% C+ _9 E6 A' Q% P# L//layout for the form
0 V2 K- k/ c& M' oecho "<strong>Send Items.</strong>* f% `4 T0 k. v2 h
<form name='select' method='post'>
1 V( H  k! B4 q8 w  L* ?, T/ z<lable>Character Name</lable><br/>" f$ u. U( A8 p7 `  U  f7 _9 }
<input type='text' name='char'/><br/>( \* e" |2 u# m2 o
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>+ A0 v+ Y7 M& ~, _$ e0 `& ?) U
<input type='text' name='item_name'/><br/>
$ }# s& U1 p6 f<lable>Item Amount</lable><br/>( L8 Y! j! ~% u( k
<input type='text' name='item_amount'/><br/>: Y: E2 t4 t/ V* }& ?: L0 x. X
<lable>Item Upgrade Amount</lable><br/>
. e3 q$ n+ G. L3 F<input type='text' name='item_upgrade'/><br/>
7 h2 f3 m  S, v2 ^, h<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
+ o8 {: k" F6 U" K2 X: w$ M  d1 w0 p5 |0 m4 Y+ h! X) u
</lable><br/>
/ h5 F( t" q6 }" [: X<input type='text' name='item_element'/><br/>6 c5 X. K/ G& }
<lable>Element Upgrade Amount</lable><br/>
# m: Y; P1 O: n. e* f8 `+ M: l' e2 z& b<input type='text' name='element_upgrade'/><br/>
  C9 \+ E# T8 ^<lable>Pierced Amount</lable><br/>
; \( n. [8 O; i<input type='text' name='item_pierce'/><br/>
! L1 P4 I! E$ z0 ^<input type='submit'/>- z4 _0 ~$ m8 d; A# _
</form>";! c6 N5 e; P1 B$ V" E
}
7 Y9 c3 T, y6 p8 B7 `( N
% e9 g; P% u5 Vfunction PostListener (){
5 d" b; T2 T0 B7 o7 b2 `//Add more post variables if needed and add them to initform() function aswell
9 g  w  Q6 _" f- c7 o+ l( |- Y2 l+ M9 k7 N
################################
- E8 Z$ j0 [' F" _# B7 B; ~##### Connection and Post ######5 m7 ?, |; T' G+ c, z* ^7 b
################################
# U, k* H5 |! h( W% o$name = @$_POST['char'];0 v6 U2 ^6 r2 \& X' U
$ItemName = @$_POST['item_name'];5 k% J) I6 d5 A' ^6 U* C2 |& u
$ItemAmount = @$_POST['item_amount'];% |2 x5 h% L2 B  y8 J
$ItemId = @$_POST['item_id'];$ }1 T1 t% F- L' K
$ItemUpgrade = @$_POST['item_upgrade'];
7 I4 u% z$ _8 C4 H/ l7 E. U+ j; i$ItemElement = @$_POST['item_element'];
9 _( a2 y% j: ^5 N$ n4 J3 p$ElementUpgrade = @$_POST['element_upgrade'];( f: D, H& Z# x4 L' X% O0 W" ]
$ItemPierce = @$_POST['item_pierce'];. y& @4 E; y5 r3 I$ _. S
################################9 Q5 o2 V# f% B: v. m# \5 A) q) x

9 q' Z; f0 a9 e' p//Check both variables for empty value7 @5 i1 p% {( v& E

* Y: y8 z& y& _0 V9 N3 ~if (!empty($_POST['char'])){
* n  y, j  f1 {# q$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ! [" N& l1 Y+ u7 `: B) t1 c# S

) @- k0 n! C, T& l6 G* D2 Lm_szName = '{$name}'");  V! [. ^% R; Q( X  }( Q
while ($row = mssql_fetch_object($find)){
, U8 p* X8 {% b0 Y: r* Fecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ Y: \0 n+ i+ I# z. R5 z! C$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 6 r/ M: h; ]. A2 N
8 ]& K! W) A! n1 V! k9 p
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ) V5 `% k. h; V$ A- u" a) d
+ @* \/ V! _( B) i: }$ t: |( n
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 4 ?7 r' s. c0 V7 `6 f! o

7 a6 s7 d% m8 v2 gN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',   k& q9 S: ]/ T' U* ]% q" V

: N7 J, w' m/ X2 u9 R8 |$ h8 ^/ L'{$ElementUpgrade}', '{$ItemPierce}');");" R! \3 V; r  m* l7 b$ K
}
+ Z; M. J0 j1 w8 O. M3 v6 l+ o( R/ D2 @$ A
}
- X1 f# J7 [2 S/ |
# n0 N% ]/ X. A+ t; l1 q* t  A' r}8 X6 u; i& |4 o2 b
" @# L! y; E+ o
$InitForm = InitForm();
' |7 Q) u) U* ]7 [$Listener = PostListener();
2 p: Q! ?5 \, P0 J( L9 K) R
! v& Q0 k. e- I; H. @, |1 O?>2 C# d- y( j; _* e9 I: ]

0 r- m" p2 \3 g* _
9 i/ P4 K6 }: ]+ @5 Y( O) M7 k. c2 X
# ^% a) H' W& n( ^& P4 e  }
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-23 22:44 , Processed in 0.061607 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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