物品发送脚本

admin

<?php
2 B+ l  U) s7 Qfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

; e( B7 u4 R/ l# d" n: J5 e; ?; e1 {Failed.');
}
Connect();

function InitForm(){
" U; r5 |; _6 Y8 C//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
0 w  y# p- X3 G! Z$ W$ J, u: Q& o<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
% s8 F1 P1 ]; v3 G5 G2 P<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
. u, z$ {& P3 X; `7 F5 g<input type='text' name='item_amount'/><br/>
) J3 {: o% _$ e8 u# M1 C1 n4 ?2 w& c<lable>Item Upgrade Amount</lable><br/>
( n( j0 M% }1 m7 M6 d- a, P<input type='text' name='item_upgrade'/><br/>
. G- B0 D& c7 A/ ~* \: T) O: C<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
# S) r* \# y7 @<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
) V% w+ W6 C1 ]; I" [<input type='text' name='element_upgrade'/><br/>
9 ~8 h' {3 n* J; a<lable>Pierced Amount</lable><br/>
* k+ n( T) O: C! C<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
  [; }  ]& Z! _  M</form>";
}
2 k- P0 |+ w6 K8 I, }
! F0 X* p" e9 k4 @. }! c2 ]function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
& ^+ n# U7 H4 H8 I1 d: [
################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ s' W" U, `5 m# s$ItemId = @$_POST['item_id'];
: N5 C& X2 j: S# b. N, y- l$ [$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
, u9 H) \* _! t, b2 R################################
/ u/ U8 d3 G- a* ^3 C/ h
//Check both variables for empty value

if (!empty($_POST['char'])){
& u7 H) J9 \1 O+ ?; B+ R# A% G& b9 Y$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
2 L5 q9 K( Y& r  ~- b0 N3 Vwhile ($row = mssql_fetch_object($find)){
0 [) [" c, U# b7 _$ Gecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
2 T0 g3 p, k  w, a- R$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

- f( b; _: ^. R1 K. u5 M[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
% S2 d) M8 W! w) q. y& p# u0 G
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

0 L& F) e) @/ lN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
( Y5 q3 o/ u, G% N4 d, D, Y
'{$ElementUpgrade}', '{$ItemPierce}');");
2 ~- u8 _. x& p5 Q( r}
4 o' a! L: r* j6 ]
1 l5 [8 C6 X8 b0 ~9 n: k# H}
" `, x( U: T1 A7 n, j; u) l
& d, w$ l/ [0 }( n( G' D* r- ^" I}

! e, H* e, g4 F! l$InitForm = InitForm();
+ G  A" g: J' R1 G  t3 z1 E3 K2 n$Listener = PostListener();
; X5 @0 q# P* D4 i
/ _% l0 [2 i0 M?>
' K  d; C) C" \) j9 d& y! X! ?


0 X. p4 O' a; k* e/ ?