物品发送脚本

admin

<?php
5 Y) v, ^8 t; a  o- a, E0 A4 J# H' sfunction Connect () {
5 g3 ^! H2 [/ q# z3 h" y2 [) X0 vmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
' o; E( ^1 M& @4 e
0 @" C# g& l% k9 cFailed.');
/ ?3 J" i7 X# x}
, c" S& ]- D$ N2 G+ oConnect();

; J7 L9 b! {. C# z$ t  pfunction InitForm(){
5 |5 z5 p7 {. |5 n  [& i9 B  ?9 {//layout for the form
  y. \+ e, L2 j% jecho "<strong>Send Items.</strong>
<form name='select' method='post'>
3 w& F0 t* P% g/ h<lable>Character Name</lable><br/>
7 O- Q; @" F8 T$ t5 O% |<input type='text' name='char'/><br/>
1 M$ u) I  y1 F/ i% h* R  W/ Q<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/>
# Y! E; D, g+ \6 s+ V5 J- ^<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.)
& g3 P9 u6 ]( h' _! m
</lable><br/>
<input type='text' name='item_element'/><br/>
0 Z# d5 s0 d7 s3 D8 Q' X+ z<lable>Element Upgrade Amount</lable><br/>
  H; t5 C5 D- l. u% `<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
* ^7 W/ n% o, }3 @}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
# B7 e3 q7 f4 U$ d) k- U
################################
' }& m9 v; h/ ~: {: g8 z4 {, s##### Connection and Post ######
; m* V/ B( d' t################################
* O  d/ L4 Q' w$ K5 Y6 L7 R+ N$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
: i+ A' M1 i5 p$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
6 {8 O* h  d$ N4 J" x$ItemElement = @$_POST['item_element'];
  [" _- t. J- X7 N1 f3 d$ElementUpgrade = @$_POST['element_upgrade'];
8 L' H% D+ l  Z* m" f8 j$ItemPierce = @$_POST['item_pierce'];
################################

. M2 w, G$ S5 I5 R9 \# A% d//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
; W2 l/ V- `  j' R
' g( [6 A5 [, Sm_szName = '{$name}'");
while ($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],
+ X8 B+ H+ m* n6 F, F" F1 l2 G
# y5 R+ E6 e. g[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

: L! k) X5 h, c[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
8 ]/ e. \) }3 G5 }6 K0 X, \
6 j& X. l+ I3 m8 O  ?/ V$ @& W'{$ElementUpgrade}', '{$ItemPierce}');");
}
) N: {' \/ B2 a; R
}
9 X" i3 t/ q  n1 E
}

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

?>
+ Z7 H4 A% v3 q

0 J: U% b* H/ `' |* d( F1 i
# R, w. x& B9 T3 e5 L
5 T! w& i9 \* ?  `% H# e