飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
: q: ?& C1 E* [( c" w5 T
function Connect () {
8 t) ^, f, z# K' q, Z7 A( m: W
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
5 n" I: [. J7 C7 e b
) g* _1 i& ` c+ X
Failed.');
7 n+ W. Z( B G6 k; Z
}
5 L( s2 \7 |& d3 U G9 K0 L/ X
Connect();
1 h' e. V0 E7 Z- j9 L' Z& ?% a
, Q1 \0 W" v( E: O
function InitForm(){
( Q" n+ o/ q- w* {. h# b1 ~; x5 p9 J
//layout for the form
) }6 J( R4 {- i" ~. d3 z$ `- r
echo "<strong>Send Items.</strong>
3 F" C# h3 b4 g2 n; `
<form name='select' method='post'>
2 A3 R3 o" p' n- f4 ~7 ?
<lable>Character Name</lable><br/>
7 p0 H+ X# Q( z- r! U% a
<input type='text' name='char'/><br/>
/ p4 P- s5 J5 W, M3 Q: |) w( v
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
' V# X" A5 V0 W" f, b+ j/ A8 G4 t
<input type='text' name='item_name'/><br/>
t/ Q! t: O$ i4 c& t( A! P. s
<lable>Item Amount</lable><br/>
- E) ]# J, D) m9 r) m, n
<input type='text' name='item_amount'/><br/>
7 p1 N1 [" a& }" R, {2 C% h' V
<lable>Item Upgrade Amount</lable><br/>
. t* B) f5 [) X+ [$ A
<input type='text' name='item_upgrade'/><br/>
2 }3 z& h* {5 }$ t6 {9 Y7 x
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; `/ ?: {# y5 z/ T1 f/ @1 L
3 f3 e1 N# Y, f' Y. p& g0 u# S
</lable><br/>
; i6 ]6 V# l0 w/ u- a' q
<input type='text' name='item_element'/><br/>
2 A( V* V. p# ]- V# V
<lable>Element Upgrade Amount</lable><br/>
) l4 t( ^8 y1 K, C' L; d
<input type='text' name='element_upgrade'/><br/>
/ D* | K+ S H$ J
<lable>Pierced Amount</lable><br/>
% @# F# K9 M; ^+ o
<input type='text' name='item_pierce'/><br/>
+ v# z1 S: Z1 Q
<input type='submit'/>
0 N6 x, m9 n9 ]( T+ j7 I
</form>";
7 D+ i k+ ~) a, v; V# A/ C
}
0 E( B: a9 K5 j4 l o {' q
2 z: N' Q, A* X
function PostListener (){
; f' }) D) V4 W* X% ?/ g
//Add more post variables if needed and add them to initform() function aswell
9 v7 u2 f g4 d# o5 N& X7 ]
' E- Q) W3 `6 g+ g6 U
################################
8 \( x" a! f$ C" f2 N1 a4 i
##### Connection and Post ######
* g0 N: h! q5 d4 |" H a7 d
################################
( l5 K) u. e0 ?
$name = @$_POST['char'];
7 `9 z9 P; ]% o( _& |. O- C9 t9 j0 e
$ItemName = @$_POST['item_name'];
! d1 y. [, {; V+ U! x
$ItemAmount = @$_POST['item_amount'];
0 M. ]4 V; b) d+ f# ]
$ItemId = @$_POST['item_id'];
' {& f& g& m, Q$ h3 a* e0 W
$ItemUpgrade = @$_POST['item_upgrade'];
; ^, B* g& L/ p# L
$ItemElement = @$_POST['item_element'];
& O1 D! ]8 F$ S
$ElementUpgrade = @$_POST['element_upgrade'];
/ b6 b# V$ G+ S2 { O* `# C- l
$ItemPierce = @$_POST['item_pierce'];
( k' Q, m6 G# b/ U5 ?, F6 J
################################
: w t* }9 T r' W, b E) I% H& k( o
; `0 l0 e% r6 Z) g( F
//Check both variables for empty value
$ J1 D9 Q/ X$ f6 x6 {
! ~' M6 n O9 ?* M2 G
if (!empty($_POST['char'])){
) N4 U. x* Y& t8 X+ O6 r
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
! [, i, M( b- V3 B: F* l, V
1 c0 B6 R0 v! ^- i5 z( o
m_szName = '{$name}'");
+ v, {4 W. I8 a5 R
while ($row = mssql_fetch_object($find)){
3 q2 O" l; e% c8 _7 y3 |
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
& k8 ^/ q( e& }! e3 }
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
. c$ F; ]( J/ L% ~
! C: C3 o! S: w$ e+ l8 c; Z3 T4 _4 u8 z
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
: `- ~# a5 M& X% o
/ k4 a Q& e H) _4 |& H
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
& M7 b6 H5 A0 e8 b7 ~$ }/ f
) @. `1 M/ M8 M3 I
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
7 i: G. X- N* H# W8 K3 I! w. w, f5 q
& n. A' ?9 ] H: |, `( |# N M
'{$ElementUpgrade}', '{$ItemPierce}');");
, c8 y# y- w: f- m
}
, _' X4 N" I3 }2 I E) o# g @
) ]& ~7 s/ Y+ [% w) s2 ?$ k. O) j
}
% r8 F: r) g+ F9 F- K, N7 d
/ X* _3 ^ r* M4 E
}
' Y2 }$ h$ |8 m( o, U) v( a! S
+ R0 [; C! ^' p9 X: r
$InitForm = InitForm();
- {% V: U! ]' s2 x0 H" Z
$Listener = PostListener();
5 o4 _* v1 H# x) }" b$ @
! `/ _9 |+ Y: o9 Q* j2 D
?>
0 o! d1 ?+ L# ?' i5 [
9 u* ~& R! f$ ^/ ]
8 G" c7 n1 H& S- W2 v" J
. G: ]$ L5 A% p/ t- P) K1 [
3 j) c. V& h! Y0 E' \
欢迎光临 飞飞世界论坛 (http://ffwold.com/)
Powered by Discuz! X3.2