飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |正序浏览 |阅读模式
<?php0 V* q" T7 t4 W' E3 M
function Connect () {9 a. K$ s$ J9 e, G
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
5 B: r+ ~' h8 ]4 G3 b8 t& B, f& w
Failed.');! W$ d# Y# C* M2 W$ F, M5 ~1 F( s
}
3 V5 d8 K$ C7 i8 Y# F2 bConnect();
$ k& v9 Y2 S* n. m' C1 u. w
# r3 a& }+ B7 m0 Y6 S2 r3 M( w* @function InitForm(){; z0 ]; k7 n- v" e
//layout for the form+ B. q# p* C) h' i% Z. z
echo "<strong>Send Items.</strong>
2 P( D( S9 D  o3 }4 O! P<form name='select' method='post'>
( ~  P6 r4 m5 a6 V# j) ~<lable>Character Name</lable><br/>% {: }5 K; C; T
<input type='text' name='char'/><br/>8 J" g, @  Q" d* j% t
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>. ^. a- S4 V5 J8 \) F7 i" M
<input type='text' name='item_name'/><br/>
) \) ?( r2 @' `0 t# V' k( L/ y<lable>Item Amount</lable><br/>  J7 H8 G9 l1 F% M! O* T7 F! l
<input type='text' name='item_amount'/><br/>+ y3 Y/ u; p* f3 A
<lable>Item Upgrade Amount</lable><br/>
" W( u# f* H, L( O, B<input type='text' name='item_upgrade'/><br/>
2 c# X9 {3 d5 b' J4 b<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)( ^* d# l1 I: d6 o# G3 }  P
. n+ }% }' w# E* p4 `+ G
</lable><br/>
" y' I% [" K5 y! H/ x<input type='text' name='item_element'/><br/>) n( s4 Y' v; ~5 x. X
<lable>Element Upgrade Amount</lable><br/>
! C" ?. I% G% `# F  k<input type='text' name='element_upgrade'/><br/>% _5 O& V, T+ _* x  M& {
<lable>Pierced Amount</lable><br/>
. ^. h& l/ C) m9 ~<input type='text' name='item_pierce'/><br/>
: P8 |1 C+ S9 W4 c% V$ N  k<input type='submit'/>
1 b. m! B' T& S. n0 p1 D</form>";. f. U$ e0 _6 e+ K  S* ]% S) y
}' I7 V( u, r7 z! R" A8 X. Z+ M
1 f$ r) o0 p$ Q% q6 z
function PostListener (){; L3 A7 ]3 u* x- N2 D/ t3 X
//Add more post variables if needed and add them to initform() function aswell( N, E) w9 `# r( ?0 ~
' b1 S% c3 o! [" ~
################################7 v9 v/ A) o6 P+ X2 X" M
##### Connection and Post ######/ h+ m3 X( e$ U& Q
################################
' T* ~8 _- I; R. r( J3 ?$name = @$_POST['char'];' c, P8 g9 f' L- e$ Z: |
$ItemName = @$_POST['item_name'];
/ N1 E: y' r: O/ ~# u9 m4 a5 E$ItemAmount = @$_POST['item_amount'];
7 S4 q2 ~+ H9 i3 q$ItemId = @$_POST['item_id'];+ M6 J1 k6 }" F5 o6 t- [% ~
$ItemUpgrade = @$_POST['item_upgrade'];
8 s0 c; i1 U4 `* m. B$ItemElement = @$_POST['item_element'];
7 R" w5 X/ \: P+ Q$ElementUpgrade = @$_POST['element_upgrade'];
0 f, p7 U% @. s2 d$ItemPierce = @$_POST['item_pierce'];0 f6 l$ f1 O" K$ k$ A" g& ]* h3 o
################################
8 Y0 K& N. c6 D" l4 M2 Y/ N: D9 v: G/ k! K, W% v2 w5 \
//Check both variables for empty value3 q7 ^) z( Y$ c$ u4 j. J9 k+ p

! B5 ?& n! f) b3 f7 D" Jif (!empty($_POST['char'])){
2 F* W/ r& f6 G" V/ s# J7 t" A$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
( D! |: L) B4 {# [5 y3 d  t
& q! N0 P3 e- a$ W, mm_szName = '{$name}'");; A4 s+ X1 T" ~8 _! B1 d
while ($row = mssql_fetch_object($find)){
- z( O5 U- l$ X" s8 jecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";8 \0 }! I8 _* f, |5 s- }
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
. G9 s& d1 p1 S, s$ f. C$ Z9 R' N3 F# n: M  L6 i2 Y' u, q
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 5 q5 y# M8 g9 ?; w6 H

, ]2 J5 i+ I" [; e& h[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ) P1 M3 _2 \! g, n5 D) y) @
+ T6 L) A- ^& a5 o6 T6 k" M1 s
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 4 M* Q) [0 X5 @% M5 d2 L1 _

6 {6 E, E9 C# C' o' S( e5 C2 c'{$ElementUpgrade}', '{$ItemPierce}');");  S& E1 X. {0 n7 w+ V
}- W7 A* ^4 s, S! g" B4 X
3 q$ m, j. ^8 i/ y: _% @
}
- B5 m& f7 y. x# ]. Y! Q
) q8 @& M: ?" @2 W+ _1 H3 L' g& k}/ N8 |: Y* p, s6 I& J/ Y
  t0 {/ g; u$ a! s: f2 I. ]6 E
$InitForm = InitForm();
% Y! }. U* Y! d; F# H$Listener = PostListener();
. e7 ~$ _1 \" r+ |7 ~3 Y7 m! C6 A# q5 o7 @% k, d
?>6 r' u9 B. \6 m. P" f
+ ]; Q: Q5 ~* ?7 Y
* m- E, U; O- C1 ^% e0 {
. n' N* g6 @* [. o

; W! s) I! [9 W; S% p) g
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-5 02:25 , Processed in 0.058336 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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