物品发送脚本

admin

<?php
function Connect () {
; F8 k7 o) }, d1 l1 Imssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
4 V  [  S1 u) A2 ^& e- a* N2 W1 Y$ P}
Connect();
+ O# ]5 {- G2 s2 s' z. j
) u+ Y0 H8 D8 K2 D4 A  N3 Dfunction InitForm(){
' x; w1 S. e5 }+ K+ d% e9 J//layout for the form
echo "<strong>Send Items.</strong>
- c% O) D$ k. M# ^. p( K<form name='select' method='post'>
4 `- u! k$ w' M# X2 c: L<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/>
<lable>Item Amount</lable><br/>
* T- l' @$ _7 k: E: ?  D& j) G<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
# A* t6 Q: X5 X<input type='text' name='item_upgrade'/><br/>
: J' r5 Q3 e! K6 _( X9 r<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
3 b$ H0 W8 i! k% G. \4 f; {<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/>
2 n6 o8 A! z! M5 x7 B: y% _/ _7 P<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

9 A; I7 J: g' ?function PostListener (){
, ^2 {7 u  i; l* b. K  F2 d//Add more post variables if needed and add them to initform() function aswell
7 V0 y7 [. L. i, H
################################
! y7 w, ?2 H9 f9 r##### Connection and Post ######
################################
6 c6 ?+ e9 n8 e/ Y$name = @$_POST['char'];
  |! \2 P6 K+ a- m  V$ItemName = @$_POST['item_name'];
# ~" E, G: O. q- H$ItemAmount = @$_POST['item_amount'];
  V) {+ ]0 y" r/ i4 [! r$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
6 r. B, W! n# L, E. k' B$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
4 ?1 m7 Y/ W+ v- x. o$ n( q" l
2 o5 H- k. w( V# O//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

6 |* p0 E7 T) l3 t5 q& `  um_szName = '{$name}'");
  x& W1 @3 ~  j1 uwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ b- p6 z9 ]( ]$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
5 A  @! ^% A4 ]8 h3 L! w0 t& L  m
& m( o) x3 D/ S4 q6 t[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
6 _( w# S& g+ Y9 a+ C
  K4 _5 }9 ]# @; W2 ~N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

! X  S. R9 R! @'{$ElementUpgrade}', '{$ItemPierce}');");
}
' p8 u( g+ P; l; N3 W4 N! B
}

2 S" D% r' k  ^3 N2 }}
2 w# l) D3 k; n* G8 r, i
$InitForm = InitForm();
$Listener = PostListener();

?>


1 K$ m- ~1 c1 u( U7 u3 f8 x- M. a