物品发送脚本

admin

<?php
function Connect () {
; o+ T: A; o, ^' H6 w: l  Fmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
; ]2 E* S- n! U2 M% K
3 B7 x1 }# Q  E/ j  hFailed.');
$ N+ d4 F# d: Y2 B% i3 A1 y# s9 {* T}
/ X7 Y6 F$ b( j1 t% q  V; BConnect();

function InitForm(){
3 e8 W2 M8 M# R' S# X3 O! z//layout for the form
echo "<strong>Send Items.</strong>
( K- g; S- A, W* h3 o4 p<form name='select' method='post'>
0 [( P3 s+ E9 m/ ]" a9 L3 O<lable>Character Name</lable><br/>
; a) C3 s9 `/ V/ g) l<input type='text' name='char'/><br/>
& X' ]" I3 L3 z- f<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
: Y0 [1 s3 T+ T( @8 w<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
7 w9 D6 S, ?1 E8 U6 v<input type='text' name='item_amount'/><br/>
# V: j: Y. G# U) E# r<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
* P& r* |5 R. @0 G% S5 j" r* B) J! S<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

; T7 @: `% V0 D% q- J& U. D8 I% f</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
' N5 @2 }" `1 P3 M1 @# J7 j2 l<lable>Pierced Amount</lable><br/>
! A: u- _6 n5 ^- U/ A7 X1 g<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
9 x# K3 ^, u& C* g& [}

function PostListener (){
$ H' l3 E. K4 G5 a3 B7 M; O3 C9 z//Add more post variables if needed and add them to initform() function aswell
' {5 d. g! ]& V5 `5 C6 \# i. ~
2 s2 T6 U9 M3 a4 N' A1 i4 |. r################################
: x' o: C; k2 z##### Connection and Post ######
0 ?% `7 k  K4 y" g( l2 b# P) l, @2 q################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
! E# U+ M0 T4 n$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
. W; W- m# ]9 x0 J' x9 n6 X; U$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
, v! O0 @- D2 ^6 o" p+ y! w8 S$ElementUpgrade = @$_POST['element_upgrade'];
" D; d; V) e4 v( w7 l$ItemPierce = @$_POST['item_pierce'];
' L+ z6 G  I7 |* [3 i5 a1 v################################

0 m/ R5 y- j" g) m6 n0 F  O- [//Check both variables for empty value

( {. Z- `' E( c  Vif (!empty($_POST['char'])){
0 }2 D" x% ^" _7 P& ~$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, ^$ `, E2 n+ r1 u5 ^1 g; ?$ [5 E
, b+ w  j0 z, H+ u6 gm_szName = '{$name}'");
& \9 b  Z, K- \# Fwhile ($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],

[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
1 q9 n. _1 H( p) |
) i0 H* n$ @8 {: F5 x1 [$ _* K, ][m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
. u% f0 }: R1 X# r}
4 G0 b5 ]4 Q) s
}
+ H7 d3 E* a$ E
}
8 B. @0 M/ v" L. S3 V$ w
# C' K4 n* r- M- |$InitForm = InitForm();
# c% h' P5 B+ ~& Q$Listener = PostListener();

?>


+ o; [! o6 g. a# {( `6 F. c0 J  X8 C
* S, Q3 k% b7 a0 S7 _
4 V" M# F- W* z2 U