物品发送脚本

admin

<?php
function Connect () {
! {* F1 v2 m2 H+ q1 C) M: }; s, Wmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
: I$ U# P: L/ P
Failed.');
}
8 k" P  k6 j5 s& T2 nConnect();
" Q* J  B4 ?$ ~9 b" l' d1 Q* j# N
0 }& m' @* v( o: K, g! _function InitForm(){
* S9 S$ j) `$ Q* J- Z1 Z5 d* T* V$ n//layout for the form
echo "<strong>Send Items.</strong>
' i- J0 w) S" g% o- r<form name='select' method='post'>
2 f, N2 m( A% t  p<lable>Character Name</lable><br/>
, v, u& ~+ Y  Z2 d<input type='text' name='char'/><br/>
8 ]2 Q' o" W6 B<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
7 H& c6 K' O$ C+ _/ J% w<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
" t# c# R6 \( E+ L
</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
% F1 y/ z) Q8 i<input type='text' name='element_upgrade'/><br/>
/ b5 E& N% w9 @3 }5 G<lable>Pierced Amount</lable><br/>
* M8 c+ S/ o$ O9 M. Q4 L" F) r* w<input type='text' name='item_pierce'/><br/>
4 s8 v( w# ?( {# u2 }( w  O<input type='submit'/>
1 c( k& H; H' r  v* J</form>";
% v" L' [5 _/ G7 M! B}
% L! p$ O' x0 a# O$ O/ s
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
+ Q$ s' p% H! X0 G
################################
##### Connection and Post ######
$ o  K: K/ p. a& y################################
) w  F  v( G: x' `, i2 S$name = @$_POST['char'];
; M2 T+ ^* }" ^4 g0 w, r$ItemName = @$_POST['item_name'];
" X4 A. P% n. V2 `$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
+ U" }* e( \' g* T4 f2 Z. ~% z$ItemUpgrade = @$_POST['item_upgrade'];
. D2 c9 O) T# x9 m& M( X# g$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
: @2 w! n  H' F& ?################################
6 @& \/ L7 K9 u. ~, I9 ^5 H3 |
9 s# M; U+ u4 O% C3 Z0 h4 r//Check both variables for empty value

if (!empty($_POST['char'])){
1 {$ f6 S2 p  K' p( ^( }$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, J* y9 W& ^" o
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
- W) o$ Y6 ~; N! `2 ?3 wecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
/ X* L9 F$ O6 b6 y, c/ x
+ C/ i$ p5 C+ _0 T( D0 f[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
5 ?8 W( k# n: {8 Z5 K
  c: r6 y8 N4 Q" ]* X7 ]( a3 @0 Y2 DN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

$ g6 I; s3 _; a  n. Z, v  t( l1 T'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

  G; q, X% n3 l% g' d5 I8 _/ `2 ~}

$InitForm = InitForm();
0 Y# I1 h4 Z+ p$Listener = PostListener();

?>



; b4 Z' I6 l9 y0 Y
* n3 I$ u7 M: k0 f+ I3 O