物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
Connect();
3 G$ I4 k6 I& d0 C5 Q% Y6 X% g
function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
- w% b/ h7 j3 g8 A<form name='select' method='post'>
<lable>Character Name</lable><br/>
<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/>
$ A+ ^1 |: B) I& u2 N<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.)
0 d( X: o+ H1 f" {
</lable><br/>
5 L0 P. I3 P( J$ R  Z1 S) b4 L& p<input type='text' name='item_element'/><br/>
: e7 r3 L: I$ Z0 h; R<lable>Element Upgrade Amount</lable><br/>
& u& P+ c3 h7 g2 G% w8 }# t/ U7 x<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
/ T: `: d3 I9 @& D<input type='submit'/>
# i, [0 G' L% V0 ^! A; N' B</form>";
}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
0 g( e' ^7 a3 [  f( p& }7 e8 ~$ K
################################
9 X) t% w% _+ m6 J" h##### Connection and Post ######
$ H2 b& r6 G0 C. }- {9 w1 q################################
$name = @$_POST['char'];
* \8 O0 J% _! E  s$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
. m9 U" P. i; L2 h( h$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ _4 p2 B1 i. A8 a- e3 Z$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
  M* \$ n/ l) o################################

; A: H( F) j# l8 k& Z//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

3 \( B3 g  [; q2 @4 Qm_szName = '{$name}'");
" {) Z, s* O6 Q# D) d9 q1 U3 uwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
% _5 ]+ ?8 |5 K$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
: H. y2 N2 m! ?" \' X; ^% `
2 T; j6 t% m, {% ^+ F[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
9 [; b8 ?' ?* `0 j- v, _& k* G7 `
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
& J% \) y5 `/ v  T1 J
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
" o0 |2 W, q2 @. I- q
$ \* g+ ?. k. V. h2 ?'{$ElementUpgrade}', '{$ItemPierce}');");
; H, ^" a+ N# ]  _! R8 N9 e}
4 Z, l  M" U- T7 I3 ~& K$ N* `" X
- o7 E5 [* c9 M# D+ R+ G}
: ^, H' }; _: w6 h! k: P9 @% s# w9 s+ X
}

% c, }* i$ u' G) B$InitForm = InitForm();
$Listener = PostListener();

' ?; A3 Q& N3 o3 v7 h?>
  `1 p( d$ ?7 C- |3 o* E7 q: K; e: `' ]
# |* d* s) l! O. P

5 P. d0 R/ g: w7 j2 R$ E
$ ?- Z) U9 d9 L