飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
<?php$ u2 C( u* v, G
function Connect () {# ~: Q, l# ]* f& I
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB . C9 M4 N2 J8 X$ Y0 s9 |3 `

+ R( N- q; X$ j# h9 @0 Q$ }6 IFailed.');/ X" j" _: O& o. y% L
}4 G/ f9 v/ E" t1 h: `
Connect();
7 C6 V6 V) ~( p' S
8 j: \) |$ |0 f3 u# P1 U, q) m2 rfunction InitForm(){; _, D4 \) `8 n% ~# t
//layout for the form* }# x8 c- j0 ~% A1 _: K
echo "<strong>Send Items.</strong>
4 \0 [2 B2 x1 C  k$ H<form name='select' method='post'>1 x5 b$ v! O# b+ X) ~
<lable>Character Name</lable><br/>" o2 a3 A7 {0 u6 t
<input type='text' name='char'/><br/>
; ]2 K: N8 r3 W$ ^$ Y<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>6 b! _* Z/ C2 U
<input type='text' name='item_name'/><br/>. P, N+ h& o  g9 J3 l) w+ H3 r1 X% N1 v
<lable>Item Amount</lable><br/>
% r+ `& H& q6 {' p& r<input type='text' name='item_amount'/><br/>
+ X, N: ]5 P  x: O6 x9 ~<lable>Item Upgrade Amount</lable><br/>
' B9 w& p% B7 K( m% u' Y<input type='text' name='item_upgrade'/><br/>
- G1 W, F2 q! F<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.); N7 ~+ A# G: l& a5 p0 x; o
- s  k$ W$ V, T# g
</lable><br/>
/ m$ d1 j4 b9 p<input type='text' name='item_element'/><br/>0 t) N  L5 E3 c  f( s, K
<lable>Element Upgrade Amount</lable><br/>$ T9 {3 K2 L/ r  G# t; |: P$ f( h
<input type='text' name='element_upgrade'/><br/>8 `+ Q$ F) ?1 `3 S; ~+ K! Q
<lable>Pierced Amount</lable><br/>9 j. P4 g5 Q- X$ B8 X
<input type='text' name='item_pierce'/><br/>
0 ]+ c0 m* L, O" Y<input type='submit'/>
  D# U( k$ X( H( [</form>";4 Z% U" D* U3 ]1 a4 n
}
6 a, I% z: u7 x, {8 ~- D4 ?( k* @3 G
function PostListener (){. S. X3 U7 a: Q( d$ n. m: B! h
//Add more post variables if needed and add them to initform() function aswell8 P8 J1 V8 O+ U1 T8 S+ a

' {, Z8 `1 r2 E% a################################
9 ?! S8 x3 O9 B& e" J##### Connection and Post ######
( F. R% T$ E* v/ D: S7 t" t################################
/ h- m" J& `# b2 T( j$name = @$_POST['char'];
) V0 \$ z) K3 k/ N% R' m$ItemName = @$_POST['item_name'];
. J3 ?8 {- p  K$ItemAmount = @$_POST['item_amount'];; ^  b& Z  Q* e+ N8 P' f+ L( b
$ItemId = @$_POST['item_id'];: G! A( X$ o2 y
$ItemUpgrade = @$_POST['item_upgrade'];6 F' w+ w* j) B' n6 R
$ItemElement = @$_POST['item_element'];# Q) P& @  Y( p( ]( _
$ElementUpgrade = @$_POST['element_upgrade'];
: N4 Z0 v% ~' W$ItemPierce = @$_POST['item_pierce'];
/ B( V. A+ `& A$ m& u8 [################################
  s' ~  c5 h& u9 W; m
2 E5 V6 q3 _2 G" t% m' N5 E//Check both variables for empty value6 |$ H  l( ]/ R& ~! r8 z3 S

+ e  H" m7 X/ d0 Sif (!empty($_POST['char'])){0 w( r0 r& M6 D2 K9 O) x2 z
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 4 a" b3 z1 h" m9 W+ ^

+ h) x# }4 y( K' w7 l7 i  h9 qm_szName = '{$name}'");: @+ h: R7 X( |+ ~: f/ N
while ($row = mssql_fetch_object($find)){
( t7 x; Q9 T* d4 A% f' pecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
8 P) U: v6 H+ K- X5 J  `$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], + w7 D8 ~+ w# q" r. F

& o# K+ l1 c0 T% q[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],   f+ o- d1 @2 x
8 |' a0 A' D1 z4 [" e; Y
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
  ]+ T1 x$ \$ D6 e' N
' \' @% B8 ]# }& yN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', 5 w4 n- |0 n' W% f/ J5 |* V
/ r; u* _" V9 |" n) i' Z
'{$ElementUpgrade}', '{$ItemPierce}');");! Q9 A1 p/ E3 i- o( r  ]& a
}0 v, N& o2 b9 C" \
6 U8 z' o0 m2 s
}! ~6 z1 U' R9 g6 v
1 [* i5 Q! x; s$ C: t. F- [, o
}
3 ]3 b, z% f) h. g
8 n3 d+ f" L" u8 y" D$InitForm = InitForm();$ y" d% m% d6 H0 V/ Q
$Listener = PostListener();( P# S1 ~/ H. r; b( n

( `% {: m  ]+ X?>
3 t1 r% h5 U# z, Z& B# @9 |  }
2 e0 t1 B) @* ~! d% D) M0 @
: [/ w5 K- U& j9 s+ L. G: p( d+ K
% ~2 J7 q" b$ `  W/ P( `0 t
/ {) ~1 A& e, p. i1 G
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-11 00:39 , Processed in 0.069450 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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