飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
" U, [( i5 s3 S/ e2 Afunction Connect () {! r' h  _" ~/ R: W/ H" }
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
; d' d2 q9 z2 X" ~! i2 a& K! m" I5 B# ]5 R/ T7 C
Failed.');+ i* E0 Y* v! A: S; M
}
3 D2 j! A$ z5 f+ E- i9 mConnect();
4 U: u) a, C$ O! ]# q! r- i+ e
: L" p" h; Q! e7 g. G8 P. cfunction InitForm(){
. P$ ~- Q+ [2 m, P) y8 u//layout for the form7 d# }0 V- X3 F' x  W7 r3 A2 L- i& `7 v
echo "<strong>Send Items.</strong>6 d5 l6 l3 ?. Q& K8 q) C
<form name='select' method='post'>1 C: s# ]& p# j) G
<lable>Character Name</lable><br/>
2 V8 j3 ~* X" C, T  Q<input type='text' name='char'/><br/>
$ ], X" x6 w. d6 H5 `6 O" M<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
1 N* x5 k' ^  O  X) X# c8 T<input type='text' name='item_name'/><br/>
8 Z4 u% @6 L/ O" x' u2 E& B4 n<lable>Item Amount</lable><br/>
  Y$ R2 I; @/ R: f, k1 I- K7 L. k<input type='text' name='item_amount'/><br/># \& [/ Z/ B7 D, _
<lable>Item Upgrade Amount</lable><br/>, Q8 `3 q1 G! w& F' a1 N4 i! Z% ]
<input type='text' name='item_upgrade'/><br/>$ x1 k, J! J! M' g# @) f9 e4 p% ?
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
7 C8 q! z& ^, O5 U9 V  \3 K, [
7 n3 p- Q4 _* e- Z) C</lable><br/>7 {: Q. o1 I* }9 L# |" \# Y
<input type='text' name='item_element'/><br/>
- i/ S# G+ A" e3 d% u) `<lable>Element Upgrade Amount</lable><br/>) c6 g2 F3 \. f5 u4 G3 V% m
<input type='text' name='element_upgrade'/><br/>
* X+ b0 Y! R4 G1 }! Z<lable>Pierced Amount</lable><br/>
9 `  w6 ~0 ^5 M0 x- {+ }  r. w<input type='text' name='item_pierce'/><br/>: |* _- ?5 Y; ^' C, e
<input type='submit'/>
. i6 K4 V% M; j, ^, {</form>";0 @5 c. r6 e. p) G
}
; j* @- m) M  t4 ~- ?
9 v8 P' u8 k$ y: T  bfunction PostListener (){
" [9 o" f, N  n//Add more post variables if needed and add them to initform() function aswell
% T1 i( `; e% o/ ^; Q6 Q/ C6 Z" |3 y/ A2 r7 ]/ q5 \6 e  s
################################3 w! y9 A/ M& V' U/ _% r
##### Connection and Post ######
8 u4 P* H2 w. n5 E9 r8 p################################
0 `6 `! G( {- [$ [( s, Z$name = @$_POST['char'];6 r$ Z9 i1 E( Y0 H# |+ w& D! q
$ItemName = @$_POST['item_name'];
4 [+ W  \2 k3 _$ItemAmount = @$_POST['item_amount'];
" W2 a4 @: V! ]3 G$ItemId = @$_POST['item_id'];
+ _3 ]! a" {, ?$ItemUpgrade = @$_POST['item_upgrade'];
- k: F) c4 X) {5 _& P, R$ItemElement = @$_POST['item_element'];
9 F' V5 Z( a* M# u; Y4 F$ElementUpgrade = @$_POST['element_upgrade'];! J2 Z1 x, }" a) A, n% ^3 F
$ItemPierce = @$_POST['item_pierce'];
9 g' _3 j, w, T1 \8 Z################################- U/ `: ~1 y$ i# {5 W% y. G

6 |: U$ U; E* t& ?$ X! P& p7 O//Check both variables for empty value
: [# X# i2 d8 z4 |2 ?8 W. H
( B1 I: i# k- q* [; b+ ?1 y( aif (!empty($_POST['char'])){
. P, {0 P2 M) c+ {) p5 {  z9 \2 Y$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 7 T% u, @7 @: R. ]4 S! \' }

$ R) z; X4 _. i$ G7 f! t0 j% em_szName = '{$name}'");; w& z: O$ O0 q7 a( a& W7 r
while ($row = mssql_fetch_object($find)){2 L# X; s( E, w) r8 k
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
. g" h* W* M" B$ Z/ y! V+ H: G- p4 Q$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
8 Z, b; j2 l. w4 Y# T* h8 b) i0 I8 p( K
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
9 N1 H; j) a+ h; o7 u: h  S; Y3 F8 \1 D
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 2 m, k5 o2 w  Y" q1 B" ~

: Q! p0 ^* D, K5 SN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
% Q" M$ P- D4 \. Y
0 j/ L& v" r; k' p'{$ElementUpgrade}', '{$ItemPierce}');");
  I! w; V: Q4 f3 }8 z}
# O, t* V; q! S
6 Q9 y1 v1 ]' _}; S* C! e0 s9 V$ w# A# F8 ~* M0 }9 \
1 x- f8 C: |7 g8 R" U# n
}
* f6 w: D9 r+ t4 T& g. [3 q) _# {  @! ]& U" i
$InitForm = InitForm();
1 f) J9 }9 O9 n' ?$Listener = PostListener();
8 S+ }) P2 X9 O& v  `- J! x* Q
6 N" I; s5 {- E# P?>
7 q) b* t! v8 y. e6 m0 J5 J- B+ t  q8 u

  m  I4 O  G' m2 M5 ]2 c- {- v; B. _0 J
+ f* C7 |8 F- T
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-22 13:53 , Processed in 0.060985 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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