飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
7 b& b5 G- x) y2 b+ a
function Connect () {
: ?8 p; l* G8 S
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
8 O+ a. j6 J* B7 g- ]; w' B% J
; l# D5 p. ` I9 ?, Z+ n8 F
Failed.');
5 M- }8 F. Q. {
}
/ V( H. _% D. d
Connect();
3 h% w$ r& t7 w; h9 u5 R
E' G8 p, c3 s3 ?" P7 s3 e
function InitForm(){
4 m9 i" M4 p7 m m
//layout for the form
, G% B# S( B" _6 R8 R/ |
echo "<strong>Send Items.</strong>
8 M, z2 h1 M8 T1 c& f
<form name='select' method='post'>
% A" i1 ]( ]5 e) P [2 {! [, F
<lable>Character Name</lable><br/>
, C/ Q. _4 D" A
<input type='text' name='char'/><br/>
$ b$ C' J- Y: N! j2 d2 i7 \
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
1 V, i1 u2 f' ]9 F) T. j0 R
<input type='text' name='item_name'/><br/>
1 L5 a+ D: Y. F+ }! a' N, P: _( U
<lable>Item Amount</lable><br/>
" K9 u1 k! ?+ n: C0 G6 @: v& [
<input type='text' name='item_amount'/><br/>
; i/ p; b6 h4 J
<lable>Item Upgrade Amount</lable><br/>
+ ?. a) S. ? A( r& @; j
<input type='text' name='item_upgrade'/><br/>
! i# M; A; k2 f# V7 e
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
O) { p4 B5 `, i
9 a0 c2 b6 m- _( q% Q" Z
</lable><br/>
+ H- [. k8 q7 Q& S! k9 C
<input type='text' name='item_element'/><br/>
! q2 P& u5 u0 l5 @
<lable>Element Upgrade Amount</lable><br/>
; S7 j1 V5 a7 g. X0 a8 K% i. z
<input type='text' name='element_upgrade'/><br/>
' d* {0 I! F4 C* V. z- ~2 W
<lable>Pierced Amount</lable><br/>
& Y4 w( R3 c) @' r, [9 t
<input type='text' name='item_pierce'/><br/>
1 g: Q0 V3 v* @* W1 v
<input type='submit'/>
; U: f+ p6 `2 n* \
</form>";
' a* _- [2 g6 C% h- w
}
& i# j- j8 y1 w' J
; N& @6 s8 Z# X3 I& A
function PostListener (){
- J% \1 X' v) F t6 z1 h+ F
//Add more post variables if needed and add them to initform() function aswell
1 ^; j; ]+ e8 v$ e
) f- m! H+ _# J& R$ v; X0 g9 c4 r
################################
* ? f! V3 H6 U% a2 M
##### Connection and Post ######
7 j0 H0 ~% [' K1 C/ H0 ] b1 w$ n
################################
* ^! l- p& {3 o; P( K4 _. ~3 W
$name = @$_POST['char'];
3 w6 X0 i! S2 R/ w0 C/ p
$ItemName = @$_POST['item_name'];
) e" [$ V( B, v- c" P
$ItemAmount = @$_POST['item_amount'];
( D( r2 f* r/ A2 y
$ItemId = @$_POST['item_id'];
" i9 z' F/ C9 M" @- W
$ItemUpgrade = @$_POST['item_upgrade'];
) c# L- H+ K' R
$ItemElement = @$_POST['item_element'];
8 D$ N$ `1 @/ G
$ElementUpgrade = @$_POST['element_upgrade'];
0 I$ F7 _8 }5 R5 ?0 g# A& B( M
$ItemPierce = @$_POST['item_pierce'];
$ Q3 u- Z. k. m* M5 y
################################
8 p, D7 {+ O x2 B( r: V
3 h8 d; A% R* o( o& S
//Check both variables for empty value
. T! L0 a5 V# i& b# K/ P
0 e. |0 n y0 T9 j- s+ k
if (!empty($_POST['char'])){
+ p/ S. S! @ X, T3 k5 T
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
9 ^1 l0 O, S2 s( P. N
* s% j5 n6 ?. Q! V/ s0 P/ L
m_szName = '{$name}'");
" F( M; K0 U6 z4 ^/ ?
while ($row = mssql_fetch_object($find)){
5 e! l9 d( e* ]# {- @
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
1 ?7 T6 \9 v! V- Y
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
( z% I# X; C$ M+ V( x, P: R
: L% P" e; ^8 k9 E |/ g
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
; M6 v% E5 R* Z+ z
* h' N% _8 z Z1 n
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
' l9 j' u7 H4 F0 j- t) D
9 ?5 C. d6 D! N% o0 W
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
9 W) j. Z4 Y/ J0 O
% h! z6 |) `+ }! Q; w' c3 d$ W
'{$ElementUpgrade}', '{$ItemPierce}');");
- ?/ k( N' q1 R1 U
}
5 ?4 a: S1 E8 P+ @ }+ D. y
- M( _$ C1 A9 Y; F0 D! M* T
}
+ {# ?/ v6 S1 M( a9 _
& }0 A9 `: J/ z- e8 D3 _# Q: Y3 A2 M
}
$ |/ P3 `$ Y i' q1 {
; [8 I6 c6 U: d6 x: P% ^; @
$InitForm = InitForm();
# N% p% {( x; m& i
$Listener = PostListener();
" {0 Q C) H6 i! {- h
/ d4 L$ B( T4 x) t! \
?>
' \8 [+ @0 f# O6 Q, R+ p9 D& e# t
, v% I( a; i4 g/ d$ W
( `' Z/ P2 k1 L0 f
! j0 d0 T3 R, z
3 I" l: B0 A+ X9 Y
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2