物品发送脚本

admin

<?php
function Connect () {
  Z3 O& {: F2 E0 bmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

# }) s; a! O+ z$ y! HFailed.');
3 u/ j% T; {( A9 u}
Connect();

8 @$ a4 a4 B, x0 z, efunction InitForm(){
//layout for the form
$ f8 z4 p% N2 h4 i8 J; A- yecho "<strong>Send Items.</strong>
<form name='select' method='post'>
; F0 p3 p2 y( ?+ z6 ]9 |" |: C& q<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
" X" I; h: d( F$ \/ M3 F<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/>
  s, B6 G9 ]9 ]<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
0 A0 L- N% M- J, W7 w
</lable><br/>
<input type='text' name='item_element'/><br/>
7 W6 |3 R, t2 w) @$ L  _8 v, z<lable>Element Upgrade Amount</lable><br/>
* g+ j) B  s5 K1 U<input type='text' name='element_upgrade'/><br/>
$ w, V* X8 z# A7 G<lable>Pierced Amount</lable><br/>
' u# P# Q7 a5 A! F& q<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
; f" A% [  H1 x$ c1 a9 W" Z! |8 W</form>";
- [+ {) w, S# x$ C4 t& g}
/ Y6 N' ]; }8 k0 A9 s
, v/ I7 m& T" Ufunction PostListener (){
6 s% P" {' Y5 E2 g# @/ ~//Add more post variables if needed and add them to initform() function aswell

  t$ O6 f% ]2 t( ^# |1 a, C- A3 ^% R################################
4 z$ _1 A4 P! m9 |: P##### Connection and Post ######
& A  y- h0 l3 s7 Y, Y* y# t################################
. S. h0 p" |2 v% E1 K$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
7 p! P7 k6 P4 w! v0 B, p* ?$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
6 o2 @' N7 X; e7 ]) H5 B$ `$ItemElement = @$_POST['item_element'];
+ y( G' L. F: E$ j3 c" v! M$ElementUpgrade = @$_POST['element_upgrade'];
6 Q+ U0 g* U1 k$ `  U. {% ?$ItemPierce = @$_POST['item_pierce'];
  }; M9 O9 b1 l################################
2 s9 z. z% X. h1 T
) D/ \) D+ N4 O% N: K- f( D//Check both variables for empty value

+ U* l" {" u  ^( [: Vif (!empty($_POST['char'])){
  `5 D. _  W+ ~% {$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 M( n. V* _' |  t
: p- h1 v) H  A9 E, R. o: J# sm_szName = '{$name}'");
. T5 n9 U7 E" u/ T" _& fwhile ($row = mssql_fetch_object($find)){
3 w5 z0 q) p. ?# `: Recho "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],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
) G( t9 }2 o9 K1 ]0 u% ?
& ?6 z0 {; }" H. F8 TN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

9 V7 T# q( l- |- ~& H. M. ~5 I'{$ElementUpgrade}', '{$ItemPierce}');");
/ t$ J4 y4 F0 p}

5 p9 y# p% ]. Y7 I}

}

2 N! B$ k+ o' R/ Q& t* c$InitForm = InitForm();
- ?1 y4 X; v. C6 @$Listener = PostListener();
$ [2 H7 L/ R- a' y" Z+ s4 Y
2 w" K% v  Y' K) v?>
" A' l- g& c) x/ x1 x
2 I/ T, p- |- a& K$ N( `

; a% Y+ f0 v/ _( R