飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
9 d8 j+ m& l* _7 S
function Connect () {
" W% s, u6 x1 O( }# v
mssql_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) a
Connect();
) h$ O, n* q% d0 @3 H/ j( B+ T
- C# Q, \) B) r8 O& [ a/ L
function InitForm(){
V6 s' B5 r Y
//layout for the form
1 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) \ O
if (!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" W
m_szName = '{$name}'");
- a1 y0 @4 E) s6 I9 c/ v
while ($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! ^$ g
3 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 \! a
4 |, 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