物品发送脚本

admin

<?php
1 A) z/ S! J" ~# `- X4 c* W# [7 o+ C7 Ffunction Connect () {
+ k, x& r6 t' e  j$ ]( Ymssql_connect('Server','UserName','Password') or die('Error: Connection to DB

# j8 X3 f$ i/ |. D7 Z) YFailed.');
}
6 X% R( k) l- ~9 y$ y) E- SConnect();
1 E$ T- N  k7 q# e9 d/ U# A9 W
  r9 L+ Q  s$ s- \8 Efunction InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
. m0 U0 l! X# l<form name='select' method='post'>
<lable>Character Name</lable><br/>
2 [, Z: |" R' A4 U<input type='text' name='char'/><br/>
( G" }; U* E9 r6 ^* h$ f<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/>
2 ~! S  e( H+ j" A<input type='text' name='item_amount'/><br/>
6 g" l0 N! [( |$ Z: u<lable>Item Upgrade Amount</lable><br/>
# o; X4 U! }2 `& G# x<input type='text' name='item_upgrade'/><br/>
3 E  F! y* {5 Z* `2 A8 d<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; b2 H3 m2 q% ^& R4 |; x+ P$ q% {
</lable><br/>
  ^1 s( |, I" F9 a<input type='text' name='item_element'/><br/>
7 b" F$ ]" F! W' J<lable>Element Upgrade Amount</lable><br/>
) Y5 J, c; d" Z4 ^: S<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
( _. M( y6 Q0 ^/ ~<input type='text' name='item_pierce'/><br/>
3 \" x! I% R0 C1 f% \7 G# j<input type='submit'/>
</form>";
}
  ^# {( h' Y" ]% p/ z( ~
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
1 ^0 @7 `( Z! n0 m0 Z( }. H
, l, u0 v' t3 n, V* P/ ?$ r################################
6 g0 l$ ]7 S% R: E# U( C7 X##### Connection and Post ######
2 P7 ~* |; e& t$ K################################
# m' F6 s: \! h; s$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
) T- c/ v2 U9 h: W- E- N$ItemId = @$_POST['item_id'];
: S4 l4 {9 L8 N5 K  M# M$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
6 F) P, T8 M0 x- \$ _' ?# b$ElementUpgrade = @$_POST['element_upgrade'];
: M1 A! W' k+ E( `  I, k$ItemPierce = @$_POST['item_pierce'];
  t3 |8 N3 n$ n& q################################
+ Q: |) Y  P- p5 H$ t4 B
//Check both variables for empty value

: G8 t9 c/ P# Mif (!empty($_POST['char'])){
* i/ Z/ L% N' j" f8 l. G9 s3 X$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
$ f. X; ?# k" U4 N
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
7 p+ ^' ^9 e" ?  ^$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

' |3 B$ V6 |) H- u  p5 s) ~[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
1 q  ^/ v3 W9 p# x, k
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
+ k5 V3 ]5 d; f% \
'{$ElementUpgrade}', '{$ItemPierce}');");
! x$ `) e5 a8 ]* ^' j, Y}
0 A7 L" N# W5 {
# A1 ~9 C9 W! }3 Q! J: Q$ \+ q}

}

+ J4 M8 x& y9 E8 l* I$InitForm = InitForm();
$Listener = PostListener();

?>



- s$ O5 ^3 g0 o5 \( L. t# s% T
5 h1 a& k! B$ r. z' a  n