物品发送脚本

admin

<?php
9 q" g9 S( d1 q* i" x! P+ k$ Tfunction Connect () {
+ n+ G- Y# m3 G) N3 v/ M' fmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
5 I+ t, y5 |4 e0 v6 p# z  X+ u
Failed.');
- i  G% e& q9 A2 O, S+ d}
! L* h# Y" e0 J( e8 x7 M+ e2 _' x% JConnect();

" o3 ]7 U/ O5 d$ cfunction InitForm(){
8 O8 M1 |# `  ~2 ~! _//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
$ _6 P- p6 Y% n<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/>
' C, Z: v4 b! G. J: @  X1 a<lable>Item Amount</lable><br/>
" t! \7 q# W6 @2 ]7 A" p<input type='text' name='item_amount'/><br/>
0 y$ F1 p1 L" k9 j, p  u<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
( }! U' F" g8 J& y# W1 J/ R) e<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
% Q& T; s: ?+ h( g9 q
+ d( {/ u6 o( f</lable><br/>
. g+ s1 w) d1 y- Q9 T( T! S1 ~& V<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
' Z( V2 n9 ]# S1 y$ T" g<input type='submit'/>
</form>";
}
. Y  r1 D3 J, k$ q$ X
: [; Y& J! N6 P2 `* k+ V- Z  T) Yfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

6 S; Z3 F, _5 J' j9 n0 U################################
' Z8 G) D4 \& R: q$ i##### Connection and Post ######
; e8 [; l) x* v3 e" |# {, u* e################################
. `* T1 i2 Z/ w5 E2 p3 {$name = @$_POST['char'];
, Y6 W# P4 C6 V3 L* n/ _! l# G2 r7 W$ItemName = @$_POST['item_name'];
! S" ]5 l* v- N4 m3 N$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
0 W) z! h# }8 j$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
6 P' G4 t8 C5 W' _" a0 T9 }$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
3 ]* B9 `+ K6 [: F4 P# ]################################
2 G! w; D/ \4 X
//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
2 u4 i5 ~3 I9 L3 Y4 L. l4 J6 }. ?
! @, ^5 ?1 B- vm_szName = '{$name}'");
3 M  p. q) _) `" X# i$ kwhile ($row = mssql_fetch_object($find)){
$ K5 V' \0 \% Z  Z6 b# n% u; T" zecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
3 U$ F3 V6 S) e& Q) e8 o% H
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

) c9 v( f# G/ X[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

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

* O# L8 q6 J4 e; Y- @'{$ElementUpgrade}', '{$ItemPierce}');");
}
  X, L6 }+ }4 B
}

" t; W( l! z" {: t}
$ Y" R5 Y  A: f6 z* m9 C/ `$ i. a
  i+ T* X9 ]/ e9 S) r$InitForm = InitForm();
! ~3 I0 _; e+ f8 i% }* M$Listener = PostListener();

?>


' b$ l% `3 |$ s% ]3 X+ o6 t

- A! x5 u. b; I8 @9 J+ a