飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
$ a5 @" l. J0 S0 r* q; ^2 Sfunction Connect () {
% g6 R/ {+ j. ?) ~# K" X* lmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
, p3 Q. ]$ E: N% r: x6 q9 S2 }
  P) x& A$ _, ]Failed.');  {3 ^" b7 J0 l2 e8 C$ d
}
8 X  K5 m3 ?4 E" ~& d9 \Connect();
4 `2 A- D4 s1 x6 p
2 q3 b6 B+ D$ \3 J2 Q$ i1 c$ Lfunction InitForm(){: _; b& }7 F9 _% H6 y
//layout for the form
$ [8 G; ]; \+ Y( iecho "<strong>Send Items.</strong>
# ^2 i8 ]& B2 P0 X% x# ~: w<form name='select' method='post'>3 t; ?) J' k0 G: H- }/ c: G
<lable>Character Name</lable><br/>
* q* q+ b( S$ \0 Z5 g: [$ d/ P<input type='text' name='char'/><br/>' l5 `2 `/ i0 I2 k
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>/ b9 h" }" [8 n5 h; L
<input type='text' name='item_name'/><br/>  ?: T. c/ b/ z' ^
<lable>Item Amount</lable><br/>
* G& e8 Q6 \* L5 J+ p% \<input type='text' name='item_amount'/><br/>6 ], |5 {. B; L6 I0 T, D3 z) q
<lable>Item Upgrade Amount</lable><br/>" k5 F8 ^0 {& s# d* n6 j* v$ `
<input type='text' name='item_upgrade'/><br/>
; w! r! ?) Y, \2 ]* O0 W<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
: P) G3 m1 U1 w' n; u* u1 G+ a9 g
</lable><br/>
; U1 z2 M9 b9 l1 G<input type='text' name='item_element'/><br/>
, a& }/ T  n/ L. y<lable>Element Upgrade Amount</lable><br/>" x+ c5 a5 b- j7 V
<input type='text' name='element_upgrade'/><br/>& i3 D' ?! s1 Q! |4 T9 z
<lable>Pierced Amount</lable><br/>
0 O6 i7 k% y# r3 A<input type='text' name='item_pierce'/><br/>
; S6 t' X7 O; V, c  e3 R! B<input type='submit'/>
, O* w  _% o. }- a# M4 {. ^</form>";1 R6 T. S6 e8 y8 d
}- j) }+ p5 h/ y+ z# g1 U" g
% f* X7 }! T! l& k8 S) }- u" }8 W
function PostListener (){" G4 m2 ]8 ?( u* `1 y: J% y: `
//Add more post variables if needed and add them to initform() function aswell" R: M' N8 A# u! @

. ]7 y2 R2 W3 F" }7 h################################' c- Q% S- {8 Q/ s% w
##### Connection and Post ######! L- J  o( C# z  P! `! o
################################5 W1 a. t- T1 g2 c" f) R/ @; f4 [. d
$name = @$_POST['char'];  s) _) a; A/ {# f" K; v2 o7 e; W
$ItemName = @$_POST['item_name'];
# J4 S/ c- k" X$ItemAmount = @$_POST['item_amount'];
( R& e4 n3 W% k. x/ F$ItemId = @$_POST['item_id'];
/ G5 X3 z3 [: ]: ~$ItemUpgrade = @$_POST['item_upgrade'];. [8 g6 ]) P- X. Z3 i/ Q# h* ?1 \& H
$ItemElement = @$_POST['item_element'];
8 U: o7 p# [" h0 R$ElementUpgrade = @$_POST['element_upgrade'];
! f0 q4 ?! S% l8 W, |$ItemPierce = @$_POST['item_pierce'];! }1 t$ x- j. g9 y+ M/ x
################################  \( s2 s$ T; T) _2 U

- _1 i' P6 Q* P//Check both variables for empty value; |" m% m3 Y9 B6 A$ W

) U' ?  y5 t7 b" {9 a7 Eif (!empty($_POST['char'])){1 i$ [# J1 U; |+ M; ?  Z9 f2 W& ]5 a( K( |
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
& o. g/ U/ Y. w3 ?4 h' B7 N) a. z9 m4 A$ C; e! F
m_szName = '{$name}'");
+ o5 Y0 Y/ G3 @: g, Wwhile ($row = mssql_fetch_object($find)){6 O& W: @# b+ X$ m( L/ z
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
) P; \- ?/ k) I$ |$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
! i6 ~* o0 A- M/ L" H/ ]8 x3 r% |/ ?5 g0 Q
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], + M" |" L5 q, }5 K# x2 S3 W1 ^4 i
' P) M! l$ P2 X% H: t) N* m
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', $ J! L% O0 Q8 D$ Q( i( J" H% S
. L- f  Q7 b' H- ~
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
0 q" {) B. h4 t5 @2 n+ o( X2 ^! l9 ]2 N) _9 \! Q" P
'{$ElementUpgrade}', '{$ItemPierce}');");
6 Q; J# O1 w" i}# ^4 L! n. y& j8 O3 `

3 p- e6 W( _3 U, q0 J' N) Q}
& F9 O7 z6 N8 }4 l5 S
7 y) N3 ^7 E! ]' k}
' r7 P& e# ~$ g, }9 i$ b& X. v) T' B/ G
$InitForm = InitForm();
2 T: \/ s5 K  U$Listener = PostListener();7 \  E! s. _# M; l

* ]5 h+ ~5 E8 T* C) j?>
3 H3 r' y! t8 g4 s
9 B2 N$ P6 L8 J% \& O6 @9 O7 A7 F

6 K- C+ ^# W0 P# @0 q$ W/ T3 p6 t) ?4 }$ P; @1 ]& G' Z, x1 |1 J
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-15 03:02 , Processed in 0.056042 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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