物品发送脚本

admin

<?php
function Connect () {
. V* b; Z' w3 q& L% ]+ J2 N5 Zmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
0 j7 f7 M4 a6 e! `, j# x6 I5 L
Failed.');
}
% |6 k1 u) e4 ]# S- [Connect();

function InitForm(){
8 C) C1 `& j! p9 y6 X' {8 Q//layout for the form
$ L$ }& J6 e* hecho "<strong>Send Items.</strong>
# m4 W: L0 A6 S1 \<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
1 \" I. ]3 S1 d: W0 T; i<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
1 N6 s$ M1 q1 y; L, M<input type='text' name='item_name'/><br/>
9 h9 A$ T( d+ p9 E; f/ U+ v<lable>Item Amount</lable><br/>
: S2 L' v- t/ a' a3 \( Z( C<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
4 L- G- x) W2 ?<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
- b- h% p7 O, M. n1 F2 T<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
( j/ K: [7 H9 ?+ v4 {<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
0 H3 W! x7 h8 G9 D7 t- x3 {<input type='submit'/>
</form>";
}

% {5 h4 J1 U' O/ Cfunction PostListener (){
/ r$ a! N7 N: `" ]//Add more post variables if needed and add them to initform() function aswell

) `# _8 O2 @+ ^% r3 ^$ f% J# A################################
7 ^  N8 ]1 K7 e##### Connection and Post ######
################################
$name = @$_POST['char'];
1 h+ {% Z- g4 r1 c% \- n: D& Z$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
- p* _6 X' j9 F* u3 i6 y1 I$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
( g# R3 e# ^! b! [1 b$ItemPierce = @$_POST['item_pierce'];
1 _/ l) N: H0 B; y################################

//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

8 p2 B1 [6 b0 k4 }4 Nm_szName = '{$name}'");
+ N3 ]5 |4 _& o( g% G0 B/ d) o( dwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
( Q4 l8 n0 [% f9 w3 s3 a9 h$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
5 A8 }* k" S: a: O3 j2 O
$ \* {2 X2 o5 @7 c! ?, w[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
& t/ x6 T8 J& ?
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
( ~3 U0 H7 b- X# P0 ~; W+ T
+ K: f* U6 r! c- U( P" {) I'{$ElementUpgrade}', '{$ItemPierce}');");
}

6 F' Y+ N, G- N+ ~" N/ Y}

6 I4 _: Z! y5 @- |3 d: B( a9 G# F}

$InitForm = InitForm();
5 r. U, z  s5 I6 k$Listener = PostListener();

?>
+ y' Y, X+ u% R0 d$ o1 z/ p

7 }( B& E# o+ H: c