物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
: D! Y0 U; w# j6 N; F$ n
Failed.');
( O, J6 r7 a4 e}
Connect();
3 ]( D" h) t  J$ ?6 D+ ^5 _
! G3 s  _& S& [) T0 k( Hfunction InitForm(){
5 K2 X1 v4 H3 K& a//layout for the form
+ [0 b% [# _5 S, L! m1 Pecho "<strong>Send Items.</strong>
<form name='select' method='post'>
: b  Z1 Z. ^/ d) u( N" C( J<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/>
: {+ g1 N) p( B& T<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
# o% u" _( V# P+ o7 v; m( O3 E<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
$ w5 j) n1 y& w<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
<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/>
<input type='text' name='item_pierce'/><br/>
3 H3 b: d3 [8 }2 T8 A<input type='submit'/>
</form>";
}

function PostListener (){
' r3 E  P* s+ V# _3 w5 o//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
################################
# G* F1 n2 [" |8 _$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
' R1 a  {" ]2 M4 i0 i$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

+ f) |! M7 y6 h  G//Check both variables for empty value
: p" T, m9 |  M! A
if (!empty($_POST['char'])){
( o$ ^# S- \4 ?6 S3 Z4 Z$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

0 C" Q5 \2 j  x1 m2 u0 L: ^m_szName = '{$name}'");
  K: }4 f# O7 ?, Z/ Jwhile ($row = mssql_fetch_object($find)){
0 v# I. f9 V5 K; Z, o8 {echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
, G" \2 Z% ^$ y, H+ y: [
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
/ V- t! v0 s- P+ _$ t
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
, t/ s+ n' E4 W, s  h, y
0 k6 V; z; q/ GN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

$ t. G3 p6 `" R& x- `'{$ElementUpgrade}', '{$ItemPierce}');");
}

5 L/ e" k% _& B4 \# a3 C# G& ?}

- _# b( g, y6 N# H% j4 U}
* |0 a* p$ p+ i  }. Y
$InitForm = InitForm();
$Listener = PostListener();

?>
/ E( T& k; i+ q5 @

6 a0 o! D3 }' r. ~9 E  t
- p% B; g3 r) x9 y+ z! i
3 ~. A( K& @3 m# r: Q% l