物品发送脚本

admin

<?php
6 }& D  W" i$ D$ d8 Sfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
; J7 h5 c. B0 h, a4 {% L
3 f  w3 W9 c2 y8 c6 U( b' NFailed.');
+ w  d3 G6 \4 ?6 F: X}
: o( y" P/ D" jConnect();

function InitForm(){
: H' j* I# k! ~" }  D9 O+ o7 n- ?9 \//layout for the form
9 O" |. a& o2 a) E8 Y/ e7 kecho "<strong>Send Items.</strong>
! P1 K% B% M7 D" F  c: i<form name='select' method='post'>
9 z2 H6 ]5 l& ?& H/ O<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
/ t+ |2 r" ]+ ~: i( X9 \' m! d<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
) f0 g' I$ q6 P5 G( Z& F<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
1 A  A* t9 @! o  R<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
3 U' f- Z2 V/ m/ N<input type='text' name='item_upgrade'/><br/>
/ K' f& }) u+ U7 V1 Q: G3 y<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

2 }- F4 r" r; w) {- P</lable><br/>
. F- v/ `# L) j% G7 ?9 Y7 a<input type='text' name='item_element'/><br/>
, y- @2 |6 y% ^: J) E<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
7 j' \: [  B; L0 r<input type='submit'/>
3 t# I1 A: [7 M# m# y</form>";
}

8 U. B4 M7 I3 G0 x2 Zfunction PostListener (){
4 {7 M" |3 x* r2 O! {- }( F4 C//Add more post variables if needed and add them to initform() function aswell

- i7 N/ g2 \' P( w) I6 I################################
##### Connection and Post ######
& N+ ?  \/ R6 z: g################################
$name = @$_POST['char'];
' `0 K2 \; R0 p# V; C, B$ItemName = @$_POST['item_name'];
: u) }4 r' P5 R$ItemAmount = @$_POST['item_amount'];
, S" m0 ]  T& Q$ L$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
% O' S+ w1 |, {7 v# R################################

//Check both variables for empty value

  N2 Z" t2 k$ {* Cif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

  D; C& I8 p9 m" Z8 {m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$ q) Y) |& W* X! j$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

( ^5 L& T7 ~5 d0 S" |[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
3 q" E% p$ b! o( O& V
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

' Z7 M& t9 J. jN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

% ^8 A1 c8 d3 L) e'{$ElementUpgrade}', '{$ItemPierce}');");
  o; C9 `. `* j! K5 b}

7 x. ?6 p6 Y7 ^6 X9 {}

+ b! M( U4 h4 {5 F6 w8 v}

$InitForm = InitForm();
  o1 N& s, V9 H% m' K2 y+ t4 B$Listener = PostListener();

?>


0 D" F7 z/ ?5 L; u8 d; Y( x, G1 D1 [) P
2 Z1 [0 K* R% z9 i! `2 l