物品发送脚本

admin

<?php
function Connect () {
9 A" Q; f* u  O! K) Tmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
6 L, C& Y) h; F% S3 V+ [& e
5 x( U$ j% V; ?- ^' }! O. g) M/ dFailed.');
4 }5 V7 F: b. }}
Connect();
1 w+ D! S! }: {/ @
; B6 k8 o  |7 K% L: F8 r% Sfunction InitForm(){
; j/ V" S8 A7 E/ |( v2 w/ z) d" ]//layout for the form
+ R( O4 i+ h5 G! vecho "<strong>Send Items.</strong>
<form name='select' method='post'>
<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/>
( @2 E" a$ C* g5 Q: [4 H<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
6 P+ A% x4 ?0 z: k<input type='text' name='item_amount'/><br/>
& D$ w& t* `2 Y, y<lable>Item Upgrade Amount</lable><br/>
9 [8 E  J9 z8 _$ d7 H) w<input type='text' name='item_upgrade'/><br/>
$ R/ ]' ^! [: Q; B<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
2 u. N& P8 ]" S+ A3 W
</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
4 U; I& G7 Q! b1 M' D/ Z! X<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
+ j- h0 ~* D$ s" y<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

& I4 y( b7 `! y! ], o! dfunction PostListener (){
//Add more post variables if needed and add them to initform() function aswell
) {2 |3 S- U! ~7 y
! A9 Q0 A' S0 O/ Z% D0 G* w3 b################################
9 \! H" e1 T* O! O##### Connection and Post ######
################################
) u3 I* g1 P. s- X1 o1 p$name = @$_POST['char'];
+ T9 h9 |& e" v3 E7 ~$ItemName = @$_POST['item_name'];
9 M) Z$ }+ M1 b$ItemAmount = @$_POST['item_amount'];
2 k6 G. h/ @" m3 _$ K6 o$ItemId = @$_POST['item_id'];
+ g/ G& v, C7 I$ j# S$ItemUpgrade = @$_POST['item_upgrade'];
: q  N/ I6 Q6 J- a' R  P5 S$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
6 `: U6 o7 E# q( B# Y################################
. y# E  r, ^/ o; C( `0 q
//Check both variables for empty value
! T2 q" m+ @# H* Q1 U% U2 T  h' L; y
# }' g. [: D9 E/ y' _& Jif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
- t# N& o7 q5 y( O
m_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
) c) }! m; N; `! c# R$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

5 G1 |- k& \" ]" t[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],

6 m: u7 p0 M, r8 i0 J0 e[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

. a* {0 y( J( h# y7 n: }$ {N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

  c2 ?  P9 l/ H8 y'{$ElementUpgrade}', '{$ItemPierce}');");
! E! s/ n4 `( R3 e6 N: q4 f# x6 N}

}

}
. g! Y+ x! I# q) |: F; Q# @
! U& h+ \; J. U0 l  P) G$InitForm = InitForm();
" K9 U) {9 U; [. `$ ~% v  M0 b$Listener = PostListener();

?>