物品发送脚本

admin

<?php
& y7 c- w5 q1 hfunction Connect () {
, s0 P% I8 W9 s1 ?mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
- X6 {$ C6 q: N( z5 y' C2 m4 \}
4 |, N, u5 S& \Connect();
, c5 a& T; m) N" ]
7 ~3 C" B) g) Pfunction InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
! \1 ~* o' J3 r9 U6 J% S7 ?/ Y<form name='select' method='post'>
' N3 W. x" L* K2 i( `! g<lable>Character Name</lable><br/>
9 f: W; R6 {* ~) Y/ o4 c6 i2 m' @+ d<input type='text' name='char'/><br/>
  |$ [* }- U) v0 g/ b<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
, z# P/ r; j. v( e+ s$ T( k<input type='text' name='item_name'/><br/>
3 s. w2 D/ j; s<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/>
; v: }4 j- I+ v- o<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/>
& a0 h. l# q2 {  d<input type='text' name='element_upgrade'/><br/>
7 @" R+ I" U: Z$ f<lable>Pierced Amount</lable><br/>
7 h, G$ h2 z4 I5 C<input type='text' name='item_pierce'/><br/>
) a  b" U# O: l<input type='submit'/>
" d+ X& `0 s2 n, A9 c</form>";
- A1 D7 a7 c: A! ~$ D8 b' C}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
, o( O6 D. S* H4 s
7 A, u+ L/ `& `- ]: }################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
7 A( X5 C/ E6 I* `9 G. S; y  W$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
# f- O5 G% z( l$ItemPierce = @$_POST['item_pierce'];
################################
0 p& f& C- m; z0 w$ b$ t
- |% k/ ?  E: w: p5 ~, s: Q( G//Check both variables for empty value
5 o5 t  [8 `  V( r0 v
if (!empty($_POST['char'])){
, F/ I. i: f) W8 p! \$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
  |* C6 z4 P8 Y; N& g8 }
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

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

3 o0 N  ^2 G& A2 L) g2 D/ E$ L) y[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

8 `2 a& t& t9 rN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}
% c1 F3 j" W8 P+ ^9 r
}

$ U: I& I( _% a1 k0 }4 Q}

$InitForm = InitForm();
# ?. z0 y' c& U7 [5 E7 j/ w- B$Listener = PostListener();

: q7 B! ^5 `3 N% H6 M?>

$ q' K% p7 f; ]! m) Z