飞飞世界论坛

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

物品发送脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:43:06 | 只看该作者 回帖奖励 |正序浏览 |阅读模式
<?php
' J$ m5 e( C0 c' Lfunction Connect () {( H: q* R' S* k# y& y( T
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB , ]: u/ A( t5 N5 }

# z0 N! K7 m0 \, K$ a* xFailed.');7 V) \  g8 P5 K$ E: {% u
}. [! I$ K: \7 E9 a1 j
Connect();# x3 H& r) f" p* y8 b. g" W

5 [1 h) W  X/ [1 kfunction InitForm(){! l; a/ a8 X2 @: i. T7 u
//layout for the form% P' u- y1 I5 D# C% c4 t% _
echo "<strong>Send Items.</strong>
1 X5 V7 y  E4 \8 U<form name='select' method='post'>2 a- R1 h2 F' J" i7 Z
<lable>Character Name</lable><br/>
) ~, O5 S! O* O  I& i7 C- q1 R<input type='text' name='char'/><br/>9 O$ c) h, P; S8 \) d" x) N8 y
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>! ]( P# d/ _1 I& l& x
<input type='text' name='item_name'/><br/>
5 x8 M* v# n3 _7 `& _" ^<lable>Item Amount</lable><br/>
, L4 j: g, s7 p: o<input type='text' name='item_amount'/><br/># w* p2 P" B, u5 [( |0 d
<lable>Item Upgrade Amount</lable><br/>
& }7 j' z( i2 \: M6 o2 Y" u<input type='text' name='item_upgrade'/><br/>9 P2 X; N5 J$ Q- N6 ?
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
3 d7 B! z$ B  t# d4 S: r! j7 W  w2 o$ [: D3 T
</lable><br/>
, {/ p' ]  r, M( K8 U, u) [( ^# N<input type='text' name='item_element'/><br/>
, S! Z2 K* P2 y<lable>Element Upgrade Amount</lable><br/>: w; u9 m2 }* s% o  ?# t' m, e
<input type='text' name='element_upgrade'/><br/>
8 I; h) [3 m7 j# h<lable>Pierced Amount</lable><br/>
! N6 u9 _2 K) V. {; h2 L' j<input type='text' name='item_pierce'/><br/>* B% j( N; j; r; D( y6 O8 Q
<input type='submit'/>' N  V) V( Q' {. J2 M, y9 r0 i+ }5 G
</form>";
5 D8 W, Q+ c9 Q9 h5 |  b}) C) S% k/ i- D
4 B0 g; c9 X( c/ @% O5 t0 \
function PostListener (){2 X( `8 P" g9 u, _
//Add more post variables if needed and add them to initform() function aswell! P' q. t  o, G- t

2 n' }' v7 c7 [% A: e################################# L/ p5 m9 I2 l; p4 h6 |/ O' O
##### Connection and Post ######
. p. P% X1 U" ~################################& `4 F, I8 q4 y; j( n% ]
$name = @$_POST['char'];
- v7 P+ T0 U, u% S* ?$ItemName = @$_POST['item_name'];
. A. {5 y- ]' ?1 [$ItemAmount = @$_POST['item_amount'];7 l6 v. @4 F/ j8 P  S7 s; T
$ItemId = @$_POST['item_id'];* O4 o4 L; }* U  o4 T  z# Z' X/ d# J
$ItemUpgrade = @$_POST['item_upgrade'];! D7 C  h: M# q  c9 r1 \
$ItemElement = @$_POST['item_element'];" C$ k0 q* C9 S: U
$ElementUpgrade = @$_POST['element_upgrade'];
+ f. A( J" N7 y1 `( L* |$ItemPierce = @$_POST['item_pierce'];* W! i3 F; N0 T. y
################################
& j5 d, N0 k. k; r& T; P
, p4 P4 _8 r, m' [- A//Check both variables for empty value( q# C, X% }6 x3 h/ |
, Z% f" S& r: l
if (!empty($_POST['char'])){
) i6 j! w. R& T2 t3 \# E$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
- N4 [3 i0 E; h! @7 D, Z4 V
0 H9 \* r( A5 `3 Z: i8 t. Hm_szName = '{$name}'");
, D  h3 l1 Z- k# L+ `while ($row = mssql_fetch_object($find)){1 k: ~- L. G; w  _
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";$ g) o$ n1 s' e, l4 Q
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 7 T2 d! i6 B7 U" e2 c6 n+ P, t

, _" B0 V) u1 p$ q+ o[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 5 M+ x- _  R4 }) d7 [
4 j' X9 T* X6 m
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', & W, @2 m4 }/ j$ V. m8 ]

: m; a1 B$ _1 u8 cN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', + ]$ [7 l, @7 O9 s% h+ Y* [8 n
/ n+ t2 e( i! S% L" f
'{$ElementUpgrade}', '{$ItemPierce}');");
4 E& K6 y1 T- k8 |; ^% @6 v( e: C1 y}
3 Z) F9 x: N# _* C3 l# X, q5 l% [1 V% D1 w3 ^3 \4 Q
}% B* \; r$ c8 D* ?- U1 {0 D3 f
5 M4 X* J2 I! c  Z1 U
}  F& e0 p  C& B- _
2 _2 c. t- C# v. S6 y. m" i
$InitForm = InitForm();
$ p5 }% Q, K3 F$Listener = PostListener();9 D2 A' q; p2 c; k$ U) _

1 T7 X8 ^1 t# Y5 K, O* ~?>
* {; n$ y, @4 ]- b4 E8 }6 c8 W
& l8 l, B+ h9 L- w8 G" C/ ?8 i! H/ ^

$ O" K! M7 P* O4 H. S5 T8 ^& _, n, a, B$ }3 r2 M- P8 n% U
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-12-3 14:18 , Processed in 0.057385 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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