物品发送脚本

admin

<?php
function Connect () {
( P( j% D7 v( m3 [/ }  {6 Wmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
8 i& |, e1 ^% {) e* M
% b; ~, L7 J  _Failed.');
0 w2 a# X0 m6 K: l}
, k6 ~8 d. N4 J6 Z6 yConnect();
6 }% h& X* [5 z. D7 j9 J. D
function InitForm(){
4 l$ a# j/ `- o2 B+ k' N//layout for the form
, J' W4 p( m6 j2 {/ [# zecho "<strong>Send Items.</strong>
4 ^7 a5 ?* q; g" i<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
' z; t8 x+ y0 ~<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
5 b9 \" X* [7 a+ O- q4 Z' }5 A<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
* \0 {4 j# r% G) H# T<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
5 |1 J1 Z5 r& e  B) p1 ^<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
) Y: }! v/ `( Y1 }8 `4 o
</lable><br/>
5 p- A6 r. m8 _0 H<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
6 F  J  t. j# W- @) a<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
6 f" H# \  R& B% ]- x# [/ \<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}
% x- Z' O7 p) E2 L9 D" _6 A8 |# D
" M3 u( h2 y: n. J% l& ^2 z9 n0 p( cfunction PostListener (){
: n& f8 _2 }/ o% ~4 f% x6 v% y9 `: i//Add more post variables if needed and add them to initform() function aswell

- ?4 |. Z  K% }4 N3 y################################
( j' {% b  G) {: Q##### Connection and Post ######
8 _8 v) G# t" A* i& f& S################################
/ F% x" J3 ^0 B) a: j! O: |& j0 J$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
* S- C( B- I1 ^0 _$ m& W, Z$ItemAmount = @$_POST['item_amount'];
/ {0 K, t5 {# h" i2 P' @9 [$ f$ItemId = @$_POST['item_id'];
* P5 x, v. f+ r1 O( F$ItemUpgrade = @$_POST['item_upgrade'];
& p; p7 |6 o. ^$ItemElement = @$_POST['item_element'];
9 z% [$ d; R1 @2 K6 F4 q! f$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
; R+ |/ \) `* p. ^+ Z; a################################
5 o1 n: e* G' E" u) P
//Check both variables for empty value
0 p! V2 {. W: F; p9 h. b: l
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
8 _6 A4 U, R5 R2 A; U: E
m_szName = '{$name}'");
" X" q* G" g# \6 F/ xwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

! w) K! A" B& M( C[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
& R  v! d: E' ~% D
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
) {3 M- H( e1 ]8 y
- |4 ]- M7 s+ `/ y'{$ElementUpgrade}', '{$ItemPierce}');");
0 \1 d- b( U+ t4 K' S}
8 ]5 v: b" K$ j  V: T
+ w4 @+ o. Z1 d: b; q( `}
. d0 s& ~! I1 `
}

$InitForm = InitForm();
! P. r$ G  {8 C) ~! s3 e7 E2 ?; I$Listener = PostListener();

! S9 ~, r8 w9 `* H?>
7 v, R4 ~+ |& n# l# d
/ R1 F! w8 N9 g$ i1 x

) x( E: c) h' @# l1 K5 [/ o