飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
) E+ a, c, E) ?5 vfunction Connect () {
* t& s' M! ?9 f) |6 ?mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
9 Z; u1 K( A' z" H- y' G/ k+ E5 j: A  |2 k) j. q
Failed.');
# x$ G8 y6 M! H) B. ~/ |, q3 L}! ~# I4 G; x3 U) X3 w+ \& e' T
Connect();6 y+ Y5 D, P+ \$ j# Q" u% o" @' \

# f& f% I1 @9 f0 k4 P' Yfunction InitForm(){
  H% D" C+ U* n# p//layout for the form
5 T, F4 ]! s, C& {5 n1 W2 t+ k2 cecho "<strong>Send Items.</strong>* [- L" J3 }. D* t) y
<form name='select' method='post'>( H9 C4 n; d: a" p
<lable>Character Name</lable><br/>
, t: D( s$ k, A2 G5 B3 o! V<input type='text' name='char'/><br/>; P5 J' X: ^; n7 G' v- J
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>  l' I7 _; s, `' q, G5 V
<input type='text' name='item_name'/><br/>
* I5 O! L# M9 k<lable>Item Amount</lable><br/>4 `5 \/ D+ c4 P/ N+ p# \% W
<input type='text' name='item_amount'/><br/>. @& ~" G# `' R# K# D
<lable>Item Upgrade Amount</lable><br/>: H2 u# ^+ ^! {( A. |( B2 f( [) m" w
<input type='text' name='item_upgrade'/><br/>
2 b0 I& n& T& A+ e, {+ X<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)$ n1 c/ s9 t" |: ]

+ o; d) ^0 {9 o3 v</lable><br/>
" h' B* q. }: Z<input type='text' name='item_element'/><br/>  e4 m: X* [" l, z
<lable>Element Upgrade Amount</lable><br/>! L  |" p& l3 L6 W# u7 j
<input type='text' name='element_upgrade'/><br/>( z7 ?& y; n' x) p# D
<lable>Pierced Amount</lable><br/>$ M. }6 u. X% v4 x
<input type='text' name='item_pierce'/><br/>9 r7 ~. j+ ~) K5 n! m7 L+ H0 L3 c8 e
<input type='submit'/>
% f8 k" }! A* O% V, ~</form>";
5 }* g7 J0 L; Y}
; S& R/ \' X- N& f4 _# H# q# B6 V& B% P7 C
function PostListener (){: h8 }  c, G9 z$ F$ Q' `" t( t( s
//Add more post variables if needed and add them to initform() function aswell! h* O- r+ o8 c8 K' `% q: Y

& X) J5 S6 ?9 ?, _+ l( j: i8 U################################
* E; t/ g" @1 J4 Y$ Z5 u##### Connection and Post ######
4 i7 d" s  @: T) {  `) G* Y4 j# s################################+ H' m, ?" L3 |6 h9 ~7 V* o
$name = @$_POST['char'];& ]5 H& L) @" ^6 A0 U# K
$ItemName = @$_POST['item_name'];: X: X! H) p8 o* r- H1 l: x& g- p
$ItemAmount = @$_POST['item_amount'];! v  I8 o9 }. O! N8 ~. V. |
$ItemId = @$_POST['item_id'];
# ~# z8 P& p! P; n. ?) j5 C$ItemUpgrade = @$_POST['item_upgrade'];6 f% B7 s( k4 ]* w% }/ T3 y: R
$ItemElement = @$_POST['item_element'];
# ]! N5 j" w1 |- ~$ElementUpgrade = @$_POST['element_upgrade'];
; H2 B* G, u! |- j  v4 t1 O/ H# U$ItemPierce = @$_POST['item_pierce'];
) u. |, S  {9 x2 _################################% _& o' r( z9 S9 h

. f, l- L8 _0 K9 t  S* r//Check both variables for empty value/ Z2 a  v, C# _6 V5 n4 N3 p

8 N0 P7 W) r  Aif (!empty($_POST['char'])){; y! {1 z4 H9 ]" z
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 6 s$ @; P! `- E5 T5 u2 J1 @

6 ]) S4 D' R- M+ N* [+ [m_szName = '{$name}'");
! z1 T" m! z& K3 q# wwhile ($row = mssql_fetch_object($find)){
0 O, [8 B; e: t% fecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
/ M5 E! x" O2 r3 O4 _6 S8 f, ?" _( n$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 2 v. T! L) z. o6 E( x
0 d: _- h$ a& b/ p
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], / m* _& H, F4 U, q3 g6 `) P3 [2 k1 _
5 A/ h3 ~* A; n" s
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
+ X' w  E6 M' J5 |4 V
9 S! z8 _1 V- N* X8 T$ v* [N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 4 ~; @; s1 ~$ ~' A" D0 T% s, S
$ N# s0 L3 f( x
'{$ElementUpgrade}', '{$ItemPierce}');");0 \$ s- P, j/ O' r
}' c; D% b- v' U6 \

  o2 u& d1 F. }" @9 K6 E2 J5 u}
) n0 e2 r' `5 j2 N( u6 K# e3 l! r& X7 {+ L0 |% M- B0 P
}) o. t& A3 f% J4 _* L! \( V  c
6 Q  u. P5 _' D1 u. L
$InitForm = InitForm();' }/ `" r# A, ]9 G* m5 L8 C' c
$Listener = PostListener();
0 M) F. @( @* ], ~" W
" g# [! |4 c) Y* {4 {: e7 W?>1 s/ _% _9 e* k; a6 w

( U, c; \  q' o1 M. o* k: p
2 Z' V0 o3 s: e1 i/ s; m) H
" B# F. U! S9 O# t4 Y& k* q+ b# t# ?; {" V9 i
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-10 13:09 , Processed in 0.060604 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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