飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
0 y' ^; ?( K/ y( I9 ^
function Connect () {
4 A: W& `, K4 y- _- T; g4 O
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
- v/ d9 i l# r, }* C# e( c
, Q6 l* w9 o; e( a1 s
Failed.');
- j5 p/ P8 h) e( _4 w* j' c
}
# [" |0 E+ X7 [7 W T0 e
Connect();
/ h, }6 j7 u! T( N
7 o( F. L5 r4 ^- [" E4 a2 B
function InitForm(){
2 G3 h; G9 R" v4 d0 _
//layout for the form
, H1 Z! R" P. w c; Z/ \
echo "<strong>Send Items.</strong>
5 a5 w5 N7 m$ S: Q$ M1 [
<form name='select' method='post'>
0 G M" e6 H& q9 f7 W
<lable>Character Name</lable><br/>
, v! l7 ]! n# j% k) h
<input type='text' name='char'/><br/>
3 u" b" E- ^/ T3 x Z/ H6 L
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
* q/ z% f! k$ Q" P2 G: R) P
<input type='text' name='item_name'/><br/>
8 m5 _; f. u" p% R A# y
<lable>Item Amount</lable><br/>
9 u' c; I' h* Z$ i$ n% w
<input type='text' name='item_amount'/><br/>
@, t+ W. ~5 F/ z- X
<lable>Item Upgrade Amount</lable><br/>
+ H& W" V& _- j
<input type='text' name='item_upgrade'/><br/>
' i1 V' R1 P1 z
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
a5 o5 Z `3 J- l! Q0 F% C+ B
& e5 I" T6 G' J" z
</lable><br/>
# |% H. X! t+ v" S& |; ?7 \; @$ ^
<input type='text' name='item_element'/><br/>
; B4 Z* L* G0 e9 V
<lable>Element Upgrade Amount</lable><br/>
* P3 r, }+ ^! @$ P
<input type='text' name='element_upgrade'/><br/>
2 }$ R9 x7 s" @( Y7 \
<lable>Pierced Amount</lable><br/>
" v0 w8 l- `( Z9 Y
<input type='text' name='item_pierce'/><br/>
8 G4 N4 a2 F, S7 i* f8 j, {3 q$ b
<input type='submit'/>
' I5 h) s6 ?6 s6 z
</form>";
Q2 h5 C4 K' G4 } F: H
}
# p& ~5 x' ^' Y5 {# r7 s
- ^( I; E# E/ [8 v+ z
function PostListener (){
/ _! e. E; h3 c+ C* v, c4 q
//Add more post variables if needed and add them to initform() function aswell
% E: b W4 H i& }2 G; S
6 N: O. K' S$ J/ L" \) M9 p
################################
) s. L$ @; x6 K& j' Y$ o
##### Connection and Post ######
5 h0 `3 j6 H3 H) g b
################################
- Z7 e( S3 t9 n7 |! ~* \. R
$name = @$_POST['char'];
! D( |# K& h9 j: Y6 N \
$ItemName = @$_POST['item_name'];
7 f1 }$ c8 i q4 u9 q/ t
$ItemAmount = @$_POST['item_amount'];
+ q; C1 } {9 a8 C) U# Z! c
$ItemId = @$_POST['item_id'];
; S1 }( P5 K5 T6 z/ @0 \6 d
$ItemUpgrade = @$_POST['item_upgrade'];
; T/ w- \5 [, [
$ItemElement = @$_POST['item_element'];
4 _5 \- M8 z- u
$ElementUpgrade = @$_POST['element_upgrade'];
( B% x" o% l; U4 x3 g6 Z8 ~
$ItemPierce = @$_POST['item_pierce'];
+ V( d$ L# R& F- _' Z
################################
9 c! S9 {/ h5 { Z2 Y4 ~) ~
3 L. D# i8 `: M8 ~1 |- `1 T
//Check both variables for empty value
0 d* Y9 J u Q" T1 l6 C& t
. K( Q2 Z0 }! D9 I' L
if (!empty($_POST['char'])){
! [& P7 Z# V p/ v& P- f
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
# Y6 S$ k) U- x' b; x6 q
6 N% A( C5 [3 J1 y2 |( I
m_szName = '{$name}'");
7 k9 q4 `* |/ x3 `# B5 T" z
while ($row = mssql_fetch_object($find)){
8 ^0 Z6 l+ |; ?5 W! m$ y
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
9 F( o) f! R" `
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
, w( g: V- P/ a k7 Z) j
; h! n. j) e4 e
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
& d! K2 O# h. [$ e+ _5 k V
- q# k1 X+ h- C( @2 j
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
1 W' a2 t2 f# b5 L: x$ m
9 Q$ i. \2 n) ?5 V) P7 H; ^" w$ z
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
! |4 f! ]+ [6 [0 _+ W. [8 V6 e
* n( ^/ U/ l( O9 M2 e: v
'{$ElementUpgrade}', '{$ItemPierce}');");
/ s3 l P1 m# G$ y7 N" U! C
}
Q r, C2 R6 I- D- u
% v% \% e& E$ I/ \1 D- r7 f8 Q
}
3 O1 x* n$ S0 ?' [! g, T+ N: s& e
6 e+ r8 w" p$ a9 B: b
}
C/ o4 H. n7 V8 O5 V
) H6 `% U5 ^! w
$InitForm = InitForm();
# r5 E( h% N$ o D4 N
$Listener = PostListener();
" x/ c; Y; u$ C* z9 A4 U) }; K
' X% {- w3 n% u
?>
5 |% i7 f7 \$ C6 c
3 X+ O3 F6 z$ y7 r# B
, }+ j' E0 X% ^2 \/ N0 q4 Z
' F. L" @8 C: r: D6 H; \
" z- @/ d# W$ {. Z& j
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2