飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php6 _1 ^+ T! X4 {% l  x
function Connect () {: E0 Q$ Y" K$ Z5 q: M, W) {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB . d! f' t( [2 _; A

+ p. I4 m3 Z: u5 G* SFailed.');
/ k9 q" V$ R" N4 u" _5 p0 V}
1 J" z8 {$ {* I% H, ], E% O' @Connect();
8 K# u, ~3 {+ \+ w; e0 g/ o  |: d! g
) S  V) W9 |" s1 Nfunction InitForm(){; \$ i  T9 c: x; _' w
//layout for the form2 V0 q: ~' Y: C
echo "<strong>Send Items.</strong>7 C" j; n) V# ?. F8 U
<form name='select' method='post'>, }. r0 f- x/ A3 r* m: \
<lable>Character Name</lable><br/>+ }( v4 L0 [  [( k" D; E1 U. r4 s% r
<input type='text' name='char'/><br/>! [' }# V' L9 k1 e+ w  O+ |; n# p+ T
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
' C' |% [) d8 q8 N7 h<input type='text' name='item_name'/><br/>
  g! Z+ s8 b( ^. k$ u! T<lable>Item Amount</lable><br/>
  k% P1 O2 X, ~8 `<input type='text' name='item_amount'/><br/>
) T( Y' g* h: S, [1 |+ [* X<lable>Item Upgrade Amount</lable><br/>
# L9 S. T& U# P<input type='text' name='item_upgrade'/><br/>. u& n' Y& ~1 M2 f4 z: b% E$ Z
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)6 V) x" r# a2 n( v+ v

) S" Y! o% c" {& C( P5 ]' O9 |</lable><br/>
3 O' U2 G5 Q( U<input type='text' name='item_element'/><br/>, {0 [8 _/ c: O- ]5 w
<lable>Element Upgrade Amount</lable><br/>" T0 ?- h4 P; z2 M5 K1 ^3 d+ }" `8 Q
<input type='text' name='element_upgrade'/><br/># w$ S# t9 ?8 \9 F
<lable>Pierced Amount</lable><br/>
# y) E0 j# K1 C0 w; t<input type='text' name='item_pierce'/><br/>2 b$ [* X$ X; j" u4 D
<input type='submit'/>& O1 Y/ N* E- q, h: U% n. n( T4 s0 {
</form>";
: E; X5 [* m- C5 E1 x$ ~) z}/ G2 W; p3 M5 J% d( V0 D0 u# m

! P8 @) k* f6 Z, ?/ a( a9 _1 Yfunction PostListener (){0 u$ k! _& e/ {" N% |% P' n' ?
//Add more post variables if needed and add them to initform() function aswell
' J) g- Y' V, |1 ~9 y  [3 E
' _8 F2 T. c- }+ E) c################################
# N) _& q3 T6 e; M- c% b# X##### Connection and Post ######
2 j5 d. q* w. Y3 b  y; ~################################
+ g: g& U. f+ d2 f$name = @$_POST['char'];
3 N& X0 c) Y2 Q+ \! k5 @: m5 b$ItemName = @$_POST['item_name'];4 W0 `  v' W( M  K2 P
$ItemAmount = @$_POST['item_amount'];
: |) F* z+ }; E2 P  l$ItemId = @$_POST['item_id'];
: o$ \. K- ]( t. x/ E- \$ItemUpgrade = @$_POST['item_upgrade'];+ Y  h) {& b, h
$ItemElement = @$_POST['item_element'];- C/ l2 T' N; w) {1 b
$ElementUpgrade = @$_POST['element_upgrade'];- _3 Q. J8 \6 I* {* f- K' `1 {$ z5 _; B3 p
$ItemPierce = @$_POST['item_pierce'];7 @6 b0 h) [& _/ _
################################
, S) A9 D6 r2 x) l4 ~: \+ F( v# A, N, k9 Q& g0 `
//Check both variables for empty value- Y# E8 j3 f4 g  {  N5 {4 ^; q
" ~" J# b4 }# q! k, U' b3 O
if (!empty($_POST['char'])){
) ]# O3 O& g% v/ H2 x5 n- {$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 5 `1 b9 K2 {+ m$ P
+ A- D3 t  r' j5 V* m4 j! @
m_szName = '{$name}'");
% K. R( v4 q2 V, Ywhile ($row = mssql_fetch_object($find)){: c2 }( c2 a( v7 L! m: ]
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
' y" q  U7 _* g& T. q" K1 s$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ( b8 B1 l7 E1 m6 K5 [
4 C: t* q8 Q' R* I
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], # w2 ?2 |" v+ \# n6 d( |

3 A7 o7 v( x% x% P3 C[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
9 D5 m) P& R6 R
) A8 ]% d' Q6 y' [$ v* I% _N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
1 Q5 L9 y8 }7 T3 _- m. |! X& x6 F9 d0 q7 ?
'{$ElementUpgrade}', '{$ItemPierce}');");; G+ r) U: u# T: C& r
}
, Z9 o: @6 R0 n" \# g8 I5 `/ T; r/ L; ~# Q, l; t  A& _0 F
}
( l+ x2 i8 [  k4 i* z
+ G5 J, u# _9 |0 {, b' Y6 r/ }! A}, |5 l, m% V+ |+ O
; Q; x# e$ D: V/ u" u- Q
$InitForm = InitForm();
+ u7 l) y) G- _6 l7 w$Listener = PostListener();5 x1 g( q+ i6 @

5 o/ ^% E+ ]% P+ u- E' E?>5 B) l& d' G) B" s/ F, J4 |
; C/ {; Y) N- K% H9 ]
" d1 Z7 N" j1 p6 V
8 z5 [6 ~' g. f. }
1 S: h; K% c1 u
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-9 14:11 , Processed in 0.065438 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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