物品发送脚本

admin

<?php
function Connect () {
6 h! t/ z$ ~/ p% G8 |3 o- hmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
1 i; \4 ]8 ^  i3 h6 A0 [4 a
' B8 J3 V0 E2 ?) I+ CFailed.');
# _. d9 s' S" x* m1 N}
Connect();

, p; f; R0 E+ P: t4 gfunction InitForm(){
9 n9 `  c9 K" J* S! V+ U, [+ w2 ]//layout for the form
  e# T0 a4 z+ ?! t( Yecho "<strong>Send Items.</strong>
8 y8 ?! T  r- Y9 y, v<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
9 p$ P* h8 a2 H: M7 R<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/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
) u! ~+ Z, J8 I<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
9 u' \' b$ f8 T! U) k, r
2 J* O1 J  b+ ]6 t</lable><br/>
' t$ G5 i8 Y+ ?; ^<input type='text' name='item_element'/><br/>
3 r4 |, i8 g6 R  D1 g<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
8 i2 x$ D2 s0 h; K7 c<lable>Pierced Amount</lable><br/>
2 o9 v# {$ n5 H: L<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
% ^' N- Z5 U( P; g; H& m}
3 P/ T% X3 ?6 }5 T  y
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

( w0 ~5 M7 V5 b9 A) h################################
##### Connection and Post ######
################################
' J9 g) I* ?& R. q& O& c9 y3 s% ~$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
+ t/ g: v( Q+ u9 c& W  d################################
/ G+ m0 a7 H2 \' G( a$ L! Y
//Check both variables for empty value
+ J6 K7 @  w0 `1 Z5 w
# t$ n# j+ b, K, yif (!empty($_POST['char'])){
! Z: P2 a& Q9 q; j) N' f  h$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
9 x' U- d) p6 g* l* _
) `1 e2 j- B; w6 om_szName = '{$name}'");
4 {: o% y0 U+ h6 |. }& o, O) |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],
! l8 [! P$ o9 d# M
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

1 D( j% z7 d2 w. q1 d( C$ b[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
6 C7 E7 t- P9 ~4 M" @
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
2 u+ M/ o# F1 o* N0 V
'{$ElementUpgrade}', '{$ItemPierce}');");
: r2 w  h2 o% i+ d}

! P" @- Q8 w: ?2 I+ Y}

}
. `2 i% n1 K) M9 C& q) L+ Q4 V
$InitForm = InitForm();
$Listener = PostListener();

?>
( y9 a7 U8 O& J( v; I
9 A. \. N: v1 T) D* c; k1 r
) ?$ ?! h* r- ~