飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
$ e' d# U- p; Y# b5 x# ~
function Connect () {
6 W, E! F. d- \4 _6 {4 L
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
# C- D, r j; l- m* T
7 T0 u; |" ^) u8 ]& B. r
Failed.');
! |+ q9 s7 A! v
}
" R' R4 F* m: z& k: \* g3 f
Connect();
" G) n) ~/ ]5 a# Y9 u/ u+ G
* ^7 r: M2 K& g6 a/ ^4 L2 F; [
function InitForm(){
2 K4 [: T5 Y( M- D W& A
//layout for the form
# V% f7 N. r7 n" b5 _! u; s2 O
echo "<strong>Send Items.</strong>
5 s0 c* [: K+ Q3 B4 j1 \& @, n
<form name='select' method='post'>
- c# E( ]4 _2 G7 k8 u
<lable>Character Name</lable><br/>
6 y1 t$ p# @2 {% L0 z
<input type='text' name='char'/><br/>
# n; M" C f0 j! P
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
* H$ S8 S9 B# W2 w/ D, s. z
<input type='text' name='item_name'/><br/>
2 j: y& Y4 w0 l9 q a% Q
<lable>Item Amount</lable><br/>
( v) {/ H, k6 y% G
<input type='text' name='item_amount'/><br/>
, o, Y+ O P* ?# h2 w
<lable>Item Upgrade Amount</lable><br/>
( Z) Q7 k0 q, X* ^
<input type='text' name='item_upgrade'/><br/>
4 E* G4 z- k( v& n7 K* X1 t, k3 `
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
1 m, e1 J# F: A& u6 T0 m. u- V
/ `9 \" L1 e9 W& g3 V, w
</lable><br/>
+ w) e" `1 S% }& P! @( }) P
<input type='text' name='item_element'/><br/>
& Y0 n8 Q# U' W0 {- q
<lable>Element Upgrade Amount</lable><br/>
6 j5 ?3 K. J; b( w/ `4 D
<input type='text' name='element_upgrade'/><br/>
+ M$ b! T2 r) A& C7 Y9 Q
<lable>Pierced Amount</lable><br/>
& U8 M) m7 e- J( J! M
<input type='text' name='item_pierce'/><br/>
; j3 @) @7 F$ x( D
<input type='submit'/>
/ `5 s' g+ L2 r, k w
</form>";
( f) ?$ L- ]5 v* w6 ^2 p
}
" b5 u$ J! Y* o: u
& e! }) c/ N0 \; Q+ B1 h# Q
function PostListener (){
5 ?+ I" R* D+ j1 B' _; ?4 Q
//Add more post variables if needed and add them to initform() function aswell
9 G) ^: ?/ h7 j. G' u
1 ?8 z/ m& i' K$ t1 E
################################
: n1 v8 R P6 H. e3 E
##### Connection and Post ######
7 t9 A: o/ y' U3 ]
################################
6 }5 X i# e* \$ O+ ~5 ?4 X
$name = @$_POST['char'];
. v$ F: V/ g" n# J' C& [. _
$ItemName = @$_POST['item_name'];
3 \1 Y. e4 X- B
$ItemAmount = @$_POST['item_amount'];
! P% U! o8 R5 P
$ItemId = @$_POST['item_id'];
% w- n7 s# z8 V$ f
$ItemUpgrade = @$_POST['item_upgrade'];
* [% f% ^8 h! k: F& m
$ItemElement = @$_POST['item_element'];
" v& U5 W% ~8 J# o
$ElementUpgrade = @$_POST['element_upgrade'];
2 }# I) _+ y9 Y* v2 i& }: R
$ItemPierce = @$_POST['item_pierce'];
) Y& h+ T+ q8 H; h
################################
, L# o# B; y$ ~% W& W- d" a
6 k* `! |0 x9 h2 D1 c2 y* g
//Check both variables for empty value
0 C& C9 e1 U# `- x
- k9 }5 ~5 V* L, i& z J: C" E! s
if (!empty($_POST['char'])){
* T5 l/ t! L% ^
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ K6 G1 u" R% ]
( M8 N! {4 s# f0 y5 A. p+ k9 {
m_szName = '{$name}'");
9 Z! ~4 M4 e) r* X. I
while ($row = mssql_fetch_object($find)){
2 c$ d/ @: m j+ \
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
% t% T' A9 E7 u! k
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
6 `' C7 R: w, x. l4 O/ L8 B8 j
* w2 ?( W5 h) ], l/ R) ~' P
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
/ y0 q& }. Z' t% l6 w1 C' a; [
, I" n* q: l& f! |3 W$ w
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
0 o y# b V7 l h
& R" M1 [8 N# l8 ]2 \
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
7 S+ q' L7 ?" {/ g8 L
# d3 l- [0 a9 c& ^3 T: I
'{$ElementUpgrade}', '{$ItemPierce}');");
" l8 o$ H3 `8 e5 o+ C/ Q
}
- J) Z( L7 h- A3 z* g9 r, N8 b
" Z+ A$ w# w5 K
}
' R3 L6 `5 ]/ J8 g# T
& L: N/ Z2 I3 q" u. m- I! A
}
% n/ Z7 E* x9 {; N
% X" e0 {/ r( h& v7 F4 C1 [* s
$InitForm = InitForm();
8 l0 A+ | W P5 E
$Listener = PostListener();
" A. ]% w) k: C0 g4 S4 T
7 V+ y# l, d/ {
?>
~6 {1 j* U1 Y- e$ O- B
8 r8 j8 U2 X8 C$ u( J3 E" P4 D
( h8 M( @5 Q' b
3 r2 f. e4 X0 C! a# g% M) Y* G
4 }3 W$ b/ H! u1 G, ?0 R8 r
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2