物品发送脚本

admin

<?php
4 |6 S2 o7 D3 d& j; H1 zfunction Connect () {
9 g8 _; M. Z# j' M: |: n! {& d6 cmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
$ Q5 _3 h) ^# e6 p1 [
# e: }) a4 x. u# w' gFailed.');
' ~9 o$ B6 x6 e: p4 M3 n5 j- Y}
Connect();

function InitForm(){
+ y" c8 }9 U. \7 }; z//layout for the form
* ]% y& j1 E: z9 iecho "<strong>Send Items.</strong>
! |, Z# J3 O: [: I8 a. F2 `<form name='select' method='post'>
) T% P; `  ]* v& a# I4 `7 K# y9 N; f<lable>Character Name</lable><br/>
; I! b! e% z/ G<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
8 M1 l( h7 \+ [" X1 a<input type='text' name='item_name'/><br/>
, r) t! R$ w8 u2 i$ T* ^8 o+ \& B<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
- d2 \) w% W# U$ ~! n% ~<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
! O  |4 u4 x( W9 j; |) ^( Q: m
</lable><br/>
<input type='text' name='item_element'/><br/>
* R% h1 a* c5 ^, s: x" ^9 H! [7 T$ h# V<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
9 C2 _* F# F/ y/ E3 Z! Y" R1 S<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
' j: b! X) Q( O9 W! W5 N<input type='submit'/>
8 q# L6 W7 r) _1 \# `</form>";
}

4 C$ e2 S4 V7 z2 Lfunction PostListener (){
5 b& c' s: i. x! n" P//Add more post variables if needed and add them to initform() function aswell
# g& m9 n1 u! M
################################
##### Connection and Post ######
################################
$name = @$_POST['char'];
. U* t2 x9 W. A: j, E. M, m$ a5 o$ItemName = @$_POST['item_name'];
5 k7 G- X6 c2 e2 `5 @1 E$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
1 U: e% q, w/ `/ X$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
" ^7 ]6 ^$ v  \  Z1 {
//Check both variables for empty value

  W8 s9 q1 v% u& ?: d# Hif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
% Z: |0 n  y3 U( Z. t6 @3 Cwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
2 J' j& a; t8 U4 a2 }- p! }$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

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

" R  m# f! p+ ~% w1 ^; N  }8 m[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

+ G" ?1 b( ~0 [  _# kN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
: w  `9 Y* H; v  X
  D# W( ]3 T. ^/ D1 i* v% x/ {8 P'{$ElementUpgrade}', '{$ItemPierce}');");
8 ]& v. U7 S6 ~; `8 U}
5 k6 ?4 A; `6 u& A, h2 k
}

}

- ^4 y4 _/ i& t/ [$InitForm = InitForm();
# P- V7 D, Q7 I# K; m$Listener = PostListener();

?>

1 X# h% n7 L# {1 V' I$ g

& e9 s9 a( T2 p& O
, b# U9 _: [( N5 b