飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |正序浏览 |阅读模式
<?php
# E" t( u$ ^2 x1 U7 L. i. h5 Nfunction Connect () {
' {* C( z: \/ Z- F6 H6 ?, Hmssql_connect('Server','UserName','Password') or die('Error: Connection to DB / H% e1 L7 F6 \4 W+ |* k
5 `0 [3 {) X2 x! S$ x& P" A* ?# x* C
Failed.');" D/ ^# b7 R- t4 \% C. j; u
}* |4 ~! k& a/ E& N3 x. l
Connect();- K- ]/ O/ c( }" F/ I

# s  A2 j3 y/ h: ufunction InitForm(){
$ p* B7 U7 e9 K% D$ i5 K//layout for the form
' l' x; C7 s. N  q- S9 Decho "<strong>Send Items.</strong>8 E& W7 {& r+ a4 y. W8 f. j; {( y" t
<form name='select' method='post'>; T" F7 j1 A6 n4 x, q, e" x
<lable>Character Name</lable><br/>% a6 i( {3 G( h/ w/ u& g2 h& F
<input type='text' name='char'/><br/>- [9 t$ d7 r' \  ~# V& m# s
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>9 f  i% p9 n/ ~- a8 j8 v; L- @
<input type='text' name='item_name'/><br/>8 V+ s  I  S/ u  O* n* f
<lable>Item Amount</lable><br/>
7 @6 u4 I1 A* j5 [- n; p, k- A8 V4 Z<input type='text' name='item_amount'/><br/>
: y* T* g6 F# N. C& A( [<lable>Item Upgrade Amount</lable><br/>7 S% v3 W0 q( k& w
<input type='text' name='item_upgrade'/><br/>
' ?, `; ~1 `+ b( O8 W<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)% z5 a0 q0 T+ g' K  Q4 m  w: j
$ ~0 j- A( S/ J1 H$ u( B& S
</lable><br/>
3 {+ w8 W; L# Y* q5 `<input type='text' name='item_element'/><br/>+ s1 g5 O, u+ t+ C! X* o7 a
<lable>Element Upgrade Amount</lable><br/>
0 p7 `9 J$ u% U3 L% f4 P8 t<input type='text' name='element_upgrade'/><br/>7 v. p6 b- e" E7 b7 D& R; R  J2 l
<lable>Pierced Amount</lable><br/>- B0 j; {/ }( r$ Y" f- Q8 d
<input type='text' name='item_pierce'/><br/>7 e7 p  ~( R/ |! ?; |' u0 h
<input type='submit'/>
$ v$ j! Y( ~4 W/ U- k/ P</form>";* \$ o2 c. m, j- o
}; u! j" P1 ^7 i

# k& q: ]7 J, Tfunction PostListener (){! X6 m; P  P( x: i/ E8 |- y9 u
//Add more post variables if needed and add them to initform() function aswell
) R' S9 A8 [( q+ `0 S
& K! h2 P9 \3 t8 M" |) Y+ R################################3 p3 i# K8 N" @! i) [2 H
##### Connection and Post ######1 ~- D' w" T3 Z
################################' |$ W  t) X- \. f: ?
$name = @$_POST['char'];- Z1 |0 {5 T  t( E2 \1 r
$ItemName = @$_POST['item_name'];+ f. t) u1 U* ^' b7 ~5 t! `
$ItemAmount = @$_POST['item_amount'];
$ p# r5 {# T4 y% G* N5 ]' y9 M$ItemId = @$_POST['item_id'];9 r/ R1 \- K( Z0 \4 h$ r
$ItemUpgrade = @$_POST['item_upgrade'];
! R5 ?% R' M; }" z' h1 I& J5 F$ItemElement = @$_POST['item_element'];1 a1 d# G# B+ k! l( [, C! t2 y
$ElementUpgrade = @$_POST['element_upgrade'];
% i) I3 f# _5 }5 `0 ?0 f( N3 }1 B" P$ItemPierce = @$_POST['item_pierce'];
1 l. p+ A3 r6 o( u) S1 W- o################################- J4 ]$ ?5 L2 b5 g; C, s
9 B/ c- Y" Q) X: v7 M6 D
//Check both variables for empty value
* B# W9 N1 q& ]$ M3 q+ L, v3 S1 x0 k# n* T# g
if (!empty($_POST['char'])){
/ Q% Z1 p) m' a: D0 V8 {3 i' U$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
0 \5 k: e7 v$ _) l8 U- x: A# |
% [" j0 z. r6 m% Om_szName = '{$name}'");
* W2 Z' v1 {, A2 {/ k/ g( ^while ($row = mssql_fetch_object($find)){( L- z  g' t, k
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";' {! s/ D5 D/ h& Y0 O
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
. d1 J3 r0 z* M  `; M" V+ f
  k* M) {& t5 R3 D( D[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
7 A5 k- j9 `6 `  T; {& ]' i$ @
, q. z2 O$ Z6 L% p8 a[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 1 P4 F0 I; V2 F" R" x

! n5 a; \. E) P' Y* |N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
. l: _  G% U9 g2 E+ Z
* ?+ q& k2 D# F'{$ElementUpgrade}', '{$ItemPierce}');");! K% W% D' l1 V
}
1 K1 P" G5 o0 P0 N0 `1 u' e
. s" |" K; y3 W4 l( o/ [- A4 d}
6 Q5 D: q, ^  T; z! @+ [5 y+ ]) w; F! Z2 u! m- M' R6 u& t
}
$ [% l( @0 q  Y2 c, i' }+ I3 \3 E4 @$ L2 D* p: L5 {' ~
$InitForm = InitForm();5 h$ e0 y3 G3 @( V- ~- P
$Listener = PostListener();
/ ^3 G% u/ z/ s2 a
9 N! t/ u3 P# l/ z! a$ F?>
& t$ ?9 }0 a$ y( u- u5 s. ?0 `- o9 f6 X8 G# m1 \' x

# ^  q+ y% h+ ]: ~- T1 Z2 b! m# i: v$ d
: N4 b7 u, B4 O' [
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-13 15:00 , Processed in 0.061858 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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