飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
, `5 b3 s+ i. K7 ?, O& \. U- @
function Connect () {
! w) |. \/ N4 o+ C' n, L7 U
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
8 f& s, n* R7 W" h, W3 h- N4 F+ x
. p7 f) c- {* c/ @; n8 W( n8 P
Failed.');
1 |7 ]4 Q# G" B, [4 J
}
, D# z6 s2 {3 O: w
Connect();
$ O$ T ?/ e1 H0 ~# v" Z
/ w; I9 R5 ]$ W! g; x( Y/ e
function InitForm(){
) H" q6 N1 y2 ]
//layout for the form
) i3 T7 W3 V# A- {: c: ]
echo "<strong>Send Items.</strong>
; T! r2 m! N" I# j/ j
<form name='select' method='post'>
" ~, a9 H' u0 a% B1 p
<lable>Character Name</lable><br/>
! {8 p8 ]- d, w7 g/ H
<input type='text' name='char'/><br/>
, @( @: d0 U9 e8 I% ^2 A
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
; |# o3 z9 ^ O' g3 i1 W* d
<input type='text' name='item_name'/><br/>
2 d O1 J" s% X) c
<lable>Item Amount</lable><br/>
& B; a. G$ |" Q9 k3 x; o& ?; ^
<input type='text' name='item_amount'/><br/>
% h+ k' ] I" X8 Z
<lable>Item Upgrade Amount</lable><br/>
7 O2 @0 i" q' h: l
<input type='text' name='item_upgrade'/><br/>
* M) t$ f" Y' |
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
6 I( ?( W6 }/ r m7 H8 R3 Q8 f
# c2 J+ r [, r8 H' g: u
</lable><br/>
+ p4 m/ s$ {" X! }" X, f9 [" |, P
<input type='text' name='item_element'/><br/>
+ u5 g* {8 ?# r0 T& G/ f/ O
<lable>Element Upgrade Amount</lable><br/>
# u1 F: }% B0 x0 t5 m3 w+ U
<input type='text' name='element_upgrade'/><br/>
3 q! i& O/ u2 t" k" P. n7 x2 O% s7 C" _
<lable>Pierced Amount</lable><br/>
! W5 ?# E( E8 L5 X0 E5 ]5 N+ _9 F
<input type='text' name='item_pierce'/><br/>
7 j; r, v, s7 E9 [
<input type='submit'/>
2 d- V) [- C% H
</form>";
! c/ c8 R; o3 R- A- `' R9 {
}
/ i( }5 C' {) q* _8 n
) K4 v4 W+ }9 [' x" P& B
function PostListener (){
$ P% z! ?" b! m* J$ J
//Add more post variables if needed and add them to initform() function aswell
& w7 r- [# n+ Z: M) A# c
% m6 j3 K2 J& [' s) w
################################
+ y' ]& K) Q" J* [) Q. c
##### Connection and Post ######
( ~" \ d' [% r$ o/ g, w. `
################################
* N( P+ v3 T6 E, o/ ^
$name = @$_POST['char'];
0 P4 d/ `5 h3 i- r' w2 q- q
$ItemName = @$_POST['item_name'];
6 N% J/ q8 x6 w- J+ i4 a
$ItemAmount = @$_POST['item_amount'];
( I" R% o+ k4 T1 x" w4 T
$ItemId = @$_POST['item_id'];
! ]2 S ]( Z% @# E. z. q" o
$ItemUpgrade = @$_POST['item_upgrade'];
/ H) H2 _- l; t3 `& N C& u+ Q
$ItemElement = @$_POST['item_element'];
+ Y& m: T- V2 m5 Y v6 R
$ElementUpgrade = @$_POST['element_upgrade'];
. Q* O# [0 s3 |4 c& M% J
$ItemPierce = @$_POST['item_pierce'];
0 D# z- i0 v3 d" z6 m+ V( }9 c4 @: J
################################
4 {# q' i" Q6 l& s+ J
8 c, j$ d, b% Y$ M
//Check both variables for empty value
- u) y$ n; G/ {4 _0 h
5 A1 p' D' `6 o8 S
if (!empty($_POST['char'])){
# V4 Z4 |5 T! m8 `9 }
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
6 w4 N0 B7 L" g& W& W, `# {
4 |2 p* h2 o$ {7 q
m_szName = '{$name}'");
' ]: H0 J& g- ~* n: v2 S2 U: |
while ($row = mssql_fetch_object($find)){
8 c( U$ f4 {) t8 h
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
+ C# Z. O! }5 z: u5 f P! v1 z
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
7 ?: D/ d4 J! l: F. _( i
/ N5 k* t7 u, G' [4 M
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
: i5 ]2 x4 o& E0 L7 ~
( G; |) [; c m3 B, s+ D2 \
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
6 y- g0 s& a: f. V" ]1 x& p
7 A8 j$ w8 M+ _; Z0 w
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
* F$ ]( r; L7 Y
! z$ {9 C, Q4 |3 X6 X+ D' U( l
'{$ElementUpgrade}', '{$ItemPierce}');");
3 x4 s4 S- I! x
}
- a. G5 P3 j* \9 L5 l; d
! q0 Q; w: v. U) d% n4 v9 k# [- N
}
9 f$ h6 D1 B; p" d2 K6 ]
5 l. T0 ^, B6 {
}
& x- y% i) K) V" X% C- y
: w o9 Q* }/ y5 k
$InitForm = InitForm();
2 U# v6 a- z% z& ~8 t( C0 Q3 i- H
$Listener = PostListener();
) K. U% G0 n! n, n! d/ D0 f
/ Z( ~' i+ T0 t @' [+ E
?>
, ?$ }& I6 r% s/ \( j
8 A5 Y8 E3 @* d
! |! x( U8 ~ B P7 `
$ i8 `6 E2 b0 ^- S
, `' D( z5 F* H8 a% l" a+ F
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2