物品发送脚本

admin

<?php
function Connect () {
- H% G, n' [2 amssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
) y5 m* l. Z1 `! H# X$ d+ P8 e}
1 O( @0 r" Z& q+ ~* G1 i5 YConnect();
# ^7 ?. ^% Z. a5 N: r& h
) B% {1 N6 p2 A( w& n  m- r; O! dfunction InitForm(){
//layout for the form
* B4 D6 h% f! q8 }+ C/ mecho "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
4 [$ h8 C- }5 }<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
2 j  m$ u5 J5 {* J  v- B& u7 B9 b<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
( {6 h  F; ?: N1 z<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
" e- z; ~$ D8 r1 [4 z% G( D<input type='text' name='item_element'/><br/>
. L5 f* n# V0 g' J/ b& I# T3 [<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
" ?$ y6 y1 a: @7 i0 s4 P# R2 M<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
7 `5 s/ B2 c" w+ c( Q+ }</form>";
' c- R0 k5 n# _" b8 {% X4 V}

function PostListener (){
3 [9 E. t, d" I" h1 O9 j//Add more post variables if needed and add them to initform() function aswell

2 J* l1 i  K7 v3 B+ e7 A7 Q0 i################################
9 \7 Q* `) l, h( _9 K##### Connection and Post ######
( l+ g; G/ u' L################################
$name = @$_POST['char'];
& U4 J% @; G8 \0 q$ L$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
5 V5 b/ c: s! E! a( R$ItemUpgrade = @$_POST['item_upgrade'];
, H0 g  A* p2 K! H; s: \$ItemElement = @$_POST['item_element'];
( G9 b) A# G' h3 k$ `$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
1 b/ a+ K- Z& M: I7 }  Z################################
' k1 g; A) h: w. L, N+ L5 {! b
2 `; O3 U' L& U5 c& P# g, i//Check both variables for empty value

6 K' Y% _" S' T2 d6 ]  |- a) O( uif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
1 A2 g: Z& v$ H
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
/ \" ~% A, p3 z6 ^' Pecho "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],
, w% S9 r6 b0 e9 h
7 `2 S9 q, h5 e9 X[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
+ w5 A- v0 R$ z% S
5 V9 s5 D' Z% g! UN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

( B% F9 L/ q$ k' ?/ k" V'{$ElementUpgrade}', '{$ItemPierce}');");
}
/ W  K9 J: Y8 o2 X
$ w, X6 |$ b9 m% r5 Z}
$ X$ u- t% T) ^% B! Q1 a
}

4 _8 u: K0 i6 A0 Q$InitForm = InitForm();
6 r& M0 t/ v5 n* Z6 e$Listener = PostListener();

/ Z5 v/ V1 E) v4 q/ X) q?>
2 K: Q+ f. F( w


( n3 z) @4 i# p  r
. W' M3 A/ v# m; V