飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php+ o, m1 {" a2 E& ?: W5 v* j, w
function Connect () {/ f2 x; N3 N- F7 T" I# K0 F
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
4 F' y5 J3 C. p/ ~8 L7 n) ]: [6 C8 l7 z; m* k7 d
Failed.');5 C1 e6 i. ~9 J  u- c
}! J5 T( k3 l6 R: S- s" \1 x( R
Connect();
& W5 `3 H6 U" {3 p& \
- r. x9 H& N+ w/ Nfunction InitForm(){9 |. [* @% V) X7 w( |: r5 M; K6 u
//layout for the form
9 f7 w- v! b/ ^8 Q! }, @) i# \echo "<strong>Send Items.</strong>
8 _! F7 G% V$ W. Y1 N4 y5 @; S<form name='select' method='post'>
- e2 w' a# d7 x: w& q8 V<lable>Character Name</lable><br/>
5 t+ ^" F2 w. F; L/ z8 F2 W<input type='text' name='char'/><br/>
  q, m! h, M8 `<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
, R: w3 i: ?; P  f" u9 R<input type='text' name='item_name'/><br/>
+ f8 j' @) P% S7 W<lable>Item Amount</lable><br/>6 i  x; @* i, E6 K% Q
<input type='text' name='item_amount'/><br/>' H9 C7 W# t' A: _1 w% w4 ]
<lable>Item Upgrade Amount</lable><br/>( }( F/ {$ }- ^, s
<input type='text' name='item_upgrade'/><br/>% @% o0 C5 q0 |) S' }
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; g3 O/ d9 t+ P, \* i
% }' S1 \+ J: R, o7 {1 b' p</lable><br/>  I- J- a; N( x( F) B
<input type='text' name='item_element'/><br/>7 a- I$ L7 G/ h. u0 m4 B3 }
<lable>Element Upgrade Amount</lable><br/>5 j% T  Q5 G1 y3 l( q
<input type='text' name='element_upgrade'/><br/>3 E; g1 _' j; f$ ]1 v: u5 K
<lable>Pierced Amount</lable><br/>0 ]& X0 n# k7 Z7 {+ k5 S
<input type='text' name='item_pierce'/><br/>2 M: C0 ]6 U- G9 }* J" D
<input type='submit'/>6 H1 z9 d, C# u2 o3 V
</form>";" Y9 f: b: H- y+ G0 [3 K
}/ X- c/ k# o0 y# M
7 A. Q9 x# F! S
function PostListener (){
% J/ y4 v  o$ Q+ A3 u5 j//Add more post variables if needed and add them to initform() function aswell& H2 `4 x# P, g; D. @

$ L- P  n3 k: J+ K. L1 A################################- v9 \, D7 J: }5 `
##### Connection and Post ######1 E- J- J8 ]3 R9 C1 I7 b+ O
################################
1 ^+ o# \; q; d$name = @$_POST['char'];  M& r1 R  ~2 h- ^1 A
$ItemName = @$_POST['item_name'];
+ [! V! p  N: j' i$ItemAmount = @$_POST['item_amount'];
# V9 g. X6 @9 L3 n$ItemId = @$_POST['item_id'];
% Y9 ?  {8 ]- |1 s( }3 B& o$ItemUpgrade = @$_POST['item_upgrade'];
9 ~) G" E( c% j; x( S% y3 a% c$ItemElement = @$_POST['item_element'];3 j8 s/ z% n! j) I; v
$ElementUpgrade = @$_POST['element_upgrade'];
2 ^5 A& O  S1 |4 I; e) |' S' d# `* {$ItemPierce = @$_POST['item_pierce'];
8 _7 P4 H# E! `2 u# l################################2 b1 y; z' s9 ^$ G2 U
& l$ U3 J$ Q6 q/ L1 V6 H, x
//Check both variables for empty value
  \1 x# S3 n& V. l& w' C- ], z4 j  o9 A  g, ~, `  S
if (!empty($_POST['char'])){
& l" s/ p2 W3 }% ]$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ; @: s, u, k0 o4 M/ W; g/ ]( H

4 k; x9 m, R& u, {) d8 o3 c+ sm_szName = '{$name}'");
: y0 [8 A% `' F! C7 a6 wwhile ($row = mssql_fetch_object($find)){& g0 J, Y1 ]% ~2 ^0 O
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";9 K' H" [5 R7 _3 `
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
, m  S3 J( X, K2 ^; V( o% [, e1 j6 E
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 5 B" g7 t4 _; J- ?2 N( n- e7 I; Q9 S

3 Z* A' K' @* R, l/ Z- s0 O* ?* I$ S[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 6 K7 @" i( _# I
# H" m! U$ l8 J6 T- u9 O
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
) x$ k: P. E8 M) i) H3 L* ?, w9 T3 z: R& c; c7 L1 C
'{$ElementUpgrade}', '{$ItemPierce}');");
) a/ [7 x* C# \, [3 b: V}" f0 q% N* F! g- W

% A7 G1 ~+ u) h" k( Z  L5 N9 b}3 _( _3 S# S9 f0 r8 i9 K8 A; r
- P. b( B# O6 G9 m% |
}
0 s9 h0 N+ t1 C# z! [" X/ L) y4 F2 H
$InitForm = InitForm();
4 [3 Q6 w4 A2 b' s+ N& w- W" W4 N+ k$Listener = PostListener();
+ f% B) N% I4 q2 {
( v* e6 o4 B, f( w: S. g% Q?>. s* c8 Q) W! D, {( M

6 s% W/ q4 c0 h% |' u+ ^
& V$ e! ]+ R6 D! Z5 q/ a2 u* [7 T2 |/ X, Z; n2 m- z% z

4 q8 w; q- j$ q  L8 ?2 h
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-19 21:12 , Processed in 0.063569 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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