飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
/ W) K9 S6 h. y6 t: |0 O. v
function Connect () {
% R9 p6 X* H6 T; D( V+ U9 U2 l0 L
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
3 `& t! U) e& R
. g+ S8 ?9 g# _! t8 q8 H, z& a% `
Failed.');
3 B! S! [2 z3 \: g( {
}
$ s( J0 A! U' X. A2 _0 `. f2 q
Connect();
3 t) [& X( \" U" X" T" u) X
) B( f- }9 X b) v( U1 q
function InitForm(){
) ~1 u. x7 e( |
//layout for the form
$ W7 j1 C) x" N- f7 p9 J! A8 a
echo "<strong>Send Items.</strong>
) y5 n+ v9 Y/ V) h- ]# j! q
<form name='select' method='post'>
2 v* p; y- A$ H- x% c
<lable>Character Name</lable><br/>
5 l& o/ g! P9 A8 B6 W1 I! Z( L
<input type='text' name='char'/><br/>
3 D1 Z& S4 T8 K9 Y
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
- x+ f4 j0 _- V5 Y3 G. Y. h) k% |
<input type='text' name='item_name'/><br/>
: i) d" L; j; P. _: @
<lable>Item Amount</lable><br/>
' {! m% b$ [3 J- F- O9 g
<input type='text' name='item_amount'/><br/>
& _! u$ l$ t7 d; X4 u$ _
<lable>Item Upgrade Amount</lable><br/>
, F; A" o' p6 `3 W# m4 S
<input type='text' name='item_upgrade'/><br/>
) x' e3 S* q3 b# K4 R# q
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
* p) w. u8 E3 I3 g
" Q5 c7 u- J; N3 ?2 }# j; W
</lable><br/>
& T, t4 [4 P2 ?% k: w8 P0 ]. J
<input type='text' name='item_element'/><br/>
0 b5 v" ?; C9 z0 Y- ]
<lable>Element Upgrade Amount</lable><br/>
. T& ?4 o: ]5 j Y5 Q* R, Z1 A! q6 r, S
<input type='text' name='element_upgrade'/><br/>
* F5 e6 O$ P9 U) \+ J
<lable>Pierced Amount</lable><br/>
4 o. ]+ e; Z6 L
<input type='text' name='item_pierce'/><br/>
# b9 j, _( X/ X( f8 ^. I- L, }
<input type='submit'/>
' I. m( Y3 p4 L) I- S
</form>";
9 m m& A! I+ |8 y4 R1 X9 |" u
}
" M0 d2 r, Y0 {( D
7 f, k2 X$ b% e# N; b
function PostListener (){
w# Q( H6 G4 D5 l( b* Z
//Add more post variables if needed and add them to initform() function aswell
7 h+ l1 P, m. @+ T1 C
6 P0 S* k5 J: ^& l
################################
& Q+ D$ E& A K" C+ k; \" j
##### Connection and Post ######
8 T. ?4 g& D3 P. h2 f, K* |
################################
: d/ |; ^# V+ @$ ]$ C ]* e* m
$name = @$_POST['char'];
! i! `8 n5 P( @1 ?' C$ q, F
$ItemName = @$_POST['item_name'];
( ]* A8 Y- b( p1 |
$ItemAmount = @$_POST['item_amount'];
7 s' ?# ~. Z H" {/ b6 J$ e! D
$ItemId = @$_POST['item_id'];
2 j& H. |) \7 V" @" J9 A/ }1 A
$ItemUpgrade = @$_POST['item_upgrade'];
# M9 Z! Q1 ]0 q& V) A6 H8 i0 J- Y
$ItemElement = @$_POST['item_element'];
R! `, g9 X' c* F9 E3 M
$ElementUpgrade = @$_POST['element_upgrade'];
@) a( R3 b3 v7 T: {
$ItemPierce = @$_POST['item_pierce'];
! c0 X, J: j6 X+ j; X* k1 Z! `0 _
################################
9 s z! t; D% F* S1 Y
2 t1 c; k4 A+ k( m. F
//Check both variables for empty value
' Z6 @. g) s8 }5 E) n
$ M6 `0 ?" n" ^* M5 K0 A
if (!empty($_POST['char'])){
% q; ?+ k4 k! A+ T$ J( o
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
3 `: N/ c8 E$ A+ J) C
, `6 L2 F3 @1 N
m_szName = '{$name}'");
; [1 Y) X9 G% l1 z: R
while ($row = mssql_fetch_object($find)){
0 _% R7 n5 ?* O7 S/ d; \- C/ A
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
0 |! U* d1 A! m
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
" S1 [6 `) g* v
! Y' M+ g; s# |1 ~: b4 A
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
$ p) I" j/ `) G8 Y
5 ?6 L8 r% p9 c8 I F S; E- j1 k3 T
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
+ ]# d7 J9 A8 l) _/ u$ }/ N; z8 |0 v
: m( B; {. f3 u- B# B
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
7 K& `6 D6 X+ z' @2 r
1 M% p0 t9 Z( k k, ]
'{$ElementUpgrade}', '{$ItemPierce}');");
, y" p+ o7 F' E4 o2 c' ]
}
$ m6 w" u& W, n9 ^
& @" C X% [' _6 V/ T. S; v
}
+ T0 M, B" S7 I, d" v9 @) P' O3 H. P
% h" O! x8 j/ ?6 E/ r6 g5 I9 I
}
) _+ e5 N3 I' t: a3 o I
1 D+ Q% S3 m3 g8 J) R
$InitForm = InitForm();
( K* ^7 y$ ?. a/ b; ^' a8 V1 y, W
$Listener = PostListener();
1 v1 j9 F5 x& O
/ r# M' M3 r9 n/ v- w) \
?>
4 L* `/ S6 t- t
; g5 F0 f( B+ T1 V2 G
8 ?) ?% H2 I6 e }
. O& t/ m2 m1 L3 r
. L& x' O4 w/ R5 y A
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2