物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

* e0 h, P2 P, M2 J# W: C/ [Failed.');
}
- _3 u# P1 ]4 k6 X0 FConnect();

function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
& y1 s6 V# S. x- H2 P<lable>Character Name</lable><br/>
0 v/ e7 j( `0 d: k3 ]1 l<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
  w% c* x. L0 P3 N( m, p<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.)
5 k1 ~# v8 t! z. q# g! `( `
</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
/ E$ l3 R' O5 F+ O: ^& U% d3 T4 o<lable>Pierced Amount</lable><br/>
9 ~. b; z; n9 a/ u( o7 }1 g* `<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
7 l, b, w' s+ j7 G% g4 p</form>";
3 Q: U; z* q5 @% W6 E}
1 l2 B5 }" }0 l9 v' H: N: v1 C
# b; J% i" o; W% E0 _- [function PostListener (){
4 {2 {/ J; g" m6 {//Add more post variables if needed and add them to initform() function aswell

0 E) y- X: ^4 [6 x8 o) `) [0 t, g################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
8 x' ]# l5 X2 V* k' c" d* h$ {$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
0 ]0 W7 X; l: Q9 k$ItemUpgrade = @$_POST['item_upgrade'];
2 z, Z+ I9 y1 P$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
% j, t) d8 v9 T  f3 h) a4 D$ItemPierce = @$_POST['item_pierce'];
# G- c6 d" C3 ~: D+ M################################

2 Y& e# G4 W1 {( V, I//Check both variables for empty value
6 I1 R# }8 r( q/ v1 r4 a* G
if (!empty($_POST['char'])){
% R" ]- R* L& Z$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, f! g6 d4 M5 r  \; m9 W
) L4 Q' ~# |9 W' q/ J0 Km_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
4 B3 d% z. {% v  x3 lecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
, M+ U8 E: K4 w$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

, z  c! }% z& j- h4 p/ H. R& Q2 \[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
2 C, o1 o: n. G$ J- _
. |: ?& g) {) [, u[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
  H# C0 [8 t6 U' C
9 ]) U& D! U5 O8 H' [N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

! X' }2 k' y! [$ z  l'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

! d- v' n0 s/ |+ G0 t5 L}

# M. }, O& R& y" ]  r$InitForm = InitForm();
$Listener = PostListener();
0 H  o/ N1 [8 ~( N4 z) h
" ~  |0 J8 m6 a8 N4 S8 E2 ??>
/ [& x3 X% @* a$ h2 Q, i
2 a; R+ ~9 u' k4 \  R
  Z4 c% ~, p0 ]/ N( h3 W  V, A

8 ~/ [+ K8 ?  ~, w8 A4 N