飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
( \( t5 B) v- h8 Q6 \% |
function Connect () {
# j2 }# S' Z% |2 b3 N; D! t- Y" ~
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
9 G4 p8 Z7 j$ W5 ]( A
{# Q+ j) C. S7 B
Failed.');
' l/ W0 w9 R" V2 z% y5 j. S# H- _# J
}
" W, k3 t- s7 y2 T" I( }7 @
Connect();
8 e" q0 @. F( X" O M8 l: M
4 Y6 A& _& k9 W
function InitForm(){
" W1 a) Y- ^5 I2 y/ c" i1 @
//layout for the form
+ L! c3 `7 Y* [$ R
echo "<strong>Send Items.</strong>
0 S3 I) \! Y7 y' D: G- Q
<form name='select' method='post'>
7 D' w6 F9 {# V- Q, C+ S
<lable>Character Name</lable><br/>
5 J& Q* V; f) M5 u9 y( t6 P
<input type='text' name='char'/><br/>
- E- M- W" g# G8 Q/ u( @: z8 b
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
+ N6 O1 K- `; z' M
<input type='text' name='item_name'/><br/>
) s. T- [0 c& }- _2 n2 s
<lable>Item Amount</lable><br/>
) J8 T E0 k. X. M5 E! V: \ l
<input type='text' name='item_amount'/><br/>
( U, {" d0 m/ m3 `( K8 E
<lable>Item Upgrade Amount</lable><br/>
+ D% l$ O7 p: B3 o
<input type='text' name='item_upgrade'/><br/>
5 r, z2 l. b6 @* F/ @) ^( K
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
: n/ n9 A4 s# C2 N4 R" E$ D
; y. `3 {/ Q& M- h8 C9 k5 C
</lable><br/>
7 i& D6 I. m2 r4 v
<input type='text' name='item_element'/><br/>
$ F( ]- l( G" }3 `. [
<lable>Element Upgrade Amount</lable><br/>
: B( Y( f' z& L
<input type='text' name='element_upgrade'/><br/>
3 P4 A; I e( C& [2 E) _7 J$ v0 }! ~
<lable>Pierced Amount</lable><br/>
* f6 {6 u# h9 D; ]# R- n
<input type='text' name='item_pierce'/><br/>
: b: f. J2 V+ X8 [
<input type='submit'/>
, K. r" \& d: u! O: _* A
</form>";
' ] H( D* i5 @( }9 {* d; I1 U
}
; R# I$ n G- ~+ j& L( T$ P, ~
: ]! Y0 c% p9 t w3 S
function PostListener (){
9 ]$ R- ^' E" {! Z4 S4 }& t
//Add more post variables if needed and add them to initform() function aswell
; F2 X0 W) j& h' X3 r8 F
" i. C5 g0 X7 {' \' U: x
################################
* W( H2 l/ T3 n8 m$ G; }* A
##### Connection and Post ######
1 b3 j+ c3 l2 _) J" P; N9 @
################################
# s8 L% [, A) Y N9 z" f6 k5 x. c
$name = @$_POST['char'];
3 o& ^) z4 P' F
$ItemName = @$_POST['item_name'];
3 d+ x5 w2 B9 j; }8 Q/ S& J
$ItemAmount = @$_POST['item_amount'];
8 B V+ z8 X8 W P" h5 W
$ItemId = @$_POST['item_id'];
. s! b6 |% M: }( L
$ItemUpgrade = @$_POST['item_upgrade'];
% @: F9 [8 O' Q- t5 V+ u
$ItemElement = @$_POST['item_element'];
2 [' d: {% c3 m. d
$ElementUpgrade = @$_POST['element_upgrade'];
2 b/ q: c4 i: j2 x2 }: Q7 p
$ItemPierce = @$_POST['item_pierce'];
q' ?" e9 Y/ n/ }$ o. L/ x* j
################################
1 _! D5 A5 r% A. Y
. \) f# t) ^' |! \6 F8 ^
//Check both variables for empty value
$ c8 G5 G# c3 N5 S' f. v2 P
! j* K9 \. H" z' ?' i
if (!empty($_POST['char'])){
1 D" A! N1 ]: V
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 \& `& v2 g5 u, l1 |
! q. V$ B _) e0 n- B# u- s
m_szName = '{$name}'");
7 v: F3 S: G: ?' `& W
while ($row = mssql_fetch_object($find)){
# C! g. j' A6 P1 W" O
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
0 e/ }$ h& h& W k `
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
/ k, w+ H C5 h( Y% k; r7 H
6 O g1 ]; R4 u& [
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
, i! V1 V0 t5 l% ]% G& @
3 s# E% `& a- j! J
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
% i3 x: g0 ~' p2 `# h
$ z3 G' l6 B$ K! D
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
: F& k& \9 @/ z; @
5 p$ o! O4 }3 O: |8 G# \
'{$ElementUpgrade}', '{$ItemPierce}');");
3 T) y+ E% A" t) X( A4 {* Z
}
% p9 e+ j3 J3 n
( w$ \) x! i% @' t. A4 ~
}
0 l+ H d$ }/ _- t3 O2 Z
3 Q7 E: d+ u4 P
}
3 R% Y% r( f& S3 W1 y; A
5 F: d( M, }- ^8 K2 X) }6 P6 f/ q
$InitForm = InitForm();
0 \7 w& C# `: G+ f
$Listener = PostListener();
: O' v: |# H7 [6 }- y8 S2 ^
' e% K8 X7 k* h1 T8 n
?>
: O* P+ v3 `5 `9 |. [2 v/ x
* _: T$ H1 j" o2 u# q
+ X7 i" \: ~: d7 X4 z
7 Y! g8 Q. d$ ?9 N& C; u F# _% `
; w$ L9 O! C8 M: ]6 F4 d
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2