物品发送脚本

admin

<?php
9 D7 ~. d9 c0 Wfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

  x, J9 F2 D' n$ s' X5 b3 MFailed.');
}
Connect();

function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
4 I( R1 W2 c9 K. M) }' q- s" H4 S9 C  M<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
9 x- W+ ^+ s$ @; O  C<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/>
* t8 G* P: f4 a2 Q<lable>Item Upgrade Amount</lable><br/>
' w, X! T& h9 v' z<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

% N- q$ ~1 O$ R3 r/ }</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
+ `. y" X  Q" b, @# H<input type='text' name='element_upgrade'/><br/>
$ Y" T- D# o% U; Y; ]; v<lable>Pierced Amount</lable><br/>
2 ?+ G) r% w+ u* D- Y<input type='text' name='item_pierce'/><br/>
4 a7 B- A5 X5 W! S7 J1 g- u<input type='submit'/>
</form>";
}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
, b, W, T2 x& X, a: }$ g0 [7 k
9 n3 X* L; h4 m" A6 x( O! i4 e################################
& H+ d9 t; W' x1 }, r. W/ j4 W##### Connection and Post ######
################################
' P; Q  o' q: ]( ?, d0 ]+ s$name = @$_POST['char'];
% }3 m1 E' U; c* d$ItemName = @$_POST['item_name'];
( z) C, f1 O; i! a$ C, Q' {$ItemAmount = @$_POST['item_amount'];
# ]. c; g0 q- b2 B8 b$ItemId = @$_POST['item_id'];
0 l* _/ j; M: x! S- o# z8 q$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
8 v8 M5 r! w0 ?$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
7 y3 W& l' X% S. J9 X4 k" P$ j################################

//Check both variables for empty value
. l# I4 t1 N+ J* W
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

, b3 j% J7 ]$ {m_szName = '{$name}'");
2 T" q* j/ F0 [+ G5 }$ c  b. \; vwhile ($row = mssql_fetch_object($find)){
1 k! J* {/ A) A9 Decho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
- ?6 M) m( o4 p- G$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
; P! V9 v: p, u
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
6 g2 Y8 P2 R' [$ ]* b; E
. `" k& f! @- z, }* C* ][m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

. f& r$ Q, F% ]) @( G0 u2 S, R0 H. w& R'{$ElementUpgrade}', '{$ItemPierce}');");
3 ]$ s7 m8 g* f+ p}
3 d2 }) |# t  H' h8 K
}
+ U) o: D  k# X5 p1 P
  i1 t4 _0 [' C, z! F& F2 s. ^}

6 `5 X; @( E/ p$InitForm = InitForm();
" ]) K8 P, u0 h( K& ]0 _  |$Listener = PostListener();
# X3 J$ P5 ]2 j( F
& e: @9 j( \, H4 I3 _; D% Z6 K! D?>

# `! D+ ~2 T$ R5 ?
5 e" S0 w, S" p6 I1 \9 W

. h" a. r% H% z5 n/ s