物品发送脚本

admin

<?php
function Connect () {
$ v" t0 q( q& x7 W: z7 c. Amssql_connect('Server','UserName','Password') or die('Error: Connection to DB
- E1 L, m2 \0 e5 T* Y: c, j! U5 A
Failed.');
/ Y& q7 y" k. z8 B9 b% o: M}
Connect();

3 k4 j- {& I# W8 [4 ]9 `function InitForm(){
" z$ @$ m1 m3 Z* U) g- Z//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
9 Z. y4 t$ p& t<lable>Character Name</lable><br/>
0 \+ o- M6 E1 G7 t. Z. d/ j  B<input type='text' name='char'/><br/>
: d( T8 `# V& |6 F$ T* w<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/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
7 G0 x6 c% r+ s4 U2 ]<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

. C: X  G+ @( [8 hfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
6 |* @1 _( {4 V) I1 N: k1 P##### Connection and Post ######
% e" m7 x2 j/ ~$ ]4 G+ L: M+ d################################
9 I6 y4 b' Y, c2 B* h# f' h* i& n$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
- x5 g3 C1 _8 o3 j; g0 {$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
& W0 y9 l) U7 u5 Z$ItemElement = @$_POST['item_element'];
2 \5 q- f: a8 M$ElementUpgrade = @$_POST['element_upgrade'];
% V  q! v" I2 [- d$ItemPierce = @$_POST['item_pierce'];
, r  x4 I) Q; {5 h6 p+ P: E################################
6 _: Q9 m2 b6 B6 Q3 |2 l( Y
  w5 Z; o  ^* a7 f//Check both variables for empty value

, V3 k7 K! O1 cif (!empty($_POST['char'])){
# ^( T& E# m, W  l" Q4 H0 z$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

, c. E* ^+ W( x6 U& F9 pm_szName = '{$name}'");
, K0 L! O& \  n& [while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
+ N! x' L8 b: L( |. q3 u
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

& |9 A" j3 B8 h[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

, \2 Y0 r5 b$ e6 ZN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
' H9 S5 c! Y! P) \2 W
) N' u! C4 ?! E'{$ElementUpgrade}', '{$ItemPierce}');");
9 f- N0 N% o$ g" N8 A6 k6 F}
9 }9 S2 j/ `1 x
- c, y4 l5 l$ D: v, X}
% I% c) K2 _0 u0 v3 b/ j7 f
* d5 V) H! v9 k" y3 Q}

$InitForm = InitForm();
$Listener = PostListener();
4 L5 y0 C8 v) t" ]% }( j$ U5 F" l
1 b  G" O" t, D. L+ l! P: j8 e?>

2 j4 x& V  W" `5 a# c, h0 L; J