飞飞世界论坛

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

作者: admin    时间: 2016-1-10 03:43
标题: 物品发送脚本
<?php9 d8 j+ m& l* _7 S
function Connect () {
" W% s, u6 x1 O( }# vmssql_connect('Server','UserName','Password') or die('Error: Connection to DB 8 R4 N+ f# b) b5 M5 n
& t9 H8 g/ J; \$ C% J
Failed.');; e% ]$ e( d2 p8 q) X
}
* y8 J: q& I+ d3 w! M+ j. Y6 y) aConnect();
) h$ O, n* q% d0 @3 H/ j( B+ T
- C# Q, \) B) r8 O& [  a/ Lfunction InitForm(){  V6 s' B5 r  Y
//layout for the form1 b8 S, |2 b+ I5 _. A1 k$ ]" n( {
echo "<strong>Send Items.</strong>' X; _6 f3 \, ]4 w4 x6 `; x
<form name='select' method='post'>
5 Z9 _0 ?7 z/ S<lable>Character Name</lable><br/>! O  h: f- ]; @9 ?
<input type='text' name='char'/><br/>9 V2 r+ r! b& X! M0 N: r
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>- E  c# m/ u/ k+ r& N  [
<input type='text' name='item_name'/><br/>( @# O" W! }+ Y2 X
<lable>Item Amount</lable><br/>3 h% b2 |; w# K, h5 o
<input type='text' name='item_amount'/><br/>. E2 p% a' o- T& h) d
<lable>Item Upgrade Amount</lable><br/>
$ X  _0 D5 ~/ T5 `! P: V5 f<input type='text' name='item_upgrade'/><br/>
0 H, B& ^9 q1 k8 X; P<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)( Y, t# i; Y$ _5 {

. j% Z* l$ ^% d: R: e$ r</lable><br/>) G9 `& N3 M8 {8 e
<input type='text' name='item_element'/><br/>
6 _/ W% W1 q) `# j<lable>Element Upgrade Amount</lable><br/>! V; G! `& s" t( `
<input type='text' name='element_upgrade'/><br/>
5 p% P6 Z. b. g* Q) ]" A<lable>Pierced Amount</lable><br/>8 J0 m. U) I, O1 U5 ~
<input type='text' name='item_pierce'/><br/>
! E; {& R4 O# P* ^<input type='submit'/>, X/ |$ z1 Z4 i: C' Y
</form>";5 Z, N; n7 I' M( x6 F
}
6 i. y- N$ N, x  V. O, z
' A: \' \! N: n7 A/ I9 _function PostListener (){8 v2 \* c3 T7 m
//Add more post variables if needed and add them to initform() function aswell
2 {1 m" N4 v" i9 R; g0 s5 s# q, O3 J6 W, r
################################# q2 \4 [5 q8 f$ O# f& I" R
##### Connection and Post ######
% Y- s. Y2 V0 I################################
; U1 b/ l% I, R5 |- j9 C6 @. J1 ]$name = @$_POST['char'];
( X. c7 s! X) f/ k2 i$ItemName = @$_POST['item_name'];4 E; K& e$ i  P  a( Y8 L) i/ {: _
$ItemAmount = @$_POST['item_amount'];
, f' ?( p) a+ H0 V" K  B% e/ D. p$ItemId = @$_POST['item_id'];
3 e/ u8 G+ l& s: E5 m. Q" n$ItemUpgrade = @$_POST['item_upgrade'];
' y$ \. f; H$ W$ItemElement = @$_POST['item_element'];
. I5 i$ z: ]6 M9 \2 {$ElementUpgrade = @$_POST['element_upgrade'];& J: ?+ Z9 D: I3 ?( |. `/ W/ c
$ItemPierce = @$_POST['item_pierce'];
5 I' q) n" \3 A5 z################################
  A. Z0 V$ v/ q% |+ l( T* O
1 q9 J( g1 ^+ x4 ]) n) A//Check both variables for empty value
& j. {! B# O6 O3 ]+ v
" S5 a$ b% S; S) \  Oif (!empty($_POST['char'])){
/ g1 @, n# |: v# G$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where * @2 V2 z9 ?5 M, j1 t

# R6 O9 g% A+ f1 x0 K9 G' V" Wm_szName = '{$name}'");
- a1 y0 @4 E) s6 I9 c/ vwhile ($row = mssql_fetch_object($find)){, F$ r" d; q) H5 ^  _4 X
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";& N0 ?% M. ]5 c% W
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], ' V/ H2 p3 T% J- c3 |$ Q

& u7 F. E" i# c[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
* K2 P" T  f! ^$ g3 s5 f  `, [: j2 ^* U' @
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', : s, `  Y% r1 _' x* O% d  i5 Y$ F; S
' G1 w. z' o  ~# C' @! I0 U
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
- [! q; o; R& t% o9 \! a4 |, V  t8 I/ o2 n/ J
'{$ElementUpgrade}', '{$ItemPierce}');");1 l1 \  M# P4 c+ ^
}+ V, z, u! j. o) n" {
6 ~. p5 v/ j$ B+ |9 z" U2 I
}
$ F( j' J/ D! Z( W9 @. H3 q6 Q8 W3 V# B% ^9 c1 t0 V! N
}/ c7 Z. C3 g6 {& f2 J/ s- o
+ K  m- y7 c$ E/ D8 Q+ ~1 Y
$InitForm = InitForm();
4 n. t# b- a: b8 g$Listener = PostListener();6 M# h/ k1 v: Q% u6 y) Z9 f

3 z2 _) ^2 E' |/ Y0 P! _' z/ f?>
' ^9 L- ~% L4 u" S1 H# Y
) O9 ]+ z6 V8 E" _! U
, D) w) P1 C# ]4 @- x8 ^/ \
# V) I( Y: @; _2 d) o7 h7 D" a4 i9 i7 c( f% A3 m2 D





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