飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
, q" G: n9 z/ G5 W. _function Connect () {+ T) t$ L( X' M: F5 H
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
! f6 {: k, e- Q9 G4 ^: t2 Y2 P1 M8 P% E5 L
Failed.');
% M: I% k0 R% J}
* i2 i: m" f* {( \Connect();8 t3 r  _- o2 f% {& p) E2 S9 T

4 q5 f% s1 |; \8 ifunction InitForm(){
7 E) x8 V$ U, P" Q//layout for the form
" M" r* u8 R! L4 ]2 ~) Z- Techo "<strong>Send Items.</strong>+ m4 ^4 d7 i) `+ Q, S* o
<form name='select' method='post'>! @: b( O) j4 j3 E
<lable>Character Name</lable><br/>0 ~! k7 Z/ O; Q4 @
<input type='text' name='char'/><br/>6 P' p8 ~/ L5 j% }
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>1 G5 D0 C2 _: z: x* Z
<input type='text' name='item_name'/><br/>" R+ L2 j' }- A) f$ i& N
<lable>Item Amount</lable><br/>: G7 O( N6 ?' m2 s( }1 P
<input type='text' name='item_amount'/><br/>4 t! F9 T9 h( @( r7 N
<lable>Item Upgrade Amount</lable><br/>5 o3 a; S) f! C0 y( E. ?) x) e
<input type='text' name='item_upgrade'/><br/>( W, {6 }& a" @. Q) m7 |# H: U
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)4 Y) N! U" m# }& i. C! ^

  c/ N7 U" C1 L</lable><br/>
2 ]. v$ i( x4 G2 t, i<input type='text' name='item_element'/><br/># v* j2 T$ D1 R8 K: f- ]: u3 M% ?/ S. v
<lable>Element Upgrade Amount</lable><br/>
4 V7 c) U' W+ |5 {<input type='text' name='element_upgrade'/><br/>
7 ]+ `3 B! Y6 S8 v* X<lable>Pierced Amount</lable><br/>+ @9 p, w$ k+ j( x0 t9 h: n9 V1 k& Q
<input type='text' name='item_pierce'/><br/>
- T1 S- j1 x6 ]- [' a/ s; ^<input type='submit'/>& P. l% C, ^' N- K
</form>";
: x, n5 R/ p9 i}
/ ?: f- s; e" O8 v
1 P- R# \3 c$ r  }( h0 e- Gfunction PostListener (){& q9 [6 a4 J& G
//Add more post variables if needed and add them to initform() function aswell2 D) j. z3 m. J
0 K  A- Y3 D! h9 ?5 @3 j, ~
################################# N) Z: j& ?$ z* W- l
##### Connection and Post ######. J! z" M( L( J9 F5 B3 R% l) ~
################################
7 l. b2 n) g; K! A/ n$name = @$_POST['char'];6 S( e2 A! i! g* z5 d. e
$ItemName = @$_POST['item_name'];  x& E4 [  f6 r7 X4 V0 `1 f
$ItemAmount = @$_POST['item_amount'];
) D4 _( s9 W; o: c$ D+ v$ItemId = @$_POST['item_id'];
! V7 J  O, y! b% V6 e$ItemUpgrade = @$_POST['item_upgrade'];
9 \+ M' U% T3 J; t& n9 ^$ItemElement = @$_POST['item_element'];
/ b: z$ @$ T# J: }" W+ N* s/ ?$ElementUpgrade = @$_POST['element_upgrade'];
9 a8 L8 ]/ F+ B) }* z2 j; A0 _$ItemPierce = @$_POST['item_pierce'];) R5 s/ g3 R: u0 h( a
################################
* P8 d& i  X# Q) D) d! {# z$ @' y$ B: ^) r& M5 f! p; e
//Check both variables for empty value8 p. \4 r5 m  F$ I4 \
) s) O/ g- A6 r; k: C" n& ^
if (!empty($_POST['char'])){1 U6 G7 O! N" t) b% k
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
+ V) F0 ]& N- M- ^
  z0 a8 R: b7 c. ?* v6 m3 R. im_szName = '{$name}'");
# E$ |% @! X6 U6 O8 x9 t, Zwhile ($row = mssql_fetch_object($find)){* }2 C0 a8 F+ j9 p/ m
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";2 `" I* a9 g* T( [5 S3 s
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 7 j! P* c2 Y/ w3 g* H

. s; I1 [( f# Y: X% m[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
/ U8 K1 y/ h7 j
( C9 I+ p# H. t% g+ ]$ J[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', ; ~0 M( q9 d! C2 X3 q

& t- j$ r- H2 y) UN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 0 G- y  F" _3 \8 a. G2 N% E, X1 D

1 X, Z. K4 U. b& L% X) x7 @  t( ]5 o'{$ElementUpgrade}', '{$ItemPierce}');");
2 b) Z3 b( b$ E" z0 E}$ K2 Q4 J- q" H$ s# ~

7 Y1 O! k( u0 K* S4 R( z}
3 l  H3 L$ b9 C/ d( S% {$ A3 M
; f% b2 O2 c+ w$ U+ ^2 I}
, ?& q: H' ^4 S* v; W5 e
9 g' O) v# u# M! z9 X) `$InitForm = InitForm();
1 Q2 A: j3 R4 i+ Z$Listener = PostListener();! O; |2 D3 O$ d4 w0 ?1 e5 Y

8 l  v+ }! G- a5 N?>2 k1 P  M) k" H" ]
  O; ^& R# J! i) s5 e5 Q* j1 C
( _7 X5 H4 p8 P
( d9 R- \! P& d9 o+ g
# M" \/ C! X1 D
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-11 20:11 , Processed in 0.060073 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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