物品发送脚本

admin

<?php
function Connect () {
- q9 T- Z# ]6 J: C& emssql_connect('Server','UserName','Password') or die('Error: Connection to DB

  S( V, x9 y2 S0 i" j: mFailed.');
}
, r; H8 @( Q; }1 k/ X. H( tConnect();

function InitForm(){
5 b, `) Q! W& t+ N//layout for the form
6 n9 t/ T1 Y& i9 ]8 @echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
# c$ D  u  S6 j6 T3 J<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/>
3 Z! I# r9 R$ }, W/ R" M, @<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
8 ?/ {9 L. m3 G& T3 R1 ~<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
6 ~% }8 x* Y  o( o) Q+ H<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
5 J: l+ ~, _+ a) W. Q
</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
5 Y8 [  |1 \$ a) C$ c<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
! t  W5 }7 p1 Q0 C1 c<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
' z- j& l) t! e* W& W3 Q) M</form>";
- k: C. a5 g( v. L0 T4 N# N; l}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
! ]- z/ |6 g0 k+ Y/ ^2 @! _' _9 g
% l+ g# A& f& J$ K- P3 ]################################
6 T7 ^1 ~& f" X9 z7 h##### Connection and Post ######
! ^0 J: L6 p8 ?) ?5 _################################
$name = @$_POST['char'];
# V. Q# y4 S6 r, L: X$ItemName = @$_POST['item_name'];
$ {. {4 B6 q, f$ c( U) A$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
1 ]. V: H! F0 F# T" G/ L9 c$ItemUpgrade = @$_POST['item_upgrade'];
$ X  a0 Q% K( J9 S9 }5 n$ItemElement = @$_POST['item_element'];
2 R; f  i1 {5 Q9 q5 r$ ?3 _4 I$ElementUpgrade = @$_POST['element_upgrade'];
! I5 J& ]- q5 Z/ c/ f4 }$ItemPierce = @$_POST['item_pierce'];
################################
2 |) {; H1 g9 X' m& O
//Check both variables for empty value

& S0 V- i7 V* c3 N; b# s; eif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
4 j8 p9 L* b- C
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
4 l' Z6 g* T; Q6 L+ L" C3 y6 Wecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
: p4 i# i; r: m* b$ V$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
2 m' s+ K, w5 T1 }
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

/ {2 S1 j9 n$ O/ LN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
5 G+ m2 q6 L3 S$ m- f& `6 B
2 [( U2 Y# h% V% R" l2 h- X'{$ElementUpgrade}', '{$ItemPierce}');");
}
/ @/ N/ a8 c0 [3 {5 J
}

* L# ~( e! \0 C2 C/ ]7 i}
4 M5 k2 Q# X3 a: {- K- W4 o
$InitForm = InitForm();
: ?, [- M6 A. k$Listener = PostListener();
6 A* S0 J; |5 P
% e# n/ m* h5 n# O2 u?>

" u1 P2 Z7 L: \; M9 F0 Q1 ]' Y
" N* Y1 G5 [2 A" L
8 }0 k2 B% o, \3 g
! P" s" r9 ~. g: O. p. U