物品发送脚本

admin

<?php
' T8 g1 h5 d$ S$ dfunction Connect () {
! B2 f& ?0 u$ w& V* C7 n$ @mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
Connect();
) i4 |+ q$ Z& b5 S& [
function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
0 q% ^+ `! c) H0 k/ U4 _<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/>
1 P7 b% f0 k% G) h( g<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.)
. a4 o" P' p2 K* D
& p$ v. e3 i) ]! M</lable><br/>
<input type='text' name='item_element'/><br/>
  u. u& e" f4 o) y<lable>Element Upgrade Amount</lable><br/>
' c; b* P, x1 Z& l1 n9 a% c/ {<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
( O$ c. ?6 q* V2 d! j8 B' h2 ]<input type='text' name='item_pierce'/><br/>
' ?6 m- b8 b& h) v) O7 d) n<input type='submit'/>
: t) @* ^$ ?+ e% X' @0 R- ]# h</form>";
}

: \: |& f9 _1 a: Nfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell
. ?- f: Y! g- D8 j9 ~. r
################################
; q1 Y% A% d4 `7 c! I( X" P: H8 L, R##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
* C7 s& I8 D" u0 {% V$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
6 ]) C# p* q9 p0 ]# I; t$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
* O8 E; z0 A; T' J8 T$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
. L. s/ b; _6 I9 l
; M8 e) C7 k% g9 j* a- s//Check both variables for empty value
9 I+ k  z- m$ B% s- P, p& M  ^
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 p  ]' p  b5 E7 l4 Z
- @4 C% q) s  v  a2 c8 rm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
' [* R1 P" S0 M; F' techo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
( L0 M) {  ~# ^9 I9 I, I/ K$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
& y; h, a' g* z6 \! G
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
, s$ `6 w6 K( g- S. ?9 p/ t0 Z
2 W5 \% |) P! f  |/ r, t[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

* _! E$ y- l3 M3 h1 B% \. PN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

2 F5 ~; z( n. ]'{$ElementUpgrade}', '{$ItemPierce}');");
; k, P' p( K3 V# u}

. K8 ]8 k6 R4 J2 h/ H" j2 v}

5 S- N5 X% c9 s, n}
! V/ `7 e" y9 A" W0 L
$InitForm = InitForm();
$Listener = PostListener();
( x2 z' `; H0 k/ t" }
?>



3 f: S* Z. H2 y3 g7 p