物品发送脚本

admin

<?php
function Connect () {
: @  X2 b2 s2 _4 E& I# |9 j. y, j, Emssql_connect('Server','UserName','Password') or die('Error: Connection to DB
  `+ K  J. B0 S% i3 W. n- v2 B
3 b4 G# e+ u- L9 kFailed.');
% V" h& c9 Z- E) Q4 R: N}
$ ?' N6 r8 O2 s" A& D1 rConnect();
- g5 q8 r6 n  N7 W# D# q* R
function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
" P' `6 b1 X0 L<form name='select' method='post'>
4 f/ }6 F7 J: s, i2 j<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/>
<input type='text' name='item_amount'/><br/>
$ d. X2 ~: b3 ~9 b$ H# f6 S5 W<lable>Item Upgrade Amount</lable><br/>
+ A% w( P9 W. N4 U) z<input type='text' name='item_upgrade'/><br/>
; r. @8 D  I( i2 I<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/>
4 p) }/ q/ ]0 y2 B0 }$ I! D3 a<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
5 q/ C( l0 r, t+ |8 R1 ?$ z<input type='text' name='item_pierce'/><br/>
+ k. y; R. Q( j6 B<input type='submit'/>
</form>";
: l8 O# c. y( N  g}
' u+ ?/ j, N3 M6 n
function PostListener (){
7 o7 [- j5 K$ s% T//Add more post variables if needed and add them to initform() function aswell
1 |0 o! r4 x5 Q7 D, F; i. |
6 o- z6 ]& x( V4 |3 y################################
6 U6 K$ }0 F& o# {" I& F1 Z8 v##### Connection and Post ######
################################
# s: z, @$ ?3 z0 Y5 T$name = @$_POST['char'];
: n0 i! f# X' D$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
/ O9 b, V& }% ]0 X8 U$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
  Z+ o2 t8 Y$ U8 u! u/ l$ M; F$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value
; M" Z* C  a* ~$ E& a
* X, Z8 A6 F$ @9 I- N  Zif (!empty($_POST['char'])){
" A) J2 `9 [+ b7 |7 y7 L3 V$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
$ _& Y' j3 p6 n2 m! E( ?# U3 {- n8 m
9 s- k& O9 k# s* V" `/ dm_szName = '{$name}'");
" B8 h- d( N. q+ [, kwhile ($row = mssql_fetch_object($find)){
1 ?8 U/ e2 e3 C3 b8 J& v( techo "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],
& |# \+ F$ `% V) U
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
, i2 [/ c! \: ~( D. J( V2 m}
' M! F' y. Y& Z% a- r( e
}
0 z; c7 R) v+ W8 w! n" z
}
7 K3 M! A, m! k; e; M9 P  J2 m, c
$InitForm = InitForm();
6 T6 j$ L  O* v8 g, u( R* u" c$Listener = PostListener();
/ P. }; j' d; P( W* _" ^0 l1 x
?>

$ \, A# f6 O  k  f" T9 w

) I) |* J+ C- n" O" Y/ o6 j6 m
" Z+ S" p7 C2 [5 G' P# r7 k0 z