物品发送脚本

admin

<?php
9 K' |7 j+ K. Y: }# O1 ofunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
  K: i  H4 o9 ~- z+ k; u: r
Failed.');
}
% |) [% X8 T& R, W3 @! b# N1 JConnect();

* d% o' m$ w# F+ K' q+ Ufunction InitForm(){
//layout for the form
" d) c4 I/ @6 j+ O- d- ~3 Yecho "<strong>Send Items.</strong>
2 T" U5 E0 D* O$ E) a. r% A) [<form name='select' method='post'>
- a/ g' J' P8 Y, b. c<lable>Character Name</lable><br/>
3 A5 [5 q+ V' B# \<input type='text' name='char'/><br/>
% l- b. ?; l2 U1 c( e$ T  A' S) L1 U<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
1 u1 s0 k. R8 c- E4 U: x<input type='text' name='item_name'/><br/>
% E8 N% e1 {. d1 O& |( @<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
1 m! X4 B  p, W+ s<lable>Item Upgrade Amount</lable><br/>
4 n+ u- v# O7 K2 |6 G<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
) k- A! A' w" N5 E<lable>Pierced Amount</lable><br/>
. ]1 F# w9 w+ b7 G& a2 J<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
+ |9 u5 v- P" x; w! P' k# r7 w1 n% x</form>";
  x! D( I) A, {, q}
: r5 O( Q* D# Y0 s
' D. M( |& d: H7 n; j/ G' k. Ofunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

2 V5 }; ?' P+ D# o################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
! O, H0 D4 L- P- ?" {$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
) o# t; w* E) i9 P! K, K+ m$ItemUpgrade = @$_POST['item_upgrade'];
( n3 R7 t1 c+ e$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
4 o  }4 v: L" E2 u5 d$ItemPierce = @$_POST['item_pierce'];
0 G- B' H# p3 R- P################################
* d8 }" N6 d1 F+ V* |
//Check both variables for empty value

4 b0 }$ [. k5 `' M% V& {& sif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
( j3 c/ h! @9 d5 T7 E7 T
5 @) ~+ d3 h# ]: @, [& N( P. Tm_szName = '{$name}'");
6 k+ ]* |) d6 n' _: i  Q$ {2 ^9 _4 Ewhile ($row = mssql_fetch_object($find)){
# c+ c# k, f% {; }2 q) Q% Xecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
% n9 r0 x' ^8 Q# l/ d$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
) L7 l1 m7 ~- }  n& E3 Z
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
4 Z$ }9 F. h6 q- q) B$ c
$ w0 y+ C- N+ E: l5 ^5 f4 [1 |+ HN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}
5 @. r( o# U$ S) ?/ y
. @' g% w: n+ _}
2 F8 k/ A- i! @. W
( v1 r2 v) r  r$ l7 G' S}

8 v) b; q$ E, G7 n5 Z$InitForm = InitForm();
% ^$ [/ q0 F) x9 L$Listener = PostListener();

?>
" Q" X5 Q! _5 e; T7 Y6 E

% F/ H% y, |# K4 z" X
+ F. `; ^$ {. Y9 `& l4 V
# Q# z: D8 c% f