飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1064

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1064
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |正序浏览 |阅读模式
<?php
" T. u" z- b) N# Nfunction Connect () {5 f7 Z+ h: G7 V6 L6 X
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB / e5 o+ M' N7 o9 `. b/ ]* a6 R! z
# Y, C8 q+ n- A% ?9 @( _
Failed.');
5 {3 x% I  B7 M6 M}: `3 i6 d: ]2 @
Connect();6 `$ v2 p* d' [, Y- `& e4 H3 r
3 @: |2 S1 r+ E
function InitForm(){
' a1 |+ A; a8 O  G% Z//layout for the form
* {0 h- u5 [) h% v6 J# U5 wecho "<strong>Send Items.</strong>$ W8 {7 P( U# q9 v* M
<form name='select' method='post'>
% _7 m* `& j) d( M& l# q# D<lable>Character Name</lable><br/>
. u5 `; H$ L1 B7 i5 u- @<input type='text' name='char'/><br/>
% F7 ?4 R: a% V0 X3 y3 s* D<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
. W7 K- l/ N5 v6 [' m# w1 T<input type='text' name='item_name'/><br/>
% ]. S4 X& `2 [+ s8 u$ z% ~2 L/ \<lable>Item Amount</lable><br/>
4 n7 L/ D# s4 ^5 u. Y9 ~; g/ t<input type='text' name='item_amount'/><br/>
% v/ h9 j# G3 F; b: q1 L* b<lable>Item Upgrade Amount</lable><br/>
$ ?" t" x0 z5 a  ]<input type='text' name='item_upgrade'/><br/>$ }+ }8 b* i5 ^% p) }  b
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.): z& D2 T' |0 n* A, ~# u2 L$ ?
) L0 b" p& [6 C) n
</lable><br/>/ ^/ Q. R  M! k* J$ `' J$ c
<input type='text' name='item_element'/><br/>2 r" M0 ^, }3 r) p' y' a# ^
<lable>Element Upgrade Amount</lable><br/>4 W+ q& l5 p  K) L7 s/ H( Q
<input type='text' name='element_upgrade'/><br/>
# K  s! j/ u4 t<lable>Pierced Amount</lable><br/>1 ^. W3 L; t, Q! \( D3 S" @
<input type='text' name='item_pierce'/><br/>8 v: _/ A5 z' A7 G1 \
<input type='submit'/>+ T: g7 m( p' P
</form>";
) m, z* X& C" o, E6 A& }/ l/ ]}$ S, p2 e: }  n% o! t; C
+ C; w& \$ ], J; h$ `+ i% `# w
function PostListener (){
2 r! p: S5 j. O//Add more post variables if needed and add them to initform() function aswell
% o0 N+ A, E1 G( b5 H- ?  y
; e& B0 y+ M- N5 `! L, [0 g################################
& T. N6 O$ A3 y##### Connection and Post ######8 P% K7 N5 P- t/ K# c
################################# a6 G$ s+ l8 k
$name = @$_POST['char'];' U/ g8 P* A4 E- D  m" k
$ItemName = @$_POST['item_name'];
5 D/ `6 W, T( l, h3 \6 x, e$ItemAmount = @$_POST['item_amount'];
% `  D, Y. g5 A. ]9 X$ItemId = @$_POST['item_id'];
% o! \# [% @6 r  Q* f/ S$ItemUpgrade = @$_POST['item_upgrade'];1 J* U( u" h8 c# x* g3 ^  b
$ItemElement = @$_POST['item_element'];. j( l& X/ ~4 a
$ElementUpgrade = @$_POST['element_upgrade'];. I* b. z) w& d, X! H4 i
$ItemPierce = @$_POST['item_pierce'];1 `: P7 }2 W! k1 `  R" k# s- V
################################
, p0 o1 B" n2 ^6 t; I3 b+ _
/ ]$ m7 L. f& Y- V//Check both variables for empty value- t9 A& P; o) y9 b, j# `9 F
+ |; t3 [; D# v
if (!empty($_POST['char'])){2 F( K( D, }2 ^" {9 b# a) z0 e
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
" V5 F: M1 N# c* n8 a$ W
4 z! a* ~3 N2 s+ S) v1 hm_szName = '{$name}'");! n  t5 `7 i! J- S
while ($row = mssql_fetch_object($find)){' \$ x" W. {7 H. S/ l
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";4 y7 [( A$ ~* K1 \' C3 C* t2 [# I
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 1 V! W! n+ J# ~3 K' Z

/ g6 S5 a! X2 L( D8 L  R[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], * Z! W2 M0 G% c% ^
" d# z! W/ _3 |' g4 M  j
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
. G8 X- Y1 p: I. j% S2 U: R
3 `0 _' _" Q; p. I& V+ Y1 J2 ?N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 9 {! Z& L! I1 t; b( ~- S/ P

# ]4 v. {% s" k' S2 S7 {'{$ElementUpgrade}', '{$ItemPierce}');");
% |3 B, x2 w' t& a+ c5 o}4 l) W* ]0 H( j7 L5 o

9 j7 f0 W" N5 `- p}
1 s0 ~$ M1 W, M: q3 {% m
- p, O0 m7 h5 P3 W  ~; q$ _}
7 B9 T% N7 L  f: @2 k
% v0 H  e; L6 N$ m5 {% ?' n$InitForm = InitForm();4 M7 U, k' }+ m( B, H. c/ L
$Listener = PostListener();& w9 _4 H" g2 h$ R- {
0 w1 L" l! @& S; P8 K
?>2 q# N9 k% s; X0 I! r3 t
1 {7 l  E0 M& s. E% n. l
: o8 i& P8 z' x/ w
1 X5 q" L- O2 H

5 j' z7 i4 P" y; A# e' X. g
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-6-7 13:54 , Processed in 0.065603 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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