物品发送脚本

admin

<?php
9 M. `, ~: |; W  ofunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

7 B( |" l: V8 J" F8 \3 h1 JFailed.');
% u- o5 [$ n" f7 A1 n}
Connect();

. X7 T' ^6 P3 E* g& x  R: hfunction InitForm(){
//layout for the form
- y# s- ?* }# {6 ]6 F- N. {1 i% necho "<strong>Send Items.</strong>
<form name='select' method='post'>
9 [- p; m- y2 C9 O+ m/ x) B# S  Z<lable>Character Name</lable><br/>
% i3 r& e6 e5 w9 y8 y; K+ a<input type='text' name='char'/><br/>
% S% L, ], V; Y$ l<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/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
% V. Z& W+ K* T  d2 T9 E) e<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

' Q5 ~# G- E& a' p# p- ]</lable><br/>
3 j7 p" J3 x$ T& c$ ?<input type='text' name='item_element'/><br/>
1 D/ C. w7 }9 k, y<lable>Element Upgrade Amount</lable><br/>
) K/ X9 f( F3 R2 N# x: E<input type='text' name='element_upgrade'/><br/>
) \; |) z8 D: _" B<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
% S" D2 B9 U4 |4 x, t% C* G<input type='submit'/>
</form>";
}

* U- O, I+ Y9 M! bfunction PostListener (){
3 r0 P3 F7 u! j3 x+ M/ e* U" B//Add more post variables if needed and add them to initform() function aswell
: G& Q4 z& X/ |* T, h
9 _' X6 g! m  d2 O6 \1 n################################
##### Connection and Post ######
################################
; w% R6 ~4 y$ H$name = @$_POST['char'];
( K: ~1 y, [. j& r, d: H! I$ItemName = @$_POST['item_name'];
$ g9 T4 h/ G+ ?) e5 d4 P3 ]$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
# z  m$ F1 |% l& A################################
7 d" M2 y  V% S# ~
//Check both variables for empty value
1 T& X! T: Y4 z( }
if (!empty($_POST['char'])){
+ l2 f+ d9 X% ~. J$ H  t8 D$ z$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
0 h- \2 R% N6 e- ^2 g2 i( recho "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],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
! B( }' k8 C& ^" S9 ~# T: u5 ]
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

7 L9 |. |3 R) a9 N8 b: R" |'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

# a8 J% j0 c3 U8 u  M) C}

$InitForm = InitForm();
" Q8 S& i' }+ d0 P& W% N$Listener = PostListener();

?>



, Q% p/ Q0 g3 x" h" p* p
2 C2 p' z: m: Z' l* B! e/ z8 h