物品发送脚本

admin

<?php
function Connect () {
2 q' t! N3 U3 Dmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

* u0 i0 f# A8 E8 H! K* S% N/ yFailed.');
$ }0 `! x4 m) ]' E( e, l}
" O  G! H( |6 Z+ S  @: YConnect();

, S* z6 F/ e: Y0 t8 z9 gfunction InitForm(){
2 S+ F9 _( T/ i5 l' y) e9 n; S//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
2 O6 k5 ^9 Y1 u/ ^0 ^6 t4 l<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
' n4 s9 Q2 \6 t) ^<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/>
  J0 D$ N/ {; R, |<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
/ F( @$ k0 W, P; p/ o<input type='text' name='item_upgrade'/><br/>
; D' T* s# Q. N9 d3 [) A<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
  A0 q+ x+ ?+ x9 e9 H7 U
, @. N7 Q3 r6 Q( s/ \</lable><br/>
5 ]6 j; Y, W$ C  v<input type='text' name='item_element'/><br/>
  _% N* q1 w! U4 }* U/ j1 y: w<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
3 I( G+ f  w& x# |4 w. n3 u<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
4 g1 w( E+ ~% Q; b/ a5 ]<input type='submit'/>
0 x9 T) ^9 W; _$ p& X) S7 j0 @</form>";
! ^9 a$ P$ Z. r' }}
& h1 u  k3 g8 w  A  t1 F
& T1 e  m  n6 i: g1 Qfunction PostListener (){
8 k; [" J& y- Z8 y, D& J//Add more post variables if needed and add them to initform() function aswell

* e" ?% [. W2 G. l0 T" z: y0 W5 j$ o################################
##### Connection and Post ######
! v6 T2 j5 W8 U8 ?4 s' V- p################################
( F: l8 v- \/ q2 G  b; W$name = @$_POST['char'];
  i' z: b* N1 z% u  t$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
  E7 p; q0 R) M# y, N' f$ItemPierce = @$_POST['item_pierce'];
2 C+ T7 Z9 {" }  m8 B; ]% z' E################################

//Check both variables for empty value
9 u) y& n1 A: k8 x* K9 @
/ ~4 Z$ o( s- u: A0 {if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
% c* ]" w: G* x0 i
; Z  l& d3 z' w2 u3 D1 Zm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
6 E/ _- q( T" F( L0 Mecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
! Y2 d. I' t7 P. \- |$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

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

5 m7 n3 G: d# [8 w& Y# P6 h9 {[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

/ Q' q  o6 f* @7 {1 @N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

, o: ^  X2 M3 @# B' p& _) O1 Y'{$ElementUpgrade}', '{$ItemPierce}');");
( B: x* d+ ?! D  R) |}
! _6 z8 S3 ?+ c+ f- Z+ H
}

: U0 _  @& {$ H* b" e}
$ ^* r8 C; n! ~) U+ ^0 \
$InitForm = InitForm();
$Listener = PostListener();

?>
# ~# t; j2 q& J! s5 r9 L8 L4 u

& J& Y8 J( }% B% z, v7 {
3 U. X% }/ }" X7 K' K% N& e. P! n