飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
0 G3 \" r. C: A+ \7 X
function Connect () {
: S* W# D) r$ u) ?! b+ e
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
0 u8 j; ?8 J4 [3 O; _$ V
9 O" h" O+ I+ R: K/ F
Failed.');
3 g0 U4 X! `: s- @3 C* K
}
9 s! T; B! k' b6 m2 w
Connect();
1 ~& C4 A: Q$ z+ B1 r% L
4 ~' Z; q4 P9 ~1 ^
function InitForm(){
v+ F" j: |! m
//layout for the form
( ~: P. J# A1 m' o5 \! W
echo "<strong>Send Items.</strong>
# A6 W h" D/ F5 Q* E: ^
<form name='select' method='post'>
. c% j* j0 B6 E; X- B6 v6 F% H
<lable>Character Name</lable><br/>
3 \. X! X2 M$ }( W5 t! d8 q3 p
<input type='text' name='char'/><br/>
: a; j& `3 |: ~! i
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
, k& K. Q2 K4 n; T: x
<input type='text' name='item_name'/><br/>
; V4 ^) K' t+ I
<lable>Item Amount</lable><br/>
" J, j" ^6 j9 R
<input type='text' name='item_amount'/><br/>
+ W% l! M- v; ^0 R! R, U
<lable>Item Upgrade Amount</lable><br/>
4 w/ X( N& e5 \# r7 R+ I' z8 x/ }* v8 Q
<input type='text' name='item_upgrade'/><br/>
) G2 R M' w! |1 Q3 k) {! P
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
_3 \' z8 }! s3 M- r
v% N* i- A! C) G
</lable><br/>
6 a* G7 h" q6 ^ X
<input type='text' name='item_element'/><br/>
5 Z/ K6 I, A$ x; t
<lable>Element Upgrade Amount</lable><br/>
. G) f; W# @" e: C
<input type='text' name='element_upgrade'/><br/>
' n. m3 C% o1 e3 P$ `
<lable>Pierced Amount</lable><br/>
6 z% i; K0 C1 ^
<input type='text' name='item_pierce'/><br/>
/ F& b2 y% S7 o' q
<input type='submit'/>
. a$ A0 Y* D% v5 w% {
</form>";
/ r$ F. d% \$ q+ w0 g$ K+ v; u
}
/ p8 v9 z6 ?* n* Y
$ o7 ?2 s7 @- P2 Y2 w
function PostListener (){
: Q# e3 @9 o' [4 J& K# R! d" v+ R
//Add more post variables if needed and add them to initform() function aswell
9 l& `) ~. q4 Y/ b* j% J: y: R
1 n8 [ g5 `( l6 q" h$ U) v
################################
) L9 \9 e# m; h* g& a
##### Connection and Post ######
' ]: \% F: r; U& \1 X
################################
7 R' S( b7 X% Z$ {; c
$name = @$_POST['char'];
* W5 z% z6 v: V! M& q) V
$ItemName = @$_POST['item_name'];
2 n9 _$ s! R. a' [
$ItemAmount = @$_POST['item_amount'];
. J. g9 L* s% f; ~
$ItemId = @$_POST['item_id'];
) A6 K5 `- |) k. R+ n4 N
$ItemUpgrade = @$_POST['item_upgrade'];
- V2 }7 R% i& j! M9 g6 }9 K
$ItemElement = @$_POST['item_element'];
" ^0 M- \! ~( a! m7 F3 u9 j; J
$ElementUpgrade = @$_POST['element_upgrade'];
; z6 `" Q, G9 W# F$ p, S7 [
$ItemPierce = @$_POST['item_pierce'];
! F3 n e/ @* j. \0 k* q
################################
8 ^& Q j" m* W) c
" R) t, x5 P" R( s0 P1 F
//Check both variables for empty value
6 A6 }2 S8 z* O9 C* V
' C* S6 X9 `) r5 g6 O
if (!empty($_POST['char'])){
. N, X" v) B/ y( Y- n; J! _
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
$ d3 N/ d* _0 c% E3 C" i* k
$ F8 e) ~' r1 } ^" R2 T3 h
m_szName = '{$name}'");
6 f; @& m+ l) c" Y8 J
while ($row = mssql_fetch_object($find)){
2 I2 e6 T6 d' ^/ O+ R
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
. N T* Z) x6 S2 b4 F- z. Z5 V
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
* ] ]% H) `* L" D* X2 R
- F; S9 _" S8 v! A0 o( V7 J
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
) c' s. G1 X" Z# @ L- v' ^6 U3 Q
7 N d3 W7 N" i. f1 r/ F; ~
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
2 k M1 {6 b: R7 `1 Q( k" i$ _7 M
! u6 @' K) m) H1 K
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
6 u' m2 F! ~6 \+ y7 m; `
1 |8 n+ R" y- V
'{$ElementUpgrade}', '{$ItemPierce}');");
f- v% Y0 k0 W0 _# ~
}
( n# e$ l7 g9 } Q# A, ]
$ ~8 t k! u" Z( n
}
# a: g9 y* Z( u, N2 C7 j+ |6 g, k A/ K
, ~" r6 Y; ] b2 c' B( P1 I( ?
}
' Z: d; a3 ^ `% f; o
! u! z2 F' g, S/ K2 _
$InitForm = InitForm();
! b R' i! R2 p
$Listener = PostListener();
5 N; V9 j9 L- Y# w
4 h R5 k1 z5 ^2 s; U3 O
?>
6 F k7 w* z3 |# t3 z. C5 B
( g5 Z% W3 }5 Q* X
( D* a+ }7 o9 x
7 [# |# Q% \! G$ U: [
. R* @4 [) `+ _) W
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2