飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
% W9 k1 X3 P, S3 T$ gfunction Connect () {
9 ~0 f$ J& n) {3 \, Mmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 7 g; u7 [1 k) d! ]5 ^: w
$ d7 n, ^/ N; d1 Z
Failed.');! H1 F8 |+ ~( P4 S' t' T
}$ J: Z6 p# i$ w9 r
Connect();
" D: l& h! m1 @# D$ T8 A0 G! [5 A
! n9 k# O9 [" Y, X% Bfunction InitForm(){
+ N& F- }2 Z& K- E$ V" p# m  i//layout for the form
3 T% ^1 Q! Q+ Oecho "<strong>Send Items.</strong>" `6 j& P0 Y5 u3 |1 H; y- Q' q: n
<form name='select' method='post'>2 ?# o) b+ ]# q( x& B
<lable>Character Name</lable><br/>
: U( v/ T4 h/ G& U. j<input type='text' name='char'/><br/>+ x$ |: I  e- A
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
- N# Z/ C2 m3 R7 _3 l7 u# `<input type='text' name='item_name'/><br/>2 Z& z7 M% |% `) t+ i( ]4 X
<lable>Item Amount</lable><br/>
" W9 b& u7 k# H3 o  A, j. Q# x+ r<input type='text' name='item_amount'/><br/>
" t& D- B, K! m; B4 m<lable>Item Upgrade Amount</lable><br/>; q8 H/ E9 Z, D1 G2 c7 b
<input type='text' name='item_upgrade'/><br/>
1 [8 B3 C+ G( G1 P+ m* p<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
% ^2 B2 w6 J" Q$ R8 o9 P. i8 q7 _; w; J0 e0 o! y
</lable><br/>
+ v6 J0 S( H( I+ s2 [<input type='text' name='item_element'/><br/>
. J2 N" Z3 F. k# r, x3 R& \1 g# [<lable>Element Upgrade Amount</lable><br/>
3 ~$ M8 n/ E( m, w% T<input type='text' name='element_upgrade'/><br/>
4 \: {5 o  N( |0 R<lable>Pierced Amount</lable><br/>
' |) l4 u: d( K3 v8 ~6 |<input type='text' name='item_pierce'/><br/>6 L) X$ J8 M. {6 `
<input type='submit'/>
2 w0 N/ f* Y, R  `</form>";
; W4 F4 e; w6 W& J}' g5 H" m+ e/ W! o7 U

( e! `7 a* N4 \* Tfunction PostListener (){
- k6 ]7 o7 L* f2 z: L//Add more post variables if needed and add them to initform() function aswell6 L( M% j) D( u2 Z
" C# |' u- Q9 G% Y
################################
- U8 p- e. |5 r" n# i##### Connection and Post ######
- y6 R- z: O/ G1 [################################
# Z3 \! C$ h7 D7 s9 r( V$ k$name = @$_POST['char'];
) U; D1 @' h2 m9 I7 Z: ]3 y$ItemName = @$_POST['item_name'];
" e0 P+ w% ]) f1 K$ItemAmount = @$_POST['item_amount'];$ \* V6 c4 o  h; X& f- C( A
$ItemId = @$_POST['item_id'];
( U# G5 n- V9 l) k$ItemUpgrade = @$_POST['item_upgrade'];
- V9 i8 F9 m- L1 L0 U, L$ItemElement = @$_POST['item_element'];
7 l" u# W8 L; F  i/ Z, M* `9 _$ElementUpgrade = @$_POST['element_upgrade'];' |0 |: g9 {* V8 e4 Z8 L
$ItemPierce = @$_POST['item_pierce'];
3 [4 z9 E' M) S4 E; l0 V################################
8 J6 S# K* @( f9 i
( f: v3 f1 B5 I2 _5 n$ n4 ^3 X2 `7 g//Check both variables for empty value3 C' o+ r" D. Q) _' r4 s

5 ?' I) h- z4 b! cif (!empty($_POST['char'])){9 ]4 g$ V, j/ V, n
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 o8 K* C: z% @4 O# y7 [: Q6 U5 ~. y" U  F1 }0 b  L% L0 b
m_szName = '{$name}'");
8 A0 z! U2 n- D8 Awhile ($row = mssql_fetch_object($find)){
6 f- z- W) \: {. L1 t* [4 pecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
2 `, s" E+ |9 G- y  ~: M& X$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 6 ]" h6 o/ B8 w0 B- s% v% Q6 L

) L. n  A( e1 J  i  E/ O[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
9 Q0 Z4 z# A/ x: {8 [! @7 [: e" g* z$ c4 a/ k1 K
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 0 f+ T- v; U0 z) \& P8 T

4 T. q: c$ K0 K3 f) [# a& e' dN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 9 F/ P8 U2 W, y2 f

( X" c* b) ?6 P0 U'{$ElementUpgrade}', '{$ItemPierce}');");
$ z$ ~& v2 a; Z  R/ F; u: R" Y4 M}
' M  z4 `" u$ N! X* S( q: ^9 [0 l
}
9 Y, R. u8 L: L. y- Q: }! a8 r# T5 K5 I
}' ^" t* p9 i' M( {% h" T

3 P; O' W8 f7 K. ?0 A) F$InitForm = InitForm();% c+ G/ ?( g3 B7 A0 a
$Listener = PostListener();: L% t; F9 L( j9 X* e# z/ }

( ]2 J/ ^( Y6 n, N4 V( k' k?>- |3 I: D% L% O7 N% `7 P

' {. o; l* G; G( x: P) f' m" _( \
! T, U+ D1 |4 ~, @! L* i: ^4 F$ C  N  L% h
. F9 W: R( K1 p3 a
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-12 01:34 , Processed in 0.067161 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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