物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
$ {% M$ i% v2 O8 ?2 U}
9 T- P  D; w, JConnect();

6 I8 f8 s& Y3 ~/ H$ c. f  kfunction InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
. z7 j* q# W: y/ f7 N' P9 R6 D<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/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
( S2 ], C0 i5 S0 m<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.)
" _- Q, W7 c1 o: `4 y, e4 c1 q/ l
1 [4 p9 a5 j+ t; i" |+ l</lable><br/>
$ U9 V, \# Q; T+ K4 ~# h<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
1 Q9 q0 Z6 d( Q% x+ M4 E8 Q9 C; K& O9 N# U<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
2 N4 m# S, s( o; A- C4 Q<input type='text' name='item_pierce'/><br/>
! @' {5 \# M. G" W$ z. ~. d; ]<input type='submit'/>
' q* F) `4 U& [& L$ d</form>";
}
1 A  b$ S& P. b8 v/ d
function PostListener (){
: {" ^9 Q5 ^7 D3 C//Add more post variables if needed and add them to initform() function aswell
9 n; t/ ~8 v( l; v) r/ t& s
" b* a* A, s; t9 P4 U* o################################
0 o' S, a9 o+ c( Y##### Connection and Post ######
3 T' f: h  `& u) h' ^* f4 w################################
9 c: V' ?6 c& N, O' S& }$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
2 ^* N2 G5 r$ H) G$ d3 B( p( l$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

& J3 m$ c5 d* J5 ~% q4 ^//Check both variables for empty value
9 }: ]/ |# Y3 Q" b4 K6 n
+ g& S5 ~% t2 I" c& B/ i& p* @if (!empty($_POST['char'])){
& B9 f. g; g3 g0 R7 R! ^$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
! y( j- J5 o+ _% n  e) b$ P0 q7 u. Y$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

  s- B' W& D6 q) d- W[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

* Z* ]; C. i. Q[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
& R7 V: G. M3 o% A& r
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

$ C: Q2 R7 F. }4 \' N, S'{$ElementUpgrade}', '{$ItemPierce}');");
}
$ |8 S3 u  _. d2 b1 f
}

$ \  }- H2 ]2 C5 T+ ^1 X) y" \4 q  Q}

% w3 p, R& b7 h$InitForm = InitForm();
$Listener = PostListener();
8 t8 ~- @6 o- K3 D
?>

0 d1 h  h, P4 j& H


* v+ {3 z( B' f5 [% s