飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |正序浏览 |阅读模式
<?php- ]: z+ j& N  H
function Connect () {7 I  ]' Y- z- W
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
/ z9 W. B$ b" g! x# c/ ]% h# z
; w" {9 K  a0 ~* _7 hFailed.');: V' A& E; w- l" j# i4 W
}
  N8 l+ s3 z$ _( TConnect();8 Y7 V. |* X" G9 l% c0 V9 |
4 v1 z& Y5 N  W, D! E' p( T* l
function InitForm(){$ x# A7 E& Y- I* R6 u9 y
//layout for the form/ y0 k/ h5 {8 b+ y( \0 u
echo "<strong>Send Items.</strong>
! }. c4 C1 c% P1 H6 E: J' N9 w<form name='select' method='post'>
2 |" f' U4 N" P7 z$ `" G$ Q<lable>Character Name</lable><br/>8 z3 A6 v# S- |5 W$ E* t1 o
<input type='text' name='char'/><br/># y# T$ i9 Y* @; R$ n, \
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>0 X5 ^8 J: J( b4 B1 n
<input type='text' name='item_name'/><br/>% Z% C6 T7 [. R. D& l
<lable>Item Amount</lable><br/>1 ^( K+ f/ h! i. M1 U' A  M
<input type='text' name='item_amount'/><br/>) N/ O8 d8 C2 F" y: F! e
<lable>Item Upgrade Amount</lable><br/>1 a1 u2 H1 o: l  I
<input type='text' name='item_upgrade'/><br/>  D+ w% U3 x; r; p+ g
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)8 I% T$ z! _9 B, ^

! l/ T5 j; s+ r% S* ~: U/ \2 W</lable><br/>
% z/ c' j; `9 M, A, N, |+ Y) M<input type='text' name='item_element'/><br/>
8 O! }5 b1 t$ T3 K7 w<lable>Element Upgrade Amount</lable><br/>
1 h, @$ ~3 y2 |5 t<input type='text' name='element_upgrade'/><br/>% V) i  B. s0 ~( m# z5 n1 m$ A' \
<lable>Pierced Amount</lable><br/>7 q7 U7 V2 b# y7 W9 t8 n
<input type='text' name='item_pierce'/><br/>
! E- C& r8 ?4 t' T# G6 p<input type='submit'/>
6 P7 ^6 X' q* {2 M* O9 ^1 O/ _</form>";) R7 t. ~% Q: R& o
}9 X, g/ O3 e1 I! n1 Z

4 J5 z) O7 @( gfunction PostListener (){1 Z9 h- s& I. S, I  e
//Add more post variables if needed and add them to initform() function aswell1 ~( [; l+ F& g$ w6 M, O4 c/ \  R- E' T

& o# F/ B7 `2 n  F8 j4 m  \################################; H& T0 @; [* i; X3 {4 i
##### Connection and Post ######, {6 B! t! v# A1 \7 P
################################9 a; t3 G# V& ]) x
$name = @$_POST['char'];# J7 b9 L9 s# ^. b2 {. @
$ItemName = @$_POST['item_name'];; M7 a6 R1 S4 Q/ K3 m" C0 k, b/ ~9 ]
$ItemAmount = @$_POST['item_amount'];- e4 z( B9 h, R# ?5 O
$ItemId = @$_POST['item_id'];
- f# L( {4 r9 }, I% o: @$ItemUpgrade = @$_POST['item_upgrade'];' |+ k+ |8 w  ^7 z3 @8 I" y# I1 V# |
$ItemElement = @$_POST['item_element'];5 P( f; G& I8 {! X
$ElementUpgrade = @$_POST['element_upgrade'];
5 H( q: m5 h- |$ItemPierce = @$_POST['item_pierce'];1 l$ p, ?: S0 Q/ b5 G
################################/ p- M7 ~9 `3 w: L; q  A* ?. E6 r, f) I

" q) `; {/ _% O7 k8 n$ p$ q//Check both variables for empty value
! _: l" _+ r  k
$ e1 [2 S7 L4 C& n: i- o0 M5 cif (!empty($_POST['char'])){
0 ?+ f/ X9 N9 P2 t0 s$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
" E5 K6 Y* m; ]3 J, s3 t: d* y( K4 E0 E
m_szName = '{$name}'");/ R: D/ V! p* _2 y
while ($row = mssql_fetch_object($find)){4 [2 r5 f4 I9 x  {* w7 P' g
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";; {! G6 f" E3 C) S/ ?- h9 |
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
/ i( l1 A$ z& F# ]1 c$ G3 k2 N. D3 \( E, ?" z4 V0 {
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
8 K3 B' }+ a2 K0 i
* M# N  e4 \7 d0 E: x[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 0 x( d7 N2 c# P0 d# x& W& B

9 a6 {+ \6 R5 y2 EN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
: k* ~( e4 p7 F& K# @: ?+ ^. x, h9 }' z( l" A
'{$ElementUpgrade}', '{$ItemPierce}');");
- ~4 L! A- }, F5 v5 }4 k}
, {0 g: I3 @9 s/ x
# ^9 Z" {  @( _( N% @}1 g) p) x" Q  c1 c. y; l
6 Q. Y3 T5 y5 U8 @$ U9 e& m
}( ^8 k/ {4 {9 {0 ]# n

4 E9 A* a. g4 N6 U  h4 X) }$InitForm = InitForm();
4 E3 B- G" k- [7 K$ B$Listener = PostListener();
, f( m: n( D2 M( v% K  u# k, K* W1 W% B$ T
?>% G5 w% r( S- _  n2 j

0 D% z5 T5 f' J; t" H! k! U3 h- K4 p

4 `% C* d' Q/ C, O+ B
# J1 l* P3 k1 d. r% F1 R: |- n0 I
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-29 23:37 , Processed in 0.060081 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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