飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
( S# C3 g# U* r2 _. `8 Y) J% Pfunction Connect () {4 y; D; v4 {- T! E
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
" \/ B5 n" a( X' O1 a! E) N) f+ ^8 L, {2 V9 n! o
Failed.');
, B/ b: J1 j6 F5 W}
6 M, y! f' G$ s( m! XConnect();; S3 F1 D6 d5 \. o& r0 ~
2 |% n6 F, K2 W- a
function InitForm(){
, F1 R3 U8 }+ h! X( b! `* y//layout for the form
, D+ i1 f+ j* e8 E" L5 I' u) ?% Iecho "<strong>Send Items.</strong>
. @" D5 j9 l8 l% I# C: V* O2 M<form name='select' method='post'>- I' ]% b, j7 ?& f5 V& Q
<lable>Character Name</lable><br/>7 q( T1 L1 Z8 b; i# j
<input type='text' name='char'/><br/># _+ I- h" F6 z* t  J4 [! K  u
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>+ o& |4 S1 C( ^$ D2 E8 J! ]  _
<input type='text' name='item_name'/><br/>  G. j0 x" J2 d* j# D: g# N! k
<lable>Item Amount</lable><br/>, v3 N# B( n( P/ u
<input type='text' name='item_amount'/><br/>
" i, q0 O& _& w3 i$ a<lable>Item Upgrade Amount</lable><br/># t* N- t5 W3 @4 F$ z
<input type='text' name='item_upgrade'/><br/>6 `9 x; j- l4 l& V5 H5 E3 a
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
- i; X5 u5 u  K$ e2 R! ]. S  g
, M* e# M# O0 n</lable><br/>
: O/ r3 A  `6 r<input type='text' name='item_element'/><br/>
7 _7 C/ \- F! V! o; a<lable>Element Upgrade Amount</lable><br/>
2 N0 Z2 B/ U4 A/ l6 @; \<input type='text' name='element_upgrade'/><br/>0 H* z' Z  d7 [: C, E$ G: |
<lable>Pierced Amount</lable><br/>
4 ^9 l/ h) T' J* C1 [<input type='text' name='item_pierce'/><br/>
* p- g) |9 ^* I8 d! w" F8 @<input type='submit'/>
) N* @& ^. z- T: H: x' c0 C</form>";4 o% k7 X7 R7 @1 t" K
}
; k4 \$ {% {* w) `
& Q: I6 s: J8 F& dfunction PostListener (){
! ~" K' E" z. f//Add more post variables if needed and add them to initform() function aswell
! }* c4 x# ]5 k9 v9 l* F# o* Z- H* A& x, H3 @
################################
( e5 l- B) I& l; P/ S5 }/ C( Q) u##### Connection and Post ######
: u8 }1 l  f$ y/ l1 T. y  ?################################& J7 d. |7 K" x. g# l. s
$name = @$_POST['char'];. w0 Y2 c; c$ R. P, _- K
$ItemName = @$_POST['item_name'];2 a# \0 \8 e6 F. d; c0 D. @
$ItemAmount = @$_POST['item_amount'];
- f) t; j: k* }# o/ y$ItemId = @$_POST['item_id'];
- I5 m8 r3 n! U6 ^5 o  \" U$ItemUpgrade = @$_POST['item_upgrade'];
6 w( x( ~0 w& }( L+ X$ItemElement = @$_POST['item_element'];4 {1 `& _, Z# y# w. Q4 u  D9 ?
$ElementUpgrade = @$_POST['element_upgrade'];! G' @8 f# X* t0 r9 Z9 q6 _2 I
$ItemPierce = @$_POST['item_pierce'];
/ j7 I) J  I9 g4 D' p################################
0 l6 z2 f7 L5 C5 u! x3 E! h* w6 X) F( m6 U+ G
//Check both variables for empty value9 d7 S# v8 r: L0 V$ h3 E( K

' }/ F+ Y, r8 R6 ]( [if (!empty($_POST['char'])){
$ f% ?' l$ \$ J$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
3 }1 v- U; d8 F% j+ f+ n) I* g6 ?) U; k' r% d  \( g
m_szName = '{$name}'");# K4 z( U3 J! P9 r+ O* M0 D% G
while ($row = mssql_fetch_object($find)){4 T, {/ k: _* e4 ]
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
9 L1 P- c: ?, [" P$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
8 c# O0 E8 C5 p, R  s; v6 m& ^0 R3 b8 U, @
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 4 |& n4 \% P9 S. V3 `7 d; ]

  l# F/ Y# u: |[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', / l, p7 ?! J; x" t* _8 }1 p8 t2 j

* o0 }* a2 y& _" u* N5 D: [/ mN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
$ E! q+ N" t8 z' Y
8 U/ v. R8 o6 y! N'{$ElementUpgrade}', '{$ItemPierce}');");
' {  l9 r1 q8 N/ L; e1 V}( r1 S9 J/ A0 R+ ]) ]) k- g. h* N8 u

* H$ F" k( T4 R9 h' g$ j  E3 j  d}! I& {5 b+ h3 H% F# ^

& l1 B6 j% u) l# s+ q}
3 u) r0 D8 t+ H- g  f& i8 y6 V, G
4 T( i( \9 N/ ?, w" p# x; X$InitForm = InitForm();
2 j" d: l) P- o. ]/ ]$ H3 `( E/ o; m4 u$Listener = PostListener();7 }9 z% f/ {, M  ^

6 D6 q3 t( Z, o' o" A% O?># e8 F% `2 k8 w: G6 M1 R. L* [

# O3 g, X2 T# t! l' K# P& M: |0 A9 P/ h: B2 q1 x! W  c; O/ I

& }* O) e2 n: w
) `8 X! x% F* h& U5 P  f
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-11-24 18:23 , Processed in 0.062009 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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