物品发送脚本

admin

<?php
" J$ n( C& ~5 N4 V7 tfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

! x, M  c' s, R0 C$ JFailed.');
}
" \. y: g; t7 H0 j' S# r* j5 `Connect();
9 r+ \. v' |' k) X3 M, q2 c2 Z
function InitForm(){
: `" E2 u) Z5 I, R* G//layout for the form
$ I' l; _9 ~9 Z) Q8 w! C. B" Oecho "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
8 u) ~1 J: j. [- `8 v9 Y! C<input type='text' name='char'/><br/>
7 o; c$ _9 ]5 k# z8 l+ @<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
& N& X+ }! _3 y/ C  X" y+ \<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
  [; x3 b4 U2 I<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/>
& l/ I4 A- O7 R1 b! |<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
, U" A# j7 F( r8 x, m7 b! e. A1 P<input type='text' name='element_upgrade'/><br/>
  U- ~1 \- h# b$ d4 U. D. L<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
, R* m& Z3 U' Y<input type='submit'/>
</form>";
}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
' t0 B$ W8 V3 Y/ q9 c
6 `9 F! V  ^) `################################
6 y( @6 |1 @# J: U6 G/ |' |! x##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ R" v' b) E  S  ^  e' g/ ~$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
7 ^+ u# F# Y6 S3 L* \0 X$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
) z  M7 P% l& f################################
7 C0 L  R0 q# F
) [  Y8 W6 i5 h0 A) J$ r//Check both variables for empty value

5 o4 u+ `- P/ b  b+ {, b$ kif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

' r1 _% m: S1 S" I9 ?m_szName = '{$name}'");
. u! p4 x! e! @8 ^. Swhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
6 w( ^; _% H. T2 B$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
9 A, F: D" P2 B+ p8 J
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
5 v' K% ~- V* h( x$ K9 {' V+ u  `" A
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
: d0 _0 Q. Z$ c
2 U6 i1 t2 C0 j- B; ]7 V'{$ElementUpgrade}', '{$ItemPierce}');");
% P7 m( c7 U2 H$ [0 Z7 a}
, s" O  j* q; s* O. Q5 y7 G2 n
}
, f1 T+ K2 e, O+ ^+ \3 i4 u
0 r0 ~9 Z' S: Y3 w4 u5 h0 q}

$InitForm = InitForm();
$Listener = PostListener();

% K, e, H; S5 t1 D3 K6 Z* o+ h?>
0 u' l2 o1 I9 @, i) {3 k
2 S8 k8 j" h" a9 z

$ `, S2 p( E1 x