飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
1 }9 C4 `4 L4 N3 \" s, P. I4 Lfunction Connect () {
* [/ y- N1 N' Q$ bmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
$ Z" r$ f; [; k" b- J4 D, N+ m: a3 V1 @* R) K4 w; V+ q
Failed.');
0 c7 V- |: A3 V' F% o}8 Y* \- `3 n! G5 z4 \$ z$ g
Connect();
8 d4 H( C0 t( }
- j: Z. V( q/ g; }& ?function InitForm(){  k5 G* ?7 C  e' T, Z- ~$ c
//layout for the form. H. f/ b6 a# p0 _. l
echo "<strong>Send Items.</strong>
; g, H' E/ F% f0 H* A. T& a4 \<form name='select' method='post'>
' W- b( B! R* v( t, O# Z* w* y<lable>Character Name</lable><br/>7 d) E8 Q% W6 ^& S
<input type='text' name='char'/><br/>- a; e1 {9 O: f/ C
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
3 e& c% b! m! c% M" O5 |& c1 E% a; i<input type='text' name='item_name'/><br/>
5 q5 |6 J  y1 d$ s  w% k# ?<lable>Item Amount</lable><br/>
) \* F- B- t. q# ~% k<input type='text' name='item_amount'/><br/>) @  Q# P6 E% E1 F0 m3 U
<lable>Item Upgrade Amount</lable><br/>
  \" f  ]% y: W<input type='text' name='item_upgrade'/><br/>
, }+ v! P8 @1 Q& d) M* ]9 @<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)9 D6 v6 D- h5 g4 m! W& q
4 X( y, Q6 y1 @: j; k
</lable><br/>
/ U" _' P2 t- g8 }$ ~, z1 }* [<input type='text' name='item_element'/><br/>6 R7 w+ q& v3 i$ X" r) Y" V5 c
<lable>Element Upgrade Amount</lable><br/>
% {" c- n1 A; H* U" [3 e0 c" @<input type='text' name='element_upgrade'/><br/>
4 G* y, y) ^- a- D, y, Z  n( e<lable>Pierced Amount</lable><br/>* e+ C0 q6 i5 l
<input type='text' name='item_pierce'/><br/>
+ Y1 ]2 o* Y8 R4 ~; Z8 v<input type='submit'/>2 j" o% ^' Q% }. q
</form>";
9 a5 a! f2 r$ X% r$ l" q' I}5 R4 V* L& J. z! c. B( ^

' p! k9 D- }6 e& v2 _0 Zfunction PostListener (){
% T+ t1 `: |/ C+ H6 `- u//Add more post variables if needed and add them to initform() function aswell
! R* I) p0 t* W( B7 L% v0 X7 R
2 o) g6 j& q! A################################& T" i. H6 _* o: |0 y6 l4 c
##### Connection and Post ####### x' E1 m, v) c  v* |* c5 q
################################5 s, t" L: t5 k, S* S/ s, Q
$name = @$_POST['char'];+ T+ t: M9 m5 p/ ~
$ItemName = @$_POST['item_name'];
$ L. l! A: v, V7 j( p# O6 ]6 Z$ItemAmount = @$_POST['item_amount'];/ ^6 j( w; m+ d
$ItemId = @$_POST['item_id'];
4 ~$ @3 I( k+ y$ N3 y. e$ItemUpgrade = @$_POST['item_upgrade'];3 z, A1 I( p7 y! q" z7 F( k
$ItemElement = @$_POST['item_element'];" Y# V- J; K$ ^8 L. V0 `: O
$ElementUpgrade = @$_POST['element_upgrade'];
/ o* V3 ^. N/ a2 W/ R" Q$ItemPierce = @$_POST['item_pierce'];& H# c6 M( C2 \9 K; N
################################) I* E" V" z1 _' _$ O% O6 f

  X9 M: ~7 r$ u' |2 T//Check both variables for empty value
0 _0 M/ ?9 C0 x
# n+ v0 }! c3 q* B0 u6 H% Lif (!empty($_POST['char'])){* x9 f; Y1 w6 k" \2 S
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 1 x8 R; I8 {+ `. v+ E: C

5 D( n, M2 q& E9 I8 W; Em_szName = '{$name}'");
4 C! D' v5 f3 S& ^0 Mwhile ($row = mssql_fetch_object($find)){, i. Z5 v/ [9 X3 D; l' }
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";' q* F+ K& M7 u8 N! c$ [" w
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 7 b, ]$ A/ I! _4 ?; r- p% W

6 l5 F( z7 w4 h9 `/ f9 A[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 6 F0 p4 i- A+ K

" f* U! k$ b8 x$ z4 C7 s: y[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 5 E/ |  A! l$ d
6 Y! o& d/ s0 v% ^. l0 ~
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
+ s1 H5 y  F' k2 b) C
0 n) j! G, d8 T'{$ElementUpgrade}', '{$ItemPierce}');");
  ^9 W1 U+ v7 U8 F; |}
* U0 K8 u, p& Z" _" x6 b7 y' A2 S0 z9 m% c! _
}
* t* t0 n# B, a0 {" d# Y. g
% F& F$ F2 N) n7 U# `}
( b' G, T2 P4 k# M! W5 \0 ?) @" ?0 w2 G4 o+ X% [
$InitForm = InitForm();5 S$ H1 Q! H0 X' G' W) O& }
$Listener = PostListener();
4 g9 f8 c$ L0 C" |: e* ~( f' o- a4 G; h( E7 X0 H% N$ T# P2 z+ p
?>
( X) i- \4 {! \% |9 x
) R0 a. Q% a9 Y: n" H3 A( Q8 \6 e5 c. j9 Q' s0 A
- T+ S1 ~& M. w) U1 G8 E7 v( V
/ T5 [3 S+ e) ?  D2 q
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-5 14:04 , Processed in 0.059716 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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