飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
% W# o, ^, G" z: a% X
function Connect () {
3 |4 W2 D, p. N
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
! {. f% @# D" {) G/ a# Y' d0 {
; {1 K; K5 V( G* r5 {* J
Failed.');
9 ?1 x# A' ~0 m p! I! Q
}
6 x6 Y6 \7 O) U A
Connect();
) }2 a! Z- @$ X7 y* T
- |- @( Y; z! L( ^6 I
function InitForm(){
: s! H& A' Q0 D; _* m) a7 @6 C! X- ~8 k
//layout for the form
6 T3 u4 s7 ^ f
echo "<strong>Send Items.</strong>
# [9 R, ^ G7 W# j9 k7 V1 q
<form name='select' method='post'>
, H6 C8 u4 {, `0 D9 F
<lable>Character Name</lable><br/>
W' {" l% r8 s8 k
<input type='text' name='char'/><br/>
* d* i5 a- o" d% ]
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
. Q- B# k l& ]* f4 t" }7 N
<input type='text' name='item_name'/><br/>
7 R: g1 y# S+ W
<lable>Item Amount</lable><br/>
' K$ _" f5 x8 T4 R/ N
<input type='text' name='item_amount'/><br/>
$ y6 p; [7 m: H7 [- x6 w9 ` C) t7 a
<lable>Item Upgrade Amount</lable><br/>
7 t) `: l1 [, M; e
<input type='text' name='item_upgrade'/><br/>
, W7 @! K$ h& x" W. c" V6 K
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
$ S7 t; Y- J+ t4 p; ]- \& J4 Y
. {- q) @3 e5 _
</lable><br/>
7 {0 p; @/ d5 [( \- A( v5 f: l8 X d
<input type='text' name='item_element'/><br/>
0 S t1 D# ?4 c
<lable>Element Upgrade Amount</lable><br/>
2 A2 j4 D8 r' w) P+ ^" J H
<input type='text' name='element_upgrade'/><br/>
" Y( j9 h) d1 h; Y: v& n
<lable>Pierced Amount</lable><br/>
8 n; V; C B: _- ^0 u
<input type='text' name='item_pierce'/><br/>
( z; w( q& m0 j5 N: Z0 |- L$ k
<input type='submit'/>
) y5 B% I1 ^ l% q' I6 y; H5 z
</form>";
$ m) y; O9 }) |0 i) w
}
9 |0 t0 ?: O- d% y
- R# g5 U8 S, Z% {/ a
function PostListener (){
6 I7 B7 W# q& @6 ?* A
//Add more post variables if needed and add them to initform() function aswell
- h$ _- _$ Q& h2 A$ _; d4 k
, @4 u! y1 I0 C2 I, m
################################
+ b; k) S1 l( ^- X4 l
##### Connection and Post ######
2 m5 S" S$ ~: e5 P# ?, A# _
################################
7 ]& f! T, ^7 @5 Q! Y
$name = @$_POST['char'];
( C; g8 \# t( p( I
$ItemName = @$_POST['item_name'];
2 y. ]6 n8 U( N6 _
$ItemAmount = @$_POST['item_amount'];
6 Y+ d( O$ M" v% W! C+ M
$ItemId = @$_POST['item_id'];
/ ^; r# T% V4 e& K8 d
$ItemUpgrade = @$_POST['item_upgrade'];
- C( c3 o0 {# G1 h% y3 O
$ItemElement = @$_POST['item_element'];
, P) g; M$ B4 l2 ~/ \: z
$ElementUpgrade = @$_POST['element_upgrade'];
8 p' f- N b: V0 `/ k% ?
$ItemPierce = @$_POST['item_pierce'];
- c) K; w. S2 q& q5 c' C
################################
" Z9 G" U& r/ _- d% z* y- d
9 f( m( r) y/ e3 G% l* J
//Check both variables for empty value
/ l) Q# K4 \& d# l U* C
6 _9 ]* M% k# ^1 w) a# z
if (!empty($_POST['char'])){
# h- ^9 _, G( k2 t9 \6 t" T+ Z
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
{" Y9 Z0 n+ [9 t7 @; z' X
) Y3 I/ W$ H. Y0 `
m_szName = '{$name}'");
* }! h, l# K8 p# {4 }. U( U
while ($row = mssql_fetch_object($find)){
$ ~; ]' h- g3 S* Y( r
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
4 i4 y. M5 Z' j
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
0 T) f( x4 u* B1 R
) x' j; W; i u' ^
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
2 {0 N' Q$ _, J9 b! k0 L m0 w6 d
: J* S. r8 n: G# A
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
. I! p3 m9 `/ G; S) H; {: f
! ~6 H% b" g4 j# v8 A& K
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
' r" U% q% Q- C$ I
" u9 v( ^ I( p1 h$ e! v3 {
'{$ElementUpgrade}', '{$ItemPierce}');");
/ }8 \$ M z* d" j" E3 \7 k" \
}
+ ~6 | b4 J* {) ~5 Q S& O
/ I5 p" o: Y, L% Z& ^4 `+ J, M
}
# |7 x8 b3 V0 e+ I% e1 c9 X
) K- s' f. a8 N$ U4 X' e9 h( f
}
0 |' u! ?+ f z. q
7 R1 Z" Q% H+ a
$InitForm = InitForm();
9 r$ x' u: s' T* e
$Listener = PostListener();
! z: h/ G( W4 f6 m, J
: C1 N: h" A- g
?>
4 q& F% z/ [$ O6 }6 j1 t: d9 ]
0 G" ~- B( g5 l; L0 \, A
3 l( P' p0 {& E1 t
0 O/ t! Y) [1 R% O/ u, p1 `7 K
% f D i( h/ G0 R
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2