飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
, \9 q5 E3 @; a& z- ~0 S$ lfunction Connect () {
6 [5 h% b$ ~0 G8 qmssql_connect('Server','UserName','Password') or die('Error: Connection to DB + L6 M+ B" z! u$ G1 u' Z

8 k) w  V/ P( V& A: TFailed.');
9 [0 I- F; p! |+ }7 H5 v}! p/ }5 r  b) {$ A0 N% @
Connect();- b" }2 F$ k1 d/ v' u

6 a. }' b; G; |function InitForm(){
+ P" s5 g& }4 j2 `//layout for the form
  H( Z- M" L3 J4 y. z8 _  J+ Eecho "<strong>Send Items.</strong>
0 f$ s% A, }) y# ]. |, Y& `<form name='select' method='post'>$ t+ m1 j* P, }% @5 Z: t( s& m
<lable>Character Name</lable><br/>
7 G/ u9 L5 U5 f1 f# j<input type='text' name='char'/><br/>
( p  N  h. ]! k5 [& I<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>; F! t, P( a$ @
<input type='text' name='item_name'/><br/>& T5 G0 [% A8 g* d
<lable>Item Amount</lable><br/>" G4 s1 b0 ?8 g! i1 p. a1 |9 E
<input type='text' name='item_amount'/><br/>
" W# |- M7 H+ N0 Q7 y! z6 z' n<lable>Item Upgrade Amount</lable><br/>+ W! s1 k0 X* p+ l
<input type='text' name='item_upgrade'/><br/>9 I2 l3 H9 J2 }$ n* m
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)6 ^4 a; _' z2 k5 |7 g0 X

1 y4 Z+ }( _8 A: o( K2 s" o</lable><br/>
) q  u5 B) z) s<input type='text' name='item_element'/><br/>; R/ {0 E. n* o
<lable>Element Upgrade Amount</lable><br/>
+ S; o( q, z: {! L<input type='text' name='element_upgrade'/><br/>* \) f" M9 k( g3 `0 Q# n; _
<lable>Pierced Amount</lable><br/>1 _; ]; l) n5 B+ v
<input type='text' name='item_pierce'/><br/>. Z& N" i& K% t! {: E
<input type='submit'/>, {: a8 e, K5 J( U$ ?% U
</form>";
! `4 y  d% p( f0 a- t) t5 L. F/ ~}/ v- ]! s) r- _( H
+ `* l+ A  @5 A5 U7 W* a
function PostListener (){' H5 d# ~" B: Q1 X; ?% f
//Add more post variables if needed and add them to initform() function aswell
3 ~1 U- l$ z4 G" w) |+ M9 U4 T
0 |- O& p3 {* ^5 S! {% w5 E) u################################" s4 u) \" X& D% e8 j! e. [
##### Connection and Post ######+ M+ a. N; L7 r! Z9 O
################################
0 C; p- a  X  ~' t$name = @$_POST['char'];
6 d  v% [; M' A7 N" s; E8 }% `% M0 K$ItemName = @$_POST['item_name'];
# s/ [/ G. F7 O$ItemAmount = @$_POST['item_amount'];' O9 G; R* c% e5 X& P
$ItemId = @$_POST['item_id'];
( w2 ]# r4 U( A. Y1 t. K: B! y$ItemUpgrade = @$_POST['item_upgrade'];
: g: q+ J, N, x1 V: P, |3 E0 {$ItemElement = @$_POST['item_element'];  b) c! n; w  `6 p6 a
$ElementUpgrade = @$_POST['element_upgrade'];1 G. _5 S% x+ S  H; B, |2 |
$ItemPierce = @$_POST['item_pierce'];
' b) {6 _* o0 y0 m1 M################################
& F' U0 H$ ^8 W2 u: A: V  `; A, S
" r/ L+ o# c, g* ]* b2 m4 i//Check both variables for empty value
3 I2 ~2 p' r3 R, C
2 m- Y! T- ]* F0 Q. Kif (!empty($_POST['char'])){5 N# Z9 G0 K. D( P$ [; s4 E3 @
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, {' o; M) E4 n0 r. n/ j' \! S3 z, K9 Q8 e
m_szName = '{$name}'");
& W) \% c+ }4 f" Pwhile ($row = mssql_fetch_object($find)){1 d/ d6 A# |! k4 E, c
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";, o( i* K$ ^& G% x
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
3 y7 e( k! {) ?, L
% V0 Q) z, s  [# e1 J9 Y[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 2 g6 E0 Y: L+ R% ?

- }' V& `1 c# e[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', : c: h, {. U2 U* k. O" \( W
: w: y6 q# s3 s. t$ f% y+ @5 d
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
% l6 U2 t, {- p6 ?5 X* F9 `+ O+ Y/ j, q2 i% F8 u
'{$ElementUpgrade}', '{$ItemPierce}');");/ p5 n9 ]( K' z. B1 W/ P* i& u
}
* j8 ^* B$ r" x( I, m% Y% \% i, Q" R9 U8 \1 o
}
3 U. U; o1 e) ?  x: x7 P. N1 ~- C
}
! K6 L& a: V8 l. i
7 |, I& ?1 ~. G1 B" T( y7 ?  j3 m; ^$InitForm = InitForm();2 i2 L& r1 ^5 h: a3 V; b7 P# T
$Listener = PostListener();
4 h  \& f" D# t2 J: w5 A# p
( o! a* Y8 W& w& k?>
+ z9 `0 R2 C! W& q0 G+ s
  D) @: \8 C' T( t
1 l7 |- W$ P: G4 A0 F. F4 P$ ]/ p  J
' \4 R/ U' P, w1 S( g9 g
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-16 21:20 , Processed in 0.064818 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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