物品发送脚本

admin

<?php
& Q' r6 W/ K6 ~0 v8 Z7 rfunction Connect () {
: m- ^8 p! U- z' x) U! n" Amssql_connect('Server','UserName','Password') or die('Error: Connection to DB

7 t! p/ d# }4 u- z7 d2 K# K% V" |Failed.');
}
Connect();

function InitForm(){
$ k. W* U; D0 `$ \: t//layout for the form
& z# I& I8 A: Z: Gecho "<strong>Send Items.</strong>
/ m% U; }5 Z  U) t& U- _<form name='select' method='post'>
3 d* x$ ]1 u' i, l2 [<lable>Character Name</lable><br/>
0 e* N" t* u, \+ j$ a3 F<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/>
. O8 N: M) ?5 n<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<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.)

</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
6 F: S6 [' j# v" c! T/ |<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
; b: \/ u! c1 x8 R- U</form>";
: v( b0 @/ B* V% [6 F' C3 E}
9 x, l1 z8 w9 Q% d& r) a
, r7 {+ e! H! ^  T( ^, [& W3 C8 {( `! Afunction PostListener (){
0 A* u. K  s- A& O1 k//Add more post variables if needed and add them to initform() function aswell
2 m* X5 W# v/ N* {5 H+ P% X$ r
################################
##### Connection and Post ######
, D5 _, m/ m% A6 y0 ]3 R################################
$name = @$_POST['char'];
/ i  K& d$ @* f, b* W! N- l! ~$ItemName = @$_POST['item_name'];
7 {# U) c7 K% T, e- d$ItemAmount = @$_POST['item_amount'];
5 j  i/ I. n* Y' w( l3 A7 i7 x1 d$ItemId = @$_POST['item_id'];
' ^0 p; z& q, W7 X- }  q$ItemUpgrade = @$_POST['item_upgrade'];
& h; K$ a5 p4 Q$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
  ]) {; B+ J; i8 x$ItemPierce = @$_POST['item_pierce'];
) r+ b- p& k* K, n+ O################################

; N# k5 J" }) I; @7 i//Check both variables for empty value
9 |  C* k" a( I
if (!empty($_POST['char'])){
' v4 k0 |1 ?2 b3 i$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 n( ]8 e- N2 N9 ~  M' V0 @3 V& w
" c( H$ Q- ]' [m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
2 V/ n8 @) N9 ?8 V6 K8 {. I4 H$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
5 {4 f3 s* W8 N# i* y: I! u! O* k, ~
* h- A) C2 z" j9 g7 \+ [4 u. O: ?' |[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
, I" s" Q( V4 C' T$ n: T$ l7 }
: u5 G: t) q2 _8 \  o0 d# t4 KN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
6 j8 b* u9 z+ S( A& |# |
'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

3 A& l9 D/ t, v0 l  }6 ]}
, d8 x! c% S  _/ ^4 |# b! N) j4 t
# i+ Z# ?0 M' v, i" l+ {+ Y9 J9 o$InitForm = InitForm();
$Listener = PostListener();

?>
4 |# y) k/ T4 F& ^
, q3 p/ n( E& W' s) j- L: d