飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
# u, `/ \) M4 p" y9 vfunction Connect () {
; X# O- `7 {3 e" ^- R) V1 W( Jmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 7 |) ^% Y# v. `, _- I

8 ~! q$ {" z! _! y- z, oFailed.');  ]4 A% G: b9 z  W4 [
}7 K% U- @0 v& m4 [9 X& Z3 Z
Connect();) T/ y8 j  x1 \1 G/ \. U% K
2 _. g+ o- c/ E' A1 N! _
function InitForm(){2 U& A  `2 Q1 K# W; `' _
//layout for the form" {' I4 s# G' w- [% d' [% a5 W( X
echo "<strong>Send Items.</strong>& ~( I2 q# t$ K' j6 k
<form name='select' method='post'>
( F; {" E9 A) W4 _0 s9 R<lable>Character Name</lable><br/>
: N# M3 W/ h2 c<input type='text' name='char'/><br/>+ l5 b/ G4 C9 a) _- ^  Y1 c" b0 x
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
: N: j* X' O* F; [& `7 N) w<input type='text' name='item_name'/><br/>0 i- y8 @& ]4 i, I
<lable>Item Amount</lable><br/>
5 l* w0 M+ [4 o% r7 z3 w/ m<input type='text' name='item_amount'/><br/>3 ]9 [/ |$ c5 x3 S: c2 ]6 t: X
<lable>Item Upgrade Amount</lable><br/>
" j0 u2 E7 ?0 C<input type='text' name='item_upgrade'/><br/>; X  U6 f% M4 }4 }
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
+ X3 f& [5 b+ ]1 i' ^6 A8 K
$ F  D& m! r' n8 Y+ [5 w</lable><br/>
# J( I1 N% Y: q! ?<input type='text' name='item_element'/><br/>! U9 p; O: I2 b, k3 @0 e
<lable>Element Upgrade Amount</lable><br/>( C7 t7 N! A& ]  ^. {
<input type='text' name='element_upgrade'/><br/>; T6 @9 w4 p, \# y/ j2 O2 G
<lable>Pierced Amount</lable><br/>( R$ g( W3 Z' Q( T- r: M+ @
<input type='text' name='item_pierce'/><br/>
% _' D% n5 h$ ]; W3 w3 e<input type='submit'/>
( J8 L# L- o, R6 W</form>";
* w' m& s# C1 S}( m8 l  a% P0 D+ c# K2 x

) C4 n2 d9 A, X' Dfunction PostListener (){$ a9 d% l3 I& L- L3 o/ j
//Add more post variables if needed and add them to initform() function aswell  I2 G* r: x" H# q
# K  [! Z: V7 H6 ^& Q7 P
################################  x( ]2 \3 [. B$ B& i6 _8 ~, Y; i
##### Connection and Post ######
2 R1 ]7 v, h1 E" b6 d% \################################
& v. w8 U+ W9 z& L" T4 I$name = @$_POST['char'];" H4 f$ d0 b( o5 L2 J! @
$ItemName = @$_POST['item_name'];/ x0 ^% g+ V5 n$ z& x
$ItemAmount = @$_POST['item_amount'];
5 u. c+ c0 X, ~5 j* {# H$ItemId = @$_POST['item_id'];
& V9 l3 C" X7 M/ {8 u5 [$ItemUpgrade = @$_POST['item_upgrade'];+ {9 x* B+ J4 b0 a) P
$ItemElement = @$_POST['item_element'];
! b% R2 G) e- R( \7 L* j3 [4 c$ElementUpgrade = @$_POST['element_upgrade'];
: O3 q- E- h7 K& b" ?* i5 y$ItemPierce = @$_POST['item_pierce'];2 z' D1 Y4 t0 E/ U# U
################################
7 n. G. }" k/ I1 J2 m9 ^4 e: H- R8 r; Z" I
//Check both variables for empty value
4 t" P" T" I$ Y- u/ n9 ^3 ~8 Q! _% k5 m# T! z5 \
if (!empty($_POST['char'])){8 ~  B# f  ]: J4 D" T
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 r+ A1 d' ~6 l) ~7 g0 V; N9 e4 i# |# ]8 w8 W
m_szName = '{$name}'");
3 P. J" ^- H7 d) q! q4 awhile ($row = mssql_fetch_object($find)){: t+ A1 g/ P2 |# {) y* h
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";# x! F! F8 W1 r& O
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
3 W  ]) t- B2 j& q, I' I0 V  A* J5 _& S+ f3 D
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
  L) i! L! o, p; N: k
) M9 D7 Z3 D* d* Y' g+ c[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ; X: T  `3 f! t7 @) ?$ A. ^- j) g

) M) \) ^- O; v3 d$ o5 K) DN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', + ~, T7 {0 h' t% L7 t* l9 o8 z

) j$ I7 U( b) P5 b) u* C'{$ElementUpgrade}', '{$ItemPierce}');");
# G3 L0 E/ I+ V' \3 I" B" w}3 w. U' S+ o6 w1 V$ S

4 n6 }9 `  ?6 c/ t7 ?' p" |: ~}9 E" ~& {3 J; q2 I" Q

2 |# e# B$ j; y$ ~" `! {}1 l& O1 h4 A) Q# p. g9 g
" G4 Q* |1 ~4 Z8 l  s
$InitForm = InitForm();1 l/ J& I* Z! L' L$ v
$Listener = PostListener();
& m. q1 L8 A5 k% g; z; t
4 s! g1 z, F' `6 V7 c( j0 O0 M?>4 ?# |3 L- l' q

" l# h1 {5 g/ D- F
8 U" E  ~2 M  t* K2 J3 {* o& ~" I+ S, q3 L9 y

" N& }) C  c9 \/ [* L$ d
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-9 17:04 , Processed in 0.057382 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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