飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
- S" W! ]4 Q+ Q$ m# ~function Connect () {3 r! X1 p  y6 q' d1 V3 b! ^
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB / Q9 [0 l2 Y+ t6 n4 f, q! W

* v1 x) Q& O/ {+ H! c' [Failed.');  H, m. s3 L4 t! X3 f/ K; ^
}% ^/ o. b. ~" s: T; Y2 R
Connect();
5 I/ B% t+ G- f& b4 `" S0 y2 Q( [4 r" L8 V* V
function InitForm(){1 V/ m; h- ^3 H7 H% S
//layout for the form/ m/ r2 O; Q4 [7 g
echo "<strong>Send Items.</strong>
5 j. O0 t; j/ [9 Z; n<form name='select' method='post'>
& g4 J- w: K0 v8 \<lable>Character Name</lable><br/>% E" Q9 X* \% {+ `5 \7 d6 i: k
<input type='text' name='char'/><br/>$ b7 v3 N$ e+ V+ L
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>, X& I$ k4 {5 ]+ g
<input type='text' name='item_name'/><br/># {8 Q2 p: {9 K# d5 _
<lable>Item Amount</lable><br/>+ z! o, S, R' X
<input type='text' name='item_amount'/><br/>
: k0 O: e! m# s6 ?! Y$ V<lable>Item Upgrade Amount</lable><br/>/ Z; r3 V: y* _, X9 Q$ P, v
<input type='text' name='item_upgrade'/><br/>6 N1 x7 k. s9 b4 X+ I' j# v
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)) b& H6 _& C" Y
% W' [0 n$ R$ y4 z( [
</lable><br/>
5 u- ?8 B4 @+ f& U2 x8 `6 i$ o<input type='text' name='item_element'/><br/>
) a8 Q6 Y4 R* e4 d0 R2 u  o<lable>Element Upgrade Amount</lable><br/>
5 l. ?" }6 [& c& J+ q<input type='text' name='element_upgrade'/><br/>; Q2 U7 ~1 i0 Q' h; N
<lable>Pierced Amount</lable><br/>
9 {4 x$ _: f! w9 i3 E7 |9 L0 c<input type='text' name='item_pierce'/><br/>6 F) u  E9 n. X0 U
<input type='submit'/>0 f: x/ d. o& ^; c- m( V
</form>";
; g9 {1 g( w, W. ^}
: x3 {: q% I5 Y8 N6 d  z: ^$ G$ J2 E7 N! y# Q- C" @  t8 t
function PostListener (){
" N: `/ h: X; {, L7 J//Add more post variables if needed and add them to initform() function aswell* B% M2 h* p  x5 d0 V1 Y
4 `: \+ w: G4 r  x( w
################################7 b2 n, f2 K( k6 y2 X9 z
##### Connection and Post ######
( I! B8 {/ `; f. V################################) s/ }$ J9 ~8 J2 g+ X1 d; l# v
$name = @$_POST['char'];0 Z0 m2 O" o, l. [7 r% T9 }' u
$ItemName = @$_POST['item_name'];
) j- Z& s: S- p5 x$ItemAmount = @$_POST['item_amount'];
0 [6 O& h2 U3 X; B6 B$ItemId = @$_POST['item_id'];0 k  W- b0 l( M. E- y
$ItemUpgrade = @$_POST['item_upgrade'];
% Q# i7 }( o: O1 X- U$ Z* X$ItemElement = @$_POST['item_element'];
# y( W/ _* }) a$ElementUpgrade = @$_POST['element_upgrade'];, A- ?7 y4 m* w* i
$ItemPierce = @$_POST['item_pierce'];
: _) Z& A' [( L  R6 I: q################################
" ?- ?6 r7 W' m. N* f0 D. W7 Z* z. b- M+ W
//Check both variables for empty value
* t5 @0 h. K% s# a
1 @- p" B* e* q; `, I3 _if (!empty($_POST['char'])){* _" A8 N; ?, ~0 A
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
# M' b+ S5 t4 z% }: R' w1 ^0 F' c7 v. H4 B& R
m_szName = '{$name}'");) c! H- i) T+ |( }7 y
while ($row = mssql_fetch_object($find)){
' S  N+ B; F$ u1 h: c4 O) gecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
( W4 M7 p' Q& {& S8 _  q$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 0 l! ]9 [  w& M- ^
# L# k/ @; w/ w# N  l
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
+ Z- x+ {# e& Z  b; b9 |7 y5 W, H5 [( r% S. r% w( r. F& [
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 7 f2 H9 j* P# m8 M; t( A2 I' R

, K' e+ E( \& Y2 ZN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
+ ?% _6 w, a/ K0 a2 w' b2 T' f/ q
: }* u; s. b' J, v6 }4 s'{$ElementUpgrade}', '{$ItemPierce}');");
" H" g- X6 t" e7 ~! r}! C) U$ q' j, n' S+ X
/ k9 t: b' M( y  b0 h. j, i
}
# w- k' |( P. m' u( _
" H3 P" L" a+ {$ E}1 h0 z- s% ?0 e% q
5 X6 `" w6 s6 I6 u, p, g
$InitForm = InitForm();" \% z+ F4 a2 w* A
$Listener = PostListener();# p- `; T& I* W; Y; G

: I% }1 L+ k  r! F* b2 n, Y; @' p% u?>4 t5 D) O/ i9 c6 ^2 A5 D. i

: K) x$ h8 j0 |+ w9 y
+ H& j2 W  a9 R+ k+ p! t
2 h5 x- [. \  q5 `$ F( k
0 J  O; X4 ?) s, ~' V0 U
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-18 21:52 , Processed in 0.061806 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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