物品发送脚本

admin

<?php
function Connect () {
8 k2 I3 c* U6 ^' J' @% S% Omssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
) _. z! b7 E3 }# N9 r6 V4 w& ^}
, Y+ T- V9 Z1 n: Z. FConnect();
$ u# b+ p& h4 X* |4 O
' N2 Q% l+ I4 Q8 t9 X" Vfunction InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
; n; q- Q6 G# B<lable>Character Name</lable><br/>
' ^: T# m& X2 g! ~  H4 u<input type='text' name='char'/><br/>
+ j# P& l/ g0 z' X, t: J<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/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
7 Z8 F, k) [% m) u% I; y( L<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
1 I, h4 u+ |6 ?+ z& Y# D" S& @
' k1 x+ R4 T1 s0 A" Z& a) ^0 D$ C</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
0 B5 F9 U$ o/ I9 y% A# g<input type='text' name='element_upgrade'/><br/>
' ?- X) A+ G' j7 g! Z$ W) K<lable>Pierced Amount</lable><br/>
1 `4 G, J; s2 i; u* r0 k9 A' W4 G<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
3 Q8 K8 U" h# G/ i</form>";
}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

+ O3 q% d8 O/ v; Q3 V) U################################
##### Connection and Post ######
& p2 J0 C- D& ^, f8 Y0 @1 q################################
  d- {) d' C) g9 n# N  C; v0 |$name = @$_POST['char'];
8 {9 T1 I) L, b$ o4 K3 n5 }. ^# {$ItemName = @$_POST['item_name'];
! y0 ?* g5 o4 P  k. x3 R/ u! ~3 c+ P$ItemAmount = @$_POST['item_amount'];
8 {# N7 v" g+ ]; g+ B; m$ItemId = @$_POST['item_id'];
1 i' V$ I" c# l9 W* o$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
7 r7 \0 W' \& p. {  h, U+ D( r+ r$ElementUpgrade = @$_POST['element_upgrade'];
; [; I9 L' v1 ?9 a" U$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value

# [6 g6 d  _7 r% @% e! Q* |if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
0 I! g& ~$ e: R# k  n% k, q3 ?$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

; N4 |; Z# f- |2 d, C9 ~9 {[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
( d4 K% N: E1 h
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

  X. U4 E) t% e9 q- DN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
5 z. h# [" D# K/ o: O}
! l% B8 r. G  ^. s4 R& Q0 e& \' }
, ^2 S5 v: I  ?! J$ @9 p" j}
+ Z! c& D) |5 E6 |# k" n; L! O& J
}

$InitForm = InitForm();
$Listener = PostListener();
% ~% z" o+ a4 o' T+ R
?>
2 _1 V- V; Z% R: V
8 T7 c! C+ |) C( g/ b

' i; W' l+ |& q0 C! H# C* A