物品发送脚本

admin

<?php
function Connect () {
4 {3 f1 c9 }& f" H0 L, c7 ?mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
) J( ~; p  B( X1 I6 L/ i
Failed.');
}
Connect();
, p: w5 a  e" b2 L" N( [5 h
) v) L# [; p  a$ N9 v% K  I- Ffunction InitForm(){
//layout for the form
' e+ D: f4 @* e# g( \+ Cecho "<strong>Send Items.</strong>
! @& l4 r5 f+ H9 `" m<form name='select' method='post'>
2 L) X, }2 J' P+ }) o. [, R" l<lable>Character Name</lable><br/>
% c' V- m* }" I$ _<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
  o+ H! x0 l0 i5 U<input type='text' name='item_name'/><br/>
: P4 m; U- q- h. P. o% ?<lable>Item Amount</lable><br/>
<input type='text' name='item_amount'/><br/>
( A8 I  C: U. q; Q! P<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
$ t! l' e) E# ^: P- r% R' {<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
<input type='text' name='item_element'/><br/>
; p" r2 Q6 s* |( A9 n8 k3 s) C& j<lable>Element Upgrade Amount</lable><br/>
; c2 T: f* ^: P8 X! \<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
' H+ C/ ?. Q% p- P}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
! K  G% ]& e2 }1 C  D. h* e
################################
##### Connection and Post ######
- s. u' E5 |7 N/ _' y( c, @################################
$name = @$_POST['char'];
* e4 H% K4 v% ~2 Y$ItemName = @$_POST['item_name'];
# g# w% `5 i. q$ItemAmount = @$_POST['item_amount'];
3 |- I. J% L: l% d% n9 j. t* H! L. P$ItemId = @$_POST['item_id'];
1 G; z7 Z, B; `" @$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
* }) Y; b. N' e4 }4 S$ElementUpgrade = @$_POST['element_upgrade'];
4 F0 ~6 D' W2 [; N0 d$ItemPierce = @$_POST['item_pierce'];
! {3 t7 S0 X; Q################################

//Check both variables for empty value

if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
; g: Y7 T2 F  ^5 u# u
8 h4 @, W* E% e# m+ i$ U1 Vm_szName = '{$name}'");
& {6 D; r% A6 k6 n5 s( hwhile ($row = mssql_fetch_object($find)){
7 H7 X1 U: U  N& Q7 u! w* E' Xecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
- L* O* G( j" j$ V; Z- \. L3 ?$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
9 ]2 ^& W. C; C) }* n
, T( t/ h3 z6 O: f, B* W' l/ g' W[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
+ O6 T  f+ m, S0 F; {
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
% M& a; n; i+ W1 }
3 c+ c! p' L# l" @$ O- |'{$ElementUpgrade}', '{$ItemPierce}');");
. y$ i7 A% K! K" E  w; F4 s}
6 \( l5 M; R/ E6 y$ X" m! e# d
/ c) |! n/ ]: c4 o  t: V}
8 p1 ?, Z" Z) |* C6 a) R
}

$InitForm = InitForm();
; v/ {1 J0 }3 @$Listener = PostListener();
1 E' }: e  g! j1 P& P
?>

. R) a' p4 M) n* ~( l9 r1 N* f* {

  q4 u5 b% R/ K* S3 w2 r2 d9 J
5 A7 ?$ K  p1 t0 ?  O