物品发送脚本

admin

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

Failed.');
}
Connect();
+ ~1 Y8 \6 t% n  w0 U: k0 ?+ P
* i3 ]- P3 j# z  f5 d/ @( wfunction InitForm(){
//layout for the form
# x. e2 {. y) j+ k+ Qecho "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
' g, v3 U* k8 b& w<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/>
& ^3 Q4 F% N: B0 e' {<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
1 y" Z0 I9 \* o0 z% }& w<input type='text' name='item_upgrade'/><br/>
% ~$ e$ U: `" I; B<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
2 I& N! ^7 D" I: w- P. w' ]8 I+ _
</lable><br/>
; y9 t# \" S5 f1 H4 H<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
: _" k/ V! F* R6 {8 T<input type='text' name='element_upgrade'/><br/>
& {& I# s4 j% S<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
5 f2 d+ J8 I; u+ R! D6 J1 ~) E<input type='submit'/>
- v; u4 g! }% V% u</form>";
- p. K6 A8 T7 q" j6 \8 Y* Z}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
; F! e6 G( B' \
# M2 ?" a% d( p' W* o' P" `! h; _1 Y  |################################
##### Connection and Post ######
$ V  x( X1 j* a% d1 Z4 _. X6 M################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
+ C9 ]7 d2 Z+ Z0 Q( K$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
2 q/ F* d' h5 o# K0 e! R################################

//Check both variables for empty value
" G5 G6 y8 G- s
1 d; W) S5 C5 k, z9 T# O" P+ A8 iif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
) P4 G- w1 f% O, e+ P# D
' C. y* Y' F5 m  K7 b/ Rm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
) N+ C9 j3 O% L1 e  h3 [$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

- g- u& x. N2 W  i' K" O+ Q[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

' G# A/ I( R$ Z  M9 YN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
  ]+ q( }) q; `& h2 @' u4 `
5 j. |/ ?) N) Y. p'{$ElementUpgrade}', '{$ItemPierce}');");
}

}
9 B) Y8 a$ B" V0 I9 h  N3 N
- u; `( q7 b, d* _2 U}

: k4 |) T- w6 i( L& ]$InitForm = InitForm();
& c! ~/ ~5 m4 l% B1 \) S$Listener = PostListener();
1 d. n5 Y. ?- Q' b0 g
?>
5 o- h. w7 L% ^# H( M: Q
+ y; _* A, P7 S# k3 f) X' ]