飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
2 Q' K ?) e0 Z/ M7 w
function Connect () {
; L- R& y2 |* f# K7 V5 O
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
& C) y. F9 \; v$ O$ c; h
. [$ B* } l4 Y1 K& D
Failed.');
' b2 u7 O" c1 P1 m7 Z1 n7 _" h
}
, z5 J; D# T5 x5 f4 I
Connect();
4 d' r/ F( m/ N' w* E
2 @5 p0 p1 L/ a( ^+ ~' Y/ z& Q. u* z
function InitForm(){
6 ^, b6 ]& k( o# n) E, w
//layout for the form
# X6 h# L4 }5 ^
echo "<strong>Send Items.</strong>
& L8 L( T2 N p' b; B* F( E
<form name='select' method='post'>
) L2 P; r* j0 A/ |, I1 q0 a. `
<lable>Character Name</lable><br/>
. p- O9 t. ]* a4 q" g, N
<input type='text' name='char'/><br/>
. q; L& ]4 X% f! e+ v& l: @
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
# J4 @: D' X! t3 |2 U0 f
<input type='text' name='item_name'/><br/>
* k- t! T9 o0 ^& i
<lable>Item Amount</lable><br/>
/ P% m% m1 `) j1 f! w8 Z
<input type='text' name='item_amount'/><br/>
/ G( w# p, Q) s; B, x. B
<lable>Item Upgrade Amount</lable><br/>
' @8 x, i( R- W" A6 t
<input type='text' name='item_upgrade'/><br/>
0 r4 |# v/ a/ R/ Q6 j* p
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
7 \* X0 I0 u/ F8 O2 w1 }* y: E) i
3 a! k5 ^' k$ ~* d, Z8 `
</lable><br/>
( j ^6 S; }' z ?- g
<input type='text' name='item_element'/><br/>
* t1 h& ~+ r% a) P4 s
<lable>Element Upgrade Amount</lable><br/>
$ V1 V( P( V: d: j$ F7 e
<input type='text' name='element_upgrade'/><br/>
' {$ s( O1 X3 t3 ^! m
<lable>Pierced Amount</lable><br/>
0 ]1 B9 o- n; d F, L5 U9 W# g3 L3 _
<input type='text' name='item_pierce'/><br/>
% w K4 { s; ~" J4 b
<input type='submit'/>
! \ Q$ x; g' j: c% q' w4 }5 G
</form>";
3 _( k k3 A3 x+ p- |
}
$ h6 e4 [3 V( F' w9 N" W/ ~+ x
( U5 z3 i/ K- {" \1 ?; {
function PostListener (){
8 l: D, l; `, ]5 E5 c: o
//Add more post variables if needed and add them to initform() function aswell
6 Y; c- Z6 C m2 ` T1 T) h' p
7 A4 x2 g6 v, Q' a/ S( |
################################
; Z0 S* z# C+ v X5 o4 V
##### Connection and Post ######
% V3 H) u: I S5 ^. f
################################
: G) W, q; C& F; W7 ^2 a
$name = @$_POST['char'];
1 W d1 } R: {1 Y; s# {
$ItemName = @$_POST['item_name'];
7 X* p' w- k" O2 W g- d9 [! w( v
$ItemAmount = @$_POST['item_amount'];
" I7 E/ p- b' L1 |1 J, y" g
$ItemId = @$_POST['item_id'];
: o& Z2 h* E0 H) X1 n/ ~' D0 h
$ItemUpgrade = @$_POST['item_upgrade'];
! T& v2 y* {! W, [. { b
$ItemElement = @$_POST['item_element'];
) y' Z8 j O* Y3 w
$ElementUpgrade = @$_POST['element_upgrade'];
: a3 T0 h" l# S. h# o: M0 M1 f
$ItemPierce = @$_POST['item_pierce'];
# j) A1 @9 y. M1 m- i+ H! W
################################
% E6 k; ]$ o! F1 e
% W/ E6 Z; V: A+ Z! k! }
//Check both variables for empty value
' L+ x) O/ Z7 X
8 ]6 U* V, H: S) ^' ^6 m
if (!empty($_POST['char'])){
$ O) L% m7 j: S: }& E
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
+ L1 s3 @- V0 R
6 r% O7 T! E0 |+ g6 x+ e5 g
m_szName = '{$name}'");
/ }$ l C1 G, q' }# S
while ($row = mssql_fetch_object($find)){
& t* m6 m: N# T$ m( g
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
2 K. O! N7 E8 [- C# ]% P8 h8 q
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
0 ], W. \( ]) y* _" H
: t9 z! H2 u/ f( g0 Q
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
; r' s" t+ d/ x$ f& T
. _3 Q" a1 Z, @2 Q
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
# L7 q. X) S6 M& i; Y* D) H
7 |# b/ u/ C' k2 i( Q
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
: s% Z9 g' U& g# c0 L. |
" r% Q$ ^8 n* ^7 n- y
'{$ElementUpgrade}', '{$ItemPierce}');");
- X/ k/ w1 p! n$ l
}
' g }6 G, N, _7 k: \! G' C
* ~" P, l8 r$ _( @
}
: ~1 I5 a; p& `; P6 M, C2 j
( F& U% c& i! } O8 V
}
( o, D( _ R3 B( L
, q: x0 G: g5 Y8 `
$InitForm = InitForm();
, X$ ~! d' v: _9 A8 `
$Listener = PostListener();
/ |3 v+ P3 i; X$ j
# a& b7 }! S( k7 A$ H
?>
& i. l/ N3 z* I2 ` r! l0 e( X7 ~0 k. n
8 y& {% K t3 u* ?. s8 y
/ s2 S8 e. V+ `& L7 T D0 T, c
! L* d2 H4 \9 _- S5 ?
# a' f0 m, x# b& ] D
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2