飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
' c4 n1 B- v5 n) p8 |function Connect () {
+ p' z! a7 W% cmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
% _3 V, H- ^- ^7 V+ G# ]# p5 }* D2 ^9 A, }' `
Failed.');
" W: D% p& R' w1 _. ]}
! f8 T! G* @* d: ~: `1 \Connect();
! c/ z# D+ |6 ~! h8 \" K% T9 Z- H; i3 W5 w8 @4 Z% D: y
function InitForm(){) E, q- Q: T9 `0 @
//layout for the form
; F+ {7 u  o) ]% G; C6 r' ^, A) Secho "<strong>Send Items.</strong>
5 s8 ~2 y" L7 C5 l<form name='select' method='post'>6 F, }: L+ V! r, F) n8 f( }* D
<lable>Character Name</lable><br/>
$ {) q- I5 _: m* H  I<input type='text' name='char'/><br/>/ }, ?/ {: `' P7 I
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>5 `9 {, m) J" G" V" a' P
<input type='text' name='item_name'/><br/>
4 w9 v  M+ S9 w5 ]2 @<lable>Item Amount</lable><br/># R8 t5 V9 _) R; l' L2 P( E& L
<input type='text' name='item_amount'/><br/>2 C) r: X/ b! J, O* Q2 R( V0 `1 F* g
<lable>Item Upgrade Amount</lable><br/>$ }/ U- ?, h  z
<input type='text' name='item_upgrade'/><br/>6 B- h+ m6 m5 N9 O
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)( ^2 X1 H+ R; p$ {
1 W2 k/ P& @9 ^2 _: d
</lable><br/>
& L8 i0 g( x0 t, ~) K1 X<input type='text' name='item_element'/><br/>8 h3 X( Z6 N) J" p$ x, i
<lable>Element Upgrade Amount</lable><br/>
9 \2 E$ O' |3 r+ w+ O) z2 ]& N<input type='text' name='element_upgrade'/><br/>
$ y1 D( R* u+ i. _1 v  ~<lable>Pierced Amount</lable><br/>
5 b' Q9 t% ^* @<input type='text' name='item_pierce'/><br/>: d/ [: l' R$ s6 M
<input type='submit'/>4 Z8 e7 h. h. L1 C/ c
</form>";
3 [" G! @! z; r( [% `8 k}5 S; V' B0 @( h9 d

3 P6 p2 w0 v; O# O8 Tfunction PostListener (){* r) m" p+ r! U, Y7 h
//Add more post variables if needed and add them to initform() function aswell
! Z2 M0 Y- j( @
& o/ D. W7 G) q" L* ]0 x################################9 o  ]3 H: }6 X4 {+ H
##### Connection and Post ######- @; _# P* d- r% c9 z4 C5 V: R
################################
. t' D  \+ B3 M5 L# J2 O8 Z$name = @$_POST['char'];5 F% `$ E: f! ^& p9 [. f9 J
$ItemName = @$_POST['item_name'];- s/ t' C0 o. q. o
$ItemAmount = @$_POST['item_amount'];
! Z+ a$ ~3 ~4 P$ItemId = @$_POST['item_id'];
, U4 z3 @7 o- X/ N$ ]& v5 y, b  T1 x% _# i$ItemUpgrade = @$_POST['item_upgrade'];8 t5 I  T" v4 ?: m) d1 f" H
$ItemElement = @$_POST['item_element'];9 Z9 b6 J+ P: [" ~6 H4 j2 r
$ElementUpgrade = @$_POST['element_upgrade'];
$ v) x& L( v% }4 }$ItemPierce = @$_POST['item_pierce'];  `; W: e9 T, k2 m1 w
################################
0 z( T  d# B6 `- j/ A# y0 v( }0 M# J6 I9 a3 o1 @7 k4 o9 z* j
//Check both variables for empty value( `- U3 d( W3 k3 L( J

- B1 S9 f' N4 Q- [; Z" M3 }5 y2 lif (!empty($_POST['char'])){
% ?+ z5 J! g5 M$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
: w# |( F, |' q) {
; _4 N- O( j4 \* Sm_szName = '{$name}'");9 f4 m# a( A6 u/ g7 z+ f  x: o
while ($row = mssql_fetch_object($find)){. {* ~8 e. [; b, x8 J
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";, S( n  E/ J9 `. W% X
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
# d2 [9 U3 ^, b
0 {) W6 S1 s9 o/ L' ?/ `! ]1 o[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 7 H' s: t: @& G2 I. {( X

1 X" @( q7 `& d" c9 U0 q2 X) M0 A[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% W, h' N2 H7 G" d' X
1 K* |5 l0 q% c/ E, sN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 n7 M% H6 d: j# O) ^. S
  _$ L, M3 |/ T'{$ElementUpgrade}', '{$ItemPierce}');");
% z' L6 e' N, c* A: K, [% o}
% N# |" x5 O* `% Q& w
2 a5 K* S7 u. A. U% m}
2 f( W! C; Y: a) \$ j- P# D7 v, u; c) s2 r# O& F- d, U
}
) e7 H+ J' i; U2 @- l$ @% G/ t/ [5 ]0 F0 E# ^
$InitForm = InitForm();. b* Q/ ~. J. f' V* @; l6 C
$Listener = PostListener();  g- I* r7 J. s+ T

. P0 Y, d) d/ s8 W! ~" q?>
. y- u  N( K4 {2 o* v4 {3 R8 w* F( I+ i, y  L

7 z" u- d1 T/ I/ n
# N& J; t; C/ |6 W& C; `2 E6 P! Q8 U( t7 a7 U% n
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-18 10:56 , Processed in 0.057811 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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