飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1090

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1090
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php  T) U3 Z+ d8 R' `6 _; k
function Connect () {
1 B% ~4 K) U( N$ y. ~- cmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 3 c% x4 q9 |6 n! X( Y2 Q& X3 o. J: M
0 ^' w  X  [7 v7 ?7 @6 @1 v
Failed.');4 }' X) P+ ?: @# f$ w# I
}
. c' a, i- Z- v: h6 u' E! jConnect();
8 P* m, ?1 {$ g0 F: D; y
8 @9 u: L; Y3 Y( ~; xfunction InitForm(){
; a0 F0 H7 t! S: \3 {" r3 }+ ~+ Q//layout for the form2 d% c; I) t: R+ @8 H; L/ F
echo "<strong>Send Items.</strong>
6 f# |2 N5 W$ q<form name='select' method='post'>
! B8 x9 \0 j2 N3 M<lable>Character Name</lable><br/>, N5 o$ f9 Y6 X7 ]% B+ [* O
<input type='text' name='char'/><br/>
- T, C8 W8 i0 j/ @- f5 ~' U<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
* k1 R/ }1 l; J* y: U: A<input type='text' name='item_name'/><br/>* ^0 @, O) r5 [2 I) q4 j9 `
<lable>Item Amount</lable><br/>3 x7 [: z7 Z8 s: f
<input type='text' name='item_amount'/><br/>
- P; w. v7 X" ~1 y1 s2 u9 J<lable>Item Upgrade Amount</lable><br/>
: P) d7 u; w5 u( o<input type='text' name='item_upgrade'/><br/>
0 T4 _9 @( q# s! w<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)) ~* s- `- ~' ~: i+ k! ~) @
% H* h* s8 x/ O) M, B  p( ~
</lable><br/>- i. V6 M* c/ P% h
<input type='text' name='item_element'/><br/>
- ?( Y% |/ I3 N) ~2 U/ h: _<lable>Element Upgrade Amount</lable><br/>$ @% f0 v8 s' ?2 ^& D! q
<input type='text' name='element_upgrade'/><br/>1 `6 D& F5 O7 N, Y# R
<lable>Pierced Amount</lable><br/>
5 e, D. s% H% u3 K<input type='text' name='item_pierce'/><br/>
7 n* v7 c; h: T" Z! }, r<input type='submit'/>2 N; B  m8 T! E
</form>";
6 R7 N  @* c  M}
5 }! i, q8 s5 m. b2 x) m' ?3 I6 R; g. g% y* e6 E- V
function PostListener (){4 j, n: R" X% ]& X# T. |* T
//Add more post variables if needed and add them to initform() function aswell
! \2 m: g0 E% g1 p4 z( l' F
9 g( X7 D9 c, i4 V% v9 f################################
) w6 C! U6 s) Z" G6 f/ V##### Connection and Post ######
' g  d1 ^2 {" k) F) E################################: q( b# Q  c& U% s
$name = @$_POST['char'];
8 @4 e. ?; p" {- R; k$ItemName = @$_POST['item_name'];
+ L# s8 _% \1 \. [2 r$ItemAmount = @$_POST['item_amount'];+ ~; f9 Y5 z0 R- f8 z+ ^
$ItemId = @$_POST['item_id'];. C6 O& `6 b5 ^# N2 {  F9 {
$ItemUpgrade = @$_POST['item_upgrade'];( G1 c+ u7 C6 e! U0 o, `/ Y
$ItemElement = @$_POST['item_element'];- c1 R! `% v9 I1 n$ T
$ElementUpgrade = @$_POST['element_upgrade'];6 E( f9 |/ `2 I
$ItemPierce = @$_POST['item_pierce'];* z5 w6 t/ B& N9 d  |% @/ k
################################4 C) e  P6 J; O9 T

7 U4 B6 }) j9 P; \+ X% N* Q7 m//Check both variables for empty value
8 c+ r2 n9 p0 z* r# N. `; h- J3 G2 h3 f
if (!empty($_POST['char'])){
1 M6 m' U6 @" Z5 f9 |$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
2 s& d/ J$ Q; M+ q5 C6 j; }1 |7 c, }% U& B# g, _
m_szName = '{$name}'");
/ N( \# P- N  j" _while ($row = mssql_fetch_object($find)){; E  o, h, V: K
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
5 j3 l. ?# s: Z& F$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
3 U. n: r( z1 m5 g% R: B  v0 P7 A+ H7 P* {' l+ @& y/ Y! ^
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
1 {9 P$ Y* m- s0 |3 P: ]6 m  s) |8 |/ d, s
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 5 E9 |9 x( y9 Z. {2 [# q8 T

3 u0 {0 g, K6 dN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ' N0 A* t: p; Y8 F( \  a
. u! E1 m' B7 X: ?: D
'{$ElementUpgrade}', '{$ItemPierce}');");
4 q' }  d* B! U9 t* U}  t9 k6 p; I3 Q/ }- }. [+ h
  Y( C$ T2 u6 y- {. y
}% u; E: s7 U+ r1 ~) y& Y; }& q
7 l/ u, V  X6 e: k  _, F
}
& V" s% O' I4 X# C' y! b  x: B2 k" `/ M+ ^( V& d, B0 f
$InitForm = InitForm();3 u& Z: h' U1 r$ g/ y  j) h3 h' q7 J
$Listener = PostListener();7 S0 ?) }" I3 v! c0 R$ w
" x2 K7 r- U$ R0 ]; U% A5 \
?>
3 l0 q6 N- m9 g! }1 G4 ], V1 s& g. z, a9 n4 I3 K

% Z( H. L$ i' {. g9 T  [( h6 U* Z2 A5 a& _5 E  Z% Y

- ~( P$ H- z/ h* Q4 M/ v" a
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-29 00:00 , Processed in 0.079567 second(s), 34 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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