物品发送脚本

admin

<?php
function Connect () {
7 I# m, d9 B+ r# O" g1 m& Rmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
) c7 ^& U" T; r0 P& ~+ j
Failed.');
/ |: f6 U) s  ^4 N* Z}
Connect();
1 ^0 e& F2 F3 X2 x( W
* q9 {: C: _1 p  C9 Lfunction InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
  a# B. }5 |. L7 e1 L. }<form name='select' method='post'>
<lable>Character Name</lable><br/>
7 h5 B- q* E. f3 ~- J8 B- T<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/>
& W1 s7 Y7 u4 p6 c1 @( P<input type='text' name='item_amount'/><br/>
: h% \/ P- b# z<lable>Item Upgrade Amount</lable><br/>
3 i8 p7 P* z6 k3 ^; D<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
$ o( X& o& @1 n7 o
</lable><br/>
2 ~7 t" y: K' K3 W" j<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
" N1 ~. j# P6 S7 ~% Z<input type='text' name='element_upgrade'/><br/>
% f+ B  l5 i) O0 v& R6 P<lable>Pierced Amount</lable><br/>
$ w# G! B- X7 I<input type='text' name='item_pierce'/><br/>
) O4 t) }( Y6 V<input type='submit'/>
7 N5 o5 ]# E: ?% Y. d0 X</form>";
}

; n: e* |9 h5 O* j1 v& w* M3 lfunction PostListener (){
  o# i( F) O' ^* W; ?//Add more post variables if needed and add them to initform() function aswell
; Y% g4 [+ h$ H% j4 l
+ w* }8 |1 R) k# l! U* j################################
##### Connection and Post ######
################################
- O1 Z0 `; G2 Y  f$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
' I* t, x7 d' y1 {$ItemUpgrade = @$_POST['item_upgrade'];
) g4 M( V" {, f$ItemElement = @$_POST['item_element'];
8 a/ M$ |7 P9 Y  h  F; v$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
: |) h' h% F8 Q+ y/ _3 _5 I
//Check both variables for empty value

+ Z$ X& f  w. N/ aif (!empty($_POST['char'])){
& ]; T# x- L7 F8 W8 U$ b$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, X2 v$ f9 Z: U& M: D
) T5 R' C0 L0 T* _% Mm_szName = '{$name}'");
! x( F7 W, G+ H  m! Kwhile ($row = mssql_fetch_object($find)){
5 G5 j$ a' }6 Zecho "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',
( Y9 I6 a- Z4 `/ U2 ?/ p( Z
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
* {, K" x# @: |% {8 ~}

( H4 x, y; Y4 K' U9 {4 H5 _1 u}
* {9 N( K# Y! {& c, I$ W) z& [
6 _; n) @* c3 S2 c; V}
8 G9 X; n. T+ [5 W8 i5 a- T
$InitForm = InitForm();
! q; c  D3 w: h" L5 t: q$Listener = PostListener();
6 j2 ^) U, W6 J/ E1 `! Y
?>