飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
$ B' j# l! ~& b. f0 [
function Connect () {
8 @$ C6 B3 O1 `" W6 d* U! b9 U
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
8 a6 G. P5 I0 C3 f: E
3 L0 g2 W3 z: R. N" Z- d
Failed.');
$ U) H: ?9 [/ B% l. g6 y# n
}
5 M% @- T+ P5 _
Connect();
9 Y' m |) t8 c, [9 A
" l( `2 y7 `* ^+ k
function InitForm(){
( W6 r: ^3 Z8 R2 t& u" Q7 w" ^
//layout for the form
( l1 h( M$ X& w6 H
echo "<strong>Send Items.</strong>
: L% Y' ^7 D: h, y) I
<form name='select' method='post'>
6 A% d. c+ X, m& @& M& y& s
<lable>Character Name</lable><br/>
% n7 Y0 j; z9 V; Y
<input type='text' name='char'/><br/>
6 [+ Q) i' a. @3 n, B2 t+ g( L4 d: I
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
+ N8 P" q" z: s* {8 Z' g. [# l
<input type='text' name='item_name'/><br/>
* x7 b$ P" |7 P
<lable>Item Amount</lable><br/>
* F7 E0 t, |) \$ [% L
<input type='text' name='item_amount'/><br/>
8 H. C. X0 d4 M2 X) S; X: `
<lable>Item Upgrade Amount</lable><br/>
3 S! v7 _# M* s8 s
<input type='text' name='item_upgrade'/><br/>
8 g2 r. W7 b4 U0 U g8 T# p
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
" Y" G+ h7 T; S
/ T8 O; X; [3 z9 o0 ]4 j. H
</lable><br/>
7 a, y0 Y5 O; E8 J
<input type='text' name='item_element'/><br/>
! h0 A% T0 m1 Z' @4 P9 @$ S
<lable>Element Upgrade Amount</lable><br/>
, z1 V- c7 G- W$ h, i# t
<input type='text' name='element_upgrade'/><br/>
. F m' y2 ], r$ S4 v- a, o( H
<lable>Pierced Amount</lable><br/>
# v9 A; ?1 f1 b; v/ J5 f8 p% l
<input type='text' name='item_pierce'/><br/>
6 o% S% w& D, w3 |
<input type='submit'/>
* b4 M6 e3 ^- t+ d o. Q
</form>";
+ r+ [$ N$ y6 |# T- O
}
( K, c- p# g+ V% q8 u ~
/ c7 B" X1 \' p% s; j
function PostListener (){
$ z4 E9 C1 N' _: w" Y" X
//Add more post variables if needed and add them to initform() function aswell
/ m! c3 T" \, l
( Z% W" |4 V- y( P, U
################################
' N9 E+ x; N* ~* A
##### Connection and Post ######
, S% A- X; @2 P! \' t1 [
################################
1 L# [6 K! H1 X0 i
$name = @$_POST['char'];
% @. y. z2 P7 y+ \
$ItemName = @$_POST['item_name'];
. B0 u% m- J' B3 J% w5 A: {) G# S
$ItemAmount = @$_POST['item_amount'];
. ]2 U8 R4 z: o: F! E" C
$ItemId = @$_POST['item_id'];
8 m2 f+ ~2 b; H4 d' ?
$ItemUpgrade = @$_POST['item_upgrade'];
4 H( w9 J1 V A* A1 n8 ?* \
$ItemElement = @$_POST['item_element'];
. P0 a8 o: |; p0 q* X! V2 s
$ElementUpgrade = @$_POST['element_upgrade'];
8 ]4 W& m& J; P* L0 R
$ItemPierce = @$_POST['item_pierce'];
0 Q4 _ g ~ R6 n( r
################################
8 `+ X( b8 K3 ~8 p7 U( t* F. s/ [( K
+ x3 Y" N: s& J/ f, j: L
//Check both variables for empty value
8 ^: O9 l/ Y8 a& b+ l: t
|1 C% z% ~6 Q& q
if (!empty($_POST['char'])){
5 |) j: P' ]; d: m% |9 G" M1 A
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
0 |2 r6 w0 u* o; ^# f/ X
# C& N6 e0 ~7 i! H/ P: ^
m_szName = '{$name}'");
/ f" D( N2 W8 K4 A+ {* Q
while ($row = mssql_fetch_object($find)){
# O% V+ i8 d9 B
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
& d% M$ f8 y+ R' f M1 C
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
( N! [4 J. E9 B: x- g
5 c- m! B! x6 q1 t2 c" g5 g6 e
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
7 @( h8 Y# U+ V& p" Q5 A3 ~
4 r+ J7 E0 w' n1 L6 r) U. ?: x
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
2 m" O3 U- {. M2 ]# w, K
& s3 K+ W. f4 n; A3 f. u+ j
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
( _+ p; A. x/ ~9 A. ~1 L/ h3 c: f
& y- C: M: L Y3 I1 @
'{$ElementUpgrade}', '{$ItemPierce}');");
8 z5 q$ l5 c, o u3 N$ E
}
2 u1 H" h5 [3 b1 R0 L) l b+ `
6 `( a5 n7 S) V8 Y
}
G' ]( T- e6 a# L9 p7 x3 l
8 F7 b9 q2 i o9 @7 y* E* \- g
}
5 Q9 Q4 u i6 e( e
2 V3 c4 |3 @! |
$InitForm = InitForm();
' o8 A1 t) S* h0 d
$Listener = PostListener();
8 `) k8 i$ _# w* B8 f7 x4 {
2 }+ T# D1 b/ n0 o, B: n
?>
8 M' z1 Y9 [1 V
; M# U/ X! l, Y3 P% N( H+ D
7 V7 a O% {& R6 @
2 L8 s6 ]; x1 O9 z+ g
5 _ E$ s. D: v) | _ |# O
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2