飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1088

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1088
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
* i) q) q" n( x8 L( \function Connect () {
) _: D% L- l* r8 I6 I+ u5 l; M2 R; Cmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 3 p+ y. Y6 u6 ^6 J1 {4 h
: c& U: g  ]0 R& o
Failed.');8 A- X* ?; A8 x- a7 t; o0 C/ v& J# S
}
% @) ^+ p3 Z4 GConnect();' K* Q  P6 J8 E/ E

6 z( ?! @; v8 V$ C- T$ l7 yfunction InitForm(){. @6 s) e; o9 c) ~. m; Q
//layout for the form
' J7 ]8 \* I( ^0 L7 t: Pecho "<strong>Send Items.</strong>
1 [% G5 n4 W! m+ [" _<form name='select' method='post'>
. l0 ~# h- H7 t<lable>Character Name</lable><br/>3 a) ^0 X0 O; f7 I$ o. `
<input type='text' name='char'/><br/>
0 q, P5 s# n/ u, A# p<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
$ M- {8 E0 o2 z! l3 B. i6 u<input type='text' name='item_name'/><br/>
( ]# {+ L) V" c" a, p2 z<lable>Item Amount</lable><br/>; b2 X/ Z7 Y7 A! t9 D' P9 T
<input type='text' name='item_amount'/><br/>/ U  K5 }7 U) Q/ U- T+ l7 [
<lable>Item Upgrade Amount</lable><br/>
" N: m5 C3 ^% p<input type='text' name='item_upgrade'/><br/>
5 b/ {9 ?  X: }% D: z" R0 r<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)  a! u/ ]! s, h  T: O' g3 p
' {, `6 V+ f% [$ Y
</lable><br/>
0 J1 |; D7 b& a/ m<input type='text' name='item_element'/><br/>
9 Q; T1 k/ b- N- ]+ ~7 f<lable>Element Upgrade Amount</lable><br/>4 K7 r' q4 A. b' u" W  y
<input type='text' name='element_upgrade'/><br/>
' ?2 `( O* E* R# t<lable>Pierced Amount</lable><br/>
6 k) g  Z, U- |+ u3 b<input type='text' name='item_pierce'/><br/>
' x( x& `) M9 b# `8 t7 \3 B- v<input type='submit'/>( s5 m$ @; M0 z1 V# g3 ~! P
</form>";
: ]8 |/ q. D% Y) B# g: j}5 R' K' q7 v% E, q+ g5 i0 w/ {/ N9 f

. f# I" f% x+ a  ?' Mfunction PostListener (){
9 q0 g2 p6 h, w# e, `# k' |, i//Add more post variables if needed and add them to initform() function aswell
+ v3 ^, z4 i$ R& y) g2 L
5 O) z( b( G9 m& S################################- a3 w+ K3 H' e9 M7 M/ p" R2 m
##### Connection and Post ######* _" D. y; Y! F: v- T
################################
! m: Z3 i- `0 p: P1 x) i$name = @$_POST['char'];
% |( y8 Z8 n  q" G2 ]. M$ItemName = @$_POST['item_name'];
3 A/ `+ ^% _! [2 v% v2 z/ b2 h$ItemAmount = @$_POST['item_amount'];
0 Q* N  o2 f. H$ItemId = @$_POST['item_id'];% J/ E* e- A" q' }6 w' |
$ItemUpgrade = @$_POST['item_upgrade'];
! C6 v2 {( |0 y/ u( B$ItemElement = @$_POST['item_element'];5 q) ?" c, ]  ?2 S
$ElementUpgrade = @$_POST['element_upgrade'];0 o+ _8 z8 f0 s( }
$ItemPierce = @$_POST['item_pierce'];' @2 ~9 n' A' W) q* p) k
################################
/ H7 m5 o3 ?& z8 J( w) n
6 E4 p1 d% q, C. _( U//Check both variables for empty value
7 }& c) U" s: m+ a/ B: h* W; U& F4 t& N! _
if (!empty($_POST['char'])){! r2 z9 D. o) G3 h$ a* ~
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
; u: m' l! z: ?* a4 _- @- r/ ]8 B. p" h0 H( |( {4 e! n9 h( O
m_szName = '{$name}'");
& ^+ h7 Y: ?" ywhile ($row = mssql_fetch_object($find)){
. ]4 v5 {% V- M- P7 ?& Kecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
- P2 V" w$ m0 w+ W4 V$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ; {, \/ {& h% n; J8 y* E, R

& t; d% w8 t- ~* j1 I# u[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
" {5 h# D. {5 \+ f/ p& B1 T7 S, T" h
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', + f; X0 g/ b( D( c

( w1 k0 t& {  ~N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
# ^+ @- e4 c$ L' g5 l
4 o! J) v/ O7 I) M# U8 E  H8 \'{$ElementUpgrade}', '{$ItemPierce}');");& s6 j! V5 X8 ?2 `
}
& K# f* f$ ^9 v; R
; Q+ m: \: O1 T0 [. |1 ]" x5 ~}9 k. y" o: e1 q7 d( r/ j

& m) \! H: \. ]+ S2 v}
# w+ s' p1 R. N3 s$ d5 P2 ]) B* w. o% O
$InitForm = InitForm();# A8 m* {/ v+ D2 r( J
$Listener = PostListener();1 H9 C1 c" t, a& n$ Q" P  ?! U

6 k. P; X; z+ A?>
" Z* |) L( }# r, |$ E' [
& k1 F+ r. h' |( x$ E# O  e& ?" S. x6 @+ y' @# W
2 D6 H# }- S; ]. c$ t* r

& p1 Z) _2 @5 S) u- K' M  Q
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-26 03:43 , Processed in 0.059531 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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