物品发送脚本

admin

<?php
& k  G' @% p1 Zfunction Connect () {
4 n# V$ m/ b' S4 t" Pmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
2 `0 R3 I9 F) Q  y4 u
Failed.');
}
5 _1 ?( ~1 Y7 G' a& j5 LConnect();
5 R% n: L& `, C, e+ K
3 z. E  o' ^/ R+ c& C  _function InitForm(){
- N! L) G/ H3 h/ ]( |/ C//layout for the form
echo "<strong>Send Items.</strong>
8 n' V( T" l  m" ~6 X0 f7 E<form name='select' method='post'>
<lable>Character Name</lable><br/>
8 z7 Z" _: ~$ @! e7 L0 W<input type='text' name='char'/><br/>
, z) O' C4 V0 G3 [  F<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
) j( R7 r/ G- |2 j! s& A<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
. |4 ]8 C$ ~8 ?/ `' F<input type='text' name='item_amount'/><br/>
$ U, `7 e' `4 U6 Z4 E" T4 d8 w7 @. _<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.)
* b1 `5 g" R5 h( S6 [
</lable><br/>
<input type='text' name='item_element'/><br/>
6 Z! g+ X# n1 x3 ?<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
  A& U: \; _. L+ R</form>";
}

function PostListener (){
  e  [% ?/ V( Q" e2 ]* y//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
! G2 ~& R  ~  o" S( @7 g* Y$ g1 K5 [$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
8 |3 m/ s2 N& e' J: J( u$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value
4 k4 z: ?) h) O5 w0 A
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

. c$ C$ U2 T6 Q' O, R" P/ X4 am_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
' `3 S, k8 J) s5 j9 ?$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

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

" A9 V5 o6 J, a5 K[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ {$ l! O9 z# B2 _
! l8 a! F+ W6 z( ^$ cN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

7 J/ [# N! m9 {, s: L'{$ElementUpgrade}', '{$ItemPierce}');");
}
: X6 b! m/ k4 w, v3 ]
4 L' F& q) S$ ~2 s% `" H}
) H$ `, x# r: r  f2 B+ N
6 r& V% m9 n. `7 _}
1 e3 b8 B1 q. a* ^* J6 W
$InitForm = InitForm();
( I, ~, I: ~* x7 {: q( F$Listener = PostListener();
8 B& C" J2 H4 y
0 o  W2 V2 @% l8 q0 f7 K; |?>
/ |2 B& s" Z, Q  F
2 @% O/ }  U% N1 b  r
: @3 v1 G+ E3 {3 H0 e

7 v) `* Z4 @: Y& _- y