飞飞世界论坛

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

物品发送脚本

[复制链接]

200

主题

203

帖子

984

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
984
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 显示全部楼层 回帖奖励 |倒序浏览 |阅读模式
<?php
! @  r4 t  ~' Z. @5 m/ efunction Connect () {
( ~4 |' H8 u/ f) A5 @7 H4 B, t7 Q2 ^mssql_connect('Server','UserName','Password') or die('Error: Connection to DB % {, {9 r' \/ A& i6 K  m
, _6 a' _# {6 _! h" `. v. v
Failed.');. Z5 h( U; n% o' D1 V, S- }' Y
}3 C- ~5 e) O& k; e  t0 D
Connect();
; k3 w* \" R/ @. g, b# a. D0 W
* Y8 S- F4 \& g$ U2 hfunction InitForm(){+ f0 @/ V' M; [' J* K# r
//layout for the form  s7 i0 `6 [5 X! ^3 m& \  N$ H; [
echo "<strong>Send Items.</strong>
2 }( D" B  w1 f+ J<form name='select' method='post'>
' B# y  n# j! u% n2 _" V7 W/ A<lable>Character Name</lable><br/>/ k, ^& p) j8 ~2 a" X; w; W
<input type='text' name='char'/><br/>' s+ n" U% Y! I( l1 c# E
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>3 P6 D; `/ |1 z! s# `- c" u
<input type='text' name='item_name'/><br/>
% s  s: [7 {5 V<lable>Item Amount</lable><br/>; U5 {0 B; |3 O
<input type='text' name='item_amount'/><br/>/ m1 H$ j7 U" _* q- J6 m
<lable>Item Upgrade Amount</lable><br/>
( v/ [# T3 e4 `8 X<input type='text' name='item_upgrade'/><br/>% d& p0 I, g0 l5 {" F8 B4 i
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
6 ~7 Z* u8 V4 y- C' K" [* n4 q
) {" y1 v# E/ p1 Q( e  }</lable><br/>7 ?; e. C6 r2 P" W4 I  T5 Q
<input type='text' name='item_element'/><br/># Q+ u# J" b% Q( R
<lable>Element Upgrade Amount</lable><br/>
& ]% L2 y6 r0 J7 E. o0 c; @<input type='text' name='element_upgrade'/><br/>- c) h3 C2 L. i% F
<lable>Pierced Amount</lable><br/>
* Z; [, i8 @$ I( l! `<input type='text' name='item_pierce'/><br/>
, m1 f- r5 O, s( y) c<input type='submit'/>
1 W. H% I+ A/ ~* P1 ?" b</form>";- O3 g. |4 w0 i; h
}
# D* N3 ~' |, E) C
, C; }0 O* m+ I0 v' U  }function PostListener (){6 L4 V& ?1 l  Y; F* h% b* V
//Add more post variables if needed and add them to initform() function aswell
( a: D; W5 r* n& h( {9 Z' P0 T: f& x7 v- A3 Y
################################
6 z* ]& F8 n' O% X0 ?##### Connection and Post ######1 D8 @. b$ U3 a. U0 ?$ N. `* r$ X, ^
################################% F" {+ j* ^9 Z: `! t: |1 @3 g$ w
$name = @$_POST['char'];
" |2 M' _3 B; R1 B2 |$ItemName = @$_POST['item_name'];
1 D* s, S+ P! E+ m$ItemAmount = @$_POST['item_amount'];$ H" n2 p+ W/ s
$ItemId = @$_POST['item_id'];. j0 [& l5 u/ z1 S/ I( S( a
$ItemUpgrade = @$_POST['item_upgrade'];
: f0 q) e7 S/ [- o" w& z$ItemElement = @$_POST['item_element'];9 R) L7 Z. y9 F& S( m2 I: X" b6 U
$ElementUpgrade = @$_POST['element_upgrade'];
5 [* S; g6 ?) w) u; c; l) R* J& f) u$ItemPierce = @$_POST['item_pierce'];
4 c( X, o" o+ n% b6 q/ Z; x5 x################################) c' ^& M2 ^" l1 ?; L! l8 ]* h: ^

# F7 Z" V0 S5 Z/ h1 {//Check both variables for empty value& M! S0 g% o1 |4 j) ~' _: E' l( K1 U1 t

% t# J* C* i% a/ r0 ^; Lif (!empty($_POST['char'])){$ m. Y  {9 _3 E$ S, ~2 h
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ( K, O! J$ P0 d7 F4 R
0 `" b7 \$ U, k3 [1 }( O3 ?  F
m_szName = '{$name}'");
, o/ o* k0 j; h! Q( _" U. Ewhile ($row = mssql_fetch_object($find)){
. `9 }9 w8 C; R. w" O% Iecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
& ?" X0 \/ q$ L$ _) ~$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
- B' J! F6 ]. ^) Q1 V. u5 L
8 U) u. l: z. c7 C& h7 e- O[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
3 P& T* S% ~# M! `$ I1 V7 a' w& D
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', + x, j" x4 @% [: K' i: l
6 R- s4 J  d0 z0 |
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 8 [" \) G/ J" k2 ]
2 l, @* ~( K' ]; c8 w
'{$ElementUpgrade}', '{$ItemPierce}');");
3 v& S/ U2 u3 {}
0 V  Z* O0 I$ E* x/ X" m7 h7 P
! m: [( H4 Y! ^$ `  z3 g}) D6 X5 g# K' W% k5 c  |2 L6 N

% B$ h* s0 l6 }}1 x# X% B. R4 |0 M

6 k. j9 V' `+ B$InitForm = InitForm();" R9 \2 R+ R& Z0 F
$Listener = PostListener();) ~6 D" i/ W3 q0 t) D% S$ f7 H6 t

; x8 c& ~% z; B  V2 \# P?>
: Z/ b9 G* i" y- t9 o1 P6 Q' _8 t$ f) F3 B4 ?* Y
$ N2 ~7 I/ _3 d: T9 U0 o/ l  ]
. B& R$ R! B" Y+ C) s
3 V$ m1 L' b- m2 }4 k
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2024-5-8 17:58 , Processed in 0.101711 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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