飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php4 b6 s6 s# q) x
function Connect () {/ d- [' U7 R. g9 M
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 8 f; f% a6 r( g+ D6 x. f2 V0 S0 ^
) u% D9 ~* [% a  C: b
Failed.');
+ I! ^3 J. r. p' o4 @) X7 Z}1 Q% T: t9 Z9 l3 J; b- W7 ^7 C
Connect();
3 [+ O* w+ P$ v& L& y) ]5 }  N$ R( y5 I1 B# q1 r0 Q' A
function InitForm(){6 L/ Y; X; P+ p, r& ^; \7 k# Q
//layout for the form. c; L' m) j6 j) J) {
echo "<strong>Send Items.</strong>8 E7 {8 {0 D+ R+ c3 p1 P9 J/ Y
<form name='select' method='post'>, d8 ?6 C9 a2 N" ?9 M2 {3 J
<lable>Character Name</lable><br/>
9 E6 l( y4 Q! t+ J0 C$ f0 ~9 k8 L<input type='text' name='char'/><br/>
! t1 R6 G8 J; |; Q0 T" X- g# w" V/ W/ c8 H<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
: v/ d0 l( [2 `<input type='text' name='item_name'/><br/># _# v1 c! t2 u* e, ]/ ?
<lable>Item Amount</lable><br/>: z/ L6 z! N5 o- O0 _
<input type='text' name='item_amount'/><br/>7 ~: F8 f* r. N3 j
<lable>Item Upgrade Amount</lable><br/>" U2 S) o9 S. E: k5 r/ {
<input type='text' name='item_upgrade'/><br/>5 x, s! \3 w( V4 [& M7 L
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)5 Q: f' I2 U" m7 i- a3 X

6 X6 B  q( {: o9 U  b</lable><br/>4 Y& E! Z9 p- A" c  S
<input type='text' name='item_element'/><br/>" y; U7 [/ s: n3 [
<lable>Element Upgrade Amount</lable><br/>
. F( }: I# I9 B6 v# R8 M2 D; J, |9 b<input type='text' name='element_upgrade'/><br/>
- n6 N6 i% S* [- X4 y$ Z/ k' U<lable>Pierced Amount</lable><br/>
  Y4 |- s* k; U<input type='text' name='item_pierce'/><br/>
! {% l" {% _' H( l<input type='submit'/>+ n4 X% B; Y  y% l" R- u2 V9 u2 j8 ~
</form>";
7 m( ^, k5 s$ v1 o9 @+ i}6 I. A9 g4 V, d: b; K

, c9 g; m+ w5 Kfunction PostListener (){
4 w9 L# G, {$ K3 d0 `& R6 s  t//Add more post variables if needed and add them to initform() function aswell
6 @4 r5 w" C$ V5 i0 J% o, U: {4 H. }+ R3 {1 Q( D
################################9 _. V  f$ }& F6 K
##### Connection and Post ######; G7 {' M7 Z* O5 t; F6 n9 Z9 Q% c8 O
################################3 Z. I/ U. ]7 M
$name = @$_POST['char'];5 V' a7 B- N0 U' G$ s+ E2 \2 V, a
$ItemName = @$_POST['item_name'];
# j  h8 n# n& h" e- S$ItemAmount = @$_POST['item_amount'];0 y+ n: x$ e! G
$ItemId = @$_POST['item_id'];
5 j: c  ]+ I: m' S' T' K; N! B( Z$ItemUpgrade = @$_POST['item_upgrade'];& [) V" u" J  v; L: m1 g& E6 @! Y- q
$ItemElement = @$_POST['item_element'];) e4 N. Y5 }0 u  \' i7 E3 d6 X$ {
$ElementUpgrade = @$_POST['element_upgrade'];& b; o7 C0 i; c: s- U; `- C
$ItemPierce = @$_POST['item_pierce'];" U* Z  F( f$ ]3 [$ l4 p1 r3 I6 u
################################
% d7 R3 f/ z1 ~' B6 R4 D0 e" F! h* Y
//Check both variables for empty value
5 {/ p  ?3 w3 D
$ \; ~8 @1 e2 r- |" U2 W: X3 d% eif (!empty($_POST['char'])){
9 W+ T' ?- n% {. }8 P1 M) M4 d& b8 e$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 9 B  W6 b/ b1 e$ ~' l

8 Z0 m+ f7 r- n& A. S: T. Sm_szName = '{$name}'");/ n; `( Y8 ]- C  J$ i" {
while ($row = mssql_fetch_object($find)){. Z5 z! ]2 D4 _* c% D  s# ]
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";2 k" a' f4 D  [# @5 G1 ]
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 5 \/ V6 @& ~+ W. \" i/ g7 O
/ @' S0 @% `8 R& _2 w8 k) U4 g% i
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
+ O% Y! [" ^& X+ v# E) h- f, K* n
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
* [( T/ N0 E) s- e# t% I# u; k2 g2 U* n
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 1 v4 q6 O$ T5 c& J

5 K2 N  A- U7 o& A'{$ElementUpgrade}', '{$ItemPierce}');");
& g1 D5 }" `- J" V$ V( D}, q; R9 T7 Y; h# L

* e9 U, ~5 P- i* i}
( e+ `4 L1 g3 ~( t6 H
' [$ M! q& J5 d}! ~$ w4 y) _: j. M# i+ e4 u
! ]4 P8 |, Y5 p! p8 w/ A2 c" V
$InitForm = InitForm();
" H" O0 ^* w  R8 s+ E! ~" i$Listener = PostListener();
! h5 u1 d. M# H& T$ T! d8 i% W& q1 c9 _% A. E' C1 Q8 L
?>
+ x! b! w/ P* d  U0 X+ B
/ P) n7 z0 n; v4 s" M9 W& p6 V5 J& Q' k$ ~
, ^: f, p! ]% G2 c

# W: H$ C0 S* x( C$ @
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-16 02:44 , Processed in 0.063355 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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