飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
9 d( ~! C: p3 S8 d$ P8 xfunction Connect () {( U4 g0 S3 E6 n- u- i* f+ ]
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB + D& K' [# I! A7 y

4 n  G3 N; P# w1 p1 ?  cFailed.');
0 G! w) l, f6 J6 j7 N}- ~3 [% f, y& o# W- {! X
Connect();
2 T" U! q# {3 s9 Q  H7 l* U3 o  ^/ E- ^1 p2 K; \
function InitForm(){
+ H$ D& a- }6 Q% f//layout for the form
+ P! j8 i& e2 n, x6 }9 Gecho "<strong>Send Items.</strong>2 k$ ?1 B2 {6 G, E) ]7 S( R
<form name='select' method='post'>
7 h' L4 s9 |( D! ?7 _<lable>Character Name</lable><br/>/ ?' `% Z5 _& n& M* f
<input type='text' name='char'/><br/>
- d/ d. m0 ~, N0 G& ~% J<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>2 z8 J( G) u3 z+ H) o' M
<input type='text' name='item_name'/><br/>  K. ]* x. w, A3 Q: Y; P
<lable>Item Amount</lable><br/>1 w- w% I" p. s. M: Y5 _9 Z
<input type='text' name='item_amount'/><br/>
6 c- w* L# r, }, h4 V$ S<lable>Item Upgrade Amount</lable><br/>
$ a1 K( q% C' x5 W1 d<input type='text' name='item_upgrade'/><br/>, T# d: G# D7 M) D" {
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
3 o3 h( M& [7 m0 W
0 u& j$ E$ r. V, [! m</lable><br/>. K( X) C) R  D$ I; u
<input type='text' name='item_element'/><br/>
  r) `3 S5 r, Q3 s7 N<lable>Element Upgrade Amount</lable><br/>
9 @# [$ N" p3 K# E4 v! U( j<input type='text' name='element_upgrade'/><br/>
# Q1 q! a. F9 W0 ~3 ^3 a) ]/ M<lable>Pierced Amount</lable><br/># ]( t, V7 C. f2 w$ L) P. G; v3 [
<input type='text' name='item_pierce'/><br/>
" n: O8 Z* F4 e, [<input type='submit'/>: o/ X2 R; J9 b+ C  o/ [8 r
</form>";/ B5 Y5 B4 u0 E7 v5 d
}
$ }2 n8 r" V6 W( s
6 C1 L  d; c( ?+ U1 jfunction PostListener (){
* {: I% [' n5 E2 S$ Q//Add more post variables if needed and add them to initform() function aswell
+ r8 ^3 n8 y' Z! ~4 D/ Z) y7 R5 C  K: R# H% i8 R1 y
################################
( g5 m2 D& U0 ^8 H6 c; j##### Connection and Post ######
6 E  E1 R9 v2 Y9 U# @. _* x################################
1 ^; V3 O( C9 j$name = @$_POST['char'];
5 ^7 e; W! w. P: M$ItemName = @$_POST['item_name'];
8 c" ~0 B5 x4 T/ K$ItemAmount = @$_POST['item_amount'];
; |, K6 S3 x# T/ h# `$ItemId = @$_POST['item_id'];
3 T1 S8 o+ M, l* x4 D$ItemUpgrade = @$_POST['item_upgrade'];1 ~; A+ o$ G7 a) F
$ItemElement = @$_POST['item_element'];6 N* R8 z  \. K! v; g
$ElementUpgrade = @$_POST['element_upgrade'];) |' h! v5 V* L( Z
$ItemPierce = @$_POST['item_pierce'];* D# p6 |9 T/ e/ ^
################################9 ^& n( o! z, ?" ]) s

8 B$ O* g& z- m0 [! D, X0 u! ]//Check both variables for empty value
1 Q: P9 K, S- P! j" h' g& A4 _/ Z# V+ C! `, e- ]
if (!empty($_POST['char'])){  z4 l6 s2 I5 k
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
& e% P2 }8 [+ @3 i4 t
0 a6 f( q4 l- Z5 G$ E" d, |; Pm_szName = '{$name}'");6 ~! U  m# V" Z. v( ], a  C# y
while ($row = mssql_fetch_object($find)){8 p6 c! ]- x( Q7 X$ @, H
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";1 h) x+ D- j6 i2 K
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], / B) w# F  ~1 e
7 t% @5 I8 M8 x9 y
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
( P) r9 e! V: |) |4 T  Q
5 S4 z& \. ~' u+ f9 }' n6 S! D[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ; ^4 a5 T% @1 v. j" Q) {

' y; w% Z% k1 f. T' c( X8 b$ VN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', & i9 T+ O0 p) W1 v6 K# j' o
/ o3 F) l# a1 t9 [5 [4 ^; f7 v; L" {
'{$ElementUpgrade}', '{$ItemPierce}');");
/ y# H9 z* ?" W  H/ L}
  u$ Q' r9 W' c7 h, ]5 P
3 d6 M, m( ]5 r}
: _" Z; ]. z% k& |! u( S' c6 ~# C' |5 T! `! \
}
. b' T- C, k0 h+ q7 Z( {  V5 U$ D. \! M  ]. h
$InitForm = InitForm();& v3 [) d! J% c  d1 K% R
$Listener = PostListener();0 g7 t0 P, {" l9 d! v8 A4 V

! d# b& v5 v/ ]  o# x?>$ `* o( Z, K( Y) p
1 \* L$ p% _; {) h1 H: D( W0 o4 D8 P) `

* S* }! v6 u1 }8 _! F; c) X0 H2 O0 ?$ l% |; n  |6 i

: S, @1 \& h4 I" ~$ ]
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-11-26 11:24 , Processed in 0.059734 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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