飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php3 G/ r6 O" \5 h/ r4 l2 e
function Connect () {
! p( Q# ^% v. g8 s: M; Z/ R2 \mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
, U0 I% X4 P6 Y6 W& E# G+ h' D* G$ V
Failed.');+ a$ [, j6 x5 `7 x* |! w0 M4 _9 [: I
}
! t8 N' U$ p; N1 q3 ^2 o6 jConnect();
; L- P6 F/ M, g" V3 w  W5 U" a9 }! j. {! J9 s& a4 O  \5 `
function InitForm(){
+ l! s. J, B, v# D+ a$ U//layout for the form
+ s3 o4 g, n! l# gecho "<strong>Send Items.</strong>
  u/ V' ~, M' H4 n<form name='select' method='post'>" o- |% P/ D  a/ f4 Z' O
<lable>Character Name</lable><br/>
* x% d/ ?) p* W, v<input type='text' name='char'/><br/>. Q! y+ L& U0 E) w  M4 l: Q
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>  ]) S! n( }# k
<input type='text' name='item_name'/><br/>
; Q% T) _" I- z( {5 S2 q<lable>Item Amount</lable><br/>1 h' ^/ Y7 B4 M, @7 q
<input type='text' name='item_amount'/><br/>
3 Z5 q1 |0 n; l3 k; h3 N! E, A<lable>Item Upgrade Amount</lable><br/>
4 X) t2 C0 P0 `. {' q4 O<input type='text' name='item_upgrade'/><br/>
! K/ R, I  Z  k# \<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
8 F$ |& X: ?" u
$ v7 J% u* s4 w$ V" \( N4 W* F</lable><br/>% p3 t1 Q3 S; g+ C4 m$ d, D" Z. q
<input type='text' name='item_element'/><br/>
) C% j2 p, q$ q& q2 s<lable>Element Upgrade Amount</lable><br/>) x. n+ `/ v" R; U- U5 g
<input type='text' name='element_upgrade'/><br/>3 V6 [! X9 E$ v5 L
<lable>Pierced Amount</lable><br/>1 }; ~' d% W* }% \3 H: I. p. t, ~
<input type='text' name='item_pierce'/><br/>
2 m- D9 M# ^  Q; N& t<input type='submit'/>' s$ G& P8 Y7 \- T/ t4 _+ e
</form>";) }# S0 P( n7 n5 V) y
}
4 Z/ t3 {7 H" u- Z2 o; n3 P* G' p, _, N5 E9 o. E% ~, V
function PostListener (){
% T; B+ d' o& t4 `& o& k( S2 C4 `//Add more post variables if needed and add them to initform() function aswell
* _8 i$ G3 T! y/ k3 K, c) P" B- ?$ @4 l! }6 c, u
################################
2 y; ^' W& @$ k% J% m9 U/ H! x##### Connection and Post ######
$ i  W9 d, R1 D  Q8 J1 X################################
9 F* z# L2 w! _/ |  R, {9 @$name = @$_POST['char'];
+ E* w; J3 U. f9 A2 ?0 `, l$ItemName = @$_POST['item_name'];
7 ]/ i) u! {& v  D# F4 x* n) M% V$ItemAmount = @$_POST['item_amount'];/ D5 r- o# w+ e9 o& ]: i
$ItemId = @$_POST['item_id'];
6 O+ [$ f: F3 E3 I# X$ItemUpgrade = @$_POST['item_upgrade'];
9 B6 }9 O- }7 {/ y1 Z3 z6 p* h6 d$ItemElement = @$_POST['item_element'];
1 V7 j/ y* o( }: ]$ElementUpgrade = @$_POST['element_upgrade'];/ d" r& v. Y/ t, ^* \
$ItemPierce = @$_POST['item_pierce'];8 I0 R+ \; {' q  F# a
################################' }* j$ U# o) r2 p
+ Z2 H4 s' S$ ~1 O% j: `& C' x  P
//Check both variables for empty value/ b! q  G2 j' B- _5 \3 a

- c1 S, k" h0 H6 {: N2 G2 g7 Wif (!empty($_POST['char'])){1 d5 Y/ P* c& W0 Y
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ' E$ \7 M8 @! a3 A

: r. |! [: |1 i( ?; Hm_szName = '{$name}'");
" {6 G" D- _9 |4 s/ @while ($row = mssql_fetch_object($find)){+ M, \6 h! L4 L: P6 s# l
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
  X  k( r0 ]! B# A& F2 D# n) g% L$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
8 c$ s; u7 A: d1 x2 u- T8 o% X
8 B5 J, U0 P2 q( b& O6 e[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], + c0 Q" Q2 X9 I; R4 s% r0 |

5 @( z( u' u, N! O[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 4 a7 Y6 S+ J5 O0 U

- U6 x9 w6 B, E" W" ^1 O& j: m8 ZN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
  i2 C3 [9 z' q  |" N& Q2 m* l' G4 L2 G7 B$ Q
'{$ElementUpgrade}', '{$ItemPierce}');");8 u9 _$ N/ }/ Q. ~' {  g  Y% P( O
}- F/ B7 `$ J& I9 @, a# ]* I

, l% q2 P0 M* z" h+ f4 D1 K' v}* a. y8 z) C3 P* C3 ^! u( q- E

6 ]6 i- h7 [# t: \}
+ X1 J5 G) r' Z" R+ Z! t, D4 V/ @1 @2 r( g
$InitForm = InitForm();5 S* P* f0 ]; B1 u0 D* ?& W- w2 ?- v
$Listener = PostListener();, A" s. a* f2 L% T: {$ m0 V

( ~+ ]* k! }4 D4 A?>
; \1 i& i' J- K/ ~) _& N' D8 s: `* J9 j' a' R

( M0 I7 R& }# f( M; E
9 P6 P8 ^, ^( |1 u
+ M) K8 |& ~1 @2 W) u0 N
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-20 09:40 , Processed in 0.062400 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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