飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
" _# H2 K; F, Y7 h
function Connect () {
I$ f, `& T# Y; Z
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
; j7 h7 y. Y2 R* u' Q% f7 j5 M L" z
+ ?1 A* n1 B1 m G
Failed.');
7 m- l$ U8 |/ j/ F/ T+ z& N( [
}
0 F% [; C' ]3 f% D3 Z
Connect();
1 k' @, }( j& B2 f' N0 K$ q! x" L
5 p( l! S5 c+ Q
function InitForm(){
2 K5 ~! Q2 e* n5 ?: j5 k
//layout for the form
^6 L+ x! T1 y5 e8 f
echo "<strong>Send Items.</strong>
( B {, R/ Z% L$ l
<form name='select' method='post'>
( v; W' q7 d! I! U
<lable>Character Name</lable><br/>
: A0 T! u' [0 [/ H
<input type='text' name='char'/><br/>
" S0 j* A9 O$ K0 i1 R2 i" Y% s
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
, p& w' @/ C+ G* m- k& y+ w
<input type='text' name='item_name'/><br/>
% t- G# k% \+ _9 z# ^
<lable>Item Amount</lable><br/>
' g6 }3 Q7 _4 D5 |* L; J
<input type='text' name='item_amount'/><br/>
& n" n* U! }2 B
<lable>Item Upgrade Amount</lable><br/>
) p4 u) H# W$ A, V. d
<input type='text' name='item_upgrade'/><br/>
) K, S' F: ?! _* l- S- d
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
8 d" R6 \; Y8 ^2 B4 b+ K) c
( d, N0 @' ]8 T2 V! A" _5 t
</lable><br/>
% c0 X, ^& b" j
<input type='text' name='item_element'/><br/>
7 v' S+ |2 J% K: R( A
<lable>Element Upgrade Amount</lable><br/>
* p6 Z& P! A9 f1 {7 R- z0 b1 l
<input type='text' name='element_upgrade'/><br/>
. Q8 e4 m" o1 p! `
<lable>Pierced Amount</lable><br/>
% r( R! K& j# m9 F/ j v, P
<input type='text' name='item_pierce'/><br/>
( |1 v' J6 e3 G+ j3 U
<input type='submit'/>
. g! Y6 S m B# n5 ~( ~
</form>";
2 z8 E/ u# ]/ I* n& J. c, i2 N' m
}
7 D% x; a! I: a; N
& m# y; m5 m* w) a# L
function PostListener (){
7 p- A, |" x/ v$ C* b
//Add more post variables if needed and add them to initform() function aswell
* g5 n! d. O8 {6 @) B: `, C
' I- a4 v9 B4 A' J: j
################################
% A, k) B- }# R
##### Connection and Post ######
. o# X! ^5 O/ k* U& k
################################
! b& \& U) _- s, m5 p
$name = @$_POST['char'];
" [. j4 }. S7 m; p) k$ G. u
$ItemName = @$_POST['item_name'];
s# x8 `' ?3 U( y9 r( x$ Z
$ItemAmount = @$_POST['item_amount'];
0 L7 F" _ U' R* J( u0 D
$ItemId = @$_POST['item_id'];
( i0 b, k i) a8 e) d; f
$ItemUpgrade = @$_POST['item_upgrade'];
; S, ~$ Y6 r6 J+ T9 ?3 X
$ItemElement = @$_POST['item_element'];
' r+ n$ Y) t4 N3 I6 j9 E9 z
$ElementUpgrade = @$_POST['element_upgrade'];
& y2 V4 {" g& ^1 z+ I& z$ G
$ItemPierce = @$_POST['item_pierce'];
+ y- ], B2 y4 u0 m) u1 s+ u0 t6 _
################################
W* \; s8 P" Z( _( o
2 {7 z; P: g- i2 c" U; s* ]
//Check both variables for empty value
3 a2 z( q4 [, |( N8 g: \
( K c, g* E4 Y7 [% `
if (!empty($_POST['char'])){
9 _* [4 M6 b8 k$ h$ f
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
0 l: C v1 C+ Q& M. w8 S' U
6 r3 W4 k7 f1 u
m_szName = '{$name}'");
. a5 ^1 t$ o" `8 u, t% d
while ($row = mssql_fetch_object($find)){
: d! ?; B9 V- X
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
" h- ?# T+ T; u/ P; r" q/ P% k/ B
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
* }- o7 n/ w' Z+ {+ Y8 [" h
$ x, i* u9 O5 k7 D1 H2 ^8 v
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
- G& S* ~3 Z+ Z8 z
, d: H6 N4 G6 o, ^
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% n+ l- R% O$ g; p
+ Q G$ d! ]) @" V/ Y4 I8 A3 P
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
0 a% @) S. L' |7 I) d6 r
9 _9 h0 |1 c: @% W% D% h9 e& p+ g
'{$ElementUpgrade}', '{$ItemPierce}');");
+ E6 [; r: g6 u+ x/ e% v- w
}
# I8 M& b$ t7 a; T9 I, G
% B" m# O1 ?8 S6 M. q h# G
}
# \5 ?2 k. ]% c; j
+ ]6 h x& ?7 F+ z5 y8 g
}
# |) E$ n. u" v; B" `, r
0 a* X" E2 m# r2 m7 j
$InitForm = InitForm();
* y" P" j; m a: ~1 q. s
$Listener = PostListener();
, T" {" ]8 D$ z5 f7 b d
* h0 F6 i" u% E9 P: Y1 k
?>
: S( ^% C5 r: i9 }
: _) v' C! l. d" y; v a7 o
! I) k* @" @. B' u t$ L
! b' {4 z) a7 n& o8 v! C* z: J
* w# ?- y7 x3 T
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2