飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
8 D9 P: V! w, U: g
function Connect () {
- M* g+ L% z. U
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
. C3 K* r7 s2 F, P; r5 f H; C- ~
3 j' ^7 r t6 z) g! C, u
Failed.');
# T1 Y1 i/ J8 h; P3 ?4 S
}
6 z+ A, g. K3 p' n8 J8 a! {9 b
Connect();
, ?6 i# W8 u1 p6 e( i
- N; q& z4 S4 G5 F
function InitForm(){
5 h4 E8 Q' n9 _4 J/ j) h
//layout for the form
2 A; K' h7 E8 ~! C3 R. v1 W9 b ?6 ]4 I
echo "<strong>Send Items.</strong>
' o5 Q& q* {8 ?/ e( f- v
<form name='select' method='post'>
3 m6 B- K* t3 A8 v/ Y
<lable>Character Name</lable><br/>
! G+ D4 v, e: l' t
<input type='text' name='char'/><br/>
% p5 p& v* C7 D5 ]4 H/ f- _
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
. i- ]9 y% B+ W9 a5 U
<input type='text' name='item_name'/><br/>
$ {5 r6 Y7 l" u
<lable>Item Amount</lable><br/>
# K6 `. Q+ }7 S9 {6 F' R* A. V
<input type='text' name='item_amount'/><br/>
9 C7 G2 W& z9 m9 G3 R& S
<lable>Item Upgrade Amount</lable><br/>
* w, Z- I- [, r) b0 |: l) e" ~
<input type='text' name='item_upgrade'/><br/>
T4 J2 Y7 ]0 T
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
# l5 p4 v8 ?- M' l
* @( f i0 K8 S* u
</lable><br/>
2 s( u8 d9 `5 t q# [
<input type='text' name='item_element'/><br/>
/ k+ q4 f% h- Y! I5 ]" q
<lable>Element Upgrade Amount</lable><br/>
0 l2 b& l- b' j! p
<input type='text' name='element_upgrade'/><br/>
6 Z$ }6 Y) O$ y) R+ ]* ~
<lable>Pierced Amount</lable><br/>
3 U3 D7 o; m% N; M
<input type='text' name='item_pierce'/><br/>
" X" H$ P( `. s3 z% T
<input type='submit'/>
0 P3 p$ g% {: v, o9 O$ u) @6 w+ H
</form>";
7 k( _/ ^$ V2 X* h
}
& z$ j3 x. _! m2 K1 w4 F" q" p* \
, h' D7 P' J. Z1 t) K* E1 E
function PostListener (){
& j) n& @* a& x2 C
//Add more post variables if needed and add them to initform() function aswell
1 z3 q4 J$ s4 @8 E# H k+ r+ B
v( }% b9 T4 b) P
################################
1 \3 _' G- m6 i
##### Connection and Post ######
- v8 o6 x! ?- ^
################################
7 B% d1 N- ]. N7 x2 b' m# t
$name = @$_POST['char'];
& j) n# O. H, G4 L P# h( b
$ItemName = @$_POST['item_name'];
) M1 _( [; @% Z7 G
$ItemAmount = @$_POST['item_amount'];
2 g" M5 z5 h: m5 U
$ItemId = @$_POST['item_id'];
/ b- _9 r3 h- | Z
$ItemUpgrade = @$_POST['item_upgrade'];
/ s& _; F4 L( }, P
$ItemElement = @$_POST['item_element'];
& }- E! [" H$ t: @5 h9 O5 d% L
$ElementUpgrade = @$_POST['element_upgrade'];
8 P+ P" a5 Y9 {! q+ } y' b
$ItemPierce = @$_POST['item_pierce'];
9 K$ t N/ M: e) p0 U, H
################################
# o$ T5 r! Z# D0 ~5 A: K: B7 F
: C0 u7 U' Y) s& d R
//Check both variables for empty value
( b3 A. [* W. S G- L3 t: d
[7 O4 b* ], h+ ~( X y5 s% M8 r
if (!empty($_POST['char'])){
+ V& l# X! c' R7 f
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 \+ a/ m* H- N* V* `& q
8 |- F) e+ t7 h3 q9 v% l( A0 ]
m_szName = '{$name}'");
/ C# V! d+ b9 c+ N$ c! f
while ($row = mssql_fetch_object($find)){
R& V. N( l; t5 }2 `
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
1 c2 P; r5 w& Y# w; X% j
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
+ O7 X2 B6 m3 r* D1 g2 T
/ P* p1 v: r' Y# [ i! y
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
2 l0 K8 [! F. ], {
# v* ?* u G) g! o) L% m
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
+ k; ?. }- }- L- Y1 D
5 B3 ?0 B }* [6 I8 G$ r
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
, _0 t! |' R) J! q5 G+ E( q4 ~
\; @+ ?: |* [
'{$ElementUpgrade}', '{$ItemPierce}');");
- ~6 {6 W! y1 p" t" W" s
}
: H6 b! W' x( F# u
4 K- _+ ^0 I8 H3 R/ p% c; ~+ N
}
9 i% r1 r8 F$ x# r% C5 { n5 s7 [7 d
9 w- l& w8 J& M- F- U5 {
}
! F- k# N( u; d& v4 P; T
7 H) A; q* Y& h0 v# W$ o) g8 h5 ?
$InitForm = InitForm();
- w# J8 l c" C) G6 X# f
$Listener = PostListener();
: P; o% j9 U, a8 H/ [/ h, S4 e3 F
& _1 P) o) b7 [
?>
) _9 n8 |3 y) L$ J( s [
L- Z# }9 `: H: a0 x
4 E3 U9 }+ z! G: }0 S
8 i2 g; u/ @1 b* ]0 D2 i( _, w
7 N/ Q: I/ c; x
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2