物品发送脚本

admin

<?php
function Connect () {
. @9 V1 N! z1 v4 v1 b9 R% smssql_connect('Server','UserName','Password') or die('Error: Connection to DB
  S+ V7 p' @: A$ E" w- A. S+ A
2 a, s! v. a5 F( M0 C, c0 D4 k7 G; GFailed.');
}
: @( r8 H5 }# [) a% oConnect();

& [, i  @! o) _' c9 m. ]function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
% G9 S. G+ W1 B7 H" p<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
9 M+ ?( L2 o' [0 J<input type='text' name='item_name'/><br/>
& S( h( A! j. S* c1 T7 L2 z/ r& \<lable>Item Amount</lable><br/>
! v% N1 X) o; |" g# t1 L+ t<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
! u; ?2 ?+ z+ c! }5 q<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
  D3 w+ t: W! ]
& q4 ^' a" G3 b5 J* |$ D</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
5 {0 D4 T6 h. j6 o3 b- u<input type='text' name='element_upgrade'/><br/>
9 a4 z0 N  L* g1 ?  \: D<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
) C$ n4 B8 N+ A6 {: }  O) J</form>";
0 e2 c9 v5 C: ~. W$ R}

function PostListener (){
# {4 B! J% A% v- o  ^//Add more post variables if needed and add them to initform() function aswell
+ ~" R+ a' b+ x9 J, @; |1 y( l) {
0 w: Q' R8 [+ I0 F0 H' A. M9 ]6 Y################################
7 l) I0 S2 F- g0 D* Z) Z, e9 K##### Connection and Post ######
################################
3 g5 j5 o3 F* ^* P2 p* p# @, m& B+ A$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
0 G+ }& B7 v* g8 ~3 F# f$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
0 V/ X) r& m( |+ O7 O8 K8 O' p$ItemElement = @$_POST['item_element'];
5 t0 p- J- n* z9 l- i$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

3 A. W( p* x3 a//Check both variables for empty value
2 `% m3 B/ {* b  z. L% K
# |% C' L+ g7 m3 F) k; S' qif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
/ O8 q% j, h  r" u- F, A9 d+ z
2 E# Y2 K4 Y4 G* mm_szName = '{$name}'");
; g" y; t% Q7 ]) d) I! Y7 cwhile ($row = mssql_fetch_object($find)){
& N3 Y% H6 J1 K% Jecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
  @9 m7 E, ?0 Y7 n/ \  Z) w$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

' B) H& c4 {1 Z  P[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

  }* W5 e! D- N. Y[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
1 Y% u; c2 t4 c
'{$ElementUpgrade}', '{$ItemPierce}');");
) M. _- o" [2 q- n}
5 y2 ~6 k, Q0 ~0 f6 H8 n# W0 z
}
, z; H% H  g* s' ^# I2 b! Y! k. I
}
6 x; X# \( S  R: a! x3 N6 U" g& a/ m! N
: u: r5 v, S: B5 O$InitForm = InitForm();
$Listener = PostListener();

& r  D( b7 @# O/ i0 g?>
, P/ O4 t3 b& X


* V) J, l9 Y' B% R3 w, ?$ N% k
2 E% _% U+ Q% R4 @; N5 ^