飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
9 z/ O" q: z( O/ Rfunction Connect () {7 [. I+ ^, [( ]" g9 S
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB ( `2 z; r' ?* g; i- u5 i

$ f5 L2 A: H  {! {Failed.');/ l. Z8 m6 y- P$ H, ^
}
' }, [5 d. C# s$ y# i& ^4 jConnect();
4 D- q8 y& u/ J8 k
- ]" T* o/ E4 y5 mfunction InitForm(){
/ g. a# N7 c3 \! k3 ]' {8 d8 s//layout for the form% v# a& Y/ k) b5 |
echo "<strong>Send Items.</strong>
  f# F- ^. e; \* t% K& f. ?+ Q<form name='select' method='post'>" V: R. \: u0 |$ L& ]% I; f
<lable>Character Name</lable><br/>
# J$ V/ }3 S- p- a' q5 h/ y' ]6 g/ G<input type='text' name='char'/><br/>. e: b% `' m5 m; ?9 B3 W: p* l
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>& }% [1 X5 D$ v8 _6 n
<input type='text' name='item_name'/><br/>" l: A' b1 H; z0 D
<lable>Item Amount</lable><br/>
( G& Y* b" m! Q" P4 Z) Q<input type='text' name='item_amount'/><br/>
6 ?! V- L+ ~9 U- {- E+ N- F, b<lable>Item Upgrade Amount</lable><br/>& i- _! Q3 {. |. {. S
<input type='text' name='item_upgrade'/><br/>* W1 n4 _- i, s& n* a
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
& Q4 ~, T4 J+ L( k
' H) W' Y1 G! s6 k( P" h% h4 Q</lable><br/># O+ i& Y5 K2 l, X) E
<input type='text' name='item_element'/><br/>
' d$ ?( l* {% A; Y4 L<lable>Element Upgrade Amount</lable><br/>
  D1 Q# [9 _* G' v<input type='text' name='element_upgrade'/><br/>
9 J. A5 h: R+ w, h$ v<lable>Pierced Amount</lable><br/>
  x( t2 u& x% _: U5 {% {<input type='text' name='item_pierce'/><br/>
- I  `, ^( w8 b9 A( e+ h, X  ^<input type='submit'/>
) I7 v' l9 g% X</form>";+ U3 z: E2 g( N' R. A
}# [2 G, j9 r8 P2 L

) u% i1 b/ h' m  R, C% G* Ufunction PostListener (){
/ i$ k; v. z, }5 O' l2 a+ `% Z//Add more post variables if needed and add them to initform() function aswell: H0 f2 b2 s: B

, X& B  ^, j' T- g################################
% L4 A& }: E2 _* `( {##### Connection and Post ######
5 N$ M: y3 P8 ^% J* c################################' s# S0 Q0 d+ k
$name = @$_POST['char'];) s! O6 B$ _) H4 p
$ItemName = @$_POST['item_name'];2 H" ?$ g$ i3 y6 ~3 e3 |% f6 j
$ItemAmount = @$_POST['item_amount'];
# V1 L  h6 c! ]% x( U% \- P$ItemId = @$_POST['item_id'];- \& I/ q6 J  A- Y( G% U
$ItemUpgrade = @$_POST['item_upgrade'];
8 h6 O( p4 C) w5 n7 K& N6 ~$ItemElement = @$_POST['item_element'];# i: |0 |$ q! N3 V7 z
$ElementUpgrade = @$_POST['element_upgrade'];7 I+ `, l, f5 Q. W  E% s2 l% ?, q
$ItemPierce = @$_POST['item_pierce'];
/ a: h. x  u+ ~" ?- S################################
0 }' _" @) S: ^8 V* F5 ?5 \1 q$ H8 W7 ^
//Check both variables for empty value( \& x+ o3 N' W4 p- [
* ^' k5 i" Q9 ]$ y; n$ u" N
if (!empty($_POST['char'])){
3 E0 Y2 z- |2 y$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 7 s8 V6 K5 b* n# {$ ~) d
" M  Y1 J5 {8 @% c
m_szName = '{$name}'");. K/ w! E0 E/ H5 Q- X$ }% i
while ($row = mssql_fetch_object($find)){
- G2 O1 j8 t9 Aecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ {9 H' B8 h" M6 \( J  j4 M$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
$ f% q# n. U: }/ g; X: B% W0 v7 W% X7 N1 J9 L0 @
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
$ `" K  p# t5 F2 i3 c$ @2 [+ M; W  E! S& o
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', . h# `) i5 p7 W9 h
* O& d/ Q3 X5 `" _& ]1 r* l& H
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', & i* w* z3 \/ K" n+ _* X
. S( T3 M* |0 U+ i. N8 t8 f+ h
'{$ElementUpgrade}', '{$ItemPierce}');");- ~. |* h% ?  v, }
}! \( Z0 u. i) V* E6 g

1 W! M6 q  Y) D6 {5 o( P}
; Z$ `2 j; h- g4 E0 E
% o9 f2 v2 T" }! N+ B# C}* R7 w9 m% P4 J- _

% w% I) f0 z9 k) h$InitForm = InitForm();4 B* R5 i+ }: U3 V9 a
$Listener = PostListener();0 Q3 x6 C9 E3 @' g# ^1 Z; q

4 }3 O: A/ \8 A" r% C?>0 D) E6 P$ j7 ^8 u7 W9 G1 Z4 Z
. s4 \# v% j+ Q9 q6 Z
" H% y* R0 r0 e# G, V" q
! p5 _$ J5 _  T& W

2 t& d; i: \- u% u5 o; D. `( t
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-22 07:36 , Processed in 0.061749 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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