飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1092

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1092
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
! h. P" W6 x7 v  z0 b8 Q( a/ Pfunction Connect () {; f" @7 E. _$ Y% C" j, q3 w
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
) W2 v5 u2 N" A- l6 `$ y' h7 t8 A7 Z. {
Failed.');! ]7 d" P9 ]1 j  X$ s( D
}# f- i/ E/ F. ?# N
Connect();6 F- ^+ [3 k" u  @3 W$ N) e1 ~4 q1 \4 [

/ N  C1 b) }- c5 I8 ofunction InitForm(){; F5 O7 D6 n- ]8 ^2 |& ~% R' f
//layout for the form
5 S% c8 b1 R) D5 c& m, xecho "<strong>Send Items.</strong>
8 S# r, R) E) u+ k  ^$ }<form name='select' method='post'>5 M4 ]2 c% B3 B8 A* ?. F
<lable>Character Name</lable><br/>' `0 H. i0 H4 m$ {
<input type='text' name='char'/><br/>
' }* C, Z# Q! ~- }/ V+ f. S<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>+ ~$ z" z% v2 G
<input type='text' name='item_name'/><br/>; ^1 Q8 v9 ]* B
<lable>Item Amount</lable><br/>3 [( @" {  h$ J! u2 P' V, ?* K8 M2 o8 P
<input type='text' name='item_amount'/><br/>
& D7 C% F- \' `# N0 L<lable>Item Upgrade Amount</lable><br/>5 |& V( H6 g3 P/ i8 m7 R/ b5 O
<input type='text' name='item_upgrade'/><br/>
/ A0 @3 m' t) Q8 ~' @2 \<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)% H1 S% {+ G+ {- B, _1 n6 ]1 x1 [

2 c6 R  ^+ b- d+ Z</lable><br/># v- c* q# o4 M: q
<input type='text' name='item_element'/><br/>
+ [9 E% c# j/ A9 n1 `<lable>Element Upgrade Amount</lable><br/>( m+ a! S! v6 h% P3 Q
<input type='text' name='element_upgrade'/><br/>
8 `- J( u7 P, r) _& Y/ g- k9 G# ^3 d5 m<lable>Pierced Amount</lable><br/>
# e2 x3 Y8 n+ W0 c/ X8 U" G<input type='text' name='item_pierce'/><br/>
4 r! s8 Z" n* o. q' v, S<input type='submit'/>* ^5 h" O7 b) I
</form>";
" w3 W# s, V- h}
1 a; A' K: f; z3 T% o8 N+ q- i# f# V0 v  i
function PostListener (){6 A+ Y8 G2 K! q1 ~, @
//Add more post variables if needed and add them to initform() function aswell
4 i/ j  N$ W* ?7 J
: a% u: U& O: q2 |################################4 X5 a, K3 A' }* p- j  i6 Y
##### Connection and Post ####### _( Z& ]7 A. o0 d% O! d; z
################################
. J! x' M- j3 ?. l: ^8 k2 @$ n# ?$name = @$_POST['char'];4 |( G$ V% k0 l+ G; ]
$ItemName = @$_POST['item_name'];9 U' N5 k, J) p: k
$ItemAmount = @$_POST['item_amount'];
( @9 i. c' v! p. X* I: g$ItemId = @$_POST['item_id'];, U: c( D) [9 X: L* i% v
$ItemUpgrade = @$_POST['item_upgrade'];
; D- D2 r8 ~$ B* j& L$ItemElement = @$_POST['item_element'];0 q9 ?5 |3 e) o0 m& \4 p+ m
$ElementUpgrade = @$_POST['element_upgrade'];
3 K! i' e8 Q% a/ U$ItemPierce = @$_POST['item_pierce'];! M2 k7 L1 r* T
################################+ B6 |) ?' R; I! q
3 v$ ^/ A5 B- [. _: S( L/ |! O8 b
//Check both variables for empty value
5 ~1 o! Z0 A0 I  O* F7 O
( Q: Y, B. [, V1 j# k  |if (!empty($_POST['char'])){
$ I: |/ }  C+ e1 R& o$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
% r; c' b2 x4 {3 x# q4 m: |/ B9 p" N! E7 p6 h$ Y3 V
m_szName = '{$name}'");
$ X& R! s: u" C* E" ~+ a; Lwhile ($row = mssql_fetch_object($find)){- h' E& R, T% Z; s0 G
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
0 H1 n( X) |) Q2 P: M6 P- q8 f$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], : D0 O( t  C* }

9 H7 @4 m4 |9 Y+ p; e[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
& A% W+ m! z3 Z9 S$ \; Y5 o3 x9 x
1 T: r2 P$ }" V0 Q9 Q9 u, q[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
$ {( f; _( x2 L3 f8 k# \2 R- Y& i
, |8 l7 `$ M& s2 vN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', / p; t- N$ q: f: f8 A

0 D& z1 L" |1 L- _. o'{$ElementUpgrade}', '{$ItemPierce}');");) q( J- r8 U2 M' Q
}
, i/ D, @/ S2 A' L6 s
. G) n% V$ j8 W4 g}
2 y) i. X# Q$ m7 \% i, F
7 r/ |- f6 Q4 V( i& q}, C' x# p" B* ^$ Q% k' P7 U

$ [# h3 K( L1 g4 N% C. j2 ]$ D$InitForm = InitForm();6 l. y9 H" X, X. U' F* c
$Listener = PostListener();, f0 T  C8 _  \1 S" L6 F8 y" f/ H

2 w; }5 ^8 p# N& B  N( M. N0 Q) v?>: |# a4 ~4 k; [5 a/ B. e
8 C- V& a9 O% r! r

* z- S5 n4 y9 C
0 b8 f0 `: s) U: K- e* a% H: C
5 n7 [  K% Q* O2 ?5 Z
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-29 11:24 , Processed in 0.071251 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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