飞飞世界论坛

标题: 物品发送脚本 [打印本页]

作者: admin    时间: 2016-1-10 03:43
标题: 物品发送脚本
<?php
. r* `) h. X4 ^& g+ `function Connect () {
! L$ i- H" Z# Nmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
: {% t, D; G; E' p3 I6 S; ]+ ?7 o. K! y2 \$ P: E) Y
Failed.');
" @* p1 D& f4 J  j9 ^: C# g}5 b6 K7 k4 o1 z2 Z* A
Connect();1 @, z" c1 A  Y: o1 w

# M9 b) f* i, y) M% wfunction InitForm(){
1 B! Y9 R& Z4 I# J5 a//layout for the form$ U4 W2 Q/ A% M3 q9 x2 E# M
echo "<strong>Send Items.</strong>
$ W1 u+ @( u( ^1 f- H<form name='select' method='post'>
: u* q. b  ?3 y: z4 G<lable>Character Name</lable><br/>: W7 l3 H1 V% R& A2 i
<input type='text' name='char'/><br/>
! [) I8 }6 j6 r<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>& G; G. t* z/ j( T
<input type='text' name='item_name'/><br/>
! A/ f4 A& f; u! ~<lable>Item Amount</lable><br/>
" s, D( e* a3 X- l" J6 X' f<input type='text' name='item_amount'/><br/>
7 z, }/ }) k" r<lable>Item Upgrade Amount</lable><br/>
1 q$ N/ R/ L3 H6 i  v<input type='text' name='item_upgrade'/><br/>4 l# G( x2 Y& y% o) d4 B5 s
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
0 [' P5 k$ u; J5 n
" t: A9 q7 x' U</lable><br/>: e7 K8 y0 ]) y. E
<input type='text' name='item_element'/><br/>
; _) G# T. \" I5 E4 q<lable>Element Upgrade Amount</lable><br/>; X5 Q8 @; R9 U6 S" e! {# B$ M4 w! {
<input type='text' name='element_upgrade'/><br/>
: P. e- V6 x' W) q<lable>Pierced Amount</lable><br/>. Q; u2 o- l. _7 ?3 b6 Q% l
<input type='text' name='item_pierce'/><br/>/ |" z$ n9 W. X5 x8 P- a6 z# [
<input type='submit'/>
5 x7 h7 `1 |+ m5 n' e+ x</form>";- S( [) Z: Z- p& |) ~9 h' W
}/ y/ ]5 C( M0 E
, k# D( ]; Q2 E
function PostListener (){
. W% ?. ^# S& p" R9 F//Add more post variables if needed and add them to initform() function aswell5 S3 v; h! s  G) Q: l

# w" B2 z" J$ U9 T9 ?################################1 x' y, a, A( L6 o
##### Connection and Post ######
# l6 B& B  T8 y6 m  S4 F7 ]/ }################################$ X/ }" D2 G* I' _/ e
$name = @$_POST['char'];
2 P4 ^. \" E. _$ItemName = @$_POST['item_name'];
% o' f9 {  v" [/ B$ItemAmount = @$_POST['item_amount'];
- K5 p! X% l" @: F; q- z$ItemId = @$_POST['item_id'];
9 b3 _8 \" \' b9 o+ ]- u, j' r6 j% u$ItemUpgrade = @$_POST['item_upgrade'];1 b8 g+ E$ @. y+ A0 S
$ItemElement = @$_POST['item_element'];
% z* Y* g) j2 P, i$ElementUpgrade = @$_POST['element_upgrade'];
% C1 m' i+ c% K/ d0 a7 O) C6 K- E) u$ItemPierce = @$_POST['item_pierce'];9 \; E% c- F7 R/ [  L
################################
3 H3 B$ D" e# ^5 _/ O* ~: A. [3 b6 V: N  u2 U8 _4 _% ~
//Check both variables for empty value
" W! c! m9 ]( z1 I* J2 i1 E, f4 t$ j3 f' k: l
if (!empty($_POST['char'])){
6 ]+ t# S& S" v, @% Y$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where / K' H. O5 d/ g2 J, t# l
; Z' B6 N. i5 b3 [. E$ P  l
m_szName = '{$name}'");
9 s& [* q) i" `# iwhile ($row = mssql_fetch_object($find)){
' c! _# J6 d5 w0 o, b! kecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";. S* ?3 }2 g  M' O9 G# k
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 8 X. @. v! v- I& {
' X5 v! a. o6 ]' V3 q* a( f4 K
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
1 @3 U" x3 _0 z# o. p/ v" v, F9 j
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', , v0 A+ ]7 w1 B+ j0 D5 g

7 h& T2 n# C+ K2 W' MN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', " t9 @2 G  J3 v& d7 f) {" U
; O2 ?! S, ~# T. u2 R) i
'{$ElementUpgrade}', '{$ItemPierce}');");
9 U4 N" m+ T- Z6 V+ I  |}
. K+ \# j& L$ o9 F/ D
* Y# J% K6 @: q0 w, E: \# x# l}' z. D/ `# Y3 v. n# j
: v1 B3 i( N' z* f$ v8 M0 ]' r# X
}
; X# j$ s& L7 a1 x( E/ H5 P! J7 Z# I/ t: Z7 ?% e0 j
$InitForm = InitForm();
6 L* ?1 q4 i# U2 h6 h8 a9 M: _$Listener = PostListener();+ V$ T; ^2 g: {- w
8 N  F8 J- ]2 M+ E$ ?' n
?>
' x; x+ w, E) A6 r, r0 l3 z( k* w  b1 a* |* |& Z( e

0 m+ M/ U+ }1 P, K( o! f/ o. v  p4 F8 L% }

1 N# `  `/ q- D( V4 `




欢迎光临 飞飞世界论坛 (http://www.ffwold.com/) Powered by Discuz! X3.2