飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
# K+ I9 D% P; f7 f
function Connect () {
, k) Z0 }/ L/ t% X6 J
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
7 H7 k. L9 j7 y3 m& o- t8 F
0 |7 p8 V/ P) `8 w: K( E& o3 k! A! w
Failed.');
2 a7 q$ ~/ s g' ~$ M; b5 k: o% [7 F
}
+ M) I. H, E9 h. \* v7 P
Connect();
) K6 L! k5 k- I, [* W
6 j6 S9 W: a, l5 |
function InitForm(){
% z+ t# `4 y- s ]( K5 F2 ^- C
//layout for the form
! d* u: ?8 D) x; m* a: M
echo "<strong>Send Items.</strong>
/ p" `8 N4 F0 [2 C$ ~( J0 \* N
<form name='select' method='post'>
2 t' K! u7 E3 B
<lable>Character Name</lable><br/>
* c" ~# v) t# B# F
<input type='text' name='char'/><br/>
8 f" Z' a, V7 |; W; ?
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
5 `% R: ~7 K1 v8 _* p0 w- ~. |4 D
<input type='text' name='item_name'/><br/>
7 i; }5 O) X# k9 [0 `3 c$ W2 f: `
<lable>Item Amount</lable><br/>
, @& ^' Q1 s2 X+ }
<input type='text' name='item_amount'/><br/>
0 G$ Z/ F" U# R
<lable>Item Upgrade Amount</lable><br/>
3 B) a/ |/ e" h# W; J* _
<input type='text' name='item_upgrade'/><br/>
/ j: w; H* t% p- d
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
8 B4 i" M$ f, R d3 a( }4 P
$ k1 r0 Y* o3 l' p
</lable><br/>
' p1 H' M/ x2 ]
<input type='text' name='item_element'/><br/>
& a' F" p- `5 s1 D1 q4 l
<lable>Element Upgrade Amount</lable><br/>
8 ~4 C2 Z4 P0 b# o4 z
<input type='text' name='element_upgrade'/><br/>
4 C8 ^2 ], a5 [
<lable>Pierced Amount</lable><br/>
4 p \# ?4 o; |2 R8 `* Z( m0 c4 @
<input type='text' name='item_pierce'/><br/>
) _* [. @, k7 `3 V9 e
<input type='submit'/>
- N; i% {2 D$ `
</form>";
, @7 J% Q- f4 H/ r+ d
}
7 b4 g2 o5 \: m% ^# t) W
6 y% N F4 i! g$ C
function PostListener (){
( E+ L" y9 `9 \: i( @
//Add more post variables if needed and add them to initform() function aswell
, ?" F: g: M- j* \) y! f( x
6 l: X" E1 x* g# D6 Q! M8 M
################################
* l$ W) c- K X! T7 Y& v
##### Connection and Post ######
4 y0 X( }" H+ M1 L
################################
/ D1 t; `' w2 U! {
$name = @$_POST['char'];
4 u- |+ H5 h5 y9 @' a
$ItemName = @$_POST['item_name'];
6 P, C9 v/ G% s# B8 `+ j
$ItemAmount = @$_POST['item_amount'];
. Y0 g8 l8 [0 Y S+ z! w; ?7 |8 x" g
$ItemId = @$_POST['item_id'];
1 ^! j; e J3 ^% \$ M
$ItemUpgrade = @$_POST['item_upgrade'];
# K, e/ [0 _: ~' a) r0 N
$ItemElement = @$_POST['item_element'];
/ `5 B$ l3 a+ i7 G3 [+ f
$ElementUpgrade = @$_POST['element_upgrade'];
3 s1 E/ Z# I* J5 E
$ItemPierce = @$_POST['item_pierce'];
, u. h& r8 R* M) _2 |
################################
6 V* j! p, m# L. }9 J: j0 X
) K2 J$ s4 P0 C
//Check both variables for empty value
) ?1 P$ R5 Y' [( b; }
+ w9 o, j) s4 {; p$ m% {+ [
if (!empty($_POST['char'])){
9 M8 u6 C8 m# A2 i4 o
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
2 ^/ d/ V# L4 t8 q2 z9 v2 s
6 i: b, O. h- a4 J
m_szName = '{$name}'");
1 y' D' X- d. C) X, `6 c# S3 z
while ($row = mssql_fetch_object($find)){
$ ?. s! h; [' Z1 r# {/ O0 d
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: ]7 Y/ X3 Q4 D" Y
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
/ i2 T+ G M) H
8 ~$ f5 x- q7 G
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
, m$ t' G# Z( a& j
. s9 O! h! S1 ?+ O" |0 m
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
- F$ n4 b6 C# _: V- }+ D' G4 j
3 b% h& g" e+ r8 L, |
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& k- M3 _* s" u, J7 g
6 p' c/ k" p& b! s A: Y( W' [
'{$ElementUpgrade}', '{$ItemPierce}');");
! J; z, }. c5 k
}
% O2 O( {3 ?% r3 ]" f" F, g' J/ g
) Y* k2 `* ?* d* _6 w0 p
}
# M9 y5 e4 |4 k7 s- v( B
8 W: |) O; w/ V/ d
}
) `0 J5 E" P* r6 i: |( }
+ g R' d# b2 A+ s" O4 R% U
$InitForm = InitForm();
$ b- E9 B# y" t2 {9 i
$Listener = PostListener();
" {7 w" W) D9 j$ X- M
: h# b7 G1 T3 F- X9 m* Y* e
?>
% {0 n2 A1 s7 n/ x/ q( ~
- a: d' r# R- F' [+ a J% n Q" |
+ }. p: q0 i5 H0 I& @
, z# g& U- f9 O6 I. K
! @# w5 a( j5 x/ f8 R8 _+ s; Z7 n$ F
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2