飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1070

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1070
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
4 Z- V) X% b) P+ c: Dfunction Connect () {
: f9 M# ~( P6 ~% o2 ~# e1 Cmssql_connect('Server','UserName','Password') or die('Error: Connection to DB $ B% ~  ]0 M! M) o
5 v0 z+ m+ C) [( J
Failed.');
: u: \% p' P( R1 J; K& R) \}- J# l+ P* I/ n6 {
Connect();
+ M/ ?: B+ r" a) d7 a7 e3 d+ c
" W8 y, a9 [# X1 P  V: xfunction InitForm(){& i/ t) V) j% H) f+ d
//layout for the form# ~$ F* _9 [. x/ p6 w( N
echo "<strong>Send Items.</strong>
. M6 S" u) U+ `7 G9 R9 @<form name='select' method='post'>
8 Y" l: p( A% N" l$ Q( ^# T<lable>Character Name</lable><br/>
0 ~3 ^0 \- ?3 U' l+ [6 d" X- T<input type='text' name='char'/><br/>
6 H" G7 d7 @: h- x<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
" q* M2 X" r) F! U0 w* k  m$ e- a<input type='text' name='item_name'/><br/>
) D. Z% u6 |" q& d( O9 a<lable>Item Amount</lable><br/>, ~; p0 [  k% O2 C" I0 Q: I
<input type='text' name='item_amount'/><br/>
- Z8 C; D. G1 b<lable>Item Upgrade Amount</lable><br/>
1 z* k8 I0 Y7 Q: X% p: V# g/ O<input type='text' name='item_upgrade'/><br/>
, q, G" d0 B! D, L& D- M<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
$ N' E# Z7 s$ m# k! {8 v0 B  }4 C& E- _7 q8 x$ D* [$ C, c0 B" ?# _$ T$ L+ e
</lable><br/>
8 e7 ^) i, l0 e' Z<input type='text' name='item_element'/><br/>: Y2 C' X5 f& N$ N: g3 R9 R! w
<lable>Element Upgrade Amount</lable><br/>1 C9 r+ O  {- m0 `
<input type='text' name='element_upgrade'/><br/>
. B' f) P; [: B0 M9 |! M8 L<lable>Pierced Amount</lable><br/>1 D: L5 u5 S% K+ h& X- v9 p1 `" T
<input type='text' name='item_pierce'/><br/>
3 M' U0 X2 P" H4 q0 r( r+ A<input type='submit'/>$ ^* @2 V7 N$ `
</form>";* [2 z; P) }5 N3 ]
}/ f/ C& v. c8 I0 j- v
! l/ H! ^2 x0 G7 p& W6 Y
function PostListener (){
! O9 W$ C8 ^0 R$ b# k//Add more post variables if needed and add them to initform() function aswell
" S2 x' C4 U" s- G9 k: P6 U3 H$ n" ~: {6 `+ n7 n! s" J" L& ^# t
################################
6 r6 r3 r$ i2 c( ?- \##### Connection and Post ######$ R6 q3 m1 I/ }) Q0 ~/ @. F
################################
1 ~: Y% m3 p1 D' `$name = @$_POST['char'];7 Q' y  [/ |& d$ S' w
$ItemName = @$_POST['item_name'];
+ J8 h3 M8 x& e' Y$ItemAmount = @$_POST['item_amount'];1 p0 k6 z# ]- n8 e
$ItemId = @$_POST['item_id'];8 ]8 e9 b4 W1 T( n+ _
$ItemUpgrade = @$_POST['item_upgrade'];
% M. a" p) P9 I: C+ i$ItemElement = @$_POST['item_element'];: _' {9 }  |" L4 ?& i) `
$ElementUpgrade = @$_POST['element_upgrade'];
& F: Y+ u- O' O7 k2 w# m  c$ItemPierce = @$_POST['item_pierce'];1 x6 {+ K4 g0 L% c9 D' H* h* B
################################
7 U0 q, j% l0 }4 ~- r9 f+ ]! M7 ^9 r$ D; w
//Check both variables for empty value* X) A1 ~3 e5 M3 b+ N
  R1 ^$ y) N; E
if (!empty($_POST['char'])){
' w$ a4 H7 L- Y8 B$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ' `( a) I& u/ l$ N5 b

5 Y: F- i+ j& r+ _$ G- y9 vm_szName = '{$name}'");
0 W) f3 x1 X4 z/ Z5 X% owhile ($row = mssql_fetch_object($find)){
8 ^# S4 ~1 I. \/ H' g4 [! Yecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";" N+ f: n, R- q
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 6 E6 q  s4 e# C4 d' h
8 B( p2 W. ?5 l, @* ?) h
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
2 x" @  c& D: K  L1 C& C- B
7 y! i! I, h( s7 |2 {[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ( B; }/ Y9 E% k: S6 b
) ?' A1 `+ }  B1 P7 ^* n
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', / t- ?3 Y# v! R. z7 Q
9 d( B2 L( e1 _
'{$ElementUpgrade}', '{$ItemPierce}');");
4 ]- l9 O6 b, i0 N}; m/ h5 U. m) t% V! |0 I& t/ x
0 T. N' V& u& U! H4 r, D5 v- b
}4 w, |7 h! i! ], R! G% g  |

0 ?6 Z/ Y2 N3 y}# A2 q# h" R. g6 T+ h

# A% V  Y$ r* O/ I; a5 x! _$InitForm = InitForm();# F$ P) i& ^3 \3 [
$Listener = PostListener();2 d- B; I6 p/ J

) b  P! \( V! [9 y! r?>
! F7 u- _& A1 s& D( E
! C. G( A. ]9 W2 G- [
6 H" C- ?5 t! K" `+ z/ I, k0 S* E; B$ p( o
5 s5 \6 i3 S1 x
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-9-17 03:36 , Processed in 0.074434 second(s), 30 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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