飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
7 Q5 R4 h# W# w# q/ B0 @6 V" _8 J
function Connect () {
1 M+ g6 y9 e0 f6 N4 ^( A+ ~
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
; u4 `& X1 B6 S* q, N8 s' ^8 A
/ E9 @" P. T8 u! V5 @" t+ ~/ Y
Failed.');
5 Y4 ]1 G( W' z" R6 k
}
3 R/ N$ {7 a0 Z" B4 e! m- Z. s
Connect();
0 n1 n8 Z/ s1 o2 X+ T. Q& w6 {+ A
3 A _, o7 W; h: e* q1 u* k2 ^: R
function InitForm(){
5 ?; F \8 Y, C+ W
//layout for the form
: h, M# W% b# O7 X* ]3 I' t% h
echo "<strong>Send Items.</strong>
, o* @; G$ u8 O. A
<form name='select' method='post'>
% q* X' H p+ d: y( U9 f) A5 w
<lable>Character Name</lable><br/>
( h+ T$ f2 C2 p
<input type='text' name='char'/><br/>
d% q7 U$ h# j0 a) \7 E
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
. J( H# U1 `- `. j' r
<input type='text' name='item_name'/><br/>
3 U' m& w/ x3 s9 G1 B( d
<lable>Item Amount</lable><br/>
& n) O5 ^: q$ Y' a- q; r* k
<input type='text' name='item_amount'/><br/>
( p4 c, v0 z j9 ~
<lable>Item Upgrade Amount</lable><br/>
) G* V8 g& N- {) i
<input type='text' name='item_upgrade'/><br/>
6 g- `7 v0 [, k/ F; S! S
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
[4 ^: Q7 ^3 V* E# K" Z- c7 e
7 ]: | Z1 ?4 @% c0 S& N
</lable><br/>
$ e1 ?. F* W! b$ u2 ^6 e7 f
<input type='text' name='item_element'/><br/>
' w h2 D E; i5 P: h
<lable>Element Upgrade Amount</lable><br/>
1 t9 p3 c$ m2 M2 R. C
<input type='text' name='element_upgrade'/><br/>
7 d1 N' F" L! \# z5 ^( c
<lable>Pierced Amount</lable><br/>
3 n& ^1 b# z2 s1 a/ n
<input type='text' name='item_pierce'/><br/>
5 l5 h7 k! [; }9 h/ y
<input type='submit'/>
5 P! W4 s. V4 x8 m
</form>";
% M, D7 g0 Z! g K z
}
7 k& i' p1 d( O8 t
$ w4 _6 L0 n6 B
function PostListener (){
" `. V6 [8 \; T8 A+ X1 F' w" n
//Add more post variables if needed and add them to initform() function aswell
; A, [( L/ g- T, o
$ a! e0 Y5 |# Q: J, K
################################
$ H* e8 X. E2 J Z' \( D% O/ _, q8 r3 u
##### Connection and Post ######
* l2 R! E S% O2 }5 I- r5 t
################################
W) L+ @: U# h9 b) [) y* E$ N
$name = @$_POST['char'];
0 C! l' N7 S6 x! ^1 m8 r
$ItemName = @$_POST['item_name'];
6 i9 w1 ?3 b. s- M F7 C
$ItemAmount = @$_POST['item_amount'];
- i w) g1 ?+ k
$ItemId = @$_POST['item_id'];
$ P9 w6 v, N' N# j+ D
$ItemUpgrade = @$_POST['item_upgrade'];
) {! {( `" Y& r0 l( g' L
$ItemElement = @$_POST['item_element'];
* @ }' e" ]5 j
$ElementUpgrade = @$_POST['element_upgrade'];
9 X6 U5 b8 G0 k$ Q0 }
$ItemPierce = @$_POST['item_pierce'];
" K: h, ~/ |+ t. b: Z) r% F# f( Z
################################
) }, @, J* C" ]0 B$ p" X
; s9 s0 w% L3 N: C ?, H2 T! v% [
//Check both variables for empty value
" `6 R9 [' S8 w$ M% V
[& D5 F- g6 h) ]6 J( [4 @
if (!empty($_POST['char'])){
1 R2 q2 o8 L$ q' b) U; P c) K
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
; O/ i0 a8 n6 l; Z# \# H. t$ r' W
5 \0 Z: O/ ?! d4 L0 v8 T
m_szName = '{$name}'");
" F$ h& |- C3 p" x7 w# f, r( b" W5 f
while ($row = mssql_fetch_object($find)){
! Z& p/ ^, h$ U3 t5 k% M) `$ F
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
- U% B0 @) u. v( V4 x2 ?; O+ w
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
- H- @" u6 F1 }
9 t, P+ V1 N I# [) S
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
. B7 v0 P2 N# h% f R9 h
( z( q7 Y2 T) b* p4 X+ j' ]! G- Z
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
& d# G9 p$ O* U
9 G' u( L7 c$ C8 W% ]7 u+ K
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
2 J' |: Y' z* b7 M0 u
3 m' _$ H' f. G3 L7 ?: V8 ~
'{$ElementUpgrade}', '{$ItemPierce}');");
9 l- A& m3 t F; h1 w, N& b7 f! k- p6 ^
}
3 M* n9 Q; c+ B) h6 ?6 }7 t: u
# c* Y7 f) @+ D9 q9 c
}
' e2 e, N1 r& Q2 u, T4 K/ v/ B3 c
$ n% {. J. @$ `$ t _
}
/ ]2 ]; O' \. {' ~
) R; o) O% v, }& U1 A
$InitForm = InitForm();
( m5 B. ]7 ]/ V" F; @$ Z/ Q' \& g
$Listener = PostListener();
% u K6 b$ R1 c% N. h9 c
8 \5 R9 r9 _3 Z, {
?>
) |0 n/ }6 k! D; R8 L
o q. N9 ~4 s# c/ d+ B' d* V+ X
& l! d# w- ^8 f Y6 }1 J" o
) {5 |' p& k8 o+ Y4 i
7 x7 ], O! L [6 P( Q8 V0 D9 x1 n2 F5 P
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2