飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
  q( J& X% q" ?% d" |function Connect () {# F& X. n1 R' b% k/ N
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 8 q2 H1 Q  f" Y

( d" d% z& @  f3 hFailed.');
2 j. S6 m) T, J; @; a}
& S) T  @: C  t# R. |Connect();
8 @" ?) F: I: _" a' g4 J9 D4 \
4 c( C5 ~) ]  g# Ifunction InitForm(){
, c) y/ `6 W4 m- i6 Q! `, G//layout for the form
  r, S2 }! b2 C# Qecho "<strong>Send Items.</strong>% \6 ^. C, @2 f% }: H1 k
<form name='select' method='post'>
( E- X& {/ [* i( k<lable>Character Name</lable><br/>; n, a6 h& [: E5 K, z
<input type='text' name='char'/><br/>) n& b* p# d+ n4 A: X( l
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>% }7 @1 X0 J1 a" Q" B+ j
<input type='text' name='item_name'/><br/>& _& q% v7 e1 E9 L6 i, m
<lable>Item Amount</lable><br/>2 s8 Y- B  S& B9 r' e- e
<input type='text' name='item_amount'/><br/>: z' p, m9 n3 z  O% b
<lable>Item Upgrade Amount</lable><br/>
- A6 F0 E: I3 I0 o<input type='text' name='item_upgrade'/><br/>
+ T$ d( g; M! Z<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
* @' B* f! k7 J9 e5 I
" Z# {) n; G5 v</lable><br/>
: X2 I$ p% j, T* g' E' v7 L<input type='text' name='item_element'/><br/>! E7 @. B/ t# c
<lable>Element Upgrade Amount</lable><br/>9 S) ^1 k# y8 ]" T
<input type='text' name='element_upgrade'/><br/>
; Z- t$ _  H+ D- J, |# z! E<lable>Pierced Amount</lable><br/>
- F# Q$ x9 K5 n( L% B* [: Z$ V<input type='text' name='item_pierce'/><br/>
0 Q8 b: d& D8 i  h<input type='submit'/>2 Q# ?  g4 o$ q
</form>";- w% b3 }" P- e
}
# M% l4 j# m) ~2 p
, q% H0 M8 N' F+ I) Afunction PostListener (){
, M1 a+ K  `+ S' t. I. U//Add more post variables if needed and add them to initform() function aswell& R3 H7 H0 K1 x( Q
1 O( ~/ W6 K4 Z) K7 `" ]. U" L- ~
################################
) h& S, ?3 Z' ^& I; {+ W4 E/ e+ \) d0 g##### Connection and Post ######8 D/ i8 v3 \( u7 `$ }; b% J) b" b
################################; b, Q' C2 |5 ^# J0 K8 s3 Z
$name = @$_POST['char'];
. b3 g0 @" p+ Y7 s+ T! I' o$ItemName = @$_POST['item_name'];8 `7 \1 f! q% w% i' z
$ItemAmount = @$_POST['item_amount'];
2 q0 `. ]' I! ?" S$ItemId = @$_POST['item_id'];
' ^9 S" b. Z4 v* R8 q% j3 o$ItemUpgrade = @$_POST['item_upgrade'];5 b& A/ a4 o; `; v5 F
$ItemElement = @$_POST['item_element'];! H3 `4 ^: K2 M& D
$ElementUpgrade = @$_POST['element_upgrade'];1 H6 R3 p3 T; B% n7 F8 k& l
$ItemPierce = @$_POST['item_pierce'];
# X4 h: d1 v/ j/ c5 l5 b/ X################################" V% E) t  W6 M7 M% d! A

/ s6 H$ L1 k5 A% C( k//Check both variables for empty value
# }2 f( n! m5 v* D# I) a8 p3 y( x' b# ~8 d( r) x7 x
if (!empty($_POST['char'])){
5 P) ~: J8 h: E* b1 y- x- t$ s3 m$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ' @$ |0 n0 S3 W; T0 ^

' A0 F/ [# O9 D( v3 b8 um_szName = '{$name}'");
/ Q& N7 R# f2 Awhile ($row = mssql_fetch_object($find)){) s) T7 u) R8 @6 D8 a
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
# z$ @0 o  p$ q8 I6 u$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], : ^6 b* B5 f: \: n; }

' P8 _" @3 x4 K' ?* {[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
, U/ b4 i1 [; L3 ~6 K* J! ?
+ Y; w( U$ V7 E8 }- f  b[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
# h9 t9 a- ~9 s% H. n, V9 n( F$ ~! D
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', * j6 Y: r- a8 |8 j' J- R7 }% a
; J+ O$ B- i8 @  B. c3 v/ Z- e  M& {
'{$ElementUpgrade}', '{$ItemPierce}');");- |. C& g2 O8 p  U
}
9 v4 Q5 G6 Q; Z; N" o4 }7 s4 n
* M5 ]( [# T9 N; M+ @}3 b) F) W6 u5 S) Z$ H

1 |6 p% X, U/ s: K& E0 C& J}) j& _5 S: d5 q- W# A6 E9 D
; b- k% M2 J7 }# d9 F/ [! r
$InitForm = InitForm();
9 V7 [" T4 S% K* G; q$Listener = PostListener();  k8 u- K2 V4 u5 u
: f9 e5 w2 u" I
?>
- \' _$ n+ l2 N& M7 |; O
: Z  v" J3 k3 g8 c0 ?& Z9 l- ~& X' d: V
, }6 F# h- L" c

; Z  O( h$ t4 A* D$ P9 s
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-28 17:04 , Processed in 0.062536 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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