飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
$ d* u' k: M6 r9 W: M
function Connect () {
/ c" N/ _6 A, u5 l C
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
8 m6 s1 b0 A4 a! z! K. W9 z
+ k7 |. M, y! k) I" x. x2 [* [6 L
Failed.');
9 P9 n- E+ q: ~4 p
}
W. z; T9 L' y
Connect();
* G4 `& ~7 n1 N
- s6 f( y, m7 T- C8 n
function InitForm(){
' K" W% a$ V( `7 Q: i
//layout for the form
/ k4 O3 i5 T J$ k$ r1 R
echo "<strong>Send Items.</strong>
& A& x5 v1 N; H4 \6 ]
<form name='select' method='post'>
5 T4 F8 U' n& l* j6 b; [) _
<lable>Character Name</lable><br/>
7 y8 v$ _- [; Z3 Q1 [; f
<input type='text' name='char'/><br/>
1 V3 i6 u. o2 X4 q9 K/ @: `
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
0 [( |6 V5 L+ K0 R
<input type='text' name='item_name'/><br/>
1 |1 x* w7 t+ X; e% I2 ~
<lable>Item Amount</lable><br/>
4 ^ d$ w& d; x k) d/ O( ~
<input type='text' name='item_amount'/><br/>
# U; f: [6 @, b2 i) D
<lable>Item Upgrade Amount</lable><br/>
+ ]1 b7 N) x5 {: E/ Y8 o+ R, q
<input type='text' name='item_upgrade'/><br/>
3 b* y1 D2 J5 Q$ x4 p% N
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
4 ?8 Z! q9 Q( O8 m% i1 o
& v0 K$ I( p* z V% D% f
</lable><br/>
) }+ ]3 ^# G; k5 p
<input type='text' name='item_element'/><br/>
: G0 |4 S5 i W) \& E
<lable>Element Upgrade Amount</lable><br/>
% r* F3 ^% {0 _+ A* n' u! g, i
<input type='text' name='element_upgrade'/><br/>
& M* o( ?/ J' y( ?
<lable>Pierced Amount</lable><br/>
0 j$ {" a( J5 R c! `' b9 r# O
<input type='text' name='item_pierce'/><br/>
7 l% O8 j) a6 J! y2 v* j0 X3 ^
<input type='submit'/>
8 Z% D( Z1 G8 {$ w! l6 I
</form>";
3 Q+ i l$ i7 e8 Y/ _5 |! M
}
) w/ C/ y; D+ l. |- o% w
" F; f' O* P V
function PostListener (){
" G# r$ a% i1 w( e( B( T( Q+ d8 M9 k
//Add more post variables if needed and add them to initform() function aswell
2 O1 N: m( I) p/ F
" a5 {. n( z* Y% [* [' u. B
################################
+ o$ N: V4 I- k$ C, u# B- z0 _ W
##### Connection and Post ######
5 ]$ v# ~! G' D9 ^
################################
& T4 Y& f! j7 \. ]" Y- p% w
$name = @$_POST['char'];
! }5 H& [* K( `" T# N8 {8 p
$ItemName = @$_POST['item_name'];
9 g8 Y4 ^* |( Y1 O! y8 V
$ItemAmount = @$_POST['item_amount'];
! l; C* o- j3 Q( y/ R& A6 ]+ k
$ItemId = @$_POST['item_id'];
9 W# }" ^1 ]+ m, y4 ]% O) }$ L4 h
$ItemUpgrade = @$_POST['item_upgrade'];
! t) \0 T7 j2 o* z
$ItemElement = @$_POST['item_element'];
& K: k" ^+ [, M% G/ w9 J
$ElementUpgrade = @$_POST['element_upgrade'];
6 B/ x) P/ u) g' \
$ItemPierce = @$_POST['item_pierce'];
[" w: `' _1 R7 L- p- B' `& y ^2 t
################################
2 P7 {3 g2 e. s- d
. F0 K- d! B) P$ p/ M1 G. ?9 D
//Check both variables for empty value
& B+ _0 } s0 E) S) f0 V& c
# ?3 b# X0 p9 [) ?) f: Q1 ?2 W
if (!empty($_POST['char'])){
& m. F2 ]- B, _' V. q' x; ~
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
3 r1 t' v# ]9 e) ]
; Q: ^# i7 p& O9 X) ~( `! o, p$ R
m_szName = '{$name}'");
9 U7 ]1 [) ~, N& ?' m1 U& F, q
while ($row = mssql_fetch_object($find)){
) c5 o! c) H. E- j
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
) [/ u9 O, f4 {/ |' @! ]# R
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
8 v! o$ f, R; T
1 z; h8 A2 J0 }1 G U6 Z
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
1 E: r7 R$ n7 m* ^7 l% X5 `
' [$ r/ S9 g8 a
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% n* g- p: h8 Z7 Y
: U& X# b# O7 Q8 c) B* g) b
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
0 J Q& E# P3 d% \+ L
6 u" h2 }9 F- B% e# D( e2 S
'{$ElementUpgrade}', '{$ItemPierce}');");
; ~+ V+ J9 d, R4 o
}
3 o& c% R# T: |+ f7 |
% q. E4 B5 L- z& h3 A6 I( H
}
" v; ]1 O; o8 F. l
8 V6 } z: l' s' i( J- j5 O: [2 O
}
/ D: j7 a+ U8 p; _
+ M9 w/ K7 r7 J0 [( I$ u. a
$InitForm = InitForm();
" G0 x# n$ g0 T. z) k% i+ b/ |
$Listener = PostListener();
. R: T* g3 B z7 R- X
8 B; V# V! m) T F3 c' H* J6 e2 i
?>
3 G; a/ T9 z3 W& x" y H( ]7 ?
8 F& i, n1 `- j" H" p* G2 J# |
' a5 [4 ^, {0 A" S- Y( E3 b. N) Z
" N) s% U. b" q% r) N3 N" Y
/ @- Y7 y' E! G5 d# r
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2