物品发送脚本

admin

<?php
; I3 Z! M, t6 x# `+ ~. efunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
" s0 m3 n: V( E0 ~0 {
4 ^) s  C4 ?. a: h8 n" c5 wFailed.');
}
& @# A0 ]7 g" I, ]' sConnect();
  G& X- [* ~; S9 H
) e* Z# S) }- D+ f! @* g/ H* _function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
% K% R8 e6 a# a: a<form name='select' method='post'>
<lable>Character Name</lable><br/>
+ p' p( B: H  I$ }<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/>
" W/ X- `1 H& _& V' j- X<input type='text' name='item_amount'/><br/>
! f1 Q, U# s# U3 E! i: n, Y2 u<lable>Item Upgrade Amount</lable><br/>
- T) T- s! Y# K; _<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
% N2 N- z/ ], P! W6 y1 m# S. r2 p
# V0 f3 Y) V/ U% {* S2 k</lable><br/>
) [+ v/ M. Q+ R* G9 R9 R4 ?<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
% o+ b& c0 |! T% V, d0 k+ Z) A<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
  ~! |- I/ G4 u4 x, g" X' G1 `0 P}
5 Z; W, H) ]2 N# B4 J
  U! \, \. v, M. _) X' |  M( Vfunction PostListener (){
1 B& b, K* E/ M6 h* ?//Add more post variables if needed and add them to initform() function aswell
( w  w% _" Q6 r" a
################################
$ P, L( H! \' E; J% p  p% E. A##### Connection and Post ######
" ^7 x' m; @% V8 I; a5 R################################
! c2 @  h" f! Q; F- Y$name = @$_POST['char'];
! k1 ~9 m. L. V% _$ItemName = @$_POST['item_name'];
/ {  r; r  x1 z, a. x9 B  S7 a$ItemAmount = @$_POST['item_amount'];
, B/ i- h. e  U/ Q: G$ItemId = @$_POST['item_id'];
. Q- q1 N; |' `$ItemUpgrade = @$_POST['item_upgrade'];
' ~) d% o4 I0 x# B0 a. f/ K$ItemElement = @$_POST['item_element'];
/ H+ W. k5 c/ g1 [5 _. U" ?; k; @$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
. k) V# L1 b! Y# `1 ?, }
  o3 t0 B8 u6 F: L5 j//Check both variables for empty value

if (!empty($_POST['char'])){
# L2 N  W2 K$ R7 Z* i3 Y* H/ I4 D$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
, S, m6 ]8 B! S5 x$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

# v! ]4 |, S: I$ l2 q. _[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
9 r9 V' {* J9 U. H! r
1 u- d5 ?% Z: F' C[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}
% j% |* ~2 ~* [6 \' i0 h* N
}

}
. b. n8 O/ ^$ q. I1 G) T5 I
$InitForm = InitForm();
' W7 c; a$ \1 t$Listener = PostListener();

?>
) }! h9 |$ q! ~8 g
" t3 T9 ^, U/ g9 \7 N5 x% T0 w