飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
* I5 h) x3 A+ K6 L+ ?- `
function Connect () {
7 E0 l+ a7 R) H
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
" g( f. a) Z: N
0 |: `, r& O3 ]! H T B
Failed.');
7 t! q& {7 e2 K0 g' g4 Y
}
4 w4 z, v+ _% ~5 D. l m) M+ g
Connect();
; s9 m& x& P6 l# X) ]
; i) Y( i% |8 ]. q4 P
function InitForm(){
1 }; ~6 {. ^# t9 L' h( f" N
//layout for the form
& a2 s4 E: r! l/ P2 [
echo "<strong>Send Items.</strong>
- j1 h0 k9 z% h* b/ ]
<form name='select' method='post'>
! L" \! f0 |2 V
<lable>Character Name</lable><br/>
( x( H" C D$ ?# E* O& q3 m8 m( u F
<input type='text' name='char'/><br/>
7 K* k! Q$ \+ J% l) {. e
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
8 T8 ?0 T- Z& z3 {8 o l) _
<input type='text' name='item_name'/><br/>
& [. [! w1 ^6 Y/ t I! k
<lable>Item Amount</lable><br/>
* g4 w0 F; U: l6 e3 |' E
<input type='text' name='item_amount'/><br/>
7 T8 x1 | D% U3 [6 ^6 q
<lable>Item Upgrade Amount</lable><br/>
+ `' s" x" q: J4 b( h
<input type='text' name='item_upgrade'/><br/>
( n! h3 x$ N2 z! B v" B+ M. V
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
8 n3 n B& x9 k5 s: b, s
& ?" l- ^% @9 g3 l, F# c
</lable><br/>
+ J. b$ L/ C2 n
<input type='text' name='item_element'/><br/>
m9 m: f9 Q1 r' I3 r
<lable>Element Upgrade Amount</lable><br/>
7 E4 E% ~/ F0 i0 B8 Q/ y% K+ u1 D o" Y
<input type='text' name='element_upgrade'/><br/>
! _* L. t9 }2 j0 Q( x! a- F: c9 M( e
<lable>Pierced Amount</lable><br/>
- U4 z; w- L6 p& j9 I
<input type='text' name='item_pierce'/><br/>
: t* q V9 J+ W, y/ ^. a8 ~" c
<input type='submit'/>
0 i4 B9 ]. O7 E" l: V" N7 ^" c
</form>";
* r+ u2 p4 B h0 {
}
8 w7 e/ |' k) ` b6 `
# s3 X6 \3 n% m! }* T6 ]' b
function PostListener (){
* X6 X. n0 R; {- \* \& m
//Add more post variables if needed and add them to initform() function aswell
+ c- D& J( P- ]1 P
' d3 z- H G) M- O4 q4 U% v
################################
( s5 Z! f) M& d5 k
##### Connection and Post ######
2 ]% J3 [/ S4 f* ~3 J% h1 D
################################
b1 ?& Q% z0 K8 K: x! E8 o
$name = @$_POST['char'];
3 [3 V) W$ `6 y7 V) r
$ItemName = @$_POST['item_name'];
$ q# g; F+ i* I9 J' v6 G6 {% y5 x J
$ItemAmount = @$_POST['item_amount'];
0 x& ~/ ]5 M) } z8 t( T6 {3 U: O
$ItemId = @$_POST['item_id'];
+ s9 V" D: y1 n! j
$ItemUpgrade = @$_POST['item_upgrade'];
1 Z( R$ r! c" M# _. ]
$ItemElement = @$_POST['item_element'];
6 w$ `. U( k t8 A. R
$ElementUpgrade = @$_POST['element_upgrade'];
3 P9 ?7 E% l Q' D7 ]
$ItemPierce = @$_POST['item_pierce'];
6 w8 v* b$ F( x' Y+ i/ s
################################
, F0 P% y& ^) W3 a# |
' o2 |# K/ Z+ u( B
//Check both variables for empty value
# N: J4 U' r) E! F
5 _% X$ |, g4 {3 [
if (!empty($_POST['char'])){
" U3 `) c: {# R( l' d
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
% _0 N+ X) R! G/ i6 k* B$ O: Q
, M; D' ?! |5 Y1 ]4 G; O; s( w
m_szName = '{$name}'");
6 T2 T' j! {1 ~1 ~8 U
while ($row = mssql_fetch_object($find)){
. Z: s& S4 S( V1 }1 m- n) c
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
2 K& N4 _# @& B* b" }& |$ E: c$ a F
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
+ I3 z" t D8 o; C) ^! s
4 A2 ?7 z- f. l( ~- E$ [' _
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
. m5 H; d I! U" U! {7 {
1 L8 A+ t+ b$ E7 M( e
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
" l4 I5 b/ r, E4 `3 z6 b" Q
/ Z6 Y6 l# m4 a. z y
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
2 i" ~: ] Y) i9 k/ H( p$ m
9 g3 @9 x' J0 y! r0 s+ a
'{$ElementUpgrade}', '{$ItemPierce}');");
1 e7 C1 _- I4 L- K( t3 D/ w' T
}
* k& u, p z# s1 h6 p
; x1 y& V, b- w2 W
}
/ ~& i2 A" s; x4 X' T# ?9 M6 Z
0 x1 a g; [3 j" c; J# P2 e
}
/ Z% }; V0 j! Q
\* r5 h( `+ C( S2 D; J
$InitForm = InitForm();
b' M" L, v. u
$Listener = PostListener();
* S( M. T$ L; t8 }* V- P8 X& w- s
+ p/ Y+ y0 W. ?+ g6 o0 T
?>
0 P) t9 ?! S' G3 \
) M% a$ t1 q" O3 C6 s& t
6 s/ I3 V& Z: U3 O' `9 Z
6 W$ q% q, `$ A# P# B; {
1 l0 S3 K" e8 A6 L+ u" g
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2