飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1084

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1084
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php1 @1 `8 s: k: d+ Z* K8 }- s
function Connect () {' S) T# l0 N  }
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
: `. i) O! l% p. R: d1 d7 ?6 J- `( z5 I: Y5 L
Failed.');4 D4 p1 q+ A/ q$ p
}
( ?( `& h8 e3 `! X# _& hConnect();4 o; v# i6 j% G7 t6 P0 @+ e
' J4 ~* c4 E* n6 l& Z" G. }/ l" ~
function InitForm(){
& M. F/ x* c  q/ S//layout for the form
6 W+ ?  q3 H3 O) Kecho "<strong>Send Items.</strong>" \+ {# s4 [* T3 c9 ^5 T' X
<form name='select' method='post'>: \# e  ^- O) j! g6 Q
<lable>Character Name</lable><br/>
; ^9 @7 `1 y& }. a8 O<input type='text' name='char'/><br/>) p% p  g- o7 ^/ i' L
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
0 v" Y7 o; y0 S3 Y! q/ U: X<input type='text' name='item_name'/><br/>1 |- F7 x1 ~$ f
<lable>Item Amount</lable><br/>
; F+ Y% ]6 G0 ^- a% Z<input type='text' name='item_amount'/><br/>* Y1 Z6 X/ p2 b4 v
<lable>Item Upgrade Amount</lable><br/>
& h8 L. P: p7 ~) `4 f<input type='text' name='item_upgrade'/><br/>9 p+ D1 _3 F8 D- T7 Y1 j# v
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)5 M7 @( U  f) y1 r* j# F9 P% c
, A* @$ U* e/ [2 N* F2 r' R+ U# y, g  _
</lable><br/>
7 G$ d9 c& `. O2 T5 e<input type='text' name='item_element'/><br/>
7 J* @% f2 l3 |2 u4 J5 D<lable>Element Upgrade Amount</lable><br/>
5 e2 L8 u5 V; R* b7 e" N<input type='text' name='element_upgrade'/><br/>
& d' f$ L3 ^& g0 c; J/ p<lable>Pierced Amount</lable><br/>) j- g& Q( C5 \! _# E7 S9 {& C
<input type='text' name='item_pierce'/><br/>$ M0 m3 H1 ~, Q/ q
<input type='submit'/>
( b  |0 k1 E% K7 v6 x1 K' y! O$ o: M: `</form>";/ d" X3 z/ B1 h" L2 `$ }
}
0 W9 N, p( e1 r% m. S9 g5 H3 V! V2 M2 h3 \* J' S' p
function PostListener (){1 O  i6 S8 j& b" S% [. W
//Add more post variables if needed and add them to initform() function aswell
9 f6 K- ?, t. k1 Z. b3 h6 z
8 j; z8 B5 _. c5 n2 f################################8 b. u2 P* ?' w% d) e
##### Connection and Post ######
4 _" z( f, V: L& K. F/ k+ X( g################################0 I+ @6 e8 x, F& B' P; d& ^
$name = @$_POST['char'];5 Q! E- J4 {% q' h& J
$ItemName = @$_POST['item_name'];5 h7 d/ A& B/ x  Y. Y4 V
$ItemAmount = @$_POST['item_amount'];6 }3 K2 F% v9 S7 e% a% Y0 V
$ItemId = @$_POST['item_id'];
! i! S, Q( l; Y* _+ t. f$ItemUpgrade = @$_POST['item_upgrade'];0 \3 C/ _! e/ g7 {0 r
$ItemElement = @$_POST['item_element'];
- y& Z2 Y2 w& C2 a/ Q$ElementUpgrade = @$_POST['element_upgrade'];# |: ^$ @% ^" ?' t
$ItemPierce = @$_POST['item_pierce'];! v% s; Y! z7 f' Q
################################
3 \* b8 i& x- D5 S8 @& B8 }, Q. x( ~, x
//Check both variables for empty value
( @, T% z; u+ n: w5 t$ _, V# @; m7 Q( n. E* p( b+ H
if (!empty($_POST['char'])){5 i  G& C( O$ X0 q% L& s* F
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
$ t& R& @* r( ?' c) _. X) y6 B1 `3 X
m_szName = '{$name}'");! M0 l8 |, [8 a
while ($row = mssql_fetch_object($find)){
+ G- T8 _2 _3 h" [8 Pecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";9 t( `; \6 j) k4 C9 q) _; y
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
. s& s( E7 b; o2 W. V6 u
2 T9 U/ {0 `/ Y4 h[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
7 u" h6 r3 P, N+ l; o+ U. M* q; X( ~- e& d' I# h# a
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
# M+ D7 W5 ]9 Y5 Y/ ~; L+ P9 s/ W
. U# H; K: x7 xN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ; ~- V1 X  K# t" C  S7 N+ a" K

, |4 Y. }: ^, X8 B) ]  H'{$ElementUpgrade}', '{$ItemPierce}');");& C; q/ z1 H9 j8 _8 |
}
, Q' j: \+ `" n( H" h
3 U7 C% m) @2 T2 O' q. ]) c1 Z}
0 ?  S( T# F9 x3 ^: w8 N+ L7 `" k+ T4 q& K; \- R( |$ C" t
}- k& w2 L/ e/ q- z0 M3 P: K

5 w  s" |8 a3 f! X/ R" S  Y$InitForm = InitForm();
/ j  a  Z+ O+ |- f+ r3 P$Listener = PostListener();$ k9 Z& Z1 i9 W$ A

2 W4 o# [  G: G6 y% {?>
! C- ~6 K# l. |$ Y
) D, a8 u7 B/ W* d/ ?# i; {" [; h& k; O$ h
; d' ]7 C" R0 r7 ^; v8 D7 d
* o. Y5 T; s% i" a
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-11-18 03:29 , Processed in 0.068077 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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