飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
, X/ I5 T2 B9 W# F9 \6 f! X; c
function Connect () {
0 b0 ?+ N- f1 C! S, k
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
5 o, p1 b+ H* L, N/ g
6 A h7 o( d0 B8 {" U4 w
Failed.');
. }4 ]. v0 r1 k* T; P+ i0 {
}
% Q2 }" _* {) |
Connect();
& Y* f: f2 u! x
4 j# |3 p4 v7 e' a4 t9 I$ W
function InitForm(){
) ]/ ?# h+ V* e( d. k
//layout for the form
2 G" {" E' h- F, \6 d. A* ]% m! _
echo "<strong>Send Items.</strong>
) y: ^( M8 F: \9 ^% {" p
<form name='select' method='post'>
4 c5 I: V8 Q' C' E
<lable>Character Name</lable><br/>
! J$ K: f4 i% }' w$ e: Z: o& Z! u
<input type='text' name='char'/><br/>
, ]9 R% K& a$ l/ q: ]$ ?
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
/ o, V5 T, Y+ C- H0 w8 d' f
<input type='text' name='item_name'/><br/>
Z$ `5 g, Z6 Q" b2 F, Y/ r! a/ |
<lable>Item Amount</lable><br/>
0 ]$ `- z, s W ?, f
<input type='text' name='item_amount'/><br/>
% T1 A6 ~ z4 U+ C
<lable>Item Upgrade Amount</lable><br/>
* U1 M' }* y* u# C
<input type='text' name='item_upgrade'/><br/>
, ~; W0 d* t* h4 C) Q. Y' h( S# K
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
5 }% M6 J' ^' y* K7 @
" ^# L- K2 ]1 i& A3 o, I$ U. Y, A
</lable><br/>
4 J4 z2 F1 C, G/ B O
<input type='text' name='item_element'/><br/>
1 x, c- M/ h* X4 \
<lable>Element Upgrade Amount</lable><br/>
5 W: b' S3 X6 q6 X6 o6 f& a+ F
<input type='text' name='element_upgrade'/><br/>
$ o' b8 ^: @6 i3 M2 ~* w! S
<lable>Pierced Amount</lable><br/>
8 O& E" q7 G9 x- u$ J
<input type='text' name='item_pierce'/><br/>
& X. F' { U, F+ V6 i, O
<input type='submit'/>
1 E( S- J" \% P9 }7 f! g
</form>";
4 M# p: g, V/ n3 R
}
* c) @* t* F. E1 _
' D9 Z% j- J) r% w8 `4 [6 F( T
function PostListener (){
q7 u5 |6 b& g) g" q
//Add more post variables if needed and add them to initform() function aswell
# _, d: K8 j5 h" z
2 H9 p e6 A% l* Y3 o9 F7 b
################################
6 B) w- y3 A$ D. G2 t
##### Connection and Post ######
9 A% @4 E8 m2 U1 k7 h* y
################################
3 u2 F7 O) B! \' r1 B! D
$name = @$_POST['char'];
) I. P5 k, V5 K5 n4 ^$ p
$ItemName = @$_POST['item_name'];
& h1 C! m+ n2 B' L1 K
$ItemAmount = @$_POST['item_amount'];
& C$ A! E \5 p* z8 Q/ K! z/ X
$ItemId = @$_POST['item_id'];
8 @8 }) ]9 R& v6 r P
$ItemUpgrade = @$_POST['item_upgrade'];
4 F- ?! E% n# M+ m
$ItemElement = @$_POST['item_element'];
, n$ W5 z' `: V6 w' M
$ElementUpgrade = @$_POST['element_upgrade'];
% g$ |. u' {2 I
$ItemPierce = @$_POST['item_pierce'];
8 [6 v# y$ A# m1 |# [+ g! r
################################
9 }& B- c7 r! U8 j
7 |) y# T8 s0 h) o
//Check both variables for empty value
$ K" @: D2 G& {1 W) S6 N
; [2 `6 e, I2 |; r
if (!empty($_POST['char'])){
1 n D3 @; R1 R
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
2 Q! y3 i' v3 o% T6 I, a$ w
. j. `$ w2 G2 D* T# S
m_szName = '{$name}'");
* w! e6 G' i9 [+ W! a
while ($row = mssql_fetch_object($find)){
$ q0 s5 A+ |+ w
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
( P, X; i' i; Q$ U' k2 i6 Y
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
: _' n9 J) B6 Y' p R0 B" _
4 _# a; A- R, z1 H* w: j$ k- G
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
' x8 m) |0 K( g( \( V" b
4 g$ |3 U/ F, Z& L- h) O8 N. k* {& y" h
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
2 Q7 ?- J; ?* |6 `& i8 }2 N- ^
1 P3 \5 u3 f- [) d! F% G
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
5 U% b1 T7 w/ v+ q$ B# \
8 z' u/ `3 M2 v6 b7 h$ E, q8 ^+ Y; |
'{$ElementUpgrade}', '{$ItemPierce}');");
9 c4 L" x6 w/ O/ |" s
}
! J! v/ R5 |8 f( R5 V5 @
5 V8 o7 f4 r8 }; D7 h8 i3 f: r6 W' Q5 x
}
- p7 C/ J' ^5 z( b1 \3 e
6 q9 E7 ~/ p8 W7 E* V: v
}
$ m3 w% Z* _& {. X, U# f% i
( P) h. O$ r1 z; h- p# Q
$InitForm = InitForm();
9 m; p# x' u5 |8 V6 f3 Z
$Listener = PostListener();
2 u5 @+ V5 s! E; X7 L% b; B
. K& j: Z% U& B. h; _; y! g
?>
( Z5 q, f; q* U: D. c
& `1 p5 J# k3 c9 f! N4 k# t
- }6 O: o6 T& ]5 ~
* n: g: [9 Z3 @4 b$ |) O* L7 ~
4 M1 Y! @$ I: Z( S5 V: H
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2