物品发送脚本

admin

<?php
function Connect () {
( f' ^# m8 j- B. x) C$ a7 dmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
Connect();
/ t3 b+ n5 K4 b: ^
function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
; Q6 t9 m" l+ X<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
3 w5 u  A: s" r$ ^7 t; Q* C6 a+ r<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
2 L2 h1 e9 j/ Z' B& b<input type='text' name='item_name'/><br/>
0 G" n6 J( [% F& ~<lable>Item Amount</lable><br/>
) [) b" G+ N$ u% I7 B0 K2 h<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
  X# D" M! G) W+ e<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

$ _, f0 }  }, p</lable><br/>
2 s2 |( q- M, N+ f<input type='text' name='item_element'/><br/>
  L3 z; k( L( O/ x<lable>Element Upgrade Amount</lable><br/>
% T: _8 o6 p6 J<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

! u1 F5 Y! ?7 ]8 V9 p% w0 |################################
" u! X0 i# }9 F' z5 _##### Connection and Post ######
################################
0 `; X% R, v2 y) e+ d7 u+ T$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
* H- a6 W5 v% U% i4 w0 ~: k- T' D$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
7 Q5 F* @( S' ^$ItemElement = @$_POST['item_element'];
' q5 n3 ^5 }+ M0 z, b' q$ElementUpgrade = @$_POST['element_upgrade'];
. [3 ~+ ?# i; C$ L/ }2 _6 p$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value

9 X: V+ e0 a4 R" e$ S6 T0 rif (!empty($_POST['char'])){
) E. X: B& j* w7 Y4 s! a0 r$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
7 Q% `6 Z8 k" N) `6 x- M2 jwhile ($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],

9 f0 K+ J& j- D: [* t' W[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
' O) H8 ~3 z# S/ V! z
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
% j+ A  h$ R, @# |0 B# m}
' x* D% K  v8 F4 [
6 n- i8 ~% f; E# O}

}

$InitForm = InitForm();
$Listener = PostListener();
( g: ~& W: D) j& ~
?>


0 i9 I5 P/ k' r7 G2 F# N
3 Z1 x. u6 p  A, q* h2 z; G
1 v: N. ]2 p& p/ y* [" L