物品发送脚本

admin

<?php
: u; U/ D9 s( s* M7 vfunction Connect () {
4 F) }* @6 }( ~$ u) kmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
2 j  `9 V  m! H) B; J  `
Failed.');
}
Connect();
0 _0 u, w* S; V/ {  m
function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
& n0 v/ b9 ]( J/ |; `3 Y5 P( O. D<form name='select' method='post'>
# v( U' _0 t' k# |4 C+ n4 K( Q8 t2 I<lable>Character Name</lable><br/>
5 w8 _7 S' \, N3 S% b! _<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/>
5 b' \& I  K8 P+ I/ I<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/>
, J! m: R' D) C! M* k- C<lable>Pierced Amount</lable><br/>
4 E# I" A( {0 P<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}
0 ~4 K  r; g4 R  E! T8 b
/ C/ |' W9 {" t4 `* yfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell
+ A1 r, S: |8 W' Z! G
% F( ?2 m3 h! L$ f8 R* H################################
##### Connection and Post ######
/ ~( g$ l  r* e5 ]! A, r) @7 f9 @################################
$name = @$_POST['char'];
+ m% h+ l$ f2 R- l$ItemName = @$_POST['item_name'];
  k1 m0 Z* M9 {& q9 B" N1 L$ItemAmount = @$_POST['item_amount'];
$ H/ Q% s0 }; h( k. h- G$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
9 n" X6 k( P- T3 E$ItemPierce = @$_POST['item_pierce'];
################################

* R0 S% `9 p, b* b+ A- x# m//Check both variables for empty value
' [4 _. H' P7 U, }2 X" D5 X
+ K. Z7 H/ B4 f5 d* E, Qif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
: Q% o5 m: C9 H/ y4 y% W: L  E& Iwhile ($row = mssql_fetch_object($find)){
  j% x( F7 z" }4 Y  n3 hecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ V6 u, W; q: y! e" }3 ^$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
5 q5 O7 G1 {" S; ?) G& @
. Q  r4 s8 r6 L[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
2 W$ t- P& t+ _( P. U; s% V9 v
) _+ p8 p, F5 z8 }[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
, _+ g  q% L! K, S
# x+ T$ }! k3 q7 L8 z1 kN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}
: f$ ~5 @) z0 d" \  j2 @
}

}

, n5 W0 d$ Z1 {; z, z$InitForm = InitForm();
$Listener = PostListener();
& ?. t! N( R( c1 P8 D
?>

; [% {3 r; A9 }: ?6 n) n+ H. L