物品发送脚本

admin

<?php
function Connect () {
! H+ W0 j7 w4 z: pmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

1 r7 E4 N5 P3 Q1 E( P+ PFailed.');
- \6 ]4 f6 C5 |! B}
Connect();

6 I7 N5 s9 U- _/ Z. w# U4 o% t  Efunction InitForm(){
5 P( _3 n1 E4 J- D//layout for the form
echo "<strong>Send Items.</strong>
$ y' F3 }; E7 A9 j' r, ~0 m4 G<form name='select' method='post'>
6 u* K. @- l3 T$ h$ G<lable>Character Name</lable><br/>
. X- P1 J' A9 a4 }$ B<input type='text' name='char'/><br/>
# a; K! |. _- F) z<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
- u' u; b4 v" L* X<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
6 s1 Q$ O. H1 m% p0 x) v<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
' p1 W: {2 D! {* y
</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
, a8 [9 j% y8 L; e5 H<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
* W& m2 n7 b. w1 X' r' W! r1 J) K<input type='submit'/>
</form>";
1 |, S4 p! T$ P}
$ K. J) g2 f  P6 H: E" U* J
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
% `: G4 R0 o; W6 U
################################
' `8 D+ E/ S: b& ^5 Y, A' Q0 V##### Connection and Post ######
################################
$name = @$_POST['char'];
$ e. v- Y* i6 x8 O; Q, n) E$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
4 X! ~) K" y; y' G' M
//Check both variables for empty value
( p5 L" E/ \6 J) L1 m
6 k" n: [+ \! c& J+ g$ p8 k5 F: ]if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
$ y' S, C& n; o$ l- r
m_szName = '{$name}'");
- C: V& ^) q* s9 ^/ T* ?  Gwhile ($row = mssql_fetch_object($find)){
. ?- J8 ?+ Z% C) Necho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
. h2 K- B0 `! O/ }  l3 E  H7 M
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
) m, t6 f" v1 X; k$ [6 @  S7 ?
. r) {" P) I. D. O# \N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
" b/ q- _% J# T9 `
! r9 R. P7 F" k  r' w'{$ElementUpgrade}', '{$ItemPierce}');");
}

  g% G7 {  h3 ^0 _}

}
8 t3 B# R3 w6 P! Y; H
- t. c$ B" i' ?/ o) A% L$InitForm = InitForm();
, \# k/ Z2 ?/ n6 s. c  ~$Listener = PostListener();
' T! t; Z" w" _" B  H
9 D" U/ D- l8 |?>




+ Z( a' T, o" T