飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php
9 r! @8 {& W. N# e4 V# lfunction Connect () {; G# \! s# I; g# D  }% O! U# e
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
2 [+ ~; W, s9 @: u0 ]1 k. A0 C: r+ X3 S! G0 W  u% E5 D$ h
Failed.');& g- X/ {# Q8 R' ^& M
}
, L. w  Q& n/ Y# F# kConnect();
; S( i) t0 c# K5 }3 Q+ E) j5 I* n; i4 n  k7 M+ V5 Q7 Y" s( |: @# H
function InitForm(){) x( c: q8 \3 r; ?! G5 M5 J
//layout for the form
$ h0 X3 S  I. r) c, z7 Q. lecho "<strong>Send Items.</strong>
9 A% K0 e4 j8 K2 @% e" u<form name='select' method='post'>
4 h3 x" c# t# k7 \<lable>Character Name</lable><br/>! G! p$ x9 e4 y4 K& l. j
<input type='text' name='char'/><br/>7 B+ m7 Q( b) d9 J# ]" `
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
5 r, N" D- E6 o<input type='text' name='item_name'/><br/>5 E' |5 ~- N2 \7 b3 P9 a
<lable>Item Amount</lable><br/>; }! u- q& E( F9 Y
<input type='text' name='item_amount'/><br/>
, P8 C0 e+ m9 X; s4 @7 [<lable>Item Upgrade Amount</lable><br/>
% f" S8 O+ {2 {  [: A<input type='text' name='item_upgrade'/><br/>  ?4 g- o8 t5 @0 y0 `/ H7 F
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)7 c& b1 F9 ^0 ?( b# T4 F5 D  q

$ `" A" F/ ^( @9 o7 s</lable><br/>9 c4 d; F. ~9 e+ N8 h/ M2 P5 C/ o
<input type='text' name='item_element'/><br/>
4 ?' i# L- U: l# X! E" t9 ]/ b" @<lable>Element Upgrade Amount</lable><br/>
4 K8 E, y# H  ^$ L6 Q5 I; ~5 A<input type='text' name='element_upgrade'/><br/>
- T( }+ X9 _3 ~- O& }0 K<lable>Pierced Amount</lable><br/>: p: m$ ?* N+ A& S( N
<input type='text' name='item_pierce'/><br/>
- [% q4 T* x' ~<input type='submit'/>
' |; v+ u9 x" J+ {" x, n</form>";
1 x/ a% T# L  X, H. @# f( K9 w}/ K' n/ d/ I4 Z( m: B6 B; t: J
+ E! ^* e) g( {6 \9 P  u
function PostListener (){
1 G. E( ^- a# b" D//Add more post variables if needed and add them to initform() function aswell% S7 D8 _* p7 V9 M$ g
) t$ w. ]0 r& |
################################
- n! G; \9 t0 u0 F) l1 `! u& J##### Connection and Post ######" B$ t+ Y8 p. i+ D
################################
7 E" t/ ~' |- \$ G$name = @$_POST['char'];
) |2 o6 a& x1 M0 ?$ItemName = @$_POST['item_name'];
, k9 T$ G6 L# y! N! a" O4 ^$ItemAmount = @$_POST['item_amount'];" o0 T9 G( J& R' k
$ItemId = @$_POST['item_id'];: E0 s, l* N% v3 U0 g1 k9 o
$ItemUpgrade = @$_POST['item_upgrade'];8 B4 |& m8 k! D9 ?7 B- ~
$ItemElement = @$_POST['item_element'];0 z5 }# i! R3 j- K- V
$ElementUpgrade = @$_POST['element_upgrade'];
$ L6 G* h+ N1 {0 c$ItemPierce = @$_POST['item_pierce'];
8 e* O# e! Y1 X; T8 m! Z. Y################################
- V, V- Y, ^8 R. h7 A2 C, V9 h1 R' K2 g- i9 Q+ @
//Check both variables for empty value
3 B; K* R2 N+ s0 r
% a. F" v; ?) I: j- z* ]if (!empty($_POST['char'])){
$ Y2 i4 e+ H: g# }( g/ l( v8 q$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where / w: O* g' ^/ }& n# i% y
1 d3 w0 ^+ Y: a2 X1 i
m_szName = '{$name}'");. \6 _' |$ b8 l( S2 \5 f3 \, ^& r
while ($row = mssql_fetch_object($find)){
& j/ z0 M7 D& Recho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
- G! y# m8 S9 P/ z7 Q, E$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], : d9 ^" _* s5 p; Q9 h% y$ f& x7 X. E

# ?# s& P0 s) `[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], / a2 T, d* x$ z5 Y

# O4 b& `2 G7 o  i4 ?[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', / \7 b; `) v8 M: F7 N, M$ A$ ?
% T$ x+ t' W) C! n1 V3 B* L
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', - A3 i/ E; N7 s4 d. k8 A
0 q4 A% t' B* ]3 E( C" s
'{$ElementUpgrade}', '{$ItemPierce}');");
. g+ r2 W; U5 L}
5 w' J& c6 M4 b/ C! o/ p/ j/ G% i0 U' U9 Q" o2 x7 X5 K. u: L3 s7 e
}
0 P- V0 e" x) G# k/ B7 W
5 f$ j' Q% X7 T% }* O# S3 _}( A$ M! h# N- @$ C) y6 j$ x
) g5 o; K2 T, t3 s: G& V4 \$ c9 E
$InitForm = InitForm();+ P/ C& K6 Z6 j2 ~% d1 ~& u) F
$Listener = PostListener();5 |( C/ p2 b0 o# o5 ?5 e0 c$ J

9 `6 T: @: U, l* v% q* o% F?>
8 ?1 C8 p( ?2 z  B
0 H' f* e" X2 w2 o  @% k
3 H% G" t$ K) r
& j4 W7 q4 V/ b  t1 e
. M9 }; E* p/ @6 C
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-4 17:06 , Processed in 0.061829 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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