物品发送脚本

admin

<?php
$ a5 @" l. J0 S0 r* q; ^2 Sfunction Connect () {
% g6 R/ {+ j. ?) ~# K" X* lmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
, p3 Q. ]$ E: N% r: x6 q9 S2 }
  P) x& A$ _, ]Failed.');
}
8 X  K5 m3 ?4 E" ~& d9 \Connect();
4 `2 A- D4 s1 x6 p
2 q3 b6 B+ D$ \3 J2 Q$ i1 c$ Lfunction InitForm(){
//layout for the form
$ [8 G; ]; \+ Y( iecho "<strong>Send Items.</strong>
# ^2 i8 ]& B2 P0 X% x# ~: w<form name='select' method='post'>
<lable>Character Name</lable><br/>
* q* q+ b( S$ \0 Z5 g: [$ d/ P<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/>
* G& e8 Q6 \* L5 J+ p% \<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
; w! r! ?) Y, \2 ]* O0 W<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
: P) G3 m1 U1 w' n
</lable><br/>
; U1 z2 M9 b9 l1 G<input type='text' name='item_element'/><br/>
, a& }/ T  n/ L. y<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
0 O6 i7 k% y# r3 A<input type='text' name='item_pierce'/><br/>
; S6 t' X7 O; V, c  e3 R! B<input type='submit'/>
, O* w  _% o. }- a# M4 {. ^</form>";
}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell

. ]7 y2 R2 W3 F" }7 h################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
# J4 S/ c- k" X$ItemAmount = @$_POST['item_amount'];
( R& e4 n3 W% k. x/ F$ItemId = @$_POST['item_id'];
/ G5 X3 z3 [: ]: ~$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
8 U: o7 p# [" h0 R$ElementUpgrade = @$_POST['element_upgrade'];
! f0 q4 ?! S% l8 W, |$ItemPierce = @$_POST['item_pierce'];
################################

- _1 i' P6 Q* P//Check both variables for empty value

) U' ?  y5 t7 b" {9 a7 Eif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
& o. g/ U/ Y. w
m_szName = '{$name}'");
+ o5 Y0 Y/ G3 @: g, Wwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
) P; \- ?/ k) I$ |$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
! i6 ~* o0 A- M/ L" H/ ]
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
0 q" {) B. h4 t5 @2 n
'{$ElementUpgrade}', '{$ItemPierce}');");
6 Q; J# O1 w" i}

3 p- e6 W( _3 U, q0 J' N) Q}
& F9 O7 z6 N8 }4 l5 S
7 y) N3 ^7 E! ]' k}
' r7 P& e# ~$ g
$InitForm = InitForm();
2 T: \/ s5 K  U$Listener = PostListener();

* ]5 h+ ~5 E8 T* C) j?>
3 H3 r' y! t8 g4 s
9 B2 N$ P6 L8 J

6 K- C+ ^# W0 P# @0 q$ W/ T3 p6 t) ?