物品发送脚本

admin

<?php
function Connect () {
0 t3 t, t6 C; v0 ^' _5 Nmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
& {2 D. B  |. @' [/ e}
- J% l1 A9 ~6 G& }! z. ZConnect();
! u# K# J  a0 r
! x- P! \4 w8 d& m$ m& Efunction InitForm(){
//layout for the form
% V/ H; h/ \- z0 [3 t0 mecho "<strong>Send Items.</strong>
' L7 }0 \2 D; g0 H; w<form name='select' method='post'>
<lable>Character Name</lable><br/>
/ c9 m+ y# P) `5 o<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/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
9 I0 _2 s7 ]1 M<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
9 l: \% H; F% S3 P/ o9 Y$ N' W<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
: b, k5 C& j- @: `/ G; y1 q4 I: _, W<input type='text' name='element_upgrade'/><br/>
% }4 J* Q; \3 b3 _, T  w6 B<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
7 ^/ Z% r& s* z; C<input type='submit'/>
$ }3 @+ g' E' p</form>";
}
. g! e5 \2 i0 z
function PostListener (){
8 X3 u7 K7 ^. F. k9 m& h; o' }) k" u; P//Add more post variables if needed and add them to initform() function aswell
6 L+ y; e( L1 F& N  B8 l7 C* A- b
! B+ Z3 @+ y  x0 v; U################################
0 `) d9 J+ v, ^##### Connection and Post ######
+ F9 Z9 S/ |9 y; u/ X7 X################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
2 n- X) C2 s2 q) p, J9 t% q* ?8 P) v$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
# o7 a5 e$ I# e; J$ItemPierce = @$_POST['item_pierce'];
- g5 d3 A! v! |$ _1 L. S6 ^7 `% X# U- X################################
5 y5 Y: e0 X3 r' I- U5 s
//Check both variables for empty value
8 A) m5 |7 s! b  e1 R% v9 T+ D
+ ~/ @7 H* @# u9 k6 @8 }/ Zif (!empty($_POST['char'])){
$ ^7 t4 E2 `1 Q( c' @5 u6 C$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

( d& i$ I1 U5 m$ H3 S- W" im_szName = '{$name}'");
! t8 b# G' p5 z5 F. m+ Uwhile ($row = mssql_fetch_object($find)){
9 K5 K. T  k5 T) |9 |; O* H, G/ g. |echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

  {- a/ T/ p+ P3 O! `& s[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
- z. m" \: K" Y3 R, }
' x) E+ t& t, ^/ XN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
% g/ Y6 l2 V$ Y, K7 m- a! ]
2 m  ~- C0 d0 z! D% q'{$ElementUpgrade}', '{$ItemPierce}');");
2 z  }3 g1 D% q% w4 f+ L1 R8 y6 ]}

; d6 x# Z9 C2 G. j- p- p; I. Y}
& [, }0 b7 t; T2 f
7 r6 |8 x  o0 G' E; y}
/ @8 P9 ^0 J5 u( Z0 p) j
$InitForm = InitForm();
" G/ N4 `3 M, |  P$Listener = PostListener();

?>
9 W/ r% L1 _9 r* a



5 _4 p; ]2 q8 j' c6 t$ J