飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
/ i& b0 G5 c; Qfunction Connect () {
, i* v! x" |: ?mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
( j$ c/ C! C6 t) n# g" a: C4 C, v8 ^( L, p! q3 c! R1 t
Failed.');( p: t' W% n* H0 ?
}( `' c' N1 S  u: m( H6 z
Connect();3 I, Z" G% r- r- |: s
3 H/ G6 Y3 E, A( y: |7 x
function InitForm(){! a8 T# W1 v' r- g
//layout for the form  H  I. t& c5 Y3 O' N- M
echo "<strong>Send Items.</strong>) N9 X0 t! P, G0 I. j9 m! m" H
<form name='select' method='post'>, i( ~7 h5 z2 N3 h2 q2 E4 K  k1 b
<lable>Character Name</lable><br/>
, x+ y) K9 p2 z  v<input type='text' name='char'/><br/>
3 F" j! O3 W+ b9 D. T+ @7 }<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
! o3 `' W2 `' S/ c' Y<input type='text' name='item_name'/><br/>, p& z# }  F% L; @+ _! _
<lable>Item Amount</lable><br/>
2 f# j# S2 X. u& z5 r" k' W<input type='text' name='item_amount'/><br/>
5 n# l; y+ S, l- k8 U<lable>Item Upgrade Amount</lable><br/>
+ M3 Y/ ?+ d0 w* m8 j<input type='text' name='item_upgrade'/><br/>
5 M! g4 ?: H3 ]: P  y2 g<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
( n/ K6 z$ H; ^5 Q$ E0 Y
/ b' v1 t; O- ~. t5 L) K# I# m) D) d</lable><br/>
) y8 x& s3 ], Q7 P: M; H  f4 E<input type='text' name='item_element'/><br/>
! [. N0 N. B; m0 [# j* d3 m<lable>Element Upgrade Amount</lable><br/>
* Z( b1 G) ]! Q6 B% V/ G/ c9 n8 K<input type='text' name='element_upgrade'/><br/>8 P/ [( D+ p5 z9 D5 h
<lable>Pierced Amount</lable><br/>' B& \) U3 K, x" N* s- o
<input type='text' name='item_pierce'/><br/>
" T! i; t. Z. s0 t<input type='submit'/>
( t- d5 M& `% Y</form>";
6 Y2 b- Z" H* {0 L* P3 a% y' M}; N: A. J2 p2 ~: y

2 Q) p+ m* y+ P/ W; X4 Qfunction PostListener (){) m2 G' K3 M5 U6 }2 m% H7 z
//Add more post variables if needed and add them to initform() function aswell
0 S. q8 J" l! ^# u' t
& L$ O$ g' ^0 X1 j################################
3 ]$ \' I$ x) D##### Connection and Post ####### `* r5 K3 C  O2 G2 a$ Y
################################
5 S# J9 l; f! ]# w$ [8 P% d$name = @$_POST['char'];6 ^- g1 D0 @  ?" e5 w
$ItemName = @$_POST['item_name'];
! S' B* G% u- w2 l) F$ItemAmount = @$_POST['item_amount'];1 {! Y! u0 L% `5 u" U
$ItemId = @$_POST['item_id'];7 `; c; s' E0 x% a
$ItemUpgrade = @$_POST['item_upgrade'];
6 [2 _( @9 K; e; j$ItemElement = @$_POST['item_element'];: C' u/ K. ], _! r  P7 |
$ElementUpgrade = @$_POST['element_upgrade'];
0 B* [) n- E, j; M3 |9 a$ItemPierce = @$_POST['item_pierce'];
( U. [3 [) ]( w! t1 }################################6 ?/ R& p; w& P6 j

2 _! I8 y2 {! [7 z& N//Check both variables for empty value1 K2 N2 O4 S  X' R. c9 k
( A. S! U" D% Q' [. D
if (!empty($_POST['char'])){
, \* L0 l2 K3 R( Z1 Z3 ?$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where ' h0 Q" @! a" ]6 y* I2 B
2 {: V. p8 n8 `9 W! r; I3 S
m_szName = '{$name}'");
$ l+ {/ b2 Z" T1 S" fwhile ($row = mssql_fetch_object($find)){
5 q# O9 O# E! jecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
/ f6 V. d) o) k6 P0 Y( f  |$ x  W1 Q$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
  M% H1 n' z0 n) C  Y- b
5 `( m' F6 y$ p6 g# a[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 5 c" O  {' E0 }3 J/ f5 i8 e# H4 }( D  A
5 u* E* `$ A- g3 @! z; P& ^% a3 i/ g
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
& N* u, B! k9 ?' y5 E% R
. K  \/ h: ^) {0 |N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
$ H. Q4 U: `3 i* A; S) i, E3 c
( Z6 \. E* o5 |( |, X5 s5 ]7 C, N3 O+ z'{$ElementUpgrade}', '{$ItemPierce}');");
1 G. P) G4 P+ X4 U0 Q: P, B& ~}
  G7 u  s* Z/ J- _1 H/ G' m/ n! I: k* N- ?$ @) D# b$ e- g. |
}1 c. o8 ^4 h" C& G( T! @

6 G7 {$ |6 Y5 s: N% T8 F}. `6 Z, R& g* m3 T  a% u
6 a( T8 J( V. ?6 ~
$InitForm = InitForm();
1 y; g  |3 ~1 o; K% A( g/ H$Listener = PostListener();
9 L9 `8 k( B) V- U* l$ G
+ r4 q; ]2 p2 O! @$ q?>" d$ z( ?! ?  _% L% k5 b: g/ `3 i
" r2 f$ J! C' k( @# ^# X/ F8 Q# Y
3 g; i8 [1 ~7 U+ Y" U. p; W$ [

$ |1 u1 J- T$ U# P/ a: h5 O. R8 J( V$ K; B; R+ s1 C, ^
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-15 11:56 , Processed in 0.059879 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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