飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1088

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1088
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
8 i5 F+ v9 {$ X0 Vfunction Connect () {# k0 x4 R- @, s: c& K2 m
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
0 o. g+ Q7 H8 C& e  d9 G0 b( v! u  B- n
Failed.');
6 ?" M8 t1 T8 {  j) M; J* N}
& b- K) `1 D/ E& k) c3 l" tConnect();
! S3 _! L, l- w* X/ M  L- P
, I, ^* H* R& {- V0 u3 a" j* kfunction InitForm(){/ J2 {' s" U9 k$ S4 @( c
//layout for the form
5 z+ K! ?" f( q# qecho "<strong>Send Items.</strong>
& b* y( d6 N1 a4 r- e1 T1 q8 C<form name='select' method='post'>2 C9 t4 V9 J6 v& k: P! @) W0 x
<lable>Character Name</lable><br/>
! I( z& ^2 S3 N! c' c  y3 A<input type='text' name='char'/><br/>
+ k; [! f) Z' _3 \% z: z) ]<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>5 L  E7 u; i: s
<input type='text' name='item_name'/><br/>
; _/ Z. o5 w* c. @1 M" g9 w6 t<lable>Item Amount</lable><br/>
* e0 E  C" A: x" q4 {$ M<input type='text' name='item_amount'/><br/>
, D$ N7 g/ v  z" T: G. `<lable>Item Upgrade Amount</lable><br/>
2 C7 u. N, o( Y) H<input type='text' name='item_upgrade'/><br/>" y4 |( V" ?4 D. c/ u9 S
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)* d9 N/ {+ E8 x# \  n- J

2 f, d4 P" }) @</lable><br/>/ O5 I% n" B8 |$ {/ {
<input type='text' name='item_element'/><br/>7 A# q: ^) {+ v  h6 m
<lable>Element Upgrade Amount</lable><br/>( e0 k- Z' a- F8 ~( k
<input type='text' name='element_upgrade'/><br/>" Z- |4 R6 d% m
<lable>Pierced Amount</lable><br/>' l2 t' {* ]3 Z! p* s+ g3 h- V2 ?9 M2 }
<input type='text' name='item_pierce'/><br/>
6 n( b2 |" U: L: K<input type='submit'/>* W% X# L% W9 }1 u# ]% c
</form>";9 `% w' `4 e: y* T
}2 Q% @" x. m" z& u' c: \4 ~, c9 g: B
" R4 A" I  J- J8 a! q
function PostListener (){
- Y) z5 x  I" h" P4 i0 `, y//Add more post variables if needed and add them to initform() function aswell
, Z! Y* l3 v% u2 b' X9 ~# g1 q# |, G4 a
################################
  n/ y2 h1 v4 Q! c6 ~9 E##### Connection and Post ######
! _* R$ l5 P5 \5 j' @################################
: f' A$ t- T% X: t5 @: M$name = @$_POST['char'];
/ F. m* z+ f* _! ~0 i$ItemName = @$_POST['item_name'];) d' P1 }" L5 k6 j+ d8 d& B6 k9 f
$ItemAmount = @$_POST['item_amount'];+ h7 |4 y% k+ I$ F
$ItemId = @$_POST['item_id'];
, ^  K, W! H2 B1 [. `# m/ q+ ]! t$ItemUpgrade = @$_POST['item_upgrade'];
/ S8 N0 K, P1 L5 Q4 R8 D$ItemElement = @$_POST['item_element'];  |/ ^/ U1 \' t/ |; B7 Z+ T' W
$ElementUpgrade = @$_POST['element_upgrade'];
# T6 {2 R' @8 O: ]+ r0 `/ g$ItemPierce = @$_POST['item_pierce'];
7 ?& ^' ?& b$ j' u################################
7 d* ^* L  d2 r- g3 T1 p% O2 }$ \( W8 P  k
//Check both variables for empty value
5 f4 E9 e7 F3 P3 ~, d1 Y, g
; {, h- v; p/ ^. R* x- m' j! |/ Mif (!empty($_POST['char'])){- i2 N& K: S: _" |; \! ?" y  C) J1 K% G( B
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
+ {- M3 w: t' r  E" q$ B
* O: h. G/ @2 K5 q! ym_szName = '{$name}'");
0 _/ M% }7 A5 ~. ~$ iwhile ($row = mssql_fetch_object($find)){1 \/ ]; z5 _3 ^; j6 ~. D
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";- \% g" [' d6 `; S- t/ A2 _# @3 y
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
' w8 d' Z# C( ?' O
  [; Q; u, G+ X. z[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
/ T% g- \- ^6 ^5 e
' }2 L" D# ~5 W1 d# ]( c1 y  ?0 U# G[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
" p  A4 m; {+ m" {" C9 F! m. `) [9 b" d# ?0 J5 M2 f
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
: l/ v' \" u$ ?8 Z3 h+ I: |4 Z6 e: ~+ E% w) S7 A/ A/ G
'{$ElementUpgrade}', '{$ItemPierce}');");
  @6 g# x: v1 F5 j}
# R5 V- ~- I& X. J0 G
& Y& K+ X2 V! }+ W% C' c, U2 f6 R}
2 U8 s) |$ ?4 M- Y, x. k; A- ~  p& E! b0 ?6 O
}
3 w2 }& i- d" y# G0 X1 B4 z* P5 J! A. @7 l, q2 m" i
$InitForm = InitForm();
$ r9 r% |0 Z& X) s+ ~$Listener = PostListener();$ j4 _: y5 [0 F; V

0 d6 z" ^) }7 y$ h& T! s9 U0 y- w?>
8 [. E4 L# D' ~" {, O( Z+ c/ n
# z% ?# [( X5 c' j* N
& c& r) K/ y( J9 g, U. V

& x2 e. z1 P! ~
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-22 22:19 , Processed in 0.064950 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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