飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1088

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1088
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |正序浏览 |阅读模式
<?php
4 A0 T6 q& w0 Q- R8 zfunction Connect () {9 }; C- v; _5 `5 F) M3 ]
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB " ^, M, G5 ^  p2 [

* X+ s# Y( F& A5 l3 `Failed.');! h$ i1 U3 x, T# @: t6 L, c3 t
}
" F# W% y9 d* W) GConnect();
/ l4 X8 C5 @; G5 L3 e& P9 u+ _7 e( |6 x/ J3 q
function InitForm(){
1 [5 r0 k, W6 a" e5 S% ~//layout for the form
( g. d) a' ]7 x6 [) r8 a" cecho "<strong>Send Items.</strong>- g" z6 I( M/ z  O
<form name='select' method='post'>) R0 j* {" `1 m( Q9 G
<lable>Character Name</lable><br/>
5 N4 u* U8 H' t% o, V( a9 y<input type='text' name='char'/><br/>
" W$ a/ m+ C6 ]<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>! C8 s6 ~7 v+ _5 o* e) |
<input type='text' name='item_name'/><br/>
* H  s( P& `, @9 V<lable>Item Amount</lable><br/>! u9 C5 D' Y0 E- M9 D) Q1 |) t9 g
<input type='text' name='item_amount'/><br/>
" _' @" e6 P; c; P# E4 d<lable>Item Upgrade Amount</lable><br/>
: ?* u& H7 C. a9 c1 C<input type='text' name='item_upgrade'/><br/>
6 V; U* s) N6 b$ e' W( A<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)! @: ~  U: b: s/ r! k! Z5 T

3 R3 J3 I3 o6 J) f" {% w</lable><br/>
7 J4 _3 o+ k3 K1 H! [<input type='text' name='item_element'/><br/>
* {: z. |' h5 ?0 T- c. y<lable>Element Upgrade Amount</lable><br/>2 i# w3 p1 b' K2 Z0 A9 J
<input type='text' name='element_upgrade'/><br/>
3 t# r2 o0 j0 y; @/ h7 x, z<lable>Pierced Amount</lable><br/>
+ v( K: P# s) w4 w2 g: W- z<input type='text' name='item_pierce'/><br/>& {/ A7 S# F: r, x) t4 G
<input type='submit'/>
$ H& I' |$ g5 T& O9 M& S</form>";7 z8 r/ L2 ?* l" S8 O6 q; }" y
}3 C8 m/ z. r) W$ R9 {8 h

+ Z6 u( E  B: y# A9 Qfunction PostListener (){  c4 ?) b# ], a) {3 W' Z7 h5 a/ V( }( Y
//Add more post variables if needed and add them to initform() function aswell* c0 K. V4 D  L1 u: N$ {' Y5 @3 c

9 ~. {6 M! k; E8 J: ~' _2 U7 ]################################
0 ^) [" _6 m; N( C+ l2 Q1 N, s# p& L##### Connection and Post ######$ \6 S) s: Z/ F$ I3 p, t) `# H
################################6 d- `* T- c; f" J* I
$name = @$_POST['char'];& E0 L! a0 c- {. ]3 o0 W
$ItemName = @$_POST['item_name'];- u8 M& D2 S/ @( V2 ]% S# Y* u
$ItemAmount = @$_POST['item_amount'];
5 {- J. [( K( \/ r/ _& I* }, \$ItemId = @$_POST['item_id'];
4 Y5 p$ w+ i# ?5 q) k; D4 a$ z8 E$ItemUpgrade = @$_POST['item_upgrade'];* b0 d  k- B9 V: p1 j. u0 a% ~2 M9 ~
$ItemElement = @$_POST['item_element'];' B" Y' h+ O7 }8 [8 T# G# F
$ElementUpgrade = @$_POST['element_upgrade'];
# ]5 p; ~, u# y3 L2 j/ g* u. E$ ]$ItemPierce = @$_POST['item_pierce'];3 |- A# k+ P: Q% k3 F
################################, D# h& i+ j4 n) I3 _
6 T! K- i' O1 F  Y0 r
//Check both variables for empty value
; O( f% n# K  d5 J7 N
  |0 x) S( a4 ~1 H" P$ g) [if (!empty($_POST['char'])){
1 }' l# r. U; P, }+ L  ^: R$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where * D+ ^2 i: x6 Q% I( p
7 G, U, V$ N+ G# E0 R
m_szName = '{$name}'");- ^3 ]7 @1 x; h0 w5 Q  B& z
while ($row = mssql_fetch_object($find)){6 s8 [, X0 j: M: J; t& a7 e) J
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
8 N' L. H! W9 m$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], % c: @" r! ]5 _: d3 c" z2 f) i

. @- i( m5 ~. b* X3 n& C0 j$ i[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
8 {9 ]' `$ d* \& B( ^
3 h6 I8 i* {6 G[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
2 G  |, y- V& I# q, v# B7 p! q' c' F* Y
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ! c- g. W" A1 n2 @1 n. T9 S
% {8 M: k" E- M7 |4 v+ i& X2 T8 \' a
'{$ElementUpgrade}', '{$ItemPierce}');");! {: j; s! i4 y4 F8 v) c
}
1 `9 o- e" p) \: K% g# Z1 q' {  t9 p; B2 f- R- r% s
}) V; M+ Q* l( f: f5 X* I

' _, A0 `  R8 T2 S% O- q4 x. L}2 z0 n2 H3 j! a8 e1 J% c% e
' w: W$ K; [, r; Y
$InitForm = InitForm();5 K+ R6 |1 W8 @6 ?- s
$Listener = PostListener();
5 d6 Z+ t5 D/ C" D: t7 Y0 I! {, Q$ a+ O9 L  y) Q$ q
?>$ ~! H9 P7 `6 o4 {' ]) P( z0 P
: ~6 |% G7 y  U$ I) V# n6 j
: [% y. a7 [+ X8 o5 X5 ?
8 C2 X$ X5 l2 o7 }. {! Y, U# f

4 j: P% g! W' c7 d* n% J, K% h
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-24 01:42 , Processed in 0.062919 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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