飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
% C3 }/ ^1 S/ `8 C% N+ w+ Jfunction Connect () {
' B+ R: w0 R& _mssql_connect('Server','UserName','Password') or die('Error: Connection to DB / J  B+ H( H% n# z

$ u* O! j3 v0 y2 z+ ~6 DFailed.');3 p: j  ~3 d( q% I7 M$ O) m% M
}
! p- @* T: E* R2 ^) mConnect();" X9 l/ X3 S$ X6 M+ K
; E* M5 \+ M4 B
function InitForm(){
* p) n- g/ g4 ~# D+ N' b# B' c7 i//layout for the form1 T  |, Y$ {( }
echo "<strong>Send Items.</strong>
$ l+ E/ S7 c3 }/ _: v: Y<form name='select' method='post'>
+ T* a/ C8 l# c( P! s/ [<lable>Character Name</lable><br/>
9 f( F6 [9 Y& h: Y/ ^% I<input type='text' name='char'/><br/>
) c7 D$ @# N* `- w0 Y  B" f<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>  x% G$ Z0 z1 f5 t) E' k
<input type='text' name='item_name'/><br/>
( y1 {& ]% E- P<lable>Item Amount</lable><br/>
# p; B0 Z0 Q0 ?- {5 v: i<input type='text' name='item_amount'/><br/>
, H$ o' B# |: i$ n. g/ R8 y5 Y<lable>Item Upgrade Amount</lable><br/>2 G" j& k$ h( M; ]4 Z* d3 N4 t2 a
<input type='text' name='item_upgrade'/><br/>9 m3 e* Z/ h$ ~' `3 r+ _7 e8 t; S  R
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
7 s; ?9 L4 s7 Q) F# v0 J9 |. R. N8 u) h* Y6 }; r; }
</lable><br/>0 H- z. `; @9 i# ^
<input type='text' name='item_element'/><br/>
7 Q: r4 F$ |+ J! E& K<lable>Element Upgrade Amount</lable><br/>
& o1 r2 G* F4 e0 ^<input type='text' name='element_upgrade'/><br/>& v4 S1 l# X; o7 o' p
<lable>Pierced Amount</lable><br/># I, [- \; m1 A
<input type='text' name='item_pierce'/><br/>: b2 M2 y& Z( j5 r# Q7 T9 \' t
<input type='submit'/>
# c1 E8 m. }+ j- T</form>";
7 D1 X' ^$ y3 z& ?+ l}
5 ^6 I- `5 T9 ~0 J$ _5 @
& V4 g, d/ d7 s: Z3 z4 xfunction PostListener (){) ~6 u- n9 S. y% T
//Add more post variables if needed and add them to initform() function aswell
+ K+ b. `1 c1 E& X/ _" k$ t1 F/ v2 Q
################################
) B" ~& y7 G- n+ T6 e! n; E: U/ `##### Connection and Post ######
9 C# e1 b+ }: b! C################################6 S3 I% W3 J6 F; e6 Z0 R. Z6 z
$name = @$_POST['char'];3 l( N% e4 u3 F4 _1 d
$ItemName = @$_POST['item_name'];
3 R- K4 K: R; d9 R* [! ]$ U  X" ^$ItemAmount = @$_POST['item_amount'];  r/ _: l6 q+ Y: Q& h' u7 z
$ItemId = @$_POST['item_id'];: L0 h7 o8 b# y' w* h' q/ G5 J
$ItemUpgrade = @$_POST['item_upgrade'];
# F: e+ S( k' B1 w0 D9 F) ~& J! L$ItemElement = @$_POST['item_element'];
7 b! Q  O- Y. f5 Q5 @: X$ElementUpgrade = @$_POST['element_upgrade'];
, W) x5 N0 P% k$ ~$ItemPierce = @$_POST['item_pierce'];
. p  J7 P5 W$ c  D, [+ M3 n$ y################################
9 [( S6 ?: e; O6 P4 b' p
2 w2 \: h  I) ]//Check both variables for empty value
/ Q- u; ^4 K; c# ~; L: W
) |% C5 P- c- H, J+ Y7 _4 M- f" qif (!empty($_POST['char'])){
% w2 c1 K9 f+ O* F0 x# X* q$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where , l. F8 c, }$ c6 T9 |  y
* C5 w& b$ Z6 {- T' N
m_szName = '{$name}'");( y6 i( H/ j! i1 t% P8 i
while ($row = mssql_fetch_object($find)){& q1 O  {% G6 ^0 I6 A+ H& G4 ^" o
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
% ]# a9 X  Z$ b+ f5 k- a! H' v$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
, Z+ m, w* d, L& B& w3 U
$ Y4 h" o! [) O7 U" |$ Z[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
; m" l: O) }5 Z1 z6 c6 u- _
) I( y9 k5 i% I- K, t[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 2 |6 [1 P! p5 F6 `
1 a6 [5 i* V2 j2 U' b
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
. Y7 B9 `) S1 t( m) \
$ t7 O& v' ]7 K" h% r* m) S6 R'{$ElementUpgrade}', '{$ItemPierce}');");
+ [4 p' \' v% f1 D9 A1 f, I}6 i9 x+ ^* \0 |7 y
5 Z/ D" ]3 A7 O, O" B* R
}  n3 W2 z" w' G  N* m  `. p7 C2 ^
5 V. b3 G1 h) G8 Z% I' x( h
}
! ?, d$ X0 @2 {% R7 z6 T" f  [. {: D% t
$InitForm = InitForm();/ ~& s' x, T- u1 z
$Listener = PostListener();) S9 h, L+ v8 P/ i, L, p2 @
/ F$ t3 B' T6 ]% Y/ J/ p# t: f/ Q
?>
6 \; Z6 |0 X3 {4 `5 S) e1 ^* ^( M1 O; b
0 y  [. c4 Q2 [6 m

0 t# v: c/ t- h% o/ P, Q8 c7 ?  a) G# }8 s2 O! a* U4 e# D5 W
回复

使用道具 举报

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

本版积分规则

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

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

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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