飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
- s6 j2 G' X% }
function Connect () {
+ _- P& E* t/ C- S: m
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
3 l9 y2 c3 g$ z5 a- k# H2 v u
' u C" x5 a: w( @9 e" `- T3 I6 g7 ?
Failed.');
i+ z% t. ^: z& p
}
2 i5 x- s @) N- L) ^
Connect();
7 R3 R1 y$ C2 ^) Q; U# L
" R5 D# d& @* d; f
function InitForm(){
" s+ i1 p% S$ d. D; o$ D
//layout for the form
9 ~8 [0 o+ o( m3 Z
echo "<strong>Send Items.</strong>
, J/ t0 |: f+ e2 L+ m0 X# k
<form name='select' method='post'>
& Q Z7 `9 Y5 ?3 A
<lable>Character Name</lable><br/>
' T1 s; u" }& i4 ^. S: ?
<input type='text' name='char'/><br/>
5 w1 u* z7 {9 E# z8 w
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
( n9 b# A M* m W: A- B
<input type='text' name='item_name'/><br/>
! x, T, ^4 z" [( |, A! k, V. W
<lable>Item Amount</lable><br/>
7 j+ Y/ t, ]- ^4 X1 g: p [- O" G
<input type='text' name='item_amount'/><br/>
* ]' `8 X) y! u% `
<lable>Item Upgrade Amount</lable><br/>
1 q) m0 R. w! I- y
<input type='text' name='item_upgrade'/><br/>
8 R* u0 m+ S* Y* `
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
5 x( M5 k. f3 N
1 \: L! x* x/ p
</lable><br/>
+ e5 K' q) M& @
<input type='text' name='item_element'/><br/>
% }0 x F2 c' G R- ^
<lable>Element Upgrade Amount</lable><br/>
# q/ m0 K! F' K
<input type='text' name='element_upgrade'/><br/>
6 z7 ?* W; U( ^3 |, |; l
<lable>Pierced Amount</lable><br/>
( S1 O) O* N7 U" ~. z2 u
<input type='text' name='item_pierce'/><br/>
1 @& @* u0 L4 L4 H) I3 e: O
<input type='submit'/>
1 B2 J9 U7 j0 r9 Q& n. d
</form>";
0 Z+ x" k) o' D2 ?) R
}
- N6 g! k* ~; y
/ z" Z( M7 {' F5 Q% p- r/ q
function PostListener (){
6 t _$ ]) N1 I# X& h
//Add more post variables if needed and add them to initform() function aswell
( b) [' B0 I( I
& @4 t% @7 n7 j( r$ l
################################
, S4 G! P4 K6 Y% r) ?3 a
##### Connection and Post ######
3 @' `( f7 L1 H' }. ]' G+ L7 ~
################################
0 q& U- a- A/ Z$ c! ?
$name = @$_POST['char'];
" O: x, {" \% u% J) k6 t5 L0 w
$ItemName = @$_POST['item_name'];
- l( R- Q( A3 \1 E1 |
$ItemAmount = @$_POST['item_amount'];
+ p' l; ]8 W/ d* \/ W: b/ N
$ItemId = @$_POST['item_id'];
* k" ^. I+ e/ B
$ItemUpgrade = @$_POST['item_upgrade'];
% R. A' Y' C @( y9 y
$ItemElement = @$_POST['item_element'];
9 W$ |: e$ x u! d* e
$ElementUpgrade = @$_POST['element_upgrade'];
7 L4 I: M9 H; H+ ?, `
$ItemPierce = @$_POST['item_pierce'];
( k) R. w: x0 Z' b
################################
3 ?- s$ G; z0 i6 J$ C
2 D1 A9 ^: E/ o( o
//Check both variables for empty value
* G3 t0 g( w* |* ]/ f. Y
' Q, b# h% w. F4 K% b8 m3 z; b' A0 n
if (!empty($_POST['char'])){
4 ~4 b8 k& {& g0 x( l- Q
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
3 `- L4 t/ w3 k6 K
5 @5 f2 |) u- q% B2 h0 q7 s* g
m_szName = '{$name}'");
5 ^4 [" V5 P. |' ~9 H: e8 M
while ($row = mssql_fetch_object($find)){
+ D/ D! B- X3 x/ E+ F
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
* W0 g9 d: h* g5 p$ W* q
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
6 H* b2 q5 a5 }9 c) H% m
- {) } D$ W4 H* O- C
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
; j1 C$ F" G" K3 ?3 ]5 p8 I
/ o+ V) K, H, o- H) o
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
. c T0 H7 s2 ?0 Z5 o" q9 P; C, H- z
: K- F& g$ d' ^4 \0 S
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 f9 t) g6 Z. L" x S
+ N; _, V& j: g; R
'{$ElementUpgrade}', '{$ItemPierce}');");
! `; k# i( X* X. z4 U: x4 ~" O; {
}
3 X& x5 t+ {0 z# P9 w
$ O$ X( m/ F/ X7 o+ m
}
. T8 U9 e" n9 @7 r& w/ }& S
1 x0 T d6 n4 x0 S% Y9 [
}
& U7 D; I" v4 }0 R: F/ |
( d( ?1 M: Z( ~. t0 S4 K6 ~
$InitForm = InitForm();
" w1 h4 F/ _" d
$Listener = PostListener();
3 l; }9 ], m9 o
. H7 O! ~* N8 G& f: q- w) S) i
?>
' p: [" N. Z* W' `2 `
+ V$ o! z7 p' @: { e5 E( g8 g
3 y: m8 `( V0 e# {+ T3 s. b
+ _; g+ |. Q2 z, N4 H; k
, }9 D- Z7 h7 M2 O( a. {+ L$ s
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2