飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1084

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1084
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php* s0 i4 }/ D) b$ Y
function Connect () {
, U# U0 B+ C8 G+ c! d5 tmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
- v+ T( N2 I8 y2 I
. g- J& U8 ~" L% pFailed.');; G' ^; ^: c! d4 Z
}# Q; H. \. m0 ~' f6 `
Connect();
7 c* f2 |( [' D  c; ]: ]' t
  V8 A! ~- T. [& q( g# m* p5 Gfunction InitForm(){
# n2 K. r% c& z3 m) F//layout for the form
) n0 k9 ]7 R% K! s) E/ xecho "<strong>Send Items.</strong>- ~" b1 u6 g1 e2 E. K6 b+ w; q
<form name='select' method='post'>
  w1 n/ I$ V) ~% F6 B8 A5 ~<lable>Character Name</lable><br/>! ~+ u4 m( Y7 Q3 Q7 R0 _3 ?: e
<input type='text' name='char'/><br/>6 N4 b" ]3 j1 u+ x3 ?
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
. @! T- d% k; @& B<input type='text' name='item_name'/><br/>/ ]' j& s! ~3 F2 j
<lable>Item Amount</lable><br/>2 `, [- [& R! F5 S& W6 O
<input type='text' name='item_amount'/><br/># L& p( a3 \9 W$ l
<lable>Item Upgrade Amount</lable><br/>
, a0 `+ j; g* U<input type='text' name='item_upgrade'/><br/>( o- w/ z' Z6 H" Y. f0 G3 p
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
+ [  W2 y: I/ M) O0 a2 O+ N0 Q! i# u5 x& ]7 h: k/ P
</lable><br/>
: ]* `5 N1 n) R0 I/ e- q<input type='text' name='item_element'/><br/>
6 H# H% d. q! A3 Q' q<lable>Element Upgrade Amount</lable><br/>$ q4 A! b, n, R+ L+ K4 x
<input type='text' name='element_upgrade'/><br/>
8 g5 k# j- j) T: d7 q<lable>Pierced Amount</lable><br/>
5 {& H! w. }" P) v, h<input type='text' name='item_pierce'/><br/>. u4 ]* @" k: C+ N8 D9 [( D2 s$ Q
<input type='submit'/>
! y9 |3 |9 D9 N</form>";; z3 L8 f+ A; L+ h7 U3 x
}" h1 }  _9 w7 v' m

' d/ {' q' b+ H5 Vfunction PostListener (){5 I6 z( k& V1 v
//Add more post variables if needed and add them to initform() function aswell
2 H+ b# o" Y5 b$ O/ L9 d, X8 ?! p; j' [9 {0 w6 i9 L
################################# Q  b, [1 g5 ?) y) m8 V
##### Connection and Post ######
* W" l/ Y: a6 ~" g% _################################: C# v0 E% u0 o" x- h) @
$name = @$_POST['char'];# N( M' }. _% n2 \7 O+ h; c% L
$ItemName = @$_POST['item_name'];
3 x# y# F1 b; E, }$ItemAmount = @$_POST['item_amount'];4 ~& K0 l- J% {% @& P6 @: _
$ItemId = @$_POST['item_id'];& n, p: f/ C6 e) ]( s9 M/ J
$ItemUpgrade = @$_POST['item_upgrade'];
* T! g* t# H- g  H$ItemElement = @$_POST['item_element'];
# b/ S! \3 h" R7 ?$ElementUpgrade = @$_POST['element_upgrade'];; P/ i& N' b& R+ R" M0 T# u! n& T
$ItemPierce = @$_POST['item_pierce'];
# Y0 e; C5 b( F( X: e################################- ^5 t" g  ]3 Q4 X+ a+ I
7 Y, g# J" M& Q
//Check both variables for empty value
/ t; I/ B' Y  w3 S
+ x+ T' B0 J$ `! x. g/ f1 F. Iif (!empty($_POST['char'])){
" n$ q+ I: d/ X) H8 r$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 0 w. P7 t0 v% j
( J' t0 M# X$ U& Q5 F8 K
m_szName = '{$name}'");
1 P) I8 p; R' C' U( L5 k7 ]4 X, qwhile ($row = mssql_fetch_object($find)){
( D' E4 c; d  a, |, T: |* {5 Decho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";+ t, s; z4 @4 s6 j) {5 r
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ( ^% t  @. [6 ]/ K
; Y0 J  Z7 C- p/ s
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], * @0 r- d# P% n9 R7 g# D) f
: e# h6 q. Y" M
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
# j" b5 |/ V" G: k* c, v
; \  R7 r7 }; X7 H+ PN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& S; a3 M$ h" q% R# n
7 w  B2 S, [* r2 A0 {'{$ElementUpgrade}', '{$ItemPierce}');");1 `0 ]/ l5 v6 h! _  H
}/ `# E& C0 I+ ^. n9 D4 c

. B- ~7 ^: v6 }$ i. [$ R1 b}
3 U! a2 N( S4 M' Z* C, `6 \. _
$ E$ h  q1 A7 m8 X}
( I  ~& X* G2 ~+ }5 h
6 @- y% D7 ]+ l4 h  [  X6 [- O$InitForm = InitForm();& E, f; u" |% z& b' P5 y  N
$Listener = PostListener();
  r% H; i- j" g. \
3 i5 v7 q$ c( {/ A?>
# Q- N1 ?, J3 D" S, P1 ~) S% l' f
. _* {+ c0 J% _$ e: J  q+ ~8 h6 U! ~1 `  P, h

, Q$ r0 [6 ?5 a, K8 q3 O* K" `
0 q  t& E& o- d' F
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-11-18 18:07 , Processed in 0.116841 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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