物品发送脚本

admin

<?php
function Connect () {
9 z) F8 x  U. N2 r% m2 Tmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
/ {1 O% s* N* K: y
# M; }2 n7 u* ?3 C; oFailed.');
, a, o, A3 E, j" k) X% G- P}
' S& g. h" c! h( ~% R5 JConnect();

function InitForm(){
3 C4 E2 [& C! G* W//layout for the form
echo "<strong>Send Items.</strong>
1 |7 L2 N/ r* J8 [7 D2 n  J. w<form name='select' method='post'>
<lable>Character Name</lable><br/>
. P; w- F) U5 D6 a( x<input type='text' name='char'/><br/>
( Q$ c: p0 r& c* @0 D% }1 C2 `1 j<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
' x' X5 Y7 |4 r' \5 T! N% C) }<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
/ {' W3 G' ^/ Q3 b7 h  q<lable>Item Upgrade Amount</lable><br/>
! V! I2 U, M6 n% A) h- b: w<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

5 c' @! L  @- v# ~, q" Y$ e# G9 W</lable><br/>
. u7 {8 E) a1 A2 h- e! ^# N<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
! A1 @( o" J# a8 t<input type='text' name='element_upgrade'/><br/>
7 l* c" D7 \, Z& G! m; H( ]% T<lable>Pierced Amount</lable><br/>
( m0 E5 E! W9 k$ |<input type='text' name='item_pierce'/><br/>
* m4 U! n  B+ Y- t/ H<input type='submit'/>
</form>";
}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
+ x0 R5 z/ A3 l4 `% {: R$ m- Q
################################
##### Connection and Post ######
9 l! L* U. E0 c; e  \################################
! ~4 `6 |% G& M6 ]$ X# Z$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
1 \0 x" t5 ~- _' f  T$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
9 G; ]4 |$ `: W1 F  @! e- Q$ItemElement = @$_POST['item_element'];
6 U6 u2 ~% f8 I5 U$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
" A' D! i7 s; j$ F- p, j
//Check both variables for empty value

' Q$ V/ I9 I  c; j# [% pif (!empty($_POST['char'])){
0 n; W4 p' h3 d# T% s: L$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
2 Q& x$ ~3 m# _# lecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
" g, H  `$ e7 p, M0 s$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
& E) s+ L: \3 Q% c2 |9 n2 l8 _
" n8 S2 X( |5 r5 d$ _[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
  D8 C: w/ D3 e8 k$ X; `+ Z
& x/ U8 S  h# j: d3 V5 V3 ~[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

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

'{$ElementUpgrade}', '{$ItemPierce}');");
" H, G) t  {- N0 k. v$ Y}

; F2 ?3 U& U% s/ ]: p}

}
$ l" V: \! n1 O: N$ d% a3 W
$InitForm = InitForm();
$Listener = PostListener();

! [1 F# N" V: c) H?>

) ~! J0 o; A) K

4 x$ Z, ]$ M9 |- _5 e% q& |: C