飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php9 B( z3 v0 V# m* P
function Connect () {
' p- T7 d. y2 E; P' _mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
1 V3 L0 `, a+ X5 f  B0 p
4 h1 L8 |" j4 Y+ U+ \* U! `# LFailed.');& g; S& h0 ]% ^/ ]! o
}9 u! v; z+ N1 C8 w
Connect();3 Z$ j- n! P% c5 C4 Q2 U
5 Y5 T) b, K- H* X& ?
function InitForm(){
' x1 ]& J- v& u& ?/ v//layout for the form* X( l8 u& G3 v8 q
echo "<strong>Send Items.</strong>$ X5 a) G7 S2 [8 `) y8 t
<form name='select' method='post'>% ?) B4 L* n6 a6 y' L$ A# n
<lable>Character Name</lable><br/>8 ^+ B5 R6 M4 G+ F* Y* E# P
<input type='text' name='char'/><br/>
2 d* h5 X* c. r# e$ p3 j# k<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/># R3 }+ V" |! l2 I
<input type='text' name='item_name'/><br/>* z0 M  y/ Y% M" L+ A
<lable>Item Amount</lable><br/>
$ j* f7 X5 f% O4 N- o8 A# D7 @3 S; o<input type='text' name='item_amount'/><br/>
2 ^& t4 J+ K& O<lable>Item Upgrade Amount</lable><br/>: I: c# U, ?, A/ W( K9 P" L9 X
<input type='text' name='item_upgrade'/><br/>- X6 e1 I6 g) U) U
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)2 A  N5 J3 Q% k

7 J) x$ ^, a3 m( N+ X. D. _  q" j</lable><br/>
8 i' A# a2 {% Y( c' O<input type='text' name='item_element'/><br/>$ ]/ M! d/ I3 O: H* ~
<lable>Element Upgrade Amount</lable><br/>6 j5 }/ [% h1 F/ W  ^; B
<input type='text' name='element_upgrade'/><br/>7 n: i0 O' Y1 @2 ?0 C7 R" M! n9 m
<lable>Pierced Amount</lable><br/>
' s; }" H" M' Z& P<input type='text' name='item_pierce'/><br/>1 {) g0 R) b8 m( n4 v" p2 x1 _* t% e& Q
<input type='submit'/>
2 a, B7 e( F# i6 ]9 G$ z  g. ?: E) R</form>";% W" b: Z( H3 Z" X: _7 Q
}% Z/ C* j) ^4 N6 G2 o: j
2 d; b5 M" w+ v4 i' |
function PostListener (){2 s/ R+ q. }  e7 {9 J
//Add more post variables if needed and add them to initform() function aswell
8 A2 n% a6 l) @- V! h# |/ e) O$ e- \" D
################################
0 e2 ^; ~" J3 K6 Y  S- {2 i##### Connection and Post ######% G2 V! |: C# W0 x5 o- l+ T5 |
################################& _& v+ E9 {3 d2 G+ {* N
$name = @$_POST['char'];3 W+ [; u0 `7 L- |* C, I+ f3 m2 C
$ItemName = @$_POST['item_name'];
8 I' `3 Z7 B* ?* P$ItemAmount = @$_POST['item_amount'];
! w$ S  K  a9 r# ]$ItemId = @$_POST['item_id'];
1 F8 W- O  P+ o$ D$ItemUpgrade = @$_POST['item_upgrade'];
8 f& m+ z7 I2 w$ k0 d4 J8 J* ?$ItemElement = @$_POST['item_element'];, L: T/ E9 j3 K$ i3 d, T
$ElementUpgrade = @$_POST['element_upgrade'];- N; k, i; B; C
$ItemPierce = @$_POST['item_pierce'];
: B4 d5 r2 Q! K( ?! v: p! f################################
2 I9 s* ?. q# k$ e3 D$ e% g! R0 A% _4 u# i2 Q& I1 X) s
//Check both variables for empty value$ ~! J3 V1 b; q3 [+ w8 H& M3 d. ^

4 a$ `) K/ P- n# oif (!empty($_POST['char'])){- r* n- l1 ]. W% n  C. o
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where   U) C! p% \! I; a' {
. _0 S3 Y) O/ }* m2 \& w) m
m_szName = '{$name}'");
# `. v- @# X: x& M% G& zwhile ($row = mssql_fetch_object($find)){, w+ I+ f4 E- [. o3 T
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
4 @: c2 I) F( Z! g4 a; |5 Y$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
( C: y% Z: t0 ?7 S+ Q
( V! {9 J6 P& u" i* n[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ! F2 V7 C. [, w3 f7 F
0 b' D5 N9 P7 `! G5 @4 K' l5 r$ O
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
! k. c2 U% P1 G3 N! t& D2 \, z. Z' E& u
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
; E+ N4 N- p$ I
# b3 V# m& K& E9 S+ C, g' s'{$ElementUpgrade}', '{$ItemPierce}');");
0 |7 w! e& Q" `}( B5 [) \" U" ?0 A; N2 Q- p

9 x1 b8 e' b, z7 H% \}; N, G  o% Y! O$ x5 E" r

7 p4 j* N1 L& k) {5 I5 L}1 D( z5 r6 a9 D  Y
  e% ?2 j; e9 w* k
$InitForm = InitForm();
" M* n  x5 x% `: x* ~$Listener = PostListener();
' w" D/ Y0 i- g% G* ^! Z5 g
" n. Z. D- l- b1 [) |# t?>
+ ^# \' o9 m  z3 V, m4 \5 ^
8 B9 d; m0 T% e6 ^& B8 |
* N! w8 y" k7 P' N
9 a+ Z0 |' f  k6 M( g* i; r/ r, a7 s2 U
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-11 06:45 , Processed in 0.078176 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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