飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php; r0 j+ M/ ~6 s2 S- z0 y9 c
function Connect () {7 h/ j+ Q& ?) F4 w5 ]1 m
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
) S& o$ A1 m+ d* s* N
  X- v* A4 M0 {1 kFailed.');
: p; ~- ]% J+ V$ T}, c( \! T/ s" Y" g
Connect();; X* W1 w1 E4 c6 b! k

) l8 ]+ m# ?0 k# `( ]1 pfunction InitForm(){
& l! o4 k) o- M4 p8 r//layout for the form# N9 `% M8 B) k% q/ u1 z6 H1 k' a
echo "<strong>Send Items.</strong># f3 e. ]% ]% S
<form name='select' method='post'>
) V+ [" W$ L+ I0 `! T<lable>Character Name</lable><br/>
( [. p" g5 \6 R& |<input type='text' name='char'/><br/>2 `( |8 x' E* E: ]) Q1 p! @* V
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
* e9 u; C" Q! O/ A# |0 @, G6 Y<input type='text' name='item_name'/><br/>  O2 e" N  Z7 _7 ~
<lable>Item Amount</lable><br/>$ h  A& u, J4 N
<input type='text' name='item_amount'/><br/>
. P5 v! ?1 ~: ~: h. E* ~<lable>Item Upgrade Amount</lable><br/>
6 H" X4 y  A$ V<input type='text' name='item_upgrade'/><br/>
" O! z( ^/ f) s+ M3 K# \<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)/ R! Z1 b/ o" c4 O
+ {/ [7 a: F) \9 ^
</lable><br/>+ A- g3 N0 W# y+ P: ~3 x& F) `
<input type='text' name='item_element'/><br/>
/ R  m$ K9 A; E- @: v<lable>Element Upgrade Amount</lable><br/>
( w. s) F" B1 o: ^<input type='text' name='element_upgrade'/><br/>
: o+ ^- o% e7 J2 j- n" @. y; J<lable>Pierced Amount</lable><br/>6 T5 O8 l( X2 z/ g+ ?
<input type='text' name='item_pierce'/><br/>
! X; p1 r' u3 V% [<input type='submit'/>
* B) I* B1 x5 z</form>";4 V* c! E% g: w& o8 |
}& p  |3 O- h/ K9 U& j" ^1 F% Z

. M9 F* W) Y+ _) b8 y7 ofunction PostListener (){
  b2 R/ ]# B8 m8 p7 ?# h7 {, j//Add more post variables if needed and add them to initform() function aswell
- L" `, ?$ `, h- i& y
- |) X8 P2 t& S# k7 L& h) d" T" o, N- _################################
: ?5 i3 P& M: @% l& w$ P+ p; b##### Connection and Post ######6 G  a2 S, l) c$ ]" Z3 |
################################
5 a- q' E9 R3 }$name = @$_POST['char'];
3 }( P3 I* s9 s* K/ \$ItemName = @$_POST['item_name'];
0 l* m! _% z1 E) [$ s! _2 j( O1 I$ItemAmount = @$_POST['item_amount'];  P9 M, p$ x, s5 |# A
$ItemId = @$_POST['item_id'];
8 U  S% u* ^! D8 @6 W2 \9 u$ItemUpgrade = @$_POST['item_upgrade'];9 q& [$ d- U+ Q  O/ E3 v) O
$ItemElement = @$_POST['item_element'];9 J1 k* ?1 L4 v) M! Q2 D1 u
$ElementUpgrade = @$_POST['element_upgrade'];, w9 Z9 U8 d0 W
$ItemPierce = @$_POST['item_pierce'];) X0 b( Z- W  F6 M8 \% p8 O
################################; ?: f6 x6 p/ K9 B- Y* j
5 T6 e% d; i! `+ F
//Check both variables for empty value# M/ b; s$ N/ V2 v7 G+ ^) g
) \/ Z; B9 E; d* |' Y$ w: w
if (!empty($_POST['char'])){1 G9 q0 m3 W& n; g: h' e
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
& {! o* ^8 N1 h3 O( t/ O$ ]8 X+ j0 Z7 L* n3 u& I9 f4 `- G* \
m_szName = '{$name}'");
5 a1 k" J& q: rwhile ($row = mssql_fetch_object($find)){1 B  V2 ~) u4 M5 g& Z# x& W
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
8 d3 Q6 S5 U3 ~: |4 l$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
' [# s) x8 k" s! R* [2 K5 Y. v9 I
: O. o/ ~! q/ w1 q9 n& Z[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
8 O# I; ]( ~9 }  K" Q) e4 V, d8 U6 |1 G4 `# [& q
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', + i* d# k8 u' S: C! J

: D. m8 l8 w' KN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ' P* i( T+ w+ V5 `& d7 x

1 p% }* M: n8 ['{$ElementUpgrade}', '{$ItemPierce}');");
! e# b7 y; {+ @9 T8 r' A}
& Q5 j" ]( j9 M9 Z6 ~4 ^$ f
  o) `" E$ n0 f& s! Z  [/ k! h}
3 h- f% D# r. @$ K( m* `6 ~% b4 |& p( x( o, l5 X/ I" O3 P" y$ Y7 }
}
" z9 h) S3 Z' [2 S$ H; q% r" `! v% s' d; v2 e6 C
$InitForm = InitForm();" A, Y" z  `, F! c1 x: q
$Listener = PostListener();  P/ A, h! Z' o+ s, C9 Q: ]2 V6 s2 b
6 E# k) d( I9 N' H0 B- \6 o' u7 B
?>
3 \  j1 t" l6 n, s* L& V+ L. K; k
6 p; q  s! Z5 ^2 n- z9 g5 h5 i) c2 [8 l) `& |8 x
( K: \" k5 c3 B; ^& W; f& G, K- z
/ }( a8 e' d3 W' S+ Z5 P3 K
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-16 12:19 , Processed in 0.064099 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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