飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |正序浏览 |阅读模式
<?php
' q: X. j$ N+ x# O, v$ j* F) |. K- efunction Connect () {
9 t1 H6 k$ @; O5 |8 R8 }mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
- g8 x3 e1 g  z; Y$ v; O1 j# A& W. L  T
9 y& j* T+ Z# R+ j$ GFailed.');
6 V9 s) d$ v+ U! N1 f% o" b; ~! _}+ D) O! p$ k2 i' a- s, U- o& {
Connect();
& _( J  ]: c, k# f* H, {, y( a/ d* p# X/ I
function InitForm(){
$ U6 ^" r( M- d; V" H" @//layout for the form
6 G5 }8 T  A- D6 L' d& d: c, Pecho "<strong>Send Items.</strong>; S6 z6 R5 ]7 a" x! @" }# P+ R
<form name='select' method='post'>
! c+ N; K8 g% h3 E<lable>Character Name</lable><br/># h# m/ p0 [: H% V
<input type='text' name='char'/><br/>
6 T8 |- l+ a3 U" T<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>$ s0 c0 r% l$ }' B/ M: Q: U. `
<input type='text' name='item_name'/><br/>
2 `1 E/ ~5 K! I* z; {+ u4 X<lable>Item Amount</lable><br/>: k1 j5 v7 M) M- {, c( d  d
<input type='text' name='item_amount'/><br/>5 @8 P1 y% L$ e
<lable>Item Upgrade Amount</lable><br/>7 @* [9 U& p* T( Z; f) c
<input type='text' name='item_upgrade'/><br/>
, Y( N. F' N& I3 o<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
' S) A6 W6 {6 |3 Z; E. ]1 @! z* @" B3 j# @% n! N0 f0 D
</lable><br/>/ S: G7 k0 C- Y4 e: x
<input type='text' name='item_element'/><br/>9 N$ y0 x, V  R# D  I1 B7 B
<lable>Element Upgrade Amount</lable><br/>
5 e' o7 i7 l: \$ c<input type='text' name='element_upgrade'/><br/>
( F( {+ O, {  t/ ?<lable>Pierced Amount</lable><br/>7 ~0 i1 G  N3 K9 B% U/ B* o
<input type='text' name='item_pierce'/><br/>
. Y, m9 Y# {7 L" m<input type='submit'/>
* i. B, a+ v  ?. Q1 |4 i. u</form>";
* h1 X1 V% s- e8 k8 u; M6 p! N, g}! `0 ]. F9 S3 X. \9 e1 D
/ w$ X+ ?, f- I; x
function PostListener (){( y$ U0 N* G$ h
//Add more post variables if needed and add them to initform() function aswell' n  S! \$ |; n+ h
" c  _0 H+ V( s2 |2 @0 |/ l5 [
################################4 J: @! @, |4 v) p" C8 ?, u
##### Connection and Post ######
2 y( c; j9 U) t5 r+ f) F2 t) Z################################( W: \$ L- t& p% }
$name = @$_POST['char'];
2 S1 O' T' ]: k6 e5 e$ItemName = @$_POST['item_name'];; \- U' F6 s1 l6 z% Q, ^
$ItemAmount = @$_POST['item_amount'];+ a$ `& {; Z  D; K8 e5 x8 ^( Q
$ItemId = @$_POST['item_id'];
: ?1 E3 K9 t$ T: U$ItemUpgrade = @$_POST['item_upgrade'];
& _6 u4 o3 E6 c4 J0 m$ItemElement = @$_POST['item_element'];
% W4 j6 l9 T! m- h$ElementUpgrade = @$_POST['element_upgrade'];: o$ V- c* ~8 |- h
$ItemPierce = @$_POST['item_pierce'];* W4 W0 \, p6 Z9 c4 e
################################" m4 M5 z$ e' J; X. N

1 U# L, \( N/ A( A4 E/ O$ j7 R//Check both variables for empty value  d( n6 Z0 Z' t* |8 H  d
0 Y9 S( J! W& p2 m3 @
if (!empty($_POST['char'])){( r4 v! P" L, E
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
) O; k  ?% |4 h8 h! q
  C+ R* K8 w- P- T! Fm_szName = '{$name}'");
  p( R9 |: i4 b" Z: s' n  _1 }) m1 |while ($row = mssql_fetch_object($find)){
0 u7 R  Y, m' {4 y* w, techo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";6 x/ A3 ~: B) _5 c! \% {
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], - w' y5 d4 ?' k% O& d6 W) i
/ S8 X8 A4 s- _. @5 Z
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
6 F* }; C8 x# R" A) W6 I
, H. R; @2 S5 J/ n; a+ _! ][m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', " F4 i* T  o1 Q

5 X1 |+ Y7 K0 `1 d: D$ \1 D8 B- Y( DN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
1 {( L* y: Z8 ?% r  B* C7 s* o7 g) h) j' z7 I9 W
'{$ElementUpgrade}', '{$ItemPierce}');");' y# K5 X. m4 O
}$ [) j" a3 Y; Y% X3 Z8 ^
; j6 r5 p; K. q# s4 m4 i
}
0 v4 R8 z& R% b/ t4 k  k
8 H! J( w% c% `+ ~/ y8 a6 d1 L}
& ^) f: m# k) H  V2 c2 R
' I. \( T4 Z6 ?$InitForm = InitForm();
. m; \3 _1 r! \8 U$ Q$Listener = PostListener();: Z1 [6 Y2 p+ X& ]' Q

8 |( u9 A' v7 a( H; \3 S- `?>- Q' S2 l$ N( A7 C

1 A. p3 _# {% j( r+ ?+ w) d. e
. z! o: `  f: ]0 g$ J$ [5 c# n* s( s! [1 u, T: @! o

+ b/ g4 L" x7 y; t5 n& h" b% G. F
回复

使用道具 举报

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

本版积分规则

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

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

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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