飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |正序浏览 |阅读模式
<?php# V, f2 e- I; p) S7 z
function Connect () {
  s0 P6 K$ @5 {+ S1 [mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
+ g4 a+ t& `8 b- v. s, W
# ^2 M& r: m6 k- t4 I" g, WFailed.');) x. |, ]7 g5 P
}
, q! I3 Z" V/ G# TConnect();. M  T# A6 G3 D6 I7 V7 Z7 g. s; b
% M7 j3 }- i  H4 F& q
function InitForm(){
6 _  T2 Z' L; q/ m# K//layout for the form
7 g; T# h! L) K- P  H: }8 b" ?* Techo "<strong>Send Items.</strong>
, S$ z7 s5 u2 d/ ^<form name='select' method='post'>/ ~8 {& [; G; t* b* N1 o
<lable>Character Name</lable><br/>! t: \; _$ \( N) }0 C- a
<input type='text' name='char'/><br/>
2 B) _$ a7 N! \1 t  h" R! F<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>5 e! u1 C) |) c- D
<input type='text' name='item_name'/><br/>
9 Z2 d. O; j) {<lable>Item Amount</lable><br/>
" n. C* [- z: @- o3 Z8 X<input type='text' name='item_amount'/><br/>0 _) U% A- i2 z' q2 N
<lable>Item Upgrade Amount</lable><br/>
8 Q. K* U) f$ q  p: X% V4 B' `, T<input type='text' name='item_upgrade'/><br/>
/ y" r7 C7 K' U- k' N9 }<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)" X$ Y, A% H* y7 Q# D

6 ^: [* a" b) y/ V</lable><br/>% X/ p* r) L! Y0 ?' A
<input type='text' name='item_element'/><br/>
8 f) K' W5 G. F9 E<lable>Element Upgrade Amount</lable><br/>4 K4 E# i8 G3 d4 E- s' u
<input type='text' name='element_upgrade'/><br/>
& h) n; H* V- i<lable>Pierced Amount</lable><br/>
, J5 N, w4 G' Y1 E. [0 U9 K<input type='text' name='item_pierce'/><br/>
1 i+ d# N( u3 d/ q) m" W<input type='submit'/>2 r, i) n0 B- i7 L4 j3 T0 j
</form>";
. B7 m2 j8 H# o9 N4 _}1 ?. @, Q+ D. }

0 r$ M! |& i+ N6 h% O: afunction PostListener (){
  E" B3 m# S' \/ I& x2 c' i, c//Add more post variables if needed and add them to initform() function aswell
1 r7 D6 t6 g) B. D! I/ d
/ p4 X# s! x" Q9 z################################
5 a4 P/ O4 N1 s6 s1 G" Z! w2 C##### Connection and Post ######
% u: S9 b- E! ~" ~1 D################################! P/ H, I( h; L
$name = @$_POST['char'];
9 }! Z/ J- {% }$ k. \+ y9 j$ItemName = @$_POST['item_name'];* B" ~2 U4 c+ R$ p* A  j
$ItemAmount = @$_POST['item_amount'];
/ h1 k6 z: _, U2 U9 ~5 F% D$ItemId = @$_POST['item_id'];( N: S4 U) \/ F! G* ^
$ItemUpgrade = @$_POST['item_upgrade'];
+ H/ R; K; O  n6 {2 A) c$ItemElement = @$_POST['item_element'];  E* M; G1 g. m6 B: I/ z; U
$ElementUpgrade = @$_POST['element_upgrade'];
5 i; ?% k: l* `0 T$ItemPierce = @$_POST['item_pierce'];
( |5 X) X+ z+ Y. t$ V################################3 l& r3 ?2 X5 U8 {: ~+ N
8 Q+ T- q: j6 {. ]" P
//Check both variables for empty value
% a& f% p+ a: k! X& U+ F7 s9 k: W* ^5 ~1 |. B1 U$ f7 v+ ^
if (!empty($_POST['char'])){3 D) Q- C1 K! v' C5 p
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
" N; ?' p5 P; L+ f; I0 @+ e/ i. |6 s3 L, Q  m8 W8 B
m_szName = '{$name}'");
3 D; s2 J' O: D7 I. ^while ($row = mssql_fetch_object($find)){
' m! p) R  C2 K3 Q4 l% `echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
* m0 B/ R5 @: `$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
8 ~0 y0 _( w" @1 A9 ?$ J
- A1 W, B( n3 x! p* W[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ( k# p/ A7 W' E; o

; m7 e+ }: G! F( }' B- U( T/ i2 A[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
' L0 ~! x3 r- B3 _: f6 n, j; z9 E- z2 [/ I
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 7 F& o3 A7 u+ e( P) J' ]
0 a- E7 E& I! g8 V( m( m7 e
'{$ElementUpgrade}', '{$ItemPierce}');");
6 E' H/ G, s; e* i8 `}
; U- B8 e$ o* O1 g  T' g1 Q$ X) @% l: l+ V" ^
}/ q5 m' V9 h" P$ J2 F

4 w0 N& D% H  B! \) |}
( c/ v  v. c9 J" k/ h" @# J
0 ^' D0 G! \: k2 }1 _& i3 [/ R$InitForm = InitForm();/ F& ], J- ]- A% e
$Listener = PostListener();
) C  W. n0 l! M) U' K( H1 h: J2 U% ?, W% P5 O
?>
/ \" i- W$ z# p) ~! u% s" _
. g& D$ `- R0 c+ @% i
# u0 ]1 e' {8 c: F4 _+ f: @' g1 U9 D. W4 [2 l% G* a* ~. f4 y

3 `" W  m, F6 R2 g
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-7 10:08 , Processed in 0.065504 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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