物品发送脚本

admin

<?php
function Connect () {
& g, e' P8 `$ j0 x1 P: smssql_connect('Server','UserName','Password') or die('Error: Connection to DB
% I/ E' z  o; Z7 f% T0 V' r4 G4 Z
1 \3 ]! A% B% ?( \+ TFailed.');
1 |$ G$ g  k0 N% k1 E% M( R# v}
3 p. M3 v: f8 i1 `/ @) EConnect();

9 e9 E0 S  W) `' O' ?2 ~function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
$ ^! C8 d/ _! h! }; Z  I% Z<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
6 A! x# o$ O$ u" B<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/>
" L5 y' ~# d8 x! y<lable>Item Upgrade Amount</lable><br/>
) P# n2 G" j# `" \* `7 A: l  _7 F<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
/ `5 D* V4 i. O
</lable><br/>
+ A3 h$ o9 |1 K5 c<input type='text' name='item_element'/><br/>
: z* G; W$ R% w9 g<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
& q7 G3 ]1 Q9 k% x* \<input type='text' name='item_pierce'/><br/>
5 x' s+ V9 Y1 l' p( K) M/ S7 H<input type='submit'/>
4 m8 s6 _. _6 M3 i</form>";
}

function PostListener (){
$ s4 h0 w+ q- q0 {$ F) R+ s, K//Add more post variables if needed and add them to initform() function aswell
& {0 r2 q1 i: H" ~# L0 L; S
/ J; Y7 R# z; {' M7 z################################
##### Connection and Post ######
4 b" f. U; _% J4 f3 q* J################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
  x! G' ~$ A7 J. b4 A/ y9 E$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
, H7 L; n8 U% a$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value

) \# F" |: A; G6 Sif (!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>";
$ Q% T  I6 k' w: Z$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
# k# z# Q. J8 g  k0 N6 @
4 C* I: v9 z' l# W3 ^+ Q" A9 X( x& C) d[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
4 C/ J% K1 X: k2 Z; P
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

2 r) h# {) O9 X4 e, q# L" e'{$ElementUpgrade}', '{$ItemPierce}');");
" I) b' L: W+ n}
5 S$ `2 K% u+ b4 L4 U
) _, f* ?! T/ @- q( ^) T+ V}
% s; A) o9 k6 Z) E
9 }+ H3 v/ b! R+ x- m+ D. [}

$InitForm = InitForm();
" @9 v( }  s+ _5 B' a- a$Listener = PostListener();

?>



7 d$ Y+ j1 s) M1 g; s