物品发送脚本

admin

<?php
function Connect () {
# T5 D' h! |6 qmssql_connect('Server','UserName','Password') or die('Error: Connection to DB

Failed.');
}
, V; Z5 \3 f4 h2 w7 |( yConnect();

; P: H, u' q: G+ n* Z5 q$ J+ d) Efunction InitForm(){
//layout for the form
* a7 Y; c6 N: m7 ^echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
5 M7 ~# d0 _8 Y" o% x- v) b<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
% Z. [* S8 X4 W9 \9 b<lable>Item Amount</lable><br/>
: z/ ~1 F7 ~9 h<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
5 J4 q& _. Y7 i! m& n  S+ @8 `<input type='text' name='item_upgrade'/><br/>
7 w8 z5 @2 }. j  n2 q& q; W<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
, T- M: v) i) I5 H
</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
+ Z# m9 O" X4 M# E) q% x<lable>Pierced Amount</lable><br/>
0 M9 d+ W4 x4 q/ [+ z<input type='text' name='item_pierce'/><br/>
, P; P! H$ E: x8 K( a7 i<input type='submit'/>
</form>";
}
) v* C4 H$ n+ E7 [) `
6 [# f; x- u+ c' wfunction PostListener (){
) k/ |2 Z8 }+ o8 O# F//Add more post variables if needed and add them to initform() function aswell
$ Y# W0 ?6 U# ?- l, K+ W
################################
; I& f1 `+ {* p# \8 L- W: W##### Connection and Post ######
################################
" J' z7 Z5 F9 U$name = @$_POST['char'];
! I7 t  \/ y, u# x* m- Y$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
+ R- k' ?* {* }  Z9 \" E$ItemId = @$_POST['item_id'];
# [* ]5 w: _& m  n" L$ItemUpgrade = @$_POST['item_upgrade'];
) M2 ^: C! T5 B1 V) [' t$ItemElement = @$_POST['item_element'];
* z7 G- i+ V# `, H$ElementUpgrade = @$_POST['element_upgrade'];
0 z) C3 A. i+ y! m5 f- V$ T0 i* B. S$ItemPierce = @$_POST['item_pierce'];
! Q2 a! k% Z, s4 {& R################################
7 Y( k- S0 H, l0 H# [. |# v) J6 `
//Check both variables for empty value
6 M8 u3 D6 T; z
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
5 ~% a5 G% f$ V/ ^9 `' @  zecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
" a, {3 c! f/ ?% z% f5 G% |$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

& b+ ]1 K- i+ M) E( S, D) h4 n[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
' f; v; g  H8 m& F1 ~
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

6 O4 V6 I$ c( w3 z/ KN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& X8 W. K# F- L% f$ `
! n. t: h! _( A. ^: J6 {'{$ElementUpgrade}', '{$ItemPierce}');");
/ X5 |( {! |* M. \0 W4 z/ f2 m}

}
$ W& S7 ]; [2 J6 }
$ i# g# _$ L9 O* r5 _. _}
. f6 v6 S7 w7 W' Y  |* N) P) Y
0 ]- {, x* b3 E/ y. l6 g" e$InitForm = InitForm();
  D4 A( L$ _# M' |* B$Listener = PostListener();

?>


+ q8 I( o/ s, J0 ]

  @" }: r# k" M$ w