飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
: o+ x$ I# l6 e
function Connect () {
3 p+ l9 j6 i0 F. ]& x ]' Y
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
) b6 }1 n' K: [3 ^& Q
" }# u% {$ r2 G5 g' E7 \
Failed.');
( s' ~- @! I" a3 s% Z+ W. |+ |) ^
}
# a& A |/ p: `5 Y
Connect();
. k, t: L4 c3 H% a+ P6 ~
8 \' O5 Z3 P' x s3 D+ {
function InitForm(){
( B1 J& N) y# R7 M4 k1 `2 t" b
//layout for the form
$ ?7 W/ Z `% J1 i2 M! P
echo "<strong>Send Items.</strong>
% L. M) L1 M/ h- g# |, C7 O
<form name='select' method='post'>
6 i- Z2 |& p6 g. v7 S0 f
<lable>Character Name</lable><br/>
6 @5 z! ?' b- q1 z5 O& _
<input type='text' name='char'/><br/>
3 q/ h5 `* W2 T
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
4 s) {/ R V9 o5 P2 h, _0 z
<input type='text' name='item_name'/><br/>
6 }! L" P, p0 F3 @
<lable>Item Amount</lable><br/>
, |; H2 m7 ?5 E* I6 e" C
<input type='text' name='item_amount'/><br/>
# q" }$ R; b7 r% ^. [- |! ^
<lable>Item Upgrade Amount</lable><br/>
% J9 ]% K4 A+ E- [2 n
<input type='text' name='item_upgrade'/><br/>
( H; H0 b% M! C1 U1 o2 e
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
2 ]7 t6 j! O5 L2 S
" k( S% o4 T, `' ?( }8 d+ Y o
</lable><br/>
$ Z- n. H- X. }! y7 l+ R
<input type='text' name='item_element'/><br/>
; ?% K: x# L0 B" S
<lable>Element Upgrade Amount</lable><br/>
9 }9 s! W* O( d4 O1 y" Y: S9 _
<input type='text' name='element_upgrade'/><br/>
. _0 {) X& l$ ^1 h
<lable>Pierced Amount</lable><br/>
3 k2 }: I0 r; ?9 ]/ O
<input type='text' name='item_pierce'/><br/>
) \$ Z* T. S4 \6 y: N7 c! t
<input type='submit'/>
2 c% D) e6 Q5 v* Q
</form>";
' ^! A6 ^7 K1 b5 R
}
3 P, u9 F' |8 h& o
. y3 S- g' f" ]3 Y1 A
function PostListener (){
B8 _* V3 D: _) O! F2 ?% v7 M
//Add more post variables if needed and add them to initform() function aswell
& U# z A9 ^+ s0 l
$ z9 P/ O3 w6 D4 S0 _/ V
################################
! u( S/ Y' Q1 h
##### Connection and Post ######
3 V* P% H* F! B/ T9 s |+ L* v
################################
$ ]! U9 M4 z) R2 H* Y, L
$name = @$_POST['char'];
" a( [0 K9 j5 b& f# L; x
$ItemName = @$_POST['item_name'];
0 N3 M z3 @2 q2 W+ d z
$ItemAmount = @$_POST['item_amount'];
# `9 Q Z. X2 p9 ?' {9 c/ j
$ItemId = @$_POST['item_id'];
& b4 F+ | Z! M6 R2 m, \
$ItemUpgrade = @$_POST['item_upgrade'];
( `) W% H, m) e2 Y; Z
$ItemElement = @$_POST['item_element'];
* B8 `0 z/ r2 `& z, K: S/ ^
$ElementUpgrade = @$_POST['element_upgrade'];
& {+ @* y3 L2 j
$ItemPierce = @$_POST['item_pierce'];
% v2 E* H# a: H7 Y/ P! V
################################
3 e+ S- j, c" F1 \
$ q! f8 ?7 [6 w
//Check both variables for empty value
+ V$ R+ K6 U! ]) r
6 G5 O1 e# v0 h* w
if (!empty($_POST['char'])){
( m# d0 t" ?: X! W
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
' s; i5 i% l0 S3 w+ x: ^" i5 o
& y9 L' v2 {! H( J# Z7 c; ?
m_szName = '{$name}'");
( T5 Y; _% j5 B
while ($row = mssql_fetch_object($find)){
2 L" l! q: ~, K( a7 d
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
. L, l; B, e+ S
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
/ F+ b) F4 X: R% b
; b X+ J3 I7 x" c$ }% w
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
" c+ p* Y4 G- R7 u, C$ v2 P
6 t/ k; C1 Q; {' z. [; _
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
: L6 P& |& I! I
/ U( Q( C G: x# {6 j# s& k
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
2 \9 D2 C: q7 g( [! f
4 A1 S; |: s8 Z( m) g9 k
'{$ElementUpgrade}', '{$ItemPierce}');");
' F( r7 i% X5 u1 S, G0 V
}
0 J9 U( P* m" c7 H
( C& ]2 Z5 g# V9 C. T" C! A
}
& Q) u& y5 j; s3 f7 h5 s
8 m% g" I& h3 ~5 E0 `& t
}
6 q+ i9 }/ T; {. j6 Y9 U, x3 J
* t6 A8 a+ \) k4 i5 Y
$InitForm = InitForm();
/ a, e; K& _ ^; ?0 Z
$Listener = PostListener();
& X6 b+ D1 O$ j% E
! P2 g" i7 a4 C! |3 o
?>
5 Q% B" {; w! ^* k
. I$ v! Y8 t1 S, Q
. \) x0 w7 W! h4 U
0 o2 [, i2 v* e
" c$ [& i5 W( ?: r1 c
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2