物品发送脚本

admin

<?php
7 P9 x0 U  g5 a# O9 Sfunction Connect () {
  _& ]1 k  f/ w+ R( n9 q7 y4 fmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
  U- J. H2 C" ]6 u! Z
Failed.');
}
+ H3 D& R% ]( c, y" a+ A2 lConnect();

: @7 s  a4 b0 n! w" R3 ?% Vfunction InitForm(){
& t1 v6 B; b" u' A: k" o$ n//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<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/>
<input type='text' name='item_name'/><br/>
  V8 c. f3 ]- S1 o9 Y" N4 o<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
+ Y9 {" J1 t4 q' f4 i' _$ u* ~<lable>Item Upgrade Amount</lable><br/>
" h$ ^$ |/ s, A; `. S<input type='text' name='item_upgrade'/><br/>
+ f- y" @; F' p' w9 k: h! Z7 w: x. e<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
6 M& V+ k; }% U# }2 _- n9 S1 m( o
4 z7 n2 H+ j  N</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

function PostListener (){
9 j  w4 ?+ `/ n) s//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
7 p- G& w. e9 a- I################################
) b, r0 p9 ]2 ]( V# B' z$name = @$_POST['char'];
# r* K# P- z: O6 ?6 u& a% t" f! T  h$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
8 J1 L- r3 K+ D2 i, a3 q$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

2 s, x  o7 x9 w- ], j& X$ y//Check both variables for empty value
) g/ _+ ?5 o/ y! ?3 O8 D
/ x& E2 O  _, J/ D% Vif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

7 X3 K  p" c* d+ U; B5 j- tm_szName = '{$name}'");
6 S' [0 j+ Z2 @6 W& Ywhile ($row = mssql_fetch_object($find)){
. f, a. D1 G9 o1 a0 {. kecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
8 E% p  v: H) K
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
' u, b+ Y: n+ N) b! D; i: j
8 Z" a5 z# O' r. J: tN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
  B1 `8 b5 T& S) D6 p. l& [2 ?
- [# v' T  W4 b1 R, V8 @' T'{$ElementUpgrade}', '{$ItemPierce}');");
}
$ A9 k  |- x) b' x: B: m& P! R
+ z8 E4 D& c6 q3 d+ |}
* b+ L8 Y/ [. k3 X. p3 D
' X* X& V% X/ ]8 R7 [3 |}

$InitForm = InitForm();
$Listener = PostListener();

?>
* ^3 X5 m8 l0 f# e# }' v