飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php* l1 Y4 S, Y4 a+ I( Q! [5 |
function Connect () {
( l" B: H. y0 I+ \mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
: Q5 m. z7 [  ~! ^. Y9 `
; L) z8 L. f6 Q" H4 w7 CFailed.');
4 `, @9 c/ Y+ V$ Y}) C9 P6 A+ l. y: I" t3 V' l
Connect();
, j5 U! J& p8 s1 p9 V. T3 y* k2 j) P* [$ h# w
function InitForm(){  g! |+ ~% t, @6 b+ S' ^
//layout for the form
" k. j( i; ~, F! ?- V6 O2 eecho "<strong>Send Items.</strong>  ~2 ~( @: {& Y7 b0 d1 j
<form name='select' method='post'>
( Q' L. y) |3 v. J7 B* H  ]. D" a<lable>Character Name</lable><br/>
4 S- Y: j% V6 r& s& q<input type='text' name='char'/><br/>, ]) H$ h- G+ y2 ?, `
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
& A* d# Z& m1 r! ]<input type='text' name='item_name'/><br/>
4 y# n9 `; {; I$ @' C& C- m<lable>Item Amount</lable><br/>
" @! n/ b: I* Q+ p<input type='text' name='item_amount'/><br/>
2 Y% |8 u$ g0 M' P6 U<lable>Item Upgrade Amount</lable><br/>2 B1 ]* |1 b9 j% S+ o
<input type='text' name='item_upgrade'/><br/>' @$ e3 H! Z) u6 X2 M9 J/ z
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
, k6 E8 w* h1 r2 ]8 _3 y) D- e1 @  V! H2 Z( V
</lable><br/>, t2 Y; K. f3 n1 k
<input type='text' name='item_element'/><br/>/ E9 C$ H& P5 z, q4 |" I
<lable>Element Upgrade Amount</lable><br/>5 K6 D( V1 q9 P+ X; m$ g, a9 ~
<input type='text' name='element_upgrade'/><br/>
* f$ v8 h8 i1 n" L5 u8 t2 i+ ]/ p<lable>Pierced Amount</lable><br/>
9 \+ \/ @3 m, j4 h& j, i8 w) N4 W<input type='text' name='item_pierce'/><br/>" f( ~1 p9 r- j: _' t" B$ r! q( I
<input type='submit'/>
$ X3 B% R1 R4 ]+ E+ Q/ F; |1 X2 q</form>";/ v  w8 \) W2 \% ?& c
}+ x- g* w2 A( }$ J$ x% ~

- x% g1 T% m% M' afunction PostListener (){
, J( c) R, ?* M& J//Add more post variables if needed and add them to initform() function aswell9 ]2 T( x8 h+ x( n0 c' u0 ~
" u3 K! s' h: U: b  o* m1 D% F
################################
1 a& S0 [$ Q* M* a* O, _7 I##### Connection and Post ######7 B: |( t# S8 j
################################
8 S8 G& v0 C  h- }- M, J3 H9 S$name = @$_POST['char'];4 S' C# k" r4 ?+ h" @, c
$ItemName = @$_POST['item_name'];
) a; @& o! q. F# W0 H4 ^$ItemAmount = @$_POST['item_amount'];  e- e) g+ U, w# [! ~* F
$ItemId = @$_POST['item_id'];
- Z# z4 o  d% A" x( ]% i$ItemUpgrade = @$_POST['item_upgrade'];
4 O) D5 s: Q' {* M* u$ItemElement = @$_POST['item_element'];
, j  O  y2 Q! E; y$ElementUpgrade = @$_POST['element_upgrade'];) ~' p( I2 C  X2 [& d6 i! h3 D
$ItemPierce = @$_POST['item_pierce'];
6 K0 \, d+ b/ G, t) J3 ]& ^################################/ G! @$ S! K+ J' k+ M) ~

% T$ u3 P$ d1 n) ?' A8 k0 b! J//Check both variables for empty value; y3 T4 U, _3 K! ^9 X

6 I' c, b! g7 `  d0 Z% Mif (!empty($_POST['char'])){# B5 z  w+ I3 p3 D6 g: O7 ^% x
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
3 W+ X( r* R- y- c7 D% K+ T/ @% ]# {6 N" f0 S% W
m_szName = '{$name}'");3 \& V6 r5 [2 C
while ($row = mssql_fetch_object($find)){
& g( Q: c; h. _0 lecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";: {4 \" D/ c: S1 K! G# C, j
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 0 ^& T$ K3 i; H0 z- K

- L" c; i6 k0 P" _[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
: S" e" u: l4 O7 O) T1 P% ]
3 X  F1 ^3 l5 ^* r/ H2 t[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% z% ?: b) i" J+ H
6 j* P; z) {% t" VN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ! c8 q& j0 m1 j: S7 M
. s, ?, c3 H2 K1 H
'{$ElementUpgrade}', '{$ItemPierce}');");( [, U* N- g9 F( F6 H; m1 V" [3 o
}, O; Y- E" U( [  ~1 U( e

% u3 z! i( \$ a; t0 @) ]# H% [}) Y8 X" F% }. c; u+ l5 |4 I, Q

* k" N* M. |; X1 k8 s}$ `2 o' y, L+ s  y- Q7 I" J& g

8 `5 p% A/ b% e: b$InitForm = InitForm();
3 k, C. I  t( Q5 ]$Listener = PostListener();
# M' m  `. O8 ^: O( ]5 B
$ I. ]. g2 f% C! s?>
  R6 o. h# r( g$ [( |6 c+ e2 h" W" R/ @: Q9 D7 E, \* R
7 ~& X2 B5 r& k( F0 G! p4 F- Y. L

. m+ f7 p4 s+ m  R" L4 D
- V; P' p$ I: \& G" v) v  ]* p3 W% `
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-30 02:16 , Processed in 0.057597 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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