飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
' |  L- |* _% R- E  rfunction Connect () {9 Q6 G" a) R% E2 r
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB * u- c/ W) [. A: e* @  s

7 T9 }6 |6 `# J" o  o6 r( EFailed.');3 E+ B7 R5 T3 T1 ^- A8 [
}+ I, ?( r1 H1 b! Y! X; B6 ~2 {
Connect();
+ v1 t. d% _8 {( Y
3 N! f, A4 l: c, J9 Pfunction InitForm(){
. I/ {7 K5 _$ U) h3 {4 \! D% k//layout for the form% @# U! o5 a2 N1 q% p- x" _
echo "<strong>Send Items.</strong>
8 w  G& C( k- K<form name='select' method='post'>" o4 B  T% s# \* _6 c
<lable>Character Name</lable><br/>9 Z( N5 E2 W* d1 g
<input type='text' name='char'/><br/>
) \+ A! V' C2 w2 L9 }7 |0 o<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>4 Y1 c. j8 n7 L4 q* F
<input type='text' name='item_name'/><br/>3 c5 q; k/ f; G( c3 p% }  C
<lable>Item Amount</lable><br/>" `- N) `# v) ^4 [4 y/ \9 a6 x
<input type='text' name='item_amount'/><br/>9 B0 k& V: i4 P+ |
<lable>Item Upgrade Amount</lable><br/>1 ^0 p6 S( b( j/ p
<input type='text' name='item_upgrade'/><br/>$ I3 l1 ~3 n# \$ S
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)8 s; s/ R# [, _" g2 @

# {: N: {; j& L  Y2 G</lable><br/>; q* X- T: E/ q: Y
<input type='text' name='item_element'/><br/>$ n" |, g3 f1 s) [2 t9 v. K
<lable>Element Upgrade Amount</lable><br/>
9 w8 L! e; v  E% x( ^( ]<input type='text' name='element_upgrade'/><br/>6 c) L3 ]9 ^+ l
<lable>Pierced Amount</lable><br/>& a( t: N3 v5 B, T5 N% m5 p" e
<input type='text' name='item_pierce'/><br/>( y! i& b8 Q9 O/ \* i, Q2 m
<input type='submit'/>3 J( S  G$ r0 K5 h% x
</form>";6 a1 I4 a; o9 X5 B
}
: f3 V$ w1 e* m+ _1 C! [) ~  F7 t9 U) `6 D: N. R' `) b
function PostListener (){( K; q( Z- Q+ V3 r% j
//Add more post variables if needed and add them to initform() function aswell; r! `; s0 t8 A9 F8 [

. \% }$ R/ {0 y/ S3 B+ n+ ?################################1 H( {4 e# t; Q0 v
##### Connection and Post ######
& x' C: V* l; J# z2 [- i################################& P9 D: S- Z- L; n8 Q' A
$name = @$_POST['char'];
% u7 f9 ^  k% U$ItemName = @$_POST['item_name'];
* p" _' H5 A1 @. B. W3 s7 g- v3 S$ItemAmount = @$_POST['item_amount'];% q  W8 ]" K: I* ?; r! e) k* o
$ItemId = @$_POST['item_id'];8 Y, a: @$ T3 P' t6 U
$ItemUpgrade = @$_POST['item_upgrade'];) X" I: {/ _& [) ?) d4 \8 ^3 w
$ItemElement = @$_POST['item_element'];
$ A' b# |' E2 h+ O" s  d, L6 k$ElementUpgrade = @$_POST['element_upgrade'];
" H: u: V2 Y8 |' R( \$ItemPierce = @$_POST['item_pierce'];
5 R. C( [6 [! E5 W################################
5 B$ b+ Y6 ?/ d0 T8 a. O6 D! I! J6 _- C+ V# |, _- e
//Check both variables for empty value
" H/ B# a+ i, }% S+ `4 G
* k( S& Y7 r* ^  Y0 [4 N, O0 {if (!empty($_POST['char'])){
# V" d3 ]- p- [7 I$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 6 G* V' U% O. D
/ H0 `& p9 b7 L( l* O, C
m_szName = '{$name}'");1 ~3 ~, f8 ?1 r0 A9 p- I
while ($row = mssql_fetch_object($find)){5 ]1 P0 ]$ R' c& }1 v
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
) B7 d' R" ^- ?7 {9 `$ ^$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ) g7 H$ g& o: p# d& n; ?

/ I( |2 }/ t8 C9 \3 u* R/ K1 o[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ; Z0 \1 ~0 |4 e! M
5 K1 r, N+ |& u' J
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ; \; D/ u* u. K  s; ]
0 H7 C0 O9 i, {! y* v
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 9 E: d. x$ W6 E; Y

* W, A9 s6 P$ b5 X, O. K! M'{$ElementUpgrade}', '{$ItemPierce}');");1 S. ?4 G+ d  ~, Y4 b8 X9 \
}2 W) a& [! D6 Q

2 \) g! l: N/ L( E}9 w) o8 l8 \3 [* U

1 T# b( T" E* c% [8 I}
+ Z5 b" \* V# L2 \* I  ~/ R& O5 O/ A0 L5 J; o
+ D7 [* J; D. b4 Q2 @, F8 U) @$InitForm = InitForm();5 ^5 ^8 v3 d4 _: C" D( A
$Listener = PostListener();% `# a9 g+ `0 Z

/ V0 l% e+ C/ `, I, p?>2 \; r/ _& a8 t7 V8 i$ t

  m7 X3 Y# O# z4 t7 X1 x2 i4 j% C% T! r# Q5 `1 O" {6 [' _* `

% v; [4 J( E+ b. J' C5 q& k* L
8 l! T9 @/ W) [* N8 c$ m5 c& c! v
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-10 23:56 , Processed in 0.059761 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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