物品发送脚本

admin

<?php
0 r$ j- N( ]8 M& Z* n* \0 M( k$ \- Gfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
0 l  n, t( t! l4 h% V* d- _3 }
, {% m* i# }5 J1 C' mFailed.');
}
  z5 B' c: |  v- |$ P" jConnect();

1 {3 K! U: V9 K' L9 e, Sfunction InitForm(){
. S  P$ ^* H- D& T0 f//layout for the form
3 m& I. N) Q8 X( uecho "<strong>Send Items.</strong>
% V$ w4 j( c$ W2 a, F9 N; J5 u<form name='select' method='post'>
2 `; M5 Y, O* h( ~<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
% G1 e0 A# P% y$ U/ p  U<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
) z! E1 u6 i' F: h<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
4 w2 f  H5 g! X$ A, e2 x<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
3 \2 D1 R- R: M8 N5 p! i<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
3 ~3 j/ d4 w7 q) a# r<input type='text' name='item_element'/><br/>
( G4 |. Z* j) z6 p<lable>Element Upgrade Amount</lable><br/>
& o& d9 ~% O! Z* y<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
4 A  V5 z; O9 E6 y& }( l5 z<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
$ T3 x" M  x- R+ H# T% s# @  C( X+ }</form>";
9 ~6 F: K% N, ^" ]! C- H  v}
7 r6 R- \- v, o. E6 m
( L- D7 [- r# l) C$ V1 u7 Ufunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
##### Connection and Post ######
  f3 S# T; q3 u+ C- V################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
5 ^' ]  ]4 R. A' V* C: v! p  }$ItemAmount = @$_POST['item_amount'];
0 {# C( E, J7 I3 o2 A$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
8 B4 V1 ^- C+ C& C6 O4 x$ ~$ItemElement = @$_POST['item_element'];
( X( ?7 g. G& I7 j6 l$ElementUpgrade = @$_POST['element_upgrade'];
2 p  n4 n0 C, f9 y7 C3 v$ |2 `: M* i$ItemPierce = @$_POST['item_pierce'];
" v. m5 J2 W6 [################################

//Check both variables for empty value
% F( h* U0 g$ d! [$ N
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
! I$ h5 f5 V8 H! ^/ f
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
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],
" r" [3 O' o% C( H" n, U
- l6 C! U% j* M7 F( |[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

) `1 N! n( q2 s) m! sN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
; s% d+ {. P2 H0 c$ U# p
/ b1 G( [( y; L  d'{$ElementUpgrade}', '{$ItemPierce}');");
+ _5 H: z) w) h, m1 H) |3 H8 N}
5 A4 j2 a" }6 t# ^# u' B
}
/ |, X* U+ U! P6 `) `
+ m0 _# I1 S9 g4 R9 o  G}
8 u9 X! s8 i6 r! a4 O
$InitForm = InitForm();
6 Q3 V! j: r5 i% @4 e7 w- T. Y( {$Listener = PostListener();

?>
0 }  `6 B9 Z* [( \2 H

! e5 [! l; J) T