飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
9 F! l8 Q& _* z* n
function Connect () {
: K% L5 m0 c' s0 [9 m k& x8 K
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
' b: u& c' m5 s ]' p/ m9 `5 J
/ X, r$ U. H9 t. P7 X& j5 i
Failed.');
$ M. M6 _3 I4 p1 k
}
# A1 Q; N2 j7 S% E
Connect();
4 W! l5 a' p {0 u y! t+ s' K
& f, D2 f# w, m& d
function InitForm(){
% ?) N$ T H" @ ^' _& T
//layout for the form
* K$ ^- T5 t9 t1 t2 k
echo "<strong>Send Items.</strong>
$ H( K% z l$ \" C
<form name='select' method='post'>
2 m: [( q) U) [+ ?- p" e
<lable>Character Name</lable><br/>
$ L. s2 {+ |' O! B6 G
<input type='text' name='char'/><br/>
t* N, X& R F! T. N
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
# }/ \+ T6 a6 k
<input type='text' name='item_name'/><br/>
8 c+ K T% f0 d
<lable>Item Amount</lable><br/>
" D$ U" _5 t6 U4 a
<input type='text' name='item_amount'/><br/>
6 H& B& a3 ~' i" |6 O; N* m
<lable>Item Upgrade Amount</lable><br/>
& t: Q6 x! }) J5 Y5 ^0 |
<input type='text' name='item_upgrade'/><br/>
/ v2 _$ X8 E& Z3 c W! H1 K; N
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
+ J; R% w9 k3 @/ E, R
# q) R5 c7 A0 n$ K) l- [
</lable><br/>
- E( ~5 a! o* V2 n0 i$ p
<input type='text' name='item_element'/><br/>
; i' ^4 x+ m1 s- J& k& U% @
<lable>Element Upgrade Amount</lable><br/>
) X- @. e9 v% w3 z
<input type='text' name='element_upgrade'/><br/>
2 Z' p3 M% g3 G9 l, r6 @! Z! z0 }8 r
<lable>Pierced Amount</lable><br/>
P9 }6 _( _# n
<input type='text' name='item_pierce'/><br/>
9 N" m& n6 \. e7 P# n8 ]
<input type='submit'/>
) e7 _4 ^; e2 J0 P
</form>";
9 V! K+ Q" j5 I3 W" f; s
}
6 q7 p) u9 Q1 S5 m3 A- J7 D6 z" T
6 D# s" F) o6 g
function PostListener (){
# a4 c4 \4 n2 ^9 }
//Add more post variables if needed and add them to initform() function aswell
5 P& P8 v' y) k& a( n) _* n
% P8 o; s! Z" ~9 Z" ~
################################
) ^" K! j3 S1 W
##### Connection and Post ######
7 K6 u. Z o$ F$ n+ R, u
################################
: i- z8 ^0 M0 `( i
$name = @$_POST['char'];
/ W. ?. l: V. W" m$ I. t& U8 _
$ItemName = @$_POST['item_name'];
" a5 g/ C/ S9 M
$ItemAmount = @$_POST['item_amount'];
7 m3 j" W0 H% O1 y0 i' x* u, _
$ItemId = @$_POST['item_id'];
5 Z, ^+ ?" N9 K4 H+ `0 P
$ItemUpgrade = @$_POST['item_upgrade'];
8 n4 Y6 ]* J6 O( _" y) V
$ItemElement = @$_POST['item_element'];
% ~* }' l& l1 |4 |+ ~
$ElementUpgrade = @$_POST['element_upgrade'];
* o* u0 F7 I- f9 d
$ItemPierce = @$_POST['item_pierce'];
/ x4 `1 ?3 D' X& v5 e
################################
& G( h% Q2 }5 D
0 {5 e3 G) Z2 Y! H+ O( |+ I
//Check both variables for empty value
% Y6 R$ Y. S+ T. |% I, i) u+ e
4 h# P$ x$ B& [" B
if (!empty($_POST['char'])){
$ c$ z, l1 o) T0 ?; j. [
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, ?6 j8 l3 c9 J- I
- ~6 w+ V! {) N' D
m_szName = '{$name}'");
2 @6 ?& j. j' Q$ [, N! K
while ($row = mssql_fetch_object($find)){
% j0 I: H$ ?; I3 G- h6 C
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
0 S1 a% Q/ O4 I2 c- e- A" R
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
5 s4 j( h& T) U9 y. D* u" B
% |+ x3 D& e: C6 ^
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
5 z3 T) l1 q. O' N
2 @1 _1 F7 Y2 ~3 I
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
# [# K9 j0 ^" ^% ^! u* m7 k
8 A: Z; c; c) Z' {6 }
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
H' ?0 D! s0 _1 c9 _: Z% G- h
, w1 C0 c8 X9 q' Q
'{$ElementUpgrade}', '{$ItemPierce}');");
- Y; @; @% }( Q! t6 `( d
}
" E3 d9 v& E# A) G# s0 ~2 Q) m8 P) n
- p7 k6 F& o, [% w
}
+ p4 b0 e9 \9 N1 {
2 V5 c t4 e8 B. _* J9 B8 _
}
, K5 O: Q. `& L2 J1 u
6 o; r7 I- T2 B Q0 E5 j; G
$InitForm = InitForm();
! h. J$ o9 ~; j; j5 I3 i0 b
$Listener = PostListener();
& R |. C- z0 r" e9 ?- l
) g: W9 L3 r( `3 B0 X3 u8 G W o
?>
+ E2 p! W& X3 _, L5 O
p' }+ r- P. e" i; a5 H
( m6 @* u t% d! |9 \
& V& c3 P! ?- g- P# ^
+ j* f i: _! @2 x$ z
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2