物品发送脚本

admin

<?php
function Connect () {
+ {4 K9 C4 E% f; amssql_connect('Server','UserName','Password') or die('Error: Connection to DB
8 c3 z8 a8 k# a7 F4 i
4 q( |$ X' G/ p  P) ^" \$ rFailed.');
}
8 D  k0 P" s% fConnect();
* j) M! j& n5 v& n9 Q9 C; W
function InitForm(){
//layout for the form
0 \) O# Y2 }0 I3 B. A& d, Secho "<strong>Send Items.</strong>
: u0 `4 H- k1 O; e, S1 V' A7 \3 E7 i, C<form name='select' method='post'>
<lable>Character Name</lable><br/>
  ]+ ]  x: d( E$ }* v/ L<input type='text' name='char'/><br/>
1 [: @, S6 B6 n$ x5 t<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<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/>
" d1 v. w6 S# [2 M$ F<lable>Element Upgrade Amount</lable><br/>
- y( ~* i) ]1 |<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}
& F: I' ?; V7 d" ^+ [; w7 Y
function PostListener (){
. k) }% I6 z1 _# Y0 I/ F- m//Add more post variables if needed and add them to initform() function aswell
2 a3 v& @8 x- I
################################
##### Connection and Post ######
  |  `; T) U4 Q% i################################
4 B1 X5 X- u% e1 e$ ~$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
& D& y% @8 m8 ?, _! D/ K3 a3 }/ z$ItemPierce = @$_POST['item_pierce'];
################################

& w/ o% x  u. a$ P8 e. [//Check both variables for empty value

5 V' H7 f+ [7 b6 m- V& y( \if (!empty($_POST['char'])){
; n8 Z# {: X# S. @2 n: N5 B$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
  h4 s. o* }: j/ Y7 U) K6 ~3 u
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
1 a: E9 \  }- n  V# h3 l- r" ]echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
! R. K: k! ?- b) \' k3 b# X* n$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
$ y3 {$ e2 W" q4 `
' u1 ?5 Q7 k3 ?7 y1 O8 d) h[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
3 y0 @* V7 l2 n3 P# O7 r& d
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
7 {  D! U& ^. k; g1 }3 d. g. [+ b
& p" W5 }! N! @& v9 v. z! p. V5 X'{$ElementUpgrade}', '{$ItemPierce}');");
- W. C& X, H4 C9 E}

7 e% W2 J& l9 ^0 J1 L}
/ n- K: [4 d0 Q' O7 `
}
5 b  N3 T8 h3 q( _+ H
$InitForm = InitForm();
$Listener = PostListener();
0 |, v# K2 W/ `
?>

" e  Q8 F4 Z' l" T