飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php( G4 Q& O  a, B( S9 ~
function Connect () {
6 K" O7 n# l/ cmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
0 d2 N$ a% o; f* V- b
' b& C  ^% G( p- K4 o  V5 FFailed.');
2 c) ^  L9 E0 ]- g- q}; s9 X2 x; D' S0 \! N' a
Connect();
* e6 \) q& k4 ^2 q1 }$ w6 ]4 c5 P" x
3 F$ Q. {- L' |  ffunction InitForm(){
+ z; _* ~6 I: W5 |+ G1 h" x//layout for the form4 p/ g- y( M" X2 K9 B; s1 ^
echo "<strong>Send Items.</strong>
" }% B* a/ ?# h" ^/ U' A+ ]# c% {( \1 |<form name='select' method='post'>; q: @  N. S, g2 `- c) A! U2 `
<lable>Character Name</lable><br/>
# n1 W1 c! c  n7 S" D<input type='text' name='char'/><br/>6 R, @0 o7 ~4 a- E. N. Q  N3 H
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
; S! T* L& c" O9 @1 h<input type='text' name='item_name'/><br/>4 W9 ?: l# \" @$ g+ G
<lable>Item Amount</lable><br/>
% A! _5 o1 F4 g& E4 H" I- R<input type='text' name='item_amount'/><br/>
( z5 f" @/ N, R. F" u<lable>Item Upgrade Amount</lable><br/>1 m. O4 R' I3 X' Q
<input type='text' name='item_upgrade'/><br/>% V, I9 r+ ~) `- K$ m
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)4 {3 C) |- O* x% i' c: z
( ]8 ~" J( A3 j1 k
</lable><br/>
4 P  B# m( b6 V4 B& i<input type='text' name='item_element'/><br/>
( V( r- I% @8 L% q<lable>Element Upgrade Amount</lable><br/>6 @. U- O2 s/ j# b' d1 e
<input type='text' name='element_upgrade'/><br/>5 Y! e) a+ q9 I' q# V
<lable>Pierced Amount</lable><br/>
7 a" p% ?  n* L$ `<input type='text' name='item_pierce'/><br/>$ R" f; m% I/ X! q7 q# G
<input type='submit'/>
$ ^0 L; {  X2 G% z" ?</form>";
& F" t2 P. ~( I" |9 S- u& q1 {}
+ e/ r+ f% t& ~6 {: g! P' s1 L( u8 T: N' C
function PostListener (){# y9 j8 B9 R' _2 q% f8 v
//Add more post variables if needed and add them to initform() function aswell+ g# `  T: |. T; y) F3 m
9 H7 x0 f, F2 h. P* J
################################
8 C' \4 }% F% M" U1 C3 I+ }##### Connection and Post ######2 ~8 T% `$ o% p) |$ X
################################2 y3 i5 l- l2 [' [2 @
$name = @$_POST['char'];
0 F( f+ K6 h3 q1 n$ ]* w- o$ItemName = @$_POST['item_name'];& r' I; d) Q% M8 B2 p3 L0 m$ r
$ItemAmount = @$_POST['item_amount'];
% u+ j- P, k6 V: |# T* t$ItemId = @$_POST['item_id'];
# H- y6 u4 B; R# I) l$ItemUpgrade = @$_POST['item_upgrade'];
6 ^' Z2 @8 [/ a: Y$ItemElement = @$_POST['item_element'];
! H0 R8 X( g1 N: [1 r$ElementUpgrade = @$_POST['element_upgrade'];
* q/ N+ {* J& m# L8 ~: t. i$ItemPierce = @$_POST['item_pierce'];
7 u9 f! _6 _  T################################
* g- |1 e, I' j0 x; G  `) T3 r% ]3 O6 a7 \* s
//Check both variables for empty value
) b7 _0 O# m3 O5 s
- X* e! S, L8 u/ Q' }0 aif (!empty($_POST['char'])){
7 Y' F9 M& g8 R$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
3 k/ j; t3 A( I  ^2 C. G+ h! S( V! s9 m4 s' @
m_szName = '{$name}'");
7 H9 F' D3 `4 w3 @! Q" T- C' y) I0 Q, Bwhile ($row = mssql_fetch_object($find)){
+ s; v0 P6 S4 D( n4 pecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";+ [2 y/ q+ L7 F+ v
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], # `$ F* q, X- p8 i

* ?, \5 z8 M  N$ ?[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
9 \1 B' Q5 m7 t$ U4 b- z$ M1 l: S5 H0 E- L
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
0 D: e  g+ f2 k- P0 r2 o; X
' w5 ]& k) v8 y; i0 AN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
, D% ?" F+ y- E# ?( t" V; b+ |1 m( D& v% [3 H4 ^: q
'{$ElementUpgrade}', '{$ItemPierce}');");
3 t  Y; P2 y5 i}
& ^3 b2 l/ Y3 D/ U7 I
, ]' T  B! \2 p$ w* d}
5 K: p/ I: t& c% H! ]' h" z* H! u
9 ]& n* Q. T3 l  k7 q}$ _  j9 H) e5 t! b: L( N( R# b
5 @$ M0 y; {) F8 ~+ [' U# A0 B2 x
$InitForm = InitForm();, \2 n4 |7 A  _* Y
$Listener = PostListener();
/ v- P- z% ?* |( ?' w# S" g. V! z
?>
$ Q( q+ u2 x, x0 V' l; F# L- N6 \' w; g6 ?. o- v8 k
' }6 l7 I' ^4 @! S& ?, q! X

/ p. ]/ Q3 M; M( `" |" L7 Y6 y( S% @: _' E, h' t" Y
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-5 00:57 , Processed in 0.059936 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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