飞飞世界论坛

标题: 物品发送脚本 [打印本页]

作者: admin    时间: 2016-1-10 03:43
标题: 物品发送脚本
<?php
" q# d2 v4 T( i3 mfunction Connect () {  F( E7 \3 O1 y5 T8 X
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB 7 N* R- m' `9 i8 [  k1 y7 ]+ \
8 @0 R' H, j/ T3 w) c- d
Failed.');
# g- a. p3 G# }) m& K}, y& O- H' y+ f5 P# L8 R
Connect();
6 c, `" F# Q. S, P; Q) h$ k1 g; [
function InitForm(){
& b; V7 J4 F( R$ ]6 X//layout for the form
) n2 l& Q; s8 q, l. V$ ?4 vecho "<strong>Send Items.</strong>
# [7 f9 v5 h& V$ Y% h0 N& F<form name='select' method='post'>
6 o; |5 ^" P# w$ G5 H( |' H<lable>Character Name</lable><br/>
* u7 I+ l5 P+ [- e<input type='text' name='char'/><br/>" j4 C9 E2 J' K, _& f+ J$ t
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>' ^6 y$ L, h( n  z! w
<input type='text' name='item_name'/><br/>
# K% d9 l7 `0 M<lable>Item Amount</lable><br/>5 a! T1 a0 y* p# h7 Y$ U  x
<input type='text' name='item_amount'/><br/>6 A- X+ d; \8 l- s
<lable>Item Upgrade Amount</lable><br/>
3 y) B  B5 ]# N( l<input type='text' name='item_upgrade'/><br/>/ |3 z2 A1 [: I, N9 U7 W
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)* `8 \4 \% \0 ?2 N$ {

8 i! Z- s/ N, M& B$ m  s</lable><br/>
2 F& p: R- [0 \, @; e$ G* _<input type='text' name='item_element'/><br/>
$ b7 J' P$ i* p; f: I( @$ _<lable>Element Upgrade Amount</lable><br/>- k/ A9 M7 `# B7 v
<input type='text' name='element_upgrade'/><br/>. w0 d; J$ ~/ U; L* \2 W6 `
<lable>Pierced Amount</lable><br/>
8 P" \* g: X1 f/ D<input type='text' name='item_pierce'/><br/>
- \$ l2 p  C2 B<input type='submit'/>+ }6 t+ {; e- m& l" f; S! [
</form>";
/ W4 e3 A' H; m5 D' a0 G' M}9 c, x( O8 n. P( g- N) s
7 l5 d& M1 I1 }, M
function PostListener (){1 g8 p4 |) k* t3 H7 F
//Add more post variables if needed and add them to initform() function aswell
  z$ u9 M( E: g  u" U& E. ?* u. L* S
################################8 R- ]; S- |2 \" X1 A
##### Connection and Post ######
8 h) k4 [  m: v5 V, {################################
  E2 {2 x  F  u$name = @$_POST['char'];
4 u, m  y  ^2 N  q$ItemName = @$_POST['item_name'];
/ A! v: E, U3 n1 o! z* G/ Q$ItemAmount = @$_POST['item_amount'];. A. L# b( }2 U' C: u# Q+ @
$ItemId = @$_POST['item_id'];  z% k, D, ?9 {
$ItemUpgrade = @$_POST['item_upgrade'];
; l' {' S* H& f+ r9 R$ItemElement = @$_POST['item_element'];+ ~+ S7 M7 W: @7 ]& h/ [
$ElementUpgrade = @$_POST['element_upgrade'];
) d  ?* J+ S4 b2 v  @$ItemPierce = @$_POST['item_pierce'];
4 l& z4 j- \" K" z+ j################################
) V8 U+ [9 z7 D# e: x$ L$ |, G5 B1 i  _9 u( }+ r
//Check both variables for empty value$ f- s. ]$ O$ g; n" \/ M0 e
2 A' C# D2 f6 @0 P, a, y) U
if (!empty($_POST['char'])){7 P8 E% a8 G, z* o: Z: g1 L
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where 2 p7 E1 a' t4 o( }" d4 \

1 S4 G. B* X  [+ v6 C. |$ Jm_szName = '{$name}'");/ c! D! N8 W/ P0 |5 Q
while ($row = mssql_fetch_object($find)){, Q7 p  E( \5 r  h
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
) y7 ?  @: V$ b- e/ h; V' w$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 9 u. x1 Y) ~6 E

+ I# h. Y: @2 s) [[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
* C& {' W) G7 E
9 D% B. U1 L4 G, ^[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',   u5 L+ M7 s8 V$ l# A2 g1 ^3 d
$ W1 h- q, Y7 T8 l
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
: m0 B- B9 e" G  F& W* N7 B3 H
8 o3 l6 K& J6 s# e, s; j'{$ElementUpgrade}', '{$ItemPierce}');");
; V( Z$ `* p$ ~  ?}1 w  O3 k# j: m: B4 `

+ [7 o5 t" ?2 v}8 P! g0 O* y; u( w% C
; a1 T: w6 v8 w. ]5 H: j& O
}9 \& l# ]2 R9 E9 W+ n3 d5 Z

9 ?/ {& Y- q( o$InitForm = InitForm();
/ h8 C2 U2 V$ j3 d: f4 y$Listener = PostListener();
! U4 p6 u0 A/ Q" R3 Z
' i& ~! f) z" F# ~?>
/ B: z/ O! h; S! T3 l" \3 A
- k9 [+ h4 H- x
& S. P4 z7 ~$ ^) j! y/ ~/ O% s! X' ?: Q

. f6 a8 O; {+ X




欢迎光临 飞飞世界论坛 (http://www.ffwold.com/) Powered by Discuz! X3.2