物品发送脚本

admin

<?php
1 g0 P' Y  O) {function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
/ `* B0 s! K: @+ n" r
Failed.');
1 R2 P; p( T' s' f9 k; G$ H}
0 m8 n. F& x6 T, w! yConnect();

function InitForm(){
; ~4 M1 [/ z1 o5 T//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
5 t; h( t: o8 S<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
- A* }8 _/ Z/ @) _<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
6 A" l: I% u+ h0 V<lable>Item Upgrade Amount</lable><br/>
: S5 A% L& b# U( w! D3 E; P<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

' f2 c9 ^) J2 s/ f</lable><br/>
4 g& j7 H- W) m' ?2 Z+ R<input type='text' name='item_element'/><br/>
/ n9 t0 v; H! ~) F! n/ m# q<lable>Element Upgrade Amount</lable><br/>
* U6 c$ p8 Y. J5 f- o  _4 f  N<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
6 e6 p9 m& d6 n; i+ p1 o. X% u</form>";
4 i) _2 }5 X$ K1 C' W6 }+ ~' X% y}

: @/ H) m/ E$ S, ^! u1 afunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell
( Y2 J( b# i; h" N9 J2 ~; E
################################
( D6 J) y2 I1 {' p6 J##### Connection and Post ######
) v3 {7 M) L$ P; v" y$ T- e, w################################
$ F0 u1 h1 J" x; k  |$name = @$_POST['char'];
1 ?1 |# X  a7 L$ `/ j# p$ItemName = @$_POST['item_name'];
) ^# O* s% F- s; O" v' h$ r$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
* f9 P, T6 R/ A) w$ItemUpgrade = @$_POST['item_upgrade'];
9 ^: ~7 t' k' R% o% V$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
9 y) x  i/ ^7 f7 f, ]& N' |################################

' d) F0 h& Y) v7 T# B) e+ c8 ?//Check both variables for empty value

. `2 E% `( n: y4 u/ i1 Y" oif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

3 Q  d) S8 J# x  km_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
9 z8 l, X: P" Lecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
4 S. u5 u) E/ x, p& Y+ s
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
% c6 O4 q" l# W7 p# N4 e* N
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
9 D/ G7 F: Y6 d8 Y
% B$ ~( I  E4 O0 CN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

% p6 y, Y; ~9 _+ s  f' E( R0 s) I'{$ElementUpgrade}', '{$ItemPierce}');");
}
# y2 I& T6 h9 j6 j& k: P* O, I$ Q, V
5 n$ C) C, q* f3 H% n+ O8 V}
4 S8 U" x- o  r6 a" i8 b& j
}
6 A; J5 y/ c- r0 ?  ~* L6 i" {
$InitForm = InitForm();
$Listener = PostListener();

! s4 R9 ~$ F* m5 r4 f* J?>

: H$ v4 G$ c0 n' `4 Q+ E" ?9 ?. B8 k, `
: O* K) b/ m. T3 i% g! S! x
6 J& @9 Q: @* V( V7 f, O
, ~9 h+ Z2 V/ P- `4 \$ e