飞飞世界论坛

标题: 物品发送脚本 [打印本页]

作者: admin    时间: 2016-1-10 03:43
标题: 物品发送脚本
<?php$ B' j# l! ~& b. f0 [
function Connect () {
8 @$ C6 B3 O1 `" W6 d* U! b9 Umssql_connect('Server','UserName','Password') or die('Error: Connection to DB 8 a6 G. P5 I0 C3 f: E
3 L0 g2 W3 z: R. N" Z- d
Failed.');$ U) H: ?9 [/ B% l. g6 y# n
}
5 M% @- T+ P5 _Connect();9 Y' m  |) t8 c, [9 A
" l( `2 y7 `* ^+ k
function InitForm(){
( W6 r: ^3 Z8 R2 t& u" Q7 w" ^//layout for the form
( l1 h( M$ X& w6 Hecho "<strong>Send Items.</strong>
: L% Y' ^7 D: h, y) I<form name='select' method='post'>
6 A% d. c+ X, m& @& M& y& s<lable>Character Name</lable><br/>
% n7 Y0 j; z9 V; Y<input type='text' name='char'/><br/>6 [+ Q) i' a. @3 n, B2 t+ g( L4 d: I
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>+ N8 P" q" z: s* {8 Z' g. [# l
<input type='text' name='item_name'/><br/>
* x7 b$ P" |7 P<lable>Item Amount</lable><br/>* F7 E0 t, |) \$ [% L
<input type='text' name='item_amount'/><br/>
8 H. C. X0 d4 M2 X) S; X: `<lable>Item Upgrade Amount</lable><br/>
3 S! v7 _# M* s8 s<input type='text' name='item_upgrade'/><br/>
8 g2 r. W7 b4 U0 U  g8 T# p<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)" Y" G+ h7 T; S

/ T8 O; X; [3 z9 o0 ]4 j. H</lable><br/>
7 a, y0 Y5 O; E8 J<input type='text' name='item_element'/><br/>
! h0 A% T0 m1 Z' @4 P9 @$ S<lable>Element Upgrade Amount</lable><br/>, z1 V- c7 G- W$ h, i# t
<input type='text' name='element_upgrade'/><br/>. F  m' y2 ], r$ S4 v- a, o( H
<lable>Pierced Amount</lable><br/>
# v9 A; ?1 f1 b; v/ J5 f8 p% l<input type='text' name='item_pierce'/><br/>6 o% S% w& D, w3 |
<input type='submit'/>* b4 M6 e3 ^- t+ d  o. Q
</form>";+ r+ [$ N$ y6 |# T- O
}( K, c- p# g+ V% q8 u  ~

/ c7 B" X1 \' p% s; jfunction PostListener (){
$ z4 E9 C1 N' _: w" Y" X//Add more post variables if needed and add them to initform() function aswell
/ m! c3 T" \, l( Z% W" |4 V- y( P, U
################################' N9 E+ x; N* ~* A
##### Connection and Post ######
, S% A- X; @2 P! \' t1 [################################1 L# [6 K! H1 X0 i
$name = @$_POST['char'];
% @. y. z2 P7 y+ \$ItemName = @$_POST['item_name'];. B0 u% m- J' B3 J% w5 A: {) G# S
$ItemAmount = @$_POST['item_amount'];. ]2 U8 R4 z: o: F! E" C
$ItemId = @$_POST['item_id'];
8 m2 f+ ~2 b; H4 d' ?$ItemUpgrade = @$_POST['item_upgrade'];4 H( w9 J1 V  A* A1 n8 ?* \
$ItemElement = @$_POST['item_element'];. P0 a8 o: |; p0 q* X! V2 s
$ElementUpgrade = @$_POST['element_upgrade'];8 ]4 W& m& J; P* L0 R
$ItemPierce = @$_POST['item_pierce'];
0 Q4 _  g  ~  R6 n( r################################
8 `+ X( b8 K3 ~8 p7 U( t* F. s/ [( K+ x3 Y" N: s& J/ f, j: L
//Check both variables for empty value8 ^: O9 l/ Y8 a& b+ l: t

  |1 C% z% ~6 Q& qif (!empty($_POST['char'])){
5 |) j: P' ]; d: m% |9 G" M1 A$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
0 |2 r6 w0 u* o; ^# f/ X# C& N6 e0 ~7 i! H/ P: ^
m_szName = '{$name}'");/ f" D( N2 W8 K4 A+ {* Q
while ($row = mssql_fetch_object($find)){# O% V+ i8 d9 B
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
& d% M$ f8 y+ R' f  M1 C$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ( N! [4 J. E9 B: x- g
5 c- m! B! x6 q1 t2 c" g5 g6 e
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], 7 @( h8 Y# U+ V& p" Q5 A3 ~

4 r+ J7 E0 w' n1 L6 r) U. ?: x[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
2 m" O3 U- {. M2 ]# w, K
& s3 K+ W. f4 n; A3 f. u+ jN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ( _+ p; A. x/ ~9 A. ~1 L/ h3 c: f
& y- C: M: L  Y3 I1 @
'{$ElementUpgrade}', '{$ItemPierce}');");
8 z5 q$ l5 c, o  u3 N$ E}
2 u1 H" h5 [3 b1 R0 L) l  b+ `
6 `( a5 n7 S) V8 Y}  G' ]( T- e6 a# L9 p7 x3 l

8 F7 b9 q2 i  o9 @7 y* E* \- g}5 Q9 Q4 u  i6 e( e

2 V3 c4 |3 @! |$InitForm = InitForm();
' o8 A1 t) S* h0 d$Listener = PostListener();8 `) k8 i$ _# w* B8 f7 x4 {

2 }+ T# D1 b/ n0 o, B: n?>8 M' z1 Y9 [1 V
; M# U/ X! l, Y3 P% N( H+ D
7 V7 a  O% {& R6 @

2 L8 s6 ]; x1 O9 z+ g
5 _  E$ s. D: v) |  _  |# O




欢迎光临 飞飞世界论坛 (http://www.ffwold.com/) Powered by Discuz! X3.2