物品发送脚本

admin

<?php
function Connect () {
! k& Q) Y7 b- T$ w: imssql_connect('Server','UserName','Password') or die('Error: Connection to DB

$ \* e6 C9 w1 d; @' KFailed.');
1 y! j0 b$ K+ a4 f}
9 S% V: G2 ~! p$ J5 k% s% D3 lConnect();
* W9 }; U- l, U4 X
* d  Z: ?$ I3 C3 L* R) [3 P. lfunction InitForm(){
8 q0 B* g8 O, G( N  h4 r//layout for the form
echo "<strong>Send Items.</strong>
/ l$ ~) x' c$ x! |<form name='select' method='post'>
<lable>Character Name</lable><br/>
<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/>
<lable>Item Upgrade Amount</lable><br/>
& ~0 N% ~$ w9 S; T& t: k<input type='text' name='item_upgrade'/><br/>
9 f2 `7 K0 Y$ Y' K! c8 b0 \<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
" o1 k5 H4 F- [/ `2 ?( o" Y% g& j9 T<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
7 t* M8 Q- K- K  e3 ^* z<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
3 b+ {4 K) d& X# A8 p# j  k<input type='submit'/>
, t6 R0 T" y, r/ Y, X8 w</form>";
3 W# q+ I  H! h- B$ ~1 w) F}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
7 a. Q* M0 H( D+ h
################################
& ?& Y6 U: ?* G* n$ S* ?9 M5 e##### Connection and Post ######
################################
9 [6 y8 G9 M; B% Y. |9 |& D$name = @$_POST['char'];
0 h# b- \, t, @5 @$ItemName = @$_POST['item_name'];
1 J  z$ r- W0 H; Y$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
5 p$ V' ^+ Q, X& C# T% o/ ]$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
/ n9 P  ?# {8 a* g4 Y! B  L: b$ItemPierce = @$_POST['item_pierce'];
* p! j5 a5 f2 _" A* K################################

//Check both variables for empty value
# _+ ]% K+ i& ?4 w0 y, b
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
# |% J5 J: T0 T) P$ f, B: M
/ c- r+ j- E( {% em_szName = '{$name}'");
1 f, ?) M& C9 f+ Twhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
4 P3 G, a. B4 [! s5 F$ H3 [$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
6 q1 e* W; b3 \! w, {
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
3 `9 V& }7 y' D$ @. W# ^
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
1 c7 h" C, h1 L
: t. k3 }4 _- s- ~$ b* H, g' m: W* \N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
3 w5 x, B8 J$ Q
'{$ElementUpgrade}', '{$ItemPierce}');");
1 x- R/ f- s4 J& w) |& m/ V, i}
. F3 v# `& A' `$ b
}
# V; u! Y! k2 X4 k" F
! ~& k6 |4 x) s}

! |1 {' g) T/ b/ O2 H) R; |$InitForm = InitForm();
$Listener = PostListener();

?>
, {- t- Z9 q* ^. n7 L7 D

& C) J/ U, a8 X! W, ?$ Y8 r
' z0 U$ }& w" L0 ^$ D/ Q; h
  Z* P" B1 J) `0 N6 \8 a