物品发送脚本

admin

<?php
- `4 e4 |. X: {+ X# Xfunction Connect () {
1 P; K4 [) s8 z! k  [, H0 tmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
& e/ j2 ~, F& |, S) Z7 WConnect();

function InitForm(){
- F/ p  E8 {8 V- }//layout for the form
echo "<strong>Send Items.</strong>
: H8 r. r/ W5 c' }. p9 B<form name='select' method='post'>
. b( v- f8 j# j+ i0 ?, W<lable>Character Name</lable><br/>
/ ~8 z- Z" a: L<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
$ u7 r7 v- H7 v3 c  B<input type='text' name='item_name'/><br/>
6 D: T$ y# U& E" g<lable>Item Amount</lable><br/>
- C/ j# I  m- m1 y4 w<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
+ ^" f/ C8 H' ]+ b<input type='text' name='item_upgrade'/><br/>
: n- V8 |' A0 X. I- E* V<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
<input type='text' name='item_element'/><br/>
, ?2 D4 o# R' T9 H. f( u<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
" N- V- F' p" H5 X<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
5 R# ]8 P9 |, k: P<input type='submit'/>
' u) C+ p" ?+ V</form>";
6 D2 W7 T* m4 f3 b; A}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
" C2 s% T4 D% E) p$ g+ O( }
################################
##### Connection and Post ######
" e" G+ z& n, {################################
8 y: `' N) i7 R, k" t$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
3 O# G; C# Q, k, i, O; O$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
8 j% W) w1 Z8 C5 n5 y7 {1 h/ j/ k$ B$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
- s5 g$ C4 `6 [; A' {# s7 u################################
! D0 }3 g( y' X
' T/ k( E( `7 q//Check both variables for empty value

if (!empty($_POST['char'])){
) H3 s: A" o" S/ G& {$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

) D% }" k! A# B% i4 I! gm_szName = '{$name}'");
! S! |" m! ~1 Jwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
3 H* j$ k0 x. X, L% L" ~$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
2 I; w( U# m8 n6 f8 x& P4 a
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
  f0 d5 ?& @3 R+ Y3 Y1 s8 c! t# O
1 M( K' A0 f7 y6 f* g- N5 }. K1 f[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
$ {; ?- @! G9 v: D3 k! }4 Z) ]9 x5 A
( s+ H8 h3 I/ c& iN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
5 \  V" ?$ l/ }/ Q" n
! S" |$ F* n" }6 Y'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

" c9 g  n8 W9 X% `) `}
: [: O6 r" M! l- p
4 o1 e/ i4 {5 g$InitForm = InitForm();
; W0 i0 I, M9 i! ~+ l% ~8 H$ v0 V$Listener = PostListener();
+ W) i+ I) `- L
?>



" t7 o- F- q0 [2 V
' A$ \" M# n* c" l7 E