飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
: M t0 u3 v: n, x: _* b4 q z+ T
function Connect () {
- k3 i/ S/ S7 ~
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
* R4 h4 z( F! o
! R( x# S( @3 h t" b6 x( J
Failed.');
; f$ y1 q( _8 {! v! a
}
; _* N9 R) x' v+ R$ `8 c
Connect();
+ C1 t% C& [: Z6 a+ ?
5 Y4 _ [- u3 P; o9 ]! n
function InitForm(){
1 K- y; P6 g/ ]: V9 G) B2 K0 `
//layout for the form
; P# Y ~- z' D1 y
echo "<strong>Send Items.</strong>
7 X3 s% Y" L% E7 `! k
<form name='select' method='post'>
B& x4 U6 ^* \6 \, u
<lable>Character Name</lable><br/>
- ?' s: B' m8 g2 ]2 N0 Y0 ^
<input type='text' name='char'/><br/>
. o" J' c! {: I" b' c
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
% Z) I2 a3 r! i ~
<input type='text' name='item_name'/><br/>
+ A+ o8 H; V9 X
<lable>Item Amount</lable><br/>
/ _6 ?4 s+ ^# z) h# N1 T2 z
<input type='text' name='item_amount'/><br/>
e, `- U: z4 U7 w
<lable>Item Upgrade Amount</lable><br/>
7 `' ~8 Z( j0 k$ o8 F) k! i
<input type='text' name='item_upgrade'/><br/>
( w& q6 |1 }- _- W. H5 g
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
9 h2 t4 N8 m4 F* W+ n, s; d
* a5 y2 C, l8 o2 q! m9 N. u
</lable><br/>
& l$ }* M; Y4 _( b9 R
<input type='text' name='item_element'/><br/>
' A s) F# w' R% j' Z* i' z
<lable>Element Upgrade Amount</lable><br/>
, r, d+ U& t9 Y% }
<input type='text' name='element_upgrade'/><br/>
4 `+ `/ Q+ F J# Y U
<lable>Pierced Amount</lable><br/>
" S+ a! q, F8 |
<input type='text' name='item_pierce'/><br/>
4 d# c2 o2 V8 R
<input type='submit'/>
9 _& d5 E; F% E0 m5 Y* A
</form>";
2 s9 K' U0 D8 R& O2 F8 H
}
. N7 y, l+ F/ ~$ V* V# {
( C% R! Y2 D4 G4 G* B, i+ z' I
function PostListener (){
4 M, I$ q7 ]' K- S
//Add more post variables if needed and add them to initform() function aswell
$ k, g( c |" M: f2 e
5 {" F& j# y5 W* b% R
################################
" c; P2 O- ?3 M% h+ Q
##### Connection and Post ######
2 l% a- _) n# a2 T' ~
################################
- X, M; m4 i& h) [8 Y
$name = @$_POST['char'];
4 q8 _) W' g) b5 k
$ItemName = @$_POST['item_name'];
0 K6 U+ ]2 ?- Q/ Y2 l* c
$ItemAmount = @$_POST['item_amount'];
& T# S; e9 q3 R( X
$ItemId = @$_POST['item_id'];
4 c g! i5 B5 p# _0 |; k
$ItemUpgrade = @$_POST['item_upgrade'];
4 k0 {' T7 h+ w
$ItemElement = @$_POST['item_element'];
7 B* j$ X2 W( k
$ElementUpgrade = @$_POST['element_upgrade'];
% g$ R% G3 `* r, I
$ItemPierce = @$_POST['item_pierce'];
$ g5 {: t6 o$ x U8 R
################################
3 O/ D* c+ R3 J6 G" {' P
9 e! t O# R, C" W- g7 X
//Check both variables for empty value
3 y5 h- u' z' C: @7 F
5 w" B+ [: s, d( J1 I+ m5 W( ^% F
if (!empty($_POST['char'])){
S) u1 t, n! T8 v7 X1 v0 q
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
! q1 J- \: e3 }* L) j. O
) n$ k3 H6 e7 J8 L2 x9 [* M
m_szName = '{$name}'");
9 V2 g& t& \, Q) @
while ($row = mssql_fetch_object($find)){
5 T' R8 X+ [5 O, e1 C
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
5 n1 B8 n! ^" F) A0 A7 h. j
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
0 X+ X# @) {) g8 A1 J# S
4 O, D" i9 W y1 v
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
# B' q G6 v n- R* e2 B' A( M
# L2 S8 V9 ?- k/ R+ j# e& M0 S
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
: G6 N) j* Y0 d* I+ o
7 e4 h4 k2 z7 ^
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
2 D4 m; B1 L4 d- f1 N+ [
+ a7 |" s, k |9 O
'{$ElementUpgrade}', '{$ItemPierce}');");
) A+ y- `7 D+ F
}
4 C6 o: F2 o+ {" W. S/ Y$ {
8 J9 e& g% ~ [
}
. Z+ F/ r; n( F9 l$ c% \" A
0 F# B6 z9 Q9 `! E1 ]$ H- ]# @
}
! J+ g5 T* K# Q$ l( f% ?: i
1 z7 ^2 n3 H5 ^, h! p
$InitForm = InitForm();
' T1 E1 j% c J
$Listener = PostListener();
# O% d& o' t% _) h: q) i
1 j0 P0 C2 G$ b4 t T% n. Z: _1 ~
?>
( x! d. n1 M2 {( p7 Y& k
* f5 z$ g% h3 T8 q% L6 v" X, H
3 U) K7 ~& `/ _8 y+ W; N- V7 l
# q8 q# n" c# _
1 r6 H( z9 P' L# ?* X1 b% c9 @
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2