物品发送脚本

admin

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

Failed.');
. H- ]. \, s8 S) h3 F3 y, E}
( o( a' P4 Z; b* s% P% IConnect();
; [& `# H& }0 s* R* U* {
function InitForm(){
5 e3 y7 U: e- j- r9 U//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/>
3 N* _% v9 }+ y" E. s% T, n/ [5 B<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
0 Q- u# Y* u! D<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.)
  O2 Y6 U) r/ I5 p
</lable><br/>
5 c$ d1 t6 t; L% g0 O0 X) |3 ~/ s. O<input type='text' name='item_element'/><br/>
5 a  m5 H! e" b( z* W0 b<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>";
' s  L: R& K4 i: W  H' _" `3 M9 Z6 l. y' o}
# [& X+ ]; x9 _, d
1 }: Z; j, u7 e# a7 U7 [function PostListener (){
- G2 f: T  J" i  M7 p" n//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
4 ?. F9 r# S) e7 e0 ^################################
' q4 Z4 a, C- p7 h; ]' u: C( r, b$name = @$_POST['char'];
/ {, l2 g9 l1 t! N$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
& _9 ?* o4 j  L: |1 \$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
2 J* E, j" k/ ~6 L$ItemElement = @$_POST['item_element'];
" Y0 k8 Y% m8 u9 o- y$ p$ElementUpgrade = @$_POST['element_upgrade'];
5 [  c- A# e6 J8 V$ItemPierce = @$_POST['item_pierce'];
5 V: ?) y% F/ e/ L& R, |################################

//Check both variables for empty value
! o* h. h) p" t
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

5 b* r* J6 g+ o) vm_szName = '{$name}'");
5 {2 S/ a+ m6 T4 X0 Twhile ($row = mssql_fetch_object($find)){
echo "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],
! ^3 I- g: P) Y# h2 U% v
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
( v) I, d% m  u- P7 H* m
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& @4 B0 c; p& c+ B# P$ W7 @
& d. e' Z* }! P: @$ p0 Z'{$ElementUpgrade}', '{$ItemPierce}');");
}
% L* H* @$ x' M4 z. V; a
}
2 ~3 u% F3 `9 _8 Z% C  L& W& B
}
9 h% K# I% Q0 N8 G: f
$InitForm = InitForm();
) ~( b* x" n$ v; Z; K$Listener = PostListener();
: O  B" _/ s: p
?>
9 y( c/ N# b7 f
6 `- Y" F& ~" p( q

. _- e4 R3 d3 B6 a5 v: g