物品发送脚本

admin

<?php
function Connect () {
4 z+ e2 u6 a3 G8 F+ Q  I, Z& Pmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

0 A3 _; W& \( f, OFailed.');
}
: a1 ?" j# s6 \9 eConnect();
$ N/ ?0 L$ i' n* p! M& V
function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
8 }; q) G' T3 b) G8 n* w# G<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
* D3 y! o/ x7 O( O  p<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
, m. G  x8 ^% [2 H  X+ g<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
* O/ Q$ N5 G9 Q; w. ?1 s5 N" R<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
7 L; U0 h! z. z2 f<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
! b5 A& y9 h/ ^6 B6 s9 d& w* K<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
+ n- y8 ~( _3 e! e4 s4 O+ e$ x<lable>Pierced Amount</lable><br/>
; C% i9 r. ^; a# G<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
: ~# f" P# I' l4 ]: g1 x9 L  J$ a}

  B0 ^; A% i7 b" {1 {function PostListener (){
6 G# n3 b( n0 k5 Q. I  o( e$ o//Add more post variables if needed and add them to initform() function aswell

################################
# F4 \- j  y* l8 S. X. c##### Connection and Post ######
################################
' E) w0 J& o. n' X6 \9 g$name = @$_POST['char'];
. w! B, c3 L+ Z" o  N$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
; ^* _4 J& ~2 _0 `. X$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
- L" V% v$ J) ]5 Z$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value
% i, q( `6 E  a6 J- s3 D4 {
if (!empty($_POST['char'])){
* O& {' q2 Z: k# a7 l$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
  ?9 q# u' A& e* n0 }while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: O' ~' \8 J1 a( n( X$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
- u1 w+ b; h/ Y5 T
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

) O: Q' X9 ~. F" \0 F% t: k[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

: \; A6 Z9 C2 s' z7 iN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}

7 f; G5 Z6 c9 R; C+ T! {+ e}

}
# F* o) f" s2 |6 Q( |
$InitForm = InitForm();
6 |* |& T/ m2 ~+ Q1 _$ c$Listener = PostListener();
0 P4 T' k. i, Z; w. _
?>
; m( {- t: z6 ~$ o! F9 u1 s: i
( `1 V. Z5 ^: }9 J* ~
5 L: V9 S$ \  j0 _; ?: [% y* {' o

; R* k( D5 X$ N2 @