物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
; \7 a! n8 h, Y+ h1 d* J
5 Z' o8 h9 T& E! _* yFailed.');
" T+ g, W* H) ?( r}
Connect();
( S& ?" }% k& o
function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
$ S( ~) \) D+ }3 ?8 |" p<lable>Character Name</lable><br/>
- y! |' k! N- o. D  n! O<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
  J, f( \. T* _. X) c5 j( }1 ?+ {<lable>Item Amount</lable><br/>
, i: d2 A& D. ^5 x: w. _<input type='text' name='item_amount'/><br/>
<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.)

</lable><br/>
<input type='text' name='item_element'/><br/>
2 l& T- P% r( C+ b/ i<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
  `% M' m% y$ n( v( H; U<lable>Pierced Amount</lable><br/>
! X2 I" B; |; [2 i# y6 ~' K) t9 z<input type='text' name='item_pierce'/><br/>
# M1 T/ S% x1 b3 `6 k: c<input type='submit'/>
</form>";
}

! _/ I( Z2 z  q4 Rfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

0 K; `" [, u5 w7 M################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
2 L( O5 [1 V, s( K9 `) Z4 L$ItemName = @$_POST['item_name'];
! J5 T+ W* X/ M+ p# Z1 K$ItemAmount = @$_POST['item_amount'];
2 J( p# ~; |/ Y' q% ~$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

: i& ~/ r0 [% N& P# J: i//Check both variables for empty value
4 S$ i( E+ y+ N) n: B* c/ I$ D- }
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
7 V+ M0 F& ^8 O3 I* w
m_szName = '{$name}'");
4 i9 l# `+ F$ n% Y3 lwhile ($row = mssql_fetch_object($find)){
% H! S5 s, `2 _" h# y, fecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
; R3 \" s" H# H0 L- @3 |
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

2 X$ R! e% z% r% w[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
- c9 d) ~8 j2 x* s' n+ ~' J9 j. A
% `& U' Q; L* P" u1 K'{$ElementUpgrade}', '{$ItemPierce}');");
}
- w! @! L3 V* Z
8 Y% n) U6 P) q1 c, h}

}
& {! P, R$ V2 C! V8 O/ i
) d* [6 r; _" u, N1 {! l$InitForm = InitForm();
$Listener = PostListener();

?>



+ O) z& I5 _' k3 x$ q
; t) m* O1 Z/ Z& J1 G