物品发送脚本

admin

<?php
6 a6 c3 X0 O: G; S, qfunction Connect () {
) i/ F" h9 {* R1 g9 umssql_connect('Server','UserName','Password') or die('Error: Connection to DB
) I+ D- |" w6 b. [$ L, D
Failed.');
}
Connect();

function InitForm(){
1 w1 U4 F. Y+ ?4 n& d5 K//layout for the form
* N. g1 U% t- A; Z5 mecho "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
# Y  o, M. b: M$ J<input type='text' name='char'/><br/>
5 m1 t1 I/ x, D- @5 l% A. n$ ~<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
' Z& E+ {/ a& H* E+ C& p; S, l6 b<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
* A$ R. a2 ]* H1 y) F3 h  l<lable>Item Upgrade Amount</lable><br/>
8 r; L4 ?( _- H3 E  x8 Z! x/ k<input type='text' name='item_upgrade'/><br/>
6 B0 P) d+ c$ [3 {+ n$ u4 V3 R$ V" @<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
<input type='text' name='item_element'/><br/>
, G9 X0 k: m# q9 @6 c. W8 V9 T3 _<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
; `6 V! Y7 G/ v<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
! {! R- T+ C( B5 {</form>";
}
7 @" N0 L, u  L5 F4 C
/ v2 k% D  H& Qfunction PostListener (){
: ?3 P; h: {9 R8 h* q. `' u//Add more post variables if needed and add them to initform() function aswell
9 y" X; C6 T9 {: ^9 ]8 Y! L& f( o
, ^- z* ?1 s5 R/ }0 u################################
##### Connection and Post ######
################################
3 {) j. N, G9 O$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
, D; k% L  U; z0 X8 [$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
. @( C; i( U1 A3 J$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

' O5 B. u, `0 m# O4 \  Dm_szName = '{$name}'");
3 h' g5 e1 o! f2 d# i! m, F# ~: |! x" Cwhile ($row = mssql_fetch_object($find)){
* E- Q. o/ E8 C  Oecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
+ {& q; l) H* X' Y# ]$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
2 K+ e. L& Y% P( Q  t
/ Q6 X8 i5 N  S, m' ^8 g[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
" e1 [+ {9 D0 t
8 g7 T) u9 V3 ?) p: `5 {N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
% _: H% W% ~  p2 {
1 l% E4 ]/ h9 n3 f& H( S'{$ElementUpgrade}', '{$ItemPierce}');");
; j0 J% q% o) c* `* a; U}
6 r: e8 H6 `: G; g& c8 W
( a' x, \; k7 h& f- W* |+ T}

}

$InitForm = InitForm();
8 [- v" @7 h4 t0 p- W. m$Listener = PostListener();

?>
. v* i$ J: W, L
+ k8 Y& L$ Y/ S% s0 _5 ?

- L5 ^$ T, t8 x& z6 S
) b9 @7 y, C: k