物品发送脚本

admin

<?php
' H, A2 L2 m3 j2 yfunction Connect () {
2 ?9 ]# b' u* [1 J$ |. S: v! smssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
: d" G" m6 A6 s, [6 f}
8 J  I3 q. A& n9 y9 hConnect();

function InitForm(){
//layout for the form
) t: q, d* P5 vecho "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
! S" Z  n& _9 Q9 e5 F<input type='text' name='char'/><br/>
! X6 a. I* `9 U8 b2 s<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
, }7 J9 U& R) [3 L  N1 T4 I<lable>Item Amount</lable><br/>
<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/>
<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/>
9 J9 H9 \7 `7 c<input type='submit'/>
% R; T4 ~0 L5 ^7 O1 Q' e7 v& `</form>";
5 ^% E( Z* N' r- }}
& m1 R' t( c2 w/ @
function PostListener (){
3 w" o9 j: U$ E//Add more post variables if needed and add them to initform() function aswell

$ o$ L6 L5 k1 G  D9 P$ _################################
  L$ M" R7 m3 e4 c6 q##### Connection and Post ######
################################
/ j- Q: q7 e7 W8 r0 J  M$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
2 _1 {3 E3 t- _4 \4 G& ]7 H$ItemAmount = @$_POST['item_amount'];
2 y( m6 Y* C# f. I5 M7 C6 N$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
. |6 @4 ~1 z0 E$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
4 \  l1 `0 G) N+ j) ]9 M" h0 {$ItemPierce = @$_POST['item_pierce'];
5 U, K$ J) [7 D  }  n" J0 p* ]' }################################

0 ]6 }8 L; D2 f+ N, O% ?3 g//Check both variables for empty value
9 }) t+ l6 ^# n  f1 c1 R
5 p0 L" `" o$ G/ ^if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

, m; [: a& m! @  d& V+ e: o! T. ?" Nm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
- C' H( ~( C2 D3 A5 M1 r7 _echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
! K0 I- o/ f$ T; v$ K2 h, w$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

: `$ I* o# `4 b! i# ^[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
  C/ |" c% W! w7 I6 Y( P% a# N
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

5 K* _  f  e+ @5 m& j" b$ VN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
4 K: z; Y" |* f3 _, U* P
7 f4 o+ _5 Z7 [$ V: C* Q'{$ElementUpgrade}', '{$ItemPierce}');");
}

: y: ], e, Q, z# B9 A* [}
% X: L/ t5 M3 A, H
' F9 y! l6 v% K1 w4 @. S/ m}

$InitForm = InitForm();
+ G4 U2 K. [4 ~" }5 B$Listener = PostListener();
5 w/ h! e9 F. D) c! w& Q
?>

0 m5 D' A4 D( K) f$ d! }


1 z/ D% K4 a: Y& y* M4 d6 M0 q