物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
8 ^9 N% L  l* ]
Failed.');
}
Connect();
4 E6 z3 X( t7 f) a; s7 W) e- p
function InitForm(){
6 C3 v' @: I$ U+ s1 R1 D2 f//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
. ?7 M0 s! Z9 e% c8 ?% k+ Q5 h2 I<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
# O/ e) c  p, J9 _<lable>Item Amount</lable><br/>
/ B3 E4 [! g& [9 s$ E<input type='text' name='item_amount'/><br/>
! D8 G, \1 u/ G& O<lable>Item Upgrade Amount</lable><br/>
" N4 _5 m# d/ h- _$ E5 M+ [<input type='text' name='item_upgrade'/><br/>
' Z/ T$ @& K. G3 r<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
; o2 j+ ]. _2 D+ V2 n3 d' C<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
% U, [- L" p8 o1 T0 C<input type='text' name='element_upgrade'/><br/>
+ U2 U5 w& b9 L- q' q. A<lable>Pierced Amount</lable><br/>
3 M7 V7 H& L! q3 |1 y! z+ V<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
8 O8 L! M2 x# E7 H</form>";
& E( D. K5 t! F}

function PostListener (){
* w* Y0 J& @- {  @//Add more post variables if needed and add them to initform() function aswell
; k. ^3 ?% s# Q, r7 _4 H0 D# i
################################
##### Connection and Post ######
################################
( Y; V: c" x: b* E3 |- b  U$name = @$_POST['char'];
- e+ m1 I6 e2 ?/ u9 \5 J3 P$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
6 q2 |% a; _" K' a  ^! i) r  }% L$ItemId = @$_POST['item_id'];
7 x) g# F  T0 c, Z3 ]9 a! m$ItemUpgrade = @$_POST['item_upgrade'];
0 ?+ x: s9 h9 Z& c# D7 g$ItemElement = @$_POST['item_element'];
2 |8 l; `/ f- N; ^$ ^9 i$ElementUpgrade = @$_POST['element_upgrade'];
9 o! Z9 O8 R4 G( b9 v! j# k$ItemPierce = @$_POST['item_pierce'];
+ G% u2 f6 j) R2 C  J3 p################################

//Check both variables for empty value

1 P. h0 F+ Z% B8 qif (!empty($_POST['char'])){
/ m! O7 p  v" `( i6 E- O. F& ^$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
( C4 {+ M4 A5 J: W
m_szName = '{$name}'");
" @* L8 z3 j, \while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: g6 [+ H9 ?+ p* ~0 V+ `$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
5 f# m+ {0 p0 k2 b1 T1 g: O' B
7 o4 R* V% {+ I! y. T" `! n[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

& O6 b! U7 k1 |% X+ `; M[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

  u! [2 W8 v0 o/ N: gN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
- ~7 z) l; D; ~2 {
3 M2 F6 r5 s9 f3 r  V* P- K'{$ElementUpgrade}', '{$ItemPierce}');");
/ x* p: m$ O1 i: W& u}

}

}
# ]3 t: m- K0 h# |
. U" X$ A3 r+ B& U. ~" ?$InitForm = InitForm();
$Listener = PostListener();

?>

0 l$ a0 b- }3 o
: Y9 M1 i. u$ @
; @4 D: R/ B' |) a7 A
4 Q4 e3 |1 Y* F4 V# J/ J