飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php/ B* v- s. q) D6 o& D3 u
function Connect () {: x+ {. J4 ]. d/ p) c* b
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
, z. v1 }5 E' [* {
) W. m  x. N3 C  dFailed.');
: d) f7 ?7 X' y}. }8 F" \( Z- f0 w* x, E' {3 H
Connect();
1 `  X5 N% j  X. |0 I( `0 e7 z4 U* g
function InitForm(){
# e0 P% ]/ o! e* W  y* K/ }//layout for the form7 d& {' h* X$ F$ E4 w, O
echo "<strong>Send Items.</strong>% @6 d' U5 u# o, K7 Q% r
<form name='select' method='post'>3 L1 N, C1 N7 B! d# R* J
<lable>Character Name</lable><br/>
) S1 D$ X: y: Y8 C: f<input type='text' name='char'/><br/>
' w; Z& U, D0 T' E3 e" u3 G<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>- ~- O6 M/ B' y% M! k
<input type='text' name='item_name'/><br/>
7 w8 c2 D' u" a3 l6 {* r<lable>Item Amount</lable><br/>+ K. D9 h) N  J- |" G+ |5 S1 |' D
<input type='text' name='item_amount'/><br/>0 }8 u% }* @; W! ^4 C: u1 v
<lable>Item Upgrade Amount</lable><br/>! e6 ~! @: g1 q; y1 [
<input type='text' name='item_upgrade'/><br/>. }% V( z3 ?1 ~1 e6 t& G
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)$ _8 S! ^6 f3 i, N5 C( }5 U

' d" a8 H: ~3 g: g- F3 M7 g</lable><br/>
6 p& H1 ]. @. ~  E8 ?; v( N1 O2 M) j<input type='text' name='item_element'/><br/>
& W9 j. M. h/ m& d: g9 G  q; L<lable>Element Upgrade Amount</lable><br/>
# g' y/ p& i8 [<input type='text' name='element_upgrade'/><br/>2 O6 P0 I3 X6 O& }/ i
<lable>Pierced Amount</lable><br/>
. q, J* |4 g0 y+ R6 E, d1 u6 M<input type='text' name='item_pierce'/><br/>9 K- u) H% {- E8 j9 H' a
<input type='submit'/>
7 F7 \( a) A9 r! l</form>";
; h3 y0 O. h/ l3 N}
/ p4 F$ W* ~! Y! M# m. M* n1 D6 i
0 @" V, `4 k2 U4 |9 kfunction PostListener (){
2 {- r- J+ U  b  q6 f//Add more post variables if needed and add them to initform() function aswell
; p2 U3 r, U% [' u7 Y( a: V# x
################################
8 Y- s5 r' V/ b$ `& J##### Connection and Post ######
0 T6 j6 v+ P9 g7 W- G$ k  U& [8 j; o################################
2 m" a( }/ E( D: c' F$name = @$_POST['char'];! t* s+ j: d4 A8 K+ u
$ItemName = @$_POST['item_name'];* B5 M* K8 `( R( Y# ~
$ItemAmount = @$_POST['item_amount'];
$ K/ @! O3 l: I! c7 R1 I+ t/ b$ItemId = @$_POST['item_id'];5 A- b7 T8 {" y# @* e4 X( ^* \
$ItemUpgrade = @$_POST['item_upgrade'];
* j5 y2 T# j4 J; p' l$ItemElement = @$_POST['item_element'];- \) ?6 a% L, C
$ElementUpgrade = @$_POST['element_upgrade'];* D; R9 h7 u) b
$ItemPierce = @$_POST['item_pierce'];) j4 b7 b0 \2 K9 V4 v
################################
( E. {' \1 e5 C' _7 P: J
( s9 \3 l6 R* N: b9 c# _1 ]) P//Check both variables for empty value5 a+ r- M5 X# l# g! D5 i4 R

7 L: r1 d( z$ o- o) [if (!empty($_POST['char'])){
. |5 _; `% l/ [, Q) {$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
; c/ u. s( h, a+ X' z$ ^! s' \( L. }8 L# M' N
m_szName = '{$name}'");; X6 o2 ~' G7 B7 q
while ($row = mssql_fetch_object($find)){. O' g1 \2 W  x6 B: v6 G2 x/ j
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
6 N, B3 `0 }2 h% ^  ]! V" R$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
& R8 d( m0 U% s$ m# M: N2 Z9 U& @2 z: m6 u/ I
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], : h! s4 {/ D# Z. R1 \8 F6 P: ]
5 @2 [7 P* d, r5 R
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', / }2 u* c3 t: H* k
/ d4 P9 @/ p8 z$ ~4 k
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 H/ \9 \, V! k0 k+ j% f6 j- y& I# \+ l. i+ O: Q7 i# W5 Y. M; u2 F
'{$ElementUpgrade}', '{$ItemPierce}');");; s) |: |3 Q) o* C; z
}
+ c  w8 I+ a$ K5 B) R
7 _7 G  \, k" X( d" g}7 \8 y6 h' x% ?1 L% m4 F: L- e& ~* u
$ \2 _( w' F. t' j, E
}, P# G( R4 T/ ]& O

0 c% g/ X7 @+ \* Q5 g0 e" `! e$InitForm = InitForm();7 V! \) E) E5 w
$Listener = PostListener();
: ~/ _4 u4 I4 @" q0 A2 ^
) F8 E4 v2 A8 a! N% l$ z?># u# \4 p) y3 l! ~! M' Z

7 k& F7 @( r8 E1 j. ?0 ?% X# c  o- |1 }, X6 U- I- x

8 b$ _# a% e/ i' B: |7 a, z/ {% r! \6 x2 @# L
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-25 05:50 , Processed in 0.071023 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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