物品发送脚本

admin

<?php
- T( P, U. B7 Q7 nfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
* c+ b8 P7 j8 v}
Connect();

: n8 M% D" w( q) E$ Lfunction InitForm(){
" k8 L% ^1 Q: y# Y- k6 `0 h//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
3 q/ a, A" w3 m5 T& n8 \' L<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
9 L6 P) B" \0 A6 d4 G<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
; m" q& g4 k; n* x) t% n; j! x3 |. Z<input type='text' name='item_amount'/><br/>
2 I- W6 v# _( g) W  g' t<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.)

" }$ X& ^. i! N" a' \</lable><br/>
' Y0 m, V8 k( c; n2 k8 D# L  l* ~4 ]; z<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
0 \2 ^8 B& ~$ L+ l6 j% c6 m* B3 n<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
5 T- L6 B) P1 J4 L+ v8 b</form>";
# e/ P8 J/ _/ y. a6 E}
" v: C/ w3 v* N% z1 Q/ J
; E9 F, g# G+ C* x  |function PostListener (){
# L4 C3 g  u; [/ ]; I, d  U//Add more post variables if needed and add them to initform() function aswell
$ Q& S# z! o7 c/ G- x
################################
5 Y+ P3 ^" u9 R: t##### Connection and Post ######
3 [9 P+ w0 G) f+ @0 }/ F################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
! R$ d7 |% J5 T+ J6 ~$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
7 C% w! k/ S8 L) E- g3 i# S$ItemElement = @$_POST['item_element'];
" o* s" k0 O8 i5 r. K" W3 f5 c+ z8 W$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
################################
; q  z3 I8 D$ |. ^" E
+ o1 R7 X2 s3 c( p% b: u//Check both variables for empty value
% G6 q# j; v4 w7 X
8 d; q4 M7 z2 A5 m+ I- D9 qif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

6 U, w& _- `9 U! ?' c. |' om_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
* V2 e5 H! n8 C$ P% y6 necho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
1 U  p/ m7 P4 v: z
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

# J( w, D2 k3 g[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
- G; W9 e$ X! U5 m9 V+ U) s
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

* g7 T0 m* N6 L9 v( K3 U% u% H5 O'{$ElementUpgrade}', '{$ItemPierce}');");
}
- y& L* _" p# k) Z7 Y: [
}

}

$InitForm = InitForm();
$Listener = PostListener();

9 G4 F9 J  E. u; D' w, w?>
9 ^. A% h( {' g0 ]. G



; ]( f9 R. w! Z4 |8 }4 M( c9 s6 ^0 W