飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php/ j% y) \- u/ `) ?/ m
function Connect () {
, n& s: P* f6 t, \- N: t1 U6 cmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
" [+ A# ]6 E/ ]6 \1 r, l( W" P% M' `2 L
Failed.');( d! N7 \) t2 N# G) E: ?
}/ _/ a2 H, o# Y3 D
Connect();; ~7 B# g; J  O( L+ e" o4 Q7 A
0 m+ M0 m; ?7 A1 g; Q- \, C
function InitForm(){
; F9 y- L( F7 ]7 d4 J0 z6 ~+ o//layout for the form, R, L- q5 |/ X  N
echo "<strong>Send Items.</strong>
6 g% a$ U0 _; m* Y! k4 e<form name='select' method='post'>
7 f% ~5 [$ ~- y6 Q, h: G2 o" x9 _<lable>Character Name</lable><br/>
; ]8 l" h3 n% U<input type='text' name='char'/><br/>
, n$ M+ a* P! L9 R5 M<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
1 S! T3 U2 B; c% Z<input type='text' name='item_name'/><br/>$ Z7 K5 ~, |$ v7 e4 \
<lable>Item Amount</lable><br/>
( j) ]! a; `- _7 p<input type='text' name='item_amount'/><br/>
) k' W2 y0 \" E<lable>Item Upgrade Amount</lable><br/>
7 S3 g$ x5 t/ ~5 R9 p<input type='text' name='item_upgrade'/><br/>* I/ S6 j6 @2 }+ z2 d" K' t
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
1 m' O# ^) o8 A9 a2 s* W. _! @% e! c
</lable><br/>( U! G; x+ t- r2 V, w. S, J
<input type='text' name='item_element'/><br/>$ e( W2 w' g+ X- R& m
<lable>Element Upgrade Amount</lable><br/>
, M/ _, b: V1 G+ j! g<input type='text' name='element_upgrade'/><br/>
2 y' Z) \3 ~( Q2 P  b& ?4 G<lable>Pierced Amount</lable><br/>
( J# N1 r" z+ L* ^<input type='text' name='item_pierce'/><br/>& o; \/ D1 h4 ?2 n  O) g
<input type='submit'/>2 T! U! C& s# s! N" e, l; i# u% ?
</form>";6 G) f3 |: R* N* H$ `) s0 `
}) s; w; e- q8 x9 F* G+ F5 ]" _0 T

1 m7 R; U/ U+ C6 w$ q/ Ufunction PostListener (){4 v* D2 X0 v* L/ M4 U$ T( X% q
//Add more post variables if needed and add them to initform() function aswell
! ?% ^+ V1 J' T% c# _8 U: j$ A0 |% o2 c1 T$ w
################################/ w/ e$ _: f4 Y% u' c% \! ^
##### Connection and Post ######
! ~6 ^0 M  c5 x) f2 h& ^& x################################
: B+ f" b) u# ^$name = @$_POST['char'];
% a  V/ j+ m5 f4 y$ItemName = @$_POST['item_name'];
) D* Z* r1 z; D; o: v3 `7 ]; ~$ItemAmount = @$_POST['item_amount'];
" X$ B2 r4 o0 O! L8 u/ E$ItemId = @$_POST['item_id'];6 T; w4 }# ]* m4 n! d4 e. J
$ItemUpgrade = @$_POST['item_upgrade'];
, r4 W1 B) V4 [$ItemElement = @$_POST['item_element'];
; Z9 d# _0 N2 k; X! [$ \$ElementUpgrade = @$_POST['element_upgrade'];9 `0 Y. d9 w% S5 T% r
$ItemPierce = @$_POST['item_pierce'];$ q/ y0 o7 L1 q; |! {
################################
, O7 H9 \% [! c5 F- `6 E$ I# L0 i4 [& v  A% h6 t* O  S( ]
//Check both variables for empty value  e, e& w0 q' z
+ Z% j; [, a0 O
if (!empty($_POST['char'])){1 X7 D9 D9 i/ `2 G  v- g
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 2 V% {( t/ z/ B# x! S4 G5 _, D
* L5 S6 V" Y+ N" E
m_szName = '{$name}'");
7 d) v# v$ W) {. Q6 t8 n$ k/ Cwhile ($row = mssql_fetch_object($find)){" |0 d9 b% o# _% y! h. _4 q
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
0 l6 D+ h/ [, i7 d3 D  ?$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 3 S0 C4 q5 t9 |. |( X
- H; }( D3 z6 L6 x( R# @  l% y
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
9 O# s4 ~! _# t- E8 R- x3 v0 _6 ^1 H: p- R  c# j  ?
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 5 R' N' [, e3 p& ?: w

5 {  c9 |9 t0 ^9 g* M" aN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', : R" Y* c1 w7 m' g; c0 d' t
/ ~& S( {$ c9 n/ N4 ?8 Y$ n
'{$ElementUpgrade}', '{$ItemPierce}');");: f. O  E5 Q7 f, J# Q8 I! ?, _
}
9 U$ W( [; |0 o: u9 j3 q* g
/ e  s9 J' z3 H& p9 p1 i9 ]}
1 u: D( M3 [; ^& V- o
8 ?# V# y* q$ ?}/ N4 P% H1 v& @" S. i
- i/ r/ v# K1 h& ?# p3 H
$InitForm = InitForm();
' O' L+ Z1 m  f$Listener = PostListener();+ d+ J/ l) @) F& T6 \
. ~; @* B: J8 e- ]$ c
?>
, t# H6 P0 G: _+ F: J
1 O% i, U, Z9 C: \, Y- U* r. r5 x( K- _

1 N( g6 X+ |* q1 _
- K+ I3 J8 k2 o; O* m# b( V
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-20 10:44 , Processed in 0.065541 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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