飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
4 D5 d$ m; E0 P5 i6 e6 P" p9 Q
function Connect () {
9 y$ j" E- B0 f5 ]$ p; V/ M% B, I
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
. V8 f; V" T3 p% k, L7 |
" T1 ]/ A4 O( o# c( q* H8 @$ f
Failed.');
% U6 F6 `* Z- K( x/ \& ]
}
5 _/ n8 d0 r w; X
Connect();
4 Z/ j+ J. Z2 t" ]4 O
# p" f# a% Z- t) k% D
function InitForm(){
, U+ u, E5 h' B
//layout for the form
' P, y# n6 w5 _7 Z
echo "<strong>Send Items.</strong>
( A7 T+ L. O; l G* r) q
<form name='select' method='post'>
8 Z$ X, F* \3 t, [ k0 k) ] Z
<lable>Character Name</lable><br/>
1 o2 X# u4 A+ o+ J4 R
<input type='text' name='char'/><br/>
! X8 [& H2 k, U! R! I7 W
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
' R% W2 b+ U1 T: Z! \" _6 j# e' q
<input type='text' name='item_name'/><br/>
/ ^4 V6 v2 V* L5 o1 m
<lable>Item Amount</lable><br/>
: [! Y+ E' C1 {* r" |. g
<input type='text' name='item_amount'/><br/>
- W. O0 U; S- n- q7 \" D
<lable>Item Upgrade Amount</lable><br/>
2 `; r- q. ^* ~0 z% w- i6 s( l
<input type='text' name='item_upgrade'/><br/>
3 A5 }' y w/ U! M3 M
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
u% ]# b5 p! N0 j6 f
: q. g+ O! p& C
</lable><br/>
9 z" R2 _0 `3 `' L' ~9 N8 S0 r4 g
<input type='text' name='item_element'/><br/>
9 ]1 L5 D2 R* `* d* O
<lable>Element Upgrade Amount</lable><br/>
" p' d2 ~6 r/ h8 ?* e- L4 V$ ]
<input type='text' name='element_upgrade'/><br/>
3 A7 v* c8 t* W' p& g. i2 a4 F
<lable>Pierced Amount</lable><br/>
: n* y7 X8 [3 W8 M6 q3 S6 a, L
<input type='text' name='item_pierce'/><br/>
) B$ N9 k. `' U2 w2 B6 ]# n. {
<input type='submit'/>
0 _5 \6 @5 d5 N& A
</form>";
% l' f" S5 J0 A# d
}
. v( H) X! g# {
4 R5 f) g$ J. o
function PostListener (){
* v4 j. @7 H* G8 T
//Add more post variables if needed and add them to initform() function aswell
& ^& {0 F3 E1 g4 g% z
7 k, u* Z- i) B9 T% C- [' e
################################
6 U. B. m' Y0 ]6 s
##### Connection and Post ######
3 ^5 b, \+ M3 z3 c$ z- z$ e7 w# C
################################
! A) Z3 ~' W! g0 r* m6 `
$name = @$_POST['char'];
" B. j2 O) i. z; ~) I
$ItemName = @$_POST['item_name'];
1 `, ]; k* f/ X( P
$ItemAmount = @$_POST['item_amount'];
5 K4 P" y/ L7 T v2 R* z2 w
$ItemId = @$_POST['item_id'];
0 |. \, T3 n# v
$ItemUpgrade = @$_POST['item_upgrade'];
, i6 n9 o" M1 L
$ItemElement = @$_POST['item_element'];
+ z" ^0 y. u s4 |& S% e! J! [( W7 P
$ElementUpgrade = @$_POST['element_upgrade'];
5 y5 B+ U5 ^) E
$ItemPierce = @$_POST['item_pierce'];
* I7 @9 M; z' I! N1 W4 a2 D
################################
; {6 `4 e- m& z7 q% L+ I$ c
9 g, x7 X, N2 k% E6 j
//Check both variables for empty value
& |5 ?! Y1 N7 Z
+ F% T5 F( A/ V- z
if (!empty($_POST['char'])){
* C% r: Y8 q4 A$ G9 I
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
& D) ? f" f; a2 t5 Y9 R D
5 e4 L+ T2 E4 e" L2 u3 w: q
m_szName = '{$name}'");
5 C0 K h& W5 U7 J
while ($row = mssql_fetch_object($find)){
9 v/ {8 f" r0 X; t0 f7 P" _- s
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
- L; f O( L! e4 K2 a
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
# T: F# y# q1 S
" f' R3 o6 D/ o9 O0 L9 z$ O# y |
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
, w+ b; U7 k8 T, m" Q7 ~- s
( B8 @8 e; w) w- F. E9 y7 ]
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ ^" `/ A. Q2 |
! T( o* S& I- }# ]0 j
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
( M% h' I! y/ C& v, `
) |1 ^/ k! |. d" b' [- q; @
'{$ElementUpgrade}', '{$ItemPierce}');");
- v& w# ]8 S% `9 c! {
}
2 [. |0 J! T. I8 `
- y; z! Y* F d3 T) S x% N8 Z
}
( ?- N% c! z* B. v
4 S! y6 }+ _9 M6 k7 v
}
9 X0 T* g+ l/ }9 q6 \
* x. ?4 z, d& Z) |8 x4 q g" m
$InitForm = InitForm();
4 W' k5 y: ^4 v7 A. x# r
$Listener = PostListener();
8 t' ^) b' u8 P: g* O
( M1 x& }1 C4 b6 g6 |( J+ o
?>
0 K3 c2 h& ^% E6 X
1 y' G3 b% S5 @; V0 Q) G
; c G# f8 j- |! N2 c9 X
2 A: P- k# a( J3 T
1 X% d8 E9 b: N( M, ~; O
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2