物品发送脚本

admin

<?php
0 o$ X4 c5 E/ K, U0 o  sfunction Connect () {
0 t& }* r) w1 Y1 lmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
; ^( F% G& w2 C
Failed.');
}
* s; \, f: I2 M$ {1 w' R, h2 S7 YConnect();

function InitForm(){
0 [0 Q- ?$ ~" c, G7 Z//layout for the form
' V: u) E% B' Zecho "<strong>Send Items.</strong>
- ~( _% v1 R/ V2 k: p; T+ u2 ?# a, T2 i+ X<form name='select' method='post'>
<lable>Character Name</lable><br/>
; H' f2 `. Y; U( |8 B& E' B<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/>
<input type='text' name='item_amount'/><br/>
; z& |: [5 U3 D<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
. |1 s. Z& ]. `% X8 |: I<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

% `3 D! C1 |6 U+ u</lable><br/>
# D% a, Q- I# P3 v; _0 {<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
, r) K9 a% V! t/ V# l<input type='text' name='element_upgrade'/><br/>
' V3 C7 ]/ E5 L. {<lable>Pierced Amount</lable><br/>
5 X6 v0 D  b5 L7 R  T' J2 H8 E<input type='text' name='item_pierce'/><br/>
5 L( z8 |6 B& w4 D* k<input type='submit'/>
" U3 z5 s- l' |' q& b: K* m. e</form>";
0 V' Q1 h( ]0 Q/ H! v' }}
, o: R  o# n: Y
function PostListener (){
. T( q" p, _# u: s4 t//Add more post variables if needed and add them to initform() function aswell

" L4 O5 x# b" W1 f################################
##### Connection and Post ######
################################
. ]3 u  `6 y# b: s; a$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
9 `' K9 E0 M& D( F3 @% K* K$ItemId = @$_POST['item_id'];
" \' v* M3 ^* s( K! S/ F$ItemUpgrade = @$_POST['item_upgrade'];
7 a; X# w/ h+ \  i$ItemElement = @$_POST['item_element'];
- N0 I  |- ^4 F+ E' D$ J& E$ElementUpgrade = @$_POST['element_upgrade'];
: Q: B" D! G! u, Q. z6 r) e& V2 z$ItemPierce = @$_POST['item_pierce'];
################################

) A) W& {4 U( }) n5 `/ G# K//Check both variables for empty value
/ `7 t: |+ K( F, ?! k
% o2 ^2 l2 N) q. m* bif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
) D  h* }0 [  R" V
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
( j/ L! Z  w8 Qecho "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],
  u+ H8 ^+ E4 C+ k' W
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

( `" a' r; V& L7 X$ jN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

0 ]8 P) V) w, U+ @% ?'{$ElementUpgrade}', '{$ItemPierce}');");
}
6 k9 g8 }' Y$ E
}

}

$InitForm = InitForm();
/ f5 u9 t* o! X# o$Listener = PostListener();
5 C, _# g/ j  Z3 E' Q- a9 E: |
4 Q. W, z  C1 F6 c5 f?>




5 q. R8 d2 t! B) d1 p8 f