物品发送脚本

admin

<?php
function Connect () {
) P# w! d$ W7 o. ^) Wmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

  ^0 E# v5 \% k3 ]- Q$ ZFailed.');
2 V% W8 w. H: @. J6 ~$ p& X  L}
$ @/ ^/ c* v1 f: C$ M8 A) _Connect();
# K% n0 ?* A6 P' h; B
function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
% x4 o/ |  q2 y% ~* F1 R3 }7 S<lable>Character Name</lable><br/>
) [8 g7 ?. V# q  ^, f( t1 K<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/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
  w9 |* [6 h$ I% ]0 }<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
" v1 T4 w. o: c+ G4 X4 k' k+ i- F<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
5 b8 N% Z# u' X$ ?/ ~. D
3 o5 p; ~$ O* S1 o: |& j: w</lable><br/>
$ l& u; M- M0 h/ a<input type='text' name='item_element'/><br/>
; E7 X; n- J0 J" s# @( t' K) P<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
  y+ X7 O. }2 {<input type='text' name='item_pierce'/><br/>
9 o" z! G# m7 W* V<input type='submit'/>
</form>";
8 }8 b5 c6 v) v4 \7 [}
: u2 k# @! y6 H2 b( i- `, L- U5 ?
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
# j% A$ g$ ?5 e3 X. r) X& q
: O. P# n+ m$ o  h" s- v- ^3 z################################
##### Connection and Post ######
################################
. L; C/ M$ W. |. ]" y$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
' [$ \1 I4 k2 m) x0 f) b- o$ItemElement = @$_POST['item_element'];
/ b: V/ S  _  v9 b9 Z( |$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
3 f: G5 K6 a6 a  h* `3 y* [
//Check both variables for empty value
% k% x: R. R& C& Y; y* I; ~
; v% @& T+ ]7 [( [3 cif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
! ]) H5 c* Z$ O; p
2 [7 b5 ~( x% }: X% Wm_szName = '{$name}'");
/ m* E2 r$ G# [; V5 Iwhile ($row = mssql_fetch_object($find)){
! p: p7 i4 c* w9 Kecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

1 b2 a3 |8 t; ~[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

( K, ^# n. D4 |7 R/ T[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
( q7 j* ^& k0 K6 O
( c8 n$ p# K- A8 zN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

/ c" j, G8 A( O% q. t. m'{$ElementUpgrade}', '{$ItemPierce}');");
! Z% Y2 v" q0 F* T6 ?* \: |}
  P7 T+ m9 l( C$ m8 l) [8 z
}

4 ]" l. D% s, {( o. ?7 m}
; |7 l8 H% C" v! B* i( T" E
$InitForm = InitForm();
$Listener = PostListener();
5 a; N' N$ L' R3 z9 k) t
0 P) x9 i% U$ ]& T4 ^; K?>