物品发送脚本

admin

<?php
$ J/ W& a, [' H: m+ F+ m4 kfunction Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB

2 H, A( w9 u( G! O2 jFailed.');
}
Connect();

5 s  i$ p- E$ \! H+ c# j: qfunction InitForm(){
: L. Y2 F! m- T//layout for the form
echo "<strong>Send Items.</strong>
( P; y8 D- C: o4 h! A<form name='select' method='post'>
<lable>Character Name</lable><br/>
  L8 W; l" O) r3 L<input type='text' name='char'/><br/>
' S0 p& T/ J* }9 R# P( a! l! S% `<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
6 i) I, e& [6 q7 U<lable>Item Amount</lable><br/>
1 ?% O1 z$ r  u. O5 n+ u<input type='text' name='item_amount'/><br/>
: D9 Y  E: E2 U4 e+ G, _  |<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.)

</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
4 G8 X6 U0 `* L+ c<lable>Pierced Amount</lable><br/>
, q+ ~) O9 F5 R) C; f1 o5 x8 ^% L9 `<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
' I8 F! _- v' l1 ]7 N' @( o}
% ~' ?' s0 m$ c; R6 K% u+ k
! L" q, u( x1 sfunction PostListener (){
6 F- N& H) F% v/ ?/ d//Add more post variables if needed and add them to initform() function aswell

; l2 d& l* h& w/ i################################
##### Connection and Post ######
################################
2 N; g0 G. i, ?$name = @$_POST['char'];
  ~, b6 Q, C( r0 B. s$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
& R4 K0 }3 d/ K# K/ _$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
2 _, f( `8 V6 h; D; c- b$ItemElement = @$_POST['item_element'];
% w) K! f; ]1 @- a$ElementUpgrade = @$_POST['element_upgrade'];
/ [1 |* S+ q6 N+ O; l; d, u) M. C, p- t$ItemPierce = @$_POST['item_pierce'];
################################

//Check both variables for empty value
  l  d/ R2 D" c0 w" N) Q5 T" y
if (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
" q$ Y! Z% e9 k! d& Z8 q1 Twhile ($row = mssql_fetch_object($find)){
( ~1 s0 B% t$ \2 vecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
; Z, {) j  A( |; ?. q6 o* i' h
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
- ~- l% Y4 ^2 j! _' c
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

5 ]3 G3 F1 W# i9 C$ r! w'{$ElementUpgrade}', '{$ItemPierce}');");
}
+ @) `2 u% e2 o$ R8 t3 X9 {
( r: O. V3 _1 h+ j! `9 {, c5 S8 [}
/ z  Y0 i6 O) k( N2 ?0 `
/ ^- i! A  u: {1 k$ h: h0 q; I6 y3 J}
  p  B! @& X9 N& A+ L: n( N
7 _4 H0 `3 Z4 u4 D4 c$InitForm = InitForm();
& O) U9 Q! ]$ ^: C4 \$ B: H  M$Listener = PostListener();
+ b$ W0 r4 t* C$ Q7 K- ]) Z
) X- e& `. P' P4 H# k?>


4 F* P% e: n- P. \' c