飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

986

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
986
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php7 F; m& j) W9 Q" @' Q' M! [/ K
function Connect () {) e( E3 M/ d2 G
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
3 X1 O7 o3 c( q4 O$ ?8 q/ M6 a
Failed.');
2 j3 u  i, V, P* G( }4 G}* W4 F3 K" @9 ~5 ?; N
Connect();6 j* F" v- n! q  {3 c' A7 o
2 o5 l. }% w- ^
function InitForm(){
. w. f; E4 ~8 ]//layout for the form& k9 N% ^# M* }2 ]4 }
echo "<strong>Send Items.</strong>5 _- _6 |4 H% i, Q: A: X0 j4 D( w6 j
<form name='select' method='post'>5 Q1 f7 P) R5 u* W, i+ w
<lable>Character Name</lable><br/>3 u$ I' F* v# M9 t$ _" F" Q
<input type='text' name='char'/><br/>
: s( J( l; ~3 s5 U7 d" B: ^8 L<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>( C- |7 Z0 H& P) j1 y
<input type='text' name='item_name'/><br/>
/ U+ L) e1 p( B" M# Z# j0 H<lable>Item Amount</lable><br/>
4 S. n6 S" ^2 n& t0 V# s% d<input type='text' name='item_amount'/><br/># j! z9 u1 |% N7 F5 n: u
<lable>Item Upgrade Amount</lable><br/>
$ r3 ~/ E% _4 h* Y6 P; @: F<input type='text' name='item_upgrade'/><br/>
* S. n4 g* T# P4 C<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)& S/ A. _/ ]9 }; Y7 m$ e

# I: {1 `( J, f- e. l</lable><br/>( s+ q7 h5 k; p7 u& N$ R$ {2 c
<input type='text' name='item_element'/><br/>& z, `' h( @' C, x5 I, J! b: J
<lable>Element Upgrade Amount</lable><br/>
) A% [$ S) N! A9 M9 N9 B- E4 M<input type='text' name='element_upgrade'/><br/>0 d. g5 w, w& i- [: R+ d
<lable>Pierced Amount</lable><br/>& @  w$ F+ L2 w  \* q- Q: T
<input type='text' name='item_pierce'/><br/>
7 L0 W- u7 p* _" F4 O& B<input type='submit'/>
" d; w  B1 u" h* M0 q  s. {3 z</form>";8 b& B& t% Q( Z, P3 \# y3 k; G6 ^* L
}  n. j& P  A; B+ Z& x; x5 T
& K9 X$ e# i1 O! M* _
function PostListener (){
- D. ?; r: R3 U5 ^% u( i- |9 ]5 e9 _//Add more post variables if needed and add them to initform() function aswell
' d* t; l7 q  j; B8 i
  A+ }1 ?! x: O0 d* n################################* z% b5 F7 L5 Y! N7 H8 j
##### Connection and Post ######( `( |6 }. y' s- Y, Y5 J
################################
1 Y; Q5 U" f$ F! S: v: ]2 Q+ |$name = @$_POST['char'];
3 r; O5 C8 k  H( Z: q# b9 a$ItemName = @$_POST['item_name'];4 f( c$ Z! t( O+ x2 t! l* q+ I
$ItemAmount = @$_POST['item_amount'];# r0 e! D8 j% G* m4 @8 ^% n
$ItemId = @$_POST['item_id'];
3 t8 e" r. ]( X0 k* q0 J; W% o$ItemUpgrade = @$_POST['item_upgrade'];2 o3 q, r/ H1 Z" E7 J! @0 a
$ItemElement = @$_POST['item_element'];; F# X# r8 ^$ g- Y/ g+ S# ^, Z7 Q0 `7 e
$ElementUpgrade = @$_POST['element_upgrade'];
( r) \; z' m/ |) z$ItemPierce = @$_POST['item_pierce'];6 B& O" H% ^6 u$ [
################################
) Q4 Z: g; ~; @( w
: d; j+ `3 E5 f/ m/ I% g9 I% {//Check both variables for empty value
/ R4 `( o" t5 y+ B2 e6 P% ~# j8 c7 [+ h: W  Y
if (!empty($_POST['char'])){
4 m" Y9 g# [- v- _$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 0 j9 t  \+ d* \! E

5 O" _" a/ Q2 q7 F: J+ Nm_szName = '{$name}'");5 o; S1 I6 u2 r* a9 }- I9 H
while ($row = mssql_fetch_object($find)){: K7 i6 R# Q% p2 |2 ]  y
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
7 H5 ~. ^+ q4 `4 m7 t7 y5 s( U$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 7 X, o2 W2 |7 C- c9 ]
. K% _* k, V% ]
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], $ @& |6 T) }1 G1 z

$ v+ p! F# @% m7 g! U, J[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', - @2 x) ~6 ?6 N2 I$ e) K2 H* h

* v, o" D3 P' e2 P) SN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', * j' V; T3 h; m6 }* c: ?
7 d  Z5 O- k8 O( q
'{$ElementUpgrade}', '{$ItemPierce}');");
) \3 u( \* ?3 k* d' _. Q' z}9 f2 d! B2 s4 i2 U3 h4 F
+ @  B; a2 P4 U) j* ~+ M
}
4 W, A3 _7 o: L( D1 Q# K# Z1 c* N$ p6 R& U" w
}
( q; r% y3 _. x" ~2 \
. x4 M& p; J) ^" @7 i( e$InitForm = InitForm();$ g# m1 x# |0 O' y8 e+ h
$Listener = PostListener();, c- |9 F7 i; @

8 P1 G* r8 d  c, a  F( t?>
; d- B0 {/ R* E- G
) A3 a! J! D5 p/ v, Z, E  [4 q0 F; p0 K& t8 _

; H% a+ x( Z) b% V
1 @, y+ r% C/ [# q1 ~) v
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2024-6-26 10:31 , Processed in 0.062796 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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