物品发送脚本

admin

<?php
0 v7 G  X* F3 Tfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
1 L' C& w3 D% {6 z9 P5 z
Failed.');
}
Connect();
' I9 w: n' [! ~" p  E& d
function InitForm(){
//layout for the form
7 `# s& i! k0 X6 m4 ~) \* yecho "<strong>Send Items.</strong>
$ C$ P) u- L0 u. u<form name='select' method='post'>
6 M2 U/ ~: N$ m. h! _8 y0 y<lable>Character Name</lable><br/>
<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/>
<lable>Item Amount</lable><br/>
/ q% L0 J( m1 h& _, C2 F<input type='text' name='item_amount'/><br/>
- s' J2 |& R) g- v9 o<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.)
5 h) }0 S- z% c8 g  V
</lable><br/>
  x9 h' W  E! A( [. Z<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
( y' `9 _: }- M% X<lable>Pierced Amount</lable><br/>
4 ]# ?6 b7 `' u9 Q; c" v5 f<input type='text' name='item_pierce'/><br/>
: R% j7 C% K9 ^' p<input type='submit'/>
5 t, o, T9 D, ~7 k</form>";
}

( g" y) k3 w1 `( {$ k8 O! Ffunction PostListener (){
  N6 A5 h5 L+ s6 N: D2 v//Add more post variables if needed and add them to initform() function aswell
8 Q6 k- B4 r: `; Y
! w- m- |/ F9 U$ q################################
##### Connection and Post ######
################################
# \- K% o; M) ?* j4 k$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
2 f1 L/ ?! y1 \4 s. u3 L$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
3 B% G* y1 v: v# Z1 z$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value
. ^2 u1 N: o+ @  s9 U& K
if (!empty($_POST['char'])){
0 i( |% j- |3 i( `$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
4 ~$ P5 d2 ~6 P) d7 `echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
  g. `& {2 l  c$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

0 `6 n9 U, o; Q, O6 R+ M[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

: y6 t$ ]2 M7 _& Y/ O# XN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}
3 {9 h( e0 Q3 V: Q5 A/ |
/ P4 U  ~2 K0 U: h% m8 \0 ]}

& l  a, \$ q, Y3 x, J" b}

3 D/ W1 u+ f( A9 y/ ^) g" y5 h$InitForm = InitForm();
1 X) l$ ~' a/ g1 n6 z5 u$Listener = PostListener();

) Q9 l. `$ {+ ^1 @9 B. x?>
9 J. n, ~. W# g3 {: E3 O