飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
' v" N: o$ T3 r2 j0 R8 k# Y
function Connect () {
' ^8 r/ i* N+ d
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
9 P5 L' Q% q- b2 U3 t
' F8 D/ ^& h( i, a0 K0 i- l
Failed.');
+ E q3 x7 E, Z8 j2 q" f
}
5 m/ u L3 _& ^1 f* r) k8 |
Connect();
# V$ f' c: e4 w1 W
, t8 H: N& @ m
function InitForm(){
1 @# i# c9 z- [4 C. g" S
//layout for the form
: w( w2 L9 j' _6 T- F- z+ M: p) M
echo "<strong>Send Items.</strong>
8 |" \1 u% f6 k7 R
<form name='select' method='post'>
5 w. q) T7 T8 W |! A& F
<lable>Character Name</lable><br/>
' f9 ~3 n( x3 y6 i
<input type='text' name='char'/><br/>
) ^# x$ d$ O! }, Y, e
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
X8 {* a6 i) [ f; a0 c p
<input type='text' name='item_name'/><br/>
2 ]1 r' H2 ^* e5 A2 b& F) b
<lable>Item Amount</lable><br/>
; f1 T. J7 E, r2 V7 x: [
<input type='text' name='item_amount'/><br/>
( U0 M! k( e0 t5 ? E; I
<lable>Item Upgrade Amount</lable><br/>
. H) k. F4 d$ G3 Y1 d* _3 s4 e5 A" x% c
<input type='text' name='item_upgrade'/><br/>
+ u$ m6 w( i, d# Q
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
9 j" g: s: N* d' H+ N9 ~; |0 f( n
8 G9 P8 [# {6 d; f8 c2 v9 j
</lable><br/>
, a# q4 j8 F& @: K( ]/ i! _, P
<input type='text' name='item_element'/><br/>
; _: c" V1 h& E
<lable>Element Upgrade Amount</lable><br/>
C) q: Z9 U' ^( [9 Z4 x5 [
<input type='text' name='element_upgrade'/><br/>
! A; Z) R3 s( k- v Q+ E
<lable>Pierced Amount</lable><br/>
# e) D( N' t p6 Q, T
<input type='text' name='item_pierce'/><br/>
. ^+ S0 J) }" b) b5 ~
<input type='submit'/>
5 S% N& q; p9 ^
</form>";
; H2 ?- k2 X6 {: U! y1 \
}
[" K4 J6 p e! M& A8 S
6 h- T8 \* z$ C0 i
function PostListener (){
# w2 J3 [( u% I0 H
//Add more post variables if needed and add them to initform() function aswell
8 ?4 a/ \% N" T! ?
2 j0 }) T2 K9 Z2 n" q8 Q
################################
( b6 l. i5 ]1 U) x
##### Connection and Post ######
& g8 V9 n" V$ j# @
################################
7 j8 J2 i+ n( \+ T
$name = @$_POST['char'];
^4 W) j9 u: |: x! `7 m8 p& o
$ItemName = @$_POST['item_name'];
4 b: S. q+ B. {6 G4 [9 s4 S
$ItemAmount = @$_POST['item_amount'];
Y( M3 i0 s! \: @9 N
$ItemId = @$_POST['item_id'];
( R3 c. y3 I- s2 B7 \, R
$ItemUpgrade = @$_POST['item_upgrade'];
{6 y1 I" ]; Z) O( B3 q& b
$ItemElement = @$_POST['item_element'];
5 Q ]# J/ k) q
$ElementUpgrade = @$_POST['element_upgrade'];
6 N( E( ^' ?) L. b
$ItemPierce = @$_POST['item_pierce'];
$ _9 i$ U: j6 e$ g0 G6 b
################################
7 C# Q Z P3 W: N$ x
( C8 F4 R( X4 o+ |* _% W
//Check both variables for empty value
+ B5 L. Y9 i6 l4 W; R3 ^# {9 N
% M& @5 z: F# m' m- Q
if (!empty($_POST['char'])){
6 l: u7 S. G# d; v
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 q' Z# k/ L% G4 }! F |% x
( j# F' [4 {% ` U
m_szName = '{$name}'");
$ ~! U- R% v- U6 K5 B
while ($row = mssql_fetch_object($find)){
+ I3 t& G6 ?9 B
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
" P# e/ P1 I, Q) J2 P, e& e) C. e
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
5 F8 ~+ V% P- o0 m0 W
, Y6 y" J0 S" v0 [2 T% P* H
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
' L6 f- L* q! R. E# p: _8 R" Z) t
: B L- A6 g8 @' e6 v0 y9 B9 E. i
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
$ ?8 }* W' s9 G- {" g3 V, n
& k9 s7 M, W. F# V
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
U* S; \0 c8 t2 P, O
5 a5 u$ c9 x+ ]! `
'{$ElementUpgrade}', '{$ItemPierce}');");
8 v" o0 J7 B" k4 |# i- ?
}
5 j; V4 [6 |* Q( g; M
. O5 y" c0 s t* r2 i# I* _+ P
}
: u' D8 C+ z) U O4 c% I- b
3 S2 `; [, J. C2 t% b1 ?4 Z4 t
}
# B4 J' l8 ~$ [ `1 D
2 d) I1 c: n( Y( H8 {- K6 p
$InitForm = InitForm();
- J7 C( b/ F3 S
$Listener = PostListener();
, _+ m8 ]5 r2 g/ B) E2 @- X4 Q
" i8 x$ {8 ]; x8 R
?>
. S/ Y: v& C$ q1 U: j8 |
. |6 J) W+ a' e" z& q6 I3 f
0 Y s9 }4 \ J; u- V
& ^0 Y! |$ p y. i' i6 [
% ]0 m2 e5 Q" a7 [
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2