飞飞世界论坛

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

作者: admin    时间: 2016-1-10 03:43
标题: 物品发送脚本
<?php
  O- v3 Y, ^* m  tfunction Connect () {- d! K! ~$ \# \8 D2 c0 U
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 3 \) C1 F3 G0 h+ ~, \

& h% P5 t4 W; v5 mFailed.');
0 ~% M2 f% R4 C}
* y2 t& k0 \$ B; [8 M, W* }1 eConnect();
& L; M* i; F% {; b/ F' K+ B* Z, V9 U. V( w. U) o$ h3 j
function InitForm(){
! h" Q$ K3 G: c8 h//layout for the form5 g- p7 u& j; V1 ^
echo "<strong>Send Items.</strong>
9 M% }8 \) Z' ^/ U! e<form name='select' method='post'>% {0 M  E% B0 I
<lable>Character Name</lable><br/>: Q1 R  ?& x2 W8 b' ~* I: V& B6 s
<input type='text' name='char'/><br/>
3 n- \8 T( _) u  v; @3 R8 m<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
$ L9 l7 t% u3 F8 R<input type='text' name='item_name'/><br/>
/ ~0 e- b1 j/ W- [" E: C$ w: U<lable>Item Amount</lable><br/>" T, k7 L" B# Z. J! T0 J
<input type='text' name='item_amount'/><br/>: p; f+ G' B* b, r3 P, c
<lable>Item Upgrade Amount</lable><br/>) n: g" ^2 O& R& m" X. D% P( R
<input type='text' name='item_upgrade'/><br/>5 ^/ G3 X+ Y$ _' X7 y. L, O
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
- h) B" ^* v/ Q1 K, h) X8 [: f4 `& b: r$ y9 M* {
</lable><br/>( |, R! ~9 ]5 W: \! f/ a
<input type='text' name='item_element'/><br/>9 P7 P" M/ F7 x3 H
<lable>Element Upgrade Amount</lable><br/>
, u$ ]; S) E# V  x1 Y<input type='text' name='element_upgrade'/><br/>
& |3 X- O$ D- g% Z4 M; ~& s( n<lable>Pierced Amount</lable><br/>: y% \( K* F7 q' l0 H3 }
<input type='text' name='item_pierce'/><br/>
- M4 E2 k0 }% e, d<input type='submit'/>/ _, B5 n( T" K+ t& m$ w
</form>";
/ r% _2 N; p! \}8 Y+ N  k' }1 m' M' q, E: u+ D: c

! C* m+ U! j+ s" D8 ]function PostListener (){. p. B; C) h  N& J
//Add more post variables if needed and add them to initform() function aswell
: `! w% q2 M" @* l# F  e+ Z/ h0 ~- e" R# f  D
################################
& g2 J! R9 M+ P* N  J7 q1 ~5 D##### Connection and Post ######
/ F7 o& L- O2 @# o, Z* S, \. _4 N################################. o8 E9 O3 G  O9 m
$name = @$_POST['char'];
) V7 F% W6 K* Z5 h' r1 @8 z6 ~$ItemName = @$_POST['item_name'];/ r& c- w; Q+ x; A! I/ a$ O
$ItemAmount = @$_POST['item_amount'];$ n+ P; {' C  C% Z; ~2 O
$ItemId = @$_POST['item_id'];
! U7 F4 r2 W' ~$ItemUpgrade = @$_POST['item_upgrade'];
, {) C% |6 R& O* j: ~( N2 u0 k$ItemElement = @$_POST['item_element'];. ]1 e% _  I$ d% Q5 p
$ElementUpgrade = @$_POST['element_upgrade'];
9 K1 g8 T7 g8 q  h$ItemPierce = @$_POST['item_pierce'];
- C  t2 W% v  i################################7 x# w  q4 E7 t; N

( Q/ w( J1 W! K' {9 ~0 @# @6 J/ P//Check both variables for empty value
/ B+ o& f3 n, w$ j9 i, y* M; s9 i! L4 W+ q
if (!empty($_POST['char'])){
8 H3 c+ X2 t7 R5 Y8 m% r( d$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where , W' i/ \) K' F* e

/ |* }+ ]4 p9 N$ k& J  Um_szName = '{$name}'");" m( A2 J+ [/ D/ Z
while ($row = mssql_fetch_object($find)){
3 n, ^. d+ m$ O3 n& h: Hecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
, |/ s7 Q- ]" F" V% o6 i3 \2 _$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], / k$ ?. L. [, R& h' H7 p* b
# b3 {+ s5 Q  `- s) z% s
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],   R: ?" n. h5 U4 G
$ `( m1 }" O7 h0 v$ [% ]: D
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
" E) m4 M1 x( `( K* E
+ K# c5 X3 z; Y5 Q, sN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',   b6 }+ [6 h3 [& j9 q9 s

- N; W$ v/ x, T' c'{$ElementUpgrade}', '{$ItemPierce}');");+ ?# ?# x, S5 S/ O# }; [
}
% M6 z6 `' P7 z; B$ p9 V; ]& I# Z: V  d5 \0 @
}
- R4 J. n3 Q" A- [
* E/ f. f. l0 \* u+ z& {% p0 g}( p# R  c8 P0 V- H6 n- N
8 R7 `; G& b( L( E* f
$InitForm = InitForm();
, R; n9 @) o5 d% h  r$Listener = PostListener();6 m) e& i. {& m
5 v2 ~2 H, G4 M) r
?>$ k* s  W% s5 T  v7 f8 S% C5 s3 e/ L
0 J. f9 s; A* o4 b& F
0 N7 A) a0 K/ u
# U1 M9 U/ L9 B3 p1 U( x3 x
& Y4 ]# j' {- m* ]* b9 i





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