物品发送脚本

admin

<?php
5 @% u; l4 `1 f- I6 `  u* L( ?  Ufunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
! `" x% |+ D  P7 @# i4 K$ `
  k0 i# P  `4 o: {) QFailed.');
}
Connect();

function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
  J" U$ e) p+ u. u3 N7 _1 M5 R. M& b<input type='text' name='char'/><br/>
3 s& W2 I5 j& D$ D# w' b* v2 M<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/>
/ @$ w2 D& l* ~# D* e<input type='text' name='item_amount'/><br/>
% O/ C" p' o7 B  t! O" Z) L<lable>Item Upgrade Amount</lable><br/>
& A1 C9 j2 R' B) K% W' g<input type='text' name='item_upgrade'/><br/>
+ y: a; o5 }9 r" R<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
; Y1 r( R0 z2 B/ |5 G
</lable><br/>
. R7 h! k/ p; [6 J3 C2 a, V<input type='text' name='item_element'/><br/>
+ G# x! M# Y# U% m% o4 W1 X<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
6 k3 T  \. P& G, \  ^4 l$ c/ q8 n<input type='text' name='item_pierce'/><br/>
7 d# V, Q9 m9 ?<input type='submit'/>
</form>";
}

function PostListener (){
3 {& @3 J* X# m: q//Add more post variables if needed and add them to initform() function aswell
$ K* i$ X4 X4 u: J6 u' I7 c( \+ ?
# ~) c# e( J- {1 @: `################################
##### Connection and Post ######
- z* u: m& {: o, z! I1 H0 u################################
6 D) i& d8 N& ^* G$name = @$_POST['char'];
  r8 H3 m1 o3 h9 Y. B6 d$ItemName = @$_POST['item_name'];
. i! J- w; }, \* V8 O$ A$ItemAmount = @$_POST['item_amount'];
5 z0 F% n3 d: R$ItemId = @$_POST['item_id'];
# [) E* c3 O" o+ E. W& J$ItemUpgrade = @$_POST['item_upgrade'];
8 D, ^/ v, b5 q  N  b4 L% H0 E$ItemElement = @$_POST['item_element'];
4 _) }: q* x0 e. O. F$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
% q" ]# m% [! W
//Check both variables for empty value

6 ]6 _9 u/ E" }9 a, sif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ N. D' s7 }: q. `4 j6 L1 f
m_szName = '{$name}'");
) ?+ Z5 {* f3 t) [0 w- d- zwhile ($row = mssql_fetch_object($find)){
/ j+ U7 A+ ]9 S& z( g* Cecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: Q6 A# L$ u3 {, K$ D6 _6 f, D$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

/ e  X! I& G! E, e" N& H% \[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

0 R5 k( g% B% a1 e[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
  p( Y/ }& g  u5 ]% W  {, ^
+ T% {# L3 I1 D* ?N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
# x0 r5 d& }4 t6 S
3 k4 C- P- V& Q6 d2 ]'{$ElementUpgrade}', '{$ItemPierce}');");
8 j/ p0 F' z  ~0 f0 R/ h}

}

$ l$ ~) d9 c% e}

3 P" o# l6 r, ]: c( u; @$InitForm = InitForm();
8 ?6 H& d7 C- E) F$Listener = PostListener();
4 X$ _$ F6 y. _8 M* o
?>
5 K5 c, Q5 D2 t- K) o

$ {, Q: }) X) T. L, E5 F! r. T4 n

7 U; E& d) Z% v# }