飞飞世界论坛

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

作者: admin    时间: 2016-1-10 03:43
标题: 物品发送脚本
<?php2 ^/ A% X3 b& q! v5 m: Q
function Connect () {4 ]3 j) f! w  c6 m
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
& l' Z; f0 g4 A% T& O* v$ V6 o
4 _8 v2 Y3 f% ~; w' K8 Q) s8 dFailed.');
! B6 L+ A4 ^& A- m6 j4 @4 @% z}
/ F3 [$ y( v; d) O( _) HConnect();, l# C  m0 C/ R$ r7 i, `* X
0 \& `; n5 ~3 S) e0 v
function InitForm(){$ ]/ b5 s( \! {7 b- {) v0 Y
//layout for the form
3 d( \1 H3 l5 T. Qecho "<strong>Send Items.</strong>+ u: x6 U1 a4 R; b
<form name='select' method='post'>! K8 c; D- @% L# `
<lable>Character Name</lable><br/>/ y2 c3 v4 E3 }* i$ x9 _6 q% @; U
<input type='text' name='char'/><br/>+ C4 e. O9 l; Y* I0 |
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>4 i: M; @- s7 a% Z& ?1 I* c
<input type='text' name='item_name'/><br/>( g6 O2 W9 u) V7 T9 O8 S7 m
<lable>Item Amount</lable><br/>( S6 y  y! ^2 \* q7 J( u
<input type='text' name='item_amount'/><br/>
3 v7 b" V( n& d2 W/ b0 c& C7 G<lable>Item Upgrade Amount</lable><br/>
2 ~2 r: s; k+ l0 @- q3 R3 r/ [<input type='text' name='item_upgrade'/><br/>" ]* n  [6 b9 ^7 b, B- V
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)+ Y- p! P  i: U# t4 V
" D$ R# L; R5 g, a. K1 J( J
</lable><br/>4 i& S# M+ f' B+ j; Z# X' x
<input type='text' name='item_element'/><br/>/ D5 X# S" i. b3 ~( }  G
<lable>Element Upgrade Amount</lable><br/>- A- k5 U/ W7 o7 r1 }+ k- s
<input type='text' name='element_upgrade'/><br/>  \" v  O+ W! b: C
<lable>Pierced Amount</lable><br/>7 ^6 R1 O' X8 N5 s( R
<input type='text' name='item_pierce'/><br/>4 P6 ?- m2 {1 Y: p6 {4 f7 ^
<input type='submit'/>
8 k7 A. w$ T- n4 H: \9 d4 e- l</form>";- ^; D/ W8 Z$ S6 G6 E! L: M( H! r; g
}. W/ E8 }& X& m- ?/ H7 q
# ~$ n' r( ]- z* i
function PostListener (){
$ F. T1 ]3 p% D) ?1 G+ `3 C' U//Add more post variables if needed and add them to initform() function aswell+ s4 y  t, V- f2 L! s0 H# m; M

8 T- D# I+ A( }& N################################
4 s- s! H& Y9 N: t, h, p$ H##### Connection and Post ######1 m% C" Q" ]5 ]. \
################################
. x: ?2 ]' |8 B* [% o; d5 H$name = @$_POST['char'];8 v9 B" x8 ]9 @( C0 D# U
$ItemName = @$_POST['item_name'];
1 [# f" Z2 @" \7 M# H$ItemAmount = @$_POST['item_amount'];
% A9 e4 y* B( Z" N$ItemId = @$_POST['item_id'];8 y; q/ c3 G7 X% }
$ItemUpgrade = @$_POST['item_upgrade'];
) z" U0 p$ e$ }" R. B$ItemElement = @$_POST['item_element'];7 n0 ^# g. {( i1 K5 R6 \+ ]* s8 m
$ElementUpgrade = @$_POST['element_upgrade'];
9 W; o5 m3 V& L4 F. E& f$ItemPierce = @$_POST['item_pierce'];1 q( [$ R$ ~3 z
################################, u7 j2 h3 |- z3 p/ O% ^3 A1 M; l! X

0 G* `  C0 h$ E//Check both variables for empty value! I/ i, r5 b# {1 F: h2 o# b& [# M
4 `6 B) V- k8 d
if (!empty($_POST['char'])){+ n6 b; r9 @9 H# ^; f1 K* V3 m6 o
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 5 i$ F! C& z& p9 c* \2 B

9 h; m" K) F% wm_szName = '{$name}'");8 I% n" O" M' D6 A6 x
while ($row = mssql_fetch_object($find)){& K- n1 {1 O" }
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";( g' R) S9 f" x6 b" f
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], , j2 P  _4 _; a8 s; o' g& i2 ?
! e# @' S8 b3 d4 v
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], ' X/ t. y8 ~9 H% Y4 I, F3 p
$ Z7 I9 K2 `1 n( |
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', + i$ A/ r& H  l" S6 u8 f5 r4 b! Z' o

1 Q% R4 |) D( ?- }N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 u# C" B3 Z3 p* c7 O  }1 m4 Y  L* H; H9 Z( z4 q
'{$ElementUpgrade}', '{$ItemPierce}');");( m) L% z; e" A" c! H6 _
}, j- [" N' `3 g. T, _7 ~0 {0 }

4 P1 y  c7 S) j}; u5 q7 q8 Z+ C3 v% P4 Y, E% P

" J7 l, F3 P' I! q}1 u! ^- |# o. W, [' t% B. X# I
8 x, q  Z2 {  A4 d* q  d& e
$InitForm = InitForm();
" h0 U7 m: ?" i" F' k$Listener = PostListener();) g  U' B1 \" q4 N# B9 ]0 `2 w4 k' L
+ U3 F! Y6 l' U  b# r. m9 a0 O, n
?>
4 @" X5 ]6 M, [9 M  b) J6 o: c3 ?* U. c& B* T7 b

% W  N5 A& j# ^
$ O. c- X& @/ Y* I
9 Q% q' D7 e6 J8 S




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