飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
8 R7 D; v! S& D, mfunction Connect () {# }5 j9 h- ~; m7 n
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 2 }7 k6 V7 H1 G2 W  C

/ ]3 s. c9 Z3 Z1 T8 K" q* A1 V& d' tFailed.');8 N  J$ d. r+ ?' y( h
}/ x; t/ g4 ]( {7 t9 C0 U& ^
Connect();
0 k( L+ Z6 Y. B* m: s- O* n& B+ H! G4 c) M' a
function InitForm(){
: S* X, O8 j2 F+ U8 F//layout for the form4 S9 D( S9 R9 q3 I" U' q. l
echo "<strong>Send Items.</strong>
  U: s0 L* s) g8 t0 ~2 N- j<form name='select' method='post'>
( J4 \$ {7 _& P6 ~# E<lable>Character Name</lable><br/>
( t) l  X3 I( b  a# f2 {<input type='text' name='char'/><br/># c5 e1 I! W7 P0 k
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>( [, B3 N! Q4 j: K4 d/ l$ N
<input type='text' name='item_name'/><br/>
9 i% I) b- Z' K7 z0 M<lable>Item Amount</lable><br/>
) Y1 u1 X. [4 X9 S9 O" N0 f<input type='text' name='item_amount'/><br/>
9 z) g# O) i9 u' r! u<lable>Item Upgrade Amount</lable><br/>$ d  t. `& r' }4 P/ b
<input type='text' name='item_upgrade'/><br/>
7 {% s( j2 [0 {- d' K<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
+ B* Y# _6 q3 e8 W" }
( Y/ A/ \/ @- G% h</lable><br/>  J1 f% @& n8 n2 i* N" C7 B  T
<input type='text' name='item_element'/><br/>
# }5 y" l  t$ U& b4 |9 |4 y" e<lable>Element Upgrade Amount</lable><br/>, N3 f+ Y  Q+ z9 @  M+ H
<input type='text' name='element_upgrade'/><br/>
* a9 Y, D6 T8 N, G<lable>Pierced Amount</lable><br/>  d! K6 T8 i" M4 ^
<input type='text' name='item_pierce'/><br/>
6 J8 S: q) P4 I3 ^7 H  ^<input type='submit'/>! M5 l: P& l6 ~: F' u4 I0 H2 ^5 `
</form>";
4 `7 m8 t/ q" X1 _( R}& v, V% Q) U9 _% R" M) E
8 q* }' Y- q; ^* G! C
function PostListener (){, Q0 d8 ]/ I/ b% l
//Add more post variables if needed and add them to initform() function aswell
, C3 Q( O  y" n4 ?+ l; @: T8 \% o! o! b
################################0 m+ U) M. i  ~1 ~7 S: e0 Q8 ]! n
##### Connection and Post ######  X8 g! V# L4 I
################################+ n2 G' [$ ?0 X* M& I
$name = @$_POST['char'];* e3 m! s. }0 u' a# {
$ItemName = @$_POST['item_name'];
6 q$ L6 Z* r$ e& `2 a" U8 V8 u$ItemAmount = @$_POST['item_amount'];
2 s& h! d( E6 K% D5 l0 M! G5 \( V2 V$ItemId = @$_POST['item_id'];
9 z: z& |" L1 e$ItemUpgrade = @$_POST['item_upgrade'];
0 o7 P) _% b, I$ v! g, k; k" I$ItemElement = @$_POST['item_element'];4 ~) P, R  V3 p1 E& T8 J
$ElementUpgrade = @$_POST['element_upgrade'];2 A3 U, b  u2 Z$ Y% [8 l
$ItemPierce = @$_POST['item_pierce'];% y) @) c" Z1 O- l1 `: D; m
################################
# }' k# Y5 j' E' y# O# a1 R
. O/ ?# J! ?/ A0 r//Check both variables for empty value
6 a, ]7 y* c" l3 K/ v! s9 n" M; [' f. a  {$ _1 W
if (!empty($_POST['char'])){
/ E- `& l0 S& V# [, O& z2 Z9 g$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
4 a8 @) U; `* m; L) t8 E* Z$ a" t& i7 u8 v6 N. H. K
m_szName = '{$name}'");# t3 q3 {8 V: I& `7 j" p
while ($row = mssql_fetch_object($find)){$ A; e6 P+ ]" o6 N8 n
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
( f$ S+ Q. O& {$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ; z' N. K5 o+ z

, c3 C$ J, D  _[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
7 C: T. T. b/ o+ ?
2 p6 h: s0 o  B/ C6 p: [  U0 W( R; L[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 6 g. D9 @3 E, M- u, |6 k
  X7 P* ]' z) O
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', . g: ]$ X, S9 K5 K+ Y; G

8 H2 O8 L9 T  Q'{$ElementUpgrade}', '{$ItemPierce}');");8 b# _& W( S  Z# T
}
6 g9 A( P8 S. h' x* Y" V1 Y
* ~" G- o' d# ]1 l" n( ?}+ t; \9 x6 @: }" `; Z
4 G- ?; W8 X3 C
}
1 f; \# A1 R- M# `
6 K! d* h% O$ j+ z. c! m% i; C$InitForm = InitForm();
3 ^( h) s* t5 U$ z$Listener = PostListener();
* o3 I4 O' M( t1 b( G( M4 }& ?
3 g! H1 ?- S- U8 n' f+ u?>
" o( W/ `  l& T# i+ Y$ g2 p/ R* I7 Y7 S8 A

( @2 |7 l8 p2 k5 _% o* z
7 a0 [% O% q5 e4 |7 H# ^( O
5 r6 ^- l! B1 U$ o1 y
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-11-25 23:58 , Processed in 0.065256 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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