飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php* h" T6 Q9 Q% K# A5 C# F8 }# A
function Connect () {
/ ?7 i) m( s) W: J- u0 e" z+ L- mmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
) T3 _2 k7 g0 D: U( z, O8 q; r, B' _# \- D& x0 @
Failed.');
9 i7 A& n. K( ?% G}
' j+ \7 Z. I2 v: i8 E/ @2 X3 KConnect();; D3 u/ M! I+ Q9 Y1 ~

; D' Y) {) F9 s$ a& j, l4 ~function InitForm(){
. ]$ g) C+ y4 F. K/ \4 }. \- n//layout for the form0 ~; k0 G2 U) |; L3 B  U5 {) c3 m
echo "<strong>Send Items.</strong>0 g  O5 |! Z/ I" h+ D
<form name='select' method='post'>3 I; F+ ^, U: [( \
<lable>Character Name</lable><br/>
' v% G( r# A% q* L. Z<input type='text' name='char'/><br/>% W4 X% Q% g4 F4 K: y& S
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>0 L+ q  }. L0 C/ r3 y( m2 j
<input type='text' name='item_name'/><br/>
3 @9 G# e# ~, \7 C' P<lable>Item Amount</lable><br/>3 o" q; m" i5 L. O% v8 l- V
<input type='text' name='item_amount'/><br/>
. ]! m* j3 U$ q2 O8 Z" h<lable>Item Upgrade Amount</lable><br/>: F& A% m% j' ?
<input type='text' name='item_upgrade'/><br/># y8 C1 \  g7 e0 C* l- z
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
! t. p! d  {; A/ i/ W; J$ g! Q
- z& G' p7 Z+ Q( O3 z: L</lable><br/>
8 `7 K8 q% t( V<input type='text' name='item_element'/><br/>
& t( g" `% u/ M* B<lable>Element Upgrade Amount</lable><br/>: ]6 F( w: [* o$ G9 }, ]
<input type='text' name='element_upgrade'/><br/>/ T* f  E4 P% s8 f
<lable>Pierced Amount</lable><br/>
. k7 n) q: g2 k' L7 E" g$ [/ B<input type='text' name='item_pierce'/><br/>5 `+ x  ~9 c5 Y" d9 f+ V
<input type='submit'/>7 P+ g7 G9 Q. p" X% J
</form>";' J+ b7 |4 _* O3 S4 P* K0 o
}
. J3 Z1 e$ q' w9 L, b; h
. z5 w8 P/ o: x/ N6 Xfunction PostListener (){- s; r4 a+ ~# k& T, |
//Add more post variables if needed and add them to initform() function aswell1 Y6 t  M' m+ C- M- h0 X" O

' {2 x" C' G9 I8 f6 r5 r  c################################. F! _0 r6 b5 ^
##### Connection and Post ######- a8 l1 e' y  W+ T, m/ s5 {
################################- r9 j0 e2 O/ o6 ]
$name = @$_POST['char'];
! [$ E% s, p9 W" m+ q$ItemName = @$_POST['item_name'];! m; K. P1 j8 X
$ItemAmount = @$_POST['item_amount'];0 |& r2 F! `. {6 b
$ItemId = @$_POST['item_id'];& H0 G& t$ }3 c- A1 n: o5 M% a7 e+ w
$ItemUpgrade = @$_POST['item_upgrade'];$ _2 ]3 L. t; d) w5 N0 ?7 C
$ItemElement = @$_POST['item_element'];
' I7 @' C. I" `$ W# l: C/ E$ElementUpgrade = @$_POST['element_upgrade'];7 H6 c3 J& s0 j  Q- ?
$ItemPierce = @$_POST['item_pierce'];1 Y& B% e- O4 D3 H( F' o& K% L0 q/ g
################################
: C: t' `( @/ |6 j0 l1 J8 {8 P2 r6 G# W: k. l
//Check both variables for empty value
( L# S( m0 r. U8 A% m: t" g
* p3 [1 u/ j$ V. a* a) O* hif (!empty($_POST['char'])){
, p" T+ \: Q( s9 `$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
: n  C/ Y8 Y/ R# A/ \; N$ m% x5 t$ L5 i5 f# J6 T
m_szName = '{$name}'");/ [4 h% K4 K1 d7 Y! l: _: b
while ($row = mssql_fetch_object($find)){5 t- R& w, A8 z0 J0 Y# T  ~$ g
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
3 Z: c" N! ~( u9 Q$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ' w! n: h8 s$ e) \
8 Y( g5 }6 B& \) m- G- m
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ! N1 ~+ J% q/ L( ^- L: ^) h* `* D
7 W% {; F- A  R+ }, ^
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
9 \* u" t+ h, N4 `% G' E" B
+ ]% E7 S. E( l8 U, g+ y( ~N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 7 S: X. W9 Y( H: V2 m, |
7 z+ ?: W( F0 k! S/ {9 J; ?9 Y
'{$ElementUpgrade}', '{$ItemPierce}');");: v1 G! ]) h7 |& u0 D0 q4 [
}
! \' a7 h, K4 ~. b4 r( m' m  E  A
}# C: h; {8 F5 d, z

& U: e7 w, d% d, O}" _  k# D8 k+ f) g

% v* M# s# x  s7 {5 X$InitForm = InitForm();1 v, u% K. |) c- E2 R
$Listener = PostListener();
$ E( d; p* g. o2 W/ ?: F3 z. G5 {! P. G* F3 `6 l2 n
?>& w  |8 W& t  r  i& O% q) R9 k" Q

- I7 t7 `& m: Z+ K- w6 C$ e6 V) p( E/ F
, J" L3 h' {. F0 B$ L* F0 k" B# J  \) d) Y8 ?$ [" I& o. z; G% r

3 k5 O; c  ~$ D4 N" r% T) V
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-22 20:53 , Processed in 0.066337 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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