飞飞世界论坛

标题: 物品发送脚本 [打印本页]

作者: admin    时间: 2016-1-10 03:43
标题: 物品发送脚本
<?php5 T4 b' u  b; m% P  n2 S7 z
function Connect () {4 Y6 j+ V2 z  L* o8 y
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB " x7 x# Y- }1 T' e$ B

$ u: Y7 C6 W( G# {$ K  @Failed.');* h+ u, b% o3 S7 |
}
4 V) @, u7 U, ?, v$ EConnect();
' F) |8 ]( H2 V1 N6 R- {1 ^% O6 H7 d# g7 I* G5 @1 X
function InitForm(){
5 y  e- X9 {% v//layout for the form/ S! W2 J  |; T
echo "<strong>Send Items.</strong>. N! o' _+ T4 N; ^# R7 c. S  q. q
<form name='select' method='post'>5 S8 O. u( S  P3 [9 E
<lable>Character Name</lable><br/>' r) ?5 X5 S+ ]4 M
<input type='text' name='char'/><br/>& ?3 E' W+ H% O+ p9 C+ e* J
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
/ q, \) F$ K. M4 @2 R  ?0 I0 u<input type='text' name='item_name'/><br/>3 b0 ^9 [1 P) z( {6 B/ H7 h
<lable>Item Amount</lable><br/>
! \( o* F9 `# I) v: h+ t<input type='text' name='item_amount'/><br/>' l1 B. g. p) R. a* j  [% Z/ |
<lable>Item Upgrade Amount</lable><br/># J- x6 P8 q( m0 v) B9 e; g4 k4 t& S
<input type='text' name='item_upgrade'/><br/>
2 d9 d. a& S; \* m9 P; D- h<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)" J( n. \: R" g) s9 G
# S1 j! U1 w/ b' ?0 K( G8 H
</lable><br/>. b7 Z" Z% _. F. s$ H8 ]) [* n
<input type='text' name='item_element'/><br/>- z9 q+ N% I2 u! l6 Q- ]
<lable>Element Upgrade Amount</lable><br/>& C+ Y4 g/ W. e7 x
<input type='text' name='element_upgrade'/><br/>) H) Y4 d; _1 s! m& o3 h
<lable>Pierced Amount</lable><br/>
) P% f7 f" e* ^, h& [2 A; I1 @0 j9 `<input type='text' name='item_pierce'/><br/>
5 k" W( h: L* q8 S7 U<input type='submit'/>
! x/ F; x2 b+ e. r% ]</form>";1 o8 t" G' e2 t$ X
}
5 G9 m2 h& z$ k: C# U4 U  ~+ U0 S3 P
+ b3 |' {, g+ ?; @' w* Rfunction PostListener (){4 K* l' b1 r/ ~7 u
//Add more post variables if needed and add them to initform() function aswell
* N4 A7 e8 O3 U% E5 ]3 N& ]0 J9 J* x: ]0 M* I
################################4 T; I6 M4 d6 _' y4 g7 Q
##### Connection and Post ######+ D1 N. F. C1 j0 |/ d6 X
################################
9 S1 j& F8 i5 {6 `" Y& p$name = @$_POST['char'];; ]2 V# b! x5 z* S: v3 D+ Z
$ItemName = @$_POST['item_name'];: G8 o  ~) S% ]1 U( {8 M4 p- {1 e
$ItemAmount = @$_POST['item_amount'];0 ?( n/ W5 g) R$ b, h4 L( x
$ItemId = @$_POST['item_id'];
' Y( d$ U+ e9 ]# {: [. B; q9 f$ItemUpgrade = @$_POST['item_upgrade'];) @! h# ~7 p) }% z/ v
$ItemElement = @$_POST['item_element'];! d0 L" B" F5 I3 H
$ElementUpgrade = @$_POST['element_upgrade'];' `* N2 ?2 e" A; z
$ItemPierce = @$_POST['item_pierce'];
3 h! d6 k1 T8 n+ F1 [################################, n5 _5 H$ A8 c4 p" X7 Y

4 F' M4 l  a; w, ^9 u//Check both variables for empty value8 N( }+ ^# ~% z1 n9 C5 v& G

6 U/ J# L2 I- j4 n# Jif (!empty($_POST['char'])){5 b. ]+ N7 q' d2 E2 [" p
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 C" b- d" W0 w" F
0 i$ x2 K5 K: o* q9 N$ xm_szName = '{$name}'");/ I9 D% p: {$ T( Y- N
while ($row = mssql_fetch_object($find)){
0 a$ I" f) @9 S# `( W$ eecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";* A& C9 [6 {- D2 L+ r7 d
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 6 d  E2 S" K9 {3 V* t# F! D

+ E9 `; x$ L5 ]+ o2 O4 `1 |[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 4 c& W: \! Q/ d/ i5 w
( [! q/ C4 _! I$ o1 k
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', . d4 U/ w9 t# J7 Y

% A1 U- B9 r$ f! H: j5 ~; Y# vN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ) |1 i9 r/ c( f1 m* v! d

# B% k0 W# ]7 b3 V8 ['{$ElementUpgrade}', '{$ItemPierce}');");! e$ t% d/ M7 s' _! \
}# ]+ q' N4 Y" V1 e% ]
: }; {% F+ M) |  B' L: s7 a
}8 y, p2 j9 t: m: c+ N' d7 D

, j/ p9 k3 O! U0 k" I: t}6 D$ A2 y/ c% A; \) i
: s  D( m# u1 z
$InitForm = InitForm();
8 p. Z; f: D# b" P! [; s4 f$Listener = PostListener();7 j, B& R/ ?9 ?* j$ z* U1 L$ C

* G3 O& w! `( l; c* c?>; ~  d1 |! S1 `2 N0 T) s
1 C- P' S' D1 F# t5 i! _. o$ s

) i$ j1 ?4 d. ^& Q. o  Y, F5 m7 Z  t  w/ Y8 x6 _8 n
7 Z8 s# u7 T/ P& p2 J. N





欢迎光临 飞飞世界论坛 (http://www.ffwold.com/) Powered by Discuz! X3.2