飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1088

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1088
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
( r% h8 D8 w  G' d4 nfunction Connect () {' |6 U) M( \* n0 u
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
. a, Q5 E6 C( f0 `" B$ {! h1 A+ Y! f* \& x; _  f9 t
Failed.');
! X# B5 E- u+ X4 C' b}) r' j0 T, m: _8 J( d
Connect();7 z" O* ^+ D# i# a6 \: c: d

& M, P- [9 C* |3 K. Lfunction InitForm(){: F5 d1 H6 U# _0 D. ?1 T' {$ P
//layout for the form/ d; }5 Y; X0 F
echo "<strong>Send Items.</strong>
# y6 v3 E" @! ^/ W! D) _) }<form name='select' method='post'>
4 F5 k1 [/ ~1 _0 Y# B9 v7 \' J7 L7 J<lable>Character Name</lable><br/>
% h1 y: F1 W# a7 ]+ X9 O<input type='text' name='char'/><br/>
+ F4 T( F  F4 o, Z<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>$ L# t/ l. L' D) k
<input type='text' name='item_name'/><br/>
$ e1 P* D7 d# ]<lable>Item Amount</lable><br/>
, L2 z7 {" ]' Q- F( u* a<input type='text' name='item_amount'/><br/>
3 H$ [+ K) f( w<lable>Item Upgrade Amount</lable><br/>
% s+ B' B9 q7 o0 K/ V$ f5 q# H<input type='text' name='item_upgrade'/><br/>+ `" k. Y6 B0 o
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)" m" X) g' ^$ Q* V5 ^4 A

8 b; w3 v8 t8 U& o8 h4 S</lable><br/>
% G) Z  k8 y6 F; L3 |' w  v4 e<input type='text' name='item_element'/><br/>/ o$ i$ A( M( K9 @/ i! C6 {% G
<lable>Element Upgrade Amount</lable><br/>
% P. Z# V: O7 B+ b4 X<input type='text' name='element_upgrade'/><br/>
% {9 v0 A+ E: B7 S8 d! j<lable>Pierced Amount</lable><br/>
7 O% ~$ d. P' Z. j0 z" Y<input type='text' name='item_pierce'/><br/>
0 }3 i0 Z8 g0 J<input type='submit'/>7 F( j& ~6 x  z
</form>";
; @  E- |8 _% V# D  Z  k1 i( Q: G8 h- H}, d$ M$ w- S6 E7 f+ r) T" `6 ~
% `" i0 `0 T! b# e8 l
function PostListener (){5 s9 `, v4 A0 E* E. ]
//Add more post variables if needed and add them to initform() function aswell
/ e: S. b, K# U8 Y; t7 x6 f* M1 N* D; y  _0 l& U
################################& Z( W1 O; a0 W3 ?
##### Connection and Post ######: F/ p0 i8 ^9 ?2 k, B$ d
################################
2 [$ z  b, p' V4 q2 w  d$name = @$_POST['char'];* @) o% x  a9 m; L7 G
$ItemName = @$_POST['item_name'];
$ ?' X3 b1 v5 S: p' X  c# o$ItemAmount = @$_POST['item_amount'];
$ V1 o& j/ G- B8 x6 ^4 ]) Y, g$ItemId = @$_POST['item_id'];- Y1 X! o& M$ g+ X
$ItemUpgrade = @$_POST['item_upgrade'];
+ C/ d# ?3 J# V* U$ItemElement = @$_POST['item_element'];% }6 a1 A) {! ?  `6 G! [
$ElementUpgrade = @$_POST['element_upgrade'];
+ C; l& m; A7 x$ }; o$ItemPierce = @$_POST['item_pierce'];
5 U, h- \+ e) U5 u, F7 G################################- D/ u/ K, }$ }: B& w) P5 v  e$ |7 }
/ y  m  P) q6 R% m. t, F. z9 y& `5 o
//Check both variables for empty value
' e( }: L" o  f" c) _8 m: N! e# }5 w/ L0 E) Y/ \. _" A. _
if (!empty($_POST['char'])){
; y% E+ j+ D9 d* M$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where , S( w6 O- }) y& O  _0 K

  t1 S: k' ?( H; @4 u5 o' p+ Cm_szName = '{$name}'");
( A, V7 `% n$ T4 Hwhile ($row = mssql_fetch_object($find)){
; W. @) Y; r6 Y# Q: |echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
1 O# t4 v  n. o! t, V4 ^2 T$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
3 {1 Y/ l5 q0 O
/ g7 X- G" U# I1 W[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], * F3 e' b0 N2 g& A) p7 `& G  a5 A

2 l' D* x- i5 F; n4 K- j% k0 G1 P[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
! m, ]$ Q5 g5 L7 l3 p1 N1 O, i. P1 }4 P1 T
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
' E, E7 f/ a4 ]4 V3 m  `2 n* @# Y
'{$ElementUpgrade}', '{$ItemPierce}');");
" V' B  t9 ^+ {4 v7 }/ y}
, `' Z7 I1 a7 x
" i5 m0 l6 V& \: E8 A- `}! A4 `/ e6 j2 d$ b* @! @
  ^) G# A7 }5 c0 a
}
/ g% _; @1 [$ p" h
  ~7 }/ i; H4 H% S$InitForm = InitForm();
5 |7 l6 i: x; w: D8 G) z$Listener = PostListener();
4 E: m5 M; |, N' y& L& A( {" p
1 w- D5 h2 B- c6 a% C?>, f# q& r* t  |
3 ^0 L: T5 c/ n4 b; O
2 _% ?7 c/ ^% E4 s- L9 j( ^7 T

* i: s+ ^& @% d; _1 t- s
7 j& l. U3 e7 G) y: O
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-24 02:56 , Processed in 0.062164 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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