物品发送脚本

admin

<?php
& d. e, v; d' p0 t4 Nfunction Connect () {
+ w" E4 Z, v* u0 [mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
# N1 [5 K5 Q" f: i4 U4 A6 o& c
Failed.');
, h! U+ d3 O) P" T/ f}
Connect();
6 d4 Q6 `! ^4 m2 S% w6 Z
function InitForm(){
//layout for the form
! [. l# ^! R5 q8 ]+ _* Z( Gecho "<strong>Send Items.</strong>
" J, g- B' P, N# H( c, b<form name='select' method='post'>
<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/>
$ |# G/ U8 @* K' a8 i$ M1 S$ [, \<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
6 s' a: c: R! ?<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
/ H# E+ l/ K/ q% S# o/ a3 H% h<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
" _- j, U' Z3 z+ k- f
</lable><br/>
4 x/ g+ e  Q. h2 o, {- H1 T" Z<input type='text' name='item_element'/><br/>
9 r! l$ }; @6 B* n& X% i! C<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
. }4 r1 P8 W) t7 u% z5 N- A, {  V/ ~<lable>Pierced Amount</lable><br/>
) c8 w5 s6 Q4 g- j7 O* c4 m<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
" B) F2 [* Q9 ^7 _3 V7 \</form>";
/ C+ P0 l1 }: y7 r}
, B4 J9 N  ]/ i% ^
4 I: n* L/ i/ N6 q) @1 |: N8 a7 Mfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell

################################
* p5 ~! e% t0 _6 l3 b2 a6 w##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
2 \' T1 |: S$ `7 C$ItemAmount = @$_POST['item_amount'];
* |+ W9 f3 D# T$ItemId = @$_POST['item_id'];
0 x! B9 ~* ]/ f* X6 m* L$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
* D4 P0 U4 t8 F4 q/ |9 W: F
//Check both variables for empty value
; J# r! H1 _4 t3 z
. a! \/ ~+ G+ }+ F8 nif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

' G9 o( Q; a& u# qm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
% U. l. N! O) W. T$ q1 R, T. I$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
7 v1 v! i  x' {
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
2 ^7 [' x6 ]. |
5 r9 A5 n5 S/ |/ L7 P3 b[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

4 @6 E/ W! X& x- b+ NN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

9 |# V8 C8 r& d1 Z# i' Y0 _'{$ElementUpgrade}', '{$ItemPierce}');");
}
- k# E& E: v) j2 z
/ d5 u1 j0 o' E* B" m$ ^}

% N: F# s- Y* z# X: c2 p2 q}

$InitForm = InitForm();
0 T0 k+ ^/ W9 B5 c8 u$Listener = PostListener();
. K- o( f+ G9 U2 I1 }0 C
/ e* K! q5 }1 d& l- ^! N7 g?>
; W3 W: W9 _$ p2 k
2 c4 G1 Y* X9 S' x% G9 b3 Q4 S
3 G% Z/ Q+ I9 T5 g4 B! e+ O
* H2 u5 R, f; {/ o