物品发送脚本

admin

<?php
" B4 C! i8 Y( }6 s% xfunction Connect () {
9 I. l# f9 u$ h1 E+ v; v+ a  Y. nmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

8 Q% l) c  e% Z% v" fFailed.');
; I$ p( g; B: s/ u5 o0 U}
' ?/ m7 V+ H7 G; i( bConnect();
& v$ K2 c( m4 F8 h
function InitForm(){
' w) m( R) W& U6 {! }) z8 O1 H//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
4 f1 l( ^3 A1 i+ Q+ E3 A. l% B<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
% W9 [% X9 j1 Y% o) i9 m<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
5 m' c# F2 f( |' Q6 [9 k<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
5 m" X4 r5 s7 V' q3 A3 J, s<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
( U5 t& I# H/ Q0 i$ ?<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
% I4 Z2 Y, V8 ]5 U% r! p2 O<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
: O9 ]: V2 }+ f. W<lable>Pierced Amount</lable><br/>
4 O7 V: V7 r" P! k+ @<input type='text' name='item_pierce'/><br/>
" F" F, K* \$ Z. W- Y, c<input type='submit'/>
</form>";
& R" ^5 h" ?/ z* o; v0 p}

9 @# {1 t: C& z& z, Bfunction PostListener (){
9 S& b. K" Z$ l9 b0 N* P% n//Add more post variables if needed and add them to initform() function aswell

$ f( M9 G9 \7 Y, ?################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
% \1 g# r7 \: C* E$ z$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
7 k) T# b8 A, ?" M2 T: O" x) p7 Z$ItemElement = @$_POST['item_element'];
. Y% L4 D! Q: r0 ~  r, @$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
! U3 D% a  y9 L' Z% ^/ [  @2 i################################
" Y) s8 o9 l% m+ ^( R
//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
- k( O1 o! u2 i8 C
; y8 n1 {6 r  h  \m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
# \6 ^4 d9 P3 [  D9 G- L1 ^0 p/ u1 Cecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
3 b: \1 {% g% {5 \/ x6 q$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

" X' m3 m2 k4 d  A* G[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
1 F5 o5 B8 g& x& `# {8 R  U
; ]9 _2 a0 a1 n, e: W: C[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

/ Z* r, N. I/ N2 r4 y- H; Y7 YN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
( V9 A* i; L1 r$ j3 }) ]}
( z7 G: z# K* J7 [4 {
8 [3 P/ V* z) p; M" W7 H- Z4 ~}

' Y: Q  O; U. _6 X( }: z: X. `; L5 s/ s}
$ @( @" [: O: p! g. [) i
: K! y& B! ^) e9 a$InitForm = InitForm();
$Listener = PostListener();

; p9 R! w, o# X* q' o2 S?>
# A6 d9 h' }6 T, m8 j% K9 q
7 x8 D" u7 W; K  v

5 q* x: S+ n( R3 b1 i9 Q
# S& B% n4 U1 Q. V+ p