物品发送脚本

admin

<?php
+ N7 M9 z0 w3 {8 E* ?0 _" Bfunction Connect () {
$ @  N& r/ V' k5 x% Smssql_connect('Server','UserName','Password') or die('Error: Connection to DB
0 A2 x# k8 z/ U- T+ p8 L1 S4 y
Failed.');
; X/ @7 l7 [5 ~9 k0 _2 q- A}
Connect();

( }4 h! o3 b- z+ o1 Z! Q2 b5 \function InitForm(){
# O4 V* }# C7 V1 g4 A//layout for the form
) D: W; ~: d* wecho "<strong>Send Items.</strong>
<form name='select' method='post'>
1 x$ p; ^6 X2 Q. y$ J: M: F<lable>Character Name</lable><br/>
, ]# _' l# [* ^9 ?7 O; Q<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
9 ~8 z4 V# n, ]0 ]5 T' p0 a<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
% |* E- h6 b- D  B<lable>Item Upgrade Amount</lable><br/>
+ n" ^0 k1 B& v8 J8 I& n! y2 x# X6 o<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
$ Z6 x/ h) x) v' L, H! X
</lable><br/>
3 _8 o. T0 W- l: C<input type='text' name='item_element'/><br/>
: }6 a! W: E9 A<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
0 r, z2 {- o6 @9 p5 K2 @<lable>Pierced Amount</lable><br/>
) _; P. K; t' z4 Z7 v2 d<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

function PostListener (){
' X6 \- z! j0 a1 R; H/ t8 g//Add more post variables if needed and add them to initform() function aswell

' J( E: ~8 k) v* Z; o! M8 r: M################################
* U0 l4 f$ [) @##### Connection and Post ######
9 \8 K/ d7 O' P* h5 b/ Q  y################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
4 s' K: Y6 y# w' _1 I! D$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
* Y- ]9 h9 h+ p5 i$ |# K6 j) j$ItemElement = @$_POST['item_element'];
/ Q, @9 ^! \0 t# X, D0 i$ElementUpgrade = @$_POST['element_upgrade'];
8 W" j) A/ o, u& T$ItemPierce = @$_POST['item_pierce'];
/ c3 Z8 L) {: t# [################################
* l" ]2 w- u& j$ X+ |! `$ @' I) A
7 b2 m; ~: b+ w: x) [' `* j//Check both variables for empty value

if (!empty($_POST['char'])){
5 f! I, U1 j; \- W; E$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
, f+ S4 j& E1 W* ?' X
m_szName = '{$name}'");
) [% E: y! m! [0 L- Z9 K! d  Gwhile ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
, G4 R7 I% F6 a; F) z$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
6 g: p9 b) f! ]" S8 ~
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

6 q/ W2 O( ?2 N" ]$ X) P[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
# ?  _  L2 ~, o+ P2 n4 t
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
; N  ?) B; \4 ~- Y/ q: c
. U% B1 n7 T9 `" g% c'{$ElementUpgrade}', '{$ItemPierce}');");
}

( c* z7 m( {; Q. D# v& F- R}
2 _+ Q( o3 b/ s( @
$ v4 P5 O1 M$ z" F! F. l/ i- m}
$ u, i1 V, {' }' l
. x$ W# d2 u' Z$InitForm = InitForm();
$Listener = PostListener();

?>
  |' Z8 o4 T9 K5 k
2 e& A; O. {3 X- M3 E# t

: m6 y$ M" C1 z2 ]
1 v, p% n! L* |5 V* T. x1 _