物品发送脚本

admin

<?php
1 e* Z7 W  T' N- xfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
6 P& V2 o3 }3 H# Q8 j
4 t8 G) k' q  o* N' S4 xFailed.');
, z7 x1 {- O- s; r2 e3 y1 S}
: U* c8 u+ `2 @: R, G' M6 [/ J6 ]Connect();
% V8 t( _7 N" d  u
! y5 R" F; k1 _/ f% [% ?function InitForm(){
1 k! S1 D& v" Z, C5 b& [7 Q//layout for the form
echo "<strong>Send Items.</strong>
/ D" B, Y( `1 h2 r- O+ K# y& ~<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/>
4 h2 e/ u: S, v2 c% e+ g8 O<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
$ d4 R7 Y! a6 i2 @7 A<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.)

</lable><br/>
<input type='text' name='item_element'/><br/>
1 l6 b6 V6 G7 \2 S2 L% y<lable>Element Upgrade Amount</lable><br/>
  k: [! ~: g0 t) Q& H! f: n<input type='text' name='element_upgrade'/><br/>
  ]* }6 N9 g' E0 w<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
$ }3 ?& J  o* A3 {" X<input type='submit'/>
</form>";
}
! e# T/ ~4 B5 J9 _' D
( S9 Z9 Q7 x: xfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell
6 }0 |5 f% Y- y/ M
################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
& D' U) p# M+ z1 z  t$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
3 [5 _2 F6 E5 W  u1 X2 O2 H( Y; y$ItemElement = @$_POST['item_element'];
0 D1 Z0 K7 R' h7 N' l9 a$ElementUpgrade = @$_POST['element_upgrade'];
8 h) d% f& F! e( {( i$ItemPierce = @$_POST['item_pierce'];
################################

' Q" t( h& Z1 k3 m: T+ Q* U, ]0 X//Check both variables for empty value

2 V+ m3 ^) q) f/ _( bif (!empty($_POST['char'])){
4 ^" ~- J6 F% A7 o9 A! I5 X2 D$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

5 p- g) O; X9 x" S- O2 km_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
% f" b: d0 E  K8 y, ^  kecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
8 d4 o6 D; y2 ~' m( Q5 R% p
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

5 w/ C% ]7 x- ~. PN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

  p+ C; ^: z% J/ G3 S# g'{$ElementUpgrade}', '{$ItemPierce}');");
% `: v  ]+ t, z  |}
0 Y: G" F- N* ?7 V* d
}

6 g' m# n, A) v! Q. Z* N}
% _; _4 n# |- n8 g! J. ]4 d
$InitForm = InitForm();
/ p. J  w  [/ _4 X$Listener = PostListener();

?>


$ u5 u- b9 E+ ]: t6 M; k3 N& b9 A# f