飞飞世界论坛
标题:
物品发送脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:43
标题:
物品发送脚本
<?php
6 a4 v" r, G/ V
function Connect () {
8 |4 R, Z* U: y1 H+ `
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
+ `8 F H$ y. U) s* i- A c7 [
1 y0 @! O S! \9 P
Failed.');
* }5 ^3 ]/ ^% K8 ~$ x D7 g
}
6 v0 |0 i; S; s( V3 d
Connect();
4 [* K% k5 T B! S
4 U. h2 o. N+ O) x2 z& U. K* A
function InitForm(){
% t" Y; C! n( v) P o1 i8 k" @! p4 H
//layout for the form
, r1 n- { ~$ L% o4 j. q) o
echo "<strong>Send Items.</strong>
$ ~4 P0 J- P+ _/ x" c6 C
<form name='select' method='post'>
% m0 [6 `. X$ w" E
<lable>Character Name</lable><br/>
) O$ ^/ a3 m+ Y
<input type='text' name='char'/><br/>
5 P# ~3 D- X) f' C& @4 x
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
$ ]; g) F. n% O/ z* x
<input type='text' name='item_name'/><br/>
7 O- a2 L# u0 {: K! u# ]
<lable>Item Amount</lable><br/>
' H9 S+ n( E# m9 H7 x7 y
<input type='text' name='item_amount'/><br/>
5 W* a2 d6 u& G% G
<lable>Item Upgrade Amount</lable><br/>
( F7 b. _. D5 z, u- T/ H D
<input type='text' name='item_upgrade'/><br/>
! g( i) z0 d/ ~) u, L+ n7 o: m, J
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
% A& ?9 O9 {/ j, }' H- t: s$ b% q5 Z9 v
8 v+ B9 Q2 k$ k1 P7 Z* s! C
</lable><br/>
* @2 \. w+ u) A' ~% N2 p' V: U' j
<input type='text' name='item_element'/><br/>
1 y) X. r# w8 q6 I1 Q6 h5 h |
<lable>Element Upgrade Amount</lable><br/>
0 K) ~* Z5 Y. A Y; \
<input type='text' name='element_upgrade'/><br/>
D; ^+ i; _9 ~% i) u5 K% {
<lable>Pierced Amount</lable><br/>
6 }4 y" g* x# B* W! Z
<input type='text' name='item_pierce'/><br/>
1 _* q" h" C% S6 a5 p- U
<input type='submit'/>
8 z' d7 [( T+ O
</form>";
0 m1 M1 ~+ B6 W
}
8 p7 ~& D8 ?1 X. E7 D" m9 B
- Y% U$ F2 z+ r) k4 H
function PostListener (){
0 {- J. P! b/ J* y: \
//Add more post variables if needed and add them to initform() function aswell
3 t6 `5 H6 ^1 a7 W7 A
/ E2 v* T* o: H
################################
$ Z }2 A& U9 Q1 e/ `
##### Connection and Post ######
' q2 n: P+ u- B4 v6 w" G( B
################################
1 g' o: R/ o# i0 s+ ~3 f+ m
$name = @$_POST['char'];
6 g. ~( ?8 u, R: t9 d9 N
$ItemName = @$_POST['item_name'];
* q8 O2 }* `7 b$ u: z: H
$ItemAmount = @$_POST['item_amount'];
3 c% o1 \5 X' J5 m4 U
$ItemId = @$_POST['item_id'];
0 U' n# O8 a% P" Y4 D8 ]
$ItemUpgrade = @$_POST['item_upgrade'];
0 M) B8 k. N5 l2 t3 }
$ItemElement = @$_POST['item_element'];
- Y4 L* \* s& p; f
$ElementUpgrade = @$_POST['element_upgrade'];
/ J' _8 j" K4 F
$ItemPierce = @$_POST['item_pierce'];
: n. Y/ U+ u, K6 B6 _/ N
################################
, J! H) R) z+ c$ g! m9 C) |7 H% d0 _- x9 t
% R- ]" A/ B4 C C# c$ m
//Check both variables for empty value
; Y c9 V1 b, }# f' ?2 M( b
7 n( C4 ^! D. |
if (!empty($_POST['char'])){
! a" z9 T- w+ D5 I0 Z3 }/ O/ {
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
& u" ?5 D9 y3 r$ A6 Q: F e
5 K( f6 Z3 `# ]2 P& Z- K- T( E
m_szName = '{$name}'");
1 E6 ]# `, v) e1 D' j/ [
while ($row = mssql_fetch_object($find)){
) N. k8 b* n3 C% q
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
9 f6 U( P1 N& l* D5 N- _2 f% y
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
, X' l) I% r% E0 N. b$ ?( E
' D5 {- q x( `7 M
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
- A& M. e! k) t) ~
9 ^/ n8 T0 U) P3 t0 U6 H; l
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
! W: R; D. V( f, }
" \9 a; w6 D; ]( ^
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
" P1 s! K" Z1 q% L3 W
6 t ?, \0 V: d4 n6 v5 l
'{$ElementUpgrade}', '{$ItemPierce}');");
; U3 X% N, P4 b+ t4 l& u$ k
}
# K T V( Q7 a, O* h
3 p- y0 S9 c. ? A" {# x
}
2 s1 H. V) r) Y# J N( G% N
/ h2 @( F; `! O1 v" K6 c
}
) n( h/ |, ^, }: O6 s
5 s3 T1 M& c0 J: ^6 d7 p' T
$InitForm = InitForm();
# x1 m" o' B* G
$Listener = PostListener();
# W7 ?: d+ s5 g
# U9 b. t- I! U: m) X# @
?>
5 y$ ]1 j! B# K
- S0 Y5 W1 c6 R( \3 N
, v! d* r+ B& g! `4 O
: N( N$ I5 ]$ @, ]7 k7 d7 {
" O9 p1 x3 Z# q
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2