飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
& d4 I; L% ]* y% }
function Connect () {
+ r. \( v/ ?( {# g# F
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
5 R! p/ t' T( O, O+ f4 o9 F
4 I) z* D3 G9 f& k
Failed.');
0 [6 Y0 F e5 U# ^
}
) L( ~$ K( m! }0 Q. [! k' _
Connect();
: ]% Y0 y9 o* a# a. n8 b& H
3 d9 R' f, D+ k# b% f; O
function InitForm(){
2 m$ ~/ d6 f' R! Q
//layout for the form
* j& n9 Q3 g3 [. m. |2 G
echo "<strong>Send Items.</strong>
& ~8 \( ? r$ x' s
<form name='select' method='post'>
3 D9 ~; f6 g0 T# t8 h: Q- R
<lable>Character Name</lable><br/>
$ K$ W. c) N# g2 ^1 X5 \8 x. G% O3 \
<input type='text' name='char'/><br/>
% g( Q. K$ y5 x& D, o* J
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
M& }, b0 |/ b o4 r& x
<input type='text' name='item_name'/><br/>
: s7 v5 _# p' ^- u# I5 v9 e
<lable>Item Amount</lable><br/>
4 e6 c8 v* Y% H4 i
<input type='text' name='item_amount'/><br/>
2 Q7 `: n- V# |$ Q
<lable>Item Upgrade Amount</lable><br/>
! m) b9 u: S) X Q
<input type='text' name='item_upgrade'/><br/>
9 ^. `2 |- \ m$ S' ?8 n; j( K3 s
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
3 f/ _) u3 m# o) X1 j
: P5 b9 m) [0 m. B+ J' j
</lable><br/>
# C, H" H8 r, w# O
<input type='text' name='item_element'/><br/>
7 B1 X+ ~2 e1 T5 a
<lable>Element Upgrade Amount</lable><br/>
: o$ a$ O$ F, V2 X( _. R0 D) A
<input type='text' name='element_upgrade'/><br/>
( H3 m3 G* D, |4 G1 n
<lable>Pierced Amount</lable><br/>
: e6 [6 B8 ?- ?2 ~7 k" w- Q
<input type='text' name='item_pierce'/><br/>
* i; t! x2 `7 {- \* ?1 Y+ i r1 g6 @
<input type='submit'/>
, C1 C2 f) T, B4 r
</form>";
/ g7 C4 a3 g6 W( F* E4 l& y/ G2 {* N
}
8 y3 m7 Z7 t/ x+ e+ T
+ @* K8 {5 M/ c" {4 p& E. `
function PostListener (){
. }5 o2 @9 v1 E8 _1 _
//Add more post variables if needed and add them to initform() function aswell
2 X; x5 p1 j$ C: e# I6 x! \# N
6 x7 d; c9 \4 R& j% f5 ~" c5 |9 g
################################
* z6 z; m! E0 ]" \2 y; i
##### Connection and Post ######
* u8 l4 T" F4 g+ U+ ?9 ]9 _ F
################################
% @0 {6 T. f. `3 f+ l/ Z C
$name = @$_POST['char'];
5 L* M8 T& {5 q& S( G
$ItemName = @$_POST['item_name'];
0 | c" p' w4 |6 U7 \
$ItemAmount = @$_POST['item_amount'];
6 K: m J9 q3 a
$ItemId = @$_POST['item_id'];
/ m2 T9 w Z. e. {5 N7 N
$ItemUpgrade = @$_POST['item_upgrade'];
/ X- U; i6 S2 j7 c! A8 r& W0 p
$ItemElement = @$_POST['item_element'];
; T* E8 h) P" S4 L! Y: ^
$ElementUpgrade = @$_POST['element_upgrade'];
7 Y5 e+ _. X( q0 i
$ItemPierce = @$_POST['item_pierce'];
) b% N1 x4 y+ L5 z7 A. Z M
################################
V9 V! b8 b9 `7 U* |3 T
I6 x' m! |! |
//Check both variables for empty value
! ^# ~- h; V) q6 P! I% f8 m
0 ]( ?3 C6 a' ^* v% h: U
if (!empty($_POST['char'])){
7 n4 A8 M# J) E+ a
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
0 V- ~0 @) y+ ~- M$ v5 M% X7 f
( b$ u% [. {7 L) i1 v& |
m_szName = '{$name}'");
+ u! P$ F( k" f! M
while ($row = mssql_fetch_object($find)){
' [: j2 Z- R. N- f! u4 v
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
! Q2 t- y- ?' \3 R' P/ m
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
! X9 Z" K8 C' b5 k" q, ^
5 l, j0 V( `0 R- b9 U5 z" k
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
% b6 A: H+ }; Y" M, o
5 d7 Z- Z' j6 `$ M; e" _; W4 r, }
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
0 g0 ~# ^# R& d7 \
! N+ K3 x: F |! D
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
9 x) X9 o0 |; i& w# X) _8 m
# K& y3 r0 _5 o& A" y
'{$ElementUpgrade}', '{$ItemPierce}');");
( I9 p/ n5 s4 z! G+ w% P( a
}
$ L5 V* H0 k7 w' w3 l$ T
5 Q. K. ^; g4 i, n+ U, C
}
5 a9 b% }# g1 T! x& l/ A* m
5 @6 ]& s ~1 T! n1 i
}
5 L2 S* n% ]# `9 b0 M- c# b7 r
, g0 Z& J! n. @
$InitForm = InitForm();
; i; G- H; G) w" P b
$Listener = PostListener();
' X! E; R$ R$ ?3 c
6 H2 S: u9 z: L: Q$ `8 e. O# s5 A7 v
?>
* ^6 x+ e! @3 E5 w/ {. F
7 e6 p# j( G+ K7 z
! A" h+ m8 a/ K" J$ I: G4 L
1 F) S) w# f+ e; @
+ h) q3 U$ C+ `* l+ F- I, x
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2