飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1088

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1088
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
! Y8 z6 n% v0 _function Connect () {
9 B! w, r' I2 z, x- {7 ymssql_connect('Server','UserName','Password') or die('Error: Connection to DB ; U8 O3 I' j  m

, G1 {+ v( z# w) fFailed.');
6 F7 b3 n1 D4 R- m}
& l; T0 J& F  U2 }2 d! vConnect();
  e+ ~& u) C" P0 C! H3 i) Y" ]1 g. j& f: p7 x4 O
function InitForm(){
. O1 ?* h8 T# L- M//layout for the form% ]& P. q" s: A, u
echo "<strong>Send Items.</strong>
5 _9 X0 V  H6 q# W; M7 X<form name='select' method='post'>
- T; }* w# j0 i& B<lable>Character Name</lable><br/>* M5 C# A- E1 j9 a% m* x1 z
<input type='text' name='char'/><br/>
. L. h, K: f3 r$ j<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>" V  U# c9 j; L& w/ U
<input type='text' name='item_name'/><br/>
. V2 I- P) v# w/ J! x/ C! T7 {<lable>Item Amount</lable><br/>
/ E: X* S& ^6 I* K<input type='text' name='item_amount'/><br/>, U( e8 }0 y" {! s
<lable>Item Upgrade Amount</lable><br/>
7 A- H1 G0 N- ]  M<input type='text' name='item_upgrade'/><br/>
5 ~' T( `- J5 T- h/ f<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)7 Y$ v; m, n1 F: ?7 k- w" z
( x0 o$ a4 r% d8 T: B& H6 p7 S
</lable><br/>9 Q( I" E) w5 Y  S8 {
<input type='text' name='item_element'/><br/>5 o; [3 ?3 F- F5 B( c2 a
<lable>Element Upgrade Amount</lable><br/>
. b# Z3 |% |' @5 c% j" @4 F<input type='text' name='element_upgrade'/><br/>! [0 |1 D6 V) Y3 |) P" R
<lable>Pierced Amount</lable><br/>
6 N& m! y& F* Y, V9 s<input type='text' name='item_pierce'/><br/>& Y  z) m* E/ P( I# B
<input type='submit'/>
  w$ P, _' \$ ]4 ?# g& m</form>";
0 c2 n* c, h, `0 W( O8 G}
* j- ]2 ?0 }2 N/ e& Q3 E; l2 ^& C/ s6 a8 y* H6 M! _
function PostListener (){
  ^/ t" D( o4 M8 ~9 _//Add more post variables if needed and add them to initform() function aswell
" k9 k5 Z/ s2 T3 ^2 I7 c: Z- z# z9 ^3 }- r% {
################################
1 \6 n/ [3 f1 H2 P" W##### Connection and Post ######; z& M1 ?! B7 V2 x
################################6 }4 h, C+ G! `' w1 m
$name = @$_POST['char'];' P- B, k5 M+ b8 o0 @- q% r% ]
$ItemName = @$_POST['item_name'];& l, l2 x$ i6 b* Z0 L$ Q  w) j
$ItemAmount = @$_POST['item_amount'];
. ?! f6 u: v. @$ItemId = @$_POST['item_id'];7 c0 H5 H; o  W) s7 ^
$ItemUpgrade = @$_POST['item_upgrade'];
( n# \$ u. G, y. E! x3 {$ItemElement = @$_POST['item_element'];4 A, H5 o' T# X
$ElementUpgrade = @$_POST['element_upgrade'];; Q- m9 G' X7 |& B- M& q- Y
$ItemPierce = @$_POST['item_pierce'];
3 c0 K8 ~7 k% B) Z, V# N################################
& ^6 f0 n( F8 f$ ~0 g
4 r+ a2 V5 g9 {//Check both variables for empty value
1 [3 F2 y+ A. D" }- k- ?# |
5 [' }0 _' ^' h5 P0 W5 x7 oif (!empty($_POST['char'])){
% m& ]4 H& c  J+ t* R2 x" L$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where : M$ |% Q0 P) j# i7 A1 [
- Z3 w6 S! \* h7 x
m_szName = '{$name}'");; i; }  O8 u2 t* m5 s. [5 k
while ($row = mssql_fetch_object($find)){8 w' N& n3 r4 ]6 G
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
  ]( H/ p" ], P% f" @$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 6 g" N8 C6 E- H* z! B% s

4 h$ q* v/ x6 u% I[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 8 @+ ^; J- {% t
' W8 }7 O8 C4 R; Z  b7 a
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
8 I' Z1 {- [/ K( k7 ^% g. r: H/ D0 ~/ o8 g7 W
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
) A# }% p& r) F- {0 B* B8 w3 |- Z. S0 I$ o( }& a; @
'{$ElementUpgrade}', '{$ItemPierce}');");7 l! W$ M* L% @$ p" R+ V, ]8 T2 I4 U
}' r+ ~) I! @' E( d

" @# W3 E4 z& e( H}1 j6 a% [. z+ C7 y0 i5 ~4 H# b0 u8 w: v
. P6 w: M7 G8 ^
}, b/ [; p$ l* E, q0 u

  |+ s/ }$ `2 ?% x* w$InitForm = InitForm();
% @2 k3 b4 c" I$Listener = PostListener();
5 J" e+ m! w' X+ \. p( V' z
1 E' r! }% D- H8 U3 b* s0 s?>1 p2 \5 }# d# Y+ {
+ H7 D1 e0 U0 B1 q# l3 J. {

5 R6 j4 S6 r3 E. H/ t* V
- \% w3 g$ }# ?. g5 k7 `1 T- U; ~% g) _" Y' X3 J* e
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-23 08:43 , Processed in 0.059991 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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