飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
+ C' F. n& U4 g
function Connect () {
" I7 ^; ?. v1 \) e* }
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
5 Y9 r% o; ^. d8 n6 m& [
8 l, \: j l! h
Failed.');
1 @! U. G y% D. @/ d% n) X
}
' }! { E% x! L/ _1 _- o6 h
Connect();
A1 k+ i$ H, o8 F
0 B" `0 O, L [
function InitForm(){
3 @% O6 Z# r, K' y8 q) v( _. p1 U
//layout for the form
8 ]6 j8 u, ]% j4 q
echo "<strong>Send Items.</strong>
3 _/ }& m L( g" R. s, J* u8 v
<form name='select' method='post'>
* B( ]3 G/ s9 b+ a- a
<lable>Character Name</lable><br/>
: A) m: T$ ?" b2 v
<input type='text' name='char'/><br/>
x$ g* U# v0 ~1 H* [* E% V
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
8 h- n! X& H9 R; B
<input type='text' name='item_name'/><br/>
V) |3 ?+ \/ z
<lable>Item Amount</lable><br/>
b4 {5 w3 m t4 M6 Y% a
<input type='text' name='item_amount'/><br/>
3 v: U' V5 ]+ i2 j- X) t. d
<lable>Item Upgrade Amount</lable><br/>
, X/ W. z) o/ K7 [3 Q# D( i9 F5 @3 H
<input type='text' name='item_upgrade'/><br/>
2 g* w) d* @2 m) W# `& Y! U+ ]
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
, J) L! ~5 }8 g F& q0 i1 ^- ?
$ `( F& y3 c8 L9 j
</lable><br/>
/ c. K% x' M) B3 [) U
<input type='text' name='item_element'/><br/>
+ M+ |% e0 t0 h) e! _; N
<lable>Element Upgrade Amount</lable><br/>
7 s6 m/ f- K& u
<input type='text' name='element_upgrade'/><br/>
: ^, O7 G9 c+ b8 n `( ^6 h
<lable>Pierced Amount</lable><br/>
0 `$ D$ { R, |4 ~4 f* N! e% Z
<input type='text' name='item_pierce'/><br/>
8 k- g0 G f: G
<input type='submit'/>
- H. V' Q& P/ g( i
</form>";
; X! T! M% u0 E
}
; h! s5 X$ i/ [9 t7 L, ]% e% V
- z1 K6 a6 ~% e/ t# {1 ^; e C
function PostListener (){
6 N4 h+ S1 g" w; u6 I y
//Add more post variables if needed and add them to initform() function aswell
" z9 \8 M2 B& x- t f2 ~
# L3 r- `& S* E
################################
B* w) N2 a- B& l
##### Connection and Post ######
: f, l8 U7 M3 s0 r
################################
6 A, [8 b7 p; G# i' u/ G
$name = @$_POST['char'];
: D) I& q, B* Y
$ItemName = @$_POST['item_name'];
" n( Z5 K4 H! {3 B
$ItemAmount = @$_POST['item_amount'];
" ? @7 T/ U7 l
$ItemId = @$_POST['item_id'];
1 c" |2 z* g" {4 @+ R, L
$ItemUpgrade = @$_POST['item_upgrade'];
, Z0 n/ Z7 J" }5 [& Y' G& V
$ItemElement = @$_POST['item_element'];
8 D- K7 N R6 X C* c: a- m0 k' I' v$ h0 V
$ElementUpgrade = @$_POST['element_upgrade'];
# x( ? L- K/ k( W% l7 S
$ItemPierce = @$_POST['item_pierce'];
2 ~0 r1 _: ] e$ ?
################################
) Y& U. P3 t# }. v! F% o( W
: W8 n) Q) E/ \4 _/ d* ^1 q
//Check both variables for empty value
1 p- K: z* c7 D- O" {
& _2 N2 p/ T) [6 c- J# j/ h
if (!empty($_POST['char'])){
$ a: S- \; ]( ~1 e {8 k
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, s5 n' z6 I" p) F
/ k1 E/ j1 Q' U# g% Y5 r
m_szName = '{$name}'");
; b; a; a& Z3 G0 j
while ($row = mssql_fetch_object($find)){
5 Z* E6 ]! P% u( S/ B: K5 P! E) E7 m
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
7 P; N( v/ `' r% k4 M0 g9 g& t
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
% q# x" l6 a. j+ t& {) X, B' L$ l
7 l+ u9 ]2 P) R* E- [" z; h0 R
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
( j; ~3 k9 h5 U( ^. u8 E+ v' \ N
0 ?- i4 U4 l2 h
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ ^' W' Q$ K. ~8 E+ h
1 k7 G6 E0 Z- R% @# ], d, ]
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
8 X, F5 J& x) P2 y# i( Y: Z
& C; q& ]/ @" ]5 q
'{$ElementUpgrade}', '{$ItemPierce}');");
" h0 u! N' `1 F$ z
}
U7 H, `. m) a: M' Y
. c( T/ Z: a! p% d6 |2 B* w* e2 C
}
9 p3 q9 l% j3 {4 _5 U# {
+ y$ E, @8 t8 y
}
+ \. D z/ e+ P* w! m
: ?2 Q e; O' S, d3 h3 x
$InitForm = InitForm();
6 b% Z1 g% m- v" P9 j
$Listener = PostListener();
|% R6 E3 P% w3 J6 O, `! ` a
: d( c4 P1 l& t* D" H* l, Q4 @0 L. [1 M
?>
4 f- w* X6 Y" ~4 H# l
5 k* w- {5 p- T
$ Q2 D4 q5 {' B% ^6 }
8 s! m+ n) f/ j m4 _" P
6 T r+ c, y/ U/ A5 g4 f2 Q
欢迎光临 飞飞世界论坛 (http://ffwold.com/)
Powered by Discuz! X3.2