物品发送脚本

admin

<?php
4 _7 R7 t* m3 Qfunction Connect () {
2 T4 g2 o4 R9 h6 F7 z# x; K; smssql_connect('Server','UserName','Password') or die('Error: Connection to DB

$ R7 H) _! w9 ~Failed.');
}
& l* k; @! ~  z, R0 A. Y2 AConnect();
$ q; Y0 ?1 m( E* u( D
6 H7 s/ h! K9 O3 k( S. G" nfunction InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
. _% T% p+ B: |<lable>Character Name</lable><br/>
' P% e  }- Z6 {4 s) D<input type='text' name='char'/><br/>
: r7 L" f* U. {3 b, v3 `" e<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
5 @, L- c9 R5 ?0 A/ ^<input type='text' name='item_name'/><br/>
' e; g. B4 ^' z<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
9 ~7 M, X4 q5 b# a<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.)

</lable><br/>
' x$ [  \- ~) \, ?3 r* y<input type='text' name='item_element'/><br/>
" W8 ]; z, Y8 F; h, D( l+ D<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
$ V4 {# {: K/ b  T0 m+ O4 d6 x<lable>Pierced Amount</lable><br/>
5 z! j( W# I8 \. v' L* C8 F<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

) c8 p( x* B# D! l" Hfunction PostListener (){
; V* y" P& Y0 g5 l//Add more post variables if needed and add them to initform() function aswell

- Q& r# K* t0 X' b) s) ]  M################################
' I* K7 t2 P* q: {' Z##### Connection and Post ######
$ w( q' k& p' H; j( x( D################################
: a# D) J. J1 y$ a0 z& E9 d$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
# `, \4 Z; A2 f$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
+ E4 z8 w+ g% g+ {& _: P
$ j6 p# ~4 U% x2 g4 u4 {1 ~$ Q//Check both variables for empty value

( F. K& g" _& I1 ], Sif (!empty($_POST['char'])){
4 Q7 j" f4 i  s$ ?  X. _4 C$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

4 H3 M3 T, ~* D+ O; c* V4 Fm_szName = '{$name}'");
& X$ y/ P! J8 ]; q6 i0 {8 Lwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
- M! P* h2 F' ~! N- `$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

5 i" p9 h6 }9 Y9 `' \5 n$ x[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
5 z/ \% Y+ j) j& p
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
0 S5 \6 [: u/ q& a- w$ K  ^1 j
'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

1 t# @3 O- D1 j" ]; H5 k! x* V}
1 \! Q9 B* ]! O% w& T4 Z
. Y' S, n8 z) ?1 o) {8 V$InitForm = InitForm();
$Listener = PostListener();

( P: x5 s; }6 i" A, k- Y?>
5 l3 U# c1 p$ h( K2 J! Y
6 ?, }% X' Z0 M+ [; |! M6 z
$ |  b7 n- p1 S% [0 }

: N, P& D4 y8 a