飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
7 p1 N# Q7 d0 P. W7 R; ]$ zfunction Connect () {
; o& X% O1 {- Ymssql_connect('Server','UserName','Password') or die('Error: Connection to DB 0 p3 _6 q1 `# F& T/ m
. f% V$ u9 h; I7 m6 I* z1 G: r
Failed.');( j5 ^" Q* T& A% S
}7 z+ K% n& s+ \; T  Q9 K
Connect();
$ p, g+ P, u4 g/ X0 [/ Z5 L1 t
$ a  e/ J9 j3 \4 Kfunction InitForm(){8 j) ~/ @% O* `1 J& ?2 z6 }& Q9 m
//layout for the form0 Y) |7 i+ {' ?$ D: Q9 y- V, u
echo "<strong>Send Items.</strong>
( |! a, t6 ~( J<form name='select' method='post'>
  M. s6 \# M4 H2 V/ x. K<lable>Character Name</lable><br/>
( D  h. I2 W+ {) e% l<input type='text' name='char'/><br/>
; @3 E% |6 d/ ^+ D5 O$ y3 ?; q<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>( m/ \  i" ]5 I+ k! z& r- J. p
<input type='text' name='item_name'/><br/>
! m8 l: ?* N6 R  S' c<lable>Item Amount</lable><br/>
( u  P9 A9 K# b- I<input type='text' name='item_amount'/><br/>
8 t4 H2 [5 ~9 X<lable>Item Upgrade Amount</lable><br/>8 l% {+ [6 R5 x# o0 B2 c7 V8 \9 R3 |
<input type='text' name='item_upgrade'/><br/>7 M- f/ s% ^+ W' i4 q& ?1 c1 h
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
5 p% p, a% d+ q2 @* h! A4 H' u+ R
</lable><br/>3 ~" F' ]$ a2 |4 J! ~9 y; b
<input type='text' name='item_element'/><br/>4 X1 m9 e4 s8 l9 Y5 \3 U
<lable>Element Upgrade Amount</lable><br/>5 Z2 u  e% M# l* s( O0 @! ?* x
<input type='text' name='element_upgrade'/><br/>) n# G2 r4 I, r( @& J" [
<lable>Pierced Amount</lable><br/>4 J8 z3 E& U8 J% n! U6 k
<input type='text' name='item_pierce'/><br/>
3 n3 S  X+ w* o1 J# m" {<input type='submit'/>
* m4 e4 V# o: S3 |$ @/ A2 g& s</form>";
, E8 p* J- c. h}; o. `8 X0 m. G# D

  L+ p& v; Q& F% d) rfunction PostListener (){
# R9 J! q" V( f% t+ `//Add more post variables if needed and add them to initform() function aswell9 `# x- [6 R3 t5 u0 M

( k& r5 q9 f0 a& Y' ?################################
; z5 x; e9 j$ N, q8 Y; _1 z" Z##### Connection and Post ######
% o) v  ~+ T0 y################################' M" G4 j. ^( x+ p, K, O5 b7 p6 u" z8 u
$name = @$_POST['char'];2 D$ F" A/ a' J  c: t6 ~' o
$ItemName = @$_POST['item_name'];
& ~8 q; Q) L: S$ItemAmount = @$_POST['item_amount'];
, ^- e+ S; f4 m9 n0 a1 X) g$ItemId = @$_POST['item_id'];8 V8 c& H- u, e
$ItemUpgrade = @$_POST['item_upgrade'];& a; w# Q) w0 b7 L
$ItemElement = @$_POST['item_element'];* M( v. s% _# ?" L; i( d: C# j9 r9 {8 g
$ElementUpgrade = @$_POST['element_upgrade'];* _9 U' }, V! G. Q
$ItemPierce = @$_POST['item_pierce'];
0 z% e" q, ^/ a################################9 Z4 K) E  U. {0 V2 Q' r
2 @7 i9 P0 N( ~$ u+ p
//Check both variables for empty value
. Y" `0 J0 q* z- T% ]( U: i3 K0 Q! ~4 q! R
if (!empty($_POST['char'])){
) D3 x' I# [, j+ P# K3 \$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
0 I$ E/ y9 w; P, F
! {  t+ o  u$ i- Im_szName = '{$name}'");( }/ @% |; v  O  n; [
while ($row = mssql_fetch_object($find)){
9 @+ s6 f) o# B/ H( Z, wecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";1 b& E: X! x7 l0 q5 l
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
* u  V0 Q" M5 S" u6 [+ m
% d3 Z& R8 E/ r0 A! E6 N% z* E6 D, h: [[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
! e# S6 ^7 a1 ~8 L2 O3 A9 q; M, b7 ?
" F7 C. o2 X9 O4 d3 ][m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
, J  |, Z! x! i; T2 A0 q: q! h
# b7 E% J/ B! Y, n0 eN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', - {6 m# U6 }* m! A! J
- J8 v7 W( o3 r6 w7 v  e
'{$ElementUpgrade}', '{$ItemPierce}');");
" V+ W, \+ d$ r! ?" s}4 c3 ^: Y1 e8 i! f

& x' \  {7 x0 {& N& @/ }}0 U5 C' \( U/ _6 O" j; J
. h" Y! b/ Y: \% f
}
" m4 L- C1 c: k' U& N3 ?$ R8 Q, m% E; |8 p$ @2 X
$InitForm = InitForm();
) Q& g% l9 U5 c; E* V. v+ _5 q$Listener = PostListener();" W8 e/ \; D7 h% H) ~/ p; L) C
1 y7 v$ y% a1 `1 _, C
?>( i: N' W* H% h
, r0 x" u* G2 M; B5 V
6 s9 o# u4 w7 L3 Y* L
9 l( r) z# u3 n/ X  X" C: @

/ _  L: M- N; p8 Q  a" V6 C* @- V/ X
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-21 03:53 , Processed in 0.127085 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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